Excel Training | Chicago & Los Angeles
Fast Facts
1 day
Max 8 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. View past student's video testimonials.
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.
Excel Training Package Deals
Find our more about our Microsoft Excel Training deals and our 100% Money Back Guarantee.
Learning Objectives
Upon successful completion of this Microsoft Excel class 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 |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Excel 2003 - Level 1 | Mar 31 | May 5 | Jun 28 |
Los Angeles |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Excel 2003 - Level 1 | Mar 24 | May 3 | Jun 16 |
* Class almost full ! Class guaranteed to run † Class is full
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.
Allyncia
Allyncia has 12 years of corporate training experience. She holds a Bachelors degree in Psychology and Spanish.
Ms. Williams has studied, traveled, and worked abroad in 14 countries. As a corporate communications consultant in Tokyo, Japan, she created business skills and cross-cultural training programs for a wide range of clients including Goldman Sachs, Deutsch Bank, Nissan, Mitsubishi, Johnson & Johnson Co., Eddie Bauer, JAPEX, Ministry of International Trade to name a few.
Since returning to the US, Allyncia has consulted in HR and Training roles with Hewitt Associates, LaSalle Bank and Unicare.
