Name: Excel dashboard tutorial part 1
Uploaded: 2024-04-03T11:52:00.703Z
Duration: 9 min 41 s
Description: Learn how to add slicers, icons, shapes and pivots to this dashboard. Part two goes more into the data bars and bar charts.

Learn how to add slicers, icons, shapes and pivots to this dashboard. Part two goes  more into the data bars and bar charts.

Microsoft Excel

I'm a Microsoft MVP, the Chief Operating Officer at OnTheClock, an employee time tracking software, with an MBA from Macquarie University and have an extensive background in analyzing and solving problems. 

I've worked in automotive, biotech, pharmaceuticals, luxury consumer goods and now SaaS. Let me show you how to incorporate Excel into your work to make it easier and actionable. 

Excel dashboard tutorial part 1

2bf2255c-05e8:37755;isclassifiedstrendingsuggestionsenableddt:42136;316f64c0-2415:46048;b2454379-d6cf:44572;47b8410f-afc8:46160;31885555-099a:47313;9979286f-d859:47315;ei83g319:53872;47h3f766:58362;fg008402:58376;i6jj6667:86739;istutorredesignv2_1:73124;a5gbd220:61179;blogpwt:71359;5db3b892:67466;2a2j8400:70238;b534g232:70741;j91hb444:69773;18h21436:69961;85h98405:81245;0eie7335:76839;cia78296:75037;9b4gd804:78753;deisn977:110326;1d789912:110325;slcardst:87990;searchranking_newpqs:91321;b1ff5649:88417;d9c7i206:87231;ajgj0920:88926;a1d06430:92612;15gbg809:92228;3cf2h499:95552;90ahj157:94513;3d835968:100010;gg41j822:94817;3i5dg498:97157;05c5i927:97770;241d3193:100431;9ab7j510:99496;a0ge6769:101092;bfb37872:105751;7f8gg909:114000;e36bg556:114647;

Beginner

Intermediate

Advanced

Chief Operating Officer

I take complex frameworks, formulas and concepts and simplify them to apply to real-life business cases to solve problems. 

I have about 300k followers learning Excel and Sheets tips and tricks on various social platforms.

Editor and Founder

English

Quick, concise lessons in manageable chunks to make it easy to learn.

Learn how to create progress bars that change color based on value you set for things like sales and satisfaction comparison.

Excel color changing status

Learn how to create this circular bullet chart to show something like satisfaction or service level in Excel.

Excel circular bullet chart tutorial

Learn how to create a slightly more advanced bar chart than the default.

Excel advanced bar chart tutorial

Learn how to use all kinds of Excel charts from icon, donut, butterfly to bar and treemaps to create a dashboard.

Excel dashboard using a combination of charts

Learn how to use slicers to control your various charts creating a nice dashboard.

Excel interactive dashboard tutorial

Custom Excel Bar Chart Tutorial

Learn how to make an Excel McKinsey Chart or chart within cells.

Excel McKinsey Chart or Chart Within Cells

Learn how to use check boxes in Excel to create a tool to track project progress.

Excel project tracking tool

Learn how to use Excel to create an inventory dashboard using pivot tables, slicers, icons, shapes, pie charts.

Nicole H.

Excel dashboard tutorial part 1

Nicole's Microsoft Excel videos

Excel color changing status

Excel circular bullet chart tutorial

Excel advanced bar chart tutorial

Excel dashboard using a combination of charts

Excel interactive dashboard tutorial

Custom Excel Bar Chart Tutorial

Excel McKinsey Chart or Chart Within Cells

Excel project tracking tool

Excel inventory dashboard tutorial

Excel dashboard with pivot charts, bar charts and slicers

Multi stage progress bar in Excel

Excel Gantt Chart Tutorial

Teacher Reviews

Book online lesson

MAX and MAXIFS Functions in Microsoft Excel

LARGE and MAX Functions in Microsoft Excel

How to Define and Name Cells and Ranges in Microsoft Excel

Best Shortcut to Take Sum in Microsoft Excel

Basic Difference Between Formula and Expression in Microsoft Excel

Excel color changing status

Excel circular bullet chart tutorial

Best Shortcut to Take Sum in Microsoft Excel

Basic Difference Between Formula and Expression in Microsoft Excel

How to Insert Emojis in Microsoft Excel

Related Subjects