From the course: Excel Weekly Challenge
Unlock this course with a free trial
Join today to access over 24,500 courses taught by industry experts.
Crop and print - Microsoft Excel Tutorial
From the course: Excel Weekly Challenge
Crop and print
- [Instructor] Check out this beautiful receipt that we have for our business. But there are two issues. One, we are no longer open 24 hours, so your help is needed to just crop that piece off. The second issue is, when we go to print this, this lovely fish logo is not printing out, look. I want to go to File, Print, no fish. So, will you please change the property so that that logo will print? And notice that the sheet is protected, so you're going to have to unprotect and re-protect the sheet, watch. And it's not moving, the cursor is not moving. And then watch it jump. See, so the sheet is protected. So, when you're ready, pause the video, grab that exercise file, make this happen, come back, and we'll do it together. All right, you're back. First, we go to Review, Unprotect Sheet. Now it's unprotected. We can touch our beautiful logo. Let's go to Format, because now that we are touching the image,…
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.
- 02_07_Create_a_chart_of_monthly_complaints.zip
- 01_05_Identify_and_move_attendee_data.zip
- 02_08_Calculate_pay_based_on_hours_and_location.zip
- 01_06_Combine_first_last_names.zip
- 02_09_Review_accuracy_of_invoice.zip
- 01_03_Align_and_adjust_text_on_an_order_form.zip
- 02_10_Combine_3_donations_lists_into_1.zip
- 01_04_Get_a_count_of_possible_venues.zip
- 01_01_Add_new_participants_to_teams.zip
- 01_02_Format_the_cells_in_a_form.zip
- 01_12_Excel_in_Real_Life_1_House_Shopping.zip
- 01_08_Fill_in_categories_and_sort.zip
- 01_09_Add_a_new_list_and_line_it_up.zip
- 01_07_Clean_up_bizarre_formatting.zip
- 02_11_Group_and_sort_inventory_items.zip
- 02_12_The_expense_report_is_wrong.zip
- 02_13_Categorize_the_status_of_each_apartment.zip
- 02_14_Excel_in_real_life_-_Auditing_inventory.zip
- 01_10_Sort_Addresses_by_Region.zip
- 01_11_Help_find_our_perfect_house.zip
- 02_04_Correct_city_names.zip
- 02_05_Fix_the_pricing_formula.zip
- 02_06_Fill_in_pick-list_details.zip
- 02_02_List_and_inspect_survey_results.zip
- 02_03_Create_table_of_course_summaries.zip
- 02_01_Prepare_this_report_to_be_printed.zip
- 03_01_Leading_zeroes.zip
- 03_02_Stack_and_sort.zip
- 03_03_Fix_dates.zip
- 03_04_Add_a_shape.zip
- 03_05_Combo_chart_with_secondary_axis.zip
- 03_06_Horizonal_sort.zip
- 03_07_Setup_and_format_workbook.zip
- 03_08_Count_addresses.zip
- 03_09_Fix_IDs.zip
- 03_10_Protect_and_validate.zip
- 03_11_Find_duplicate_records.zip
- 03_12_Hide_zeroes.zip
- 03_13_Correct_these_calculations.zip
- 04_01_What_is_this_formula_doing.zip
- 04_02_Pricing_grid_and_dropdown_list.zip
- 04_03_Write_a_formula_trigger.zip
- 04_04_Merge_and_compare_lists.zip
- 04_05_Recreate_this_graphic.zip
- 04_06_Insert_happy_or_sad_face.zip
- 04_07_Conditional_format_and_sort_icons.zip
- 04_08_Crop_and_print.zip
- 04_09_Quick_access_and_theme.zip
- 04_10_Update_graphs.zip
- 04_11_Insert_a_pivot_table.zip
- 04_12_Delete_transactions_and_insert_pivot_table.zip
- 05_01_Close_holes_in_a_list.zip
- 05_02_QAT_and_Pivot_Table.zip
- 05_03_Unpivot_and_split_columns.zip
- 05_04_Presentations_Part_1_Randomize.zip
- 05_05_Presentations_Part_2_What_day_is_each_person_presenting.zip
- 05_06_Calculate_team_fees.zip
- 05_07_Lookup_and_correct_errors.zip
- 05_08_Calculate_final_cost.zip
- 05_09_Clear_excess_images.zip
- 05_10_Format_workbook_defaults.zip
- 05_11_Extract_all_Saturdays.zip
- 06_01.zip
- 06_01_Copy_to_a_new_workbook_and_save_as_PDF.zip
- 06_02_Insert_pivot_table_and_slicers_to_review_workshops.zip
- 06_03_Use_Find_Replace_to_correct_names.zip
- 06_04_Isolate_addresses.zip
- 06_05_Payment_errors_part_1.zip
- 06_06_Payment_errors_part_2.zip
- 06_07_Change_chart_type_and_create_summary.zip
- 06_08_Create_dropdown_lists.zip
- 06_09_Explain_this_sales_formula.zip
- 06_10_Using_COUNTIFS_with_wildcards.zip
- 06_11_Create_an_index_column.zip
- 06_12_Create_tables_and_eliminate_hyperlinks.zip
- 06_13_List_the_top_7_donation_amounts.zip
- 07_01_Get_data_ready_for_a_pivot_table.zip
- 07_02_Modify_this_pivot_table.zip
- 07_03_Power_query_result.zip
- 07_04_Create_a_dynamic_dropdown_list.zip
- 07_05_Dynamic_array_filter_venues.zip
- 07_06_Find_and_restore_the_missing_data.zip
- 07_07_Override_names.zip
- 07_08_Quiz.zip
- 07_09_Protect_formulas_with_a_shape.zip
- 07_10_Show_percentages.zip
- 07_11_Replace_highlights.zip
- 07_12_Replace.zip
- 07_13_Add_a_spin_button.zip
- 08_01_Create_a_custom_data_validation_alert.zip
- 08_02_Modify_Data_Validation.zip
- 08_03_Identify_multiple_shifts.zip
- 08_04_Conditional_Formatting_Icons.zip
- 08_05_Two_windows.zip
- 08_06_Correct_dates.zip
- 08_07_Remove_image_background.zip
- 08_08_Calculate_reimbursements.zip
- 08_09_Fix_and_sort.zip
- 08_10_Apply_formulas.zip
- 08_11_Clear_all_content_and_formatting.zip
- 08_12_Transpose_and_format_data.zip
- 09_01_Find_3_ways_to_extract_this_data.zip
- 09_02_Write_a_formula_from_scratch.zip
- 09_03_Isolate_data_by_the_week.zip
- 09_04_Arts_and_Crafts.zip
- 09_05_Explain_and_test_this_formula.zip
- 09_06_Please_fix_this_pivot_table.zip
- 09_07_Calculate_PTO_Available.zip
- 09_08_Flight_Counts.zip
- 09_09_Adjust_layout_and_set_conditional_formatting.zip
- 09_10_Sum_the_salmon_dishes.zip
- 09_11_Event_Planning_Formula.zip
- 10_01_Payroll.zip
- 10_02_Format_grid.zip
- 10_03_Conditional_Formatting.zip
- 10_04_Guest_Count.zip
- 10_05_Footers.zip
- 10_06_Exams.zip
- 10_07_Slicers.zip
- 10_08_Survey.zip
- 10_09_Extract_Names.zip
- 10_10_Change_the_colors.zip
- 10_11_Chart_Axis.zip
- 10_12_Extract_Sales_Data.zip
- 11_01_Order_form.zip
- 11_02_Correct_and_format_dates.zip
- 11_03_Curriculum_audit.zip
- 11_04_Create_a_running_total.zip
- 11_05_Convert_liquids.zip
- 11_06_Office_expenses.zip
- 11_07_If.zip
- 11_08_Top_Bottom.zip
- 11_09_Calculate_team.zip
- 11_10_Topics_for_Students.zip
- 11_11_Shapes.zip
- 11_12_Hot_or_cold.zip
- 12_01_OneCell.zip
- 12_02_Sales_Data.zip
- 12_03_Unique.zip
- 12_04_Repeat.zip
- 12_05_Three_Lists.zip
- 12_06_Dropdown.zip
- 12_07_Goal_Actual.zip
- 12_08_Deadlines.zip
- 12_09_Icons.zip
- 12_10_Unpivot.zip
- 12_11_Count_Characters.zip
- 12_12_Filter_Project.zip
- 13_01_Sort_Left_Right_Up_Down.zip
- 13_02_Days_Open.zip
- 13_03_Clean_this_list.zip
- 13_04_Sort_High_School_Data.zip
- 13_05_Area_Chart.zip
- 13_06_Fishing_Pivot_Table.zip
- 13_07_Retrieve_prices.zip
- 13_08_Clean_and_sort_this_song_list.zip
- 13_09_Highlight_southwest.zip
- 13_10_Dropdown_from_Table_Headers.zip
- 13_11_Summarize_your_progress.zip
- 14_01_This_printout_is_weird.zip
- 14_02_Adjust_the_due_dates.zip
- 14_03_Append_these_3_datasets.zip
- 14_04_Filter_projects.zip
- 14_05_Merge_columns_2_ways.zip
- 14_06_Who_gets_paid.zip
- 14_07_Build_a_statement.zip
- 14_08_Spin_buttons.zip
- 14_09_Count_Functions.zip
- 14_10_Summarize_and_create_chart.zip
- 14_11_This_lookup_doesnt_work.zip
- 14_12_Slicers.zip
- 15_01_10_rounds_2_teams_who_won.zip
- 15_02_Calculate_Kates_maximum_advance.zip
- 15_03_Assign_Emails.zip
- 15_04_Identify_5_problems.zip
- 15_05_Monitor_capacity.zip
- 15_06_Correct_the_printing_of_this_document.zip
- 15_07_Revenue_Share.zip
- 15_08_Dropdown_lists_chairs_and_prices.zip
- 15_09_Pivot_table_training.zip
- 15_10_Formula_triggers_and_totals.zip
- 15_11_Identify_Multi_part_names.zip
- 15_12_Format_the_times_and_calculate_pay.zip
- 16_01_Area_chart.zip
- 16_02_Create_a_pivot_table_for_the_juniors_and_seniors.zip
- 16_03_Please_fix_this_pivot_table.zip
- 16_04_Picture_formatting_to_improve_a_presentation.zip
- 16_05_Split_the_string_of_IDs.zip
- 16_06_Clean_the_pivot_table_data.zip
- 16_07_Automated_color_changing_emoji.zip
- 16_08_Missing_inventory.zip
- 16_09_Find_the_cars.zip
- 16_10_Spell_out_the_months_and_sort.zip
- 16_11_Count_the_empty_cells.zip
- 16_12_Relative_cells_references_and_pricing.zip
- 17_01_Change_gridlines.zip
- 17_02_Modify_this_2_way_lookup_formula.zip
- 17_03_PJ_10_mile_run.zip
- 17_04_Calculate_commissions_based_on_agreement.zip
- 17_05_Correct_the_XLOOKUP.zip
- 17_06_Airport_Count.zip
- 17_07_Modify_the_Conditional_Formatting.zip
- 17_08_Out_of_pocket_expenses.zip
- 17_09_Identify_the_eastside_apartments.zip
- 17_10_Make_Room_Assignments.zip
- 18_01_Sort_names_in_Power_Query.zip
- 18_02_Identify_the_non_donors.zip
- 18_03_Sort_the_strikethroughs.zip
- 18_04_Simplify_the_IF.zip
- 18_05_Total_the_emoji_scores.zip
- 18_06_Delete_unneeded_rows.zip
- 18_07_Day_and_Time.zip
- 18_08_Attendance_matrix.zip
- 18_09_Measure_the_response_rate.zip
- 18_10_Sort_city_dates.zip
- 18_11_Attendance_queries.zip
- 18_12_Decode_the_words.zip
- 19_01_How_much_is_owed_for_the_beach_house.zip
- 19_02_Get_data_from_an_image.zip
- 19_03_Quickly_answer_these_questions..zip
- 19_04_Flag_and_Delete.zip
- 19_05_Delete_rows.zip
- 19_06_Project_cost.zip
- 19_07_Retrieve_the_name_and_genre.zip
- 19_08_Generate_random_codes.zip
- 19_09_Count_the_letter_L.zip
- 19_10_Double_headers.zip
- 19_11_Quiz.zip
- 19_12_Calculate_total_loss.zip
- 20_01_Calculate_the_percent_change.zip
- 20_02_Times_and_penalties.zip
- 20_03_Build_your_own_Pivot_Table.zip
- 20_04_Sort_by_Last_Name.zip
- 20_05_List_all_of_the_colors.zip
- 20_06_Build_a_Venn_diagram.zip
- 20_07_Event_Calculator.zip
- 20_08_Sum_the_net_loss.zip
- 20_09_Find_the_missing_numbers.zip
- 20_10_Bring_contents_into_a_single_cell.zip
- 20_11_Recycle_a_query_in_Power_Query.zip
- 20_12_Paydays_and_Holidays.zip
- 21_01_Applying_slicers.zip
- 21_02_Build_a_bar_chart.zip
- 21_03_Boxes_on_a_shelf.zip
- 21_04_Insert_rows.zip
- 21_05_Trivia_night_calendar.zip
- 21_06_Tally_top_scores.zip
- 21_07_Filepath.zip
- 21_08_Add_picture_in_pivot_table.zip
- 21_09_Indent_cells.zip
- 21_10_Change_cell_borders.zip
- 21_11_Make_a_logo.zip
- 21_12_Convert_performer_roster.zip
- 22_01_Randomize_Names_3_Ways.zip
- 22_02_Teach_Me_XLOOKUP.zip
- 22_03_Book_Club_Mavis_and_Benedict.zip
- 22_04_Book_Club_Attendance.zip
- 22_05_Create_a_block_of_numbers.zip
- 22_06_Conditional_Formatting_Scores.zip
- 22_07_Sort_by_Shift.zip
- 22_08_Set_Print_Layout.zip
- 22_09_I_Know_The_Day_But_Need_The_Year.zip
- 22_10_Dropdown_and_Filter_Cars.zip
- 22_11_Sort_Pairs_of_Columns.zip
- 22_12_Workshop_Trends.zip
- 23_01_CF_Highlight_Every_3rd_cell.zip
- 23_02_Explain_The_Query.zip
- 23_03_Modify_the_Query.zip
- 23_04_List_the_Cheeses.zip
- 23_05_Schedule_The_Meetings.zip
- 23_06_Append_3_Datasets.zip
- 23_07_Filter_By_3_Criteria.zip
- 23_08_Convert_From_Range_to_Table_References.zip
- 23_09_Control_Worksheet_Entries.zip
- 23_10_Flip_This_Dataset.zip
- 23_11_Build_A_Table.zip
- 23_12_Sort_By_Last_Name.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_5_ID_Interns_Contractors.zip
- 25_6_Count_Interns_Contractors.zip
- 25_7_Count_5_Years_or_More.zip
- 25_8_Build_Grid.zip
- 25_9_Review_Data.zip
- 25_10_ID_Donors.zip
- 25_11_Add_Addresses.zip
- 25_12_Population_Change.zip
- 26_1_County_Dropdown_List.zip
- 26_2_Calculate_Top_3.zip
- 26_3_Filter_Counties.zip
- 26_4_Useful_Surveys.zip
- 26_5_Pizza_Toppings.zip
- 26_6_Group_and_Save.zip
- 26_7_Bike_Ride.zip
Contents
-
-
-
-
(Locked)
Group and save as picture2m 57s
-
(Locked)
Universal pizza toppings2m 17s
-
(Locked)
Identify and tally the useful surveys4m 57s
-
(Locked)
Filter multiple criteria3m 28s
-
(Locked)
Identify two ways to tally the top three8m 39s
-
(Locked)
Insert a variable dropdown list3m 28s
-
(Locked)
Calculate the population changes1m 33s
-
(Locked)
Add address street numbers3m 7s
-
(Locked)
Identify specific donors2m 43s
-
(Locked)
Review data for Power Query5m 24s
-
(Locked)
Build a grid of fake data for training4m 56s
-
(Locked)
Count employees with five or more years2m 43s
-
(Locked)
Count employees, interns, and contractors3m 52s
-
(Locked)
Identify interns and contractors3m
-
(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)
Calculate overtime1m 50s
-
(Locked)
Find the top three2m 51s
-
(Locked)
Color choices3m 48s
-
(Locked)
Revenue share4m 52s
-
(Locked)
November advances4m 54s
-
(Locked)
Round winners4m
-
(Locked)
Win-loss record4m 49s
-
(Locked)
Graph the population1m 22s
-
(Locked)
Home scores4m 6s
-
(Locked)
Payment tracking4m 53s
-
(Locked)
Flip the zone2m 43s
-
(Locked)
Sort by last name3m 55s
-
(Locked)
Build a table3m 35s
-
(Locked)
Flip this dataset2m 40s
-
(Locked)
Control and identify worksheet entries3m 41s
-
(Locked)
Convert range to table references3m 37s
-
(Locked)
Filter by three criteria5m 1s
-
(Locked)
Append three datasets6m 25s
-
(Locked)
Schedule the meetings3m 31s
-
(Locked)
List the cheeses4m 31s
-
(Locked)
Modify the query3m 36s
-
(Locked)
Explain the query5m 6s
-
(Locked)
Highlight every third cell3m 22s
-
(Locked)
Find trends using sparklines1m 53s
-
(Locked)
Sort pairs of columns2m 10s
-
(Locked)
Filtering vehicles4m 35s
-
(Locked)
I know the day but need the year2m 9s
-
(Locked)
Set print layout2m 47s
-
(Locked)
Sort by shift3m 1s
-
(Locked)
Identify the top five and bottom five values7m 40s
-
(Locked)
Create a 12x10 block of numbers with no duplicates3m 17s
-
(Locked)
Book club attendance count2m 23s
-
(Locked)
Attendance of Mavis and Benedict5m 10s
-
(Locked)
Teach me XLOOKUP8m 20s
-
(Locked)
Randomize three ways3m 56s
-
(Locked)
Convert performer roster5m 37s
-
(Locked)
Create a logo and save it6m 36s
-
(Locked)
Change cell borders4m 2s
-
(Locked)
Indent cells4m 42s
-
(Locked)
Add a picture in a PivotTable4m 21s
-
(Locked)
Include filepath on print out2m 51s
-
(Locked)
Tally top scores4m 34s
-
(Locked)
Create a trivia night calendar6m 38s
-
(Locked)
Stack names with rows in between3m 11s
-
(Locked)
How many boxes can fit on this shelf?2m 57s
-
(Locked)
Build a bar chart for program attendance5m 42s
-
(Locked)
Apply slicers to a review class schedule4m 17s
-
(Locked)
Paydays that fall on a weekend or holiday4m 45s
-
(Locked)
Recycle a query to use on a different dataset3m 23s
-
(Locked)
Bring contents into a single cell4m 5s
-
(Locked)
Find the missing numbers4m 28s
-
(Locked)
Sum the total loss4m 39s
-
(Locked)
Build an Event Calculator3m 55s
-
(Locked)
Build a Venn diagram7m 52s
-
(Locked)
List all available colors5m
-
(Locked)
Sort data by last name4m 20s
-
(Locked)
Build your own Pivot Table4m 35s
-
(Locked)
How many penalties can be accrued?4m 8s
-
(Locked)
Calculate the percent change3m 38s
-
(Locked)
Calculate total loss2m 39s
-
(Locked)
Quiz!4m 54s
-
(Locked)
Correct double column headers3m 42s
-
(Locked)
Count the L names3m 30s
-
(Locked)
Generate random codes5m 23s
-
(Locked)
Accept ID or confirmation number5m 4s
-
(Locked)
Tally the project cost2m 25s
-
(Locked)
Delete rows and split text3m 55s
-
(Locked)
Flag and delete records3m 51s
-
(Locked)
Quickly answer these questions11m 20s
-
(Locked)
Get data from image9m 49s
-
(Locked)
How much for the beach rental?3m 51s
-
(Locked)
Decrypt the words3m 56s
-
(Locked)
Attendance queries6m 1s
-
(Locked)
Sort city dates2m 15s
-
(Locked)
Measure the response rate6m 4s
-
(Locked)
Attendance matrix2m 49s
-
(Locked)
Identify entries with specific day and time4m
-
(Locked)
Delete unneeded rows2m 35s
-
(Locked)
Total the emoji scores3m 52s
-
(Locked)
Simplify the IF formula and create a lookup table5m 21s
-
(Locked)
Sort so the strikethrough values are on the bottom2m 18s
-
(Locked)
Identify the non-donors3m 55s
-
(Locked)
Sort names in Power Query3m 40s
-
(Locked)
Make assignments based on the last name4m 32s
-
(Locked)
Highlight the odd-numbered rooms3m 23s
-
(Locked)
Calculate your out-of-pocket expense3m 2s
-
(Locked)
Change the conditional formatting2m 43s
-
(Locked)
Count and sort the airport codes4m 27s
-
(Locked)
Correct this XLOOKUP2m 36s
-
(Locked)
Calculate the commissions based on increments of $1005m 26s
-
(Locked)
PJ's 10-mile run3m 44s
-
(Locked)
Modify this two-way lookup formula to fit your data3m 10s
-
(Locked)
Change the gridlines3m 58s
-
(Locked)
Relative cell references and pricing3m 22s
-
(Locked)
Use three methods to identify and count empty cells4m 21s
-
(Locked)
Spell out and sort the months3m 9s
-
(Locked)
Filter for the car2m 51s
-
(Locked)
Find the missing item numbers7m 32s
-
(Locked)
Animated color-change emoji6m 16s
-
(Locked)
Clean data to correct the PivotTable3m 25s
-
(Locked)
Split string of IDs4m 49s
-
(Locked)
Use the Picture Format tools to improve an image5m 6s
-
(Locked)
Clean the source data and fix the PivotTable5m 2s
-
(Locked)
Create a PivotTable for juniors and seniors3m 25s
-
(Locked)
Area chart: Up vs. down?3m 38s
-
(Locked)
Format times and calculate pay2m 56s
-
(Locked)
Identify multipart last names2m 12s
-
(Locked)
Write a formula trigger to control calculations4m 10s
-
(Locked)
PivotTable training3m 50s
-
(Locked)
Drop-down lists: Chairs and prices3m 22s
-
(Locked)
What's the revenue based on revenue share?3m 56s
-
(Locked)
Print the entire sheet and its charts3m 21s
-
(Locked)
Write a sentence with dynamic values3m 31s
-
(Locked)
Identify five problems with this spreadsheet5m 24s
-
(Locked)
Assign email addresses and check for duplicates2m 39s
-
(Locked)
How much more can Kate advance?3m 26s
-
(Locked)
After ten rounds, which is the winning team?3m 42s
-
(Locked)
Excel Slicers: Insert, format, select1m 53s
-
(Locked)
What's wrong with my XLOOKUP?5m 3s
-
(Locked)
Isolate values and build a chart3m 51s
-
(Locked)
Identify and isolate distinct entries3m 6s
-
(Locked)
Correct the behavior of these spin buttons2m 52s
-
(Locked)
Build a sentence with variable inputs4m 46s
-
(Locked)
Who gets paid this month, and who doesn't?4m 15s
-
(Locked)
Find two ways to combine these cells5m 10s
-
(Locked)
Filter with Excel's dynamic arrays2m 39s
-
(Locked)
Append these three datasets5m 15s
-
(Locked)
Identify and correct completion dates3m 24s
-
(Locked)
Troubleshoot settings for printing3m 18s
-
(Locked)
Summarize your progress3m 13s
-
(Locked)
Create a drop-down list from table headers2m 37s
-
(Locked)
Highlight southwest2m 54s
-
(Locked)
Clean and sort this song list4m 19s
-
(Locked)
Retrieve prices2m 27s
-
(Locked)
Prep data for a pivot table4m 47s
-
(Locked)
What's going up and what's going down?4m 35s
-
(Locked)
Sorting this column isn't working–what's wrong?2m 28s
-
(Locked)
Clean up this song list4m 17s
-
(Locked)
How many days are we open?2m 26s
-
(Locked)
Sorting up, down, left, and right2m 28s
-
(Locked)
Filter project data4m 20s
-
(Locked)
Too many characters: Count characters in a cell2m 47s
-
(Locked)
Unpivot expenses2m 26s
-
(Locked)
Conditional formatting icons3m 6s
-
(Locked)
Calculate deadlines1m 51s
-
(Locked)
Goals vs. actuals3m 3s
-
(Locked)
Show me how to make a drop-down list2m 14s
-
(Locked)
Who's on all three lists?3m 33s
-
(Locked)
Repeat a pattern2m 54s
-
(Locked)
Who's unique in this list?3m 10s
-
(Locked)
Distribute the sales data4m 8s
-
(Locked)
Several lines: Just one cell3m 33s
-
(Locked)
Too hot or too cold3m 29s
-
(Locked)
Insert and format shapes2m 45s
-
(Locked)
Assign random topics to our students3m 6s
-
(Locked)
Calculate team records and break ties3m 15s
-
(Locked)
Use conditional formatting to identify top and bottom values2m 35s
-
(Locked)
IF AND OR: Identify records of interest2m 53s
-
(Locked)
Office expenses and relationships3m
-
(Locked)
Convert liquids3m 19s
-
(Locked)
Create a running total4m 56s
-
(Locked)
Curriculum audit: Accept reasonable dates4m 4s
-
(Locked)
Correct and format dates2m 53s
-
(Locked)
Create an order form6m 33s
-
(Locked)
Extract sales data1m 36s
-
(Locked)
Create a chart and adjust the axis3m 6s
-
(Locked)
Change icon colors2m 35s
-
(Locked)
Extract names from a dataset3m 27s
-
(Locked)
Check the quality of survey responses4m 17s
-
(Locked)
Apply slicers and filter dataset3m 1s
-
(Locked)
Who failed one exam or the other, but not both?3m 45s
-
(Locked)
Set the footers for printing worksheets2m 44s
-
(Locked)
Tally the number of guests for a party3m 57s
-
(Locked)
Apply two conditional formatting rules3m 30s
-
(Locked)
Format grid3m 23s
-
(Locked)
What's the deal with these payroll calculations?4m 47s
-
(Locked)
Event planning formula4m 8s
-
(Locked)
Sum the salmon dishes2m 5s
-
(Locked)
Adjust layout2m 37s
-
(Locked)
Count flights in a matrix3m 36s
-
(Locked)
How many paid days off are available?3m 22s
-
(Locked)
Please fix this PivotTable3m 26s
-
(Locked)
Explain this crazy formula and test it5m 18s
-
(Locked)
TJ's arts and crafts: How can we improve this workbook?4m 4s
-
(Locked)
Isolate data by the week3m 23s
-
(Locked)
Write a formula from nothing and create your own data2m 42s
-
(Locked)
Find three ways to extract the item ID3m 11s
-
(Locked)
Transpose data and paste formula2m 3s
-
(Locked)
Clear the formatting in a range of cells1m 46s
-
(Locked)
Apply formulas to new data2m 30s
-
(Locked)
Sort this data1m 56s
-
(Locked)
Calculate reimbursements based on a maximum per day4m 1s
-
(Locked)
Remove the background from an image2m 35s
-
(Locked)
Correct dates to show the weekday, day, month, and year1m 49s
-
(Locked)
View a worksheet through two windows2m 30s
-
(Locked)
Apply conditional formatting icons2m 21s
-
(Locked)
Identify multiple shifts2m 43s
-
(Locked)
Change the parameters of a data validation3m 11s
-
(Locked)
Create a custom message in data validation2m 11s
-
(Locked)
Apply a spin button3m 24s
-
(Locked)
Replace "Al" with "Alyssa"2m 51s
-
(Locked)
Replace highlights with conditional formatting3m 42s
-
(Locked)
Working with inventory percentages1m 32s
-
(Locked)
Protect calculations with a shape4m 32s
-
(Locked)
Answer four questions about data2m 54s
-
(Locked)
Override names1m 57s
-
(Locked)
Find and restore missing data3m 8s
-
(Locked)
Filter venues with dynamic arrays2m 25s
-
(Locked)
Create a dynamic drop-down list3m 34s
-
(Locked)
Find a Power Query result1m 19s
-
(Locked)
Modify a PivotTable2m 35s
-
(Locked)
Get data ready for a PivotTable3m 5s
-
(Locked)
List the top seven donation amounts1m 45s
-
(Locked)
Create tables and eliminate hyperlinks2m 17s
-
(Locked)
Create an index column1m 32s
-
(Locked)
Using COUNTIFS with wildcards1m 42s
-
(Locked)
Explain this sales formula3m 50s
-
(Locked)
Create drop-down lists2m 59s
-
(Locked)
Change chart type and create summary3m 33s
-
(Locked)
Payment errors, part 24m 32s
-
(Locked)
Payment errors, part 11m 39s
-
(Locked)
Isolate addresses4m 37s
-
(Locked)
Use Find and Replace to correct names1m 35s
-
(Locked)
Insert a PivotTable and slicers to review workshop data3m 23s
-
(Locked)
Copy to a new workbook and save as a PDF2m 1s
-
(Locked)
Extract all Saturdays2m 52s
-
(Locked)
Format workbook defaults1m 11s
-
(Locked)
Clear excess images1m 51s
-
(Locked)
Calculate final cost and set data validation5m 32s
-
(Locked)
Lookup and correct errors2m 47s
-
(Locked)
Calculate team fees3m 2s
-
(Locked)
Presentations part 2: What day is each person presenting?2m 49s
-
(Locked)
Presentations part 1: Randomize4m 5s
-
(Locked)
Unpivot and split columns2m 19s
-
(Locked)
QAT and pivot table2m 54s
-
(Locked)
Close holes in a list1m 2s
-
(Locked)
Delete transactions and insert a PivotTable2m 58s
-
(Locked)
Insert a PivotTable2m 26s
-
(Locked)
Update graphs3m 26s
-
(Locked)
Quick access and theme2m 8s
-
(Locked)
Crop and print1m 53s
-
(Locked)
Conditional formatting and sorting icons2m 35s
-
(Locked)
Insert a happy or sad face3m
-
(Locked)
Recreate this graphic5m 5s
-
(Locked)
Merge and compare lists3m 24s
-
(Locked)
Write a formula trigger3m 14s
-
(Locked)
Pricing grid and drop-down list3m 42s
-
(Locked)
What is this formula doing?2m 39s
-
(Locked)
Correct these calculations3m 19s
-
(Locked)
Hide zeroes2m
-
(Locked)
Identify at least five problems with this data3m 51s
-
(Locked)
Protect and validate3m 47s
-
(Locked)
Fix IDs3m 25s
-
(Locked)
Count addresses2m 50s
-
(Locked)
Set up and format a workbook3m 17s
-
(Locked)
Horizontal sort2m 34s
-
(Locked)
Combo chart with secondary axis1m 48s
-
(Locked)
Add a shape2m 59s
-
(Locked)
Fix dates2m 57s
-
(Locked)
Sort and stack2m 35s
-
(Locked)
Leading zeroes1m 51s
-
(Locked)
Excel in real life: Auditing inventory4m 37s
-
(Locked)
Categorize the status of each apartment3m
-
(Locked)
The expense report is wrong2m 18s
-
(Locked)
Group and sort inventory items2m 16s
-
(Locked)
Combine three donation lists into one4m 30s
-
(Locked)
Review accuracy of invoice2m 12s
-
(Locked)
Calculate pay based on hours and location3m 21s
-
(Locked)
Create a chart of monthly complaints1m 28s
-
(Locked)
Fill in pick list details3m 40s
-
(Locked)
Fix the pricing formula1m 48s
-
(Locked)
Correct city names1m 4s
-
(Locked)
Create table of course summaries1m 51s
-
(Locked)
List and inspect survey results2m 8s
-
(Locked)
Prepare this report to be printed2m 1s
-
(Locked)
Excel in real life: House shopping5m 39s
-
(Locked)
Help find our perfect home2m 21s
-
(Locked)
Sort addresses by region1m 28s
-
(Locked)
Add a new list and line it up2m 6s
-
(Locked)
Fill in categories and sort2m 3s
-
(Locked)
Clean up bizarre formatting2m
-
(Locked)
Combine first and last names2m
-
(Locked)
Identify and move attendee data3m 20s
-
(Locked)
Get a count of possible venues2m 1s
-
(Locked)
Align and adjust text on an order form1m 24s
-
(Locked)
Format the cells in a form1m 24s
-
(Locked)
Add new participants to teams2m 21s
-
(Locked)