Software Skills Training Excel 2016 - Beginner

Beginner Excel 2016 Course

Excel 2016 - Beginner

0 seconds of 1 minute, 3 secondsVolume 90%

00:00

01:03

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 3 sec
- Introduction 1 min 3 sec
Getting Started with Excel

6 videos

23 min 36 sec
- What is Excel? 2 min 1 sec
- Opening Excel 4 min 25 sec
- Navigating the Excel User Interface 7 min 48 sec
- Using the Excel Ribbon 2 min 55 sec
- Understanding Excel Worksheet Components 3 min 55 sec
- Using the Backstage View 2 min 32 sec
Creating Workbooks and Using Templates

4 videos

14 min 4 sec
- Creating a New Workbook 3 min 1 sec
- Creating Workbooks Using Templates 3 min 24 sec
- Saving an Excel Workbook 5 min 20 sec
- Using Convert and Checking Compatibility 2 min 19 sec
Entering Data

6 videos

25 min 18 sec
- Navigating a Worksheet by Mouse or Keyboard 4 min 52 sec
- Understanding Excel Data Types 2 min 50 sec
- Working with Cell and Range Addressing 2 min 20 sec
- Using Various Data Selection Techniques 5 min 14 sec
- Working with Common Excel Commands 7 min 25 sec
- Using the Autofill Handle 2 min 37 sec
Excel Formula Basics

7 videos

27 min 7 sec
- What are Formulas and Functions? 2 min 2 sec
- Understanding the Components of a Formula 5 min 39 sec
- Understanding Calculation Hierarchy and the Order of Operations 2 min 26 sec
- Creating Basic Formulas 8 min 9 sec
- Working with Basic Functions and AutoSum 3 min 59 sec
- Using Cell References 3 min 37 sec
- Using the Quick Analysis Tool 1 min 15 sec
Adjusting a Worksheet

2 videos

9 min 14 sec
- Modifying Columns and Rows 6 min 8 sec
- Hiding and Unhiding Columns and Rows 3 min 6 sec
Formatting and Aligning Worksheet Data

7 videos

19 min 56 sec
- Formatting and Aligning Data 5 min 47 sec
- Merging Data 3 min 52 sec
- Wrapping Text and Adjusting Orientation 1 min 45 sec
- Formatting Numbers 3 min 10 sec
- Using Borders and Shading 2 min 37 sec
- Using the Format Painter 1 min 21 sec
- Removing Formatting Quickly 1 min 24 sec
Using Cell Styles and Themes

3 videos

9 min 14 sec
- Understanding Cell Styles 1 min 38 sec
- Applying Cell Styles 4 min 23 sec
- Applying Themes 3 min 13 sec
Inserting Objects and Graphics

9 videos

30 min 37 sec
- Inserting and Formatting Images 2 min 46 sec
- Inserting and Formatting Shapes 4 min 27 sec
- Inserting and Formatting SmartArt 3 min 47 sec
- Inserting Screenshots 2 min 17 sec
- Inserting Hyperlinks 2 min 37 sec
- Inserting Symbols and Equations 3 min 13 sec
- Inserting WordArt and Text Boxes 3 min 50 sec
- Inserting Other Excel Objects 3 min 53 sec
- Arranging Objects 3 min 47 sec
Proofing a Workbook

5 videos

13 min 3 sec
- Using Find and Replace 3 min 43 sec
- Finding and Replacing Formatting 1 min 19 sec
- Using Go To and Go To Special 2 min 23 sec
- Using the Spell Checker 2 min 34 sec
- Using the Thesaurus and Translation Features 3 min 4 sec
Printing an Excel File

6 videos

20 min 11 sec
- Printing and Previewing Excel Files 2 min 57 sec
- Creating Custom Margins and Scaling 4 min 53 sec
- Adding Headers and Footers 3 min 40 sec
- Formatting a Page with the Page Layout Tab 2 min 34 sec
- Printing Titles and Specific Worksheet Areas 4 min 31 sec
- Exporting to PDF and XPS 1 min 36 sec
Managing Worksheets

4 videos

11 min 58 sec
- Renaming and Coloring Worksheet Tabs 2 min 34 sec
- Adding, Deleting, and Navigating Worksheets 3 min 29 sec
- Moving and Copying Worksheets 3 min 44 sec
- Hiding and Unhiding Worksheets 2 min 11 sec
Navigating and Viewing Excel Files

6 videos

18 min 25 sec
- Viewing Workbooks 2 min 44 sec
- Using Zoom Tools 2 min 13 sec
- Configuring Sheet Options 2 min 16 sec
- Using the Freeze Panes and Split Commands 4 min 49 sec
- Working with Window Commands 3 min 41 sec
- Adjusting Workbook Properties 2 min 42 sec
Conclusion

1 videos

1 min 42 sec
- Course Recap 1 min 42 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!

Beginner Excel 2016 Course

Excel 2016 - Beginner

Overview

Course Playlist

Intellezy Select 50

Intellezy Full Library

Your subscription includes:

Billed Monthly

Billed Annually

Your subscription includes:

Unlocked Your Course