MICROSOFT EXCEL – INTERMEDIATE

AED 1,800.00AED 2,300.00

Available!

  • Price: 1800  AED
  • Duration: 16 Hours
  • Timings: Flexible
Compare
Enquire Now

 

 

 

 

 

Additional information:

  • 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

     

Reviews

There are no reviews yet.

Be the first to review “MICROSOFT EXCEL – INTERMEDIATE”

Your email address will not be published. Required fields are marked *

Vendor Information

  • Address:
  • No ratings found yet!

Shop By Services

Emotions

FREE
VIEW