Excel Power User Challenge

Focused View

Oz du Soleil

1:59:25

156 View

01 - Welcome

01 - Excel Power User Challenge.mp4

02:40

02 - Excel Power User Challenge

01 - Deliveries and PivotTables.mp4

04:06

02 - Troubleshoot this query that has a peculiar result.mp4

02:45

03 - Check this data quality for results that don't fit requirements.mp4

09:10

04 - Set up a document to show low-level alerts.mp4

05:12

05 - Write a formula for a two-way lookup.mp4

03:46

06 - Format cells to create ID numbers.mp4

02:25

07 - Parse and summarize data to tally votes.mp4

06:37

08 - Write a SUMIFS formula for three criteria.mp4

05:35

09 - Beautify form with images and print settings.mp4

03:45

10 - Add spin buttons to compare products.mp4

06:57

11 - Restructure the data and write formulas to calculate bonuses.mp4

05:33

12 - Import from folder and tally attendances.mp4

04:12

13 - Create a histogram from the donation data.mp4

02:29

14 - How many full and partial orders can be filled from this inventory.mp4

05:14

15 - Who owes what for the beach house vacation.mp4

06:01

16 - Sort dates by day and month to find the birthday with the most people.mp4

03:17

17 - Pizza party calculation.mp4

06:34

18 - Stack this data using Power Query.mp4

04:19

19 - Who has an assignment and who doesn't.mp4

03:17

20 - Create data validation that only accepts pairs.mp4

01:40

21 - Stack and summarize vendor data.mp4

02:40

22 - Sort titles and ignore A, An, The.mp4

02:48

23 - Unwind this report.mp4

02:42

24 - Two data sets, one relationship, one PivotTable.mp4

02:40

25 - Extract the competition winners.mp4

03:31

26 - Three ways to retrieve data.mp4

06:54

27 - Unstack this list so that it's useful.mp4

02:36

Exercise Files

01_01_Deliveries_and_Pivot_Tables.zip

01_02_Please_fix_this_query.zip

01_03_Check_data_quality.zip

01_04_Create_Low_Level_Alerts.zip

01_05_2_Way_Lookup.zip

01_06_Format_cells_to_create_ID_Numbers.zip

02_01_Count_Votes.zip

02_02_SUMIFS_3_criteria.zip

02_03_Beautify_form_with_images.zip

02_04_Add_spin_buttons.zip

02_05_Calculate_Bonuses.zip

02_06_Import_from_a_folder.zip

02_07_Attendance.zip

03_01_Donation.zip

03_02_Orders.zip

03_03_Beach.zip

03_04_Birthday.zip

03_05_Pizza.zip

03_06_Stack.zip

04_01_Assignment.zip

04_02_Data_Validation.zip

04_03_Append.zip

04_04_Sort_Titles.zip

04_05_Unwind.zip

04_06_Relationships.zip

05_01_Retrieve_the_competition_winners.zip

05_02_3_ways_to_retrieve_data.zip

05_03_Unstack.zip

Description

You know your way around Excel? Want to put your skills to the test? This biweekly advanced Excel series with Excel MVP Oz du Soleil offers sophisticated exercises that can transform you into a bona fide power user. The challenges are drawn from Oz's real-world experience as a long-time Excel user, Excel trainer, and business intelligence consultant. Topics include formulas and functions, conditional formatting, pivot tables, Power Query, troubleshooting, and more.

Note: Because this is an ongoing series, viewers will not receive a certificate of completion.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Oz du Soleil

Instructor's Courses

Microsoft Excel MVP | YouTube Channel: Excel on Fire | Author, Guerrilla Data Analysis Version 2. Co-authored with Mr Excel, Bill Jelen | Excel Trainer & Instructor | Speaker. I've been working with data and Excel for many years, and have developed a passion for clean data and reliable reporting. An even greater passion is that of teaching, sharing knowledge and empowering people to do handle their data more efficiently and with greater skill to turn their data into useful information. Presented at: #Northwestern University #University of Illinois at Chicago #IgniteChicago #ExcelTV Courses taught: Excel Formulas Data Visualization in Excel 2013 Pivot Tables & Dashboards Excel for Nonprofits: Measuring Fundraising Effectiveness Introduction to Programming VBA

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.