MICROSOFT Excel – intermediate 


Price:                                             1800  AED
Duration:                                       16 Hours
Timings:                                         Flexible

Course Overview

  • Introduction
    • Spreadsheets & Its Terminology
    • Understanding Excel Interface
    • Entering & Editing Data
    • Opening, Closing & Saving Workbook
    • Prevent Data Loss in the Event of System Crash
    • Didn’t Save a Workbook? Don’t Worry – Recover Unsaved
    • Workbooks

     

    Basic Formula & Function

    • Difference between a Formula & Function
    • Learning the Core Excel Functions
    • Nesting Functions
    • Understanding Relative, Absolute & Mixed Referencing
    • Defining Names and Using them in Functions

     

    Formatting Techniques

    • Useful Formatting Tools
    • Using Special Number Formatting
    • Applying Predefined Styles & Themes
    • Inserting Pictures, Objects & Smart Art

     

    Working with Dates & Time

    • The Science of Dates & Time in Excel
    • Useful Date & Time Functions

     

    Efficient Handling of Large Data

    • Quick Data Selection Techniques – Use of Ctrl & Shift Keys
    • Quick Data Entry Techniques
    • Using the Fill Handle
    • Accelerating Copy Paste
    • Learning Sorting & Filtering

     

     Analyzing Data with Conditional Formatting

    • Highlighting Cells based on Different Criteria
    • Using the Data Bars, Icon Sets & Color Scales Working with Tables
    • Exploring the Power of Excel Tables
    • Creating Dynamic Ranges with Tables

     

 

  • Working with Charts & Graphs
    • Dos & DONTs of Excel Charting
    • Creating a Chart in no Time!
    • Useful Charting Techniques

     

    Lookup Functions

    • Learning the Powerful IF Function
    • Evaluating Multiple Results with Nested IF
    • Learning the All Important VLOOKUP & Its
    • Limitations
    • Analyzing Data with Criteria – SUMIF Family
    • Functions

     

    Pivot Tables

    • Understanding the Power of Pivot Tables – An
    • Excellent Reporting Tool!
    • How to Create a Pivot Table
    • How to Generate Reports from Pivot Tables
    • Managing & Presenting Pivot Table

     

     Managing Workbook & Worksheet

    • Linking Worksheets & Workbooks
    • Performing Calculations across Worksheets with
    • 3D Formula
    • Creating a Hyperlink

     

    Printing

    • Printing Fundamentals

     

    Security

    • Protecting Workbook with Password
    • Restrict Editing Data – Hiding the Contents of the Cell