Microsoft Excel 2003 Intermediate

This course provides competency in applying text attributes and other formatting characteristics, creating workbooks from templates, using styles, adding worksheet backgrounds, applying AutoFormats, and finding and replacing data, & much more.

Course Outline

Working With Functions And Formulas

• Using Formulas In Excel
  • Understanding Relative And Absolute Cell References
  • The Basic Mathematical Operators
  • Using Formulas With Multiple Cell References
  • The Formula Auditing Bar
  • Fixing Formula Errors
  • Displaying And Printing Formulas
  • Exploring Excel Functions
  • What Are Functions?
  • Finding The Right Function
  • Some Useful And Simple Functions
  • Using Functions In Excel
  • Inserting Functions
  • Using Functions And AutoFill To Perform Difficult Calculations
  • Using The If Function
  • Working With Nested Functions
  • Working With Names And Ranges
  • What Are Range Names?
  • Defining And Using Range Names
  • Selecting Nonadjacent Ranges
  • What Is Auto Calculate?
  • Working With Array Formulas
  • What Are Array Formulas
  • Using Basic Array Formulas
  • Using Functions With Array Formulas
  • Using The If Function In Array Formulas

Managing Lists

• Working With Lists
  • What Is A List?
  • Creating Lists
  • Modifying Lists
  • What Is The Total Row?
  • Working With Records And Fields
  • What Are Records And Fields?
  • Adding Fields By Inserting Columns
  • Adding Records By Inserting Rows
  • Adding Records With A Data Form
  • Finding And Deleting Records
  • Working With Lists And Filters
  • Sorting A List
  • What Is An AutoFilter
  • Custom AutoFilters
  • Using An Advanced Filter
  • Copying Filtered Records
  • Using Excel As A Database
  • Filtering With Wild Card Characters
  • Validating Your Data
  • What Are Database Functions?
  • What Are Lookup Functions?

Working With Macros And Controls

• Creating Macros In Excel
  • What Is A Macro?
  • Creating A Macro
  • Playing A Macro
  • Assigning A Shortcut Key To Macro
  • Macros, Buttons, And Toolbars
  • Excel Form Controls
  • What Is A Form Control?
  • The Form Toolbar
  • Adding A Control To A Worksheet
  • Assigning A Macro To A Control
  • Using Form Controls

Using Excel With Other Programs

• Using Excel In Word
  • Inserting Excel Data In Word
  • Modifying Excel Data After Insertion
  • Linking Excel Data In Word
  • Linking An Excel Chart In Word
  • Using Excel With Other Programs And Files
  • Using Outlook To Send Excel Data
  • Opening An Excel File In A Different Format
  • Importing Data From A Text File
  • Importing Data From A Database

Additional Details

Pre-Requisites

Microsoft Excel 2003 Foundation

Certificates offered

Certificate of completion

Cancellation Policy

Cancellations less than 2 business weeks before the expected delivery date are eligible for a 50% refund, or a credit voucher will be provided for regularly scheduled courses (choice being that of the registrant). Credit Vouchers are transferable within the same company. Please send your cancellation notice to info@itplanit.com.

Map & Reviews

Itplanit Services Corp.
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

A very interesting course. Claude Gerin, our instructor, was excellent in making this a very interesting and learning experience. THANKS!

Reviewed by Oleg T. 2012