This is my new shopping mall.
https://excellatte.etsy.com
Complete version of tool at my BuyMeACoffee 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 Addins 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 AutoSheet Movement Functions
1:46:48 Adding Photo Visual Effect in Charts
1:50:01 Implementing AutoUpdating Functions