Microsoft Excel 2019 Level 1 - Beginner Excel 2019

Focused View

Kirt Kershaw

6:23:43

94 View

1. Introduction

1. Introduction.mp4

01:27

2. Practice Activities and Instructor Notes

1.1 Excel 2019 L1-Exercises Instructor Notes.zip

1. Practice Activities and Instructor Notes.mp4

04:51

3. Basics

1. Excel 2019 First Look! Overview.mp4

16:07

2. Themes, Save Location, Back Stage And Fonts.mp4

14:21

3. Quick Access Toolbar.mp4

05:21

4. Ribbon.mp4

09:02

5. Cell Selection, Navigating Shortcuts, Tips And Tricks.mp4

10:28

6. Data Entry And Creating a Basic Worksheet.mp4

05:53

7. Save, Save As And Backup Copy.mp4

05:35

8. Convert To 2019.mp4

03:43

9. Compatibility Checker.mp4

07:02

10. Tell Me What You Want To Do - Help Feature.mp4

03:36

11. Excel Basics Quiz.html

4. Functions And Formulas

1. Basic Formulas.mp4

13:20

2. Introduction to Functions with SUM And AVERAGE Functions.mp4

14:38

3. MIN And MAX.mp4

04:13

4. COUNT And COUNTA.mp4

05:03

5. Move, Copy, Cut, And Paste Data into Cells.mp4

14:07

6. Absolute And Relative References.mp4

05:56

7. Mixed References.mp4

05:51

8. AutoFill.mp4

08:33

9. FlashFill.mp4

05:59

10. Converting Text into Columns.mp4

04:47

11. Functions And Formulas Quiz.html

5. Editing Worksheets

1. Editing Cell Data.mp4

07:36

2. Insert And Delete Cells, Columns and Rows.mp4

05:51

3. Find And Replace Data.mp4

09:29

4. GoTo.mp4

05:16

5. TRANSPOSE.mp4

04:52

6. Change Height, Width and Hide Rows and Columns.mp4

07:09

7. Check Worksheet or Workbook Spelling with Spell Check.mp4

03:32

8. Smart Lookup And Thesaurus.mp4

03:22

9. Editing Worksheets Quiz.html

6. Formatting

1. Formatting Text.mp4

04:54

2. Basic Number Formats.mp4

06:11

3. Basic Custom Number Format.mp4

06:39

4. Adding Borders And Colors to Cells.mp4

08:04

5. Formatting Shortcuts.mp4

06:53

6. Adding Background.mp4

01:56

7. Align, Merge And Wrap Cell Data.mp4

08:08

8. Cell Styles.mp4

06:19

9. AutoFormat.mp4

02:19

10. Basic Conditional Formatting.mp4

05:27

11. Conditional Formatting Manager.mp4

03:40

12. Formatting Quiz.html

7. Print

1. Print Page Breaks, Grildines And Headlines.mp4

10:54

2. Page Orientation.mp4

04:45

3. Print Rows at the Top of Each Page - Repeat Column Headers.mp4

08:18

4. Headers And Footers.mp4

10:45

5. Editing Page Margins And Center on Page.mp4

07:10

6. Page Breaks.mp4

10:54

7. Setting Print Range And Scaling.mp4

11:55

8. Print Quiz.html

8. Modifying Worksheet Appearance

1. Name, Move, Copy, Color, Link Worksheets in Workbook.mp4

12:17

2. Hide Worksheets And Workbooks.mp4

05:39

3. Split Worksheet.mp4

03:50

4. Freeze Panes.mp4

06:20

5. New Windows - Multiple Workbook Views.mp4

03:23

6. Customize Formula Options.mp4

03:22

7. Speak Cells.mp4

01:54

8. Sound Feedback (New to 2019!).mp4

02:01

9. Accessibility Checker - One Click Fix! (New to 2019!).mp4

01:31

10. Translate (New to 2019!).mp4

01:15

11. Modifying Worksheet Appearance Quiz.html

12. BONUS! - Special Offer! Discount on ANY of my Courses!.html

Description

Learn Microsoft Excel skills that will give you a solid foundation (Microsoft Excel 2010, 2013, 2016, 2019 and 365).

What You'll Learn?

Build a solid foundation on the Basics of Microsoft Excel
Create a Basic Worksheet from scratch
Write simple Formulas and performing Calculations
Use Relative, Absolute and Mixed References
Learn how to do basic and setup your own custom number formats
More tips, tricks and shortcuts by a Multi-Certified Microsoft Trainer with over 18 years of Excel training

Who is this for?

This Microsoft Excel 2019 Beginner Level 1 course is for anyone who is just starting out in Excel and also wants the latest, newest features available in Excel 2019 and Office 365 Excel skills

For those who’ve used Excel, but want to find out some little-known tips, tricks and shortcuts and become more efficient

What You Need to Know?

You will need Excel installed on your computer to follow along and complete the exercise files

Videos have been recorded using Excel 2019, and most features will work in Excel 2010, 2013, 2016 and 365

More details

Description
Quickly Get a Solid Foundation on Excel 2019 BasicsÂ Â
During this Microsoft Excel Level 1 â€“ Beginner course you will gain a solid foundation on which you will build the rest of your Excel experience on. Enroll now and I'll guide you step-by-step, through the basics of working with the basics on formulas and functions. In very little time you will master the basics of Excel that'll provide a sure foundation for more intermediate to advanced Excel techniques.Â
At completion of this course you will have mastered the most popular Excel basic tools and have the foundational skills with a sureness to complete many daily Excel tasks with efficiency and ease.Â Â Below are just a few of the topics that you will master:Â Â
Build a solid understanding on the basics of Microsoft Excel
Writing formulas and performing calculations
SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, TRANSPOSE functions
Inserting headers and footers, and adjusting margins
Print row and, or column page titles
Color code data that meet certain criteria with Conditional Formatting
Save time applying formatting to other cells with shortcuts
Copy formulas about with accuracy by applying Absolute and, or Mixed References
Save time entering data using the AutoFill and FlashFill features
Split Worksheet, Freeze Panes and add Multiple Views
New to Excel 2019! Sound Feedback, Check Accessibility one click fix, Translate and more!
Who this course is for:
This Microsoft Excel 2019 Beginner Level 1 course is for anyone who is just starting out in Excel and also wants the latest, newest features available in Excel 2019 and Office 365 Excel skills
For those whoâ€™ve used Excel, but want to find out some little-known tips, tricks and shortcuts and become more efficient

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Kirt Kershaw

Instructor's Courses

Kirt Kershaw is President of Dream Force LLC and provides certified and professional training videos on Microsoft Office applications including: Access, Excel, Outlook, PowerPoint, Word, Project and Windows since 2000. His certifications include: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016. Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP), Certified Microsoft Project XP (2002), 2010 and 2013 and CompTIA's A+. Whew! With all my certifications and experience you're probably looking at the biography of the only Microsoft trainer on the web who has the most Microsoft teaching experience and holds the most Microsoft certifications. So, I do have a lot to share in my arsenal of Microsoft Office training. What Makes My Training Unique? If you've read my reviews, seen my certifications (above) and my training videos, you probably already know the answer to this; I focus on step-by-step basics to more advanced training including: unique tips, tricks, shortcuts and other Microsoft Office time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass Microsoft Access, Excel, Outlook, Project, PowerPoint and Word Exams and become certified!

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.