Excel Home Tab: Clipboard, Font and Alignment Number formatting and Styles Cells and Editing options Tables and Illustrations Charts, Links, Text and Symbols Basic data processing concepts Excel interview questions
Statistical functions: SUM, SUMIF, SUMIFS, AVERAGE, AVERAGEIF, AVERAGEIFS Counting functions: COUNT, COUNTIF, COUNTIFS, COUNTA, COUNTBLANK SMALL, LARGE, MAX and MIN Database functions: DSUM, DMAX, DMIN, DCOUNT, DAVERAGE Lookup functions: VLOOKUP, HLOOKUP and CHOOSE MATCH, INDEX, FORECAST and RANK Formula auditing and calculations
Cell References Advanced Conditional Formatting Advanced Data Validation Get Data and Sorting Excel Data Tools What-If Analysis Goal Seek and Solver Advanced Filtering Stock Maintenance
Filters, Slicers and Timeline Advanced Filter with Macro Advanced VLOOKUP with Data Validation Financial Functions and Depreciation Logical Functions: IF, IF AND, IF OR Error handling in Excel Flash Fill
Excel Dashboard creation Data Entry Forms Visitor Report Invoice preparation Attendance Sheet Practical data-management exercises and reporting skills