Follow Tony
Twitter: Tony Holowitz
Tony Holowitz on LinkedIn
My YouTube Channel
My Blog
Free Computer Training
 
 
 

Beginners
Computers 101

For Business
ACT!
QuickBooks

Microsoft Office Training
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Outlook

Web Design
My Portfolio

Additional Topics
AddressGrabber
Antivirus Software
BlackBerry
Blogs
Camtasia Studio
Carbonite
ColorSchemer
CompanionLink
Contact List Plus
Copernic
CSS
DIV’s
Domain Names
Dragon
Durkin Computing
EFax
Egrabber
Expression Web
Facebook
Facebook Fan Pages
Firefox
GoDaddy
Google AdSense
Google AdWords
Google Alerts
Google Analytics
Google Chrome
GoToMeeting
GoToMyPC
GoToWebinar
handheld devices
Internet Explorer
iPhone
Istockphoto
iTunes
LinkedIn
ListGrabber
LogMeIn
Microsoft Access
Microsoft Expression Web
Network Magic
Photoshop
Picasso
ping.FM
RoboForm
Screencast.com
Skype
Snagit
Social Networking
Software Add-ons
Sperry Software
Spyware
Styles
Swiftpage
System Mechanic
Task List Plus
Tweet Adder
TweetDeck
Twitter
Two Monitors
UltraMon
WordPress
Working with Video
YouTube





Microsoft Excel 2003, 2007 and 2010 Training

Classes Part 1, 2 and 3 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 & 3 classes explores options and techniques more experienced users would appreciate.

Microsoft Excel 1 Training 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
Correcting Errors
File Management
Saving Files
Opening Files
Formatting Cells
Number Formats
Scaling
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 Training Outline
Intermediate and Advanced Classes Thoughts
Dislike second classes
Outline Issues
The Dietitian Story
Tutorial vs. Class
More than one way
Algebra issue
Review Tony's Place Key Points
Formulas
Cheating to remember Formulas
Sort
AutoFilter
Freeze Headings
Color tab
Move worksheet
Intro to Pivot tables
Excel Options
Working with Excel Tabs
Formatting Multiple Sheets
Comparing Workbooks
Naming Cells
Conditional Formatting
Print Area
Excel Options
Creating Charts
Manipulating Data in Excel
Summarize Data

Microsoft Excel 3 Outline
Cell Formatting including Borders and Shading
AutoFormat
Format Painter
Printing and Page Setup
Fitting to Page
Margins
Headers and Footers
Printing Options
Absolute Reference
Text File to Excel Trick
Link to other sheets
Formatting a spreadsheet