CertifiedWe believe in "learn by doing". We won't teach you but we will make you practice during the session so that you understand the practical implementation and use the learnings in your work. I guarantee you will remember it forever if you learn by practicing method.
Course contents (High level)
Basics to set the foundations right, Workbook, worksheets, working with data, absolute reference, mixed reference etc.
Filters, Advanced filter, sorting, merging, formatting, conditional formatting, data validation, text to column, list, group ungroup, calculations, setting up rules, protect workbook.
Formulas and functions: Date & time, text, maths, statistical functions, lookup and reference, match, index, logical, database, financial etc.
Vlookup, hlookup, IF, Iferror, mid etc.
Pivot table, calculated fields, pivot chart, Slicer.
Visualization: Bar chart, column chart, histogram, scatter plot, area chart, waterfall, pie, donut, line chart, combined etc.
Data Analysis, goal seek, scenario.
VBA & Macros: record new macro, edit macro, assign shortcut key etc.
Assignments and practice session.
View this Course
Certified
You have 
