Super User Advanced Excel Training - Power Charts

It’s not enough to just know how to make a chart – it needs to look good too! This class gets you started with the basics and how to best layout your data for effective CHARTS. You’ll learn all different types of formatting techniques and ways to enhance the chart to make it pop! Our instructor will show you how to insert your chart into a document or slide.PREREQUISITES: Excel Basic or equivilant experience At the completion of this course, participants will be able to perform the following tasks: CREATING CHARTS * Using Charts * Creating Charts * Moving and Resizing Charts * Identifying Chart Elements * Changing the Chart Type * Changing the Plot Direction * Removing/Adding a Legend * Moving the Legend * Charting Non-adjacent Ranges * Changing the Chart Range * Changing the Data Source * Changing the Chart Location * Working with Sparklines * Formatting a Sparkline * Printing a Chart FORMATTING CHARTS * Format charts * Add chart titles * Format chart elements * Change the text orientation * Add a data table * Create an exploded pie chart * Adjust the 3-D view * Delete a chart USING ADVANCED CHARTING FEATURES * Add and remove gridlines * Format gridlines * Format an axis * Change the axis scaling * Format the data series * Add data from different worksheets * Use a secondary axis * Change data series chart types * Add a trendline * Create a chart template * Apply a chart template