|
|
Download All Course Resources
|
|
|
|
Excel Interface and Download Resources
|
Navigation and Selection Keyboard Shortcuts
|
|
|
Mathematical Functions in Excel
|
Logical Functions in Excel
|
|
|
|
|
Data Formatting and Number Formats in Excel
|
Database Functions and Subtotal in Excel
|
Relative, Absolute and Mixed Referencing in Excel
|
|
|
|
IF,AND,OR,NOT & Download Resources
|
|
|
|
|
|
|
|
Remove Errors and Blanks & Download Resources
|
|
|
Dividing Data from Single Column
|
|
|
|
|
|
|
|
|
|
Introduction to Excel Charts. Pie Chart & Download Resources
|
|
|
|
|
Column chart to compare fields
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Creating and Using Named ranges & Download Resources
|
|
VLOOK UP to Search for a Value in Column & Download Resources
|
|
|
INDEX & MATCH for Vertical & Horizontal Look Up
|
HLOOK UP & MATCH to search for a value in the top row
|
XLOOK UP to Search in Range or Array
|
Approximate Match in Look Up Functions
|
|
|
|
Encrypting File with Password & Download Resources
|
Protecting Worksheet & Allow Edit Ranges
|
|
|
|
|
|
Sorting and Custom Sort & Download Resources
|
Filtering Data and Using Advanced Filters for complex criteria
|
|
|
|
Conditional Formatting using Icons ,Data Bars & Download Resources
|
Conditional Formatting using Rules
|
Conditional Formatting Using Formula
|
|
|
|
|
|
Learning Pivot Tables & Download Resources
|
Value Field Settings in Pivot Tables
|
|
|
|
|
|
Introduction to Data Model & Download Resources
|
Creating a Data Model in Power Pivot
|
Creating Pivot Tables & Pivots Charts from Data Model
|
|
|
|
Dashboard Introduction, Data Import & Download Resources
|
Append, Data Profiling , Remove Blanks & Errors in Power Query
|
Remove Duplicates & Split
|
Format & Extract in Power Query
|
Add Columns in Power Query
|
Merge and Joins in Power Query
|
Fuzzy Merge, Cross Join, Pivot, Unpivot & Group by
|
Loading Data from Power Query
|
Power Pivot And Add To Data Model
|
Creating Calendar Table, Relationships & Hierarchy
|
Key Points about Dashboard
|
Objectives, Audience and Layout of Business Dashboard
|
(KPI) Key Performance Indicators
|
Column Charts for Business Dashboard
|
Channel Sales, Cost & Gross Profit using Pie Charts
|
Line Chart and Bar Chart for Business Dashboard
|
Pivot Tables for Business Dashboard
|
Slicers for Business Dashboard
|
Findings and Navigation for Business Dashboard
|
|
|
|
Objectives and KPIs of Revenue & Cost Dashboard
|
Map Visual & Column Chart
|
|
|
Pivot Table & Bar Chart for Revenue & Cost Dashboard
|
Visuals Should Not Change Shape or Size with Cells
|
Slicers for Revenue and Cost Dashboard
|
Key Analytical Findings and Observations
|
Design Adjustment and Navigation
|
|
Objectives, Audience, Layout and KPIs of Expenses Dashboard
|
Pareto Chart and Column Chart for Expenses Dashboard
|
Pivot Tables for Expenses Dashboard
|
Slicers, Findings and Navigation for Expenses Dashboard
|
View Settings and Protection for Dashboards
|
|
|
|
Goal Seek - What-If Analysis & Download Resources
|
Scenario - What-If Analysis
|
|
|
|
|
|
Recording, Running Macros & Download Resources
|
Understanding Visual Basics Code of Recorded Macros
|
|
|
|
|
|
|
|
Recommended Charts in Excel
|
Column from Examples in Power Query
|
|
|
|
Copilot to Sort, Filter, Highlight Data in Excel & Download Resources
|
Generate formulas in Excel with Copilot
|
Text Insights using Copilot
|
Data Insights using Copilot
|
Data Visualization with Copilot in Excel
|
|
|
|