Now loading...

Microsoft Excel

Starting From

Nov 29, 2024

Duration: 6 Weeks
Class Timing: To be mutually decided with Students
Mode Of Training: Online

11,500 PKR

Apply Now
  • Excel basics, including structure and navigation.
  • Entering and editing data, including formulas and functions.
  • Using Pivot Tables to organize and analyze data.
  • A program to a practical approach
  • Online Classes
  • Access to The Upgraded Private Enablers Community
  • Access to Enablers Facebook Public Groups
  • Ability to get Enablers Certificates if passes the assessment
  • FREE Access to Enabling Video Series (EVS v3.0) worth ($160)
Online Via Zoom

Microsoft Excel & Its Benefits

Objective

Learn the basics of creating spreadsheets in Excel. Enter data, formulas, Use Pivot Table and Charts, format and print workbooks.

Target Student

This course is geared for anyone, so you do not need prior experience Learn the basics of creating spreadsheets in Excel. Enter data, formulas, Use Pivot Table and Charts, format and print workbooks.

Pre-requisites

  • Basic Windows, keyboarding and mouse skills
  • Idea of Raw Data
  • Basics of Mathematical functions e.g. Addition, Subtraction, Multiplication, Division

Module Breakdown

Now…here’s something SUPER EXCITING that we have to share with you…

This is a complete overview of the actions you will take while building your business with the Enablers.

  1. Class 1

    Getting Started
    • Basic structure of Excel
    • Cells and Row
    • Opening A Workbook
    • Understanding The Display Screen
    • Working With The Ribbon
    • Navigation – Excel Menu
    • Working With The Quick Access Toolbar
    • Working With The Status Bar
    • Switching Between Opened Workbooks
    • Short Keys

  2. Class 2

    Entering Data
    • Creating/working/saving a New Workbook
    • Advance Excel Formula
    • Editing Worksheets
    • Nomenclature of Cell Address
    • Understanding/Editing/Maneuvering Cells
    • Entering Constant Values
    • Understanding Number Formatting
    • Clearing/Replacing Cell Values
    • Using Auto Fill to Enter Data
    • Working with Undo and Redo

  3. Class 3

    Using Advanced Formulas
    • Substract ,percentage etc
    • Entering Formulas
    • Using Auto Fill with Formulas
    • Using the SUM Function
    • Using Statistical Functions
    • Working with the Range Finder
    • Using Formula Error Checking

  4. Class 4

    Advance techniques for Excel
    • Vloop up
    • Look up Formulas
    • Copying and Pasting Constant Values and Formulas
    • Cutting and Pasting Constant Values and Formulas
    • Using Collect and Paste
    • Preparing Data View

  5. Class 5

    Pivot Table
    • Structuring data for Pivot
    • Creating Pivot Table
    • Creating Pivot Charts
    • Drop down Menu

  6. Class 6

    PRINTING WORKSHEETS/PROJECT
    • Using Print Preview
    • Working with Print Settings
    • Using Page Setup Tools
    • Working in Page Layout View
    • Creating a Header and Footer
    • Using Page Break Preview
    • Printing a Worksheet