Excel Power Tools for the Payroll Professional: Formulas, Functions & More
Recording Price: $199.00
(Includes Proprietary Materials)
Creating and maintaining payroll data in Excel can be difficult and time consuming. However, Excel has a variety of features that will ease tedious & repetitive tasks. How can you be sure you're utilizing all of these useful tools? Join us for a live, 60-minute webinar to discover:
Beyond the basics: Little-known tips & tricks that ease your day
Formulas & Functions: Essential tools to simplify your payroll process
How to take what you get from data imports & turn it into what you need
Improve the integrity of your payroll data: Avoiding mistakes
Key Excel Power Tools to Use in Payroll: What You Need to Know
Compensation formulas: Eliminating manual data entry
Conditional formatting and advanced functions to control your data
Reduce dozens of clicks to one or two - while still maintaining accuracy
Timesaving Excel Functions & Formulas for In-House or Vendor Payroll Data
Key functions you can't live without - VLOOKUP, IF & more!
Tips to link spreadsheets to vendor data for repeatable success
Convert data to tables: Speed-up formula creation, sorting & filtering
What Excel Can Do For Payroll Professionals: Excel Tips & Shortcuts
Pivot tables: Summarize your data by dept., region, or salary
Leverage Excel's full power: Avoiding common pitfalls in payroll
Validating the data you use to make critical business decisions
Live Question & Answer Session - Have your questions answered by the expert!
About The Speaker
Melissa Esquibel is a technology consultant, coach, trainer and speaker.
She is a consultant, frequent speaker and Microsoft Certified Trainer.
Since 1991, Ms. Esquibel has assisted a variety of companies and industries with Microsoft Office (Excel, Word, PowerPoint, Access, Outlook) all versions through 2010. Her strong foundation in finance and accounting was built over years in the banking and accounting industries.
Melissa has 25+ years experience in information technology with a background in training, finance, technical writing and business risk analysis.
Join us for this 60-minute webinar to discover Excel tips & tricks to create and edit payroll spreadsheets like a pro.