Course Outline

Module 1: Introduction to Advanced Excel

• Introduction excel shortcuts
• Understand various excel setting
• Understand the excel layout
• Working With Microsoft Excel Fundamentals and numeric data
• Saving Excel in different formats
• Importing data into Excel

Module 2: Advanced Excel Formulas and Macros

• Work with various advanced Excel data functions
• Learn how to work with arrays and lists
• Work with advanced logical formulas in excel
• Work with advanced text formulas in excel
• Understanding the basics of VBAs and Macros

Module 3: Data Visualization and analysis in Advanced Excel

• Creating and Designing tables
• Working with charts for data presentation
• Work with slicers, sorting and filtering data and understanding the use references
• Data summary and analysis using pivot tables and charts
• Linking several worksheets

• Combining several workbooks to create a summary
• Securing and reviewing your worksheet
• Tracking changes and comments

Module 4: Management and Decision making

• Understand how to Identify, evaluate and manage business capital risk
• Monte Carlo Simulation for Decision making
• Decision Trees for Decision making
• Forecasting
• Learn Payroll Management
• Understand Return of investment

Module 5: The HR dashboard and Analytics for presentation and reports

• Introduction to data index and page layouts
• Work with predictive attrition and animated macro charts
• Understand the Vlookup and Hlookup analysis
• Learn BVG and leave analysis, FNF and Exit Analysis
• Learn how to group data and understand the Bradford Factor
• Learn the HR update and HR Update calendar
• Develop operational dashboards including business KPI’s
• Use pivot tables and pivot charts to efficiently perform automated report writing and analysis