Excel Training for Individuals or Groups

2020-01-07 12:07 pm

Advance Excel Training Syllabus


Introduction to MS Excel and Understanding Basic Working with it

Introduction to MS Excel, Quick Review on MS Excel Options, Ribbon, Worksheets and Toolbar

Difference Between Excel 2003, 2007, 2010 and 2013

Saving Excel File as CSV, Macro Enable Sheet, PDF and Older Versions

Using Excel Shortcuts with Full List of Excel Shortcuts

Copy, Cut, Paste, Hide, Unhide, Delete and Link the Data in Rows, Columns and Sheets

Using Paste Special Options

Formatting Cells, Rows, Columns and Sheets

Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password

Page Layout, Themes, Background and Printer Properties

Inserting Pictures, Hyperlinks, Header/Footers, Shapes and Other Objects in Worksheets

Working with Formulas/Functions

Lookup and Reference Functions

Logical Function

Database Functions

Date and Time Functions

Information Functions

Math and Trigonometry Functions

Statistical Functions

Conditional Formatting

Using Conditional Formatting with advance techniques

Creating New Rules and Managing Existing Rules

Data Sorting and Filtering

Sorting Data by Values, Colors, etc

Using Filters to Sort Data

Advance Filtering Options

Pivot Tables

Creating Pivot Tables

Using Pivot Table Options

Changing and Updating Data Range

Formatting Pivot Table and Making Dynamic Pivot Tables

Pivot Charts

Creating Pivot Charts

Types of Pivot Charts and Their Usage

Formatting Pivot Charts and Making Dynamic Pivot Charts

BI Tools


Duration : 40 Hours

Course Fee : LKR. 10,000.00 (Ten Thousand) each student

individual Classes time and the days can be arranged to your convenient.

Practical session relating Finance, HR, Marketing, Administration, Corporates with Multinational company scenarios.

Corporate trainer for multinational companies in Executive and Manager Categories.

Contact Seller

- 0777550479

- 0777550479