Adobe Training
Acrobat Training
Dreamweaver Training
Flash Training
Flex Training
Illustrator Training
InDesign Training
Photoshop Training
Web Development
AJAX Training
CSS Training
HTML Training
JavaScript Training
PHP MySQL Training
Ruby on Rails Training
XML Training
Microsoft Office
Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training
Business Skills
Anger Management Class
Business Communication
Business Etiquette Training
Business Writing Class
Change Management
Customer Service Training
Project Management Training
Sales Training
Supervisor Training
Time Management Training
QuickBooks
QuickBooks Training
Excel Training | Chicago
Fast Facts
1 day
Max 10 students
9.00am to 4.30pm
One per student
Included
295.00
Excel 2003 - Level 1
Course Description
This is the first of 3 levels of excel training we offer. You will learn to store and manage data in Excel, perform calculations and generate reports.
Target Audience
This Excel course is ideal for people new to Excel who need to produce reports, budgets, lists and other spreadsheets. No prior knowledge of Microsoft Excel is required, however it would be beneficial to have a general understanding of personal computers and the Windows operating system.
Leaning Objectives
Upon successful completion of this Excel training course students will be able to:
- Start Microsoft Excel, Navigate and Exit correctly.
- Setup a new Spreadsheet.
- Modify a Worksheet.
- Select Ranges of Cells in Spreadsheet.
- Create Formulas to Perform Basic Calculations.
- Format the Look and Feel of a Spreadsheet.
- Print Spreadsheets.
- Customize the layout of the Excel window.
Upcoming Classes
Chicago |
Jul, 2008 | Aug, 2008 | Sep, 2008 | Oct, 2008 |
| Excel 2003 - Level 1 | Jul 28 | Aug 18 | Sep 22 |
Course Outline
Getting Started with Excel
- An Overview of Excel
- Navigate in Excel
- Select Data
- Enter Data
- Save a Workbook
- Obtain Help
Modifying a Worksheet
- Move and Copy Data Between Cells
- Fill Cells with Series of Data
- Edit Cell Data
- Insert and Delete Cells, Columns, and Rows
- Find, Replace, and Go To Cell Data
- Spell Check a Worksheet
Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
- Create an Absolute Reference
Formatting a Worksheet
- Change Font Size and Type
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Merge Cells
- Apply Number Formats
- Create a Custom Number Format
- Align Cell Contents
- Find and Replace Formats
- Apply an AutoFormat
- Apply Styles
Developing a Workbook
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
- Copy a Workbook
Printing Workbook Contents
- Set a Print Title
- Create a Header and a Footer
- Set Page Margins
- Change Page Orientation
- Insert and Remove Page Breaks
- Print a Range
Customizing Layout
- Split a Worksheet
- Arrange Worksheets
- Freeze and Unfreeze Rows and Columns
- Hide and Unhide Worksheets
Meet the Instructors
Rich
Rich has been creating custom software programs, and delivering tailored training classes for the past 13 years. His passion for instruction and his pursuit of all things technical, combine with his outgoing personality to provide an engaging and enthusiastic exchange of knowledge and ideas with his trainees. Software training for Rich is a labor of love. As he puts it, "When you love what you do, it's really not work after all!"
Sandy
Honest, direct, detail-oriented and compassionate, Sandy has more than 15 years of software training experience to help everyday users expand their computer knowledge. She has provided training to companies such as Bear Stearns Securities Corp. and the Chicago Board Options exchange.
She has an Associates in Applied Science, Management and an Associates in Arts, General Education from College of DuPage. Sandy currently runs her own consulting company specializing to helping clients manage their accounting using Quicken and Quickbooks.
