Slideshow

MS Office Excel

E-mail

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.

 

Prerequisites:

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

 

Audience:

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!