Fully Customizable Courseware For Trainers
Excel 2002: Advanced
DOWNLOAD A FREE SAMPLE
Are your students ready for the advanced concepts in our Excel 2002 – Advanced training courseware? Have they already received training in the foundation and intermediate level curriculum?
Here are just a few of the topics and lessons covered in this Excel 2002 – Advanced courseware:
- Using Automatic Outlining
- Grouping Data Manually
- Creating a Pivot Table Frame
- Refreshing a Pivot Table?
- Creating a Pivot Table Based On Data from an External Database
- What Is A Scenario?
- Creating a Scenario
- Using Goal Seek
- Using Solver
- Browsing Hyperlinks in Excel
- Saving a Worksheet as a Web Page
- Saving a Chart as a Web Page
- Saving a Web Query
- Tracking Changes
- Merging and Revising a Shared Workbook
- Prompting For User Input
- Searching For Files
- Protecting Personal Information
- Protecting Your Workbook with A Password
- Using Detect and Repair
And many more topics!
Are you ready?
SECTION 1: Getting the Most From Your Data
Lesson 1.1: Outlining and Grouping your Data
Using Automatic Outlining
Displaying and Collapsing Levels
Grouping Data Manually
Creating Subtotals
Practice Exercise
Lesson 1.2: Pivot Tables
What is a Pivot Table?
Creating a Pivot Table Frame
Specifying Data in a Pivot Table
Rearranging Pivot Table Data
Practice Exercise
Lesson 1.3: More on Pivot Tables
Modifying Pivot Table Calculations
Formatting a Pivot Table
Refreshing a Pivot Table
Charting a Pivot Table
Creating a Pivot Table Based On Data from an External Database
Practice Exercise
Lesson 1.4: Exploring Scenarios
What Is A Scenario?
Creating a Scenario
Creating a Scenario Summary Report
Saving Multiple Scenarios
Practice Exercise
Lesson 1.5: What if Analysis
Using a One and Two Input Data Table
Using Goal Seek
Using Solver
Practice Exercise
Section 1: Review Questions
SECTION 2: Excel and the Internet
Lesson 2.1 Excel and Hyperlinks
Hyperlinks and The Internet
Inserting Hyperlinks
Modifying Hyperlinks
Using the Web Toolbar
Browsing Hyperlinks in Excel
Practice Exercise
Lesson 2.2 Excel Workbooks as Web Pages
Interactive and Non-Interactive Web Pages
Saving a Workbook as a Web Page
Saving a Worksheet as a Web Page
Saving a Chart as a Web Page
Saving a Range as a Web Page
Practice Exercise
Lesson 2.3 Getting Data from the Internet
Importing From an External Data Source
Creating a Web Query
Saving a Web Query
Refreshing a Web Query
Practice Exercise
Section 2: Review Questions
SECTION 3: Advanced Excel Tasks
Lesson 3.1: Creating and Using Shared Workbooks
Sharing a Workbook
Requesting Reviews
Reviewing a Workbook
Tracking Changes
Merging and Revising a Shared Workbook
Practice Exercise
Lesson 3.2: Visual Basic and Macros
Adding Code to Your Macro
Adding Comments to VBA Code
Declaring Variables
Prompting For User Input
Iteration over a Range
Using If Then Else Statements
Practice Exercise
Lesson 3.3: Advanced File Management
Identifying File Properties
Searching For Files
Protecting Personal Information
Creating Back Up Files
Changing Auto-Recovery Settings
Practice Exercise
Lesson 3.4: Excel Security
Digital Signatures
Macro Security
Protecting Your Workbook with A Password
Practice Exercise
Lesson 3.5: Custom and Advanced Features in Excel
Customizing Excel by Changing Options
Using Custom Auto-fill Lists
Using Detect and Repair
Practice Exercise
Section 3: Review Questions
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.
