Microsoft Excel Course | Data Analytics, Visualizations, Concepts with Examples

Description
Microsoft Excel Course | Data Analytics, Visualizations, Concepts with Examples

Course Outline:
01 - Introduction to Excel

02 - Relative & Absolute Cell References
03 - Formatting Paste Special
04 - Excel Tables
05 - Data Filters and Sorting
06 - Data Validation Tips & Tricks
07 - Named Ranges
08 - Worksheet and Workbook Protection
09 - Printing and Page Layout Tab
10 - Handle Formula Errors
11 - Using IF Formula, Nesting IF Formulas
12 - Using IF with AND OR Formulas
13 - COUNTIFS, SUMIFS, AVERAGEIFS Formulas
14 - Excel TEXT Functions
15 - VLOOKUP Function, INDEX, MATCH Function
16 - XLOOKUP, XMATCH Function
17 - Indirect Function
18 - Offset Function
19 - Formula Editing Tips & Tricks
20 - Date and Time Functions
21 - Maths Functions
22 - Dynamic Array Formulas
23 - Conditional Formatting
24 - WHAT IF Analysis
25 - Linear Regression
26 - Data Analysis Feature
27 - Data Storytelling Tips
28 - Introduction to Excel Charts
29 - Dynamic Advanced Charts
30 - Pivot Table with Dashboard
31 - Advanced Pivot Table Tips & Tricks
32 - Top 10 Power Query Tips
33 - Introduction to Power Pivot
34 - Apply DAX in Power Pivot for Analysis
35 - Dashboard Reporting in Excel with Tips
36 - Ageing Analysis Report in Microsoft Excel (VLOOKUP & Pivot Table)
37 - Excel Dashboards in Under 15 Minutes! Awesome Secret Tips & Tricks
38 - How to Split Names and Emails from a List in Microsoft Excel FORMULA FLASH FILL POWER QUERY
39 - NESTED IF, VLOOKUP, XLOOKUP, INDEX+MATCH Risk Rating Criteria in Excel
40 - SUMIFS Function Multiple Criteria Dates Between with Excluding WEEKENDS & HOLIDAYS in Excel
41 - Wildcard Search in Excel
Amazon-Accounting-Ver-0.1
HR - Best Practices Model - V2.0
Income Tax Return Calculator 2021 - Salaried - Business Indv and AOP
KPI VISUALIZATION DASHBOARD - Template
KPI-dashboard
24 Excel Tips in 24 Minutes
15 Excel Functions with Examples