Name: Excel inventory dashboard tutorial
Uploaded: 2024-04-07T15:19:45.321Z
Duration: 8 min 6 s
Description: Learn how to use Excel to create an inventory dashboard using pivot tables, slicers, icons, shapes, pie charts.

Learn how to use Excel to create an inventory dashboard using pivot tables, slicers, icons, shapes, pie 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 inventory dashboard tutorial

eceedcf3-ac5a:37756;isclassifiedstrendingsuggestionsenableddt:42136;316f64c0-2415:46048;b2454379-d6cf:44572;47b8410f-afc8:46160;31885555-099a:47313;9979286f-d859:47315;jgfi9803:61686;ei83g319:53872;596id705:58363;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;dgigc739:92611;15gbg809:92228;3cf2h499:95552;90ahj157:94513;3d835968:100010;gg41j822:94817;3i5dg498:97157;437bb176:97771;06ieg414:100430;9ab7j510:99496;86afb588:101093;bfb37872:105751;7f8gg909:114000;eh7a9388:114646;

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.

Nicole H.