Excel: Focus On Formulas
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 can use only a small part of Excel's amazing capabilities.
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. You'll 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 seminar 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.
|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, presentations, Microsoft Office
|Currently Scheduled Dates For This Webcast|
|There currently are no scheduled dates for this webcast. Please click here to search for another course.||
How To Keep HR From Being The Employee Complaint Department
Rules And Requirements For Employee Expense Reimbursements
Garnishments, Child Support Orders, And Other Levies
Internal Investigations Certificate Program
Dress Code Policy Do′s and Don′ts
How To Deal With Employees Who Are Chronically Late Or Absent
Certificate Program In FMLA &ADA Compliance
Reasonable Or Unreasonable Accommodation? How To Identify Disabilities And Handle Employee Issues - Without Violating The ADA
Certificate Program For HR Generalists
Assertiveness Skills For HR Professionals
HRCI / SHRM 60 Hour Re-Certification Training Suite
IRS Rules For Travel Pay
Dealing with Difficult People
9 Ways To Spot, Handle, and Reduce Workers′ Comp Fraud
How To Use PTO To Reduce Absenteeism