Modern Excel - The Essential Skills
A customizable course according to your company’s requirements.
1. Duration
1 day (2 sessions of 3.5 hours each).
2. Objectives
The course aims to make an Excel user benefit from the inbuilt capabilities of Excel, rather than using it as a mere electronic spreadsheet application for TYPING reports.
-
The course starts from the foundations of TYPES and SOURCES of data as accepted by a cell in Excel. The focus is on inbuilt calculations and formatting capabilities.
-
The course delves into the concept of Absolute and Relative Reference while calculating numbers and handling non-numeric data via formulas and functions.
-
It covers all aspects of working with Cell, Range, Worksheet, and workbook. The course introduces the power of PIVOT TABLES, and IF and VLOOKUP functions.
-
The course is totally hands-on. No theory! No PowerPoint presentation. Throughout the course you practice the skills on Excel. The exercises are based on real life data scenarios.
3. Pre-requisite
You must have worked on Excel for at least 3 months.