Excel Beginner Outlines
Excel 2010 Beginner 1 |
Running Time 1 hr, 29 min
00. Intro (9:50)
01. Excel Interface 1 (6:22)
Starting Excel
The Ribbon Changes with Window Size
Title Bar
Maximize, Minimize, Restore Down
Close Button
File Tab - Backstage View
02. Excel Interface 2 (7:06)
The Ribbon
Ribbon Tabs, Groups, Buttons
Help Popup Menus for Each Command
Command Buttons
Drop-Down Menus
Command Button Groups
Galleries
Dialog Box Launcher Buttons
03. Excel Interface 3 (5:30)
Quick Access Toolbar
Adding or Removing a Command from QAT
Status Bar
Views Buttons
Zoom Controls
Scroll Bars
04. Excel Interface 4 (5:55)
Formula Bar
What is a Spreadsheet
Columns, Rows, Cells
Name Box
Mouse Pointer
Sheet Tabs
05. Entering Data (5:19)
Creating a sales summary sheet
Entering text in Excel
Typing data into a cell
Select a Cell with Mouse
Select a Cell with Keyboard
Move with ENTER, TAB
Move with Arrow Keys
Entering Data
06. Editing Data (7:37)
Editing data in a cell
Four methods for editing data
Overtyping your data
Replacing data in your cells
Editing data using the Formula Bar
Editing a cell by double-clicking
Backspace vs. Delete Keys
Edit Mode with F2
Deleting data in a cell
Using UNDO in Excel
Using REDO in Excel
07. Formatting 1 (6:14)
Home, Alignment
Formatting your text
Horizontal cell alignment
Align Right, Left, Center
Format multiple cells at once
A Cell Range defined
Cell Range Notation (A1:B5)
Selecting cell rangess
Bold, Italics, Underline
08. Formatting 2 (8:40)
Changing the Font
Live Preview
Change Font Size Dropdown
Type in a Font Size Manually
Increase Font Size
Decrease Font Size
Resizing Columns
Changing Column Width
Resize Column with Double-Click
Resizing Rows
Background Color / Fill Color
Foreground Color / Font Color
09. Basic Math 1 (7:48)
Moving to a different sheet tab
Using a "scratch" sheet
Adding two cells together
How Formula Work in Excel
Auto Recalculation of Formula
See Formula in Formula Bar
See Result on the Sheet
Basic math operators
Addition
Subtraction
Multiplication
Division
Exponentiation
Using Constants
Clearing a range of cells
Selecting an Entire Column
10. Basic Math 2 (5:11)
Adding Multiple Cells
Select to See Summary in Status Bar
Click to Add Cell to Formula
Order of Operations
Using parentheses in math operations
Average a Group of Cells
11. Save, Load, Print (8:24)
Saving Your Workbook File
Save As a Different File
Open Recent Documents
Open Any Document
Pinning Documents to the List
Create a New Blank Workbook
Print Preview
Print Your Spreadsheet
12. Review (4:57)
|
|
Excel 2010 Beginner 2 |
Running Time: 1 hour, 28 minutes
00. Intro (7:37)
01. Cut Copy Paste (9:30)
The Clipboard
Copy, Paste
Cut, Paste
Formula References Updated
Paste Multiple Times
Clipboard Heyboard Shortcuts
02. Autofill (7:46)
Autofill a Formula
Autofill Handle
Mistakes
Moving a cell
Move a Cell Value
03. Cell Formats 1 (10:39)
Text, Number
Missing Leading Zeros
Currency, Accounting
Short Date, Long Date
04. Cell Formats 2 (7:32)
Fraction
Mixed Fraction
Percentage
Increase Decimal
Decrease Decimal
Comma Style
Scientific Style
05. Rows & Columns (9:42)
Clear v. Delete
Selecting Multiple Columns
Delete Columns
Delete Rows
Right-Click Delete
Insert Column
Insert Row
Insert Multiple Row
Clear Contents
06. Sheets (9:34)
Insert New Worksheet
Delete Worksheet
Rename Sheet
Moving Sheets
Copying a Sheet
Sheet Tab Color
07. Sorting Data (6:25)
Sort A to Z
Dealing with Total Rows
Select Everything First
Sort on a Different Column
Use TAB to Change Columns
08. Conditional Formatting (8:03)
Highlight Cells Rules
Greater Than, Less Than
Above Average
Multiple Conditions
Clear Formatting from Sheet
Data Bars
Color Scales
Icon Sets
09. Find & Replace (7:35)
Find Data
Find Next
Find All
Replace
Replace All
10. Review (4:40)
|
|
Excel 2010 Beginner 3 |
Running Time: 1 Hour, 40 Minutes
00. Intro (8:00)
01. Functions 1 (8:14)
What is a Function
The SUM Function
Benefits of Functions
02. Functions 2 (9:42)
AVERAGE Function
COUNT
MAX, MIN
Move a Block of Cells
03. Functions 3 (11:17)
Practice with Functions
The Key Cell Format Trick
Insert New Month of Sales
AutoFill Multiple Cells
04. Styles & Themes (9:03)
Selecting Cell Styles
Using Styles to Format
Changing Themes
Theme Colors vs. Standard Colors
05. Page Layout (11:55)
Margins
View, Page Layout
Print Preview
Orientation
Page Size
Set Print Area
Clear Print Area
Page Breaks
Background
Gridlines: View, Print
Headings: View, Print
06. Illustrations 1 (13:11)
Insert a Picture
Move and Resize a Picture
Rotate Picture
Picture Tools, Format Tab
Brightness, Contrast
Reset Picture
Compress Pictures
Delete a Picture
Insert Clipart
07. Illustrations 2 (11:38)
Insert Shapes
Rectangle
Drawing Tools, Format Tab
Shape Styles
How Themes Effect Shape Styles
Shape Outline
Shape Effects
Add Text
Format Text
Quick Mini Toolbar Popup
WordArt Styles
Inserting an Arrow
08. Illustrations 3 (12:39)
Insert SmartArt
Basic Process
Format SmartArt Options
Screenshots
Screen Clippings
Insert WordArt
WordArt Options
09. Review (5:03)
|
|
Excel 2010 Beginner 4 |
Running Time: 1 Hour 38 Minutes
00. Introduction (8:46)
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
07. Review (6:46)
|
|
Excel 2010 Beginner 5 |
Running Time: 1 Hour 46 Minutes
00. Introduction (9:35)
01. Insert Text 1 (9:45)
Insert > Text Group
Insert Hyperlink
Web Page Hyperlinks
Email Hyperlinks
Link to Customer Address
Link to Google Maps
02. Insert Text 2 (13:07)
Insert Text Box
Insert WordArt
Insert Signature Line
Insert Object
Insert Symbol
03. Header & Footer (12:55)
Insert Header & Footer
Three Sections
Header & Footer Elements
Entering Text in Header
&[Page] Code for Page Number
Page 1 of 2
Page Footer
Date Code
Insert Picture
Header & Footer Templates
Go To Footer, Header
04. View Window (12:25)
Working with Large Sheets
Create a Large Sheet of Data
Freeze Panes
Freeze Top Row
Freeze First column
Split the Window
05. Borders (7:42)
Print Preview
Zoom to Page
Printing Gridlines
Changing Borders
Top, Left, Right, Bottom
Inside, Outside Borders
Thick Borders
06. Misc Format Tricks (9:22)
Merge and Center
Merge Across
Merge Cells
Unmerge Cells
Cell Orientation
Format Painter
Double-Click Trick
07. Comments (5:56)
Insert Comment
Edit Comment
Delete Comment
Show, Hide Comments
Previous, Next Comment
08. Research (10:00)
Spell Check
Thesaurus
Getting Stock Quotes
Translate
09. Office Online Templates (11:47)
How to Download Templates
Calendar Template
Invoice Template
Home Mortgage Template
10. Review (4:07) |
|
|