Fully Customizable Courseware For Trainers
Upgrading to Microsoft Office Excel 2007
DOWNLOAD A FREE SAMPLE
Do your students need Upgrading to Microsoft Office Excel 2007? It is essential to overall productivity to keep up to date with one of the most powerful and widely used spreadsheet applications used by businesses throughout the world. With our Upgrading to Excel 2007 courseware we provide you with all the tools you need to breathe new life into the otherwise hum-drum world of spreadsheets.
Our training materials turn YOU into the expert!?Instructors just like you rely on our courseware daily to provide their students with the best training possible. You will be able to completely customize your purchase. We even allow you to swap out our logo and replace it with your own.
You’ll get EVERYTHING you need. Instructor Guide, Power Point Presentations, a Student Manual and even Lesson Plans, we really have done all the work for you!
Why spend countless hours preparing for each lesson when you don’t have to?
We know you’ll find the added value that Upgrading to Microsoft Office Excel 2007 will provide. And now with our easy to use courseware we’ve made it easy. Add Upgrading to Microsoft Office Excel 2007 training materials to your library for a step-by-step guide to providing a workshop that will transform your people into more effective, competent producers.
Section 1: Getting Started
Lesson 1.1: Starting Out
What's New in Excel 2007?
Why Upgrade?
Our Favorite Features
Interface Overview
Step-By-Step
Skill Sharpener
Lesson 1.2: Getting Help in Excel
Using the Help Screen
About Online Help
About Offline Help
Step-By-Step
Skill Sharpener
Lesson 1.3: Saving your Files
File Formats
File Properties
AutoRecover
Upgrading a Workbook
Step-By-Step
Skill Sharpener
Lesson 1.4: Using the View Tab
Using Normal View
Using Full Screen View
Using Page Layout View
Using Page Break Preview
Step-By-Step
Skill Sharpener
Lesson 1.5: Printing your Workbook
Opening Print Preview
Using the Print Preview Tab
Quick Printing
The Print Dialog
Using Page Setup
Step-By-Step
Skill Sharpener
Section 1: Case Study
Section 1: Review Questions
Section 2: The New Interface
Lesson 2.1: The Quick Access Toolbar
The Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar
Step-By-Step
Skill Sharpener
Lesson 2.2: The Home Tab
Clipboard
Font
Alignment
Number
Style
Cells
Editing
Step-By-Step
Skill Sharpener
Lesson 2.3: The Insert Tab
Tables
Charts
Illustrations
Links
Text
Step-By-Step
Skill Sharpener
Lesson 2.4: The Page Layout Tab
Themes
Page Setup
Scale to Fit
Sheet Options
Arrange
Step-By-Step
Skill Sharpener
Lesson 2.5: The Formulas Tab
The Function Library
Defined Names
Formula Auditing
Calculation
Step-By-Step
Skill Sharpener
Lesson 2.6: The Data Tab
Get External Data
Connections
Sort and Filter
Data Tools
Outline
Step-By-Step
Skill Sharpener
Lesson 2.7: The Review Tab
Proofing
Comments
Changes
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 3: Basic Spreadsheet Tasks
Lesson 3.1: Using Templates
Opening a Template
Downloading a Template
Using a Template
Creating a Template
Step-By-Step
Skill Sharpener
Lesson 3.2: Using Formulas in Excel
Understanding Relative and Absolute Cell References
Basic Mathematical Operators
Using Formulas with Multiple Cell References
The Formula Auditing Buttons
Fixing Formula Errors
Displaying and Printing Formulas
Step-By-Step
Skill Sharpener
Lesson 3.3: Customizing your Workbook
Inserting a Symbol or Special Character
Adding and Editing Shapes
Creating and Altering Diagrams
Changing the Diagram Type
Incorporating Text
Adding a Signature Line
Step-By-Step
Skill Sharpener
Lesson 3.4: Finishing your Workbook
Using the Document Inspector
Using the Compatibility Checker
Marking a Workbook as Final
Step-By-Step
Skill Sharpener
Section 3: Case Study
Section 3: Review Questions
Section 4: Charts and PivotTables
Lesson 4.1: Working with Charts, Part 1
Creating a Chart
Formatting a Chart
Modifying Charts with the Layout Tab
Manipulating a Chart
Enhancing a Chart with Shapes and Graphics
Step-By-Step
Skill Sharpener
Lesson 4.2: Working with Charts, Part 2
Changing the Type of Chart
Changing the Source Data
Working with the Chart Axis and Data Series
Saving a Chart as a Template
Step-By-Step
Skill Sharpener
Lesson 4.3: PivotTables
What is a PivotTable?
Creating a PivotTable
Creating a PivotTable Frame
Specifying PivotTable Data
Rearranging PivotTable Data
Step-By-Step
Skill Sharpener
Lesson 4.4: More about PivotTables
Modifying PivotTable Calculations
Formatting a PivotTable
Refreshing a PivotTable
Charting a PivotTable
Creating a PivotTable Based on External Data
Step-By-Step
Skill Sharpener
Section 4: Case Study
Section 4: Review Questions
Section 5: Advanced Topics
Lesson 5.1: Using Excel with other Programs and Files
Using Outlook to Send Excel Data
Opening an Excel File in a Different Format
Importing Data from a Text File
Importing Data from External Data Sources
Publishing a Workbook as a PDF File
Faxing a Workbook
Step-By-Step
Skill Sharpener
Lesson 5.2: Excel and Office Servers
Publishing to a Document Server
Saving to a Document Management Server
Using Excel with Excel Services
Step-By-Step
Skill Sharpener
Lesson 5.3: Add-ins and the Trust Center
What is a COM Add-in?
Add-In Management
Installing Add-ins
Using the Trust Center
Step-By-Step
Skill Sharpener
Section 5: Case Study
Section 5: Review Questions
Index
Everything you need to deliver amazing training
Each courseware title is a trainers' kit that comes with the following course components:
Instructor Guide
Velsoft Instructor Guides are the core of each training course. Our Instructor Guides lay out the training in simple, easy-to-follow instructions. You can also customize the Instructor Guides in order to personalize your training.
Student Manual
Each Instructor Guide - for each course - is paired with a Student Manual that you can present to your participants. This customizable Student Manual gives each participant the ?student? version of the course you will be teaching.
Exercise Workbook
Velsoft offers an Exercise Workbook (also customizable) that is specific to the course you are offering. You can choose whether this is something you would like to present to your students.
Sample Files
Pre-made Sample Exercise Files are provided for use with the Lab Workbook so that you, as the trainer, do not have to prepare activity working files.
PowerPoint Deck
Courseware from Velsoft is designed to give you everything you need for use in the classroom or for your workshop. This includes the PowerPoint versions of all the courses, prepared for you in advance.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes the most important elements in each courseware title down to two pages.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
