Advanced Excel

Number of Hours : 20 Hours

Excel is a Microsoft office application. Microsoft Excel is a spreadsheet program that is used to record and analyse numerical data. From an accountant to a receptionist, human resource to administration department all are using Microsoft Excel. It is not only limited to the large companies, small entrepreneurs and college students are using it for their day to day work.

Prerequisites:

Basic Knowledge of Computers

Courses Objectives:

After the course, you will be able to:

    • All types of Formatting
    • Build Formulas
    • Basic Data Analysis
    • Create Charts
    • Arithmetic Functions – Sum, Product, Average. Insert Row, Column, Copy & Paste Techniques, Formatting, Navigational Techniques, Protect Sheet and workbook
    • SUMPRODUCT, SUMIF & SUMIFS, COUNTIF & COUNTIFS, AVERAGEIF & AVERAGEIFS 2-Case Studies
    • Drop Down Lists, Error Alerts, Conditional Formatting
    • Different kinds of Graphs 1-Case Study
    • DAYS360, TODAY, NOW, NETWORKDAYS, WORKDAY – 1 Case Study
    • IF, AND, OR and NESTED IF 1-Case Study
    • VLOOKUP and HLOOKUP 4-Case Studies
    • INDEX & MATCH Functions
    • Data Analysis using Pivot Tables 2-Case Studies
    • Applying & Using AutoFilter,
    • Creating a Custom AutoFilter,
    • Sorting On More Than One Column
    • Scenarios
    • Goal Seek
    • Solver
    • Using The Mid, Search, Left, Right Functions
    • Using The Trim, Clean, Upper, Lower, Dollar Functions, Substitute
    • Purpose of Macros
    • Recording macros
    • Where to save macros
    • Running macros:
      • Custom buttons, menu items, keyboard shortcuts