Prerequisite

This course presumes that the user has a basic knowledge of Windows concepts (such as My Computer, cutting, copying, selecting, and pasting) as well as a basic knowledge of Excel concepts (such as toolbars, menus, and the interface components).

Details

Click on a date to request further information or to register.

Course Outline

There is no disputing that Microsoft Excel is a powerful tool.  This tool allows users to create spreadsheets that can be formatted to allow for sharing of critical data. Users can make informed decisions by formatting and analyzing data. From basic data entry to creating charts and pivot tables for rich data visualization, students will derive a greater appreciation for the value of the data.

Section 1: Working with Functions and Formulas

• Lesson 1.1: 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
• Lesson 1.2: Exploring Excel Functions
  • What are Functions?
  • Finding the Right Function
  • Some Useful and Simple Functions
• Lesson 1.3: Using Functions in Excel
  • Inserting Functions
  • Using Functions and AutoFill to Perform Difficult Calculations
  • Using the IF Function
  • Working with Nested Functions
• Lesson 1.4: Working with Names and Ranges
  • What are Range Names?
  • Defining and Using Range Names
  • Selecting Nonadjacent Ranges
  • What is Auto Calculate?
• Lesson 1.5: Working with Array Formulas
  • What are Array Formulas?
  • Using Basic Array Formulas
  • Using Functions with Array Formulas
  • Using the IF Function in Array Formulas

Section 2: Managing Lists

• Lesson 2.1: Working with Lists
  • What is a List?
  • Creating Lists
  • Modifying Lists
  • What is the Total Row?
• Lesson 2.2: 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
• Lesson 2.3: Working with Lists and Filters
  • Sorting a List
  • What is an AutoFilter?
  • Custom AutoFilters
  • Using an Advanced Filter
  • Copying Filtered Records
• Lesson 2.4: Using Excel as a Database
  • Filtering with Wild Card Characters
  • Validating your Data
  • What are Database Functions?
  • What are Lookup Functions?

Section 3: Working with Macros and Controls

• Lesson 3.1: Creating Macros in Excel
  • What is a Macro?
  • Creating a Macro
  • Playing a Macro
  • Assigning a Shortcut Key to Macro
  • Macros, Buttons, and Toolbars
• Lesson 3.2: 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

Section 4: Using Excel with Other Programs

• Lesson 4.1: 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
• Lesson 4.2: Using Excel w/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