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
  1. Solver
  2. Scenario Manager
  3. Data Tables – Sensitivity Analysis with Data Tables
  4. 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