|
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.
Sorry, this item is no longer available.
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)
Sorry, this item is no longer available.
|
