MO-100 Word, MO-200 Excel, MO-300 PowerPoint certifications

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

Learn the skills for the MO-100 Word, MO-200 Excel, MO-300 PowerPoint Associate exams. Get Microsoft Office certified.

1 - Introduction

1 - Introduction

2 - Welcome to Udemy.html

3 - How to get the best out of your Udemy course

4 - Do you want autotranslated subtitles in more languages.html

5 - Introduction to the Microsoft Office Specialist Associate certification

6 - Word Curriculum

7 - MO-100Exam.docx

7 - MO-100ExamRequirements220126.pdf

7 - PracticeActivities.docx

7 - Resources.html

2 - Part 1 Section 1 Insert text and paragraphs

8 - An introduction to Microsoft Word

9 - Fonts

10 - Copy cut and paste dragging text and the clipboard

11 - 101 Search for text

12 - 116 Find and replace text

13 - 117 Insert symbols and special characters

14 - PracticeActivities.docx

14 - Practice Activity Number 1.html

15 - Practice Activity Number 1 The Solution

3 - Part 1 Section 2 Format text and paragraphs

16 - 118 122 Apply text effects including Clear Formatting

17 - 119 Apply formatting by using Format Painter

18 - 120 Set line and paragraph spacing

19 - 120 Set indentation

20 - 121 Apply builtin styles to text

21 - PracticeActivities.docx

21 - Practice Activity Number 2.html

22 - Practice Activity Number 2 The Solution

4 - Part 1 Section 3 Configuring documents and creating document sections

23 - 123 Format text in multiple columns

24 - 104 Show and hide formatting symbols and hidden text

25 - 124 Insert page section and column breaks

26 - 105 125 Set up document pages and Change page setup options for a section

27 - PracticeActivities.docx

27 - Practice Activity Number 3.html

28 - Practice Activity Number 3 The Solution

5 - Part 2 Section 1 Create and modify tables

29 - 128 Create tables by specifying rows and columns

30 - 126 127 Convert text to tables and tables to text and how to add tabs

31 - 132 Resize tables rows and columns

32 - 133 134 Configure a repeating row header and splitting tables

33 - PracticeActivities.docx

33 - Practice Activity Number 4.html

34 - Practice Activity Number 4 The Solution

35 - Formatting tables including borders

36 - 131 Merge and split cells

37 - 129 Sort table data

38 - 130 Configure cell margins and spacing

39 - PracticeActivities.docx

39 - Practice Activity Number 5.html

40 - Practice Activity Number 5 The Solution

6 - Part 2 Section 2 Create and modify lists

41 - 135 136 137 Format paragraphs as custom numbered and bulleted lists

42 - 139 140 Set starting number values and restart and continue list numbering

43 - 138 Increase and decrease list levels

44 - PracticeActivities.docx

44 - Practice Activity Number 6.html

45 - Practice Activity Number 6 The Solution

7 - Part 3 Create and manage references

46 - 141 Insert footnote and endnotes

47 - 142 Modify footnote and endnote properties

48 - 143 144 Create and modify citation sources and citations

49 - 147 Insert bibliographies

50 - 145 146 Insert and customize tables of contents

51 - PracticeActivities.docx

51 - Practice Activity Number 7.html

52 - Practice Activity Number 7 The Solution

8 - Part 4 Manage document collaboration

53 - 166169 Comments

54 - 170 173 Track changes and Lock and unlock change tracking

55 - 171 172 Review accept and reject tracked changes

56 - PracticeActivities.docx

56 - Practice Activity Number 8.html

57 - Practice Activity Number 8 The Solution

9 - Part 5 Section 1 Insert and format text boxes

58 - 153 160 163 Insert add and modify text in text boxes and position object

59 - 164 Wrap text around objects

60 - 165 Add alternative text to objects for accessibility

61 - PracticeActivities.docx

61 - Practice Activity Number 9.html

62 - Practice Activity Number 9 The Solution

10 - Part 5 Section 2 Insert and Format Pictures

63 - 149 Insert pictures

64 - 155 157 Apply picture effects and picture styles and Format graphic elements

65 - 154 156 Apply artistic effects and Remove picture backgrounds

66 - PracticeActivities.docx

66 - Practice Activity Number 10.html

67 - Practice Activity Number 10 The Solution

11 - Part 5 Section 3 Insert and format other graphic elements

68 - 148 Insert shapes including using the Canvas

69 - 152 Insert screenshots and screen clippings

70 - 151 158 162 Insert format and modify SmartArt graphic content

71 - 150 159 Insert and format 3D models

72 - Practice Activity Number 11.html

73 - Practice Activity Number 11 The Solution

12 - Part 6 Section 1 Navigate within and format documents

74 - 103 Move to specific locations and objects in documents

75 - 102 Link to locations within documents

76 - 106 Apply style sets

77 - 107 Insert and modify headers and footers

78 - 108 Configure page background elements

79 - PracticeActivities.docx

79 - Practice Activity Number 12.html

80 - Practice Activity Number 12 The Solution

13 - Part 6 Section 2 Save and share documents and inspect documents for issues

81 - 109 Save documents in alternative file formats

82 - 110 113 Modify basic document properties and locateremove hidden properties

83 - 114 Locate and correct accessibility issues

84 - 115 Locate for compatibility issues

85 - 111 Modify print settings

86 - 112 Share documents electronically

87 - PracticeActivities.docx

87 - Practice Activity Number 13.html

88 - Practice Activity Number 13 The Solution

14 - Well done for finishing the Word course

89 - Whats Next

90 - Well done

15 - Introduction to Excel MO200

91 - Curriculum

92 - CSVFile.csv

92 - MO-200ExamRequirements210404.pdf

92 - Part-7-Session-1-Start.xlsx

92 - Resources.html

92 - fixedwidthfile.zip

92 - tabdelimitedfile.zip

92 - textfile.zip

16 - Part 7 Section 1 Import data into workbooks and Navigate within workbooks

93 - Microsoft Excel an introduction

93 - Part-7-Session-1-Start.xlsx

94 - 201 202 Import data from txt and csv files

94 - CSVFile.csv

94 - fixedwidthfile.zip

94 - tabdelimitedfile.zip

94 - textfile.zip

95 - 203 Search for data within a workbook

96 - 205 Insert and remove hyperlinks

97 - Practice Activity Number 14.html

97 - practiceactivity071.zip

98 - Practice Activity Number 14 The Solution

17 - Part 7 Section 2 Format worksheets and workbooks

99 - 212 Change window views

99 - Part-7-Session-2-Start.xlsx

100 - Using zoom

101 - 206 Modify page setup

102 - 208 Customize headers and footers

103 - 215 Set a print area

104 - 207 Adjust row height and column width

105 - PracticeActivity072.xlsx

105 - Practice Activity Number 15.html

106 - Practice Activity Number 15 The Solution

18 - Part 7 Section 3 Customize options and views

107 - 209 Customize the Quick Access toolbar

107 - Part-7-Session-3-Start.xlsx

108 - 210 Display and modify workbook content in different views

109 - 211 Freeze worksheet rows and columns

110 - 213 Modify basic workbook properties

19 - Part 7 Section 4 Configure content for collaboration

111 - 216 Save workbooks in alternative file formats

111 - Part-7-Session-4-Start.xlsx

112 - 217 Configure print settings

113 - 218 Inspect workbooks for issues

114 - PracticeActivity074.xlsx

114 - Practice Activity Number 16.html

115 - Practice Activity Number 16 The Solution

20 - Part 8 Section 1 Manipulate data in worksheets

116 - 219 Paste data by using special paste options

116 - Part-8-Session-1-Start.xlsx

117 - 220 Fill cells by using Auto Fill

118 - 221 Insert and delete multiple columns or rows

119 - 222 Insert and delete cells

120 - PracticeActivity081.xlsx

120 - Practice Activity Number 17.html

121 - Practice Activity Number 17 The Solution

21 - Part 8 Section 2 Format cells and ranges

122 - 225 Format cells by using Format Painter

122 - Part-8-Session-2-Start.xlsx

123 - 226 Wrap text within cells

124 - 224 Modify cell alignment orientation and indentation

125 - 223 Merge and unmerge cells

126 - 227 Apply number formats

127 - 228 230 Apply cell formats from the Format Cells dialog box clear formatting

128 - 229 Apply cell styles

129 - PracticeActivity082.xlsx

129 - Practice Activity Number 18.html

130 - Practice Activity Number 18 The Solution

22 - Part 8 Section 3 Summarize data visually

131 - 234235 Applying and removing conditional formatting highlighting

131 - Part-8-Session-3-Start.xlsx

132 - 234235 Applying and removing conditional formatting Bars Scales and Sets

133 - PracticeActivity083.xlsx

133 - Practice Activity Number 19.html

134 - Practice Activity Number 19 The Solution

23 - Part 9 Section 1 Create and format tables

135 - 232 236 238 Create Excel tables from cell ranges back and name a table

135 - Part-9-Session-1-Start.xlsx

136 - 239 Add or remove table rows and columns

137 - 237 240 241 Apply table styles and options including total rows

138 - Practice Activity Number 20.html

138 - Practice-File-091.xlsx

139 - Practice Activity Number 20 The Solution

24 - Part 9 Section 2 Filter and sort table data

140 - 242 Filter records numbers

140 - Part-9-Session-2-Start.xlsx

141 - 242 Filter records text and dates

142 - 243 Sort data by multiple columns

143 - PracticeActivity092.xlsx

143 - Practice Activity Number 21.html

144 - Practice Activity Number 21 The Solution

25 - Part 10 Section 1 Creating formulas

145 - Part-10-Session-1-Start.xlsx

145 - Using basic operators

146 - Order of operations

147 - Exercise1.xlsx

147 - Referencing cell ranges in formulas

148 - 214 244 Insert relative absolute and mixed references display formulas

149 - PracticeActivity22-Exercise2.xlsx

149 - Practice Activity Number 22 and Solution

26 - Part 10 Section 2 Calculate and transform datas

150 - 246 Perform calculations by using the AVERAGE MAX MIN SUM functions

150 - Part-10-Session-2-Start.xlsx

151 - 247 Count cells by using the COUNT COUNTA and COUNTBLANK functions

152 - 248 Perform conditional operations by using the IF function

153 - PracticeActivity102.xlsx

153 - Practice Activity Number 23.html

154 - Practice Activity Number 23 The Solution

27 - Part 10 Section 3 Define and reference named ranges

155 - 231 245 Define a named range and reference named ranges in formulas

155 - Part-10-Session-3-Start.xlsx

156 - 245 Reference named tables in formulas

157 - 204 Navigate to named cells Reminder

158 - PracticeActivity103.xlsx

158 - Practice Activity Number 24.html

159 - Practice Activity Number 24 The Solution

28 - Part 10 Section 4 Format and modify text

160 - 249 Format text by using RIGHT LEFT and MID functions

160 - Part-10-Session-4-Start.xlsx

161 - 250 Format text by using UPPER LOWER and LEN functions

162 - 251 Format text by using the CONCAT and TEXTJOIN functions

163 - PracticeActivity104.xlsx

163 - Practice Activity Number 25.html

164 - Practice Activity Number 25 The Solution

29 - Part 11 Section 1 Create and modify charts

165 - 252 253 Create charts create chart sheets and moving charts

165 - Part-11-Session-1-Start.xlsx

166 - 254 Add data series to charts

167 - 255 Switch between rows and columns in source data

168 - PracticeActivity111.xlsx

168 - Practice Activity Number 26.html

169 - Practice Activity Number 26 The Solution

30 - Part 11 Section 2 Format charts

170 - 256 Add and modify chart elements

170 - Part-11-Session-2-Start.xlsx

171 - 257 258 259 Apply chart layouts and styles and add alternative text

172 - 233 Insert Sparklines

173 - PracticeActivity112.xlsx

173 - Practice Activity Number 27.html

174 - Practice Activity Number 27 The Solution

31 - Well done for finishing the Excel course

175 - Congratulations for finishing the Excel course

32 - Introduction to PowerPoint MO300

176 - Curriculum

177 - MO-300ExamRequirements210404.docx

177 - MO-300ExamRequirements210404.pdf

177 - PracticeActivity124.pptx

177 - Resources.html

33 - Part 12 Section 1 Insert slides

178 - 327 Insert slides and select slide layouts

178 - Part-12-Section-1-Start.pptx

179 - 325 Import Word document outlines

180 - 326 Insert slides from another presentation

181 - 308 Display presentations in different views

182 - 329 334 Duplicate slides Modify slide order

34 - Part 12 Section 2 Modify slides

183 - 330 Hide and unhide slides

183 - Part-12-Section-2-Start.pptx

184 - 307 331 Change slide size and Modify individual slide backgrounds

185 - 332 Insert slide headers footers and page numbers

186 - PracticeActivity122.docx

186 - PracticeActivity122Import.pptx

186 - Practice Activity Number 28.html

187 - Practice Activity Number 28 The Solution

35 - Part 12 Section 3 Skills from the MO100 course

188 - 336338 Format text

188 - Part-12-Section-3-Start.pptx

189 - 339 Insert hyperlinks

190 - 341343 Insert and format images

191 - 344 346350 Insert and format graphic elements

192 - Practice Activity Number 29.html

193 - Practice Activity Number 29 The Solution

194 - 355357 Insert and format tables

195 - 358359 Insert and modify charts

196 - 360362 Insert and format SmartArt graphics

197 - 363364 Insert 3D models

198 - PracticeActivity123.xlsx

198 - Practice Activity Number 30.html

199 - Practice Activity Number 30 The Solution

36 - Part 12 Section 4 Order and group slides

200 - 333 Create and rename sections

200 - Part-12-Section-4-Start.pptx

201 - 328 340 Insert Summary Zoom slides Section Zoom links and Slide Zoom links

202 - PracticeActivity124.pptx

202 - Practice Activity Number 31.html

203 - Practice Activity Number 31 The Solution

37 - Part 13 Section 1 Order and group objects on slides

204 - 345 Draw by using digital ink

204 - Part-13-Section-1-Start.pptx

205 - 352354 Align and group shapes images and text boxes using alignment tools

206 - 351 Order shapes images and text boxes

38 - Part 13 Section 2 Manage media

207 - 365 367 Insert audio and video clips and configure media playback options

207 - Clap-Cheers.WAV

207 - Part-13-Section-2-Start.pptx

207 - SSISextract

208 - 366 Create and insert screen recordings

209 - Slide Show controls

210 - ClapCheers.WAV

210 - PracticeActivity132

210 - Practice Activity Number 32.html

211 - Practice Activity Number 32 The Solution

39 - Part 14 Section 1 Apply and configure slide transitions and animations

212 - 368 369 375 376 Apply and configure slide transitions including set timing

212 - Part-14-Section-1-Start.pptx

213 - 370 371 Animate text and graphic elements and 3D models

214 - 372374 Configure animation effects paths and reorder animations on a slide

215 - PracticeActivity141.pptx

215 - Practice Activity Number 33.html

216 - Practice Activity Number 33 The Solution

40 - Part 14 Section 2 Modify slide handout and note masters and print

217 - 301304 Change the slide master theme background and slide layouts

218 - 310 313 Print all or part of a presentation in color grayscale blackwhite

219 - 305 306 311 312 Modify handoutnotes master and Print notes pageshandouts

220 - PracticeActivity142.pptx

220 - Practice Activity Number 34.html

221 - Practice Activity Number 34 The Solution

41 - Part 14 Section 3 Configure and present slide shows prepare for collaboration

222 - 314 315 Create custom slide shows and configure options

223 - 316 318 Rehearse slide show timing and use Presenter View

224 - 317 Set up slide show recording options

225 - 309 319321 File properties final passwords and inspect for issues

226 - 322324 Comments preserve presentation content and export to other formats

227 - PracticeActivity143.pptx

227 - Practice Activity Number 35.html

228 - Practice Activity Number 35 The Solution

42 - Well done for finishing the PowerPoint course

229 - Congratulations for finishing the PowerPoint course

230 - Well done for finishing this course

231 - Bonus Lecture

231 - idodatabonuslecture230113.zip

53,700 تومان

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

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

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

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