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
MS 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 MS 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
MS 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
MS 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 MS 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 MS 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 MS Excel
Book 100%
Total
86% |
NOTICE: In the above report, it is easy to see that Chelsea Morris
needs more help with database queries. |
|