Dear Candidate,
Discover Success with NAS Training Cell & Get an Opportunity to enhance your career we are providing practical training in Advance excel sheet also provide training on MIS Report
Advanced Excel Training focuses upon the basic to advance excel training and also facilitates the candidate to understand the application of excel in their domain area.
ADVANCED EXCEL
Course Contents
CONDITIONAL FORMATTING
PIVOT TABLES & PIVOT REPORTING
CHARTS
- Create a Chart
- Change Chart Type
- Switch Row/Column
- Chart Title
- Data Labels
- Move or resize a chart
- Show or hide a legend
- Display or hide chart axes or gridlines
- Save a chart as a template
FORMULAE
- 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, Rounddown, Roundup, Sqrt, Subtotal, Sumif, Sumproduct, Average, Autosum)
Other Useful Topics
For more information visit our website:-
https://nassolutions.in/services/professional-training/advanced-excel-training
NAS Training Institute
D-307,Vibhuti Khand,Gomti Nagar
Lucknow. India, 226010
Mobile: +91-9919999638
Email: training@nassolutions.in
