Course Details

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 ScalesWorking 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