This training will drill down to the overview of Excel tools, basic functions, and tools that are mostly used to operate Excel effectively which would enhance the effectiveness and efficiency.
The training will also demonstrate 3 projects in the form of Human Resources, Sales & Marketing and Finance Dashboard.
Afterwards, it will drill down to advanced functions, reporting & presentation tools.
These 3 Online Sessions of 9 hours of exclusive training covers up to developed skills for an Advanced Level Excel User and are suited for people who use/plan to use Microsoft Excel applications extensively in the workplace to Analyze data, Presentation, and Reporting.
Part One: Overview of Microsoft Excel [45 Minutes]
Part Two: Referencing & Tools [45 Minutes]
Part Three: Create Logical Formulas [1 Hour]
Part Four: Print & Workbook Management [30 Minutes]
Part One: TEXT Function & Number Formats [30 minutes]
Part Two: Excel Statistical Functions for Data Consolidation [1 Hour]
Part Three: Lookup & References [1.5 Hours]
Part One: Data Visualization [1.5 Hours]
Part Two: PivotTable [1.5 Hours]