Microsoft Excel 2010                                                       


Level I

Participants gain hands-on experience in Beginning Excel for Windows applications.  Topics include creating worksheets, workbooks and calculations in Microsoft Excel.

Keyboarding/Typing

Level I

Participants will learn to type by touch using Mavis Beacon computerized typing program.  Students become familiar with different keyboard and document functions while improving typing speed and accuracy.

Preparing to Type

               Basic Operational Techniques

Learning the Letter Keys

               Learning the Letter Keys

               Reaches on Lower Keys

               Reaches on the Upper Keys

               Keyboard Mastery

               Mastering the Alphabets

               Shifting for capitals

               Drill on Letters and Words

Numbers & Special Symbols

               Number Location

               Number Keys

               Drill on Numbers on Sentences

               Speed Development

               Quizzes and Speed Drills


Getting Started

  • Understanding the Display Screen, Ribbon & Quick Access Toolbar
  • Accessing Excel On & Offline help
  • Creating a Worksheet
  • Opening & Managing Workbooks
  • Exploring Backstage View

Entering Data

  • Moving the Cell Pointer
  • Selecting a Range of Cells
  • Creating a New Workbook
  • Entering Constant Values
  • Saving a Workbook
  • Clearing & Editing Cell Contents
  • Working with the Undo/Redo Function
  • Closing a Workbook
  • Exiting Excel

 

Using Formulas

  • Entering Formulas
  • Using the SUM Function
  • Summing Columns or Rows Automatically
  • Using Statistical Functions
  • Working with the Range Finder
  • Using Formula Error Checking

Working with Constant Values & Formulas

  • Copying & Pasting Constant Values & Formulas
  • Moving & Pasting Constant Values & Formulas
  • Using Collect & Paste
  • Use AutoFill

Formatting Worksheets

  • Formatting Numbers
  • Changing the Font Format
  • Aligning Cell Contents
  • Merging Cells
  • Adding Borders
  • Applying Cell Styles

Modifying Columns & Rows

  • Changing Column Width & Row Height
  • Using AutoFit
  • Inserting & Deleting Columns or Rows
  • Hiding Columns or Rows
  • Using Custom Worksheet Views

Editing Workbooks

  • Working with AutoCorrect
  • Checking Spelling
  • Using Find and Replace

Printing Worksheets

  • Working in Page Layout View
  • Creating a Header & Footer
  • Using Print Preview
  • Using Page Setup Tools
  • Using Page Break Preview
  • Printing a Worksheet


Microsoft Excel 2010


Level II

Participants gain hands-on experience in Intermediate Excel for Windows applications.  Topics include charting, graphic objects, querying data, mapping, sorts & filters, and using basic macros


Charting

  • Using the Chart Wizard
  • Creating a Chart, Chart Types, Chart Elements, Formatting, Editing & Printing
  • Embedding/Linking Charts into Word & PowerPoint
  • Creating a Chart Sheet
  • Pivot Charts & Interactive Pivot Charts

Graphic Objects

  • Adding Graphic Objects
  • Formatting & Editing

Querying Data

  • Query Options & Querying the Web
  • Database Functions
  • Databases the Web (2000) & External Database

 

Using Lists

  • Plan & Create a List
  • Add Records with the Data Form
  • Find & Delete Records
  • Sort by One or Multiple Fields
  • Print a List

 

Charting

Using the Chart Wizard

Creating a Chart, Chart Types, Chart Elements, Formatting, Editing & Printing

Embedding/Linking Charts into Word & PowerPoint

Creating a Chart Sheet

Pivot Charts & Interactive Pivot Charts

Graphic Objects

Adding Graphic Objects

Formatting & Editing

Querying Data

Query Options & Querying the Web

Database Functions

Databases the Web (2000) & External Database

 

Using Lists

Plan & Create a List

Add Records with the Data Form

Find & Delete Records

Sort by One or Multiple Fields

Print a List

Charting

Using the Chart Wizard

Creating a Chart, Chart Types, Chart Elements, Formatting, Editing & Printing

Embedding/Linking Charts into Word & PowerPoint

Creating a Chart Sheet

Pivot Charts & Interactive Pivot Charts

Graphic Objects

Adding Graphic Objects

Formatting & Editing

Querying Data

Query Options & Querying the Web

Database Functions

Databases the Web (2000) & External Database

 

Using Lists

Plan & Create a List

Add Records with the Data Form

Find & Delete Records

Sort by One or Multiple Fields

Print a List

Mapping

  • Creating a Data Map, Elements, Format a Map
  • Editing a Map Data

Sorts & Filters

  • Sorting Options
  • Single, Multiple Level Sorting
  • Design Considerations
  • Custom Multiple Condition Criteria
  • Filtering a List & Managing a Filtered list

Using Macros

  • Recording, Running, Editing a Macro
  • Using Shortcut Keys with Macros
  • Use Personal Macro Workbook
  • Add a Macro as a Menu Item
  • Create a Toolbar for Macros

Working with Advanced Formulas

  • Create Formula with Several Operators
  • Use Names in Formula
  • Use Dates in Calculations
  • Use Statistical Functions, Display & Print Formula Contents


Microsoft Excel

Level III

 

Participants gain hands-on experience in Advanced Excel for Windows applications.  Topics include advanced charting & formatting, customizing templates, pivot tables, file linking/object linking & embedding, visual basic for applications and the Web as well as additional features.


Advanced Charting

  • Combination Charts, Double Y-axis, XY Scatter Charts, Picture Charts & Re Scaling the Scatter Axis, Display Units
  • Volume/High Low-Close
  • Custom Chart Options
  • Creating Figures & Comment Boxes

Pivot Tables

  • Creating & Working with Pivot Tables
  • Viewing Pivot Tables at Different Levels & Pivot Chart Reports
  • Dragging Reports into Worksheet

Dialog Box

  • Creating & Customizing Dialog Boxes
  • Using Dialog Box Control as Worksheet Objects

File Linking/Object Linking & Embedding (OLE)

  • Using Workbooks, Linking Individual Cells
  • Workbooks vs. Links and Workspaces
  • Introduction to OLE
  • Using MS-Word as Your Report Writer

Protecting & Displaying Options

  • Using Comments, Hiding Information
  • Custom Views & Protecting the Worksheet

Customizing

  • Creating Templates
  • Creating New Toolbar
  • Creating & Using Styles

More Advanced Formula Construction

  • IF, VLOOKUP & PMT Functions
  • Nested Functions
  • Error Handling & Auditing Features
  • Using Split & Freeze Panes
  • Revise Formulas

 

Visual Basic for Applications (VBA)

  • Introduction, Create & Edit VBA Codes
  • Consolidating Data & Using Analysis Tools
  • Consolidating Worksheets
  • Goal Seek & Solver Utilities
  • Creating a Scenario Using Scenario Mgr.

Web and Excel

  • Web Overview & How Web Pages are used with Excel
  • Round Tripping & Keeping Office Specific Formatting
  • Consolidate Data with 3D References
  • Understanding Web Folders & Auxiliary Files
  • Web Queries & Managing Web Docs
  • Create Hyperlinks
  • Overview of Office 2000’s New Web tools, On-line Meetings & Subscribing to a Document & Discussions
  • Interactive Pivot Table Lists
  • Save as HTML

Auditing a Worksheet

  • Work with the Auditing Toolbar
  • Trace Dependents (Find Formulas that Refer to a Specific Cell)
  • Trace Errors (Find & Fix Errors)
  • Trace Precedents (Find Cells)