Price: AED 1,800

Duration: 16 Hours

Timing: 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

WhatsApp chat