MS Office; Excel, Word, Access & PowerPoint 2019 – Beginners

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

Learn the essentials of Microsoft Office in this 4-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 theSave 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 - Working with the Save and Save As Commands

43 - Adding Deleting and Renaming Sheets

44 - Additional Sheet Tab Options

45 - 3 Dimensional Formulas

46 - Module 9 Practice Exercise

10 - Excel 2019 Beginner Formatting Worksheets

47 - Formatting Cells Part 1

48 - Formatting Cells Part 2

49 - Formatting Numbers

50 - Borders and Shading

51 - Format as Table

52 - Using Styles

53 - Using Format Painter

54 - Protecting Sheets

55 - Fill Handle and Custom Lists

56 - Module 10 Practice Exercise

11 - Excel 2019 Beginner Charts

57 - Creating Charts

58 - Types of Charts

59 - Editing Charts Part 1

60 - Editing Charts Part 2

61 - Using Graphics to Enhance Charts

62 - Linking Chart Titles

63 - Module 11 Practice Exercise

12 - Excel 2019 Beginner Working with Names

64 - Creating Range Names

65 - Managing Names

66 - Using Names in Formulas

67 - Module 12 Practice Exercise

13 - Excel 2019 Beginner Sorting and Filtering

68 - Remove Duplicates

69 - Sort Data

70 - Filter Data

71 - Advanced Filters

72 - Module 13 Practice Exercise

14 - Excel 2019 Beginner Outlining and Subtotaling

73 - Creating an Outline

74 - Subtotals

75 - Module 14 Practice Exercise

15 - Excel 2019 Beginner Working with Views

76 - Arranging Files

77 - New Window Option

78 - Custom Views

79 - Module 15 Practice Exercise

16 - Excel 2019 Beginner Linking Files

80 - Creating Formulas Between File

81 - Working with Links

82 - Consolidating Data

83 - Module 16 Practice Exercise

17 - Excel 2019 Beginner Advanced Formula Creation

84 - If Statements

85 - VLookups

86 - Data Validation

87 - Formula Auditing

88 - Module 17 Practice Exercise

18 - Excel 2019 Beginner Pivot Tables

89 - Pivot Tables

90 - Pivot Charts

91 - Module 18 Practice Exercise

19 - Excel 2019 Beginner Additional Excel Features

92 - Slicers

93 - Goal Seeker

94 - Text to Columns

95 - Watch Window

96 - Customizing Ribbons and Tabs

97 - Module 19 Practice Exercise

20 - Excel 2019 Beginner Shortcuts

98 - Excel Shortcuts Every User Should Know

21 - Excel 2019 Beginner Closing

99 - Closing Video

22 - Word 2019 Introduction

100 - Welcome and Overview

101 - WATCH ME Essential Information for a Successful Training Experience

102 - Course Exercise Files.html

102 - Word-2019-Exercise-Files.zip

103 - Downloadable Course Transcripts.html

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

104 - Overview of the MS Word Screen

105 - The Backstage View

23 - Word 2019 Getting Started with Word

106 - Creating a New Blank Document

107 - Working with NonPrinting Characters and Line Spacing

108 - Saving a Document

109 - Opening a Document

110 - Navigating a Document

111 - Go To Find and Replace

112 - Editing a Document

113 - Practice Exercise

24 - Character Formatting

114 - AutoCorrect Options

115 - Selecting Text

116 - Cut Copy and Paste

117 - Character Formatting Options

118 - Format Painter

119 - Working with Numbers

120 - Working with Bullets

121 - Creating an Outline

122 - Practice Exercise

25 - Word 2019 Paragraph Formatting

123 - Alignment Options

124 - Line Spacing Options

125 - Working with Indents

126 - Working with Tabs

127 - Practice Exercise

26 - Word 2019 Managing Lists

128 - Sorting a List

27 - Word 2019 Tables

129 - Working with Tables

130 - Creating a Table

131 - Adding Rows and Columns to a Table

132 - Formatting Table Data

133 - Borders and Shading

134 - Sorting in a Table

135 - Drawing in a Table

136 - Converting Existing Data to a Table

137 - Quick Tables

138 - Using Formulas in Tables

139 - Practice Exercise

28 - Word 2019 Styles

140 - Working with Styles

141 - Creating Styles

142 - Editing Styles

143 - Practice Exercise

29 - Word 2019 Controlling Page Appearance

144 - Working with Page Breaks

145 - Working with Columns

146 - Adding a Watermark

147 - Headers and Footers

30 - Word 2019 Sectioning

148 - What is Sectioning

149 - Sectioning a document

150 - Odd and Even Sections

151 - Practice Exercise

31 - Word 2019 Graphics

152 - Inserting Pictures

153 - Inserting Pictures into Existing Documents

154 - Picture Options

155 - Working with Shapes

156 - Icons and 3D Models

157 - SmartArt Charts and Screenshots

158 - Practice Exercise

32 - Word 2019 Envelopes and Labels

159 - Working with Envelopes

160 - Working with Labels

33 - Word 2019 Mail Merges

161 - What is Mail Merge

162 - Creating a Mail Merge Document Part 1

163 - Creating a Mail Merge Document Part 2

164 - Merging a Document with an Existing Data Source

165 - Merging Envelopes and Labels

166 - Merging a Directory

167 - Practice Exercise

34 - Word 2019 Page Setup Options

168 - Building Blocks

169 - Auto Text

170 - Practice Exercise

35 - Word 2019 Indexing and Table of Contents

171 - Creating an Index

172 - Creating a Table of Contents

173 - Practice Exercise

36 - Word 2019 Review and Printing

174 - Using the Thesaurus and Spell Check

175 - Comments

176 - Page Setup Options

177 - Printing

178 - Practice Exercise

37 - Word 2019 Other Word Options

179 - Word Options

180 - Protecting a Document

181 - Macros

38 - Word 2019 Wrap Up

182 - Closing

39 - PowerPoint 2019 Course Introduction

183 - Welcome and Overview

184 - WATCH ME Essential Information for a Successful Training Experience

185 - Course Exercise Files.html

185 - PowerPoint-2019-Exercise-Files.zip

186 - Downloadable Course Transcripts.html

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

40 - PowerPoint 2019 Overview

187 - Navigate a PowerPoint Presentation

188 - Overview of the Screen and Views

189 - Exercise 1

41 - PowerPoint 2019 Getting Started

190 - Presentation Tips and Guidelines

191 - Creating a New Presentation

192 - Working with Slides

193 - Saving a Presentation

194 - Exercise 02

42 - PowerPoint 2019 Text and Bullet Editing Options

195 - Formatting Text

196 - Working with Bullets and Numbered Lists

197 - Exercise 03

43 - PowerPoint 2019 Adding Graphics

198 - Inserting Shapes

199 - Inserting Graphics

200 - Inserting Icons and 3D Models

201 - Inserting Pictures

202 - Exercise 04

44 - PowerPoint 2019 Working with objects

203 - Selecting Objects

204 - Editing Objects

205 - Formatting Objects Part 1

206 - Formatting Objects Part 2

207 - Arranging Objects

208 - Grouping Objects

209 - Exercise 05

45 - PowerPoint 2019 Editing pictures

210 - Picture Options

211 - Cropping Pictures

212 - Formatting Pictures

213 - Things You Can Do with Pictures

214 - Exercise 06

46 - PowerPoint 2019 Working with SmartArt

215 - Creating SmartArt

216 - Modifying SmartArt

217 - Creating a Flowchart using SmartArt

218 - Exercise 07

47 - PowerPoint 2019 Working with Tables

219 - Creating Tables

220 - Formatting Tables

221 - Inserting Tables

222 - Exercise 08

48 - PowerPoint 2019 Working with Charts

223 - Adding Charts

224 - Formatting Charts

225 - Inserting Charts from Microsoft Excel

226 - Exercise 09

49 - PowerPoint 2019 Unlocking the Power of Masters

227 - Using Master Slides

228 - Modifying Master Slides

229 - Creating a New Master Design Template

230 - Exercise 10

50 - PowerPoint 2019 Adding Media

231 - Adding Video to a Presentation

232 - Adding Audio to a Presentation

233 - Exercise 11

51 - PowerPoint 2019 Working with Transitions

234 - Applying Transitions

235 - Transition Options

236 - Exercise 12

52 - PowerPoint 2019 Animation

237 - Animating an Object

238 - Effect Options

239 - Working with the Animation Pane

240 - Motion Paths

241 - Triggers

242 - Exercise 13

53 - PowerPoint 2019 Hyperlinks and Action Buttons

243 - Working with Action Buttons

244 - Working with Hyperllinks

245 - Exercise 14

54 - PowerPoint 2019 Slideshow Options

246 - Onscreen Presentation Options

247 - Hiding Slides

248 - Changing the order of slides

249 - Copying slides

250 - Slideshow Options

251 - Exercise 15

55 - PowerPoint 2019 Preparing a presentation for delivery

252 - Rehearse Timings

253 - Recording a Presentation

254 - Slide Show Settings

255 - Creating a Custom Slide Show

256 - Exercise 16

56 - PowerPoint 2019 Exploring the Backstage Area

257 - Exporting options

258 - The Backstage Area

259 - Printing a Presentation

260 - Exercise 17

57 - PowerPoint 2019 Course Close

261 - Conclusion

58 - Access 2019 Beginners Introduction

262 - Introduction to Access 2019

263 - WATCH ME Essential Information for a Successful Training Experience

264 - Access-2019-Exercise-Files.zip

264 - Course Exercise Files.html

265 - Access-2019-Course-Files.zip

265 - Course Demo Files.html

266 - Downloadable Course Transcripts.html

266 - Microsoft-Access-2019-Course-by-Simon-Sez-IT.pdf

267 - Acquiring Access 2019

268 - Structure of the Course

59 - Access 2019 Beginners Getting Started with Access 2019

269 - Using Database Templates

270 - Creating Saving and Opening Databases

271 - The Access Workspace and Backstage

272 - Online Help and Tell Me What You Want To Do

60 - Access 2019 Beginners The Ribbon and Toolbars

273 - Working with the Ribbon

274 - The Quick Access Toolbar

275 - Contextual Menus

276 - The Status Bar

61 - Access 2019 Beginners Keyboard Shortcuts and Key Tip

277 - Keyboard Shortcuts

278 - Key Tips

62 - Access 2019 Beginners Access Options

279 - Exploring Access Options

63 - Access 2019 Beginners Tables

280 - Creating a Table and Fields

281 - Indexed Field

282 - Lookup Wizard

283 - Numeric Fields

284 - Practice Exercise 01

64 - Access 2019 Beginners Importing Data

285 - Importing Data from Excel

286 - Practice Exercise 02

65 - Access 2019 Beginners Backup Restore and Repair

287 - Backing up your Database

288 - Compact and Repair

66 - Access 2019 Beginners Datasheet View

289 - Design in the Datasheet View

290 - Sorting and Filtering in Datasheet View

291 - Entering and Modifying Data in Datasheet View

67 - Access 2019 Beginners Relationships

292 - Creating a Link Table

293 - Setting up Relationships

294 - Practice Exercise 03

68 - Access 2019 Beginners Forms

295 - Creating a Form

296 - Modifying a Form

297 - Practice Exercise 04

298 - Forms in Layout View

299 - Forms in Design View

300 - Form Design

301 - Practice Exercise 05

69 - Access 2019 Beginners Subforms

302 - Setting Up Subforms Part 1

303 - Setting Up Subforms Part 2

304 - Setting Up Subforms Part 3

305 - Practice Exercise 06

70 - Access 2019 Beginners Queries

306 - Creating a Query

307 - Joins

308 - Query Wizard

309 - Practice Exercise 07

71 - Access 2019 Beginners Expressions

310 - Setting Up Validations

311 - Calculation using Expressions

72 - Access 2019 Beginners Reports

312 - Basic Reports

313 - Report Design

314 - Complex Reports

315 - Practice Exercise 08

73 - Access 2019 Beginners Printing

316 - Printing and Print Properties

74 - Access 2019 Beginners More Data Types

317 - YesNo OLE Objects and Hyperlink Data Types

75 - Access 2019 Beginners More About Forms

318 - Form Controls

319 - Form Themes

320 - Navigation Forms

76 - Access 2019 Beginners Exporting

321 - Exporting an Access Database

77 - Access 2019 Beginners Application Parts

322 - Adding Application Parts to a Database

78 - Access 2019 Beginners More Access Options

323 - Additional Access 2019 Options

79 - Access 2019 Beginners Info Tab

324 - Edit Database Properties and Encrypt with Password

80 - Access 2019 Beginners Course Close

325 - Course Close

81 - Extras

326 - EXTRA LESSON Designing Better Spreadsheets Webinar Recording

327 - EXTRA LESSON Data Cleaning in Excel Webinar Recording

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

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

329 - PC-Excel-Most-Used.pdf

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

330 - Powerpoint.pdf

331 - Access-Shortcuts.pdf

331 - EXTRA RESOURCE The Most Frequently Used Access Shortcuts Infographic.html

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

332 - Word.pdf

82 - Congratulations

333 - BONUS Lecture.html

179,000 تومان

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

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

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

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