77-727 Microsoft Excel 2016 Core Certification

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

Prepare with confidence for the 77-727! Includes complete exercise book, individual lecture exercises and practice exam!

1 - Introduction

1 - What is Microsoft Office Specialist MOS Certification

2 - Objective-Domain-MOS-Uni.pdf

2 - Understanding the Objective Domain

3 - Certiport Testing Centre Locator.txt

3 - Certiport Tutorial.txt

3 - Compass Overview.txt

3 - Exams from Home Information.txt

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

3 - MOS Core Excel Microsoft Information.txt

4 - Try It Yourself Exercises

2 - Introducing the Microsoft Excel User Interface

5 - Introducing the Excel User Interface

6 - Essential Navigation Skills

7 - Entering Information

3 - Student Exercise Files

8 - Course Exercise Workbook.html

8 - Course-Workbook-March-2020.pdf

9 - Student Files

9 - Student-Resource-Files-April-2020.zip

4 - 11 Create Worksheets and Workbooks

10 - 111.pdf

10 - 111 Create a Workbook

11 - 112TIY.pdf

11 - 112 Importing Data from a Delimited Text File

11 - Customers.csv

11 - HelpLess-Details.txt

11 - Names.txt

12 - 113TIY.pdf

12 - 113 Add a Worksheet to an Existing Workbook

12 - Multi-Sheets.xlsx

13 - 114.xlsx

13 - 114TIY.pdf

13 - 114 Copy and Move a Worksheet

14 - Exercises Domain 11

14 - Objectives-1.1-Exercises-MOS-University.pdf

5 - 12 Navigate in Worksheets and Workbooks

15 - 121 & 122 Search & Navigate to a Named Cell Range or Workbook Element

15 - 1212.pdf

15 - 1212.xlsx

16 - 122 Named Ranges

17 - 123.pdf

17 - 123.xlsx

17 - 123 Insert and Remove hyperlinks

18 - Exercises Domain 12

18 - Objective-1.2-Exercises.pdf

6 - 13 Format Worksheets and Workbooks

19 - 131 to 133 Changing Worksheet Characteristics

19 - 13123.xlsx

19 - 13123TIY.pdf

20 - 134.xlsx

20 - 134TIY.pdf

20 - 134 Modify Page Setup

21 - 135.xlsx

21 - 135TIY.pdf

21 - 135 Insert and Delete Columns or Rows and Cells

22 - 136.xlsx

22 - 136TIY.pdf

22 - 136 Change Workbook Themes

23 - 137.xlsx

23 - 137TIY.pdf

23 - 137 Adjust Row Height and Column Width

24 - 138.xlsx

24 - 138TIY.pdf

24 - 138 Insert Headers and Footers

25 - Exercises Domain 13

25 - Objective-1.3-Exercises-MOS-University.pdf

7 - 14 Customise Options and Views for Worksheets and Workbooks

26 - 141 and 142 Hide or Unhide Worksheets Columns and Rows

26 - 1412.xlsx

26 - 1412TIY.pdf

27 - 143.zip

27 - 143TIY.pdf

27 - 143 Customise the Quick Access Toolbar

28 - 144.xlsx

28 - 144TIY.pdf

28 - 144 Change Workbook Views

29 - 145.xlsx

29 - 145TIY.pdf

29 - 145 Change Window Views

30 - 146.xlsx

30 - 146TIY.pdf

30 - 146 Modify Document Properties

31 - 147.xlsx

31 - 147TIY.pdf

31 - 147 Change Magnification by using Zoom Tools

32 - 148.xlsx

32 - 148TIY.pdf

32 - 148 Display Formulas

33 - Exercises Domain 14

33 - Objective-1.4-Exercises-MOS-Uni.pdf

8 - 15 Configure Worksheets and Workbooks for Distribution

34 - 151.xlsx

34 - 151TIY.pdf

34 - 151 Set a Print Area

35 - 152.xlsx

35 - 152TIY.pdf

35 - 152 Save Workbooks in Alternative File Formats

36 - 153 Print All of Part of a Workbook

37 - 154 Set Print Scaling

38 - 155 Display Repeating Row and Column Titles on Multipage Worksheets

38 - 15345.xlsx

38 - 15345TIY.pdf

39 - 156.xlsx

39 - 156TIY.pdf

39 - 156 Inspect a Workbook for Hidden Properties or Personal Information

40 - 157.xlsx

40 - 157TIY.pdf

40 - 157 Inspect a Workbook for Accessibility Issues

41 - 158.xlsx

41 - 158TIY.pdf

41 - 158 Inspect a Workbook for Compatibility Issues

42 - Exercises 15

42 - Objective-1.5-Exercises-MOS-Uni.pdf

9 - Manage Worksheets & Workbooks Exam Seminar

43 - Seminar Series Manage Worksheets & Workbooks

10 - 21 Insert Data in Cells and Ranges

44 - 211.xlsx

44 - 211TIY.pdf

44 - 211 Replace Data

45 - 212.xlsx

45 - 212TIY.pdf

45 - 212 Cut Copy or Paste Data

46 - 213.xlsx

46 - 213TIY.pdf

46 - 213 Paste Data by using Special Paste Options

47 - 214.xlsx

47 - 214TIY.pdf

47 - 214 Fill Cells by using Auto Fill

48 - 215.xlsx

48 - 215TIY.pdf

48 - 215 Insert and Delete Cells

49 - Exercises Domain 21

49 - Objectives-2.1-Exercises-MOS-Uni.pdf

11 - 22 Format Cells and Ranges

50 - 221 Merge Cells

51 - 222 Modify Cell Alignment and Indentation

52 - 223 Format Cells by using Format Painter

53 - 224 Wrap Text Within Cells

53 - 221234.xlsx

53 - 221234TIY.pdf

54 - 225.xlsx

54 - 225TIY.pdf

54 - 225 Apply Number Formats

55 - 226 Apply Cell Formats

56 - 227 Apply Cell Styles

56 - 2267.xlsx

56 - 2267TIY.pdf

57 - Exercises Domain 22

57 - Objective-2.2-Exercises-MOS-Uni.pdf

12 - 23 Summarise and Organise Data

58 - 231.xlsx

58 - 231TIY.pdf

58 - 231 Insert Sparklines

59 - 232 and 233 Outline Data and Insert Subtotals

59 - 2323.xlsx

59 - 2323TIY.pdf

60 - 234.xlsx

60 - 234TIY.pdf

60 - 234 Apply Conditional Formatting

61 - Exercises Domain 23

61 - Objective-2.3-Exercises-MOS-Uni.pdf

13 - 31 and 32 Create and Manage Tables

62 - 311 and 312 Create an Excel Table from a Cell Range and Reverse

63 - 313 Add or Remove Table rows and Columns

64 - 321 to 323 Table Styles

64 - 3123.xlsx

64 - 3123TIY.pdf

65 - Exercises Domain 31 and 32

65 - Objectives-3.1-and-3.2-Exercises-MOS-Uni.pdf

14 - 33 Filter and Sort a Table

66 - 331.xlsx

66 - 331TIY.pdf

66 - 331 Filter Records

67 - 332 and 333 Sort Data

68 - 334 Remove Duplicate Records

68 - 33234.xlsx

68 - 33234TIY.pdf

69 - Exercises Domain 33

69 - Objective-3.3-Exercises-MOS-Uni.pdf

15 - 41 Summarise Data by Using Functions

70 - 411 Part I Insert References

71 - 411.xlsx

71 - 411TIY.pdf

71 - 411 Part II Absolute References

72 - 412 Perform Calculations by using the SUM Function

73 - 413 to 415 Using the Average MIN MAX and COUNT Functions

73 - 4125.xlsx

73 - 4125TIY.pdf

74 - Exercises Domain 41

74 - Objective-4.1-Exercises-MOS-Uni.pdf

16 - 42 Perform Conditional Operations by Using Functions

75 - 421.xlsx

75 - 421TIY.pdf

75 - 421 Perform Logical Operations by using the IF Function

76 - 422 to 424 Using the AverageIF COUNTIF and SUMIF Functions

76 - 4224.xlsx

76 - 4224TIY.pdf

77 - Exercises Domain 42

77 - Objective-4.2-Exercises-MOS-Uni.pdf

17 - 43 Format and Modify Text by Using Functions

78 - 431 to 433 Format Text by using Text Functions

78 - 4313.xlsx

78 - 4313TIY.pdf

79 - Exercises Domain 43

79 - Objective-4.3-Exercises-MOS-Uni.pdf

18 - 51 Create Charts

80 - 511 Create a New Chart

81 - 512 and 513 Add Additional Data Series and Switch Rows and Columns

82 - 514 Analyse Data by using Quick Analysis

82 - 5114.xlsx

82 - 5114TIY.pdf

83 - Exercises Domain 51

83 - Objective-5.1-Exercises-MOS-Uni.pdf

19 - 52 Format Charts

84 - 521 Resize Charts

85 - 522 Add and Modify Chart Elements

86 - 523 and 524 Apply Chart Layouts and Styles and Move Charts

86 - 5214.xlsx

86 - 5214TIY.pdf

87 - Exercises Domain 52

87 - Objective-5.2-Exercises-MOS-Uni.pdf

20 - 53 Insert and Format Objects

88 - 531 Insert Text Boxes and Shapes

89 - 532 Insert Images

90 - 533 Modify Object Properties

91 - 534 Add Alternative Text to Objects for Accessibility

91 - 5314.xlsx

91 - 5314TIY.pdf

91 - moss-university-logo4.zip

92 - Exercises Domain 53

92 - Objective-5.3-Exercises-MOS-Uni.pdf

21 - 77727 Sample Practice Exam

93 - How To Use the Practice Exam

94 - Project 1 Solution

94 - project-1-pilots-and-passengers.zip

95 - Project 2 Solution

95 - project-2-income-analysis.zip

96 - Project 3 Solution

96 - project-3-sales-analysis.zip

97 - Project 4 Solution

97 - project-4-pilot-performance.zip

98 - Project 5 Solution

98 - project-5-monthly-merchandise-sales-analysis.zip

99 - Project 6 Solution

99 - project-6-helpless-airlines-marketing-plan-2017-to-2022.zip

100 - Project 7 Solution

100 - project-7-training-sales.zip

22 - Bonus Lecture

101 - Bonus Lecture About MOS University

139,000 تومان

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

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

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

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