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.
SUM,COUNT, COUNTA, COUNTBLANK, AVERAGE, MAX, LARGE MIN, ABS, SUMIF, COUNTIF, SUMIFS, COUNTIFS, LOWER, UPPER, PROPER, TRIM, LEN, LEFT, RIGHT, MID, CONCATENATE, SUBTOTAL,AND, OR, DAY, YEAR, EOMONTH, EDATE, NETWORKDAYS, TODAY, WEEKDAY, WEEKNUMBER, WORKDAY, FIND,SEARCH, VLOOKUP, HLOOKUP, MATCH, IFERROR, IFNA, IF, INDEX, OFFSET
Filters (Basic, Advanced , Conditional), Sort ( Ascending, Descending, Cell/ Font Colour), Single and Multiple Charts/Graphs, Conditional Formatting, Data validation, Group & ungroup, Data split.
Pivot Table and Chart, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display
DASHBOARD & VBA,Dashboard reports allow user to get high-level overview of the business and help them make quick decisions. Dashboards are often called as management information system (MIS), which provides information that organizations require to manage themselves efficiently and effectively.