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 > 2003 Outlines
 
Old Excel 2003 Outlines

Excel 2000-2003
Excel 101
1. INTRODUCTION
Objectives
Pre-Requisites
Important concepts

2. PARTS OF THE EXCEL SCREEN
Starting Excel
Parts of the screen
Title Bar
Workbook name
Spreadsheets Defined
Maximize
Minimize
Close
Two sets of max/min/close buttons
Menubar
Toolbars
Standard toolbar
Formatting toolbar
Formula Bar
The Spreadsheet Window
Columns v. Rows
Names of Columns and Rows
Column and Row Headers
Cells
Names of Cells
The Cell Name Box
The Mouse Pointer in Excel
Scroll Bars and their use in Excel
The Task Pane
Sheet Tabs
Status Bar
Adjustments to Excel for class
Closing the Task Pane
Moving Toolbars Around
Floating v. Docked Toolbars

3. ENTERING DATA
Creating a sales summary sheet
Entering text in Excel
Typing data into a cell
Entering a full column of data
Pressing ENTER, TAB, or ARROW KEYS
Using the Mouse to move around
Using the keyboard to move around

4. EDITING DATA
Editing data in a cell
Overtyping your data
Replacing data in your cells
Editing data using the Formula Bar
Editing a cell by double-clicking
Deleting data in a cell
Using UNDO in Excel
Using REDO in Excel

5. FORMATTING OUR SHEET
A Cell Range defined
Cell Range Notation (A1:B5)
Highlighting (selecting) ranges of cells
Formatting your text
Horizontal cell alignment
Align Right, Left, Center
Bold, Italics, Underline
Changing Fonts, Font Size
Resizing Columns
Changing Column Width
Resizing Rows
Resizing Columns Automatically with Double-Click
Background Color / Fill Color
Foreground Color / Font Color

6. BASIC MATH
Moving to a different sheet tab
Using a "scratch" sheet
Basic math operators
Adding two cells together
Demonstrate auto-recalculation
Result on sheet, formula in formula bar
Addition
Subtraction
Multiplication
Division
Exponentiation
Clearing a range of cells
Adding a range of cells
Taking the average of a range of cells
Order of Operations
Using parentheses in math operations

7. FUNCTIONS, PART ONE
Functions defined
What is a function
The SUM function
The AVERAGE function
Using the mouse with functions
Selecting function ranges with the mouse
The MAX, MIN, and COUNT functions

8. FUNCTIONS, PART TWO
Adding functions to our sales summary sheet
Totalling each month's sales
Totalling each sales rep's sales
Calculating a grand total
Calculating sums for columns and rows
Practical application for our student gradebook

9. CUT, COPY, PASTE, AUTOFILL
Copying and pasting a formula
Excel adjusting formula automatically
Using AutoFill to copy a formula
The AutoFill Handle
Common mistakes while trying to AutoFill
Moving cells by click and drag
AutoFill Series: Months

10. SAVING, LOADING, PRINTING
Saving your workbook
Saving with the floppy disk (save) button
Saving to your "My Documents" folder
Entering a filename
Closing Excel
Reloading your workbook
Using the Task Pane
Using the File Menu Option
Using the Windows Documents options
Printing your spreadsheet
File, Print
Print Options

11. REVIEW
Review topics
 
Excel 102
1. INTRODUCTION
Objectives
Pre-Requisites

2. USING AUTOFILL, PART ONE
Using AutoFill with series
Months of the year
Days of the week
Sequential dates
Number series
Non-seqential dates
Creating a calendar in Excel
Using the ZOOM drop-down
Zooming in and out
Zoom to selection
AutoFilling backwards (to the left)
###### showing up in your cells
Double-click to auto-resize a column
Highlighting multiple columns
Resizing multiple columns to the same width
Double-click resize multiple columns
Manually entering a column width

3. USING AUTOFILL, PART TWO
Right Click, Format Cells
Changing the format of a date
Two v. Four Digit Years
Using the Format Painter
Format Painter double-click trick
Sticky Format Painter
AutoFilling multiple columns/rows
Inserting a blank row or column
Forcing Excel to format text
Single-quote text formatting
Losing leading zeros (ZIP codes, SSN, etc.)
Align left
Merge and Center Cells
Center Across Columns
Print Preview
Cell Borders
Turning borders on and off
Preset borders
All Borders
No Borders
Thick Outside Border
Resizing rows to the same hight
Changing vertical cell alignment
Top, Center, Bottom vertical alignment

4. SORTING DATA
Setting up a new sheet
Green warning markers
Ignoring Errors
Numbers stored as text
Percent Style
Dealing with decimals and fractions
Increase Decimal
Decrease Decimal
Currency Style
How Excel rounds decimals
Using the AutoSum button
A warning about the AutoSum feature!
Sort Ascending
Sort Descending
Selecting the right cells to sort
Sort Warning
Expand the selection
Continue with the current selection
Accidentally scrambling your data
Recognizing the Key Cell to sort by
Sorting by the left-most cell in a range
Sorting by the right-most cell in a range
Sorting by some column in the middle of your range
Moving the Key Cell with the TAB key
Using Data > Sort
Sorting by up to three fields
The Sort Dialog box

5. CHARTING, PART ONE
Selecting which cells to chart
Selecting non-contiguous ranges with the CTRL key
Getting rid of Clippy, the Office Assistant
Using the Chart Wizard
Selecting a Chart Type and Chart Subtype
Verifying your data range
Entering a chart title
Where to place your chart
Chart as a new sheet
Chart as an object in an existing sheet
Using Format Data Series
Changing the color of your chart columns
Changing the background colors with Format Plot Area
Using Format Axis

6. CHARTING, PART TWO
Creating a 3D Column Chart
Press and Hold to View Sample
Entering a Category (X) Axis Title
Entering a Series (Y) Axis Title
Entering a Value (Z) Axis Title
The Axes tab - turning axis labels on/off
Major and Minor Gridlines
Showing or hiding the Legend
Legend Placement
Using Data Labels
Show Data Table
Show Legend Keys
Hiding the Chart Toolbar
Format Data Point
Changing the format of one specific column
Format Walls
Using a Gradient fill
Fill Effects
Textures
Patterns
Using 3-D View to rotate your chart
Changing elevation, perspective, rotation

7. CHARTING, PART THREE
Creating a pie chart
Category name, percentage data labels
Separating a piece of the pie
Separating all of the pie pieces
3-D View for pie charts
Formatting, moving data labels
Leader lines

8. REVIEW
Review topics
 
Excel 103
0. INTRODUCTION
Objectives
Pre-Requisites

1. SETTING UP OUR SHEET
Building an Income & Expense Report Sheet
Setting up Income & Expense Categories
Moving a range of cells with the mouse
Formatting our sheet
Inserting blank rows
AutoFill Review

2. WORKING WITH LARGE SHEETS
Freezing panes
Window, Freeze Panes
Window, Unfreeze Panes
Splitting the Screen
Window, Split
Window, Remove Split
Window, New Window
Insert Comments
Edit Comment
Delete Comment
Hiding Columns and Rows
Unhiding Columns and Rows

3. PAGE SETUP, PART ONE
Print Preview
Using the Magnifying Glass
Zooming in and out
Closing Print Preview
File, Page Setup
Page Orientation
Portrait v. Landscape
Scaling
Adjust to % Normal Size
Fit to pages
Print quality (resolution)
First Page Number
Additional printer options
Page Margins
Top, Bottom, Left, Right Margins
Header & Footer Margin Settings
Center on Page Horizontally, Vertically
Adjusting margins visually

4. PAGE SETUP, PART TWO
Headers & Footers
Using the stock page headers
Page header previews
Creating a custom header and footer
Left, center, right sections
Using the insert codes for headers/footers
Page numbering
Number of pages
Putting an ampersand in your headers
Inserting the date and time
The path and file of your workbook
Inserting a picture in your sheet
Changing text format of headers/footers

5. PAGE SETUP, PART THREE
Working with the Page Setup, Sheet tab
Specifying a Print Area
Using the range popup boxes
Rows to repeat at top
Columns to repeat at left
Showing gridlines
Black and white printing only
Draft quality
Showing row and column headings
Showing comments, options
Forcing comments to stay visible on sheet
Displaying Cell Errors
Page Order (numbering)

6. WORKING WITH MULTIPLE SHEETS
Viewing the page breaks
View, Page Break Preview
Moving the page break lines
View, Normal
Changing the name of your sheet tabs
Creating a copy of a sheet
Changing the color of a sheet tab
Using the keyboard to move between sheets
Deleting a sheet tab
Inserting a blank new worksheet
Moving a sheet tab with the mouse
Selecting multiple sheet tabs
Moving multiple sheet tabs
Format, Sheet, Background
Creating a background picture for the sheet

7. REVIEW
Review topics
 
Excel 104
0. INTRODUCTION
Objectives
Pre-Requisites

1. FORMAT CELLS: NUMBER FORMATS
Setting up a sales log sheet
Right Click, Format Cells
The Number Tab
General Number Format
Number of decimal places
Use 1000 Separator
Formats for negative numbers
Currency Style
Accounting Style
The Date Formats
The Time Formats
Percentage Formats
Fractions Format
Precisions with fractions
Scientific notation format
Plain Text Formats
Special Formats
Custom Formats, a brief discussion on
Using Format Painter on a whole column
Percent Style Button
Calculating sales tax by a tax rate
Math for calculating totals, subtotals

2. FORMAT CELLS: ALIGNMENTS
Format Cells, Alignment Tab
Setting vertical alignment
Top Vertical Alignment
Wrap Text to keep text in a cell
Text Orientation
Displaying text at an angle
Insert Cut Cells to move a whole row
Shrink To Fit text
Merge and Center
Center Across Columns
Merge Cells

3. FORMAT CELLS: FONTS
Format Cells, Font Tab
Strikethrough, Superscript, Subscript
Borders Tab
None, outline, inside borders
Manually turning borders on/off
Diagonal (strike) borders
Border styles, colors, thickness
Patterns tab
Setting a pattern and color
Cell protection, brief discussion

4. CONDITIONAL FORMATTING
Format, Conditional Formatting
Formatting a cell based on its value
Example: Highlighting sales over $300
Adding more conditions
Example: Highlighting sales under $100
Formatting based on a cell value

5. SPELLING, FIND, REPLACE, AUTOFORMAT
Tools, Spelling to spell check your sheet
Ignore once
Ignore all
Add to dictionary
Change
Change All
Edit, Replace
Find and Replace Dialog
Finding based on format
Match case
Match entire cell contents
Find Within (workbook, sheet, range)
Search By (rows, columns)
Look in (formulas)
Format, AutoFormat
Pre-designed AutoFormats

6. FINANCIAL CALCULATOR
Creating a loan calculator
Entering the value of the house, down payment
Calculating the financed amount
Entering the interest rate, period
Learning the PMT function
Using PMT to calculate the monthly payment
Calculating number of payments
Figuring out total interest paid
Currency Style button
Comparison shopping: compare two loans
Changing interest rates, periods, down payments
Calculating your savings
Locking specific cells to prevent tampering
Turning on sheet protection
Format Cells, Protection tab
Locked cells
Tools, Protection, Protect Sheet
Unprotect Sheet

7. REVIEW
Review Topics
 
Excel 201
0. INTRODUCTION
Objectives
Pre-Requisites

1. REVIEW AND SHEET SETUP
Setting up a student gradebook

2. THE IF FUNCTION, PART ONE
How the IF function works
Learning about logical tests
Specifying true and false values for IF
Using text values with IF

3. THE IF FUNCTION, PART TWO
Setting up a sales tax sheet for IF
Logical test with text values
Charging tax only to customers from NY

4. RELATIVE V. ABSOLUTE REFERENCES, PART ONE
Marking a student "pass" or "fail"
Move passing grade outside formulas
Making a cell reference absolute
absolute references v. relative references
AutoFill with absolute references
Move sales tax outside formulas

5. RELATIVE V. ABSOLUTE REFERENCES, PART TWO
Making passing grade based on class average
Grading on a "curve"
Creating a new quarterly sales summary sheet
Showing percent of sales for each quarter
Divide by Zero Error (#DIV/0!)

6. VALUES FROM OTHER SHEETS
Moving all of our external data to a new sheet
Refering to a cell on a different sheet
Cutting and pasting a link to a cell
Right click, paste special
Paste Special dialog box
Pasting the value of a cell (Paste Values)
#NAME? error
Referring to sheet names with spaces in them

7. COPYING DATA TO MICROSOFT WORD
Copying Excel sheet data into Word
Pasting Excel Data as a Word Table
Edit, Paste Special
Microsoft Excel Worksheet Object
Paste Link
Linking v. Embedding
Linking data back to the original Word document

8. TIPS AND TRICKS
Insert Cut Cells
Moving a whole row
Shift cells right
Shift cells down
Copying a sheet with the CTRL-drag trick
Manually drawing borders
View, Toolbars, Borders
Borders Toolbar
Pencil tool
Eraser tool
Insert Comments
Show Comments
Hide Comments

9. REVIEW
Review topics
 
Excel 202
0. INTRODUCTION
Objectives
Pre-Requisites

1. REVIEW AND SHEET SETUP
Reconstruct Student Gradebook
Short review of important concepts

2. NAMED CELLS
Defining a named range
Insert, Name, Define
Refers To Box
Using the Name Box
Naming the PassingGrade cell
Jumping to a named cell
Using the named cell in functions
Collapse Dialog
Expand Dialog
Valid names for cells

3. NAMED RANGES, PART ONE
Defining a named range
Pasting a named cell or range
Insert, Name, Paste
Using named ranges in formulas
Jumping to named ranges
Range Intersections

4. NAMED RANGES, PART TWO
Deleting a named range or cell
Editing a named range or cell
Pasting a list of your named ranges
Paste List
Creating names based on your headers
Insert, Name, Create
Applying names to existing ranges
Insert, Name, Apply

5. NESTED IF FUNCTIONS
What is a Nested IF function
Using the COUNT function
Checking multiple conditions
Giving our students an Incomplete
Giving a letter grade using nested IFs

6. VLOOKUP, PART ONE
Creating a subtable (lookup table)
Grade values lookup table
Using VLOOKUP to return the letter grade
Using VLOOKUP to return a commission rate

7. VLOOKUP, PART TWO
Expanding our lookup table to three columns
Using VLOOKUP to return multiple columns
Creating a basic invoice using Excel
Using HLOOKUP to calculate a discount
Using the Function Wizard for HLOOKUP

8. REVIEW
Review Topics
 
Excel 220
0. INTRODUCTION
Objectives
Pre-Requisites

1. DATA LISTS
Data Lists Defined
Header Row
Fields
Records
Database Terminology
Pick From List

2. FORMATTING DATA LISTS
Formatting the Header Row
Freezing Panes (review)
Calculate Time Difference (in hours)
Absolute References (review)
Conditional Formatting (review)
Spreadsheet v. Database (when to switch)

3. DATA ENTRY FORMS
Data entry forms defined
Opening the data form
Moving between fields
Entering data
New records
Find Previous
Find Next
Deleting records
You can't undo deletes
Calculated fields in data forms
Searching for records
Search Criteria
Using wildcard characters * and ?
Wildcard rules
Restore button

4. ADVANCED SORTING
The sum preview on the status bar
Changing from sum to a different function
Count v. Count Nums
Sorting month names in month order (not alpha)
First key sort order
Sort options
Custom Lists (using in sorts)
Sorting on more than 3 fields
Restoring a list's original sort order
Alphanumeric sorting rules

5. CUSTOMIZING TOOLBARS
Toolbars and commands defined
Customizing built-in toolbars
Reviewing the command button options
Moving buttons around
Removing buttons from toolbars
Copying a button from one toolbar to another
Resetting a toolbar to its default settings
Changing a button from icon to text
Creating a New Toolbar
Attaching a toolbar to a workbook (to share it)
Change Button Image
Creating a custom button image
Button Editor
Edit Button Image
Copying ANY image onto a button
Changing the tooltip text
Toolbars Options tab
Toolbar Quick-Add Buttons
Toolbar buttons with dual functions
How to backup your custom toolbars

8. REVIEW
Review Topics
 
Excel 221
0. INTRODUCTION
Objectives
Pre-Requisites

LESSON 1. FILTERING DATA
Data > Filter > AutoFilter
Filtering by a single item
Filtering by multiple items
Showing (All) records
Showing (Top 10...) results
Top/Bottom X Items/Percent
Duplicate values
Turning off AutoFilter
Adding AutoFilter and Show All to toolbar
1000 Item Limit

LESSON 2. CUSTOM FILTERS
(Custom...) AutoFilter
One item, equals
AND and OR conditions
End With
Inequalities (greater/less than)
Blank option
(Blanks) and (NonBlanks)

LESSON 3. ADVANCED FILTERING
Boolean operators
Creating custom advanced filter fields
Data > Filter > Advanced Filter
List Range
Criteria Range
Adding Advanced Filter to Toolbar
Creating a custom advanced Criteria Row
Filtering in place
Creating a named range for our DataList
Criteria named range
AND across, OR down

LESSON 4. SENDING LATE NOTICES (PROJECT)
Creating a customer list
Show records with missing data
Show customers over 30 days late
Copying filtered records
Showing non-blank records with Advanced Filters
Showing blank records with Advanced Filters
Showing customers in the 14xxx ZIP code
Wildcard Filter Characters
Showing customers with "gate" in address
Copying filtered records to a new sheet
Microsoft Word Mail Merge Wizard
Creating Mailing Labels
Configuring your Address Block
Matching Fields

LESSON 5. CALCULATED FILTERS, CUSTOM VIEWS
Calculating the average of all sales
Filtering sales above/below average
Calculating average of an entire column (D:D)
Custom Views
Creating a filtered Custom View
Switching between Custom Views
Placing Custom Views on your toolbar

LESSON 6. SUBTOTALS
Using the SUBTOTAL function
Why use SUBTOTAL instead of SUM
What the function_num means
List of available functions for SUBTOTAL
Using the Function Wizard with SUBTOTAL
Using the AutoSum button with SUBTOTAL
How AVERAGE doesn't work with filters
Using SUBTOTAL for averages
Creating automatic Subtotals
Data > Subtotals
Grouping and Outlining - brief discussion
Calculated Subtotals for each group
Removing subtotals
Sorting the list properly
Sorting to remove subtotals

7. REVIEW
Review Topics
 
Excel 222
INTRODUCTION
Objectives
Pre-Requisites

LESSON 1. STYLES
Format > Style
Style Dialog
Built-In Excel Styles
Currency Style
Modifying Styles
Style Patterns
Creating your own Styles
Changing styles throughout your workbook
Adding the Style dropdown to your toolbar
Style Borders
Merging styles from different workbooks

LESSON 2. GROUPING AND OUTLINING
Traditional outline formats
Sales & expenses
Tracking multiple stores
Data > Group and Outline > Auto Outline
Grouping and Outline Levels
Collapse and Expand
Data > Group and Outline > Clear Outline
Horizontal outlines
Grouping months into quarters
Data > Group and Outline > Settings
Summary rows below detail
Summary columns to right of detail
Automatic styles
RowLevel_1 and RowLevel_2
ColLevel_1 and ColLevel_2

LESSON 3. MANUAL GROUPING
Data > Sort review
Data > Group and Outline > Group
Creating a manual group
Creating a sorting and grouping toolbar
Manually creating subtotals
Hide detail and show detail
Review of creating a custom view

LESSON 4. GROUPING TIPS AND TRICKS
Selecting only visible items when you collapse a group
Selecting Visible Cells Only
Using the Go To command
Using CTRL-8
Creating a HeaderGroupStyle
Changing your style and watching the whole sheet change

LESSON 5. DATA VALIDATION
Correcting user input
Data > Validation
Checking text length
Custom Input Message
Custom Error Alerts
Stop, Warning, or Information
Dealing with dates in a range
Number types
Picking from a list
Drop down menu of options
Hiding your source list
Putting your list in the Settings dialog
Formula Auditing Toolbar - a quick look
Circle Invalid Data
Clear Validation Circles
Conditional Formatting - review
Custom formulas for data validation
ISTEXT() function
Ignore Blank
LEFT() function

REVIEW
Review Topics
 
Excel 223
  • What is a PivotTable
  • Building a PivotTable
  • Manipulating PivotTable Fields
  • PivotTable rules for data
  • Field Settings
  • Pivoting Your Data
  • Inner & Outer Fields
  • Example: Sales Log
  • Example: Employee List
  • Refreshing PivotTable Data
  • Filtering Data
  • Using Page Fields to Filter Data
  • Sorting PivotTable Data
Excel 224
  • Grouping Data
  • Drill to Detail
  • Grouping Dates Together (months, quarters, etc.)
  • Grouping Numeric Values
  • Subtotals
  • Subdetails
  • Advanced Field Settings
  • Formatting PivotTables
  • Copying PivotTable Data
  • PivotTable Options
  • Calculated Fields
  • Calculated Items
  • Base Fields & Items
  • Running Totals
  • Showing Data as a Percentage of Previous Data
  • Example: Employee Costs using IF, VLOOKUP, and a PivotTable
Excel 230
Lesson 1. Multisheet Ranges
Selecting Multisheet (3D) Ranges
Tracking sales for multiple years
Formatting multiple sheets with one selection
Creating a summary sheet

Lesson 2. Go To > Special
Comments, Formulas, Blanks,
Current Region, Objects, Row & Column Differences
Precedents & Dependents, Last Cell
Visible Cells Only, Conditional Formats,
Data Validation

Lesson 3. Advanced Find & Replace
Find, Replace Options
Wildcards: *, ?
using tilde ~ to find a wildcard character
Find Format > Choose Format From Cell
Find in Sheet, Workbook
Find All
Selecting all found cells
Find in Formulas, Values, Comments
Match Case
Match Entire cell
Careful when doing Replace All, esp w numbers!

Lesson 4. File Options
AutoRecover
AutoRecover Options
Saving Your AutoRecover file
File Save Options
Creating Automatic Backups
Password to Open, Modify
Encryption
Workbook Summary
Summary Fields (Subject, Title, etc.)
Custom Fields - creating a workbook database
Item, Type, Data

Lesson 5. Templates
Understanding templates
Modifying the default Excel template
Setting up custom workbook templates
Book.xlt, Sheet.xlt
XLStart Folder
Excel 231
LESSON 1. ERROR TYPES
Types of Errors
Syntax Errors
Logical Errors
Reference Errors
Circular References
Mismatched Parentheses

LESSON 2. SPECIFIC ERRORS
#DIV/0!
Handle DIV/0 error with IF function
ISERROR() function
#NAME?
#REF!
#VALUE!
#NUM!
SQRT() Function for square root
Exponents too large 10^308
#NULL!
#N/A
=NA() Function

LESSON 3. ERRORS WITHOUT MESSAGES
Logical Errors
Relative v. Absolute References
Rounding errors
Actual v. displayed values
ROUND() function
Force "Precision as displayed"
Floating Point Errors
Numbers close to zero not rounding right

LESSON 4. LOGICAL FUNCTIONS
TRUE
FALSE
NOT
AND
OR
=IF(AND(X,Y),TRUE,FALSE)

LESSON 5. AUDITING
Tracking Errors
Auditing Toolbar
Trace Dependents
Trace Precedents
Dependents on another sheet
Goto jumping to those dependents
Trace Errors
Blue and Red Arrows
Evaluate Formula
Evaluate, Step In, Step Out
Circle Invalid Data
Watch Window

LESSON 6. HIDING ERRORS
Automatic Error Checking
Hiding Cell Errors from Printouts

LESSON 7. CIRCULAR REFERENCES
Circular Iterations
When you WANT a Circular Reference
Simulating a DO LOOP

LESSON 8. TIPS & TRICKS
Transpose Data
Edit > Fill
Series Trend
Increasing X Weekdays
AutoFill with RIGHT Mouse Button
Upgrading to Excel 2007 Seminar
00. Intro (6:29)

01. The Ribbon 1 (8:03)

Ribbon Tabs
Ribbon Tab Groups
Simple Command Buttons
Complex Command Buttons
Drop-Down Menus
Dialog Box Launcher Buttons
On Demand Menu Tabs
Minimize the Ribbon

02. The Ribbon 2 (7:37)
Resize Formula Bar
Keyboard Shortcuts
New ALT-key Combinations
ALT-arrow keys
Live Preview
Mini Toolbar Popup Menu

03. Quick Access Toolbar (7:35)
Customizing
Office > Options > Customize
Adding Commands
Adding a Separator
Add for All Books
Add to This Book
Show Above / Below the Ribbon
Right-Click, Add to
Commands Not in the Ribbon

04. Upgrades & Changes (6:16)
Get the Latest Updates
Upgrades and Changes
Row, Cell, Size Increases
Other Changes

05. Office Button 1 (9:22)
Save, Load, Print, etc.
Save in Other Formats
New File Formats
XLSX, XLSM, XLTX, XLTM
Backward Compatibility
Excel 2007 Viewer
Other File Formats

06. Office Button 2 (12:32)
Pin Workbooks to Recent List
Print vs. Quick Print
Print Preview
Page Layout View
Prepare
Document Properties
Inspect Document
Encrypt Document
Digital Signatures
Mark as Final
Compatibility Checker

07. Excel Options (14:33)
Show Mini Toolbar
Enable Live Preview
Show Developer Tab
Edit Custom Lists
New Workbook settings
Font, Number of Sheets
Change Language Settings
R1C1 Reference Style
Other Formula Options
Error Checking Options
AutoCorrect Options
Spelling Options
Default File Format
AutoRecover
Advanced Options
Trust Center Settings
Macro Settings
Resources
Get Updates
About Excel

08. Home Tab 1 (11:02)
Home Tab
Clipboard Group
Upgrades to Paste Options
Draw Borders
New Color Options
Orientation Button
New Format Number Dropdown
Cells, Insert, Delete
Format Cells on Ribbon
New AutoSum Button

09. Home Tab 2 (13:52)
Styles
Conditional Formatting

10. Home Tab 3 (13:23)
Tables
Table Styles
How Tables Work
Total Row
Banded Columns / Rows
Table Autofilters
Sort & Filter
Sort By Color

11. Charts (14:58)
Inserting a Chart
No More Chart Wizard
Chart Types
Switch Row/Column
Quick Layout
Chart Styles
Move Chart
Layout Formatting

12. PivotTables (14:02)
Creating PivotTables
New / Changed Features
Adding Fields
Rows Columns
Formatting
Grouping
Sorting
PivotChart
Conditional Formatting

13. Illustrations (10:51)
Pictures
Clipart
Shapes
Smart Art

14. Insert Tab Misc (5:51)
Text Box
Header & Footer
WordArt
Signature Line
Object
Symbol

15. Themes (6:45)
Color Schemes
Font Groups
Effects

16. Page Layout (10:57)
Margins
Orientation
Page Size
Print Area
Page Breaks
Background
Print Titles
Scale to Fit
Gridlines
Headings
Arrange
Bring to Front
Send to Back
Selection Pane
Align, Group, Rotate

17. Formulas (12:37)
Insert Function
Search For Function Name
Function Libraries
New Functions
IFERROR
AVERAGEIF
AVERAGEIFS
SUMIFS
COUNTIFS

18. Get External Data (9:49)
From Access Database
From a Web Site
Automatic Refresh

19. Data, Review (4:32)
Remove Duplicates
Review Tab

20. Miscellaneous (11:45)
Templates
Microsoft Office Online
Customize Status Bar
Zoom Slider
Find & Select New Features
Name Manager
Create from Range
Range Intersections

21. Review (5:02)
 

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:

2/17/2021Old Excel 2003 Outlines
2/17/2021Excel Expert Outlines
2/17/2021Excel Beginner Outlines
12/26/2020Import New, Changed Records
12/13/2020Duplicates Conditional Formatting
12/3/2020Access v Excel
8/18/2020Excel Expert 11 Lessons
8/17/2020Excel Courses
8/17/2020Excel Expert Courses
8/15/2020Excel 2010 Beginner 1
 

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 9 1  PermaLink