Video

Is This Microsoft Excel?! Financial Statistics Dashboards System | Tutorial 1

Published

on



https://other-levels.com/products/one-time-full-access
๐ŸŒ ๐Ÿ… The #1 Website Worldwide for Excel Dashboard Templates, Reports, and Professional Analysis Tools.
๐ŸŽ–๏ธ ๐Ÿ† Other Levels YouTube Channel โ€” The #1 Authority for Excel Dashboards on YouTube, with over 24 million views and a global impact.

๐Ÿ’ผ Other Levels Services
* Custom Excel Dashboard Service https://other-levels.com/products/custom-excel-dashboard-service
* Enhance Your Templates Service https://other-levels.com/products/enhance-your-templates-service

๐ŸŽ“ Master Excel Dashboards
Join over 100,000 learners in our top-rated online course and gain the skills to create professional Excel dashboards from scratch.
๐Ÿ‘‰ Enroll today: https://other-levels.com/products/master-microsoft-excel-dashboards-online-course

To watch the full Tutorials? Join our channel Membership https://www.youtube.com/channel/UCuDF09RGFE3V3lY77Z_cA9g/join

Advertisement

๐ŸŽ“ Free Excel Courses On YouTube:
Single Dynamic Excel Dashboard https://www.youtube.com/playlist?list=PLxuBYEpUjhDsVA2O1FTayFiYrDfoErdbx
Multiple Dynamic Excel Dashboards https://www.youtube.com/playlist?list=PLxuBYEpUjhDuAfwWMEgnYirso6UXMzPB9

Have a question about this template?
๐Ÿ‘‡๐ŸปComment down below

Letโ€™s connect on social
LinkedIn https://www.linkedin.com/company/other-levels-com
Facebook https://www.facebook.com/Other.levels.Official
Instagram https://www.instagram.com/other.levels
TikTok https://www.tiktok.com/@other.levels

Playlists
Data Analysis By Power Point https://youtube.com/watch
PowerPoint Slides https://youtube.com/watch
CV/Resume Templates https://youtube.com/watch
Organizational Structure Chart https://www.youtube.com/watch
PowerPoint Templates https://youtube.com/watch
PowerPoint Dashboard https://youtube.com/watch
Modern Excel Reports https://youtube.com/watch

Advertisement

โญ๏ธ Is this really Excel?
Yes, and itโ€™s powerful! Discover the Financial Statistics Dashboards Systemโ€”the most-viewed Excel dashboard tutorial on YouTube with over 6 million views, brought to you by Other Levels.

This dynamic Excel dashboard simplifies complex financial data into beautiful, interactive visuals.

Itโ€™s perfect for business owners, analysts, and financial planners who want clear insights into income, sales, marketing ROI, and profits.

๐Ÿš€ Hereโ€™s what youโ€™ll learn in Tutorial 1:
* Dynamic web chart to break down income by source
* Stunning doughnut chart to track goal achievement
* Monthly income line chart and average tracking
* Total income, target values, and performance indicators
* Operating profit breakdown by month
* Compare marketing strategy effectiveness
* All fully dynamic with yearly slicer filtering

Advertisement

Plus, youโ€™ll get:
* Total profits by country via interactive map chart
* Visual sales process diagram with customer flow
* KPIs for project workflows in a stylish, editable layout
* Fully editable in Excel โ€“ no macros or VBA required

๐Ÿ’ฌ Got questions? Drop a comment below and weโ€™ll help you out!
๐Ÿ”” Subscribe for more Excel dashboard magic.

00:00 Is This Microsoft Excel?! Financial Statistics Dashboards System
00:36 Overview of Dashboards other-levels.com
01:04 Income Source Analysis with Web Chart and Doughnut Chart
01:15 Monthly Income Line Chart and Operating Profit Bar Chart
01:32 Yearly Slicer Controls Dashboard Interactivity
01:37 Map Chart for Country-Wise Profit Analysis
01:52 Tax Breakdown and Profit Percentage Doughnut Chart
02:00 Sales Process Status and Stage Funnel Chart
02:21 Sales Target vs Achieved and Refund Rate
02:32 Projects Workflow KPI Dashboard Overview
03:03 Start Dashboard Design with Income Source Sheet
05:02 Add Browser Button and Dashboard Navigation
06:23 Indicate Active Dashboard with Blue Tick
08:21 Copy Header Layout to All Dashboard Sheets
10:02 Create Pivot Table for Income Sources and Amounts
11:22 Design Custom Web Chart with Scatter Bubbles
13:11 Highlight Top Income Source with MAX Formula
14:43 Insert Year Slicer to Test Interactive Chart
16:04 Add Data Labels and Customize Circle Sizes
21:22 Calculate Achieved Percentage vs Target
24:14 Build Monthly Income Line and Area Charts
26:44 Extract Item Quantities and Percentages
27:40 Apply VLOOKUP to Display Detailed Metrics
31:21 Use Symbol Bullets Instead of Shapes
32:20 Display Average Monthly Income
34:42 Add Operating Expenses and Monthly Bar Chart
38:03 Marketing Strategy Profit Analysis B2B B2C
42:23 Build Distinctive Doughnut Chart for Target Progress
44:49 Complete Web Chart Center Design and Highlights
48:51 Breakdown Analysis for Each Income Source
50:42 Use Pivot Tables and VLOOKUP for Source Details
53:27 Duplicate Groups for Clean Layout
56:03 Distribute Source Circles and Final Web Layout
57:33 Finalize Web Chart with Icons and Labels
1:13:10 Finish First Dashboard and Apply Protection
1:14:02 Use Sheet Protection for Slicer and Dashboard

#ExcelDashboard #FinancialDashboard #IncomeTracker #ExcelTutorial #BusinessAnalytics #DataVisualization #OtherLevels #ExcelTips #FinanceTool #MarketingAnalytics

source

Advertisement

Leave a Reply

Your email address will not be published. Required fields are marked *

Trending

Exit mobile version