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:

Excel Training: How To Use Excel Charts

SKU:WT-1001711
Format: Webcast/Audio Conference/Interview/Podcast
Description:

Excel Training: How To Use Excel Charts

Excel Charts allows users to store, model, and manipulate data.

Once data is stored in an Excel spreadsheet, anyone with access to that spreadsheet can manipulate the data in order to analyze and communicate its meaning. The charting function can be a key element in these processes, enabling users to strike a balance between automation and customization.

If a spreadsheet already contains updated data, the chart function can transform this data into a chart with a minimal amount of user input. The Recommended Charts tool in Excel is a key part of this process. Using the chart function, spreadsheet administrators can generate a chart in a few clicks, choosing a chart type, as well as options such as labels, axes and titles.

Users can also customize their charts. For instance, in addition to customizing the data presented within a chart, users can finely tweak the chart options to any detail. Charts in Excel can also be altered after they have been initially generated, by selecting a chart and choosing from the available options to amend the chart type, data, or other details.

In this session, Excel expert David H. Ringstrom, CPA - who is also the Tech Editor-at-Large for AccountingWEB - shares numerous techniques that you can use to work with charts more efficiently. David will teach primarily from Excel 2010, but will also demonstrate new charting capabilities in Excel 2013.

Excel's charting functionality has evolved with each version of Excel, so a special feature of this presentation is that David provides four different handouts to cover Excel 2013, Excel 2010, Excel 2007, and Excel 2003. As you watch him carry out techniques in Excel 2010 or 2013, you'll be able to follow the numbered steps in the handout that corresponds with your version of Excel.

Learning Objectives

By attending this webinar, you and your team will learn how to:

  • Compare user interface changes in Excel 2013 and 2016 that have vastly simplified chart-related tasks
  • Create self-updating chart titles that are linked to formulas within a worksheet cell
  • Enliven your charts with clip art in any version of Excel
  • Explore the Recommended Charts feature in Excel 2013 and later
  • Learn to avoid repetitive formatting by using chart templates and determine where this feature was relocated in Excel 2013 and later
  • Learn why certain features, including slicers, sparklines, and charts, are disabled in some workbooks
  • Summarize complex data sets quickly with Excel’s PivotChart feature
  • Use the SUMIF function to summarize data based on a single criterion
  • Use the Table feature in Excel 2007 and later to create charts that expand or contract automatically as your source data changes
  • Apply Excel’s Table feature to create self-expanding charts
  • Recognize how to save time by copying chart formatting between charts and using chart templates
  • Identify new charting capabilities in Excel 2013 and later
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.


Other Excel Topics

This course is just one of several Excel training courses we offer as part of our Excel training line. Go to www.CPATrainingCenter.com/Excel-Training-For-Accountants.asp to see the full list of Excel training courses.

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
Course TitleDatePrice
Excel Training: How To Use Excel ChartsCD/On-Demand$239.00

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