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  
 
 
Excel 2007 Upgrade Seminar Recorded
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   12 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)

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:

11/30/2021Import Multiline Cells
11/11/2021Link to Excel
11/11/2021Read Write Excel Data
11/10/2021Excel Moving Average
9/11/2021Circular References
8/25/2021Stock History
8/23/2021Concatenation
8/17/2021Flash Fill
8/5/2021Stock Portfolio
8/4/2021Stock Portfolio
 

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
Keywords: excel 2007 upgrade seminar  PermaLink