Excel 2007: Advanced Formulas and Functions
In Excel 2007: Advanced Formulas and Functions, author and trainer Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. He then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and even work with financial data using advanced formulas. Dennis focuses on practical examples that will help users easily transition to using these formulas and functions in real-world scenarios. Exercise files accompany this course.
- Referencing, copying, updating, and converting formulas
- Using the logical functions and creating compound logic tests
- Searching for and matching data based on specific criteria
- Formatting cell data using functions
- Calculating dates, times, and days of the week
- Analyzing mathematical and financial data
(Music playing.) Hello! I am Dennis Taylor and I am pleased to present Excel 2007 Advanced Formulas and Functions. If you are like most Excel users, you want to know more about this software. You used some of the other 300-plus functions, but you realize that you might be missing something. Shouldn't there be a better way to do what it is you are doing? In this course, I'll show you practical examples of some of the advanced formulas and functions in Excel to make you more confident as you work with your data.
I'll start by giving you some great shortcuts and tips to speed your work in Excel, then a quick review of the basic functions as a foundation. I'll show you the powerful If function and a variety of LOOKUP functions, including VLOOKUP, Match and Index to help you find exactly what you are looking for. You'll see how to use some vital Math and Financial functions and how to work with the very useful Date functions to analyze data in a variety of ways. I'll teach you how to use powerful Array formulas and functions to expand your analytical powers, and use a few indispensable text functions to organize your data.
Finally, I'll show you a dazzling technique for creating multi-tiered pick-lists via the obscure Indirect function. With this wealth of tips and practical examples, I know you'll be ready to tackle more Excel challenges in ways you never thought possible. So let's get started working on Excel 2007 Advanced Formulas and Functions.
There are currently no FAQs about Excel 2007: Advanced Formulas and Functions.
Illustrator CC 2013 One-on-One: Fundamentals1,635,156 Views
Illustrator CC 2013 One-on-One: Mastery287,223 Views
Excel 2013 Essential Training5,687,914 Views
Illustrator CC 2013 One-on-One: Advanced376,992 Views
iOS 8 App Development with Swift 1 Essential Training1,001,384 Views
Edge Animate Essential Training593,690 Views
Excel 2007 Essential Training2,805,842 Views
Pages 5 Essential Training159,262 Views
Illustrator CC 2013 One-on-One: Intermediate527,762 Views
Excel 2010 Essential Training5,772,091 Views