![]() Opening Comments Formulas are equations that perform calculations on values. ![]() ![]() We'll enhance your ability to analyze your data by showing you how to summarize cell data that meets conditions you define, round cell values up and down, and summarize your data using named ranges, data lists, and Excel tables. Advanced Formulas and Functions in Microsoft Excel This document provides instructions for using some of the more complex formulas and functions in Microsoft Excel, as well as using absolute references in formulas. I'll also show you how to discover more information by using the Excel help system. Then, using that knowledge as a base, I'll demonstrate how to create formulas that find the sum or average of groups of numbers. In the following figure, cell B10 has the calculated result, but look up at the Formula Bar and you can see the actual function as it was entered. I'll begin by explaining the difference between formulas and functions. An alternative is to type the range of those cells. In this course, I'll show you how to use formulas and built-in functions to summarize your data effectively. (upbeat piano music) - Hi, I'm Curt Frye, welcome to Excel 2007, Introduction to Formulas and Functions.
0 Comments
Leave a Reply. |