Excel Advanced Techniques: When and How to Use Them

Duration: 90 minutes

Speaker: Melissa Esquibel

 

Webinar Description

Do you feel like there’s a better way to handle your complex spreadsheet analyses? Are you ready to unleash the power of Excel? Join us for Excel Advanced Techniques:  When and How to Use Them.  This information-packed 90 minute webinar taught by noted Microsoft expert Melissa Esquibel  will introduce you to five sets of tools that you can put to work on your data challenges right away. 

This session is designed to not only show you how-to, but why these techniques are important and to what types of projects they apply. 

 

Are you facing this?

You’ll learn how to use this to save time and make your life easier!

Pivot Table and VLookUp Data sources that grow from month to month

Named Ranges

You need to perform a look up on a list, but the list isn’t organized for a VLookUp

Index and Match

You know what you want the result to be but don’t know how to “force” the values to give you that

Goal Seek

You are doing the same actions over and over on your data

Macros

Data comes in messy when copied and pasted from the web

Linking Web Data

 

Agenda

In this webinar you will learn:

This session will be presented from Excel 2010, however all techniques shown are applicable to earlier versions. To get the most out of the program, you should have at least an intermediate level of knowledge in Excel that includes basic functions (Sum, Average, Min, Max, Count) and intermediate functionality (If statements, sort/filter, worksheet formatting).

 

BONUS! As an incentive to putting your learning to work right away, and as a bonus just for attending this valuable webinar, Melissa will be happy to provide assistance via email for 10 days following the session on anything covered.

 

Logistics

This event will be presented live by phone together with a PowerPoint presentation to be viewed on your computer. Internet access is not required for phone-only participants. 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.