CPATrainingCenter.com offers CPA exams, accounting degree training, CPE, and professional development for accountants and CPAs
Course/Product Description
Title:

Excel Explained: Charts

SKU:WT-1001521
Format: Webinar
Description:

In this session, Excel expert David H. Ringstrom, CPA 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 three different handouts to cover these versions of Excel:

  • Excel 2013
  • Excel 2010
  • Excel 2007

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.

Covered Topics:
  • Compare user interface changes in Excel 2013 that vastly simplify chart-related tasks
  • Explore the new Recommended Charts feature in Excel 2013
  • Enliven your charts with clip art
  • Avoid repetitive formatting by using chart templates
  • Use the Table feature in Excel 2007 and later to create charts that expand or contract automatically as your source data changes
  • Create self-updating chart titles that are linked to formulas within a worksheet cell
  • Master the versatile SUMIF function
  • Quickly summarize complex data sets with Excel's Pivot Chart feature
  • Learn why certain features like slicers, sparklines, and even charts are disabled in some workbooks

Learning objectives:

  • Learn new features in Excel 2013, such as recommended charts, and user interface changes
  • Build a pivot chart from a list of data
  • Use the Table feature and INDEX/COUNTIF functions to create self-maintaining charts
Who Should Attend

All practitioners who may benefit from using Excel charts more effectively.

The Presenter

David Ringstrom, CPA owns Accounting Advisors, Inc., an Atlanta-based spreadsheet and database consulting firm that he started in 1991. David has written freelance articles about spreadsheets since 1996, some of which have been published internationally. He teaches dozens of webinars on Excel each year, along with speaking at conferences. David coined the phrase "Either you work Excel, or it works you!" Accordingly his sessions are designed to help you turn the tide and become a much more effective spreadsheet user.

Licenses / Designations / Educational Credits:CEU
All US States: 2.5
All Canadian Provinces: 2.5
About The Provider: Since 1983 Total Training Solutions has produced dozens of videotapes, CD-Roms, DVD's and web-based training modules. In addition to off-the-shelf products, Total Training Solutions also develops custom training products and consults with financial institutions to develop their own training curriculum.

For timely delivery of training topics, webinars or web conferencing is an unbeatable option. We now offer over 100 live programs per year and you can even purchase the recorded or ondemand session if you are unable to attend the live program.

We have worked exclusively with the financial industry since our founding. Because of this, we understand the needs of training departments in financial institutions and are alert to changes which affect the industry.

Webinar Descriptions:

Live Session:
Attend the live session with the opportunity to ask questions to the presenter. You also receive a link to the handouts. All registrations for a live event will be given access to the OnDemand recording, at no additional cost, for seven days following the event. This will allow a flexible alternative when last minute conflicts intrude on scheduled events.

Recorded CD:
CD-Rom includes audio and video of recorded webinar plus hard copy handouts. You will also receive 6 months access to the OnDemand weblink as an added free bonus.

OnDemand:
Includes a weblink for unlimited viewing for 6 months after the date of the webinar as well as a link to handouts.

Live + Recorded:
Includes all three options above. Live session, OnDemand Weblink, and CD-Rom plus Hardcopy Handouts.

Live + OnDemand:
Includes two of the options above. Live session and 6 months access to OnDemand Weblink plus link to handouts.
Price: $265.00
More Info: Contact Us For More Information
Share This: Share on Facebook


Share on Twitter


Share on Google+


Currently Scheduled Dates For This Webcast
Course TitleDatePrice
Excel Explained: ChartsCD/On-Demand$325.00

Sales &Use Tax Workshop
Sales &Use Tax Workshop

Certified Payroll Administrator
Certified Payroll Administrator

Series 6 - Live &OnDemand Online Course
Series 6 - Live &OnDemand Online Course

Fundamentals Of Internal Auditing
Fundamentals Of Internal Auditing

Internal Audit School
Internal Audit School

Audit And Security For Cloud-Based Services
Audit And Security For Cloud-Based Services

Fraud Auditing Boot Camp
Fraud Auditing Boot Camp

Advanced Auditing For In-Charge Auditors
Advanced Auditing For In-Charge Auditors

Forensic Certified Public Accountant Designation
Forensic Certified Public Accountant Designation

How To Use QuickBooks
How To Use QuickBooks

1040 Training
1040 Training

Project Management Workshop
Project Management Workshop

Peachtree Seminars
Peachtree Seminars

How To Document Your Payroll Procedures
How To Document Your Payroll Procedures

Certified Annuity Specialist (CAS)
Certified Annuity Specialist (CAS)

I-9 Administrator Training - Top 10 Mistakes To Avoid In Completing, Storing, And Destroying Form I-9
I-9 Administrator Training - Top 10 Mistakes To Avoid In Completing, Storing, And Destroying Form I-9

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