Excel: Focus on Formulas
|Date / Time:
You know that Microsoft® Excel® crunches numbers extremely well.
But did you know that more than half of Excel users never learn how to use 9 out of 10 of its most powerful features? Don't be one of those people!
If you don't have a good foundation for the way formulas work, then you use only a small part of Excel's amazing capabilities.
On Wednesday, August 6, Excel: Focus on Formulas will take you from the foundational concepts that almost every self-taught Excel user missed to essential functions for numbers and text. By attending, you will learn:
In addition to showing you how to correctly write formulas, Microsoft® Certified Trainer, Melissa Esquibel will explain how to troubleshoot and reverse engineer formulas, too! She makes this content relevant for both new formula writers and intermediate-level users who just want to sharpen their formula-building skills. The webinar is presented from Microsoft Office 2010, but will be applicable to all versions of Excel.
- How to construct formulas the right way to get the results you expect.
- The difference between an absolute and relative cell reference, and why you should know it!
- What conditional functions are and how they can cut your work in half.
- How to use IF and VLookUp to create data you need but can't seem to get.
In about an hour, we'll give you the foundation for the way formulas work. You'll have your data working for you in no time.
Cannot Attend The Live Presentation?
This presentation is also available in a recorded format, in CD version, as shown in the pricing options below.
|About Webcasts / Audio Conferences / Podcasts:|
Webcasts, audio conferences, and podcasts are presentations that you
attend via the Internet, phone, or mobile device at a specified date and time for "live" versions, or at your convenience for "recorded" and "On-Demand" versions.
versions are interactive, meaning that participants can ask questions in real time, plus are a very cost-effective form of training because 1) you receive fast, convenient learning without
any out-of-office time; 2) you can invite as many colleagues as you'd like to listen in on a single phone line; 3) you incur no travel expenses; and 4) you and your colleagues are back
at work immediately after the session ends!
And though with recorded versions you do lose the ability to ask questions, you gain the ability to hear the presentation numerous
times and to share it with others in your office.
Handout materials and the phone number for live presentations are made available to you prior to the event via email from the
presenter and from the "MyAccount" link on the menu bar. Copies of the presentations are included with recorded versions.
|Licenses / Designations / Educational Credits:||PACE|
All US States: 1.5
All Canadian Provinces: 1.5
|About The Provider:
||The HR Specialist family of products helps HR professionals quickly resolve their daily challenges. From state-specific employment law to compensation and benefits, our experts give you the HR advice you need to know.
Whether you're new to HR or an experienced pro - a department of one or 10 - you can trust the practical, plain-English advice from HR Specialist. We'll save you time and headaches by focusing on what you need to know, when you need to know it. That makes you the HR expert your company can rely on and gets you the recognition you deserve.
||Contact Us For More Information
||Share on Facebook
Share on Twitter
Share on Google+
|Keywords For This Course:|
Excel, formulas, spreadsheets, accounting, data, software, MS Office
How To Communicate Assertively To Exude Confidence And Competence
Year End Legislative &Tax Changes In Payroll
Payroll Records: What To Keep, What To Toss
PTO Plan Or Traditional Vacation And Sick Time? The Pros and Cons Of A Paid-Time-Off Plan
Motivate Or Terminate
Workplace Investigations 101: The Basics For Conducting Workplace Investigations
Certificate Program For HR Generalists
Agile Basics For HR
Employee Handbooks: 2017 Issues
Internal Investigations Certificate Program
Certificate Program In FMLA &ADA Compliance
The Essentials Of HR Law
How To Change The Perception Of The HR Department
FMLA Training &Certification Program
Certified Payroll Manager
Fundamentals Of Form W-2 &Form W-4 Processing