Excel Formulas and Functions

For many Excel users, creating and manipulating formulas and functions is at the heart of what they do. Formulas and functions are some of Excel’s best features that save you the most time and effort!

If you want to move to a higher level of Excel productivity, you need the most vital and time-saving tips that will simplify formula building. Now, top Excel trainer and author Dennis Taylor is here to give you a roadmap into the hundreds of Excel functions that can dramatically increase your day-to-day efficiency.

As you manipulate worksheets of increasing complexity, you also need auditing tools that let you quickly locate formulas, debug problematical formulas, and locate cells that affect formula results. Your productivity will improve immeasurably if you utilize the powerful AutoSum tool and its allied features, get familiar with the Insert Function tool, and master the intricacies of lookup and text functions.

This webinar will expose you dozens of powerful functions that let you achieve productivity gains without slogging through a list of nearly 400 functions. If you hope to become a power user of Excel or just a more proficient user of this software, you need to have greater exposure to the different kinds of formulas and functions available in Excel. Sign up today to learn as Dennis presents these fantastic, must-know techniques and tricks with easily accessible, easy-to-understand terms and methods.

Learning Objectives:

This webinar quickly reviews basic formula concepts, provides tips to creating formulas more easily and focuses on those productive time-saving functions that every power user of Excel needs. Highlights include:

• Discover the “what-if” capability of the IF function and build on that knowledge with the AND, OR, and CHOOSE functions for even greater power and flexibility
• Need to look up values from a large table? There’s no better tool than the powerful VLOOKUP function
• Once you get an overview of some of the more useful and powerful Statistical and Financial functions, you will have even more analytical and summary tools
• Working with dates and times will become simpler as you use critical Date/Time functions, such as calculating days of the week and tabulating working days between two dates
• The frequently overlooked Text functions give the power to quickly adjust uppercase entries, eliminate unnecessary spaces in cells, extract parts of cell contents, and combine text from different cells

Presented by:

Dennis Taylor is an author and highly respected computer trainer and facilitator, specializing in Excel. His focus is on spreadsheet and database techniques that improve business efficiency and productivity. Dennis has over 20 years of training and consulting experience. A former employee of major Fortune 500 companies, as well as the federal government, and the University of Colorado, he has taught nearly 4,000 seminars and classes for over 100 companies, organizations, and government agencies.

Dennis is the author of Teach Yourself Microsoft Excel 2000 and co-author of four other books on spreadsheet software. He has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions…) to many clients over the past 20 years. In addition, Dennis has authored and presented over 50 different training courses on Excel topics (available on DVD/CD/VHS formats), has hours of online Excel training modules at www.lynda.com and has presented over 100 webinars to thousands of attendees. Please visit www.excel-train.com or contact Dennis at dennistaylor@msn.com for more information.

Why a WTC Audio Conference is Right for You:

• Fast, convenient learning without any out-of-office time lost.
• No travel-related expenses or complications.
• The perfect way to train as many employees as you like.
• 100% Guarantee: If you are dissatisfied, you are entitled to a complete refund.

Product Options:

Audio Conference Formats Explained

• Audio Conference CD Only: $229.00 (includes S&H)

Length: 1 hour 30 minutes