Microsoft Excel & PowerPoint 2019/365 Essential Training

Focused View

Simon Sez IT

20:37:41

130 View

1. Excel 2019 Beginner Intro to Excel

1. Intro to Excel.mp4

01:00

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

02:03

3.1 Excel 2019 Beginner Course Exercise Files.zip

3. Course Exercise Files.html

4.1 Microsoft Excel 2019 Course by Simon Sez IT.pdf

4. Downloadable Course Transcripts.html

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

03:12

9. Back Stage View.mp4

02:37

10. Section 1 - Quiz.html

2. Excel 2019 Beginner Creating Workbooks

1. Entering Text and Numbers.mp4

04:32

2. Creating Basic Formulas.mp4

06:49

3. Relative References.mp4

03:01

4. Order of Operations.mp4

04:48

5. Working with Ranges.mp4

04:14

6. Module 2 - Practice Exercise.mp4

01:35

7. Section 2 Quiz.html

3. Excel 2019 Beginner Saving Workbooks

1. Working with the Save and Save As Commands.mp4

04:34

2. File Extensions, Share, Export and Publish Files.mp4

03:44

3. Module 3 - Practice Exercise.mp4

00:59

4. Section 3 Quiz.html

4. Excel 2019 Beginner Navigating Workbooks

1. Opening a File.mp4

05:33

2. Working with Larger Files.mp4

05:34

3. Freeze Panes Option.mp4

03:16

4. Split Screen Option.mp4

03:22

5. Module 4 - Practice Exercise.mp4

02:50

6. Section 4 Quiz.html

5. Excel 2019 Beginner Page Setup & Print Options

1. Headers and Footers.mp4

07:23

2. Print Titles.mp4

02:52

3. Comments.mp4

05:23

4. Page Setup Options.mp4

07:30

5. Fit to Print on One Page.mp4

03:59

6. Printing Workbooks.mp4

03:55

7. Module 5 - Practice Exercise.mp4

01:53

8. Section 5 Quiz.html

6. Excel 2019 Beginners Working with Rows, Columns and Cells

1. Adding and deleting rows columns and cells.mp4

06:12

2. Changing Column and-Row Widths.mp4

03:45

3. Module 6 - Practice Exercise.mp4

01:11

4. Section 6 Quiz.html

7. Excel 2019 Beginners Moving Data

1. Cut, Copy and Paste.mp4

07:07

2. Copying Formulas.mp4

05:09

3. Module 7 - Practice Exercise.mp4

01:20

4. Section 7 Quiz.html

8. Excel 2019 Beginners Formulas & Functions

1. Overview of Formulas.mp4

02:48

2. Create Formulas Using Functions Part 1.mp4

10:04

3. Create Formulas Using Functions Part 2.mp4

05:24

4. Absolute Values.mp4

05:16

5. Module 8 - Practice Exercise.mp4

01:20

6. Section 8 Quiz.html

9. Excel 2019 Beginner Working with Sheets

1. Adding Deleting and Renaming Sheets.mp4

04:09

2. Additional Sheet Tab Options.mp4

05:19

3. 3 Dimensional Formulas.mp4

05:28

4. Module 9 - Practice Exercise.mp4

01:31

5. Section 9 Quiz.html

10. Excel 2019 Beginner Formatting Worksheets

1. Formatting Cells Part 1.mp4

10:04

2. Formatting Cells Part 2.mp4

03:38

3. Formatting Numbers.mp4

09:24

4. Borders and Shading.mp4

07:08

5. Format as Table.mp4

06:07

6. Using Styles.mp4

03:49

7. Using Format Painter.mp4

04:29

8. Protecting Sheets.mp4

09:01

9. Fill Handle and Custom Lists.mp4

07:17

10. Module 10 - Practice Exercise.mp4

01:10

11. Section 10 Quiz.html

11. Excel 2019 Beginner Charts

1. Creating Charts.mp4

09:48

2. Types of Charts.mp4

05:58

3. Editing Charts Part 1.mp4

11:00

4. Editing Charts Part 2.mp4

03:12

5. Using Graphics to Enhance Charts.mp4

05:05

6. Linking Chart Titles.mp4

02:47

7. Module 11 - Practice Exercise.mp4

00:53

8. Section 11 Quiz.html

12. Excel 2019 Beginner Working with Names

1. Creating Range Names.mp4

00:35

2. Managing Names.mp4

03:17

3. Using Names in Formulas.mp4

05:59

4. Module 12 - Practice Exercise.mp4

01:20

5. Section 12 Quiz.html

13. Excel 2019 Beginner Sorting and Filtering

1. Remove Duplicates.mp4

07:45

2. Sort Data.mp4

10:28

3. Filter Data.mp4

07:38

4. Advanced Filters.mp4

04:46

5. Module 13 - Practice Exercise.mp4

00:57

6. Section 13 Quiz.html

14. Excel 2019 Beginner Outlining and Subtotaling

1. Creating an Outline.mp4

06:01

2. Subtotals.mp4

08:00

3. Module 14 - Practice Exercise.mp4

01:08

4. Section 14 Quiz.html

15. Excel 2019 Beginner Working with Views

1. Arranging Files.mp4

03:14

2. New Window Option.mp4

02:45

3. Custom Views.mp4

05:32

4. Module 15 - Practice Exercise.mp4

01:07

5. Section 15 Quiz.html

16. Excel 2019 Beginner Linking Files

1. Creating Formulas Between File.mp4

06:35

2. Working with Links.mp4

04:01

3. Consolidating Data.mp4

05:16

4. Module 16 - Practice Exercise.mp4

01:30

5. Section 16 Quiz.html

17. Excel 2019 Beginner Advanced Formula Creation

1. If Statements.mp4

07:49

2. VLookups.mp4

07:39

3. Data Validation.mp4

08:13

4. Formula Auditing.mp4

05:29

5. Module 17 - Practice Exercise.mp4

01:20

6. Section 17 Quiz.html

18. Excel 2019 Beginner Pivot Tables

1. Pivot Tables.mp4

09:36

2. Pivot Charts.mp4

03:16

3. Module 18 - Practice Exercise.mp4

00:56

4. Section 18 Quiz.html

19. Excel 2019 Beginner Additional Excel Features

1. Slicers.mp4

04:41

2. Goal Seeker.mp4

02:56

3. Text to Columns.mp4

02:49

4. Watch Window.mp4

02:32

5. Customizing Ribbons and Tabs.mp4

03:25

6. Module 19 - Practice Exercise.mp4

01:23

7. Section 19 Quiz.html

20. Excel 2019 Beginner Shortcuts

1. Excel Shortcuts Every User Should Know.mp4

12:00

21. Excel 2019 Beginner Closing

1. Closing Video.mp4

00:37

22. PowerPoint 2019 Course Introduction

1. Welcome and Overview.mp4

03:20

2. WATCHE ME Essential Information for a Successful Training Experience.mp4

02:03

3.1 PowerPoint 2019 Exercise Files.zip

3. Course Exercise Files.html

4.1 Microsoft PowerPoint 2019 Course by Simon Sez IT .pdf

4. Downloadable Course Transcript.html

23. PowerPoint 2019 Overview

1. Navigate a PowerPoint Presentation.mp4

11:46

2. Overview of the Screen and Views.mp4

12:16

3. Exercise 1.mp4

01:11

24. PowerPoint 2019 Getting Started

1. Presentation Tips and Guidelines.mp4

08:11

2. Creating a New Presentation.mp4

04:45

3. Working with Slides.mp4

07:01

4. Saving a Presentation.mp4

06:30

5. Exercise 02.mp4

02:05

6. Section 24 Quiz.html

25. PowerPoint 2019 Text and Bullet Editing Options

1. Formatting Text.mp4

10:56

2. Working with Bullets and Numbered Lists.mp4

10:51

3. Exercise 03.mp4

01:27

4. Section 25 Quiz.html

26. PowerPoint 2019 Adding Graphics

1. Inserting Shapes.mp4

12:12

2. Inserting Graphics.mp4

05:56

3. Inserting Icons and 3D Models.mp4

06:24

4. Inserting Pictures.mp4

06:42

5. Exercise 04.mp4

01:13

6. Section 26 Quiz.html

27. PowerPoint 2019 Working with objects

1. Selecting Objects.mp4

03:38

2. Editing Objects.mp4

04:35

3. Formatting Objects - Part 1.mp4

12:51

4. Formatting Objects - Part 2.mp4

09:03

5. Arranging Objects.mp4

09:42

6. Grouping Objects.mp4

06:27

7. Exercise 05.mp4

01:25

8. Section 27 Quiz.html

28. PowerPoint 2019 Editing pictures

1. Picture Options.mp4

06:04

2. Cropping Pictures.mp4

06:49

3. Formatting Pictures.mp4

07:21

4. Things You Can Do with Pictures.mp4

09:29

5. Exercise 06.mp4

01:08

6. Section 28 Quiz.html

29. PowerPoint 2019 Working with SmartArt

1. Creating SmartArt.mp4

08:16

2. Modifying SmartArt.mp4

06:05

3. Creating a Flowchart using SmartArt.mp4

04:10

4. Exercise 07.mp4

01:10

5. Section 29 Quiz.html

30. PowerPoint 2019 Working with Tables

1. Creating Tables.mp4

07:13

2. Formatting Tables.mp4

06:19

3. Inserting Tables.mp4

06:40

4. Exercise 08.mp4

01:04

5. Section 30 Quiz.html

31. PowerPoint 2019 Working with Charts

1. Adding Charts.mp4

07:04

2. Formatting Charts.mp4

12:52

3. Inserting Charts from Microsoft Excel.mp4

04:29

4. Exercise 09.mp4

01:12

5. Section 31 Quiz.html

32. PowerPoint 2019 Unlocking the Power of Masters

1. Using Master Slides.mp4

05:04

2. Modifying Master Slides.mp4

08:00

3. Creating a New Master Design Template.mp4

10:00

4. Exercise 10.mp4

01:37

5. Section 32 Quiz.html

33. PowerPoint 2019 Adding Media

1. Adding Video to a Presentation.mp4

06:03

2. Adding Audio to a Presentation.mp4

05:52

3. Exercise 11.mp4

01:10

4. Section 33 Quiz.html

34. PowerPoint 2019 Working with Transitions

1. Applying Transitions.mp4

05:38

2. Transition Options.mp4

06:04

3. Exercise 12.mp4

01:02

4. Section 34 Quiz.html

35. PowerPoint 2019 Animation

1. Animating an Object.mp4

10:15

2. Effect Options.mp4

05:54

3. Working with the Animation Pane.mp4

05:12

4. Motion Paths.mp4

05:57

5. Triggers.mp4

08:52

6. Exercise 13.mp4

01:24

7. Section 35 Quiz.html

36. PowerPoint 2019 Hyperlinks and Action Buttons

1. Working with Action Buttons.mp4

06:30

2. Working with Hyperllinks.mp4

05:04

3. Exercise 14.mp4

01:02

4. Section 36 Quiz.html

37. PowerPoint 2019 Slideshow Options

1. Onscreen Presentation Options.mp4

08:38

2. Hiding Slides.mp4

03:28

3. Changing the order of slides.mp4

02:42

4. Copying slides.mp4

02:33

5. Slideshow Options.mp4

04:51

6. Exercise 15.mp4

01:32

38. PowerPoint 2019 Preparing a presentation for delivery

1. Rehearse Timings.mp4

06:06

2. Recording a Presentation.mp4

04:19

3. Slide Show Settings.mp4

04:03

4. Creating a Custom Slide Show.mp4

03:28

5. Exercise 16.mp4

01:18

39. PowerPoint 2019 Exploring the Backstage Area

1. Exporting options.mp4

05:52

2. The Backstage Area.mp4

05:24

3. Printing a Presentation.mp4

05:13

4. Exercise 17.mp4

01:09

40. PowerPoint 2019 Course Close

1. Conclusion.mp4

01:19

41. Extras

1. EXTRA LESSON Designing Better Spreadsheets Webinar Recording.mp4

01:04:55

2. EXTRA LESSON Data Cleaning in Excel Webinar Recording.mp4

52:26

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

01:11:18

4. EXTRA LESSON Creating Engaging PowerPoint Presentations Webinar Recording.mp4

01:01:45

5.1 Powerpoint.pdf

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

6.1 PC Excel Most Used.pdf

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

42. Bonuses

1. Ten Excel Tips and Tricks - Part 1.mp4

43:23

2. Ten Excel Tips and Tricks - Part 2.mp4

40:36

3. Ten Excel Tips and Tricks - Part 3.mp4

37:09

Description

Take your Microsoft Office presentations and spreadsheets to the next level with this Excel + PowerPoint combined course

What You'll Learn?

Discover new and improved features in Excel 2019
Learn how create, save, and open an Excel workbook
Learn how to personalize your use of Excel 2019 using Excel Options.
Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
Learn the basics of entering and editing data in a workbook.
Discover how to format dates and numbers in Excel.
Learn practical methods to backup and recover your Excel spreadsheets and never lose data.
Learn about the amazing autofill and flashfill in Excel to enhance your productivity
Discover the essentials of using fomulas and functions
How to rename, insert, move, and reference an Excel worksheet.
Discover how to create stunning charts and graphs in Excel
Learn practical methods to sort and filter your data
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 present information in a non-text format
Wow your audience by adding animations, audio and video
Learn time saving techniques including how to copy slides, and exporting your presentation
Discover practical tips to present your presentation to your audience
Discover templates and how to use them to reuse your PowerPoint designs

Who is this for?

Users new to Microsoft Excel and PowerPoint 2016 and those upgrading from previous software versions

Anyone who wants to learn how to give effective reports and presentations using Microsoft Excel and PowerPoint

Beginners who wants to master Excel and PowerPoint

More details

Description
This course includes practice exercises and LIFETIME access

Learn to use Microsoft Excel and PowerPoint 2019, master spreadsheets, and deliver outstanding presentations in this two-course bundle.

The Excel 2019 Course:
With this 7-hour Microsoft Excel 2019/365 course, youâ€™ll gain a fantastic grounding in Microsoft Excel. This in-depth course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. This course is perfect if youâ€™re brand new to Excel or are upgrading from an older version.
What You'll Learn:
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
Exercise and demo files included

The PowerPoint 2019 Course:
In this in-depth PowerPoint 2019 course, we not only teach you through the most business-relevant PowerPoint techniques, you then get to put into practice what you learn through exercises at the end of each chapter.
This PowerPoint 2019 course will help you:
Utilize templates to improve your efficiency
Create professional looking presentations using PowerPoint's new Icons function
Include multi-media to take your presentations up a notch
What You'll Learn:
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
This 2-course bundle includes:
14-hours of video tutorials
170+ individual video lectures
Exercise files to practice what you learned
Certificate of completion

Hereâ€™s what our students are sayingâ€¦
â€œAs someone who has no experience with Microsoft Excel I am finding this course very easy to understand and follow. Great pace and the modules don't overwhelm you. So glad I purchased this.â€
- Sharon Knight
â€œYes of course, it was a wonderful learning. This will be very much beneficial in my professional life. Thank you !â€
- Armesh Kamble
â€œI had learned excel a long time ago, but never used it much or worked with formulas. Most of the "work"was more for inventory. This was very helpful and I will be using it more for the applications described. Thank-you!â€
- Wendy Gonigan

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:
Users new to Microsoft Excel and PowerPoint 2016 and those upgrading from previous software versions
Anyone who wants to learn how to give effective reports and presentations using Microsoft Excel and PowerPoint
Beginners who wants to master Excel and PowerPoint

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.