Microsoft Excel Introduction
Excel
Training
Provided by Computer Training Source, Inc.
In this class you will learn how to design financial spreadsheets, create formulas to total rows and columns, do averages and percentages, copy and move information, apply formatting to your spreadsheets, use the format painter, print, insert and remove columns and rows, do margins and set print ranges, and work on multiple spreadsheets at the same time. Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with practice files to take home. A free repeat, within six months, is included as well as thirty days of technical support. Class is usually one day from 9am to 4pm (unless it& 39;s an evening class or an accelerated class).
|
|
||||||||||||
Microsoft Excel Introduction
Understanding Excel
Examining The Projects
Examining The Excel Window
Opening A Workbook
Follow-up
Entering And Editing Data
Working With Columns And Rows
Understanding Formulas
Understanding Functions
Using Paste Function
Entering More Formulas
Follow-up
Looking At The Office Clipboard
Cutting, Copying, And Pasting
Moving Cells
Using Fills
Follow-up
Understanding Cell References
Using Relative References
Using Absolute References
Using More Functions
Follow-up
Adjusting Rows And Columns
Formatting Numbers
Aligning Text
Formatting Text
Applying Borders And Shading
Follow-up
Lesson 6 - Printing Worksheets
Adjusting Page Setup
Setting Up Headers And Footers
Setting Print Titles And Options
Setting Print Areas
Follow-up
Corporate Sales Forecast
Using The Help Window
Using The Contents Card
Using The Answer Wizard
Working With The Index
Using Context-sensitive Help
Follow-up
Lesson 9 - Common Tools And Shortcuts Appendix
Standard Tools
Formatting Tools
Navigation Shortcuts
Lesson 1 - Getting Started
Understanding Excel
Examining The Projects
Examining The Excel Window
Opening A Workbook
Follow-up
Lesson 2 - Entering Text And Formulas
Entering And Editing Data
Working With Columns And Rows
Understanding Formulas
Understanding Functions
Using Paste Function
Entering More Formulas
Follow-up
Lesson 3 - Moving And Copying Data
Looking At The Office Clipboard
Cutting, Copying, And Pasting
Moving Cells
Using Fills
Follow-up
Lesson 4 - Exploring Formula Construction
Understanding Cell References
Using Relative References
Using Absolute References
Using More Functions
Follow-up
Lesson 5 - Formatting Worksheet Appearance
Adjusting Rows And Columns
Formatting Numbers
Aligning Text
Formatting Text
Applying Borders And Shading
Follow-up
Lesson 6 - Printing Worksheets
Understanding Printing
Adjusting Page Setup
Setting Up Headers And Footers
Setting Print Titles And Options
Setting Print Areas
Follow-up
Lesson 7 - Application Project
Corporate Sales Forecast
Lesson 8 - Using Help Appendix
Using The Help Window
Using The Contents Card
Using The Answer Wizard
Working With The Index
Using Context-sensitive Help
Follow-up
Lesson 9 - Common Tools And Shortcuts Appendix
Standard Tools
Formatting Tools
Navigation Shortcuts
About The Training Provider: Computer Training Source, Inc.
Computer Training Source, Inc. - Computer Training Source, Inc. has offered computer training classes in Chicago, Il and New York, NY since 1991. We specialize in instructor-led training in all the popular desktop software applications. Training can be held at our training centers, at your location, or via the Internet. We have training rooms in the Chicago area (downtown, Naperville, and Schaumburg), and in the New York area...
