July 2007
Beginner
256 pages
7h 29m
English
Content preview from Excel® 2007: Top 100 Simplified® Tips & TricksBecome 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,
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.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.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.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.
Chapter 2. Work with Formulas and Functions
Excel provides you with tools for storing numbers and other kinds of information. However, the real power of Excel comes from manipulating all this information. You can use formulas and functions to calculate in Excel.
The more than 300 functions built into Excel enable you to perform tasks of every kind, from adding numbers to calculating the internal rate of return for an investment. You can think of a function as a black box. You put your information into the box, and out come the results you want. You do not need to know any obscure algorithms to use functions.
Each bit of information you provide is called an argument. Excel’s Function Wizard provides guidance for every argument for every function. A formula consists of an equal sign, one or more functions, their arguments, operators such as the division and multiplication symbols, and any other values required to get your results.
Many Excel functions do special-purpose financial, statistical, engineering, and mathematical calculations. The Function Wizard arranges functions in categories for easy access. The Payment (PMT) function in the Financial category, for example, enables you to determine an optimal loan payment for a given principal, interest rate, and length of loan.
This chapter introduces useful techniques for making formulas and functions even easier, including the Function Wizard and the Excel calculator. You can also find tips for working more efficiently with functions ...
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.
Read 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.