> feedback
Hi Tony, I did enjoy your class. Your teaching style was
very easy to follow and you provided some good take-away
information. Thank you for including me, I will be in
touch shortly. Thank you again, Alison
...based on my previous limited exposure to Microsoft Excel I
was especially grateful for your taking the time to explore
with me whether that was the program that would suit my
current need. Your suggestion to invest in another more
appropriate program and then follow up with any training that
might be needed made a lot of sense.
Thank you again for your time, expertise and patience.
This
past summer I took a class with Tony Holowitz.
Before the class I have to admit I was a bit concerned if
I’d be able to keep up, computers make me so nervous.
Tony was able to make me feel very comfortable and
explained what to do so well I really learned how to use the
Excel program I was being taught.
He went slow enough and yet was thorough so I had a good
handle on how to continue to improve myself independently with
the program…
|
|
Microsoft Excel 2007 Training
Part 1 & Part 2
Excel
training will give participants an understanding of the
basic functions of Microsoft Excel. During the session
participants will receive training on many different
uses of Microsoft Excel, including an introduction to
the formulas available and their uses.
The Excel 1 class is designed for those who are new to
Microsoft Excel. A basic knowledge of working within
Microsoft Word environment is desirable, but not
necessary.
Our Excel 2 class explores options and techniques more
experienced users would appreciate.
Read: Our
Approach to Teaching Office 2007
_______________________________
Microsoft
Excel 1 Outline
What is Excel?
Starting Excel
Basic Concepts of Spreadsheets
An introduction to Workbooks and Worksheets
Working with Rows and Columns
Cell References
Navigating within Excel
Using the Mouse
Using the Keyboard
Useful Keyboard Shortcuts
Data Entry
Entering Text, Numbers and Dates
Correcting Errors
File Management
Saving Files
Opening Files
Formatting Cells
Number Formats
Cell Formatting including Borders and Shading
AutoFormat
Format Painter
Printing and Page Setup
Scaling
Fitting to Page
Margins
Headers and Footers
Printing Options
Time Saving Techniques
Cut, Copy and Paste
Freeze Panes
Basic Calculations within Excel
Addition, Subtraction, Multiplication and Division
An Introduction to Functions
Functions including: SUM, MIN, MAX and AVERAGE
GIGO
_______________________________
Microsoft
Excel 2 Outline
Intermediate and Advanced Classes Thoughts
Dislike second classes
Outline Issues
The Dietitian Story
Replicating Data
More Keyboard Shortcuts
Tutorial vs. Class
More than one way
Algebra issue
Review Tony's Place Key Points
Formulas
Cheating to remember Formulas
Absolute Reference
Sort
Auto Filter
Freeze Headings
Data Filter
Format Painter
Text File to Excel Trick
Link to other sheets
Color tab
Move worksheet
Intro to Pivot tables
Formatting a spreadsheet
Conditional Formatting
Print Area
Excel Options
Creating Charts
Manipulating Data in Excel
Summarize Data |
 |
|
|
|
New classes are
included at
no extra cost
|
|