From the course: Excel Challenges
Unlock this course with a free trial
Join today to access over 25,600 courses taught by industry experts.
Quickly answer these questions - Microsoft Excel Tutorial
From the course: Excel Challenges
Quickly answer these questions
- [Instructor] We're going to do something different here, and hopefully you will find this fun, enlightening, and educational. Here is a real world situation where somebody calls us on the phone, and they want some answers about some data. They just want the answers. They don't want a spreadsheet or an email. If we tell 'em 19 and Jody, they're going to write that down, and that's all they need, right? So we want to blast through this, and we can be as sloppy as we need to be, but we also need to be accurate. Okay, so here it is. We got somebody on the phone, they want answers. We need to get them those answers. Here are the questions they're going to ask a total of 12, and about this data, here we are. So Juan Pablo Acosta coming from Auckland, arriving Wednesday, 23:28, hotel room assignment 505, and Juan Pablo is a returning participant, and doesn't have a balanced due, but we do see that Salamay has a balanced due…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
- 28_12_Flag_Forbidden_Reimbursements.zip
- 11_12_Hot_or_cold.zip
- 13_07_Retrieve_prices.zip
- 13_08_Clean_and_sort_this_song_list.zip
- 15_10_Formula_triggers_and_totals.zip
- 16_06_Clean_the_pivot_table_data.zip
- 16_07_Automated_color_changing_emoji.zip
- 17_03_PJ_10_mile_run.zip
- 17_08_Out_of_pocket_expenses.zip
- 17_10_Make_Room_Assignments.zip
- 18_03_Sort_the_strikethroughs.zip
- 18_09_Measure_the_response_rate.zip
- 19_01_How_much_is_owed_for_the_beach_house.zip
- 19_03_Quickly_answer_these_questions..zip
- 19_07_Retrieve_the_name_and_genre.zip
- 20_02_Times_and_penalties.zip
- 20_07_Event_Calculator.zip
- 20_09_Find_the_missing_numbers.zip
- 20_11_Recycle_a_query_in_Power_Query.zip
- 22_02_Teach_Me_XLOOKUP.zip
- 22_03_Book_Club_Mavis_and_Benedict.zip
- 22_04_Book_Club_Attendance.zip
- 22_06_Conditional_Formatting_Scores.zip
- 22_08_Set_Print_Layout.zip
- 22_12_Workshop_Trends.zip
- 23_02_Explain_The_Query.zip
- 23_04_List_the_Cheeses.zip
- 23_05_Schedule_The_Meetings.zip
- 23_09_Control_Worksheet_Entries.zip
- 23_10_Flip_This_Dataset.zip
- 23_11_Build_A_Table.zip
- Flip_the_Zone.zip
- Payment_Tracking.zip
- Home_Scores.zip
- Graph_the_Population.zip
- Win_Loss_Record.zip
- Round_Winners.zip
- November_Advances.zip
- Revenue_Share.zip
- Color_Choices.zip
- Find_the_Top_3.zip
- Calculate_Overtime.zip
- Lineup_Order.zip
- 25_1_Numbers_Adding_Up_to_11.zip
- 25_2_Check_Progress.zip
- 25_3_Find_Valerie.zip
- 25_4_Make_Names.zip
- 25_8_Build_Grid.zip
- 25_9_Review_Data.zip
- 25_10_ID_Donors.zip
- 26_3_Filter_Counties.zip
- 26_4_Useful_Surveys.zip
- 26_7_Bike_Ride.zip
- 26_12_Graph_Complaints.zip
- 27_02_Restaurant_Sort.zip
- 28_06_Format_Birthdates.zip
- 28_08_Guests_and_Bundles.zip
- 28_10_Print_National_Holidays.zip
- 28_11_Stained_Glass.zip
Contents
-
-
Flag forbidden reimbursements2m 29s
-
(Locked)
Stack and group data4m 32s
-
(Locked)
Print holiday calendar1m 43s
-
(Locked)
Rounding bundled products4m 21s
-
(Locked)
Format and sort birthdates3m 28s
-
(Locked)
Graph specific complaints3m 41s
-
How many miles did Terri cycle?5m 8s
-
(Locked)
Identify specific donors2m 43s
-
(Locked)
Review data for Power Query5m 24s
-
(Locked)
Build a grid of fake data for training4m 56s
-
(Locked)
Choose preferred names3m 11s
-
(Locked)
Find Valerie in the roster2m 16s
-
(Locked)
Using checkmarks to check progress4m 55s
-
(Locked)
Numbers that add to 113m 38s
-
(Locked)
Determine the new player lineup3m 34s
-
(Locked)
Find the top three2m 51s
-
(Locked)
Color choices3m 48s
-
(Locked)
Revenue share4m 52s
-
(Locked)
November advances4m 54s
-
(Locked)
Win-loss record4m 49s
-
(Locked)
Home scores4m 6s
-
(Locked)
Payment tracking4m 53s
-
(Locked)
Build a table3m 35s
-
(Locked)
Flip this dataset2m 40s
-
(Locked)
Control and identify worksheet entries3m 41s
-
(Locked)
Schedule the meetings3m 31s
-
(Locked)
List the cheeses4m 31s
-
(Locked)
Explain the query5m 6s
-
(Locked)
Find trends using sparklines1m 53s
-
(Locked)
Set print layout2m 47s
-
(Locked)
Identify the top five and bottom five values7m 40s
-
(Locked)
Book club attendance count2m 23s
-
(Locked)
Attendance of Mavis and Benedict5m 10s
-
(Locked)
Teach me XLOOKUP8m 20s
-
(Locked)
Recycle a query to use on a different dataset3m 23s
-
(Locked)
Find the missing numbers4m 28s
-
(Locked)
Build an Event Calculator3m 55s
-
(Locked)
How many penalties can be accrued?4m 8s
-
(Locked)
Accept ID or confirmation number5m 4s
-
(Locked)
Quickly answer these questions11m 20s
-
(Locked)
How much for the beach rental?3m 51s
-
(Locked)
Measure the response rate6m 4s
-
(Locked)
Sort so the strikethrough values are on the bottom2m 18s
-
(Locked)
Make assignments based on the last name4m 32s
-
(Locked)
Calculate your out-of-pocket expense3m 2s
-
(Locked)
PJ's 10-mile run3m 44s
-
(Locked)
Animated color-change emoji6m 16s
-
(Locked)
Clean data to correct the PivotTable3m 25s
-
(Locked)
Write a formula trigger to control calculations4m 10s
-
(Locked)
Clean and sort this song list4m 19s
-
(Locked)
Retrieve prices2m 27s
-
(Locked)
Too hot or too cold3m 29s
-