ADVANCE EXCEL TRAINING CONTENT
Module 1: Conditional Formatting
a) Excel Conditional Formatting Options
b) Simple Conditional Formatting
c) Highlight Cells Rules
d) Clear Rules
e) Top/Bottom Rules
f) Color Cells Based on Cell Value
g) Find Duplicate Data in Excel with Conditional Formatting
Module 2: Pivot Tables & Pivot Reporting
a) Report Filter
b) Column Labels
c) Row Labels
d) Summation values
e) Change Summary Calculation
f) Update (refresh) data in a PivotTable
Module 3: Charts
a) Create a Chart
b) Change Chart Type
c) Switch Row/Column
d) Chart Title
e) Data Labels
f) Move or resize a chart
g) Show or hide a legend
h) Display or hide chart axes or gridlines
i) Save a chart as a template
Module 4: Formulas
a) Logical (And, IF, or).
b) Text (Clean, Concatenate, Exact, Len, Lower, Proper, Replace, Substitute, Trim, Upper).
c) Date & Time (Now, Today).
d) Lookup & Reference (Vlookup, Hookup, Transpose, Rows, Columns).
e) Math & Trig(Ceiling, Even Odd, Fact, Floor, Gcd, Int, Lcm, Mod, Product, Sum, Quotient, Roman, Round, Rundown, Roundup, Sqrt, Subtotal, Sum if, Sum product, Average, Auto sum)
Module 5: Other Useful Topics
a) Handling Formula Errors
b) Data Validation
c) Data Consolidation
d) AutoFill
e) Naming Ranges and Cells
f) Cell referencing
g) Sheet Protection
h) Freeze and Split Panes
For more Details Visit our website:-
https://nassolutions.in/services/professional-training/advanced-excel-training/
Contact:- 9919999638
NAS Solutions
D-307,Vibhuti Khand,Gomti Nagar
Lucknow-226010(UP)
Landmark:- Opposite Urdu Academy,Near Madhurima Hotel
