K2's Excel Charting and Visualizations
Course Information
4
CPE Credits
4-Hour Course
Computer Software and Applications (4 Credits)
Fundamental Understanding of Creating Charts in Microsoft Office Applications
Prerequisites
Intermediate
Program Level
No
Preparation
Course Information
4
CPE Credits
4-Hour Course
Computer Software and Applications (4 Credits)
Fundamental Understanding of Creating Charts in Microsoft Office Applications
Prerequisites
Intermediate
Program Level
No
Preparation
Major Topics
Small businesses have unique and specific technology needs, including those around remote access. Whether team members need remote access to desktops, data, voice services, instant messaging, or Cloud-based services, sometimes the list of available options can be overwhelming!
In this course, you will learn about practical solutions for facilitating remote access in small businesses. Among other items, included in this program is a detailed review of various solutions to provide remote access to a desktop, how to work securely from remote locations, key considerations when selecting Cloud-based solutions, and how to facilitate communication and collaboration in remote environments.
Course Description
Charts and graphs are nothing new. However, many professionals struggle with building effective visualizations. If that statement describes you, take part in this session to improve your skills when building charts and other visualizations in Excel. As a result of doing so, you will be able to create visualizations that will enhance your communication skills.
This is much more than just a seminar on fundamental charts. Instead, in this session you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. If you are looking to improve your communication skills, this seminar is a must for you.
Learning Objectives
Upon completing this course, you should be able to:
- Identify the types of visualizations that should be used to communicate specific messages
- List the steps to creating effective visualizations in Excel and other Microsoft Office applications
- Identify options for creating interactive visualizations
- Utilize Sparklines and Conditional Formatting to enhance visualizations in Excel
- Identify options for linking Excel-based data and visualizations into Word and PowerPoint
Who is the course for?
CPAs and other accounting, financial, and business professionals who want to learn how to create more effective charts and visualizations in Excel.
Instructional Delivery Method
Group-live demonstration and discussion. This course is “laptop-friendly” and participants will have access to demonstration files. This course focuses on features found in Excel for Windows but many of the features can be used in Excel for Mac.
More Courses
Looking for Other Excel-Focused Learning Options?
Consider the Following Seminars Available from K2 Enterprises
K2's Advanced Excel
K2's Advanced Excel
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
K2's Budgeting and Forecasting Tools and Techniques
K2's Budgeting and Forecasting Tools and Techniques
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
K2’s Excel Best Practices
K2’s Excel Best Practices
Computer Software and Applications (8 Credits)
K2's Excel Boot Camp
K2's Excel Boot Camp
Computer Software and Applications (16 Credits)
K2’s Excel Charting and Visualizations
K2’s Excel Charting and Visualizations
Computer Software and Applications (4 Credits)
K2’s Excel Essentials for Staff Accountants
K2’s Excel Essentials for Staff Accountants
Computer Software and Applications (8 Credits)
K2’s Excel PivotTables for Accountants
K2’s Excel PivotTables for Accountants
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
K2’s Excel Tips, Tricks, and Techniques for Accountants
K2’s Excel Tips, Tricks, and Techniques for Accountants
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
K2’s Introduction to Excel Macros
K2’s Introduction to Excel Macros
Computer Software and Applications (4 Credits)
K2’s Mastering Advanced Excel Functions
K2’s Mastering Advanced Excel Functions
Computer Software and Applications (4 Credits)
K2’s Next Generation Excel Reporting
K2’s Next Generation Excel Reporting
Accounting (8 Credits)
K2’s Testing and Auditing Excel Workbooks
K2’s Testing and Auditing Excel Workbooks
Information Technology (4 Credits)