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

 Home   Courses   Seminars   Templates   TechHelp   Forums   Help   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 Beginner Level 4
Beginner Microsoft Excel Tutorial - 1 Hour 38 Minutes

This tutorial picks up where our Excel 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 Beginner Level 4
 Description: Excel Beginner Level 4 Versions: Recorded with Microsoft Excel 2010. Valid for 2007 to 2021. Pre-Requisites: Excel Beginner Level 3 Running Time: 1 Hour 38 Minutes Cost: \$5.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 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 works, this class is for you.

Complete Outline - Excel 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 tutorial, microsoft office excel tutorial, microsoft excel 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

 Check out these other pages that may be of interest to you:
 4/17/2023 Military Time Import 4/12/2023 Timestamp 4/7/2023 Excel VBA 2/3/2023 TextSplit 1/27/2023 Math in Fields 12/12/2022 Tax Brackets 12/9/2022 Double Lookup 10/24/2022 Follow Hyperlink 9/17/2022 Very Hidden 8/11/2022 Crosstab