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  
 
Home > Courses > Excel > Beginner Outlines
 
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)

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

9/11/2021Circular References
8/25/2021Stock History
8/23/2021Concatenation
8/17/2021Flash Fill
8/5/2021Stock Portfolio
8/4/2021Stock Portfolio
6/23/2021Import Data
5/14/2021Quick Queries #4
4/4/2021Text to Columns
3/15/2021VLOOKUP in Access
 

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
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Page Tag: outline excel 1 1  PermaLink