Completed
How to make a Bakers Recipe Costing Calculator in Excel
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Basics - Functions, Formulas, and Practical Applications
Automatically move to the next video in the Classroom when playback concludes
- 1 ADDRESS function in Excel 2018
- 2 COLUMN function in Excel 2018
- 3 COLUMNS function in Excel 2018
- 4 CONCATENATE function in Excel 2018
- 5 COUNT function in Excel 2018
- 6 COUNTA function in Excel 2018
- 7 COUNTBLANK function in Excel 2018
- 8 COUNTIF function in Excel 2018
- 9 INDIRECT function in Excel 2018
- 10 LARGE function in Excel 2018
- 11 ROUND function in Excel 2018
- 12 ROUNDUP function in Excel 2018
- 13 ROUNDDOWN function in Excel 2018
- 14 ROW function in Excel 2018
- 15 ROWS function in Excel 2018
- 16 SMALL function in Excel 2018
- 17 SUBSTITUTE function in Excel 2018
- 18 AVERAGE function in Excel 2018
- 19 SUM function in Excel 2018
- 20 SUMIF function in Excel 2018
- 21 How to use LARGE and VLOOKUP function in Excel
- 22 How to use the LARGE function in Excel
- 23 How to use SMALL and VLOOKUP function in Excel
- 24 How to use the SMALL function in Excel
- 25 How to make a DROPDOWN LIST combine with VLOOKUP with values in different tabs in Excel
- 26 How to make a DROPDOWN LIST combined with VLOOKUP in Excel
- 27 How to make a DROPDOWN LIST in Excel
- 28 How to make a DROPDOWN LIST with source from other tabs in Excel
- 29 How to make a DROPDOWN LIST with source on different tab with pop up error message in Excel
- 30 How to use DROPDOWN LIST, LARGE and VLOOKUP function combined in Excel
- 31 How to use LARGE, DROPDOWN LIST, VLOOKUP and CHOOSE function to make a tiny dashboard component
- 32 How to use CHOOSE with VLOOKUP function to solve common VLOOKUP issue in Excel
- 33 How to use CHOOSE function to structure table data in Excel
- 34 How to use the SUMPRODUCT function in Excel
- 35 How to use the SUM function in Excel
- 36 How to use the AVERAGE function in Excel
- 37 How to calculate the WEIGHTED AVERAGE in Excel
- 38 5 useful functions in Excel for beginners
- 39 Inventory System in Excel part 1
- 40 Inventory System in Excel part 2
- 41 Inventory System in Excel part 4
- 42 Inventory System in Excel part 5
- 43 Inventory System for Retail Shop in Excel
- 44 How to use CONDITIONAL FORMATTING for inventory system in Excel
- 45 How to use the OFFSET function in Excel
- 46 Invoicing System in Excel, Part 1 Product List Tab
- 47 Invoicing System in Excel, Part 2 Customer List tab
- 48 Invoicing System in Excel, Part 3 Invoice Design tab
- 49 Invoicing System in Excel, Part 4 Invoice Formula
- 50 Invoicing System in Excel, Part 5 Invoice Print Ready Design
- 51 Invoicing System in Excel, Part 6 Dashboard tab
- 52 Invoicing System in Excel Complete Course
- 53 How to make an AUTOMATED CERTIFICATE SYSTEM in Excel
- 54 How to create a DYNAMIC SENTENCE in Excel
- 55 How to track your sales in Excel
- 56 How to calculate age in Excel
- 57 How to display currency symbol in Excel
- 58 How to lock specific cells and hide formulas in that cell in Excel
- 59 How to lock specific cells in Excel
- 60 How to wrap text in Excel
- 61 VLOOKUP returning NA error and how to solve it in Excel
- 62 How to use double VLOOKUP, NESTED VLOOKUP in Excel
- 63 VLOOKUP example between two sheets in Excel | VLOOKUP function
- 64 VLOOKUP from another sheet in Excel
- 65 How to make a Bakers Recipe Costing Calculator in Excel
- 66 Apply CONDITIONAL FORMATTING to entire column in Excel
- 67 How to do CONDITIONAL FORMATTING based on text in EXCEL
- 68 How to remove CONDITIONAL FORMATTING from a sheet in Excel
- 69 How to do CONDITIONAL FORMATTING based on TEXT with UNIQUE DROPDOWN LIST in Excel
- 70 How to do CONDITIONAL FORMATTING with IF STATEMENT in Excel