HRTrainingCenter.com provides Human Resource training on FMLA, COBRA, HIPAA, HRAs (Health Reimbursement Accounts), HSAs (Health Savings Accounts), FLSA, Payroll, Cafeteria Plans, and more through seminars, online training, webcasts, webinars, and audio conferences. Best sellers include FMLA seminars, COBRA seminars, online payroll training, retirement plan training, and HIPAA training.
Course/Product Description
Title:

Data-Crunching Secrets Of Excel

SKU:WC-1011579
Date / Time: Recorded
Format: Webinar
Order:Qty:
Description:

Do you have a love/hate relationship with Microsoft® Excel®?

You know the power it wields, but it sure would make your life easier if you knew all the tricks the pros use to take it to the next level. Now you can!

The editors of the Office Technology Today newsletter have once again teamed up with master trainer Melissa Esquibel to present a webinar on advanced Excel skills. Data-Crunching Secrets of Excel is designed for those who have some experience working with data lists and tables (beyond Sort and Filter), as well as basic formulas and functions in Excel (beyond SUM, AVERAGE, COUNT).

As the data pile gets larger and larger, the answers seem to get buried deeper and deeper. Knowing the secrets of working with data in Excel can bring you actionable information quickly, consistently and in a way that stays nimble as your datasets grow.

Join us for this 75-minute live event on advanced Excel skills – presented by Microsoft® Certified Trainer Melissa Esquibel.

You'll find out...

Teaching Points

  • Performing LookUps in Formulas
  • Conditional Formulas
  • Subtotal Secrets
  • Pivot Tables
  • Content Summary
  • LookUp Functions
    • VLookUp
    • Inside an IF
    • ISNA
  • Conditional Formulas
    • SUMIF
    • DSUM
    • SUMIFS
  • Subtotals
    • Data Standards
    • Creating Subtotals
    • Banded Totals
    • A Trick with Charts
  • Pivot Tables
    • Creating Pivot Tables
    • Manipulating Data
    • Creating a Formula
    Data isn't information until you can get it to tell you something. You'll leave this Data-Crunching Secrets of Excel webinar with the tools you can put to work right away to handle all your Excel data like an old pro.

    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.

    The live 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.

    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.
    More Info: Contact Us For More Information
    Order:Qty:
    Share This: Share on Facebook


    Share on Twitter


    Share on Google+


    How To Properly Complete A Form I-9
    How To Properly Complete A Form I-9

    Workplace Investigations 101: The Basics For Conducting Workplace Investigations
    Workplace Investigations 101: The Basics For Conducting Workplace Investigations

    Certificate Program For HR Generalists
    Certificate Program For HR Generalists

    Employee Handbook Updates for 2017: How To Ensure Legal Compliance And Avoid Liability
    Employee Handbook Updates for 2017: How To Ensure Legal Compliance And Avoid Liability

    PTO Plan Or Traditional Vacation And Sick Time? The Pros and Cons Of A Paid-Time-Off Plan
    PTO Plan Or Traditional Vacation And Sick Time? The Pros and Cons Of A Paid-Time-Off Plan

    Pre-Employment Screening: Can I Ask That Question?
    Pre-Employment Screening: Can I Ask That Question?

     Agile Basics For HR
    Agile Basics For HR

    Strategic HR Basics: A Practical Approach To Working More Strategically In HR
    Strategic HR Basics: A Practical Approach To Working More Strategically In HR

    Internal Investigations Certificate Program
    Internal Investigations Certificate Program

    Certificate Program In FMLA &ADA Compliance
    Certificate Program In FMLA &ADA Compliance

    Basics Of Affirmative Action Planning
    Basics Of Affirmative Action Planning

    How To Identify And Investigate Claims Of Bullying
    How To Identify And Investigate Claims Of Bullying

    How To Change The Perception Of The HR Department
    How To Change The Perception Of The HR Department

    The Essentials Of HR Law
    The Essentials Of HR Law

    FMLA Training &Certification Program
    FMLA Training &Certification Program

    ADA Training &Certification Program
    ADA Training &Certification Program

    Google+HRTrainingCenter.com. 5755 North Point Parkway, Suite 228 | Alpharetta, GA 30022 | 770-410-1219 | support@HRTrainingCenter.com
    Copyright HRTrainingCenter.com 2016 | Web Site Development by OTAU
    Facebook