Edutrends, Inc.
Training For Tomorrow's Technology
   

Home

PC Software Training
MS Word Training
Excel Training
PowerPoint Training

PC Assessment Software
Excel Assessment
MS Word Assessment

Textbooks
Excel for Everyone
PowerPoint For Everyone

Word for Everyone

CBTs Courses
Networking Essentials Part I
Networking Essentials Part II
Network+ Part I
Network+ Part II
Networking With Windows NT 4
Admin Windows NT 4 Network
UNIX Made Easy
Linux Made Easy
Local Area NetworksFundamental
Local Area Networks Interconnections
ISDN Technology & Applications

Ordering Information

Contact Us

Links

MICROSOFT Excel for Everyone Training

Classroom Sets, Network Version and Single User Packages Available

Microsoft Excel for Everyone was designed to provide basic instruction in the use of the Microsoft Excel for Windows spreadsheet. This training guide explains basic concepts and procedures of Microsoft Excel, and how to apply them in everyday business situations. Emphasis is on learning the most common features of Microsoft Excel.  Microsoft Excel for Everyone includes a workbook and a sample files disk that contains examples that will be used throughout the course and assessment software which evaluates your mastery of the features covered in the workbook.

For each technique this course teaches, you'll find a brief explanation of the Microsoft Excel command. The explanation is followed by a set of exercises that allow you to learn by doing. This guide provides you with the keystrokes needed to perform each major operation. To ensure accuracy, screen displays follow many exercises, so that you can compare your own screen with this book. Quiz Yourself end of chapter review questions, evaluate your knowledge of topics covered and provide lots of practice.

The Final Project exercises reinforce the commands covered in the training course, and will provide you with a way to determine if you have mastered the commands covered. An index at the end of this guide provides you with an easy way to look up any procedures you may have to review.

Available: Single User, Classroom Sets and Network Versions
Microsoft Excel is a registered trademark of Microsoft Inc.

Microsoft Excel for Everyone Training Outline

Unit 1: Creating And Editing Worksheets

The Excel Worksheet
Using The Menus & Tool Bars
Deleting Rows
Saving Your Work
Changing Cell Width
Opening A Spreadsheet

Unit 2: Creating Professional Looking Spreadsheets

What Is A Range?
Format
Formatting Numbers
Data Alignment
Printing
Formatting Text
Fonts

Unit 3: Copying Formulas &Text

Copying
The Undo Feature
Copying Formulas

Unit 4: Creating A Typical Business Worksheet

Creating A Typical Business Worksheet
Naming Ranges
Mathematical Functions
Absolute Cell Address
Printing
Headers And Footers

Unit 5: Database Sorting & Charts

What Is A Database?
Sorting
Sorting By More Than One Field
Moving Cell Entries
Calculating Division Totals
Creating Charts
Selecting The Range To Chart
Creating A Column Chart
Resizing The Chart
Moving The Chart
Creating A Separate Chart
Line Chart
Pie Chart
Titles

Unit 6: Dates

Date Arithmetic
Using Standard Date Formats
Calculating Dates

Unit 7: Database Queries

Querying The Database List
Using Conditions To Filter A List
Finding Records Using Single Column Filtering
Logical Operators Used In Filters
Filtering A Range Of Values
Filtering On Two Columns

Unit 8: Working With Multiple Sheets In An Excel Book

Multiple Spreadsheets In A Book File
Selecting Sheets In The Book
Copying Information To Other Sheets
Creating A Summary Sheet

Final Project Exercise

How to Use Assessment Tool with Microsoft Excel for Everyone

You will benefit from using this assessment tool while learning Excel with Edutrends training guide. There are several ways you may want to use this assessment software to enhance your training experience. You can use it as a pretest tool, to determine your knowledge of Excel before beginning the training. You may use it at the end of each chapter after completing the hands on Quiz Yourself assessments provided at the end of each chapter. At anytime you may choose to be tested on all topics or you can choose selected topics. You may use it at the end of the entire training to determine how well you have mastered the information covered. Regardless of how you choose to use this assessment tool, it will help you to determine how well you are grasping the Excel training material as you progress through the course.

Sample Diagnostic Report:
Microsoft Excel Assessment

Evaluation for Chelsea Morris ID Number 915

Creating and Editing Worksheets                              100%

Creating Professional Looking Spreadsheets             90%

Copying Formulas & Text                                            80%

Creating a Typical Business Worksheet                     90%

Dates                                                                             80%

Database Queries                                                          46%

Working with Multiple Sheets In an Excel Book        100%

Total                                                                                86%

NOTICE: In the above report, it is easy to see that Chelsea Morris needs more help with database queries.