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
You will learn about the
Quick Access Toolbar and how to customize it with your own
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
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.
seminar is pretty long (over 3.5 hours) but it's broken up into
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 Tab Groups
Simple Command Buttons
Complex Command Buttons
Dialog Box Launcher
On Demand Menu Tabs
Minimize the Ribbon
Ribbon 2 (7:37)
Resize Formula Bar
New ALT-key Combinations
Mini Toolbar Popup Menu
Quick Access Toolbar (7:35)
Office > Options > Customize
Adding a Separator
Add for All Books
Add to This Book
Above / Below the Ribbon
Right-Click, Add to
Commands Not in the
04. Upgrades & Changes (6:16)
Get the Latest Updates
Upgrades and Changes
Row, Cell, Size
05. Office Button 1 (9:22)
Save, Load, Print, etc.
Save in Other Formats
New File Formats
XLSX, XLSM, XLTX, XLTM
Excel 2007 Viewer
Other File Formats
06. Office Button 2 (12:32)
Pin Workbooks to Recent List
Print vs. Quick Print
Page Layout View
Mark as Final
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
Error Checking Options
Default File Format
Trust Center Settings
08. Home Tab 1 (11:02)
Upgrades to Paste Options
New Color Options
New Format Number
Cells, Insert, Delete
Format Cells on Ribbon
09. Home Tab 2 (13:52)
10. Home Tab 3 (13:23)
How Tables Work
Columns / Rows
Sort & Filter
Sort By Color
11. Charts (14:58)
Inserting a Chart
No More Chart Wizard
12. PivotTables (14:02)
New / Changed Features
13. Illustrations (10:51)
14. Insert Tab
Header & Footer
15. Themes (6:45)
16. Page Layout
Scale to Fit
Bring to Front
Send to Back
17. Formulas (12:37)
Search For Function Name
18. Get External Data (9:49)
From Access Database
From a Web Site
19. Data, Review (4:32)
20. Miscellaneous (11:45)
Microsoft Office Online
Customize Status Bar
Find & Select New Features
21. Review (5:02)