In this tutorial, we will learn about How to make a Dynamic Excel Dashboard using Raw SALES Data Step-by-step.
Check out our 23 hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
We covered the following topics:
00:00 Introduction to Dynamic Dashboard in Excel
00:26 How to create a Sales Dashboard in Excel
03:41 How to create Excel Dashboard
04:03 How to use Data Validation Function in Excel
05:22 How to Insert Symbol in Excel'
07:25 How to use Year Function in Excel
07:31 How to Join Year and TEXT Formula in Excel
08:00 How to use SUMIFS Formula in Excel
08:14 How to use Function Argument in Excel
11:44 How to use SUM Formula in Excel
11:56 How to Calculate Percentage Sales in Excel
13:57 How to use IFERROR Formula in Excel
14:34 How to use CONDITIONAL Formatting in Excel
18:04 Use of INDEX Formula in Excel
19:21 How to use INDEX MATCH Formula in Excel
27:32 How to create a Line Chart in Excel
28:17 How to use Format Axis Function in Excel
31:14 How to insert Border in Excel
-------------------------------------------
15 Excel CHARTS in Hindi
• Excel Charts & Graphs ...
Basics of Index + Match formula in Excel
• Basics of Index + Matc...
Intermediate of Index + Match Formula in Excel
• Basic of Index + Match...
Advanced Index + Match formula in Excel
• Index + Match formula ...
MS Excel: SUMIFS formula - NOT for BEGINNERS
• Excel SUMIFS Formula (...
------------------------------------------
Build Dynamic Excel Dashboard [Raw Data to Excel Dashboard]
#dashboard #exceldashboard #dynamicsdashboard
To watch more videos visit: www.excelsuperstar.org/
To Buy an Excel Course visit: www.courses.excelsuperstar.org
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar
14 июл 2024