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

مدرس Oz du Soleil

انتشار 2018/10/05

به‌روز‌رسانی 2024/05/03

مدت زمان 15h 29m

سطح مبتدی

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

آموزش Excel Weekly Challenge

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

Microsoft Excel Spreadsheets

New This Week

Schedule the meetings ()

Introduction

Sharpen your Excel skills with hands-on practice ()

1. Excel Challenges (Oct-Dec 2018)

Add new participants to teams ()

Format the cells in a form ()

Align and adjust text on an order form ()

Get a count of possible venues ()

Identify and move attendee data ()

Combine first and last names ()

Clean up bizarre formatting ()

Fill in categories and sort ()

Add a new list and line it up ()

Sort addresses by region ()

Help find our perfect home ()

Excel in real life: House shopping ()

2. Excel Challenges (Jan-Mar 2019)

List and inspect survey results ()

Prepare this report to be printed ()

Create table of course summaries ()

Correct city names ()

Fix the pricing formula ()

Fill in pick list details ()

Create a chart of monthly complaints ()

Calculate pay based on hours and location ()

Review accuracy of invoice ()

Combine three donation lists into one ()

Group and sort inventory items ()

The expense report is wrong ()

Categorize the status of each apartment ()

Excel in real life: Auditing inventory ()

3. Excel Challenges (Apr-Jun 2019)

Count addresses ()

Leading zeroes ()

Sort and stack ()

Fix dates ()

Add a shape ()

Combo chart with secondary axis ()

Horizontal sort ()

Set up and format a workbook ()

Fix IDs ()

Protect and validate ()

Identify at least five problems with this data ()

Hide zeroes ()

Correct these calculations ()

4. Excel Challenges (Jul-Sep 2019)

What is this formula doing? ()

Pricing grid and drop-down list ()

Write a formula trigger ()

Merge and compare lists ()

Recreate this graphic ()

Insert a happy or sad face ()

Conditional formatting and sorting icons ()

Crop and print ()

Quick access and theme ()

Update graphs ()

Insert a PivotTable ()

Delete transactions and insert a PivotTable ()

5. Excel Challenges (Oct-Dec 2019)

Close holes in a list ()

QAT and pivot table ()

Unpivot and split columns ()

Presentations part 1: Randomize ()

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

Calculate team fees ()

Lookup and correct errors ()

Calculate final cost and set data validation ()

Clear excess images ()

Format workbook defaults ()

Extract all Saturdays ()

6. Excel Challenges (Jan-Mar 2020)

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

Insert a PivotTable and slicers to review workshop data ()

Use Find and Replace to correct names ()

Isolate addresses ()

Payment errors, part 1 ()

Payment errors, part 2 ()

Change chart type and create summary ()

Create drop-down lists ()

Explain this sales formula ()

Using COUNTIFS with wildcards ()

Create an index column ()

Create tables and eliminate hyperlinks ()

List the top seven donation amounts ()

7. Excel Challenges (Apr-Jun 2020)

Get data ready for a PivotTable ()

Modify a PivotTable ()

Find a Power Query result ()

Create a dynamic drop-down list ()

Filter venues with dynamic arrays ()

Find and restore missing data ()

Override names ()

Answer four questions about data ()

Protect calculations with a shape ()

Working with inventory percentages ()

Replace highlights with conditional formatting ()

Replace "Al" with "Alyssa" ()

Apply a spin button ()

8. Excel Challenges (Jul-Sep 2020)

Calculate reimbursements based on a maximum per day ()

Create a custom message in data validation ()

Change the parameters of a data validation ()

Identify multiple shifts ()

Apply conditional formatting icons ()

View a worksheet through two windows ()

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

Remove the background from an image ()

Sort this data ()

Apply formulas to new data ()

Clear the formatting in a range of cells ()

Transpose data and paste formula ()

9. Excel Challenges (Oct-Dec 2020)

Find three ways to extract the item ID ()

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

Isolate data by the week ()

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

Explain this crazy formula and test it ()

Please fix this PivotTable ()

How many paid days off are available? ()

Count flights in a matrix ()

Adjust layout ()

Sum the salmon dishes ()

Event planning formula ()

10. Excel Challenges (Jan-Mar 2021)

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

Format grid ()

Apply two conditional formatting rules ()

Tally the number of guests for a party ()

Set the footers for printing worksheets ()

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

Apply slicers and filter dataset ()

Check the quality of survey responses ()

Extract names from a dataset ()

Change icon colors ()

Create a chart and adjust the axis ()

Extract sales data ()

11. Excel Challenges (Apr-Jun 2021)

Create an order form ()

Correct and format dates ()

Curriculum audit: Accept reasonable dates ()

Create a running total ()

Convert liquids ()

Office expenses and relationships ()

IF AND OR: Identify records of interest ()

Use conditional formatting to identify top and bottom values ()

Calculate team records and break ties ()

Assign random topics to our students ()

Insert and format shapes ()

Too hot or too cold ()

12. Excel Challenges (Jul-Sep 2021)

Several lines: Just one cell ()

Distribute the sales data ()

Who's unique in this list? ()

Repeat a pattern ()

Who's on all three lists? ()

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

Goals vs. actuals ()

Calculate deadlines ()

Conditional formatting icons ()

Unpivot expenses ()

Too many characters: Count characters in a cell ()

Filter project data ()

13. Excel Challenges (Oct-Dec 2021)

Sorting up, down, left, and right ()

How many days are we open? ()

Clean up this song list ()

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

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

Prep data for a pivot table ()

Retrieve prices ()

Clean and sort this song list ()

Highlight southwest ()

Create a drop-down list from table headers ()

Summarize your progress ()

14. Excel Challenges (Jan-Mar 2022)

Troubleshoot settings for printing ()

Identify and correct completion dates ()

Append these three datasets ()

Filter with Excel's dynamic arrays ()

Find two ways to combine these cells ()

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

Build a sentence with variable inputs ()

Correct the behavior of these spin buttons ()

Identify and isolate distinct entries ()

Isolate values and build a chart ()

What's wrong with my XLOOKUP? ()

Excel Slicers: Insert, format, select ()

15. Excel Challenges (Apr-Jun 2022)

PivotTable training ()

Write a formula trigger to control calculations ()

Identify multipart last names ()

Format times and calculate pay ()

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

How much more can Kate advance? ()

Assign email addresses and check for duplicates ()

Identify five problems with this spreadsheet ()

Write a sentence with dynamic values ()

Print the entire sheet and its charts ()

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

Drop-down lists: Chairs and prices ()

16. Excel Challenges (Jul-Sep 2022)

Area chart: Up vs. down? ()

Create a PivotTable for juniors and seniors ()

Clean the source data and fix the PivotTable ()

Use the Picture Format tools to improve an image ()

Split string of IDs ()

Clean data to correct the PivotTable ()

Animated color-change emoji ()

Find the missing item numbers ()

Filter for the car ()

Spell out and sort the months ()

Use three methods to identify and count empty cells ()

Relative cell references and pricing ()

17. Excel Challenges (Oct-Dec 2022)

Change the gridlines ()

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

PJ's 10-mile run ()

Calculate the commissions based on increments of $100 ()

Correct this XLOOKUP ()

Count and sort the airport codes ()

Change the conditional formatting ()

Calculate your out-of-pocket expense ()

Highlight the odd-numbered rooms ()

Make assignments based on the last name ()

18. Excel Challenges (Jan-Mar 2023)

Sort names in Power Query ()

Identify the non-donors ()

Sort so the strikethrough values are on the bottom ()

Simplify the IF formula and create a lookup table ()

Total the emoji scores ()

Delete unneeded rows ()

Identify entries with specific day and time ()

Attendance matrix ()

Measure the response rate ()

Sort city dates ()

Attendance queries ()

Decrypt the words ()

19. Excel Challenges (Apr-Jun 2023)

How much for the beach rental? ()

Get data from image ()

Quickly answer these questions ()

Flag and delete records ()

Delete rows and split text ()

Tally the project cost ()

Accept ID or confirmation number ()

Generate random codes ()

Count the L names ()

Correct double column headers ()

Quiz! ()

Calculate total loss ()

20. Excel Challenges (Jul-Sep 2023)

Calculate the percent change ()

How many penalties can be accrued? ()

Build your own Pivot Table ()

Sort data by last name ()

List all available colors ()

Build a Venn diagram ()

Build an Event Calculator ()

Sum the total loss ()

Find the missing numbers ()

Bring contents into a single cell ()

Recycle a query to use on a different dataset ()

Paydays that fall on a weekend or holiday ()

21. Excel Challenges (Oct-Dec 2023)

Apply slicers to a review class schedule ()

Build a bar chart for program attendance ()

How many boxes can fit on this shelf? ()

Stack names with rows in between ()

Create a trivia night calendar ()

Tally top scores ()

Include filepath on print out ()

Add a picture in a PivotTable ()

Indent cells ()

Change cell borders ()

Create a logo and save it ()

Convert performer roster ()

22. Excel Challenges (Jan-Mar 2024)

Randomize 3 ways ()

Teach me XLOOKUP ()

Attendance of Mavis and Benedict ()

Book club attendance count ()

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

Identify the top five and bottom five values ()

Sort by shift ()

Set print layout ()

I know the day but need the year ()

Filtering vehicles ()

Sort pairs of columns ()

Find trends using sparklines ()

23. Excel Challenges (Apr-Jun 2024)

Highlight every third cell ()

Explain the query ()

Modify the Query ()

List the cheeses ()

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)

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

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

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

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

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

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

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