Introduction to Excel
Introduction to Excel 365 | Editing sheet | Formatting | Project1
Worksheet view
Viewing worksheet | Filling series | Flash fill
Conditional formatting | Data validation
Conditional formatting- new rule | Data validation
Lookup and cell reference
FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, RANDARRAY, XMATCH, and XLOOKUP.
Important functions in Excel
Remove duplicate values | Hyperlink | Important functions in excel
Logical operations | sum and count functions
Logical functions | sum | sumif | sumifs | count | countif | countifs
Working with formulas
Statistical functions and mathematical functions | Date related functions
Text functions
Text functions in excel | Match and index functions
Database functions and subtotal functions
Dsum | dcount | Subtotal functions
Classic pivot table and chart
Chart element | Pivot table and pivot chart
Data extraction
Filter and advanced filter
Graphics and insert object function
Custom view | Graphics | Insert object
Print area setup
Header and footer | Print area setup | Text to column function
Important tools in excel
Form data | Auditing tool | Web data
Goal seak | Solver | Scenario manager
Speak cell | Camera tool | Sparkline chart
People graph | Data forecast | Import text file
Mail merge | Consolidating data
Macro | Password protection