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:
-
Named Ranges
-
LookUp Functions and How to Use Them
-
"What If" Analysis
-
Intro to Macros
-
Using External Data
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
- 90-minute webinar (Travel-Free) delivered over the phone and Internet.
- Unlimited listeners per connection - bring the entire department.
- Q&A session with the expert.
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.
What is a webinar?
A webinar is an Internet based seminar. Webinars are a way for participants in many different locations to see and hear a presentation and view PowerPoint slides. You can also have your colleagues attend the webinar using one connection.
What kind of equipment do I need?
You will need a computer with an Internet connection (high speed service such as DSL or cable works best) and a telephone. You may use a headset if that is more comfortable. The headset will also help block out background noise. Internet access is not required for phone-only participants.
How can I share the webinar with my colleagues who may not be able to attend the event?
CDs of each program will be available for sale and can be shared with your business associates.
Can I get a copy of the PowerPoint slides used in the webinar?
The PowerPoint slides will be available on the materials page link in the confirmation email that will be sent to you no later than the morning of the day a webinar is presented.
How do I ask a question during the webinar? Will my question be answered during the presentation?
A question and answer session will be scheduled at the end of each webinar. You can then ask a question by typing it into the question box that will be provided to you duringthe webinar. You may also ask a question through the telephone connection. As many questions as possible will be answered during the Question and Answer period.