Excel Charts & Graphs

Excel is an incredibly powerful data visualization platform for those willing to think beyond rows, columns, and primitive pie charts -- and we're here to prove it.

This course provides a deep, comprehensive review of Excel's latest data visualization tools and techniques. We'll discuss when, why, and how to use each type of chart, introduce key data visualization best practices, and work through interactive, hands-on demos and exercises every step of the way.

We'll review common chart elements and formatting options, dive into each of the 20+ chart types available in Excel 2016+, and then wrap things up with a series of custom visuals and advanced demos guaranteed to transform you into an absolute data viz ROCKSTAR.

COURSE CONTENTS:

• 4.5 hours on-demand video (8.0 CPE credits)

• 3 quizzes

• 16 homework assignments

• 2 skills assessments (1 benchmark, 1 final)

COURSE CURRICULUM:

WHO SHOULD TAKE THIS COURSE?

• Excel users looking to bring their data to life with beautiful and effective charts & graphs

• Analysts or BI professionals looking to develop expert-level data visualization skills

• Anyone seeking to understand key visualization principles and best practices

WHAT ARE THE COURSE REQUIREMENTS?

• Microsoft Excel, ideally 2016+ or Office 365 for PC (several chart types are not available in older versions of Excel)

• Mac users are welcome to join, but may have challenges following along

• No advance preparation is required

WHAT ARE THE COURSE OBJECTIVES?

• Identify Excel's basic data visualization functionality, including contextual menus, chart behaviors, worksheet gridlines, and custom chart templates

• Identify chart elements & formatting options, including layouts, styles, trendlines, secondary axes, and the format pane

• Identify and interpret key Excel charts & graphs, including the type of data needed, the message they communicate, and common use cases

• Identify examples of pro tips applied to custom visuals, including custom number formats, color scales, named ranges, form controls, and data validation lists

CPE ACCREDITATION DETAILS:

• CPE Credits: 8.0

• Field of Study: Information Technology

• Delivery Method: QAS Self Study

Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.

*Last Updated: December 1, 2021