Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This Microsoft Excel – Charts in Detail training course from Infinite Skills takes you beyond the basics of Excel, diving into detail about creating and using charts within this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel.
You will start by learning the basics of Excel charts, such as how to create them quickly and why the right chart type matters. From there, you will learn about the tools within the design and format tabs, including the different chart layout styles and colors, adding and manipulating shapes, and managing data labels. Guy will show you special chart types and properly explain scatter charts. This training video will teach you about chart data and how to create charts from multiple data sources. Finally, Guy will teach you how to print your chart and copy and link it to other Office applications.
By the completion of this video based training course, you will be fully versed in creating and using Excel charts. Working files are included, allowing you to follow along with the author throughout the lessons.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Welcome|
Important - Download These First - Working FilesPreview
0101 A Chart Can Explain Things Better Than NumbersPreview
0103 The Included Working FilesPreview
|Section 2: Chart Basics|
0201 Deciding On The Data To Be Used In A ChartPreview
0202 Creating Charts Quickly
0203 Use Sparklines To Create Inline Charts
0204 Chart Areas Plot Chart Legends
0205 Filtering An Existing Chart
0206 The Right Chart Type Matters
0207 The Chart Sub Ribbons And Properties Box
|Section 3: The Design Tab|
0301 Moving Charts And Switching Rows And Columns
0302 Changing The Default Chart Type
0303 Chart Layouts Styles And Colors
0304 Adding And Removing Chart Elements
0305 Dealing With Hidden Or Empty Cells
0306 Dynamic Titles
0307 Trend Lines Used To Help Analyze Data
|Section 4: The Format Tab|
0401 Adding And Manipulating Shapes
0402 Add WordArt And Use Of WordArt Styles
0403 Adding Static And Dynamic Text Boxes
0404 Using Pictures Or Textures As Chart Element Backgrounds
0405 Altering Axis Formatting And Plotting
0406 Managing Data Labels
|Section 5: Special Chart Types|
0501 Multiple Chart Types In The Same Chart
0502 Multiple Pie Charts In The Same Sheet
0503 Pie Of A Pie
0504 Charting Stock Movements
0505 Radar Charts In Action
0506 Scatter Charts Explained
|Section 6: Chart Data|
0601 Changing A Charts Date Source
0602 Creating Charts From Multiple Data Sources
0603 What Happens When I Copy Sheets With Charts?
|Section 7: Printing And Sharing Charts|
0701 How To Print Charts
0702 Chart Templates
0703 Copying And Linking Charts To Other Office Applications
|Section 8: The End|
0801 Charts In Summary
Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.
The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.