Course Outline

Day 1: DATA MANAGEMENT AND DATA ENTRY

  • Overview of the Training
  • Understanding the Key Functionalities in Excel
  • Managing the Excel worksheet
  • Formatting the Excel Worksheet
  • Data Entry Techniques in Excel
  • Data Cleansing with Excel

Day 2: SOLVING BUSINESS PROBLEM USING FUNCTION

  • Understanding the concept of using functions and formula
  • Using Mathematical operations for business metrics
  • Manipulating Text in Excel
  • Using Date Functions in Excel

Day 3: DATA ANALYSIS WITH EXCEL

  • Enforcing value using conditional function
  • Using conditional functions to enforce multiple values
  • Using criteria’s to generate value based on conditional analysis
  • Using AND(), OR(), SWITCH(), AND IFS()
  • Using Multiple criteria for Analysis

Day 4: CREATING PAYROLL AND INVOICE WITH REFERENCE FUNCTIONS

  • LOOKUP to show relationship between tables
  • Creating a payroll invoice using VLOOKUP
  • Using Nested LOOKUP
  • INDEX
  • MATCH
  • INDEXMATCH
  • FILTER
  • UNIQUE
  • SEQUENCE

Day 5: BUSINESS REPORTING WITH PIVOT TABLES

  • Cleaning Business Data
  • Data Validation
  • Pivot Tables In-depth
  • What-if Analysis
  • Goal Seeking and Solver

Day 6: DATA VISUALIZATION

  • Getting Started with Charts
  • Using Advanced Charts Techniques
  • Creating Sparkline Charts
  • Custom number formatting in visualization

Day 8: AUTOMATION AND BUILDING APPLICATIONS

  • Introduction to Macro and VBA
  • Creating User form in Excel
  • Creating Excel Add-ins
  • Using User form control in a Workbook

Project

  • Build HR Applications
  • Implement and create Dynamic charts
  • Build a Loan management Application with Excel

Benefits of This Training

  • Learn all the the Key functions in Excel
  • Skills to make you earn remotely and consistently
  • Learn all the Key formatting Techniques in Excel
  • Data Validation in Excel
  • Learn how to Clean Data in Excel
  • Create Dynamic Dashboards in Excel
  • Learn how to analyze data like a Pro
  • Create Stunning Charts and Infographics
  • Build HR application in Excel
  • Build Loan Calculator in Excel
  • Automate Workbook and Worksheet Content
  • Collaborate and work on Projects
  • Access to Bonus files
  • Access to Video Tutorials

Audience

  • Business Professional
  • Data Analyst
  • Business Administrator
  • Business People
  • Students
  • Professionals
  • Bankers
  • SME’s
  • Unemployed

Training Dates

First Batch: 2nd  September- 10th September
Second Batch: 12th September – 19th September

Monday- Friday : 7:00-10:00pm
Saturday: 12:00-4:00pm

Price: ₦10,000

Enroll Now

Once payment is confirmed, you will be booked for the training within 1-12hrs