Excel 2019 Essentials

In this course, Excel 2019 Essentials, you’ll learn the basics of working with Excel 2019. You’ll learn how to work with the Excel interface and begin the process of putting data into Excel and manipulating that data to gain results.
Course info
Level
Beginner
Updated
Jan 31, 2019
Duration
2h 5m
Table of contents
Getting to Know Excel 2019
Backstage View
Working with Worksheets and Data
Working with Rows and Columns
Formatting
Totaling Values
Saving a File
Description
Course info
Level
Beginner
Updated
Jan 31, 2019
Duration
2h 5m
Description

Knowing the basics of Excel 2019 can help make you a more well rounded professional. In this course, Excel 2019 Essentials, you will learn foundational knowledge of the Excel interface and settings. First, you will learn how to work with the Ribbon interface and Backstage View. Next, you will discover how to work with worksheets, cells, columns, and rows. Finally, you will explore how to use formatting and Auto options, as well as how to save your file. When you’re finished with this course, you will have the skills and knowledge of Excel 2019 needed to begin creating your own spreadsheets (and begin preparation for the Microsoft Office exams.)

About the author
About the author

Bill Kulterman is an educator, author, and a Microsoft Certified Trainer (MCT). Bill has been a trainer for more than a dozen years, educating students in Excel, Visio and a bevy of additional solutions. In recent years he has focused solely on SharePoint and SharePoint Online through Office 365. When he's not creating courses, he can usually be found riding his bike or relaxing near his Koi pond.

More from the author
PowerPoint 2019 Power Users
Intermediate
2h 37m
Apr 16, 2019
PowerPoint 2019 Essentials
Beginner
2h 0m
Feb 15, 2019
More courses by Bill Kulterman
Section Introduction Transcripts
Section Introduction Transcripts

Backstage View
So what is the Backstage view, and how do I get there, and what do I do once I am there? Well, the Backstage view gives us another place to find options for Excel. Now you'll find some of the commands that you find on the ribbons, some of the same things will be there, but it's also going to give us some other options that have to do with Excel as a whole as well. How do we get there? Well, we're going to go here, the upper-left corner, and click on the File tab. Now the File tab is not another ribbon tab. When we click on it, it takes us to this, our Backstage view. And basically, what it does is takes us behind the scenes of Excel. Our workbook hasn't disappeared. Don't worry about it; we're going to be able to come back to it. But when we get to our Backstage view, the first thing we notice is over here on the left, this column of options. Right now we're on the Info option page, but we have New, Open, Save, Save As, History, all of these that you can see that we can access. And all we have to do is click on one, and it'll bring us to that option page. This is the Info option page, and we'll talk about that in another clip. But when we want to get back to our workbook, we simply have to click up here on this big back arrow, and it takes us right back to where we were. Again, click on File to get to the Backstage view, click on the back arrow to return to our workbook. And that is what your Backstage view is for.