Excel 2010/2013
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
NEW Release: Access Developer Level 3   dismiss
 
 

Upgrading to Excel 2007
Learn What's New and Different in Microsoft Excel

 
Are you still using Excel 2003, or an older version? Want to see what's new and different in Excel 2007? Or perhaps, have you already upgraded to Excel 2007? Are you struggling with the new features, or perhaps want to see what's new that you're missing?
 
If you said YES to any of these questions, then this seminar is for you. This video seminar will teach you about all of the new and changed features in Excel 2007
. Click here to watch a video explaining the goals for this seminar, or scroll down for more information.





 

Seminar - Upgrading to Excel 2007
Description: Upgrading to Excel 2007
Versions: We will learn with Excel 2007, and will cover all of the new features. If you're used to Excel 2003, XP, 2000, or even Excel 97, you will be just fine in this seminar.
Pre-Requisites: Excel 101 strongly recommended
Running Time: Over Three and a Half Hours (3 hours, 38 minutes)
Cost: $39.99

 

This seminar is for the person who wants to learn what's new and improved in Excel 2007. We will begin by covering the new menu interface called The Ribbon.

 

You will learn about the Quick Access Toolbar and how to customize it with your own buttons.

 

Next you'll learn about the upgrades and changes to Excel 2007, for example, Excel can now handle much, much larger spreadsheets (rows and columns) and is faster at calculations. We'll discuss all of the upgrades and enhancements.

 

We'll learn about all of the new features on the Office Button, which is the replacement for the File menu. We'll also talk about all of Excel's new file formats, including XLSX and XLSM.

 

There are a whole ton of new settings on the Options Menu. This is the replacement for Tools > Options. We'll cover all of the important ones.

 

Next we'll start going over the different Ribbon Tabs, starting with the Home Tab, and we'll look at all of the new features. A lot of the changes involve new locations for old Excel 2003 features. I'll point out many of these.

 

One of the features that has received a major improvement is Conditional Formatting. You're no longer limited to just three formats. You can have an almost unlimited number of conditions, plus you can use color bars, icons, and lots more. We'll spend a whole lesson on this.

 

Data in Excel can now be stored in something called a Table, which is very similar to a Table in a Microsoft Access database. We'll learn all about these, in addition to the upgrades to Sort & Filter.

 

No seminar on new Excel features would be complete without a lesson covering Charts & Graphs. There have been a lot of new enhancements here.

 

We'll learn about all of the changes to PivotTables and PivotCharts.

 

There are a lot of excellent new enhancements that Microsoft made in the area of Graphics & Illustrations. Working with Pictures, Clipart, Shapes, and SmartArt has never been easier. There are a ton of new formats and styles available.

  

We'll cover all of the items on the Insert Tab including Text Boxes, Headers & Footers, WordArt, Signature Lines, Inserting Objects, and Symbols.

 

I'll show you how to work with Themes, which are new collections of color schemes, font sets, and effects in Office 2007. I'll show you how these work in conjunction with styles to create professional-looking spreadsheets.

 

We'll cover all of the changes to Page Layout in detail, including Margins, Orientation, Paper Size, Print Area, Breaks, Background, and Print Titles.

  

There are several New Functions in Excel 2007, including IFERROR, SUMIFS, AVERAGEIFS, and COUNTIFS. I'll show you how to use all of these.

 

I will show you how to Get External Data into Excel and keep it linked to the source data. We'll import some Microsoft Access data. Then I'll show you how to pull down real-time data from a Web site (like this stock portfolio data) and then refresh it with one click.

 

 

We'll go over the new features on the Data and Review tabs, including the new Translate button.

 

Finally, we'll go over any other minor features and function that we missed in the previous lessons, like the Name Manager, Zoom Slider, and the new Microsoft Office Online Templates.

 

Plus there are a lot of extra, small tips and tricks that are thrown in throughout this seminar - like keyboard shortcuts and other timesavers. If you use Excel 2007 at all, or you're thinking about upgrading, then this seminar is definitely worth your while. 

This seminar is pretty long (over 3.5 hours) but it's broken up into 22 easily managed lessons of about 8 to 15 minutes each. You can site down, watch a lesson, review the material, play with it yourself, and experiment. Do a little bit each day. It's long, but it's comprehensive - you won't miss a single step as I've recorded everything from start to finish. Of course, if you have any questions about whether or not this seminar is for you, please contact me.
 

 

Complete Seminar Outline - Topics Covered

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)

 


 

 
 
 

Student Interaction: Upgrading to Excel 2007 Seminar

Richard on 1/1/2009:  Upgrading to Excel 2007 Seminar - Changes & New Features in Excel - The Ribbon & Quick Access Toolbar - Office Button & Tools - Conditional Formatting - Data Tables, Sort & Filter - Charts, Graphs, PivotTables, PivotCharts - Graphics, Illustration, Pictures, Shapes - Headers & Footers, Inserting Objects - Themes, Color Schemes, Effects, Styles - New Functions like SUMIFS and IFERROR - Get External Data from Access & the Web - And lots more!  
Richard B. Jordan on 11/11/2009: How difficult is it to load from 2002 to 2007? Does your tutorial include this info? Since you reccomend it I suppose you have included it but would like to read your comments before ordering. Please enlighten me! Thanks.
Richard Rost on 11/11/2009: Richard, I didn't have any problems at all installing Office 2007. You can have your 2002 and 2007 together on the same PC if you'd like (just pick a different install folder).

To date I haven't found a single one of my spreadsheets that doesn't work in 2007, so I'm very happy with it. Like I said in the video, there really isn't anything EARTH SHAKING that you have to get that's in Excel 2007, except once you get used to it, the Ribbon really does make working in Excel easier (I was resistant at first). Plus, if you like making PRETTY charts and use a lot of images, that has really been enhanced.

Richard Jordan on 1/15/2010: Is it possible to put one piece of data in a cell without all the data that came with it.Can I put NYSE Composite Volume in cell T2120 and Nasdaq Composite volume in cell V2120 using data from URL http://online.wsj.com/mdc/public/page/2_3021-tradingdiary.html?mod=topnav_2_3020. Please advise.
Richard Jordan on 2/9/2010: How do I import single bits of data? I want to import NYSE volume into one cell and have it up date automatically. The URL I use is http://online.wsj.com/mdc/public/page/2_3021-tradingdiary.html?mod=topnav_2_3000. Please comment.

Reply from Richard Rost:

Richard, the easiest way to handle this situation is to just import the entire table of data into a "scratch" sheet, and then copy/paste-link the cell data that you want into another sheet. This way you can pick and choose the bits of information that you want in your REAL sheet.

Richard Jordan on 7/19/2010: In a column of the Dow Averages or Daily Volume, how can conditional formatting be used to note a change in direction; i.e., a number higher - say green - or lower - say red, and also a third color to show a new high has been reached. Then how to set these up to operate continuosly? I can do some of this but not all, and am unable to drag settings so once set up no daily input is required. Please help.

Reply from Richard Rost:

Unless you've got a separate cell indicating this change, you can't do this with simple conditional formatting. Once a value is updated, Excel has no idea what the old value in the cell is... without some VBA programming.

 Lynn Robbins on 9/20/2010: as an example: how to import baseball standings e.g. from internet
MLB.com or other such sources???
Thank you

 

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

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP