Interactive Excel Dashboard - Restaurant Management Dashboard скачать в хорошем качестве

Interactive Excel Dashboard - Restaurant Management Dashboard

This is my new shopping mall. https://excellatte.etsy.com Complete version of tool at my Buy-Me-A-Coffee website: https://www.buymeacoffee.com/exceltut... Practice file link (incl. dummy data set): https://www.buymeacoffee.com/exceltut... For a Quick Start, go to 09:31 (Open an Excel File) Keyword: food cost calculator in excel interactive excel dashboard Contents: 00:00 Intro & Motivation 01:38 Demonstration of Tool 09:31 Open an Excel File 11:15 How to Make a List in Cells 12:12 Save a File 12:48 Create a New Sheet (i.e. Inventory) 17:21 Date Picker Add-ins Function 19:00 How to use Pivot Table 20:39 Individual Food Cost Calculation 21:53 How to use VLOOKUP Function 25:20 How to Remove Grand Total in Pivot Table 25:58 How to Control Name Box in Excel 30:29 How to Copy & Paste Entire Sheet 33:08 How to calculate Sale Figure (Focus on Sale Figures) 40:51 How to calculate Estimated Sale Figure (per Month) 43:54 How to calculate Labor & Fixed Costs (Estimated Profit) 47:21 How to calculate Estimated Profitability 50:42 Profit Sensitivity Tests 54:47 Visualizing Sensitivity Tests 56:44 How to calculate Slope & Y intercept 1:00:47 How to Decorate Waterfall Chart 1:02:11 Starting implementing Monthly Profitability 1:04:23 How to Hide Excel Sheet 1:14:34 How to Insert Icons in Cells 1:15:27 Make 2 Waterfall Charts 1:16:51 Making Profit Dashboard Base 1:17:19 Make Headline for Profit Dashboard 1:17:53 How to Get Copyright Free Photos 1:19:30 How to Make Dynamic Buttons (Slicers) 1:20:35 How to Make Personalized Buttons (Slicers) 1:22:48 How to Use Linked Pictures 1:27:08 Implementing Sale Dashboard Base 1:29:21 Calculating Total Sale Revenue Trend 1:33:28 Calculating Total Sale Revenue By Menu 1:36:25 How to Make Personalized Buttons (Slicers) 1:37:39 Calculating Average Sale Revenue By Menu 1:40:14 Calculating Average Sale Revenue (%) By Menu 1:41:47 Implementing Estimated Profit Chart 1:44:53 Implementing Auto-Sheet Movement Functions 1:46:48 Adding Photo Visual Effect in Charts 1:50:01 Implementing Auto-Updating Functions