Microsoft Office; Excel, Word & PowerPoint 2019 – Beginners

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

Learn the essentials of Microsoft Office in this 3-course bundle for Office 365 or Office 2019 users.

1 - Excel 2019 Introduction

1 - Intro to Excel

2 - WATCH ME Essential Information for a Successful Training Experience

3 - Course Exercise Files.html

3 - Excel-2019-Beginner-Course-Exercise-Files.zip

4 - Downloadable Course Transcripts.html

4 - Microsoft-Excel-2019-Course-by-Simon-Sez-IT.pdf

5 - Whats New In Excel 2019

6 - Course Overview

7 - Overview of the Excel window

8 - MouseFeatures

9 - Back Stage View

2 - Excel 2019 Beginner Creating Workbooks

10 - Entering Text and Numbers

11 - Creating Basic Formulas

12 - Relative References

13 - Order of Operations

14 - Working with Ranges

15 - Module 2 Practice Exercise

3 - Excel 2019 Beginner Saving Workbooks

16 - Working with the Save and Save As Commands

17 - File Extensions Share Export and Publish Files

18 - Module 3 Practice Exercise

4 - Excel 2019 Beginner Navigating Workbooks

19 - Opening a File

20 - Working with Larger Files

21 - Freeze Panes Option

22 - Split Screen Option

23 - Module 4 Practice Exercise

5 - Excel 2019 Beginner Page Setup & Print Options

24 - Headers and Footers

25 - Print Titles

26 - Comments

27 - Page Setup Options

28 - Fit to Print on One Page

29 - Printing Workbooks

30 - Module 5 Practice Exercise

6 - Excel 2019 Beginners Working with Rows Columns and Cells

31 - Adding and deleting rows columns and cells

32 - Changing Column andRow Widths

33 - Module 6 Practice Exercise

7 - Excel 2019 Beginners Moving Data

34 - Cut Copy and Paste

35 - Copying Formulas

36 - Module 7 Practice Exercise

8 - Excel 2019 Beginners Formulas & Functions

37 - Overview of Formulas

38 - Create Formulas Using Functions Part 1

39 - Create Formulas Using Functions Part 2

40 - Absolute Values

41 - Module 8 Practice Exercise

9 - Excel 2019 Beginner Working with Sheets

42 - Adding Deleting and Renaming Sheets

43 - Additional Sheet Tab Options

44 - 3 Dimensional Formulas

10 - Excel 2019 Beginner Formatting Worksheets

45 - Formatting Cells Part 1

46 - Formatting Cells Part 2

47 - Formatting Numbers

48 - Borders and Shading

49 - Format as Table

50 - Using Styles

51 - Using Format Painter

52 - Protecting Sheets

53 - Fill Handle and Custom Lists

54 - Module 10 Practice Exercise

11 - Excel 2019 Beginner Charts

55 - Creating Charts

56 - Types of Charts

57 - Editing Charts Part 1

58 - Editing Charts Part 2

59 - Using Graphics to Enhance Charts

60 - Linking Chart Titles

61 - Module 11 Practice Exercise

12 - Excel 2019 Beginner Working with Names

62 - Creating Range Names

63 - Managing Names

64 - Using Names in Formulas

65 - Module 12 Practice Exercise

13 - Excel 2019 Beginner Sorting and Filtering

66 - Remove Duplicates

67 - Sort Data

68 - Filter Data

69 - Advanced Filters

70 - Module 13 Practice Exercise

14 - Excel 2019 Beginner Outlining and Subtotaling

71 - Creating an Outline

72 - Subtotals

73 - Module 14 Practice Exercise

15 - Excel 2019 Beginner Working with Views

74 - Arranging Files

75 - New Window Option

76 - Custom Views

77 - Module 15 Practice Exercise

16 - Excel 2019 Beginner Linking Files

78 - Creating Formulas Between File

79 - Working with Links

80 - Consolidating Data

81 - Module 16 Practice Exercise

17 - Excel 2019 Beginner Advanced Formula Creation

82 - If Statements

83 - VLookups

84 - Data Validation

85 - Formula Auditing

86 - Module 17 Practice Exercise

18 - Excel 2019 Beginner Pivot Tables

87 - Pivot Tables

88 - Pivot Charts

89 - Module 18 Practice Exercise

19 - Excel 2019 Beginner Additional Excel Features

90 - Slicers

91 - Goal Seeker

92 - Text to Columns

93 - Watch Window

94 - Customizing Ribbons and Tabs

95 - Module 19 Practice Exercise

20 - Excel 2019 Beginner Shortcuts

96 - Excel Shortcuts Every User Should Know

21 - Excel 2019 Beginner Closing

97 - Closing Video

22 - PowerPoint 2019 Course Introduction

98 - Welcome and Overview

99 - WATCH ME Essential Information for a Successful Training Experience

100 - DOWNLOAD ME Course Exercise Files.html

100 - PowerPoint-2019-Exercise-Files.zip

101 - Downloadable Course Transcripts.html

101 - Microsoft-PowerPoint-2019-Course-by-Simon-Sez-IT.pdf

23 - PowerPoint 2019 Overview

102 - Navigate a PowerPoint Presentation

103 - Overview of the Screen and Views

104 - Exercise 1

24 - PowerPoint 2019 Getting Started

105 - Presentation Tips and Guidelines

106 - Creating a New Presentation

107 - Working with Slides

108 - Saving a Presentation

109 - Exercise 02

25 - PowerPoint 2019 Text and Bullet Editing Options

110 - Formatting Text

111 - Working with Bullets and Numbered Lists

112 - Exercise 03

26 - PowerPoint 2019 Adding Graphics

113 - Inserting Shapes

114 - Inserting Graphics

115 - Inserting Icons and 3D Models

116 - Inserting Pictures

117 - Exercise 04

27 - PowerPoint 2019 Working with objects

118 - Selecting Objects

119 - Editing Objects

120 - Formatting Objects Part 1

121 - Formatting Objects Part 2

122 - Arranging Objects

123 - Grouping Objects

124 - Exercise 05

28 - PowerPoint 2019 Editing Pictures

125 - Picture Options

126 - Cropping Pictures

127 - Formatting Pictures

128 - Things You Can Do with Pictures

129 - Exercise 06

29 - PowerPoint 2019 Working with SmartArt

130 - Creating SmartArt

131 - Modifying SmartArt

132 - Creating a Flowchart using SmartArt

133 - Exercise 07

30 - PowerPoint 2019 Working with Tables

134 - Creating Tables

135 - Formatting Tables

136 - Inserting Tables

137 - Exercise 08

31 - PowerPoint 2019 Working with Charts

138 - Adding Charts

139 - Formatting Charts

140 - Inserting Charts from Microsoft Excel

141 - Exercise 09

32 - PowerPoint 2019 Unlocking the Power of Masters

142 - Using Master Slides

143 - Modifying Master Slides

144 - Creating a New Master Design Template

145 - Exercise 10

33 - PowerPoint 2019 Adding Media

146 - Adding Video to a Presentation

147 - Adding Audio to a Presentation

148 - Exercise 11

34 - PowerPoint 2019 Working with Transitions

149 - Applying Transitions

150 - Transition Options

151 - Exercise 12

35 - PowerPoint 2019 Animation

152 - Animating an Object

153 - Effect Options

154 - Working with the Animation Pane

155 - Motion Paths

156 - Triggers

157 - Exercise 13

36 - PowerPoint 2019 Hyperlinks and Action Buttons

158 - Working with Action Buttons

159 - Working with Hyperlinks

160 - Exercise 14

37 - PowerPoint 2019 Slideshow Options

161 - Onscreen Presentation Options

162 - Hiding Slides

163 - Changing the Order of Slides

164 - Copying Slides

165 - Slideshow Options

166 - Exercise 15

38 - PowerPoint 2019 Preparing a Presentation for Delivery

167 - Rehearse Timings

168 - Recording a Presentation

169 - Slide Show Settings

170 - Creating a Custom Slide Show

171 - Exercise 16

39 - PowerPoint 2019 Exploring the Backstage Area

172 - Exporting options

173 - The Backstage Area

174 - Printing a Presentation

175 - Exercise 17

40 - PowerPoint 2019 Course Close

176 - Conclusion

41 - Word 2019 Introduction

177 - Welcome and Overview

178 - WATCH ME Essential Information for a Successful Training Experience

179 - DOWNLOAD ME Course Exercise Files.html

179 - Word-2019-Exercise-Files.zip

180 - Downloadable Course Transcripts.html

180 - Microsoft-Word-2019-Course-by-Simon-Sez-IT-Full-Transcripts.pdf

181 - Overview of the MS Word Screen

182 - The Backstage View

42 - Word 2019 Getting Started with Word

183 - Creating a New Blank Document

184 - Working with NonPrinting Characters and Line Spacing

185 - Saving a Document

186 - Opening a Document

187 - Navigating a Document

188 - Go To Find and Replace

189 - Editing a Document

190 - Practice Exercise

43 - Word 2019 Character Formatting

191 - AutoCorrect Options

192 - Selecting Text

193 - Cut Copy and Paste

194 - Character Formatting Options

195 - Format Painter

196 - Working with Numbers

197 - Working with Bullets

198 - Creating an Outline

199 - Practice Exercise

44 - Word 2019 Paragraph Formatting

200 - Alignment Options

201 - Line Spacing Options

202 - Working with Indents

203 - Working with Tabs

204 - Practice Exercise

45 - Word 2019 Managing Lists

205 - Sorting a List

46 - Word 2019 Tables

206 - Working with Tables

207 - Creating a Table

208 - Adding Rows and Columns to a Table

209 - Formatting Table Data

210 - Borders and Shading

211 - Sorting in a Table

212 - Drawing in a Table

213 - Converting Existing Data to a Table

214 - Quick Tables

215 - Using Formulas in Tables

216 - Practice Exercise

47 - Word 2019 Styles

217 - Working with Styles

218 - Creating Styles

219 - Editing Styles

220 - Practice Exercise

48 - Word 2019 Controlling Page Appearance

221 - Working with Page Breaks

222 - Working with Columns

223 - Adding a Watermark

224 - Headers and Footers

49 - Word 2019 Sectioning

225 - What is Sectioning

226 - Sectioning a Document

227 - Odd and Even Sections

228 - Practice Exercise

50 - Word 2019 Graphics

229 - Inserting Pictures

230 - Inserting Pictures into Existing Documents

231 - Picture Options

232 - Working with Shapes

233 - Icons and 3D Models

234 - SmartArt Charts and Screenshots

235 - Practice Exercise

51 - Word 2019 Envelopes and Labels

236 - Working with Envelopes

237 - Working with Labels

52 - Word 2019 Mail Merges

238 - What is Mail Merge

239 - Creating a Mail Merge Document Part 1

240 - Creating a Mail Merge Document Part 2

241 - Merging a Document with an Existing Data Source

242 - Merging Envelopes and Labels

243 - Merging a Directory

244 - Practice Exercise

53 - Word 2019 Page Setup Options

245 - Building Blocks

246 - Auto Text

247 - Practice Exercise

54 - Word 2019 Indexing and Table of Contents

248 - Creating an Index

249 - Creating a Table of Contents

250 - Practice Exercise

55 - Word 2019 Review and Printing

251 - Using the Thesaurus and Spell Check

252 - Comments

253 - Page Setup Options

254 - Printing

255 - Practice Exercise

56 - Word 2019 Other Word Options

256 - Word Options

257 - Protecting a Document

258 - Macros

57 - Wrap Up

259 - Closing

58 - Extras

260 - EXTRA LESSON Designing Better Spreadsheets Webinar Recording

261 - EXTRA LESSON Data Cleaning in Excel Webinar Recording

262 - EXTRA LESSON Top Ten Excel Functions You HAVE to Know Webinar Recording

263 - EXTRA LESSON Creating Engaging PowerPoint Presentations Webinar Recording

264 - EXTRA RESOURCE The Most Frequently Used PowerPoint Shortcuts Infographic.html

264 - Powerpoint.pdf

265 - EXTRA RESOURCE The Most Frequently Used Excel Shortcuts Infographic.html

265 - PC-Excel-Most-Used.pdf

266 - EXTRA RESOURCE The Most Frequently Used Word Shortcuts Infographic.html

266 - Word.pdf

59 - Congratulations

267 - BONUS Lecture.html

139,000 تومان

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

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

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

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