Microsoft Programmes

Back to courses

Microsoft Excel for Business Analysis Online Workshop

Course Description: Microsoft Excel for Business Analysis, you will learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user. This Online Excel program is designed specifically for those who are new to spreadsheet and looking to perform a professional financial analysis using Excel.

Apply Now

---

Learning Outcomes

Upon successful completion of the course unit, the student should be able to perform the following tasks:

• Calculating data using advanced formulas and functions;
• troubleshooting and solving function errors;
• assigning names to cells and ranges;
• formatting values and creating custom number types
• ; enforcing data validation.
• Analyzing and presenting worksheet data using Charts,
• Sparklines, Diagrams, PivotTables, PivotCharts, What-if Analysis,
• Collaborating and importing data into Excel
• Adding worksheet protection

---

Course Content

• Excel Basics
• Work with Cells and Worksheets
• Calculate Your Data
• Format your Workbook
• Add Charts and Graphics
• Collaborate with Others
• Excel Formulas & Functions
• IF /AND/ OR Conditions
• Data Table Tools
• PivotTables
• Flash Fill
• Auto Filter
• Advanced Filter
• Sort using Value, Color, Icon
• Grouping & Subtotal
• Conditional Formatting
• Absolute/Relative Cell Reference
• Data Validation
• Data Management functions
• Advanced Excel Analytics
• Worksheet Protection
• Power Pivots
• Sparkline
• Goal seek