what we offer

Advanced Excel Training - 20 Hours

Pace Training Academy provides the Best Advanced Excel Training in Bangalore. The Training is Handled by all the Advanced Excel Professionals and Trainers who are having a very good working experience as well as teaching Experience. Our Advanced Excel Syllabus and the modification made to our syllabus by updating and advancing the Advanced Excel Course Contents.

Pivots and Pivot Graphs

Creating of Pivot Table.
Using Summary function in Pivot Table.
Pivot Table Calculations.
Creating own formulas in Pivots.
Grouping and Ungrouping in Pivot Tables.
Creating Pivot Graph.
Custom Filter on Pivot Table.
Formatting Pivot table (Removing old data, grand total, subtotal â€Ķetc).

Data Management in Excel – Sorting

Rearranging of Data.
Sorting by alphabets, numbers and time.

Filtering Data

Using Auto filter option.
Custom Filtering with different options.
Advanced Filtering.
Find Unique records using advanced filtering.
Filter using operators AND/OR.
Filter by color.

Grouping and Outlining Data

Group and ungroup rows and columns.
Auto outlining the data.
Freezing and Unfreezing.

Removing duplicate records

Remove duplicate records in a spread sheet.
Customize to remove the duplicate values.

Split Texts

Split texts to different columns.
Remove special character from a string and split the string.

Data Consolidation

Combining different spreadsheet using data consolidation.
Using summary function in data consolidation.

Copy Data

Use of format painter.
Use of paste special.
Strike through a value.
Find and Replace.

View Multiple Files

Arrange multiple windows to view in one time.
Split big sheet into sub sheets for better analysis.

Working on Tab

Hide/ Unhide a tab.
Color a tab.
Move /Copy the tab to another sheet/workbook.

Advanced Functions

V-Lookup.
H-Lookup.
IF.
Get Pivot Data.
Date and Time Functions.
Text Functions.
Operators.
Mathematical functions.
Calculation options.

Customize your Excel view

Customize Excel view.
Developer Option.
Trust Centre.
Add-Ins.
Save directory options.
Language Setting.
Quick access toolbar.

Security options in excel

Protecting the worksheet.
Protecting the workbooks.
Sharing the workbook.
Allow users to edit ranges.