Microsoft Excel 2007 Foundation

Upon Completion of this course the students will be able to: Understand what Excel is used for; Use the 'Help' function; Use the toolbar; Manage files; Use Features, Tools; Modify data; Use Smart Tags; Modify, format and enhance worksheets and much more

Course Outline

Upon Completion of this course the students will be able to:

• Understand what Excel is used for
• Use the ‘Help’ function
• Use the toolbar
• Manage files
• Use Features, Tools
• Modify data
• Use Smart Tags
• Modify, format and enhance worksheets
• Manage charts and data
• Manage workbooks

Course Outline

Getting Started Starting Out What is Microsoft Excel 2007? Opening Microsoft Excel Interacting with Excel Closing Excel Step-By-Step About Workbooks Creating a New Workbook Opening a Workbook Saving a Workbook About Excel File Types Closing a Workbook Step-By-Step Skill Sharpener Exploring your Workbook Using Worksheets The Active Cell Selecting Cells Exploring a Worksheet The Zoom Feature Step-By-Step Skill Sharpener Getting Help in Excel 2007 Using the Help Screen About Online Help About Offline Help Step-By-Step Skill Sharpener Case Study Review Questions The New Interface The Quick Access Toolbar The Default Buttons Adding Buttons Removing Buttons Customizing the Toolbar Step-By-Step Skill Sharpener The Home Ribbon Clipboard Font Alignment Number Style Cells Editing Step-By-Step Skill Sharpener The Insert Ribbon Tables Charts Illustrations Shapes Links Text Step-By-Step Skill Sharpener The Page Layout Ribbon Themes Page Setup Scale to Fit Sheet Options Arrange Step-By-Step Skill Sharpener The Formulas Ribbon The Function Library Defined Names Formula Auditing Calculation Step-By-Step Skill Sharpener The Data Ribbon Get External Data Connections Sort and Filter Data Tools Outline Step-By-Step Skill Sharpener The Review Ribbon Proofing Comments Changes Step-By-Step Skill Sharpener Case Study Review Questions Excel Basics Working With Excel 2007 Columns, Rows, Cells, and Ranges Creating Worksheet Labels Entering and Deleting Data Printing Your Worksheet Step-By-Step Skill Sharpener Basic Excel Features What is AutoFill? What is AutoSum? What is AutoComplete? Working with Basic Formulas Step-By-Step Skill Sharpener

Moving your Data Dragging and Dropping Cells How to Cut, Copy, and Paste Cells How to Cut, Copy, and Paste Multiple Cells and Items How to Use Paste Special How to Insert and Delete Cells, Rows, and Columns Using Undo, Redo, and Repeat Step-By-Step Skill Sharpener Smart Tags and Options Buttons What Are Smart Tags? The Error Option Button The AutoFill Option Button The Paste Option Button Setting Smart Tag Options Step-By-Step Skill Sharpener Editing Tools Using AutoCorrect Using Spell Check Using Find and Replace Adding Comments Step-By-Step Skill Sharpener Case Study Review Questions Editing Your Workbook Modifying Cells and Data Changing the Size of Rows or Columns Adjusting Cell Alignment Rotating Text Creating Custom Number and Date Formats Step-By-Step Skill Sharpener Cell Formatting Conditional Formatting The Format Painter Cell Merging and AutoFit Find and Replace Formatting Step-By-Step Skill Sharpener Enhancing a Worksheet’s Appearance Adding Patterns and Colors Adding Borders Working with Styles Step-By-Step Skill Sharpener Working With Charts Creating a Chart Formatting a Chart Modifying Charts with the Layout Ribbon Manipulating a Chart Enhancing a Chart with Shapes and Graphics Step-By-Step Skill Sharpener Working with Charts, Part 2 Changing the Type of Chart Changing the Source Data Working with the Chart Axis and Data Series Saving a Chart as a Template Step-By-Step Skill Sharpener Case Study Review Questions Printing and Viewing your Workbook Using the View Ribbon Using Normal View Using Full Screen View Using Page Layout View Page Break Preview Step-By-Step Skill Sharpener Managing a Single Window Creating a New Window Hiding a Window Unhiding a Window Freezing a Pane Step-By-Step Skill Sharpener Managing Multiple Windows Switching Between Open Workbooks Arranging Workbooks Comparing Workbooks Side by Side Synchronous Scrolling, Resetting a Window, and Saving a Workspace Step-By-Step Skill Sharpener Printing your Workbook Opening Print Preview Using the Print Preview Ribbon Quick Printing The Print Dialogue Using Page Setup Step-By-Step Skill Sharpener Case Study Review Questions

Additional Details

Pre-Requisites

None

Certificates offered

Certificate of Completion

Cancellation Policy

Cancellations less than 2 business weeks before the expected delivery date are eligible for a 50% refund, or a credit voucher will be provided for regularly scheduled courses (choice being that of the registrant). Credit Vouchers are transferable within the same company. Please send your cancellation notice to info@itplanit.com.

Map & Reviews

Itplanit Services Corp.
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

A very interesting course. Claude Gerin, our instructor, was excellent in making this a very interesting and learning experience. THANKS!

Reviewed by Oleg T. 2012