Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

 < Previous: Excel Beginner 3 Next: Excel Beginner 5 >

Excel 2010 Beginner Level 4
Beginner Microsoft Excel Tutorial - 1 Hour 38 Minutes

This tutorial picks up where our Excel 2010 Beginner 3 class left off. In this tutorial, you will learn:

 - What are Charts & Graphs  - Insert Column, Pie, Line Charts  - Multiple Series in Charts  - Formatting Chart Objects  - Copy Charts to Microsoft Word  - Creating a Summary Sheet / Dashboard  - Working with Data Tables Order Now

If you would like a preview of what's covered in this class,

Excel 2010 Beginner Level 4
 Description: Excel 2010 Beginner Level 4 Versions: Microsoft Office Excel 2010 Pre-Requisites: Excel 2010 Beginner Level 3 Running Time: 1 Hour 38 Minutes Cost: \$9.99

This course is for the novice user who has little or no experience with Microsoft Excel except for my Excel Beginner Level 1, 2, and 3 courses. Today's course is mostly about Charts & Graphs.

We'll start by learning the basics of charting. What is a chart? What are the parts of a chart? We'll see how to create a simple column chart and insert it into our spreadsheet.

Next, we'll learn how to add data to an existing chart, create a line chart, make a chart with multiple series of data, and work with chart styles and themes.

You will learn how to select non-contiguous data (that's two ranges of data that aren't next to each other) so you can graph information that's in different areas of your sheet. You'll make a 3D pie chart and a 3D column chart. You'll see how to move the chart to a different sheet, change the chart layout, and the chart type.

Next we'll learn how to switch the row and column axes, format all of the different objects inside of our chart (titles, axes, walls, etc.), and insert comments, lines, shapes, and other objects inside the chart as well.

You'll learn how to copy your charts to Microsoft Word to embed them inside of reports or other documents. You'll see how to create a summary sheet (also known as a dashboard).

You'll learn how to separate a piece of pie from a pie chart, and create leader lines.

Finally, we'll learn how to create Data Tables which are database-like lists of information in Excel. You'll see how to use table styles to format them, how formulas work in series, how to use AutoFilter, and create a total row.

Again, this is the perfect class for anyone who is new to Microsoft Excel 2007 and has finished my Excel Beginner Level 1, 2, and 3 courses. If you have little or no experience with spreadsheets, or you just want to get familiar with how Excel 2010 works, this class is for you.

Complete Outline - Excel 2010 Beginner 4

 01. Charts 1 (10:51) What is a Chart Parts of a Chart Insert a Column Chart 02. Charts 2 (11:24) Add Data to an Existing Chart Line Charts Multiple Series in a Chart Chart Styles & Themes 03. Charts 3 (16:14) Selecting Non-Contiguous Data 3D Pie Charts Move a Chart to a Different Sheet Format Objects Inside Charts Chart Layouts Leader Lines Change Chart Type 3D Column Charts Stacked 3D Column Chart 04. Charts 4 (13:52) Switch Row/Column Current Selection Box Format Selection Reset to Match Style Insert Shapes Insert Text Box Labels Chart Title Axis Titles Legend Data Labels Data Table 05. Charts 5 (13:15) Copy Excel Charts into Word Creating a Summary Sheet / Dashboard Separate a Slice of Pie Create a Leader Line 06. Tables (17:05) Creating a Table Why Use a Table Table Styles Table Formulas are Uniform New Rows Automatically Copy Formulas Sort in a Table Filter in Tables Turn off Filtering Total Row Insert New Row

Keywords: microsoft excel tutorial, microsoft excel 2010 tutorial, microsoft office excel 2010 tutorial, microsoft excel 2010 training, charts, charting, column chart, pie chart, line chart, chart styles, 3d charts, chart layouts, chart type, axis title, data labels, data table, separate pie slice, leader line, dashboard, summary sheet, data table

 You may want to read these articles from the 599CD News:
 6/23/2021 Import Data 5/14/2021 Quick Queries #4 4/4/2021 Text to Columns 3/15/2021 VLOOKUP in Access 2/17/2021 Old Excel 2003 Outlines 2/17/2021 Excel Expert Outlines 2/17/2021 Excel Beginner Outlines 2/4/2021 Free Beginner Courses 12/26/2020 Import New, Changed Records 12/13/2020 Duplicates Conditional Formatting

 Learn  Access - index Excel - index Word - index Windows - index PowerPoint - index Photoshop - index Visual Basic - index ASP - index Seminars More... Customers  Account Login Online Theater Downloads Lost Password Memberships Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Search The Site Code Vault Collapse Menus Help  Customer Support Web Site Tour FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Contact Info Support Policy Email Richard Mailing Address Phone Number Fax Number Course Survey