Online Advanced Excel Training

Excel is one of the most commonly used business applications with unlimited capabilities for making your job easier and less stressful.

Our Online Advanced Excel Workshop is a structured and comprehensive learning program developed for Excel users who would want to manage huge sets of data with at most ease in Developing Complex Reports, Dashboards, Better Charts, Nesting Lookups., In one word being Productive with Excel.

 

What you get to Learn in this Power Packed 12 Days Program

Sum, MAX, MIN, Average, Count, Today, Now, Datedif, Error Handling                                       

Countif, CountA, CountBlank, Round, RoundUp, RoundDown, ABS, Sign, Ceiling, Floor, Trim, Value, Clean, Countifs, Sumifs

Conditional Formats, Text to Columns

Using Custom Sort & Advanced Filters

IF, AND, OR

Vlookup, Hlookup

IFError, IFNA, Rank, Match, Index

Validations, Indirect Function

Networkdays, EDate, EoMonth, WorkDay

Consolidation

Using Goal Seek, Data Tables, PMT

Creating/Revising Pivot Tables Using Slicer on Pivot Tables, Presenting Histogram Trends, Grouping Etc

Importing Data (Power Query)

Auditing Tools, Worksheet Protection, Hyper Links, Compare Side by Side, Freeze Panes

Sparklines, Charts(Pie, Exploded Pie, Pie on Pie, Stacked Column Bar, Pareto, Plotting Data on Two Axis, Trend Lines)

Macros - Using, Recording & Editing