Our technicians know that the best way for people to get the most out of their computers is to get the right training for the tools they use. Contact your Tech Hero today to find out how to get training on the most popular programs used today.
Microsoft Office Training
Microsoft Office Training
Microsoft Office is the most commonly used suite of programs used in the business world. Click on the links below for details on each of the programs available.
Click on the title below to view a list of course offerings
Microsoft Excel
Microsoft Excel
Outline:
- Lesson 1: Introducing Excel 2003
Screen Layout
Create & Open A Database
View A Workbook
Save A Workbook
Print Workbooks
Help In Excel 2003
- Lesson 2: Work With Cells
Cell Basics
Enter Data
Edit Data
Copy And Move Data
Copy & Move Data
Insert & Delete Cells
- Lesson 3: Calculate Your Data
Formulas
Cell References
Functions
- Lesson 4: Work With Your Workbook
Modify A Worksheet
Modify A Workbook
- Lesson 5: Format a Worksheet
Format Characters
Format Cells
Auto Format
- Lesson 6: Work With graphics
Work With Graphics
Add Charts
- Lesson 7: Automate Your Work
AutoFill
AutoComplete
AutoCalculate
- Lesson 8: Collaborate With Others
Collaborate On Workbooks
Work With Comments
- Lesson 9: Customize Excel 2003
Advanced Features & Customization
Customize Menus
Customize Toolbars
- Lesson 10: Calculate your Data
Work With Named Ranges
Use Subtotals
Use Lookup Functions
Find & Correct Errors
- Lesson 11: Manage & Analyze Data
Create & Filter Lists
Sort List Data
Outline A Worksheet
Query External Databases
XML Documents
Goal Seek & Solver
Scenarios
Link & Consolidate Data
PivotTables & PivotCharts
- Lesson 12: Format a Worksheet
Conditional Formatting
Styles
- Lesson 13: use Macros
Create Macros
Work With Macros
"Step Into" A Macro
- Lesson 14: Manage Data & Workbooks
Link & Consolidate Data
Import & Export Data
- Lesson 15: Collaborate With Others
Share Workbooks
Track Changes In A Shared Workbook
Workbook Protection & Properties
- Lesson 16: EXCEL & THE WEB
Create Web Pages