Fully Customizable Courseware For Trainers
Microsoft Office Excel 2003
Our mission is to provide you with the best possible courseware so you can teach incredible classes and workshops
High quality course content - written for you
Save hundreds of hours in developing training materials. Download our proven content used by trainers in 164 countries worldwide.
Enjoy confidence in the classroom
Facilitate perfect workshops everytime with high-quality training material with all the training components you need.
Save time & money with pre-written materials
Focus your attention on the training and we'll take care of the materials.
Course description
Are your students ready for the advanced concepts in Microsoft Office Excel 2003: Intermediate? Have they already received training in the foundation level curriculum? Velsoft training materials and courseware can help!
Here are just a few of the topics and lessons covered in this Microsoft Office Excel 2003: Intermediate courseware:
- Using Automatic Outlining
- Displaying And Collapsing Levels
- Specifying Data in a PivotTable
- Charting A PivotTable
- Creating A Scenario
- Using Goal Seek
- Using Solver
- Browsing Hyperlinks In Excel
- Saving A Worksheet As A Web Page
- Sharing A Workbook
- Requesting Reviews
- Reviewing A Workbook
- Tracking Changes
- Changing Auto-Recovery Settings
- Using Custom AutoFill Lists
- What Is Text To Speech?
And many more topics!
Are you ready? Download Velsoft’s customizable courseware training materials today!
Course outline
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: PivotTables
What Is A PivotTable?
Creating A PivotTable Frame
Specifying Data in a PivotTable
Rearranging PivotTable Data
Practice Exercise
Lesson 1.3: More on PivotTables
Modifying PivotTable Calculations
Formatting A PivotTable
Refreshing A PivotTable
Charting A PivotTable
Creating A PivotTable 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 AutoFill Lists
What Is Text To Speech?
Using Detect And Repair
Practice Exercise
Section 3: Review Questions
What you get
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
Whether or not you choose to introduce exercises into your training is up to you as the facilitator. In case you want to do this Velsoft offers you an Exercise Workbook (also customizable) that is specific to the course you are offering.
Sample Files
Each Velsoft courseware title comes with a Lab Workbook loaded with activities and exercises to practice and reinforce the learners' understanding of the course objectives. 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 workshop. This includes the PowerPoint versions of all the courses, prepared for you in advanced.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes in two pages the most important elements in each courseware title.
The best courseware in the world has Velsoft on the cover.
Our goal is to improve the daily life of those who train the world.
Velsoft empowers training providers with course material and educational technologies that get results.
Fully customizable
Easily make any changes to the material you like. Simply open in MS Word or Google Docs and localize the content to meet your training needs.
Unlimited reprinting
Print only what you need, when you need it. Print as many copies at your location as you like - forever. This includes editing and printing.
Unlimited users
Train as many people at your location as you like - forever. There is no per-user pricing or limit on the number of people that can be trained.
No annual renewal fees
This course comes with a perpetual license which means once you purchase it you never have to pay anything ever again.
COURSEWARE SAMPLE
Courseware you can customize.
View an eLearning Course
SCORM COMPLIANT
Available as an eLearning Course
ELEARNING SAMPLE
eLearning you can customize.
COURSEWARE SAMPLE
Courseware you can customize.
Safe & Inclusive Workplace
By Velsoft
Seeing Double
August Only
COURSEWARE SAMPLE
Courseware you can customize.