MS Office Excel


Course description:


Microsoft Office Excel is a powerful and widely used tool that helps people analyze information to make more informed decisions. Using Office Excel and Excel Services, you can share and manage your analysis and insight with coworkers, customers, and partners with greater confidence.



This course requires a basic understanding of computers, such as the proper use of pointer and input devices.



Those interested in analyzing and applying formulated data.


What you will learn:

• The paper spreadsheet

• The Excel program

• The Workbook environment


Entering data and navigating in a worksheet

• Entering and correcting data

• Saving a file

• Using formulas

• Navigation and movement techniques


Modifying a workbook

• Working with ranges

• Moving data

• Copying data


Moving and copying data

• Inserting rows and ranges

• Moving data

• Copying data


Formatting a worksheet

• Formatting a worksheet

• Number formats and text alignment


Printing a worksheet

• Using the Print Preview command


Creating Excel Web pages

• Using Excel as a Web tool


Creating Charts

• Creating a Chart sheet

• Creating an embedded Chart

• Comparing Chart sheets with embedded Charts


Modifying Charts

• Chart Types

• Modifying embedded Charts

• Adding and deleting Chart items

• Moving and sizing Chart items


Formatting a Chart

• Formatting Chart text

• Formatting Labels

• Formatting the Chart

• Printing a Chart sheet


Using Graphic Objects

• Adding graphic objects

• Formatting graphic objects

• Using graphic objects to enhance Worksheets and Charts


Sorting Data

• Single-level sorting

• Multiple-level sorting

• Sorting options

• Importing data

• Design considerations


Filtering Data

• Filtering a list

• Custom criteria

• Multiple-condition criteria

• Managing a filtered list


Additional Topics

• Database functions

• Excel Web pages and the Internet or an Intranet

Customizing the Work Area

• Working with built-in toolbars

• Using custom toolbars

• Creating and using Styles

• Using Templates


Advanced Formula Construction

• Using Names

• Using the IF function

• Using the VLOOKUP function

• Using IS functions and the Auditing features


Using Pivot Tables

• Creating Pivot Tables

• Modifying Pivot Tables

• Grouping and summarizing data in a Pivot Table

• Creating interactive Pivot Tables for the Web


Working with Multiple Worksheets

• Working with Workbooks

• Linking cells in different Workbooks

• Workbook versus links and Workspaces

• Sharing and merging Workbooks

• Consolidating and analyzing data

• Consolidating data from more than one Worksheet

• Using the Goal Seek and Solver utilities

• Using Scenario Manager to view a Worksheet

with different input values


Using Protection and Display Options

• Using Comments

• Protecting Workbooks

• Using custom views


Introduction to Macros

• Running Macros

• Recording a Macro

• Viewing and editing VBA code


Working with Interactive Excel Web Documents

• Saving Excel Worksheets as Web documents

• Spreadsheet Web components.


Share this page!