Excel in the Real World
42mGeneral2018-11-26
Authors
Oz du Soleil
Excel MVP, Author, and Trainer
Course details
Excel is more than just a number cruncher. It's a Swiss Army knife that helps you work with data from anywhere—numbers, dates, times, text, and more. In this short course, Microsoft MVP Oz du Soleil shows how Excel can help solve real-world problems featuring any kind of information. Learn how Excel can be used in interesting, out-of-the-box ways: to manage property, calculate prices for a new product, simplify music arrangements, keep your kids on top of their chores, or even build seating charts for an event. There's nothing Excel can't do. So make it do more for you.
Learning objectives
Real-world applications for COUNTA, ROUNDUP, and VLOOKUP
Uses for named ranges
Reasons to use conditional formatting
Common drop-down lists
Uses for PivotTables and slicers
When to use Power Query and joins
Common uses of array formulas
Learning objectives
Real-world applications for COUNTA, ROUNDUP, and VLOOKUP
Uses for named ranges
Reasons to use conditional formatting
Common drop-down lists
Uses for PivotTables and slicers
When to use Power Query and joins
Common uses of array formulas
Skills covered
VlogSpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoft
Concepts
Excel in the Real World
- 01 - How Excel changed my life
- 02 - Tracking naughty and nice behavior in Excel
- 03 - Plan for future work with Excel
- 04 - Calculate the right retail price with Excel
- 05 - How Excel can simplify music arrangements
- 06 - Tracking progress with Excel
- 07 - Who sits where Create a seating chart in Excel
- 08 - Excel event planning - Calculate a shopping list
- 09 - How Excel can calculate your break-even point
- 10 - Find the most popular product combinations in Excel
- 11 - Tracking chores in Excel
- 12 - How Excel can help you find the house of your dreams
- 13 - Excel Power Query - Keep data refreshed automatically
- 14 - Making sense of bundled orders with Excel