Share Description
In this course, you will :
- This biweekly advanced Excel series with Excel MVP Oz du Soleil includes sophisticated exercises that will turn you into a true power user.
- Oz's real-world experience as a long-time Excel user, Excel trainer, and business intelligence consultant informs the challenges.
- Formulas and functions, conditional formatting, pivot tables, Power Query, troubleshooting, and other topics are covered.
Syllabus :
1. Excel Power User Challenge
- Deliveries and PivotTables
- Troubleshoot this query that has a peculiar result
- Check this data quality for results that don't fit requirements
- Set up a document to show low-level alerts
- Write a formula for a two-way lookup
- Format cells to create ID numbers
- Parse and summarize data to tally votes
- Write a SUMIFS formula for three criteria
- Beautify form with images and print settings
- Add spin buttons to compare products
- Restructure the data and write formulas to calculate bonuses
- Import from folder and tally attendances
- Create a histogram from the donation data
- How many full and partial orders can be filled from this inventory?
- Who owes what for the beach house vacation?
- Sort dates by day and month to find the birthday with the most people
- Pizza party calculation
- Stack this data using Power Query
- Who has an assignment and who doesn't?
- Create data validation that only accepts pairs
- Stack and summarize vendor data
- Sort titles and ignore A, An, The
- Unwind this report
- Two data sets, one relationship, one PivotTable
- Extract the competition winners
- Three ways to retrieve data
- Unstack this list so that it's useful
- Pair each student with every other student
- This query used to work—what's wrong?
- Reformat this list
- The strange case of copy and paste from Word to Excel
- Combine a dataset with a Power Query conversion table
- Convert a report so it can be sorted and filtered
- Convert records from a matrix to a single column
- Retrieve school mascots from the column
