Sale Date Ended
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