Advanced Microsoft Excel Course

You will be able to review a range of tools and choose the right ones for the particular application and produce analyses and diagrams that make your reports and business cases easier to read and more effective. By attending this course, you will learn how to apply data analysis techniques to improve your operational and project based work.

What will I learn?

• Unit 1: Conditional Formatting
• Unit 2: Sorting Data
• Unit 3: Filtering Data
• Unit 4: Filling Data
• Unit 5: PivotTables
• Unit 6: Dynamic table (New feature)
• Unit 7: Charting Techniques
• Unit 8: Creating Charts
• Unit 9: Advance Validation
• Unit 10: Text options
• Unit 11: Macros
• Unit 12: File / Data Security
• Unit 13: Formulas
• Unit 14: Formula Referencing

Target Audience:

This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks.

Students should have already completed Excel 2010 Level 1 course or know how to create and save an excel workbook, enter simple formulas and print and chart data.