By Curt Frye | Tuesday, February 3, 2015
Excel users are often faced with spreadsheets that summarize sales data for multiple areas, such as states within the U.S. or individual countries.
Functions such as SUM or AVERAGE let you summarize your data as a whole—but it can be difficult to find the totals, averages, or counts for subsets of that data. For example, suppose you want to find the total of all sales to Canada. To do that using a standard SUM formula, you would have to identify cells that contain values for all sales to Canada and then create a formula for just those cells.
Fortunately, there’s a set of conditional functions in Excel that let you specify which values should be included in a sum, average, or count calculation. Those functions are: SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, and COUNTIFS.
Here’s how to take advantage of them:
By Curt Frye | Tuesday, January 27, 2015
Excel workbooks let you summarize your data using a powerful set of built-in functions and features such as sorting and filtering.
That said, basic worksheets are static and make rearranging data difficult. Fortunately, there’s a way to avoid all that cutting and pasting: Pivot Tables.
You can learn everything you’d ever want to know from my lynda.com courses Excel 2007: PivotTables for Data Analysis, Excel 2010: PivotTables in Depth, and Excel 2013: PivotTables in Depth.
But here’s a quick-start guide for you:
By Curt Frye | Thursday, June 26, 2014
Excel is a powerful and versatile tool you can use to analyze data—but not every capability you might want is built in.
Using the Visual Basic for Applications (VBA) language, you can script custom processes in Excel. VBA is an object-oriented language, which means that elements of Excel—such as workbooks, worksheets, and the program itself—are represented as objects. An object has three main components:
You can change your email preferences at any time. We will never sell your email. More info
Thanks for signing up.
We’ll send you a confirmation email shortly.
Sign up and receive emails about lynda.com and our online training library:
Keep up with news, tips, and latest courses with emails from lynda.com.
We've updated our terms and conditions (now called terms of service).Go Review and accept our updated terms of service.