MO-201 Complete Techniques for the MOS Excel Expert Exam

سرفصل های دوره

Microsoft Excel (365/2019) Expert Certification - Comprehensive lectures, exercises and video solutions.

1 - Introduction

1 - Course Introduction

1 - MO-201-MOS-2019-Excel-Expert-Exercise-Book-v4.pdf

1 - MO-201-Objective-Domain-MOS-Uni.pdf

2 - Certiport Registration.txt

2 - Compass Interface tutorial.txt

2 - Exams from Home.txt

2 - Exams from Home Test Candidate Guide.txt

2 - How is the exam be conducted and what will it be like

2 - Official Microsoft Site for the MO201 Exam.txt

2 - Test Centre Locator.txt

3 - Domain-1-Exercise-Resources.zip

3 - Domain-2-Exercise-Resources.zip

3 - Domain-3-Exercise-Resources.zip

3 - Domain-4-Exercise-Resources.zip

3 - Extracting the Student Resource Files

4 - Try It Yourself Exercises

2 - 11 Manage Workbooks

5 - 111TIY.pdf

5 - 111 Copy Macros between Workbooks

5 - macro-version-of-marketing-budget-workbook.zip

6 - 1-pm.xlsx

6 - 9-am.xlsx

6 - 11-am.xlsx

6 - 112TIY.pdf

6 - 112 Reference Data in Other Workbooks

7 - 114TIY.pdf

7 - 114 Manage Workbook Versions

8 - 113TIY.pdf

8 - 113 Enable Macros in a Workbook

3 - 12 Prepare Workbooks for Collaboration

9 - 121 and 122 Restrict Editing and Protect Worksheets

9 - 121122TIY.pdf

9 - Hours-Worked.xlsx

10 - 123TIY.pdf

10 - 123 Protect Workbook Structure

10 - Hours-Worked.xlsx

11 - 124TIY.pdf

11 - 124 Configure Formula Calculation Options

12 - 125TIY.pdf

12 - 125 Manage Comments

12 - Comments-Workbook.xlsx

4 - 13 Use and Configure Language Options

13 - 131 and 132 Use and Configure Language Options

13 - 131132TIY.pdf

13 - macro-version-of-marketing-budget-workbook.zip

5 - 21 Fill Cells Based on Existing Data

14 - 211TIY.pdf

14 - 211 Fill Cells by using Flash Fill

14 - Staff-Records.xlsx

15 - 212TIY.pdf

15 - 212 Fill Cells by using Advanced Fill Series Options

15 - 212-Resource.xlsx

16 - 212 Clarification on Advanced Series Fill Options

6 - 22 Format and Validate Data

17 - 221.pdf

17 - 221.xlsx

17 - 221TIY.pdf

17 - 221 Create Custom Number Formats

18 - 9-am.xlsx

18 - 222TIY.pdf

18 - 222 Configure Data Validation

19 - 223 and 224 Group Ungroup and Sub Total Data

19 - 223224TIY.pdf

19 - HelpLess-Airlines-Flight-Details.xlsx

20 - 225TIY.pdf

20 - 225 Remove Duplicate Records

20 - Monthly-Revenue.xlsx

7 - 23 Apply Advanced Conditional Formatting and Filtering

21 - 231TIY.pdf

21 - 231 Create Custom Conditional Formatting Rules

21 - 231-Monthly-Revenue.xlsx

22 - 232TIY.pdf

22 - 232 Create Conditional Formatting Rules that use Formulas

22 - 232-Sales-Information.xlsx

23 - 232 TIY Explanatory Lecture

24 - 233TIY.pdf

24 - 233 Manage Conditional Formatting Rules

24 - 233-Conditions.xlsx

8 - 31 Perform Logical Operations in Formulas

25 - 311 Part 1 Perform Logical Operations by using IF and IFS Functions

25 - 311-Monthly-Revenue.xlsx

25 - 311-Part-1-TIY.pdf

26 - 311 Part 2 Perform Logical Operations by using SWITCH AND OR and NOT

26 - 311-Part-2-Sales-Information.xlsx

26 - 331-Part-2-TIY.pdf

27 - 311 Part 3 Perform Logical Operations by using SUMIF and Other Functions

27 - 311-Part-3-Sales-Information.xlsx

27 - 331-Part-3-TIY-v2.pdf

9 - 32 Look Up Data by using Functions

28 - 321 Part 1 Using the Vlookup and Hlookup Functions

29 - Hlookup Clarification Lecture

30 - 321 Part 2 Using the Match and Index Functions

31 - 321TIY.pdf

31 - 321 Part 3 Match and Index Function Structures

31 - Lookup-Functions.xlsx

10 - 33 Use Advanced Date and Time Functions

32 - 331T.pdf

32 - 331 Reference Date and Time by using the NOW and TODAY Functions

32 - 331-Functions.xlsx

33 - 332TIY.pdf

33 - 332 Calculate Dates by using the WEEKDAY and WORKDAY Functions

33 - 332-Functions.xlsx

11 - 34 Perform Data Analysis

34 - 341TIY.pdf

34 - 341 Summarise Data from Multiple Ranges by using the Consolidate Feature

34 - 341-4-pm.xlsx

34 - 341-9-am.xlsx

35 - 342TIY.pdf

35 - 342 Perform WhatIf Analysis by using Goal Seek and Scenario Manager

35 - 342-HelpLess-Charter-Scenario.xlsx

35 - 342-HelpLess-Income-Ranges.xlsx

36 - 343TIY.pdf

36 - 343 Forecast Data by using the AND IF and NPER Functions

36 - Financial-Functions.xlsx

37 - 344TIY.pdf

37 - 344 Calculate Data by using the PMT Function

12 - 35 Troubleshoot Formulas

38 - 351 Trace Precedence and Dependence

39 - 352 Monitor Cells and Formulas by using the Watch Window

40 - 353 Validate Formulas by using Error Checking Rules

41 - 35TIY.pdf

41 - 351-HelpLess-Income-Ranges.xlsx

41 - 354 Evaluate Formulas

13 - 36 Create and Modify Simple Macros

42 - 361 to 363 Part 1 Record Name and Edit Simple Macros

43 - 361TIY.pdf

43 - 361 to 363 Part 2 Record Name and Edit Simple Macros

14 - 41 Create and Modify Advanced Charts

44 - 411 Create and Modify Dual Axis Charts

44 - 411-Combo-and-Dual-Axis-Charts.xlsx

44 - 441TIY.pdf

45 - 412 Part 1 Create and Modify Charts including Box & Whisker Combo etc

45 - 412-Part-1.xlsx

45 - 412-Part-1-T.pdf

46 - 412 Part 2 Create and Modify Charts including Box & Whisker Combo etc

46 - 412-Part-2.xlsx

46 - 412-Part-2-T.pdf

47 - 412 Part 3 Create and Modify Charts including Box & Whisker Combo etc

47 - 412-Part-3.xlsx

47 - 412-Part-3-T.pdf

15 - 42 Create and Modify Pivot Tables

48 - Webinar on Pivot Tables and Charts March 11th 2021

49 - 421TIY.pdf

49 - 421 Create Pivot Tables

49 - Training-Sales.xlsx

50 - 422TIY.pdf

50 - 422 Modify Field Selections and Options

50 - Sales-Information.xlsx

51 - 423TIY.pdf

51 - 423 Create Slicers

51 - Sales-Information-Data.xlsx

52 - 424TIY.pdf

52 - 424 Group Pivot Table Data

52 - 424-Sales-Information-Data.xlsx

53 - 425 Add Calculated Fields

54 - 426 Format Data

16 - 43 Create and Modify Pivot Charts

55 - 431TIY.pdf

55 - 431 Create PivotCharts

55 - 431-Training-Sales.xlsx

56 - 432TIY.pdf

56 - 432 Manipulate Options in Existing PivotCharts

56 - 432-Training-Sales.xlsx

57 - 433 Apply Styles to PivotCharts

58 - 434TIY.pdf

58 - 434 Drill Down into PivotChart Details

58 - 434-Training-Sales.xlsx

17 - Exercise Book Solution Videos

59 - Objective Domain 1 Exercise Solutions

60 - Objective Domain 2 Exercise Solutions

61 - Objective Domain 3 Exercise Solutions

62 - Objective Domain 4 Exercise Solutions

18 - MO201 Practice Exam and Video Solutions

63 - How to use the Practice Exam

64 - Exam 1 Project 1

64 - exam-1-project-1.zip

65 - Exam 1 Project 2

65 - exam-1-project-2.zip

66 - Exam 1 Project 3

66 - exam-1-project-3.zip

67 - Exam 1 Project 4

67 - exam-1-project-4.zip

68 - Exam 1 Project 5

68 - exam-1-project-5.zip

19 - Bonus Lecture

69 - Bonus Lecture MOS University

69 - MOS University Facebook Home.txt

69 - MOS University Private Facebook Group.txt

69 - MOS University Website.txt

69 - MOS University YouTube Channel.txt

70 - Bonus Lecture About MOS University

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training