Excel software is used to analyze data using a variety of features. The hands-on Microsoft® Office Excel 2007 training includes the basic topics related to using Excel worksheets and workbooks. The students will learn to create, modify and format common business reports such as budgets, inventory reports, invoices, and charts. This course is designed for students who desire the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets and manage and audit numerical reports.

Topics

• What is an Electronic Spreadsheet?
• Looking at the Excel Screen
• Ribbon User Interface
• Creating a New Blank Workbook
• Entering Data in a Worksheet
• Selecting Cells
• Copying and Moving Data
• Adjusting the Columns and Rows
• Inserting and Deleting Rows and Columns
• Managing Worksheets
• Renaming Worksheets
• Inserting or Deleting Worksheets
• Moving or Copying Worksheets
• Creating and Editing Simple Formulas
• Using Common Functions with Cell Ranges
• Displaying and Printing Formulas
• Formatting a Cell
• Clearing Cell Contents and Formatting
• Formatting Worksheets
• Changing the Views
• Print Previewing Worksheets
• Adding and Previewing Page Breaks
• Customizing the Printout
• Printing the Worksheet
• Creating a Basic Chart
• Changing Chart Types
• Working with Pie Charts
• Changing the Chart Layout
• Moving and Resizing Charts
• Printing Charts

Audience
Anyone with basic computer skills, including, but not limited to:

After completing this course, you will be able to:

• understand how Microsoft Office Excel handles numerical information for analysis or tracking purposes
• identify and work with the screen, Screen Tips, the Ribbon, and the Quick Access toolbar
• create, edit, save, open, and close workbooks
• select cells for further action such as formatting, deleting, copying and pasting
• change the view mode for specific types of editing tasks
• create and edit simple and more complex formulas
• apply text and numeric formatting options
• control the data flow using appropriate page breaks
• set headers and footers for a worksheet
• change margins, orientation, or layout for printing a worksheet
• preview and print worksheets or workbook

For more information,

call 714-505-3475