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 you ready to learn additional skills in Microsoft Office Excel 2003: Advanced?
If you understand the program foundations, it makes sense to learn more skills. It will improve your efficiency.
Are you an instructor? Are you sure that your students to improve their skills? Instructors all over the world have been using our pre-written, customizable training material courseware since 1998.
There is a lot to learn. Here are just a few of the topics and lessons covered in this Microsoft Office Excel 2003: Advanced courseware:
- Understanding Relative And Absolute Cell References
- Finding The Right Function
- Using Basic Array Formulas
- Using Functions With Array Formulas
- What Is A List?
- Adding Fields By Inserting Columns
- What Is An AutoFilter?
- Validating Your Data
- Playing A Macro
- Using Form Controls
- Linking An Excel Chart In Word
- Importing Data From A Text File
And many more topics!
Our courseware and included training material is fully customizable so the instructor can add whatever content they deem necessary (or take away whatever is not).
Course outline
SECTION 1: Working with Functions and Formulas
Lesson 1.1: Using Formulas in Excel
Understanding Relative And Absolute Cell References
The Basic Mathematical Operators
Using Formulas With Multiple Cell References
The Formula Auditing Bar
Fixing Formula Errors
Displaying And Printing Formulas
Practice Exercise
Lesson 1.2: Exploring Excel Functions
What Are Functions?
Finding The Right Function
Some Useful And Simple Functions
Practice Exercise
Lesson 1.3: Using Functions in Excel
Inserting Functions
Using Functions And AutoFill To Perform Difficult Calculations 3
Using the IF Function
Working With Nested Functions
Practice Exercise
Lesson 1.4: Working with Names and Ranges
What Are Range Names?
Defining And Using Range Names
Selecting Nonadjacent Ranges
What Is Auto Calculate?
Practice Exercise
Lesson 1.5: Working with Array Formulas
What Are Array Formulas?
Using Basic Array Formulas
Using Functions With Array Formulas
Using The IF Function In Array Formulas
Practice Exercise
Section 1: Review Questions
SECTION 2: Managing Lists
Lesson 2.1: Working with Lists
What Is A List?
Creating Lists
Modifying Lists
What Is The Total Row?
Practice Exercise
Lesson 2.2: Working with Records and Fields
What Are Records And Fields?
Adding Fields By Inserting Columns
Adding Records By Inserting Rows
Adding Records With A Data Form
Finding And Deleting Records
Practice Exercise
Lesson 2.3: Working with Lists and Filters
Sorting A List
What Is An AutoFilter?
Custom AutoFilters
Using An Advanced Filter
Copying Filtered Records
Practice Exercise
Lesson 2.4: Using Excel as a Database
Filtering With Wild Card Characters
Validating Your Data
What Are Database Functions?
What Are Lookup Functions?
Practice Exercise
Section 2: Review Questions
SECTION 3: Working with Macros and Controls
Lesson 3.1: Creating Macros in Excel
What Is A Macro?
Creating A Macro
Playing A Macro
Assigning A Shortcut Key To Macro
Macros, Buttons, And Toolbars
Practice Exercise
Lesson 3.2: Excel Form Controls
What Is A Form Control?
The Form Toolbar
Adding A Control To A Worksheet
Assigning A Macro To A Control
Using Form Controls
Practice Exercise
Section 3: Review Questions
SECTION 4: Using Excel with Other Programs
Lesson 4.1: Using Excel in Word
Inserting Excel Data In Word
Modifying Excel Data After Insertion
Linking Excel Data In Word
Linking An Excel Chart In Word
Practice Exercise
Lesson 4.2: Using Excel w/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 A Database
Practice Exercise
Section 4: 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.