
MICROSOFT EXCEL APPLICATION WORKSHOP (INTERMEDIATE LEVEL)
CLASSROOM FEE: ₦140,000 | ONLINE FEE: ₦110,000
SYNOPSIS: In today’s rapidly emerging technology, technical skills can be said to be common place; but the differentiating factor that will separate the high flyers from the low performers lies in the ability of the people to develop and sustain viable and relevant skillsets.
This ability comes with a trained mindset and sets of attitudes that positions the individual at the forefront. This requires a continuous training and retraining program that will equip them to effectively compete in the ever expanding and aggressive business environment.
This course will introduce the participant(s) to basic and intermediate data analysis using Microsoft Excel.
COURSE OBJECTIVES
By the end of the course, the participant will be in a better position to:
- Professionally analyze data and report it in a way that makes sense
- Prepare reports more professionally and efficiently
- Create eye-catching and understandable reports and visualizations
- Automate redundant reporting and office processes
COURSE CONTENT
Customizing the Excel Environment
- Configure Excel Options
- Customize the Ribbon and the Quick Access Toolbar
- Enable Excel Add-Ins
Creating Advanced Formulas
- Use Range Names in Formulas
- Use Specialized Functions
- Use Array Formulas
Analyzing Data with Functions and Conditional Formatting
- Analyze Data by Using Text and Logical Functions
- Apply Advanced Conditional Formatting
Pivot Table
- Creating and configuring a pivot table
- Connecting to an external data source
- Consolidating data from multiple data sources
- Managing pivot tables, subtotals and grand totals
- Manipulating and summarizing data fields
- Sorting pivot table data, creating a custom sort order
Filtering a pivot table field(selection, by rule, search filter, slicers)
Creating a pivot table using the data model
Creating a pivot chart
Filtering and formatting a pivot chart
Changing a pivot chart layout, chart type
Adding a trend line to a pivot table
Setting pivot table chart print options
Creating a simple pivot table presentation kit
Creating relationships between tables
Editing table relationships
- Data Consolidation
- Grouping and ungrouping data
- Subtotals
- Data validation
- Analysis Toolpak
- What-if-Analysis
- Solver
- Scenario Manager
- Data Tables – Sensitivity Analysis with Data Tables
- Goal Seek
Recording and reviewing an Excel Macro
Running an Excel Macro
Protecting worksheets, workbooks
Sharing workbook
Printing worksheets
WHO SHOULD ATTEND?: Office Managers and Administrators, Supervisors, Office Clerks, Secretaries, Accountants, Cashiers and anyone wanting to up skill