Learn Excel Formulas and Foundations—Unleash the Power of Excel
Wednesday, January 20, 2016 at 1:30 pm ET
Speaker: Melissa Esquibel
Bonus for Each Registrant:The webinar speaker will answer one written question that you may submit by email within one week after the webinar.
Webinar Description
Do you want to really unleash the power of Excel? Knowing how to construct formulas and leverage functions is essential. In this content-rich program by Microsoft Certified Trainer Melissa Esquibel, you will learn the foundations of formula building. Discover the difference between absolute and relative cell references and remember the correct order of operation.
In addition to writing formulas, Ms. Esquibel will show you how to troubleshoot common problems, even reverse engineer someone else’s formulas! This program is relevant for both new formula writers and intermediate level users who want to sharpen their formula-building skills. The webinar is presented from Microsoft Office 2013, but is applicable to all versions of Excel.
Agenda
-
Building formulas that get the results you expect
-
The difference between absolute and relative cell references
-
The power of conditional functions to cut your work in half
-
Essential functions like IF and VLookUp; how to create data and solve problems
-
Get help with functions without ever leaving the cell
-
Avoid common mistakes and interpret error messages
Logistics
- 90 minutes (Travel Free) delivered over the Internet.
Unlimited listeners per connection - bring the entire department.
Q&A session with the expert.
Special Feature: If you register for this webinar and cannot attend, you will be able to access a one-time instant replay without charge for up to 90 days after the date of the webinar.
This event will be presented live with a PowerPoint presentation to be viewed on your computer. You may listen to the audio of the webinar by telephone or through your computer. The PowerPoint slides will be provided shortly before the event. Once you register, you will receive an email which is your receipt and which includes your instructions for dialing in and logging on. You will also receive an email reminder 24 hours before the webinar.