Excel
Introduction and Intermediate Level 1 or equivalent knowledge. It is
not a necessary to take Intermediate Level 2 before this course. The
topics in this course are unrelated to Intermediate Level 2 topics.
Course Description
This course
is designed for Excel users who would like to learn more about creating
formulas, as well as brushing up on math skills.
Detailed List of Topics
Review
of Basic Formulas
Using
Operators
Order
of Calculation
Formulas that Reference One Cell
Copying
and Filling Formulas
Absolute Formulas
Partial
Absolute Formulas
Formulas And Range Names
Using
Range Names in Formulas
Using
Range Names For Values
Column/Row Headings in Formulas
Manipulating Formulas
Editing
Formulas
Converting Formulas to Values
Printing Formulas in Place of Results
Manual
Calculation
Combining/Splitting Cell Contents
Concatenating Formulas
Text To
Columns
Text
Formulas
Adding
Text to Value Cells
Date
and Time Formulas
Calculating Days Between Dates
Calculating Years Between Dates
Calculating Time Differences
Referencing Cells Not On Sheet
Multiple Sheet Formulas
Multiple File Formulas
Linking
Formulas
Auditing
Tracing Formulas
The Auditing Toolbar
Tracing Dependents
and Precedents
Displaying Formulas
Goal
Seek
Have
Excel Change Cell Value To Arrive At Desired Result
Formulas That Cannot Be Edited
Creating Array Formulas
Editing
Array Formulas
Computer Training
Courses / SoftSkills Seminars / Access Database Development
Computer Help is a division of MPM
Skills Development Inc.
Toronto, Ontario, Canada.
