Contact Customer Support at: 800-964-6033

Excel Power Tools for the Payroll Professional: Formulas, Functions & More


Webinar Recording

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

Program Highlights

  • 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.

Program Benefits

Join us for this 60-minute webinar to discover Excel tips & tricks to create and edit payroll spreadsheets like a pro.


  • None

Delivery Method

  • Group Internet Based

NASBA Field Of Study

  • Accounting - Finance

Program Level

  • Basic Knowledge Required