Excel Training: Mastering Charts & Graphs in Excel
Looking to take your Excel skills to the next level? Our Excel Training course, “Mastering Charts & Graphs in Excel,” is the perfect opportunity to do just that. In this engaging and hands-on program, you’ll delve into the world of data visualization, learning how to create stunning charts and graphs that instantly reveal trends, differences, and relationships in your data.
What You'll Learn
Under the guidance of our experienced instructors, you’ll explore advanced chart techniques, from creating 3-D charts to generating combo charts with ease. You’ll also gain expertise in pie charts, scatter charts, and other visualization methods. By the end of the course, you’ll be proficient in crafting Waterfall Charts, Thermometer Charts, and much more.
Why Choose Our Excel Training
At Info Trek, we’re committed to delivering top-notch Excel training. Our course empowers you to excel in chart creation and data visualization, making you a valuable asset in today’s data-driven corporate world. So, if you’re eager to go beyond your limits and arm yourself with the knowledge to stay competitive, this Excel Training course is your gateway to success.
Take a step towards charting your Excel journey by enrolling in our “Mastering Charts & Graphs in Excel” program. Become a data visualization pro and gain a skill set that will set you apart in the fast-paced corporate landscape. Join us, and let’s master Excel together!
Course Details
Course Code: Instructor-led
Audience
Those who wish to Excel their knowledge in creating charts in a different type. And explore in-depth.
Prerequisites
- Knowledge in windows
- Microsoft Excel
- Microsoft Word
- Microsoft Power Point
Methodology
Hands on creation and lab Exercises with simple case study.
Course Objectives
Upon completion of this program, participants should be able to:
- Create stunning data visualizations instantly with Excel 2016’s new Recommended Charts
- Use charts to instantly reveal trends, differences, and relationships
- Quickly generate combo charts that once required complex, frustrating procedures
- Use spark lines to imbue worksheets with more context and insight
Create Waterfall and Thermometer Charts.
Outlines
Module 1: Creating Chart in Microsoft Excel 2016
- Creating 3-D Charts and Make as a Default
- Creating Stacked Column Chart
- Formatting Chart Plot Area and Chart Area
- Save as a Template
- Set as a Default chart
Module 2: Charts that show Differences
- Showing Component Comparisons
- Adding a Second Series to Show a Comparison
- Creating Waterfall Chart
Module 3: Pie Charts
- Creating Pie Charts
- Rotating a Pie Charts
- Highlighting One Slice of a Pie Chart
- Creating Pie of Pie Chart
Module 4: Creating Charts that show Relationships
- Creating a Scatter Chart
- Showing Scatter Chart Labels in Excel 2010
- Joining the Points in a Scatter Chart with Lines
- Adding a Third Dimension with a Bubble Chart
- Using Paired Bar to Show Relationship
Module 5: Advanced Chart Techniques
- Mixing Two Chart Types on a Single Chart
- Creating Bullet Chart
- Creating a Thermometer Chart
- Creating a Benchmark chart
- Creating a Delta Chart
Module 6: Visualization and other Non-chart Methods
- Creating Chart Using Conditional Formatting
- Creating chart using the REPT Function
Module 7: Exporting Chart for Use Outside of Excel
- Presenting Excel Chart in Power Point or Word
- Copying a Chart as a picture
- Presenting Chart on a Web
- Converting to XPS or PDF
