Microsoft Excel (Intermediate To Advanced Level)

Microsoft Excel provides you with the relevant tools to transform data into formatted and meaningful information. It also allows you to generate great business reports, graphs and charts for business analysis and presentation.

It is an essential tool for today’s business. If you already have the basics of Microsoft Excel, this course will help bring you to the next level for greater efficiency and productivity.

Learning Outcomes:

• Outlining And Managing Group Data Effectively.
• Applying Proper Formula And Function.
• Troubleshooting Errors.
• Working With Pivot Tables
• Using Vlookup For Data Handling
• Creating And Using Shared Workbooks
• Creating Advanced Workbooks And Worksheets, Including Advanced Formulas, Tables And Data-Analyzing Tools.

Focusing On:

• Module 1 : Calculating With Formulas
• Module 2 : Conditional Formatting
• Module 3 : Vlookup
• Module 4 : Charts
• Module 5 : Logical Functions
• Module 6 : Pivot Tables
• Module 7 : Data Validation
• Module 8 : Working With Data From Multiple
• Worksheets & Workbooks
• Module 9 : Text Function
• Module 10 : Passwords & Security