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.