Microsoft Excel 2007 Basic - Intermediate

Course Code :

EXC 261

Duration

2 Days

The program is designed to give office workers a basic understanding on the working of Microsoft Excel, its benefits and applications. The program will equip participants with basic skills require in utilizing Excel spreadsheets in day to day business environments. Hands-on exercises related to actual business applications will help participants concepts & features covered.

Prerequisites

Working knowledge of the Microsoft Windows 2000 or XP interface such as configuring the desktop, using Control Panel, moving and sizing windows, and switching between tasks

Module 1 :

Getting Started with Excel

Starting Excel

Viewing the Excel Windows

Using the Ribbon (New)

Choosing Command (New)

Working with Toolbard (New)

Choosing Dialog Box Options (New)

Using the Status Bar (New)

Creating a Blank Workbook

Creating a Workbook Using a Template (New)

Opening an Existing Workbook (New)

Converting an Existing Workbook (New)

Using Task and Windows Panes (New)

Moving Around the Workbook

Arranging Windows

Getting Help While You Work

Saving a Workbook (New)

Saving a Workbook with Different Formats (New)

Checking Compatibilty (New)

Documenting Workbook Properties (New)

Switching Views (New)

Getting Excel Updates in the Web

Recovering a Workbook

Diagnosing and Repairing Problems

Closing a Workbook and Quiting Excel

Module 2 :

Basic Workbook Skills

Making Label Entries

Selecting Cells

Selecting Rows, Columns, and Special Ranges

Entering Labels on a Worksheet

Entering Value on a Worksheet

Entering Values Quickly with AutoFill

Editing Cell Content

Clearing Cell Content

Understanding How Excel Pastes Data

Storing Cell Contents

Copying Cell Contents

Moving Cell Contents

Inserting and Deleting Cell Contents

Correcting Cell Contents with AutoCorrect

Inserting Information the Smart Way

Checking Spelling (New)

Changing Proofing Options (New)

Using Custom Dictionaries (New)

Finding the Right Words

Inserting Research Material

Translating Text to Another Language

Using the English Assistant (New)

Undoing and Redoing an Action

Module 3 :

Working with Formula and Functions

Understanding Formulas

Creating a Simple Formula (New)

Creating a Formula Using Formula AutoComplete

Editing a Formula

Understanding Cell Referencing

Using Absolute Cell References

Using Mixed Cell References

Using 3-D Cell References

Naming cells and Ranges (New)

Entering Names Cells and Ranges (New)

Managing Names (New)

Simplying a Formula with Ranges

Displaying Calculations with the Status Bar

Calculating Totals with AutoSum

Performing One Time Calculations

Converting Formulas and Values

Correcting Calculation Errors

Correcting Formulas

Auditing a Worksheet

Locating Circular References

Performing Calculation Using Functions

Creating Functions

Creating Functions Using the Library

Calculating Multiple Results

Using Nested Functions (New)

Using Constants and Functions in Names

Module 4 :

Modifying Worksheet and Workbooks

Selecting and Naming a Worksheet

Inserting and Deleting a Worksheet

Moving and Copying a Worksheet

Hidung and Unhiding Worksheet and Workbooks

Selecting a Column or Row

Hiding and Unhiding a Column or Row

Inserting a Columns or Row

Deleting a Column and Row

Adjusting Column Width and Row Height

Freezing and Unfreezing a Column or Row

Splitting a Worksheet into Panes (New)

Showing and Hiding Workbook Elements (New)

Zooming the View In and Out

Creating Custom Views

Saving a Workspace Layout

Creating a Template

Opening a Template

Changing a Template

Module 5 :

Formatting a Worksheet

Formatting Numbers

Formatting Text (New)

Applying Condional Formatting (New)

Applying Specialized Conditional Formatting (New)

Creating Conditional Formatting (New)

Clearing Conditional Formatting (New)

Managing Conditional Formatting (New)

Finding Condiotional Formatting

Changing Data Aligment

Controlling Text Flow

Changing Data Color

Adding Color and Patterns to Cells

Adding Custom Colors (New)

Adding Borders to cells (New)

Formatting Tabs and Background

Copying Cell Formatting

Understanding Color Themes (New)

Creating Theme Color (New)

Choosing Theme Fonts (New)

Choosing Theme Effect (New)

Creating a Custom Theme (New)

Choosing a Custom Theme (New)

Applying and Creating Cell Style (New)

Modifying a C ell Style (New)

Finding and Replacing Cell Formatting

Module 6 :

Viewing and Printing Worksheet and Workbooks

Setting Up the Page

Adjusting Page Margins (New)

Adding Headers and Footers (New)

Inserting Page Breaks

Customizing Worksheet Printing

Setting the Print Area

Previewing a Worksheet

Printing a Worksheet and Workbook

Creating a PDF Document (New)

Creating an XPS Document (New)

Module 7 :

Inserting and Modifying Graphics

Formatting a SmartArt Graphics (New)

Formatting a Shape in a SmartArt Graphics (New)

Creating an Organization Chart (New)

Modifying an Organization Chart (New)

Module 8 :

Drawing and Modifying Shapes

Drawing and Resizing Shapes

Inserting Multiple Shapes

Adding Text to a Shape

Drawing Lines and Arrows (New)

Creating and Editing Freeforms

Copying and Moving Objects

Adding a Quick Style to a Shape (New)

Adding a Quick Style to a Shape Text (New)

Applying Color Fills (New)

Applying Picture Fills

Applying Texture Fills

Applying Gradient Fills (New)

Applying Shape Effects (New)

Adding 3-D Effects to a Shape (New)

Adding 3-D Rotation Effects to a Shape (New)

Creating Shadow (New)

Aligning and Distributing Objects

Connecting Shape (New)

Selecting Objects Using the Selection Pane (New)

Changing Stacking Order

Rotating and Flipping a Shape

Grouping and Ungrouping Shapes

Adding a Shape to the Clip Organizer

Module 9 :

Creating and Modifying Chart

Formatting Chart Text (New)

Formattin Line and Bar Charts

Changing the Chart Backround

Enhancing a Chart

Editing Chart Data

Adding and Deleting a Data Series

Saving a Chart Template (New)

Managing Chart Templates

Attachment	Size
EXC 261 (Basic -Intermediate).doc	63 KB

Code:

EXC261

Duration:

Price:

1500000

Schedule:

Jan 10-11, Feb 14-15, Mar 7-8, Apr 2-3, May 2-3, Jun 31-1

Microsoft Excel 2007 Basic - Intermediate

What's New

The Wait for Visual Studio 2008 is Over!

The New Generation of Microsoft Certification

Microsoft Excel 2007 Basic - Intermediate