Microsoft Excel

Our courses introduce you to the world of computers using Microsoft Excel. Learn how to utilize Excel's powerful features to save, edit, format and print professional spreadsheets.

LEVEL 1

Excel Basics
Menus & Toolbars
The Spreadsheet Concept
Opening & Closing a Workbook


Entering & Moving Information
Labels and Values
Entering and formatting text
Formatting numbers within cells
Cutting and Copying cells
Selecting a range of cells
The Fill Handle


Formulas
AutoSum
Minimum
Average
Absolute References


Formatting Worksheets
Inserting Columns and Rows
AutoFit & Currency
Formatting fonts, sizes
Borders and shading


Print Preview
Headers, Footers and Margins
Center worksheet on page
Scaling & Freezing Panes
Printing Worksheets, formulas


Additional Features
Increasing/Decreasing Decimals
Working with Dates
QuickSort
Using Spreadsheets for analysis & database

LEVEL 2

Lookup Functions
Vlookup
Hlookup


Filtering Data
AutoFilter
Advanced Filter


Charts
Chart Types
Creating a chart
Editing a chart
Printing a chart


Macros
Assigning a Macro to a Keyboard
Running a Macro


Formulas
The “If” Statement


Range
Range Names
Pasting a List of Named Ranges


Additional Features
Linking Workbooks
Scenario Summary Report

Professional Training
 training classroom rental locations Locations
computer training room rental facility Training Room Rental



Technical Advancement is a full service technology firm.  We offer services in software development, networking, and Web site creation. Our seasoned staff of certified engineers, developers, and technical professionals can help you solve your IT challenges. Technical Advancement has been servicing our clients business and technology needs since 1982
 September 7, 2010 11:32:51 PM