I want to hire somebody that make a reseach over the internet for some Excel lessons presentations. I want to be respected every request from this job and the presentation to be complete and complex with all the necessary explanations. I also want that the presentation contain images/sliders/graphics that helps viewers understand every lesson.
I want the presentations to contain the following:
I. Excel 2010 interface presentation
1. Data entry. Data types (numeric, text, dates). Repetitive data entry (series Autofill)
II. The formulas and functions
1.Create and modify a formula. Using mathematical operators in formulas (addition, subtraction, multiplication, division, percentage).
2.Using comparison operators in formulas (>,>=,<,<=.<>).
3.Calculations with values of the same sheet, different sheets and from different spreadsheets (using references of relative cell, absolute, 3D and external).
4.Functions to calculate totals: SUM, SUMIF (assembly according to criteria), SUMIFS (assembly according to several criteria).
5. Counting Functions (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS).
6. Functions to extract the maximum and minimum values (MAX, MIN).
7. IF Function (to create conditional formulas). TODAY Function (display the current date).
8. Copying formulas. Practical applications
1. Sorting data. Simple sorting (after a field) / multiple (over several fields) / Specials.
2. Automatic data filtering (extracting records that meet certain criteria). Simple filtering / custom filtering.
3. Automatic search and replace data (options Find / Replace). Practical applications.
1.Creating, modifying and formatting graphics. Adding and removal data from a graphic. Practical applications.
V. Working with sheets.
1. Insertion, rename, removal, reordering, copying, remove. Lock rows/ columns; display/ hiding rows and columns. Formating sheets. Practical applications.
VI. Printing sheets.
1.Page setup (orientation/ adding header/ footer on the page/ numbering pages). Insertion of a page break. Setting the printing area. Practical applications.
In the final i want to recive 6 PowerPoint presentations that cover the information that i mentioned above.
Please apply ONLY if you can do this job with this budget.