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: Advanced File Tasks

• Lesson 1.1: Using My Computer within Excel
  • Using the My Places Toolbar
  • Navigating with My Computer
  • Performing Basic Tasks with My Computer
  • Changing Views
• Lesson 1.2: Saving your Files
  • File Formats
  • File Properties
  • AutoRecover
  • Upgrading a Workbook
• Lesson 1.3: Using Templates
  • Opening a Template
  • Downloading a Template
  • Using a Template
  • Creating a Template

Section 2: Working with Functions and Formulas

• Lesson 2.1: Using Formulas in Excel
  • Understanding Relative and Absolute Cell References
  • Basic Mathematical Operators
  • Using Formulas with Multiple Cell References
  • The Formula Auditing Buttons
  • Fixing Formula Errors
  • Displaying and Printing Formulas
• Lesson 2.2: Exploring Excel Functions
  • What are Functions?
  • Finding the Right Function
  • Some Useful and Simple Functions
• Lesson 2.3: Using Functions in Excel
  • Inserting Functions
  • Using Functions and AutoFill to Perform Difficult Calculations
  • Using the IF Function
  • Working with Nested Functions
• Lesson 2.4: Working with Names and Ranges
  • What Are Range Names?
  • Defining and Using Range Names
  • Selecting Nonadjacent Ranges
  • Using AutoCalculate
• Lesson 2.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 3: Managing Tables

• Lesson 3.1: Working with Tables
  • What is a Table?
  • Creating Tables
  • Modifying Tables
  • What is the Total Row?
• Lesson 3.2: Working with Records and Fields
  • What are Records and Fields?
  • Adding Fields by Inserting Columns
  • Adding Records by Inserting Rows
  • Quickly Adding Records to a Data table
  • Deleting Records or Fields
• Lesson 3.3: Working with Tables and Filters
  • Sorting Data in a Table
  • What is an AutoFilter?
  • Custom AutoFilters
  • Using an Advanced Filter
  • Copying Filtered Records
• Lesson 3.4: Using Excel as a Database
  • Filtering with Wildcard Characters
  • Validating Your Data
  • What are Database Functions?

Section 4: Enhancing your Workbook

• Lesson 4.1: Customizing your Workbook
  • Inserting a Symbol or Special Character
  • Adding and Editing Shapes
  • Creating and Altering Diagrams
  • Changing the Diagram Type
  • Incorporating Text
  • Adding a Signature Line
• Lesson 4.2: Working with Text Boxes
  • Adding a Text Box
  • Selecting a Text Box
  • Manipulating a Text Box
  • Formatting a Text Box
• Lesson 4.3: WordArt
  • Adding WordArt to your Spreadsheet
  • Changing the Font Color
  • Changing the Outline Color
  • Adding Effects
• Lesson 4.4: ClipArt
  • Finding ClipArt
  • Inserting ClipArt
  • Manipulating ClipArt
  • Inserting a Photographic Image
• Lesson 4.5: Using Objects
  • Creating New Embedded Objects
  • Embedding Existing Files
  • Editing Embedded Objects
  • Embedding Parts of Files

Section 5: Finalizing Your Workbook

• Lesson 5.1: Protecting your Workbook
  • Protecting your Workbook
  • Protecting your Worksheets
  • Unlocking Cells
  • Protecting your Excel Files
• Lesson 5.2: Finishing Your Workbook
  • Using the Document Inspector
  • Using the Compatibility Checker
  • Marking a Workbook as Final
• Lesson 5.3: Using Excel in Word
  • Inserting Excel Data in Word
  • Linking Excel Data in a Word Document
  • Modifying Excel Data after Insertion
  • Insert an Excel Chart into a Word Document
• Lesson 5.4: Using Excel and Access
  • Linking an Excel Workbook to an Access Database
  • Importing Table, PivotTable, and PivotChart Data from Access
  • Transforming an Excel Workbook into an Access Database
• Lesson 5.5: 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 External Data Sources
  • Publishing a Workbook as a PDF File
  • Faxing a Workbook