چالش هفتگی اکسل

مدرس Oz du Soleil

انتشار 2018/10/05

به‌روز‌رسانی 2025/02/07

مدت زمان 17h 48m

سطح مبتدی

فایل تمرینی دارد

آموزش Excel Weekly Challenge

کتاب ها و دوره های بی شماری وجود دارد که مایکروسافت اکسل را آموزش می دهند. با این حال، تسلط واقعی نیاز به تمرین دارد. شما باید آنچه را که یاد گرفته اید به کار ببرید تا بتوانید آن را ثابت کنید. این مجموعه با Excel MVP Oz du Soleil، چالش‌های هفتگی اکسل را برگرفته از تجربه Oz ارائه می‌کند و به مشتریان با مشکلات دنیای واقعی کمک می‌کند. هر ویدیو با چالشی مانند قالب بندی سلولی متناقض، موارد خط تکراری یا داده های ناقص شروع می شود. ویدیو را مکث کنید و فایل تمرین مربوطه را دانلود کنید تا راه حل خود را با استفاده از ویژگی های قدرتمند ساخته شده در اکسل حل کنید. وقتی آماده شدید، می‌توانید ویدیو را دوباره راه‌اندازی کنید تا ببینید اوز چگونه چالش را حل می‌کند. تنها در چند دقیقه در هفته، می توانید محبوب ترین و مفیدترین فرمول ها، توابع و ویژگی های اکسل را بیاموزید. هر جمعه برای یک تکنیک جدید هماهنگ شوید.توجه: از آنجایی که این سریال در حال انجام است، بینندگان گواهی پایان کار دریافت نخواهند کرد.

Microsoft Excel Spreadsheets

New This Week

Group and save as picture ()

Introduction

Sharpen your Excel skills with hands-on practice ()

Previous Episodes

Universal pizza toppings ()

Identify and tally the useful surveys ()

Filter multiple criteria ()

Identify two ways to tally the top three ()

Insert a variable dropdown list ()

Calculate the population changes ()

Add address street numbers ()

Identify specific donors ()

Review data for Power Query ()

Build a grid of fake data for training ()

Count employees with five or more years ()

Count employees, interns, and contractors ()

Identify interns and contractors ()

Choose preferred names ()

Find Valerie in the roster ()

Using checkmarks to check progress ()

Numbers that add to 11 ()

Determine the new player lineup ()

Calculate overtime ()

Find the top three ()

Color choices ()

Revenue share ()

November advances ()

Round winners ()

Win-loss record ()

Graph the population ()

Home scores ()

Payment tracking ()

Flip the zone ()

Sort by last name ()

Build a table ()

Flip this dataset ()

Control and identify worksheet entries ()

Convert range to table references ()

Filter by three criteria ()

Append three datasets ()

Modify the query ()

Randomize three ways ()

Schedule the meetings ()

List the cheeses ()

Explain the query ()

Highlight every third cell ()

Find trends using sparklines ()

Sort pairs of columns ()

Filtering vehicles ()

I know the day but need the year ()

Set print layout ()

Sort by shift ()

Identify the top five and bottom five values ()

Create a 12x10 block of numbers with no duplicates ()

Book club attendance count ()

Attendance of Mavis and Benedict ()

Teach me XLOOKUP ()

Convert performer roster ()

Create a logo and save it ()

Change cell borders ()

Indent cells ()

Add a picture in a PivotTable ()

Include filepath on print out ()

Tally top scores ()

Create a trivia night calendar ()

Stack names with rows in between ()

How many boxes can fit on this shelf? ()

Build a bar chart for program attendance ()

Apply slicers to a review class schedule ()

Paydays that fall on a weekend or holiday ()

Recycle a query to use on a different dataset ()

Bring contents into a single cell ()

Find the missing numbers ()

Sum the total loss ()

Build an Event Calculator ()

Build a Venn diagram ()

List all available colors ()

Sort data by last name ()

Build your own Pivot Table ()

How many penalties can be accrued? ()

Calculate the percent change ()

Calculate total loss ()

Quiz! ()

Correct double column headers ()

Count the L names ()

Generate random codes ()

Accept ID or confirmation number ()

Tally the project cost ()

Delete rows and split text ()

Flag and delete records ()

Quickly answer these questions ()

Get data from image ()

How much for the beach rental? ()

Decrypt the words ()

Attendance queries ()

Sort city dates ()

Measure the response rate ()

Attendance matrix ()

Identify entries with specific day and time ()

Delete unneeded rows ()

Total the emoji scores ()

Simplify the IF formula and create a lookup table ()

Sort so the strikethrough values are on the bottom ()

Identify the non-donors ()

Sort names in Power Query ()

Make assignments based on the last name ()

Highlight the odd-numbered rooms ()

Calculate your out-of-pocket expense ()

Change the conditional formatting ()

Count and sort the airport codes ()

Correct this XLOOKUP ()

Calculate the commissions based on increments of $100 ()

PJ's 10-mile run ()

Modify this two-way lookup formula to fit your data ()

Change the gridlines ()

Relative cell references and pricing ()

Use three methods to identify and count empty cells ()

Spell out and sort the months ()

Filter for the car ()

Find the missing item numbers ()

Animated color-change emoji ()

Clean data to correct the PivotTable ()

Split string of IDs ()

Use the Picture Format tools to improve an image ()

Clean the source data and fix the PivotTable ()

Create a PivotTable for juniors and seniors ()

Area chart: Up vs. down? ()

Format times and calculate pay ()

Identify multipart last names ()

Write a formula trigger to control calculations ()

PivotTable training ()

Drop-down lists: Chairs and prices ()

What's the revenue based on revenue share? ()

Print the entire sheet and its charts ()

Write a sentence with dynamic values ()

Identify five problems with this spreadsheet ()

Assign email addresses and check for duplicates ()

How much more can Kate advance? ()

After ten rounds, which is the winning team? ()

Excel Slicers: Insert, format, select ()

What's wrong with my XLOOKUP? ()

Isolate values and build a chart ()

Identify and isolate distinct entries ()

Correct the behavior of these spin buttons ()

Build a sentence with variable inputs ()

Who gets paid this month, and who doesn't? ()

Find two ways to combine these cells ()

Filter with Excel's dynamic arrays ()

Append these three datasets ()

Identify and correct completion dates ()

Troubleshoot settings for printing ()

Summarize your progress ()

Create a drop-down list from table headers ()

Highlight southwest ()

Clean and sort this song list ()

Retrieve prices ()

Prep data for a pivot table ()

What's going up and what's going down? ()

Sorting this column isn't working–what's wrong? ()

Clean up this song list ()

How many days are we open? ()

Sorting up, down, left, and right ()

Filter project data ()

Too many characters: Count characters in a cell ()

Unpivot expenses ()

Conditional formatting icons ()

Calculate deadlines ()

Goals vs. actuals ()

Show me how to make a drop-down list ()

Who's on all three lists? ()

Repeat a pattern ()

Who's unique in this list? ()

Distribute the sales data ()

Several lines: Just one cell ()

Too hot or too cold ()

Insert and format shapes ()

Assign random topics to our students ()

Calculate team records and break ties ()

Use conditional formatting to identify top and bottom values ()

IF AND OR: Identify records of interest ()

Office expenses and relationships ()

Convert liquids ()

Create a running total ()

Curriculum audit: Accept reasonable dates ()

Correct and format dates ()

Create an order form ()

Extract sales data ()

Create a chart and adjust the axis ()

Change icon colors ()

Extract names from a dataset ()

Check the quality of survey responses ()

Apply slicers and filter dataset ()

Who failed one exam or the other, but not both? ()

Set the footers for printing worksheets ()

Tally the number of guests for a party ()

Apply two conditional formatting rules ()

Format grid ()

What's the deal with these payroll calculations? ()

Event planning formula ()

Sum the salmon dishes ()

Adjust layout ()

Count flights in a matrix ()

How many paid days off are available? ()

Please fix this PivotTable ()

Explain this crazy formula and test it ()

TJ's arts and crafts: How can we improve this workbook? ()

Isolate data by the week ()

Write a formula from nothing and create your own data ()

Find three ways to extract the item ID ()

Transpose data and paste formula ()

Clear the formatting in a range of cells ()

Apply formulas to new data ()

Sort this data ()

Calculate reimbursements based on a maximum per day ()

Remove the background from an image ()

Correct dates to show the weekday, day, month, and year ()

View a worksheet through two windows ()

Apply conditional formatting icons ()

Identify multiple shifts ()

Change the parameters of a data validation ()

Create a custom message in data validation ()

Apply a spin button ()

Replace "Al" with "Alyssa" ()

Replace highlights with conditional formatting ()

Working with inventory percentages ()

Protect calculations with a shape ()

Answer four questions about data ()

Override names ()

Find and restore missing data ()

Filter venues with dynamic arrays ()

Create a dynamic drop-down list ()

Find a Power Query result ()

Modify a PivotTable ()

Get data ready for a PivotTable ()

List the top seven donation amounts ()

Create tables and eliminate hyperlinks ()

Create an index column ()

Using COUNTIFS with wildcards ()

Explain this sales formula ()

Create drop-down lists ()

Change chart type and create summary ()

Payment errors, part 2 ()

Payment errors, part 1 ()

Isolate addresses ()

Use Find and Replace to correct names ()

Insert a PivotTable and slicers to review workshop data ()

Copy to a new workbook and save as a PDF ()

Extract all Saturdays ()

Format workbook defaults ()

Clear excess images ()

Calculate final cost and set data validation ()

Lookup and correct errors ()

Calculate team fees ()

Presentations part 2: What day is each person presenting? ()

Presentations part 1: Randomize ()

Unpivot and split columns ()

QAT and pivot table ()

Close holes in a list ()

Delete transactions and insert a PivotTable ()

Insert a PivotTable ()

Update graphs ()

Quick access and theme ()

Crop and print ()

Conditional formatting and sorting icons ()

Insert a happy or sad face ()

Recreate this graphic ()

Merge and compare lists ()

Write a formula trigger ()

Pricing grid and drop-down list ()

What is this formula doing? ()

Correct these calculations ()

Hide zeroes ()

Identify at least five problems with this data ()

Protect and validate ()

Fix IDs ()

Count addresses ()

Set up and format a workbook ()

Horizontal sort ()

Combo chart with secondary axis ()

Add a shape ()

Fix dates ()

Sort and stack ()

Leading zeroes ()

Excel in real life: Auditing inventory ()

Categorize the status of each apartment ()

The expense report is wrong ()

Group and sort inventory items ()

Combine three donation lists into one ()

Review accuracy of invoice ()

Calculate pay based on hours and location ()

Create a chart of monthly complaints ()

Fill in pick list details ()

Fix the pricing formula ()

Correct city names ()

Create table of course summaries ()

List and inspect survey results ()

Prepare this report to be printed ()

Excel in real life: House shopping ()

Help find our perfect home ()

Sort addresses by region ()

Add a new list and line it up ()

Fill in categories and sort ()

Clean up bizarre formatting ()

Combine first and last names ()

Identify and move attendee data ()

Get a count of possible venues ()

Align and adjust text on an order form ()

Format the cells in a form ()

Add new participants to teams ()

01_01_Add_new_participants_to_teams.zip (10 KB)

01_04_Get_a_count_of_possible_venues.zip (92 KB)

07_06_Find_and_restore_the_missing_data.zip (14 KB)

07_07_Override_names.zip (9 KB)

07_10_Show_percentages.zip (241 KB)

07_03_Power_query_result.zip (14 KB)

07_12_Replace.zip (9 KB)

07_11_Replace_highlights.zip (10 KB)

07_13_Add_a_spin_button.zip (12 KB)

07_08_Quiz.zip (10 KB)

07_01_Get_data_ready_for_a_pivot_table.zip (9 KB)

07_05_Dynamic_array_filter_venues.zip (9 KB)

07_04_Create_a_dynamic_dropdown_list.zip (17 KB)

07_09_Protect_formulas_with_a_shape.zip (17 KB)

07_02_Modify_this_pivot_table.zip (17 KB)

06_07_Change_chart_type_and_create_summary.zip (13 KB)

06_12_Create_tables_and_eliminate_hyperlinks.zip (11 KB)

06_05_Payment_errors_part_1.zip (10 KB)

06_08_Create_dropdown_lists.zip (9 KB)

06_04_Isolate_addresses.zip (30 KB)

06_13_List_the_top_7_donation_amounts.zip (9 KB)

06_03_Use_Find_Replace_to_correct_names.zip (10 KB)

06_10_Using_COUNTIFS_with_wildcards.zip (8 KB)

06_11_Create_an_index_column.zip (8 KB)

06_01_Copy_to_a_new_workbook_and_save_as_PDF.zip (13 KB)

06_09_Explain_this_sales_formula.zip (15 KB)

06_02_Insert_pivot_table_and_slicers_to_review_workshops.zip (10 KB)

06_01.zip (13 KB)

06_06_Payment_errors_part_2.zip (10 KB)

05_06_Calculate_team_fees.zip (9 KB)

08_10_Apply_formulas.zip (11 KB)

08_03_Identify_multiple_shifts.zip (9 KB)

10_07_Slicers.zip (190 KB)

10_06_Exams.zip (10 KB)

10_08_Survey.zip (10 KB)

10_02_Format_grid.zip (9 KB)

10_05_Footers.zip (28 KB)

10_04_Guest_Count.zip (191 KB)

09_11_Event_Planning_Formula.zip (9 KB)

09_03_Isolate_data_by_the_week.zip (15 KB)

09_07_Calculate_PTO_Available.zip (10 KB)

09_05_Explain_and_test_this_formula.zip (11 KB)

09_09_Adjust_layout_and_set_conditional_formatting.zip (404 KB)

09_06_Please_fix_this_pivot_table.zip (274 KB)

08_04_Conditional_Formatting_Icons.zip (9 KB)

09_02_Write_a_formula_from_scratch.zip (9 KB)

09_01_Find_3_ways_to_extract_this_data.zip (8 KB)

09_08_Flight_Counts.zip (10 KB)

09_04_Arts_and_Crafts.zip (317 KB)

08_05_Two_windows.zip (16 KB)

08_02_Modify_Data_Validation.zip (9 KB)

08_08_Calculate_reimbursements.zip (16 KB)

08_12_Transpose_and_format_data.zip (11 KB)

08_06_Correct_dates.zip (13 KB)

08_11_Clear_all_content_and_formatting.zip (11 KB)

08_01_Create_a_custom_data_validation_alert.zip (72 KB)

08_09_Fix_and_sort.zip (9 KB)

08_07_Remove_image_background.zip (513 KB)

09_10_Sum_the_salmon_dishes.zip (1.2 MB)

10_03_Conditional_Formatting.zip (9 KB)

05_10_Format_workbook_defaults.zip (8 KB)

05_07_Lookup_and_correct_errors.zip (9 KB)

03_11_Find_duplicate_records.zip (8 KB)

03_04_Add_a_shape.zip (10 KB)

02_14_Excel_in_real_life_-_Auditing_inventory.zip (102 KB)

02_13_Categorize_the_status_of_each_apartment.zip (102 KB)

02_12_The_expense_report_is_wrong.zip (102 KB)

02_11_Group_and_sort_inventory_items.zip (102 KB)

02_10_Combine_3_donations_lists_into_1.zip (102 KB)

02_09_Review_accuracy_of_invoice.zip (102 KB)

02_08_Calculate_pay_based_on_hours_and_location.zip (102 KB)

02_07_Create_a_chart_of_monthly_complaints.zip (102 KB)

02_06_Fill_in_pick-list_details.zip (102 KB)

02_05_Fix_the_pricing_formula.zip (102 KB)

03_09_Fix_IDs.zip (10 KB)

02_04_Correct_city_names.zip (102 KB)

02_02_List_and_inspect_survey_results.zip (102 KB)

02_01_Prepare_this_report_to_be_printed.zip (102 KB)

01_12_Excel_in_Real_Life_1_House_Shopping.zip (31 KB)

01_11_Help_find_our_perfect_house.zip (10 KB)

01_10_Sort_Addresses_by_Region.zip (10 KB)

01_09_Add_a_new_list_and_line_it_up.zip (10 KB)

01_08_Fill_in_categories_and_sort.zip (10 KB)

01_07_Clean_up_bizarre_formatting.zip (655 KB)

01_06_Combine_first_last_names.zip (92 KB)

01_05_Identify_and_move_attendee_data.zip (10 KB)

01_02_Format_the_cells_in_a_form.zip (10 KB)

01_03_Align_and_adjust_text_on_an_order_form.zip (10 KB)

02_03_Create_table_of_course_summaries.zip (102 KB)

05_01_Close_holes_in_a_list.zip (9 KB)

03_07_Setup_and_format_workbook.zip (17 KB)

03_08_Count_addresses.zip (9 KB)

05_02_QAT_and_Pivot_Table.zip (10 KB)

05_03_Unpivot_and_split_columns.zip (13 KB)

05_08_Calculate_final_cost.zip (10 KB)

05_09_Clear_excess_images.zip (147 KB)

05_04_Presentations_Part_1_Randomize.zip (10 KB)

05_11_Extract_all_Saturdays.zip (11 KB)

04_12_Delete_transactions_and_insert_pivot_table.zip (10 KB)

04_11_Insert_a_pivot_table.zip (3.9 MB)

04_05_Recreate_this_graphic.zip (77 KB)

04_08_Crop_and_print.zip (390 KB)

04_03_Write_a_formula_trigger.zip (12 KB)

03_03_Fix_dates.zip (10 KB)

04_07_Conditional_format_and_sort_icons.zip (14 KB)

04_06_Insert_happy_or_sad_face.zip (14 KB)

04_04_Merge_and_compare_lists.zip (570 KB)

04_09_Quick_access_and_theme.zip (13 KB)

04_02_Pricing_grid_and_dropdown_list.zip (11 KB)

04_01_What_is_this_formula_doing.zip (12 KB)

03_12_Hide_zeroes.zip (13 KB)

03_10_Protect_and_validate.zip (11 KB)

03_01_Leading_zeroes.zip (9 KB)

03_05_Combo_chart_with_secondary_axis.zip (9 KB)

03_13_Correct_these_calculations.zip (13 KB)

03_02_Stack_and_sort.zip (9 KB)

03_06_Horizonal_sort.zip (9 KB)

04_10_Update_graphs.zip (589 KB)

10_01_Payroll.zip (18 KB)

10_09_Extract_Names.zip (15 KB)

05_05_Presentations_Part_2_What_day_is_each_person_presenting.zip (12 KB)

10_10_Change_the_colors.zip (43 KB)

10_11_Chart_Axis.zip (16 KB)

10_12_Extract_Sales_Data.zip (15 KB)

11_01_Order_form.zip (10 KB)

11_02_Correct_and_format_dates.zip (10 KB)

11_03_Curriculum_audit.zip (10 KB)

11_04_Create_a_running_total.zip (10 KB)

11_05_Convert_liquids.zip (389 KB)

11_06_Office_expenses.zip (10 KB)

11_07_If.zip (11 KB)

11_08_Top_Bottom.zip (9 KB)

11_09_Calculate_team.zip (774 KB)

11_10_Topics_for_Students.zip (10 KB)

11_11_Shapes.zip (9 KB)

11_12_Hot_or_cold.zip (9 KB)

12_01_OneCell.zip (9 KB)

12_02_Sales_Data.zip (11 KB)

12_03_Unique.zip (12 KB)

12_04_Repeat.zip (8 KB)

12_05_Three_Lists.zip (12 KB)

12_06_Dropdown.zip (8 KB)

12_07_Goal_Actual.zip (1.1 MB)

12_08_Deadlines.zip (3.3 MB)

12_09_Icons.zip (1.9 MB)

12_10_Unpivot.zip (42 KB)

12_11_Count_Characters.zip (161 KB)

12_12_Filter_Project.zip (9 KB)

13_01_Sort_Left_Right_Up_Down.zip (130 KB)

13_02_Days_Open.zip (1.6 MB)

13_03_Clean_this_list.zip (453 KB)

13_04_Sort_High_School_Data.zip (9 KB)

13_05_Area_Chart.zip (10 KB)

13_06_Fishing_Pivot_Table.zip (20 KB)

13_07_Retrieve_prices.zip (12 KB)

13_08_Clean_and_sort_this_song_list.zip (626 KB)

13_09_Highlight_southwest.zip (421 KB)

13_10_Dropdown_from_Table_Headers.zip (136 KB)

13_11_Summarize_your_progress.zip (63 KB)

14_01_This_printout_is_weird.zip (28 KB)

14_02_Adjust_the_due_dates.zip (157 KB)

14_03_Append_these_3_datasets.zip (18 KB)

14_04_Filter_projects.zip (9 KB)

14_05_Merge_columns_2_ways.zip (12 KB)

14_06_Who_gets_paid.zip (154 KB)

14_07_Build_a_statement.zip (10 KB)

14_08_Spin_buttons.zip (305 KB)

14_09_Count_Functions.zip (16 KB)

14_10_Summarize_and_create_chart.zip (9 KB)

14_11_This_lookup_doesnt_work.zip (661 KB)

14_12_Slicers.zip (20 KB)

15_01_10_rounds_2_teams_who_won.zip (57 KB)

15_02_Calculate_Kates_maximum_advance.zip (10 KB)

15_03_Assign_Emails.zip (78 KB)

15_04_Identify_5_problems.zip (1.4 MB)

15_05_Monitor_capacity.zip (846 KB)

15_06_Correct_the_printing_of_this_document.zip (17 KB)

15_07_Revenue_Share.zip (9 KB)

15_08_Dropdown_lists_chairs_and_prices.zip (1.0 MB)

15_09_Pivot_table_training.zip (772 KB)

21_04_Insert_rows.zip (58 KB)

21_03_Boxes_on_a_shelf.zip (181 KB)

21_02_Build_a_bar_chart.zip (25 KB)

21_01_Applying_slicers.zip (40 KB)

20_12_Paydays_and_Holidays.zip (73 KB)

20_11_Recycle_a_query_in_Power_Query.zip (43 KB)

20_10_Bring_contents_into_a_single_cell.zip (22 KB)

20_09_Find_the_missing_numbers.zip (462 KB)

20_08_Sum_the_net_loss.zip (77 KB)

20_07_Event_Calculator.zip (83 KB)

20_06_Build_a_Venn_diagram.zip (81 KB)

20_05_List_all_of_the_colors.zip (144 KB)

20_04_Sort_by_Last_Name.zip (155 KB)

20_03_Build_your_own_Pivot_Table.zip (217 KB)

20_02_Times_and_penalties.zip (27 KB)

20_01_Calculate_the_percent_change.zip (9 KB)

19_12_Calculate_total_loss.zip (41 KB)

19_11_Quiz.zip (14 KB)

19_10_Double_headers.zip (11 KB)

21_05_Trivia_night_calendar.zip (39 KB)

19_09_Count_the_letter_L.zip (166 KB)

21_06_Tally_top_scores.zip (46 KB)

21_08_Add_picture_in_pivot_table.zip (852 KB)

23_03_Modify_the_Query.zip (18 KB)

23_02_Explain_The_Query.zip (15 KB)

23_01_CF_Highlight_Every_3rd_cell.zip (8 KB)

22_12_Workshop_Trends.zip (393 KB)

22_11_Sort_Pairs_of_Columns.zip (9 KB)

22_10_Dropdown_and_Filter_Cars.zip (85 KB)

22_09_I_Know_The_Day_But_Need_The_Year.zip (237 KB)

22_08_Set_Print_Layout.zip (188 KB)

22_07_Sort_by_Shift.zip (39 KB)

22_06_Conditional_Formatting_Scores.zip (79 KB)

22_05_Create_a_block_of_numbers.zip (9 KB)

22_04_Book_Club_Attendance.zip (199 KB)

22_03_Book_Club_Mavis_and_Benedict.zip (201 KB)

22_02_Teach_Me_XLOOKUP.zip (50 KB)

22_01_Randomize_Names_3_Ways.zip (236 KB)

21_12_Convert_performer_roster.zip (103 KB)

21_11_Make_a_logo.zip (9 KB)

21_10_Change_cell_borders.zip (32 KB)

21_09_Indent_cells.zip (10 KB)

21_07_Filepath.zip (65 KB)

23_04_List_the_Cheeses.zip (46 KB)

19_08_Generate_random_codes.zip (9 KB)

19_06_Project_cost.zip (186 KB)

17_04_Calculate_commissions_based_on_agreement.zip (49 KB)

17_03_PJ_10_mile_run.zip (42 KB)

17_02_Modify_this_2_way_lookup_formula.zip (10 KB)

17_01_Change_gridlines.zip (52 KB)

16_12_Relative_cells_references_and_pricing.zip (9 KB)

16_11_Count_the_empty_cells.zip (9 KB)

16_10_Spell_out_the_months_and_sort.zip (10 KB)

16_09_Find_the_cars.zip (607 KB)

16_08_Missing_inventory.zip (73 KB)

16_07_Automated_color_changing_emoji.zip (11 KB)

16_06_Clean_the_pivot_table_data.zip (12 KB)

16_05_Split_the_string_of_IDs.zip (9 KB)

16_04_Picture_formatting_to_improve_a_presentation.zip (1.3 MB)

16_03_Please_fix_this_pivot_table.zip (13 KB)

16_02_Create_a_pivot_table_for_the_juniors_and_seniors.zip (179 KB)

16_01_Area_chart.zip (9 KB)

15_12_Format_the_times_and_calculate_pay.zip (210 KB)

15_11_Identify_Multi_part_names.zip (9 KB)

15_10_Formula_triggers_and_totals.zip (690 KB)

17_05_Correct_the_XLOOKUP.zip (66 KB)

19_07_Retrieve_the_name_and_genre.zip (130 KB)

17_06_Airport_Count.zip (148 KB)

17_08_Out_of_pocket_expenses.zip (49 KB)

19_05_Delete_rows.zip (10 KB)

19_04_Flag_and_Delete.zip (9 KB)

19_03_Quickly_answer_these_questions..zip (165 KB)

19_02_Get_data_from_an_image.zip (829 KB)

19_01_How_much_is_owed_for_the_beach_house.zip (772 KB)

18_12_Decode_the_words.zip (24 KB)

18_11_Attendance_queries.zip (76 KB)

18_10_Sort_city_dates.zip (446 KB)

18_09_Measure_the_response_rate.zip (99 KB)

18_08_Attendance_matrix.zip (124 KB)

18_07_Day_and_Time.zip (7 KB)

18_06_Delete_unneeded_rows.zip (10 KB)

18_05_Total_the_emoji_scores.zip (9 KB)

18_04_Simplify_the_IF.zip (10 KB)

18_03_Sort_the_strikethroughs.zip (421 KB)

18_02_Identify_the_non_donors.zip (99 KB)

18_01_Sort_names_in_Power_Query.zip (334 KB)

17_10_Make_Room_Assignments.zip (445 KB)

17_09_Identify_the_eastside_apartments.zip (210 KB)

17_07_Modify_the_Conditional_Formatting.zip (35 KB)

23_05_Schedule_The_Meetings.zip (70 KB)

23_06_Append_3_Datasets.zip (10 KB)

25_2_Check_Progress.zip (71 KB)

25_3_Find_Valerie.zip (9 KB)

25_4_Make_Names.zip (9 KB)

25_5_ID_Interns_Contractors.zip (8 KB)

25_6_Count_Interns_Contractors.zip (8 KB)

25_7_Count_5_Years_or_More.zip (84 KB)

25_8_Build_Grid.zip (455 KB)

25_9_Review_Data.zip (192 KB)

25_10_ID_Donors.zip (200 KB)

25_11_Add_Addresses.zip (628 KB)

25_12_Population_Change.zip (300 KB)

26_1_County_Dropdown_List.zip (32 KB)

26_2_Calculate_Top_3.zip (42 KB)

26_3_Filter_Counties.zip (35 KB)

26_4_Useful_Surveys.zip (36 KB)

25_1_Numbers_Adding_Up_to_11.zip (769 KB)

26_5_Pizza_Toppings.zip (112 KB)

Lineup_Order.zip (177 KB)

Find_the_Top_3.zip (98 KB)

23_07_Filter_By_3_Criteria.zip (189 KB)

23_08_Convert_From_Range_to_Table_References.zip (97 KB)

23_09_Control_Worksheet_Entries.zip (9 KB)

23_10_Flip_This_Dataset.zip (139 KB)

23_11_Build_A_Table.zip (56 KB)

23_12_Sort_By_Last_Name.zip (12 KB)

Flip_the_Zone.zip (172 KB)

Payment_Tracking.zip (291 KB)

Home_Scores.zip (639 KB)

Graph_the_Population.zip (402 KB)

Win_Loss_Record.zip (639 KB)

Round_Winners.zip (99 KB)

November_Advances.zip (10 KB)

Revenue_Share.zip (9 KB)

Color_Choices.zip (104 KB)

Calculate_Overtime.zip (204 KB)

26_6_Group_and_Save.zip (64 KB)

دانلود فایل فشرده

با توجه به امکانات آموزش و همچنین امکانات بسته انتخاب شده لینک دانلود فایل فشرده آماده خواهد شد. با در نظر داشتن این شرایط لطفا بسته مورد نظر خود را انتخاب کرده و روی دکمه درخواست لینک دانلود کلیک کنید

در حال به روزرسانی اطلاعات

درخواست لینک دانلود

در حال به روزرسانی اطلاعات

لطفا قبل از فعالسازی لینک دانلود به موارد زیر توجه کنید:

پسورد فایل‌های فشرده است.
لینک‌های آماده شده تا 8 روز پس از فعالسازی منقضی خواهند شد.
حجم فایل‌ها تخمینی هستند.
در صورتی که لینک دانلود تا 15دقیقه پس از درخواست آماده نشد، از بخش پشتیبانی پیگیری نمایید.