Course Info

MX2007-1 - Microsoft Excel 2007: Introduction

Categories Applications Training, Microsoft Excel Training, Microsoft Office Training, MOUS Certification Training

Duration 1 day (7 hours)

Pre-requisites
MX2003-1 - Microsoft Excel 2003 Introduction or equivalent experience.
Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Courseware MX20071-EK (240 pages)

Price $195

Notes

This series course teaches the basic functions and features of Excel 2007. After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Excel 2007 exam (77-602). For comprehensive certification training, students should complete Excel 2007: Basic, Intermediate, and Advanced.

Creating a Basic Worksheet
      Explore the User Interface and the Ribbon
      Navigate and Select in Excel
      Obtain Help
      Enter Data and Save a Workbook
      Customize the Quick Access Toolbar
Performing Calculations
      Create Basic Formulas
      Calculate with Functions
      Copy Formulas and Functions
Modifying a Worksheet
      Manipulate Data
      Insert and Delete Cells, Columns, and Rows
      Search for Data in a Worksheet
      Spell Check a Worksheet
Formatting a Worksheet
      Modify Fonts
      Add Borders and Color to Cells
      Change Column Width and Row Height
      Apply Number Formats
      Position Cell Contents
      Apply Cell Styles
Printing Workbook Contents
      Print Workbook Contents Using Default Print Options
      Set Print Options
      Set Page Breaks
Managing Large Workbooks
      Format Worksheet Tabs
      Manage Worksheets in a Workbook
      Manage the View of Large Worksheets