The ribbon, which displays many of the program’s capabilities without requiring you to open a menu, makes it easier for you to find what you’re looking for and to discover capabilities you might not have encountered before.
- [Tutor] When you start Excel 2019 for the first time, the program can be pretty intimidating. You're faced with a blank spreadsheet and literally hundreds of user interface options. Where do you begin? Rather than dive straight into the details of how to manipulate Excel, I'll take a few minutes to show you what's possible. After you get a feel for what you can do in the program, I'll show you how to perform specific tasks. The sample file that I'll use is the What To Do Workbook and you can find it in the Chapter One folder of the Exercise Files collection.
In this workbook I have an Excel Table that tracks the cash on hand for a business. You can see that here, in what's called an Excel Table that starts in column B and runs through column E. I have four columns of data: those are the date of an expenditure or starting balance, the income if any, the expense if any, and then the running balance. And you can see that all expenses are subtracted from the previous balance and income is added.
Also note that on the right side I have a chart that summarizes the data from my table, and that gives a visual indication of how much cash is on hand at any particular time. Also note that I have indicated values in red within the body of the table. You can see that I have two values where the tax is in red and those are in cells E9 and E11. The conditional formatting rule that I created, highlights in red and bold any number that is less than $70,000.00.
In other words I'm assuming that the business had a rule in place that it wanted to keep at least $70,000.00 in its bank account at all times, and if it had less than that then there should be an indication. Finally you can also collaborate with your colleagues. One way to do that among many is to provide comments. You might notice the red flag here in cell D10 and in that cell I have added a comment. You can see it from me, we might be able to get this expense down to $45,000.00.
If I click the cell, I can perform in the edits that I like or I can wait until we know exactly what the expense will be. Excel 2019 is a powerful and versatile program that let's you summarize your data numerically, as well as visually. I'm sure you'll see how Excel 2019 enables you to manage your data efficiently and effectively.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.