Advance Excel Training in Lucknow

In today fast-paced business climate, it is vital that decisions are made quickly and accurately. This course will help you improve your existing skill sets, and teach you Excel techniques to build sophisticated spreadsheets and better ways of overcoming Excel related problems.
Learning this powerful business software will set you apart from your co-workers and make you more valuable in the job market.
Advanced Excel Training Course Content

1 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.)
2 Working on Objects:
Inserting Objects
Inserting different files into Excel (like .doc, .pdf, .txt files)
Hyper linking to different sheets
Providing screen tips in hyper link
Hyperlink to send emails
Inserting symbols
Sending working file to an email
3 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
Data Validation:
Use Data Validation in Excel
Using Input Message in Data validation
Using error message in Data Validation
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
Conditional Formatting:
Use of conditional formatting
Custom formatting
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
4 Advanced Functions:
V-Lookup
H-Lookup
IF
ISERROR
Index Match
Rows
Columns
Match
Offset
Get Pivot Data
Date and Time Functions
Text Functions
Operators
Mathematical functions
Calculation options
Name Manager:
Define a name to a range
Use of name manager
Using formulas in name manager
Editing name range
5 Data Connection from External Data:
From access
From SQL
From Web
From ODBC
6 Customize your Excel view:
Customize Excel view
Developer Option
Trust Centre
Add-Ins
Save directory options
Language Setting
Quick access toolbar
7 Security options in excel:
Protecting the worksheet
Protecting the workbooks
Sharing the workbook
Allow users to edit ranges
ADVANCED FUNCTIONS
Logical (ANd, IF, Or)
Text ( Clean, Concatenate, Exact, Len, Lower, Proper, Replace, Substitute, Trim, Upper)
Date & Time(Now, Today)
Lookup & Reference (Vlookup, Hlookup, Transpose, Rows, Columns)
Math & Trig(Ceiling, Even Odd, Fact, Floor, Gcd, Int, Lcm, Mod, Product, Sum, Quotient, Roman, Round etc.

Become an Expert and learn to use Excel like a professional with our Advanced Excel Training.

Call Now: 8188800505