2 days ago: New Feature: you can now upload your Profile Picture to the site. Check it out!  Dismiss
 
Excel 2010-2019
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
 
 

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.



Sorry, this item is no longer available.

 

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.
 

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.

 

 
 
 

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
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
PCResale.NET
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
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/19/2024 2:12:01 AM. PLT: 0s