77-728 Microsoft Excel 2016 Expert Certification

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

77-728 Microsoft Certified Excel Expert - includes lectures, test exercises and video solutions PLUS Practice Exam

1 - Introduction

1 - Introduction

2 - March-2021-Objective-domain-Excel-Expert.pdf

2 - Understanding the Objective Domain

3 - COVID19 Testing Arrangements Exams From Home.txt

3 - Certiport Testing Centre Locator.txt

3 - Certiport Tutorial.txt

3 - Console 8 Testing Interface.txt

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

3 - MOS Expert Excel Microsoft Information.txt

3 - Microsoft Official MOS Site.txt

4 - Try It Yourself Exercises

2 - 11 Manage Workbooks

5 - 111T.pdf

5 - 111 Save a Workbook as a Template

6 - 112.pdf

6 - 112 Copy Macros between Workbooks

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

7 - 1-pm.xlsx

7 - 9-am.xlsx

7 - 11-am.xlsx

7 - 113TIY.pdf

7 - 113 Reference Data in Another Workbook

8 - 1.1.4-Structured-References.pdf

8 - 114 Reference Data by using Structured References

9 - 115TIY.pdf

9 - 115 Enable Macros in a Workbook

10 - 116TIY.pdf

10 - 116 Display Hidden Ribbon Tabs

3 - 12 Manage Workbook Review

11 - 121 Restrict Editing

12 - 122 Protect a Worksheet

12 - 121122TIY.pdf

12 - Hours-Worked.xlsx

13 - 123TIY.pdf

13 - 123 Configure Formula Calculation Options

13 - Hours-Worked.xlsx

14 - 124TIY.pdf

14 - 124 Protect Workbook Structure

15 - 125TIY.pdf

15 - 125 Manage Workbook Versions

16 - 126TIY.pdf

16 - 126 Encrypt a Workbook with a Password

4 - Objective Domain 1 Exercises & Solutions

17 - Domain Objective 1 Manage Workbook Options and Settings Exercises & Solutions

17 - HelpLess-Airlines-Passenger-Numbers.xlsx

17 - Objective-Domain-1-Exercises.pdf

17 - Sales-Information-Data.xlsx

5 - 21 Apply Custom Data Formats and Validation

18 - 2.1.1-Custom-Number-Formats.pdf

18 - 211.xlsx

18 - 211TIY.pdf

18 - 211 Create Custom Number Formats

19 - 212TIY.pdf

19 - 212 Populate Cells by using Advanced Fill Series Options

19 - 212-Resource.xlsx

20 - 9-am.xlsx

20 - 213TIY.pdf

20 - 213 Configure Data Validation

6 - 22 Apply Advanced Conditional Formatting and Filtering

21 - 221TIY.pdf

21 - 221 Create Custom Conditional Formatting Rules

21 - 221-Monthly-Revenue.xlsx

22 - 222TIY.pdf

22 - 222 Create Conditional Formatting Rules that use Formulas

22 - 222-Sales-Information.xlsx

22 - Excel-workbook-for-2.2.2-Conditional-formatting-rules-that-use-formulas.xlsx

22 - Monthly-Revenue.xlsx

23 - 222 TIY Explanatory Lecture

24 - 223TIY.pdf

24 - 223 Manage Conditional Formatting Rules

24 - 223-Conditions.xlsx

7 - 23 Create and Modify Custom Workbook Elements

25 - 231 Create Custom Colour Formats

26 - 232 Create and Modify Cell Styles

27 - 233 Create and Modify Custom Themes

28 - 234 Part I Create and Modify Simple Macros

29 - 234 Part II Create and Modify Simple Macros

30 - 235 Part I Insert and Configure Form Controls

31 - 2.3.5-Part-II-HelpLess-Airlines-Query-Form.pdf

31 - 235 Part II Insert and Configure Form Controls

31 - Template-for-Part-II-Insert-and-Configure-From-Controls.xlsx

32 - 235 Part III Insert and Configure Form Controls

8 - 24 Prepare a Workbook for Internationalisation

33 - 241 and 242 Display Data in Multiple International Formats

34 - 243 Manage Multiple Options for Body and Heading Fonts

9 - Domain Objective 2 Exercises & Solutions

35 - Domain Objective 2 Apply Custom Data Formats and Layouts Exercises & Solutions

35 - HelpLess-Airlines-Marketing-Plan-2017-to-2022.xlsx

35 - Objective-Domain-2-Exercises.pdf

35 - Sales-Information-Data.xlsx

10 - 31 Apply Functions in Formulas

36 - 311 Perform Logical Operations by using AND OR and NOT Functions

36 - HelpLess-Nested.xlsx

36 - Sales-Information.xlsx

37 - 312 Perform Logical Operations by using Nested Functions

38 - 313 Perform Statistical Operations by using SUMIFS AVERAGEIFS and COUNTIFS

11 - 32 Look Up Data by using Functions

39 - 321 and 322 Look Up Data by using the VLOOKUP & HLOOKUP Functions

40 - Hlookup Clarification Lecture

41 - 323 Look Up Data by using the INDEX and MATCH Functions

41 - 321234TIY.pdf

41 - Lookup-Functions.xlsx

12 - 33 Apply Advanced Date and Time Functions

42 - 331TIY.pdf

42 - 331 & 2 NOW TODAY Functions and Serialise Numbers

42 - 331-Functions.xlsx

13 - 34 Perform Data Analysis and Business Intelligence

43 - Introduction to Domain Objective 34

44 - 341 Part I Connecting to Data with Power Pivot

45 - 341 Part II More on Power Pivot

46 - 341 Part III Measures

47 - 341 Part IV Get and Transform

48 - 342TIY.pdf

48 - 342 Consolidate Data

48 - 342-4-pm.xlsx

48 - 342-9-am.xlsx

49 - 343TIY.pdf

49 - 343 Perform Whatif Analysis by using Goal Seek and Scenario Manager

49 - 343-HelpLess-Charter-Scenario.xlsx

49 - 343-HelpLess-Income-Ranges.xlsx

50 - 344 Cube Functions Part I

51 - 344 Cube Functions Part II

52 - 344 Cube Functions Part III

53 - 345TIY.pdf

53 - 345 Calculate Data by using Financial Functions

14 - 35 Troubleshoot Formulas

54 - 351 Trace Precedence and Dependence

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

56 - 353 Validate Formulas by using Error Checking Rules

57 - 351-HelpLess-Income-Ranges.xlsx

57 - 354 Evaluate Formulas

57 - 351234TIY.pdf

15 - 36 Define Named Ranges and Objects

58 - 361 and 362 Name Cells and Data Ranges

59 - 363 Name Tables

60 - 364 Manage Named Ranges and Objects

60 - 361234.xlsx

60 - 361234TIY.pdf

16 - Domain Objective 3 Exercises & Solutions

61 - Consolidation-Exercise.xlsx

61 - Cube-functions.xlsx

61 - Domain Objective 3 Create Advanced Formulas Exercises & Solutions

61 - Flight-Date-and-Times.xlsx

61 - HelpLess-Airlines-Marketing-Plan-2017-to-2022.xlsx

61 - HelpLess-Charter-Scenarios.xlsx

61 - Raw-Sales-Data.xlsx

61 - Sales-Information-Data.xlsx

61 - Section-3-Exercises-Jan-2019.pdf

61 - Trace-Problems.xlsx

61 - Training-Sales.xlsx

17 - 41 Create Advanced Charts

62 - 411 Add Trendlines to Charts

63 - 412TIY.pdf

63 - 412 Create Dualaxis Charts

63 - 412-Combo-and-Dual-Axis-Charts.xlsx

64 - 413 Save a Chart as a Template

18 - 42 Create and Manage Pivot Tables

65 - 421TIY.pdf

65 - 421 Create Pivot Tables

65 - Training-Sales.xlsx

66 - 422TIY.pdf

66 - 422 Modify Field Selections and Options

66 - Sales-Information.xlsx

67 - 423TIY.pdf

67 - 423 Create Slicers

67 - Sales-Information-Data.xlsx

68 - 424TIY.pdf

68 - 424 Group Pivot Table Data

68 - 424-Sales-Information-Data.xlsx

69 - 425 Reference Data in a Pivot Table by using the GETPIVOTDATA Function

70 - 426 Add Calculated Fields

71 - 427 Format Data

19 - 43 Create and Manage Pivot Charts

72 - 431TIY.pdf

72 - 431 Create PivotCharts

72 - 431-Training-Sales.xlsx

73 - 432TIY.pdf

73 - 432 Manipulate Options in Existing PivotCharts

73 - 432-Training-Sales.xlsx

74 - 433 Apply Styles to PivotCharts

75 - 434TIY.pdf

75 - 434 Drill Down into PivotChart Details

75 - 434-Training-Sales.xlsx

20 - Domain Objective 4 Exercises & Solutions

76 - Domain Objective 4 Create Advanced Charts and Tables Exercises & Solutions

76 - Exercises-Domain-4-Jan-2019.docx

76 - HelpLess-Airlines-Marketing-Plan-2017-to-2022.xlsx

76 - Raw-Sales-Data.xlsx

21 - CUBE Functions Special Lecture

77 - CUBE Function Questions

77 - cube-functions-questions-november-2018.zip

22 - 77728 Practice Exam and Video Solutions

78 - Special Exam Considerations

79 - How to use the Practice Exam Files

80 - Integrated-Project-1-Pilots-and-Passengers-1.xlsx

80 - Project 1 Pilots and Passengers Solution

81 - Integrated-Project-2-Income-Analysis.xlsx

81 - Project 2 Income Analysis Solution

82 - Integrated-Project-3-Sales-Analysis.xlsx

82 - Project 3 Sales Analysis Solution

83 - Integrated-Project-4-Pilot-Performance.xlsx

83 - Project 4 Pilot Performance Solution

84 - Integrated-Project-5-Monthly-Merchandise-Sales-Analysis.xlsx

84 - Project 5 Monthly Merchandise Solution

85 - Zipped Exam Files.html

85 - Zipped-Exam-Files.zip

23 - Bonus Lecture Discount Coupon Facebook Group

86 - Bonus Lecture MOS University

86 - MOS University Facebook Home.txt

86 - MOS University Private Facebook Group.txt

86 - MOS University Website.txt

86 - MOS University YouTube Channel.txt

139,000 تومان

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

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

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

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