Learn Basic and Advance excel tools - Vlookup, Pivot, Sorting, Formatting, Keyboard shortcuts, Use of countif, Countifs, Sumif, Sumifs, Freeze panes, filters.
Easy to make report , graph and statistical presentation, dashboard & power pivot table in Microsoft advanced Excel and live project
Introduction to Excel, Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.
Mathematical Functions:- Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
Date & Time Function:- Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.
Lookup & Reference Functions:- VLookup,
microsoft excel lessons closeby? Here's a selection of teacher ads that you can check out.
|at his home||at your home||By webcam|
|1 hour||$7||Not available||$7|
|5 hours||$36||Not available||$36|
|10 hours||$73||Not available||$73|