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

Focused View

Simon Sez IT

33:38:47

157 View

1 - Excel 2019 Introduction

1 - Intro to Excel.mp4

01:00

2 - WATCH ME Essential Information for a Successful Training Experience.mp4

02:03

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.mp4

07:52

6 - Course Overview.mp4

01:16

7 - Overview of the Excel window.mp4

08:25

8 - MouseFeatures.mp4

03:12

9 - Back Stage View.mp4

02:37

2 - Excel 2019 Beginner Creating Workbooks

10 - Entering Text and Numbers.mp4

04:32

11 - Creating Basic Formulas.mp4

06:49

12 - Relative References.mp4

03:01

13 - Order of Operations.mp4

04:48

14 - Working with Ranges.mp4

04:14

15 - Module 2 Practice Exercise.mp4

01:35

3 - Excel 2019 Beginner Saving Workbooks

16 - Working with theSave and Save As Commands.mp4

04:34

17 - File Extensions Share Export and Publish Files.mp4

03:44

18 - Module 3 Practice Exercise.mp4

00:59

4 - Excel 2019 Beginner Navigating Workbooks

19 - Opening a File.mp4

05:33

20 - Working with Larger Files.mp4

05:34

21 - Freeze Panes Option.mp4

03:16

22 - Split Screen Option.mp4

03:22

23 - Module 4 Practice Exercise.mp4

02:50

5 - Excel 2019 Beginner Page Setup & Print Options

24 - Headers and Footers.mp4

07:23

25 - Print Titles.mp4

02:52

26 - Comments.mp4

05:23

27 - Page Setup Options.mp4

07:30

28 - Fit to Print on One Page.mp4

03:59

29 - Printing Workbooks.mp4

03:55

30 - Module 5 Practice Exercise.mp4

01:53

6 - Excel 2019 Beginners Working with Rows Columns and Cells

31 - Adding and deleting rows columns and cells.mp4

06:12

32 - Changing Column andRow Widths.mp4

03:45

33 - Module 6 Practice Exercise.mp4

01:11

7 - Excel 2019 Beginners Moving Data

34 - Cut Copy and Paste.mp4

07:07

35 - Copying Formulas.mp4

05:09

36 - Module 7 Practice Exercise.mp4

01:20

8 - Excel 2019 Beginners Formulas & Functions

37 - Overview of Formulas.mp4

02:48

38 - Create Formulas Using Functions Part 1.mp4

10:04

39 - Create Formulas Using Functions Part 2.mp4

05:24

40 - Absolute Values.mp4

05:16

41 - Module 8 Practice Exercise.mp4

01:20

9 - Excel 2019 Beginner Working with Sheets

42 - Working with the Save and Save As Commands.mp4

04:34

43 - Adding Deleting and Renaming Sheets.mp4

04:09

44 - Additional Sheet Tab Options.mp4

05:19

45 - 3 Dimensional Formulas.mp4

05:28

46 - Module 9 Practice Exercise.mp4

01:31

10 - Excel 2019 Beginner Formatting Worksheets

47 - Formatting Cells Part 1.mp4

10:04

48 - Formatting Cells Part 2.mp4

03:38

49 - Formatting Numbers.mp4

09:24

50 - Borders and Shading.mp4

07:08

51 - Format as Table.mp4

06:07

52 - Using Styles.mp4

03:49

53 - Using Format Painter.mp4

04:29

54 - Protecting Sheets.mp4

09:01

55 - Fill Handle and Custom Lists.mp4

07:17

56 - Module 10 Practice Exercise.mp4

01:10

11 - Excel 2019 Beginner Charts

57 - Creating Charts.mp4

09:48

58 - Types of Charts.mp4

05:58

59 - Editing Charts Part 1.mp4

11:00

60 - Editing Charts Part 2.mp4

03:12

61 - Using Graphics to Enhance Charts.mp4

05:05

62 - Linking Chart Titles.mp4

02:47

63 - Module 11 Practice Exercise.mp4

00:53

12 - Excel 2019 Beginner Working with Names

64 - Creating Range Names.mp4

07:45

65 - Managing Names.mp4

03:17

66 - Using Names in Formulas.mp4

05:59

67 - Module 12 Practice Exercise.mp4

01:20

13 - Excel 2019 Beginner Sorting and Filtering

68 - Remove Duplicates.mp4

07:45

69 - Sort Data.mp4

10:28

70 - Filter Data.mp4

07:38

71 - Advanced Filters.mp4

04:46

72 - Module 13 Practice Exercise.mp4

00:57

14 - Excel 2019 Beginner Outlining and Subtotaling

73 - Creating an Outline.mp4

06:01

74 - Subtotals.mp4

08:00

75 - Module 14 Practice Exercise.mp4

01:08

15 - Excel 2019 Beginner Working with Views

76 - Arranging Files.mp4

03:14

77 - New Window Option.mp4

02:45

78 - Custom Views.mp4

05:32

79 - Module 15 Practice Exercise.mp4

01:07

16 - Excel 2019 Beginner Linking Files

80 - Creating Formulas Between File.mp4

06:35

81 - Working with Links.mp4

04:01

82 - Consolidating Data.mp4

05:16

83 - Module 16 Practice Exercise.mp4

01:30

17 - Excel 2019 Beginner Advanced Formula Creation

84 - If Statements.mp4

07:49

85 - VLookups.mp4

07:39

86 - Data Validation.mp4

08:13

87 - Formula Auditing.mp4

05:29

88 - Module 17 Practice Exercise.mp4

01:20

18 - Excel 2019 Beginner Pivot Tables

89 - Pivot Tables.mp4

09:36

90 - Pivot Charts.mp4

03:16

91 - Module 18 Practice Exercise.mp4

00:56

19 - Excel 2019 Beginner Additional Excel Features

92 - Slicers.mp4

04:41

93 - Goal Seeker.mp4

02:56

94 - Text to Columns.mp4

02:49

95 - Watch Window.mp4

02:32

96 - Customizing Ribbons and Tabs.mp4

03:25

97 - Module 19 Practice Exercise.mp4

01:23

20 - Excel 2019 Beginner Shortcuts

98 - Excel Shortcuts Every User Should Know.mp4

12:00

21 - Excel 2019 Beginner Closing

99 - Closing Video.mp4

00:37

22 - Word 2019 Introduction

100 - Welcome and Overview.mp4

02:36

101 - WATCH ME Essential Information for a Successful Training Experience.mp4

02:03

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.mp4

07:35

105 - The Backstage View.mp4

08:33

23 - Word 2019 Getting Started with Word

106 - Creating a New Blank Document.mp4

08:56

107 - Working with NonPrinting Characters and Line Spacing.mp4

08:27

108 - Saving a Document.mp4

06:41

109 - Opening a Document.mp4

06:53

110 - Navigating a Document.mp4

03:56

111 - Go To Find and Replace.mp4

07:30

112 - Editing a Document.mp4

03:26

113 - Practice Exercise.mp4

00:57

24 - Character Formatting

114 - AutoCorrect Options.mp4

08:32

115 - Selecting Text.mp4

05:18

116 - Cut Copy and Paste.mp4

08:11

117 - Character Formatting Options.mp4

08:05

118 - Format Painter.mp4

03:29

119 - Working with Numbers.mp4

08:02

120 - Working with Bullets.mp4

07:00

121 - Creating an Outline.mp4

05:41

122 - Practice Exercise.mp4

02:00

25 - Word 2019 Paragraph Formatting

123 - Alignment Options.mp4

03:18

124 - Line Spacing Options.mp4

04:45

125 - Working with Indents.mp4

05:18

126 - Working with Tabs.mp4

12:18

127 - Practice Exercise.mp4

01:03

26 - Word 2019 Managing Lists

128 - Sorting a List.mp4

05:42

27 - Word 2019 Tables

129 - Working with Tables.mp4

04:15

130 - Creating a Table.mp4

05:36

131 - Adding Rows and Columns to a Table.mp4

05:43

132 - Formatting Table Data.mp4

09:48

133 - Borders and Shading.mp4

12:41

134 - Sorting in a Table.mp4

06:14

135 - Drawing in a Table.mp4

07:30

136 - Converting Existing Data to a Table.mp4

04:46

137 - Quick Tables.mp4

06:03

138 - Using Formulas in Tables.mp4

08:34

139 - Practice Exercise.mp4

01:18

28 - Word 2019 Styles

140 - Working with Styles.mp4

04:48

141 - Creating Styles.mp4

08:12

142 - Editing Styles.mp4

06:34

143 - Practice Exercise.mp4

01:08

29 - Word 2019 Controlling Page Appearance

144 - Working with Page Breaks.mp4

03:45

145 - Working with Columns.mp4

05:45

146 - Adding a Watermark.mp4

03:38

147 - Headers and Footers.mp4

08:52

30 - Word 2019 Sectioning

148 - What is Sectioning.mp4

03:58

149 - Sectioning a document.mp4

12:12

150 - Odd and Even Sections.mp4

02:40

151 - Practice Exercise.mp4

01:02

31 - Word 2019 Graphics

152 - Inserting Pictures.mp4

04:52

153 - Inserting Pictures into Existing Documents.mp4

05:02

154 - Picture Options.mp4

10:34

155 - Working with Shapes.mp4

10:37

156 - Icons and 3D Models.mp4

05:20

157 - SmartArt Charts and Screenshots.mp4

13:34

158 - Practice Exercise.mp4

00:53

32 - Word 2019 Envelopes and Labels

159 - Working with Envelopes.mp4

06:09

160 - Working with Labels.mp4

03:44

33 - Word 2019 Mail Merges

161 - What is Mail Merge.mp4

04:07

162 - Creating a Mail Merge Document Part 1.mp4

12:01

163 - Creating a Mail Merge Document Part 2.mp4

09:54

164 - Merging a Document with an Existing Data Source.mp4

05:38

165 - Merging Envelopes and Labels.mp4

06:23

166 - Merging a Directory.mp4

04:01

167 - Practice Exercise.mp4

01:34

34 - Word 2019 Page Setup Options

168 - Building Blocks.mp4

07:44

169 - Auto Text.mp4

03:22

170 - Practice Exercise.mp4

01:01

35 - Word 2019 Indexing and Table of Contents

171 - Creating an Index.mp4

06:07

172 - Creating a Table of Contents.mp4

07:32

173 - Practice Exercise.mp4

01:43

36 - Word 2019 Review and Printing

174 - Using the Thesaurus and Spell Check.mp4

04:33

175 - Comments.mp4

04:05

176 - Page Setup Options.mp4

07:17

177 - Printing.mp4

06:20

178 - Practice Exercise.mp4

01:12

37 - Word 2019 Other Word Options

179 - Word Options.mp4

06:51

180 - Protecting a Document.mp4

02:51

181 - Macros.mp4

06:36

38 - Word 2019 Wrap Up

182 - Closing.mp4

00:23

39 - PowerPoint 2019 Course Introduction

183 - Welcome and Overview.mp4

03:20

184 - WATCH ME Essential Information for a Successful Training Experience.mp4

02:03

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.mp4

11:46

188 - Overview of the Screen and Views.mp4

12:16

189 - Exercise 1.mp4

01:11

41 - PowerPoint 2019 Getting Started

190 - Presentation Tips and Guidelines.mp4

08:11

191 - Creating a New Presentation.mp4

04:45

192 - Working with Slides.mp4

07:01

193 - Saving a Presentation.mp4

06:30

194 - Exercise 02.mp4

02:05

42 - PowerPoint 2019 Text and Bullet Editing Options

195 - Formatting Text.mp4

10:56

196 - Working with Bullets and Numbered Lists.mp4

10:51

197 - Exercise 03.mp4

01:27

43 - PowerPoint 2019 Adding Graphics

198 - Inserting Shapes.mp4

12:12

199 - Inserting Graphics.mp4

05:56

200 - Inserting Icons and 3D Models.mp4

06:24

201 - Inserting Pictures.mp4

06:42

202 - Exercise 04.mp4

01:13

44 - PowerPoint 2019 Working with objects

203 - Selecting Objects.mp4

03:38

204 - Editing Objects.mp4

04:35

205 - Formatting Objects Part 1.mp4

12:51

206 - Formatting Objects Part 2.mp4

09:03

207 - Arranging Objects.mp4

09:42

208 - Grouping Objects.mp4

06:27

209 - Exercise 05.mp4

01:25

45 - PowerPoint 2019 Editing pictures

210 - Picture Options.mp4

06:04

211 - Cropping Pictures.mp4

06:49

212 - Formatting Pictures.mp4

07:21

213 - Things You Can Do with Pictures.mp4

09:29

214 - Exercise 06.mp4

01:08

46 - PowerPoint 2019 Working with SmartArt

215 - Creating SmartArt.mp4

08:16

216 - Modifying SmartArt.mp4

06:05

217 - Creating a Flowchart using SmartArt.mp4

04:10

218 - Exercise 07.mp4

01:10

47 - PowerPoint 2019 Working with Tables

219 - Creating Tables.mp4

07:13

220 - Formatting Tables.mp4

06:19

221 - Inserting Tables.mp4

06:40

222 - Exercise 08.mp4

01:04

48 - PowerPoint 2019 Working with Charts

223 - Adding Charts.mp4

07:04

224 - Formatting Charts.mp4

12:52

225 - Inserting Charts from Microsoft Excel.mp4

04:29

226 - Exercise 09.mp4

01:12

49 - PowerPoint 2019 Unlocking the Power of Masters

227 - Using Master Slides.mp4

05:04

228 - Modifying Master Slides.mp4

08:00

229 - Creating a New Master Design Template.mp4

10:00

230 - Exercise 10.mp4

01:37

50 - PowerPoint 2019 Adding Media

231 - Adding Video to a Presentation.mp4

06:03

232 - Adding Audio to a Presentation.mp4

05:52

233 - Exercise 11.mp4

01:10

51 - PowerPoint 2019 Working with Transitions

234 - Applying Transitions.mp4

05:38

235 - Transition Options.mp4

06:04

236 - Exercise 12.mp4

01:02

52 - PowerPoint 2019 Animation

237 - Animating an Object.mp4

10:15

238 - Effect Options.mp4

05:54

239 - Working with the Animation Pane.mp4

05:12

240 - Motion Paths.mp4

05:57

241 - Triggers.mp4

08:52

242 - Exercise 13.mp4

01:24

53 - PowerPoint 2019 Hyperlinks and Action Buttons

243 - Working with Action Buttons.mp4

06:30

244 - Working with Hyperllinks.mp4

05:04

245 - Exercise 14.mp4

01:02

54 - PowerPoint 2019 Slideshow Options

246 - Onscreen Presentation Options.mp4

08:38

247 - Hiding Slides.mp4

03:28

248 - Changing the order of slides.mp4

02:42

249 - Copying slides.mp4

02:33

250 - Slideshow Options.mp4

04:51

251 - Exercise 15.mp4

01:32

55 - PowerPoint 2019 Preparing a presentation for delivery

252 - Rehearse Timings.mp4

06:06

253 - Recording a Presentation.mp4

04:19

254 - Slide Show Settings.mp4

04:03

255 - Creating a Custom Slide Show.mp4

03:28

256 - Exercise 16.mp4

01:18

56 - PowerPoint 2019 Exploring the Backstage Area

257 - Exporting options.mp4

05:52

258 - The Backstage Area.mp4

05:24

259 - Printing a Presentation.mp4

05:13

260 - Exercise 17.mp4

01:09

57 - PowerPoint 2019 Course Close

261 - Conclusion.mp4

01:19

58 - Access 2019 Beginners Introduction

262 - Introduction to Access 2019.mp4

03:19

263 - WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

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.mp4

04:24

268 - Structure of the Course.mp4

02:23

59 - Access 2019 Beginners Getting Started with Access 2019

269 - Using Database Templates.mp4

10:56

270 - Creating Saving and Opening Databases.mp4

06:41

271 - The Access Workspace and Backstage.mp4

13:41

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

08:42

60 - Access 2019 Beginners The Ribbon and Toolbars

273 - Working with the Ribbon.mp4

09:28

274 - The Quick Access Toolbar.mp4

05:57

275 - Contextual Menus.mp4

02:39

276 - The Status Bar.mp4

04:07

61 - Access 2019 Beginners Keyboard Shortcuts and Key Tip

277 - Keyboard Shortcuts.mp4

03:36

278 - Key Tips.mp4

03:52

62 - Access 2019 Beginners Access Options

279 - Exploring Access Options.mp4

09:15

63 - Access 2019 Beginners Tables

280 - Creating a Table and Fields.mp4

11:30

281 - Indexed Field.mp4

08:42

282 - Lookup Wizard.mp4

11:35

283 - Numeric Fields.mp4

07:46

284 - Practice Exercise 01.mp4

03:07

64 - Access 2019 Beginners Importing Data

285 - Importing Data from Excel.mp4

10:57

286 - Practice Exercise 02.mp4

05:38

65 - Access 2019 Beginners Backup Restore and Repair

287 - Backing up your Database.mp4

03:56

288 - Compact and Repair.mp4

06:23

66 - Access 2019 Beginners Datasheet View

289 - Design in the Datasheet View.mp4

10:12

290 - Sorting and Filtering in Datasheet View.mp4

09:56

291 - Entering and Modifying Data in Datasheet View.mp4

10:56

67 - Access 2019 Beginners Relationships

292 - Creating a Link Table.mp4

10:35

293 - Setting up Relationships.mp4

09:55

294 - Practice Exercise 03.mp4

10:21

68 - Access 2019 Beginners Forms

295 - Creating a Form.mp4

12:41

296 - Modifying a Form.mp4

05:15

297 - Practice Exercise 04.mp4

02:08

298 - Forms in Layout View.mp4

11:11

299 - Forms in Design View.mp4

10:00

300 - Form Design.mp4

11:11

301 - Practice Exercise 05.mp4

01:33

69 - Access 2019 Beginners Subforms

302 - Setting Up Subforms Part 1.mp4

13:02

303 - Setting Up Subforms Part 2.mp4

09:13

304 - Setting Up Subforms Part 3.mp4

13:24

305 - Practice Exercise 06.mp4

04:13

70 - Access 2019 Beginners Queries

306 - Creating a Query.mp4

13:27

307 - Joins.mp4

08:30

308 - Query Wizard.mp4

12:39

309 - Practice Exercise 07.mp4

09:45

71 - Access 2019 Beginners Expressions

310 - Setting Up Validations.mp4

10:40

311 - Calculation using Expressions.mp4

08:43

72 - Access 2019 Beginners Reports

312 - Basic Reports.mp4

07:46

313 - Report Design.mp4

10:43

314 - Complex Reports.mp4

13:29

315 - Practice Exercise 08.mp4

02:23

73 - Access 2019 Beginners Printing

316 - Printing and Print Properties.mp4

07:54

74 - Access 2019 Beginners More Data Types

317 - YesNo OLE Objects and Hyperlink Data Types.mp4

11:21

75 - Access 2019 Beginners More About Forms

318 - Form Controls.mp4

11:15

319 - Form Themes.mp4

12:37

320 - Navigation Forms.mp4

09:52

76 - Access 2019 Beginners Exporting

321 - Exporting an Access Database.mp4

04:16

77 - Access 2019 Beginners Application Parts

322 - Adding Application Parts to a Database.mp4

04:48

78 - Access 2019 Beginners More Access Options

323 - Additional Access 2019 Options.mp4

05:42

79 - Access 2019 Beginners Info Tab

324 - Edit Database Properties and Encrypt with Password.mp4

05:31

80 - Access 2019 Beginners Course Close

325 - Course Close.mp4

01:06

81 - Extras

326 - EXTRA LESSON Designing Better Spreadsheets Webinar Recording.mp4

01:04:55

327 - EXTRA LESSON Data Cleaning in Excel Webinar Recording.mp4

52:26

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

01:11:18

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

Description

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

What You'll Learn?

Learn the essential Microsoft Office Skills in this four-course bundle: Excel, Word, PowerPoint and Access
Learn practical methods to backup and recover your Excel spreadsheets and never lose data.
Effectively use autofill and flashfill so you are more productive in Microsoft Excel.
Discover the essentials of using formulas and functions in Excel
Discover how to create stunning charts and graphs in Excel
Learn practical methods to sort and filter your data in Excel
Discover new features in PowerPoint 2019 including Icons and 3D Models
Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint
Add charts, graphs and tables to your PowerPoint presentation information in a non-text format
Wow your audience by adding animations, audio and video to PowerPoint
Discover practical tips to present your PowerPoint presentation to your audience
Learn time saving techniques including how to copy slides, and exporting your presentation
Master the most common uses of Microsoft Word
Learn Word tools including using columns, indents, footers, borders and watermarks.
How to create a mail merge in Microsoft Word
Learn how to correctly Print envelopes and labels in Word
Learn to protect your Word document from changes
Insert professional pictures and graphics in your Word document
Make your Word documents look amazing by inserting and editing tables
Sorting information and running queries in Access
Navigating the Access 2019 interface
Discover how to into import data from Excel in Access
Learn Queries, use validations, how to create and print reports in Access
How to compact, repair and backup your Access database
How to create a linked table in Access

Who is this for?

Anyone new to Microsoft Office or upgrading from a previous version

What You Need to Know?

Excel, Word, PowerPoint and Access installed on your machine. Preferably Office 2019 or Office 365

More details

Description
This course includes practice exercises and LIFETIME access
Learn Excel, PowerPoint, Access and Word 2019 with this tremendous value 4-course bundle from Office experts Simon Sez IT.
Microsoft Office remains the go-to tool for the modern worker, yet so many workers donâ€™t utilize its full potential.
Weâ€™re here to make sure you arenâ€™t one of those people.
In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Access) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals.

What's included?
Excel 2019
What's new in Excel 2019
Creating workbooks
Entering text, numbers and working with dates
Navigating workbooks
Page setup and print options
Working with rows, columns and cells
Cut, Copy and Paste
Introduction to functions and formulas
Formatting in Excel, including formatting cells and numbers
Creating charts and graphs
Sorting and Filtering
Introduction to PivotTables
Logical and lookup formulas - the basics
PowerPoint 2019
How to navigate around PowerPoint
Presentation dos and don'ts
Text and bullet edition options
How to use graphics, images, objects and shapes
Using SmartArt
Working with Charts and Graphs
How to utilize Master Slides and just how much time this could save you
How to add audio and video to a presentation
All about transitions between slides
Animation, the animation pane and motion paths
Setting your slideshow options
Presentation preparation and delivery
The backstage area of PowerPoint including printing a presentation
Word 2019
How to get started with Word 2019
Word 2019 basics including navigation, editing and saving
Character formatting in Word including Format Painter and AutoCorrect
How to properly work with bullets and numbering in Microsoft Word
All about formatting paragraphs and managing lists
Working with Tables in Word including formatting, converting data and formulas
Page appearance including page-breaks, watermarks and styles
All about Sectioning a document
Inserting graphics, pictures, shapes, icons and 3d models (new for 2019)
How to work with envelopes and labels
All about mail-merge and operating Word at scale
How to create an Index or Contents page
Reviewing and Printing in Word and Page Setup
Protecting a Word document and basic macros in Word
Microsoft Access
Where to start in Microsoft Access and whether to use a template or not
How to modify Access to suit your needs
All about importing data and the datasheet view
How tables work in Access and how to create relationships between them
Creating forms and sub-forms that feed data into your tables
How to run queries in Access
Setting up validations and calculations using expressions in Access
Printing from Access
To start to use macros and Modal Dialog
The basics of the Access web app
Exporting and reporting in Access
Exercise and demo files included

This bundle includes:
29+ hours of video tutorials
300+ individual video lectures
Exercise files to practice what you learned
Certificate of completion

Hereâ€™s what our students are sayingâ€¦
"Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course."
- Yunesh Garusinghe
"I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you."
- Cavin Macwan
"Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!"
- Coreen Teoh

Did you know?
Simon Sez IT teaches all sorts of software, including:
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Word
- Microsoft Project
- Microsoft Outlook
- QuickBooks
- Photoshop Elements
- Web Development Languages
- And so much more!
Who this course is for:
Anyone new to Microsoft Office or upgrading from a previous version

User Reviews

Rating

average 0

Total votes0

Focused display

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 8,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 630,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.