Microsoft Excel is a powerful spreadsheet program that you
can use to efficiently store and work with lists of data,
calculate numbers, and create reports and charts. MS Excel
enables you to:
- Enter and format your data, and write formulas
- Office Assistant
- Headers and Footers
- Print Titles and Options
- Working with Series
- Create a template to speed up your work
- Linking Worksheets
- Consolidate data from several worksheets into one.
- Find and organize information by filtering, sorting, and
subtotaling.
- Summarize and analyze data using PivotTable dynamic
views.
- Use charting to visualize trends and relationships.
- Print the reports you require.
- Find the optimum answer by using Goal Seek and Scenario
Manager to compare alternatives.
- Saving a Workbook as a Web Page
- Work simultaneously with others by sharing a workbook
via your company intranet.
- Plus much more . . .
Excel is the premiere spreadsheet software program.
Creating and Implementing Spreadsheets is a must have skill
for any successful business, and MS Office 2000 contains more
options and benefits than the prior versions. Our training
gives you the skills necessary to get the most out of your
Excel projects.
Our Excel Office training will answer your most fundamental
questions beginning with a definition of MS Excel. It proceeds
to cover navigation, creation, modification, and printing of
workbooks, formatting values and rangers, drawing functions,
data sorting, and the creation and use of templates.
- Introduction
- What is Excel
-
Navigation
-
Cells
-
Sheets
-
Rows
-
Columns
-
Creating a Workbook/Spreadsheet
-
Copying Data
-
Moving Data
|
- Introduction
- Undo
-
Cutting Data
-
Series
-
Saving
-
Using Online Help
-
Formatting Values & Ranges
-
Opening a Workbook
-
Deleting Cell Contents & Worksheets
-
Revising Text and Numbers
|
Also advances into the more in-depth applications of Excel.
Our training covers auto and custom formatting, applications
of formulas, use of IF functions, and importing data and lists
from outside sources.
Using Drawing Tools
Using Functions
Using Charts
Inserting & Deleting Rows & Columns
Using & Creating Templates
Auto Formatting
Creating &Working with Formulas
Formula Basics
Mathematical Operators
Order of Operation |
Copying Formulas Using Relative Reference
Copying Formulas Using Absolute Reference
Using IF and Nested IF Functions
Working with Dates
Importing Data from Other Sources
Importing Lists
Conclusion
|
We cover the
most comprehensive topics of the Excel program. It contains
information on advanced charts, hyperlinks and macros, filters
and sorts, data analysis, conditional formatting and styles,
sharing workbooks and workgroups and their functions, and
pivot tables.
Advanced Charts
Linking Spreadsheets & Workbooks
Hyperlinks and Saving as HTML
Creating & Using Macros
Using Fields & Sorts
Data Analysis |
Conditional Formatting
Styles
Auditing a Workbook
Sharing Workbooks & Workgroup Functions
Pivot Tables
|
Attend five hours per week for 10 weeks to total
50 hours
of lecture/workshop training. Weekly worksite implementation
projects hone your skills and additional one-on-one instruction
ensures all your questions get answered! Enrollment is limited.
Apply
Now!
This in-depth program is designed for graduates of previous
PDC Office training and those who already have good working
knowledge of Word and Excel. Each Excel 2003 participant must have a computer loaded with the
appropriate software (95 or higher) dedicated to his/her use
at work.
Have a question or need more information?
* I Have a
Question
* Contact the PDC
* Who Can
Apply for Training
|
