Adobe Training
Acrobat Training
Captivate 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 2007 - Level 1
Course Description
Excel Level 1 is the first of 3 levels of Excel training we offer. This is a hands-on class where participants will learn to create, modify, format and print worksheets. You will learn to use basic formulas and functions and manage large workbooks.
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.
Leaning Objectives
Upon successful completion of this Excel training course students will be able to:
- Explore the Microsoft Excel 2007 Environment.
- Create a Basic Worksheet.
- Create Formulas to Perform Basic Calculations.
- Modify a Worksheet.
- Format the Look and Feel of a Spreadsheet.
- Print Workbook Contents.
- Manage Large Workbooks.
Upcoming Classes
Chicago |
Aug, 2008 | Sep, 2008 | Oct, 2008 | Nov, 2008 |
| Excel 2007 - Level 1 | Sep 29 | Oct 22 | Nov 17 |
Course Outline
Creating a Basic Worksheet
- Explore the User Interface and the Ribbon
- Navigate and Select in Excel
- Obtain Help
- Enter Data and Save a Workbook
- Customize the Quick Access Toolbar
Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
- Modifying a Worksheet
- Manipulate Data
- Insert and Delete Cells, Columns, and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
Modifying a Worksheet
- Manipulate Data
- Insert and Delete Cells, Columns, and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
Formatting a Worksheet
- Modify Fonts
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Apply Number Formats
- Position Cell Contents
- Apply Cell Styles
Printing Workbook Contents
- Print Workbook Contents
- Using Default Print Options
- Set Print Options
- Set Page Breaks
Managing Large Workbooks
- Format Worksheet Tabs
- Manage Worksheets in a Workbook
- Manage the View of Large Worksheets
Meet the Instructors
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.
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!"
