MICROSOFT EXCEL – INTERMEDIATE

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