Using the Status bar

- At the bottom of the screen, below sheet tabs,…you'll see an area referred to as the status bar.…Very often you'll see the word "Ready"…in the lower left corner.…As you work with Excel, sometimes you take certain actions,…maybe by mistake.…Perhaps I've touched Caps Lock here.…I didn't mean to do that but I see in…the lower left corner it says Caps Lock.…Well, okay, I'll turn it off.…It's a nice little indicator there.…I also have a Num Lock button;…sometimes I use it, sometimes I don't.…If I press the Num Lock button…I might see an indicator there, as well, too.…

But there are other uses for the status bar, as well.…On this worksheet, it's called "2015 HOME products revenue,"…if you're curious as to what the total revenue is here,…you could click the column letter "I".…At the bottom of the screen…I'm seeing a few statistical measures here.…This tells me what the average revenue is per item,…the count of how many items, and actually the total revenue.…That's valuable information.…You can even see more here.…

If you right click in the status bar,…

Resume Transcript Auto-Scroll

Author

Updated

3/1/2016

Released

9/22/2015

Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.

Topics include:

Working with the Excel interface

Entering data

Creating formulas and functions

Formatting rows, columns, cells, and data

Working with alignment and text wrap

Adjusting rows and columns

Finding and replacing data

Printing and sharing worksheets

Creating charts and PivotTables

Inserting and deleting sheets

Using power functions such as IF and VLOOKUP

Password-protecting worksheets and workbooks

Sorting data

Analyzing data with Goal Seek and Solver

Creating and running macros

Skill Level Beginner

8h 56m

Duration

1,495,130

Views

Show MoreShow Less

Q: This course was updated on 03/01/2016. What changed?

A: We added one tutorial about the new Funnel chart type in Excel 2016.