November 2021
Beginner
1h 3m
English
on-demand course
Excel Essentials for Working with Columns, Cells, Worksheets, the Toolbar, and More: Covering Excel 2019 and Microsoft 365
with David Slager, Annette Slager
Closed Captioning available in English
Overview
Excel is a powerful and versatile spreadsheet program that has the versatility to be used for both business and personal needs, providing amazing capabilities that you can use to make any type of data more streamlined, visual, and productive.
In this introductory video you will discover how to add and remove, and change the order of items on the Quick Access Toolbar.
What You Will Learn
- How to change the location of the Quick Access Toolbar
- Become skilled at changing the column width and row heights to adjust for the length or height of data in your cells
- Test out how to create formulas to perform calculations on the data you have entered in the worksheet cells
- Use and customize the Quick Access Toolbar
You will practice creating, removing, renaming, moving, and copying worksheets. Find out how to hide them and then bring them back, change their order and how to make easily to identify the worksheets by changing their tab color.
You will learn how to select multiple cells so that you can then apply formatting, computations, etc. to multiple cells at one time. By dragging across multiple cells in your worksheet, learn how you can make Excel work like a calculator so that it can perform calculations such as sum, average, count, minimum, maximum, etc. You can select these options and more from the status bar. You will also learn how you can turn on and off various Excel features from the status bar.
This video is for anyone who is new to Excel and wants to learn about its features. It is also useful to those who want to continue building their Excel skills, or for those who want to get up to speed on the latest changes in the new versions of Excel.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.