The new Formula Tab


show more The new Formula Tab provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

The new Formula Tab

We've had to review some pretty heavy concepts when learning how to work with formulas in excel. But Microsoft doesn't want it to be that difficult for people to use. So what they've done is they've come up with the Formulas tab, which houses a Function Library that you can access. Now what functions are, are predefined formulas that perform calculations by using specific values in a particular order. For example, AutoSum will automatically sum all of the values in a row or column that you define. We're going to take a look at some of the most commonly used functions in another chapter, but let's just see how we group the Function Library, in case you're interested in taking a look at these on your own.

You have a recently used grouping, which will house all of the most recently used functions for you, so that they're easy to grab, and you're not having to search for them. There's a Financial grouping of functions which help with financial and a...

The new Formula Tab
Video duration: 5m 59s 5h 13m Beginner

Viewers:

The new Formula Tab provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...