In Part 3 of our video series, we will use the amazing Pivot Tables in Excel to keep track of the calories we eat, giving us totals for each day and each meal.
To follow along, click techhelptoday.com/videos/ and click the link for the Excel workbook designed for this video. At this same link you will also find links to other videos in this series as well as several other videos and resources by Rich Malloy and Tech Help Today.
In the next and final video in this series, we will see how we can use the super-powerful VLOOKUP function to make it easy to record the various foods we eat. Here's a summary of the various parts in the Dieting Series:
Part 1: Dieting with a simple table
Part 2: Dieting with Excel Tables
Part 3: Dieting with Pivot Tables
Part 4: Dieting with the VLOOKUP function
- Dieting with Excel Pivot Tables ( Download)
- Dieting with Excel, Part 2: Excel Tables ( Download)
- Pivot Table Excel Tutorial ( Download)
- Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!) ( Download)
- Dieting with Excel, Part 1: Creating a Simple Food Log ( Download)
- Anova and pivot tables in Excel with Biggest Loser data | Business Statistics ( Download)
- Dieting with the Amazingly Powerful VLOOKUP Function ( Download)
- Create a Weight Tracking Worksheet in Excel with the OFFSET Function ( Download)
- Z and Paired T using Pivot Tables in Excel using data from The Biggest Loser | Business Analytics ( Download)
- How to create a Nutrition Calculator in Excel ( Download)
- DON'T Make These 5 Pivot Table Mistakes ( Download)
- How to use pivot table for employee absenteeism analysis ( Download)
- How to VLOOKUP in Excel in 1 min #excel ( Download)
- Weight Loss Table ( Download)
- Excel vs Google Sheets ( Download)
