Copy of MICROSOFT EXCEL APPLICATION WORKSHOP (INTERMEDIATE LEVEL)

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 skill sets. 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 upskill

Date

Nov 30 2021 - Dec 03 2021

Time

8:00 am - 5:00 pm

Cost

₦140,000

Location

Ikeja - Lagos Training Center
Ostra Hall and Hotel, Opposite NNPC Gas Station, CBD, Alausa, Ikeja - Lagos.
Duration

Event registration