Software Skills Training Excel 2019 - Beginner

Excel 2019 Beginner Tutorials & Tips

Excel 2019 - Beginner

0 seconds of 1 minute, 12 secondsVolume 90%

00:00

01:12

Overview

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

Course Playlist

Introduction

1 videos

1 min 12 sec
- Introduction 1 min 12 sec
Getting Started with Excel

6 videos

42 min 54 sec
- What is Excel? 3 min 35 sec
- Opening Excel 6 min 55 sec
- Navigating the Excel User Interface 9 min 56 sec
- Using the Excel Ribbon 6 min 55 sec
- Understanding Excel Worksheet Components 6 min 47 sec
- Using the Backstage View 8 min 46 sec
Creating Workbooks and Using Templates

4 videos

16 min 38 sec
- Creating a New Workbook 5 min 55 sec
- Creating Workbooks Using Templates 2 min 31 sec
- Saving an Excel Workbook 4 min 35 sec
- Using the Accessibility Checker 3 min 37 sec
Entering Data

8 videos

34 min 32 sec
- Navigating a Worksheet by Mouse or Keyboard 4 min 40 sec
- Understanding Excel Data Types 6 min
- Using the Inking Tools 6 min 29 sec
- Working with Cell and Range Addressing 3 min 21 sec
- Using Various Data Selection Techniques 3 min 3 sec
- Working with Common Excel Commands 4 min 41 sec
- Using the AutoFill Handle 4 min 10 sec
- Using Flash Fill 2 min 8 sec
Excel Formula Basics

7 videos

29 min 57 sec
- What are Formulas and Functions? 4 min 2 sec
- Understanding the Components of a Formula 6 min 7 sec
- Calculation Hierarchy and the Order of Operations 2 min 38 sec
- Creating Basic Formulas 3 min 6 sec
- Working with Basic Functions and AutoSum 6 min 18 sec
- Using Cell References 4 min 37 sec
- Using the Quick Analysis Tools 3 min 9 sec
Adjusting a Worksheet

2 videos

10 min 1 sec
- Modifying Columns and Rows 5 min 39 sec
- Hiding and Unhiding Columns and Rows 4 min 22 sec
Formatting and Aligning a Worksheet

7 videos

49 min 33 sec
- Formatting and Aligning Data 10 min 48 sec
- Merging Data 7 min 41 sec
- Wrapping Text and Adjusting Orientation 6 min 54 sec
- Formatting Numbers 8 min 28 sec
- Using Borders and Shading 7 min 10 sec
- Using the Format Painter 3 min 36 sec
- Removing Formatting Quickly 4 min 56 sec
Using Cell Styles and Themes

2 videos

9 min 58 sec
- Using Cell Styles 5 min 34 sec
- Applying Themes 4 min 24 sec
Inserting Objects and Graphics

11 videos

65 min 32 sec
- Inserting and Formatting Images 6 min 9 sec
- Inserting and Formatting Shapes 5 min 52 sec
- Inserting and Formatting SmartArt 9 min
- Working with Icons 5 min 49 sec
- Working with 3-D Models 5 min 15 sec
- Inserting Screenshots 5 min 20 sec
- Inserting Hyperlinks 4 min 56 sec
- Inserting Symbols and Equations 4 min 49 sec
- Inserting WordArt and Text Boxes 7 min 33 sec
- Inserting Other Excel Objects 6 min 17 sec
- Arranging Objects 4 min 32 sec
Proofing a Workbook

4 videos

15 min 46 sec
- Using Find and Replace 3 min 18 sec
- Using Go To and Go To Special 3 min 18 sec
- Using the Spell Checker 4 min 29 sec
- Using the Thesaurus and Translation Features 4 min 41 sec
Printing an Excel File

4 videos

18 min 14 sec
- Printing and Previewing Files 5 min 11 sec
- Creating Custom Margins and Scaling 4 min 38 sec
- Adding Headers and Footers 4 min 50 sec
- Exporting to PDF and XPS 3 min 35 sec
Managing Worksheets

2 videos

8 min 9 sec
- Renaming and Coloring Worksheet Tabs 3 min 37 sec
- Adding, Deleting and Navigating Worksheets 4 min 32 sec
Navigating and Viewing Excel Files

6 videos

26 min 49 sec
- Viewing Workbooks 5 min 7 sec
- Using Zoom Tools 2 min 19 sec
- Configuring Sheet Options 4 min 3 sec
- Using the Freeze Panes and Split Commands 6 min 14 sec
- Working with Window Commands 3 min 21 sec
- Adjusting Workbook Properties 5 min 45 sec
Conclusion

1 videos

54 sec
- Course Recap 54 sec

For Business

Give your team access to award-winning training content on the most popular software & business skills. We have options for every budget, with tiered pricing available on user count and multi-year discounts automatically applied.

Intellezy Select 50

Build a custom 50-course library from the Intellezy complete library.

Intellezy Full Library

Access to full library of courses, including 11,000+ video lessons.

Your subscription includes:

The Most-Up-to-Date Contentt

Content Available in 20+ Languages

Course Assessments & Downloadable Files

Deliverability via Your SCORM-Compliant LMS or Our Easy-to-Navigate Platform

And More!

Billed Monthly

$15/month

$180 total annually

Billed Annually

$12.50/month

$150 total annually

Your subscription includes:

11,000+ Video Lessons

Content Available in 20+ Languages

The Most-Up-to-Date Content

Content Available in 20+ Languages

Course Assessments & Downloadable Files

And More!

Excel 2019 Beginner Tutorials & Tips

Excel 2019 - Beginner

Overview

Course Playlist

Intellezy Select 50

Intellezy Full Library

Your subscription includes:

Billed Monthly

Billed Annually

Your subscription includes:

Unlocked Your Course