Excel 2007 Upgrade Seminar Recorded - Computer Learning Zone

Excel 2007 Upgrade Seminar Recorded
By Richard Rost

17 years ago

I just finished recording all of the videos for the Upgrading to Excel 2007 Seminar. This seminar is over 3.5 HOURS long and covers just about everything that's new and exciting in Excel 2007.

Even if you've been using Excel 2007 for a while now (yes, I know it's been out for over 2 years already) I'll bet that you'll learn something new in this seminar. I've been using Excel myself for over a year, and even I learned a bunch of new stuff while researching this seminar.

Like I said, I just finished recording the videos. I'll be editing and packaging up the course tonight and hope to have it online for download this evening, if not definitely by tomorrow.

The handbook should be ready in about a week. I've got a whole team of authors who write handbooks for me now (and they do awesome work) so the handbook will be available very soon.

For the curious, here's the complete outline of everything that's covered in this class. I'll have to "real" full outline (with screen shots) posted on the web site within the next 24 hours.

Excel Upgrade 2007 Seminar
3 hr 38 min

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)

Subscribe to Excel 2007 Upgrade Seminar Recorded
Get notifications when this page is updated