|
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.
Of
course, if you have any questions about whether or not this class is
for you, please contact me.
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 |
|
