Overview
They say that a picture is worth a thousand words. Using Excel charting tools to visually display complex Excel data communicates the data's message much more effectively to your target audience.
Chart and graphs are visual representations of your data. Viewing the data graphically makes the data less confusing and increases comprehension. It is easier to spot trends and patterns in your data sets.
Why you should Attend
You will learn how to create charts in Excel based on a variety of data sets. There are so many chart types to choose from, and you will understand which chart type presents the data from which perspectives.
We will start with very basic charts, modify the data being represented in the chart and advance into more complex combination charts. You will also learn how to format the charts to create the perfect emphasis of data.
Learn to embed Sparklines, mini charts, right inside of a cell.
Areas Covered in the Session
- Creating charts in Excel
- Defining the components of a chart
- Formatting a chart
- Modifying a chart
- Adding chart elements
- Adding, editing and removing data
- Annotating with Trendlines
- Creating a combination chart and advanced Excel charts
- Using sparkline chart, Excel
- How to make a graph in Excel
Who Will Benefit
- Financial Analysts
- Accountants
- Data Analysts
- Project Managers
- Operations Managers
- Marketing Analysts
- Sales Managers
- Supply Chain Managers
- HR Professionals
- Researchers
Speaker Profile
Cathy Horwitz is a highly experienced Microsoft Office instructor, specializing in Excel, Word, PowerPoint, Outlook, and Access. With over 30 years of expertise in both in-person and online training, she has helped thousands of professionals boost productivity, streamline workflows, and master essential Microsoft Office skills.
Cathy has been teaching Microsoft Office since its inception, offering tailored training programs that meet the unique needs of individuals and businesses. Her courses cover everything from Excel formulas, PivotTables, and automation with macros to Word document formatting, PowerPoint presentation design, and Outlook email management. Workshops from beginning level through advanced are available.
Known for her engaging, hands-on teaching style, Cathy incorporates real-world business scenarios to ensure students gain practical skills they can immediately apply. Whether you're looking for corporate training, individual coaching, or advanced Microsoft Office workshops, Cathy delivers results-driven instruction that enhances efficiency, problem-solving, and software proficiency.
Instructor
Cathy Horwitz