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:

High Impact Excel: Dashboard Edition

SKU:WT-1001716
Format: Webinar
Description:

The flow of information crossing your desk, as well as your clients, accelerates seemingly daily. One way to stem the tide is by way of Excel-based dashboards, which can aggregate content from numerous sources into a compact resource that allows users to assimilate mass amounts of information at once, but also quickly drill down into the details when needed.

In this presentation, Excel expert David Ringstrom, CPA - who is also the Tech Editor-at-Large for AccountingWEB - shares with you a number of techniques that you can use to construct dashboard applications in Excel. David teaches from Excel 2010 in this presentation, but his course materials include alternate instructions for Excel 2013, 2007, and 2003 when needed. He also provides an example workbook that includes copies of the related PowerPoint slides on each worksheet.

Learning Objectives:

  • Master a variety of Excel features and worksheet functions that will help you use Excel far more effectively
  • Create set-and-forget spreadsheets that others can use to monitor financial results

  • Use the From Text feature in Excel to establish persistent links to data files exported from your accounting software
  • Discover how Microsoft Query allows you to create self-updating links to databases, spreadsheets, text files and other data sources
  • Use Excel's Pivot Table feature to condense large amounts of information into manageable chunks
  • Create dynamic and interactive graphs with Excel's Pivot Chart feature
  • Filter data faster by way of the Slicers feature in Excel 2010 and 2013
  • Control multiple pivot tables/charts at once with the Slicer feature in Excel 2010 and 2013
  • Move beyond worksheet column restrictions by using the Paste Linked Pictures feature to easily present data from various sections of a spreadsheet in one place
  • Learn why certain features like slicers, Sparklines, and even charts are disabled in some workbooks
  • Use Excel's Custom Views feature to make a single set of data serve multiple purposes
  • Use the Group and Ungroup feature to expand or collapse
  • Master the versatile SUMIF function
  • Use the SUMIFS to sum value based on multiple criteria
  • Compare the MIN, SMALL, MAX and LARGE functions
  • Make your dashboard look less like Excel by hiding screen elements
  • Use a simple macro technique to hide or unhide Excel's Ribbon interface
  • Discover the new Recommended Pivot Tables feature in Excel 2013
  • Explore the new Recommended Charts feature in Excel 2013
  • Capitalize on new features in Excel 2013 that empower anyone to quickly analyze dataLevel: Basic
    Prerequisites: None
    Advance Preparation: None

    About Your Speaker:

    David Ringstrom, CPA, is the Tech Editor-at-Large for AccountingWEB and Going Concern. David speaks at conferences nationally and presents dozens of webinars annually on Excel and other topics. He offers Excel training and consulting services nationwide, and has written numerous articles on spreadsheets.

  • Licenses / Designations / Educational Credits:PHR / SPHR Re-Certification Credits
    All US States: 1.5

    SHRM Re-Certification Credits
    All US States: 1.5
    About The Provider: The Industry Calendar creates and sells webinars, audio conferences, and seminars for busy business professionals.

    For over ten years we've done the work of listing the important, don't-miss events in one convenient location so you can quickly and easily learn about key training topics that keep you up-to-date on trends and best practices, all while helping to keep you in compliance with the various rules and regulations affecting your organization.
    Price: $239.00
    More Info: Contact Us For More Information

    See Other Courses From This Provider
    Share This: Share on Facebook


    Share on Twitter


    Share on Google+


    Currently Scheduled Dates For This Webcast
    There currently are no scheduled dates for this webcast. Please click here to search for another course.

    Certificate Program For HR Generalists
    Certificate Program For HR Generalists

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

    Internal Investigations Certificate Program
    Internal Investigations Certificate Program

    How To Get Your Managers To Cooperate With HR
    How To Get Your Managers To Cooperate With HR

    Compliance Tips For Gifts, Awards, &Other Fringe Benefits
    Compliance Tips For Gifts, Awards, &Other Fringe Benefits

    Multi-State Payroll Tax Compliance
    Multi-State Payroll Tax Compliance

    Disability Discrimination And The Interactive Process
    Disability Discrimination And The Interactive Process

    Time Management for HR Professionals
    Time Management for HR Professionals

    How To Conduct Employee Relations Investigations
    How To Conduct Employee Relations Investigations

    Dealing with Difficult People
    Dealing with Difficult People

    Integrating FMLA, ADA, COBRA, And Workers′ Compensation Training &Certification Program
    Integrating FMLA, ADA, COBRA, And Workers′ Compensation Training &Certification Program

    Certificate In Essentials Of Human Resource Management Seminar
    Certificate In Essentials Of Human Resource Management Seminar

    Payroll Requirements For Terminated Employees
    Payroll Requirements For Terminated Employees

    HR’s Role In Team Building
    HR’s Role In Team Building

    Evaluating Your Paid Time-Off Strategy:  PTO Or Traditional Vacation &Sick Pay?
    Evaluating Your Paid Time-Off Strategy: PTO Or Traditional Vacation &Sick Pay?

    Update For The New Form W-4
    Update For The New Form W-4

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