Excel Operators, Logical & Text Formulas./ Formula error checking. Excel Sheet Formatting. Date and time functions, Datebase functions like DSUM, Daverage, DCOUNT, DGET.
Relative, Absolute & Mixed Referencing :
Creating Absolute/Mixed References. Problems with Absolute/ Relative Cell Referencing
Look up Functions :
VLOOKUP() - a practical perspective.VLOOKUP()w.TRUE - When & Why ? VLOOKUP() with MATCH() 2-D lookup.INDIRECT() + Range Naming for 3- D lookup INDEX() and 2 MATCH(), XLOOKUP
Pivot Tables, Pivot Charts & Power Pivot :
Creating, Formatting Simple PivotTables, Page Field in a PivotTable. Formatting a PivotTable. Creating / Modifying a PivotChart
Automatic row-wise Subtotal, Gridlines, Data Validation (list), Cell-Range Naming, Grouping. Build Business reports like Sales, Inventory, Salary Report, Dashboards, etc.
Protecting sheets/ workbooks / Files, Importing Data from Text Files / Web
Macro Application :
Developer tab; Record & Run a Macro, Understanding & Editing VBA Code of Macros.
Data Cleaning :
Learn Data Cleaning Techniques.
Data Analysis :
What if Analysis, Forecast.
Basics of Excel, Formatting, Database Functions :
Excel Operators, Logical & Text Formulas./ Formula error checking. Excel Sheet Formatting. Date and time functions, Datebase functions like DSUM, Daverage, DCOUNT, DGET.
Relative, Absolute & Mixed Referencing :
Creating Absolute/Mixed References. Problems with Absolute/ Relative Cell Referencing
Look up Functions :
VLOOKUP() - a practical perspective.VLOOKUP()w.TRUE - When & Why ? VLOOKUP() with MATCH() 2-D lookup.INDIRECT() + Range Naming for 3- D lookup INDEX() and 2 MATCH(), XLOOKUP
Pivot Tables, Pivot Charts & Power Pivot :
Creating, Formatting Simple PivotTables, Page Field in a PivotTable. Formatting a PivotTable. Creating / Modifying a PivotChart
Automatic row-wise Subtotal, Gridlines, Data Validation (list), Cell-Range Naming, Grouping. Build Business reports like Sales, Inventory, Salary Report, Dashboards, etc.
