EXCEL_07: Microsoft Office Specialist (MOS 2007)

SEARCH NETCAMPUS

Products

Job Roles

Technologies

Certifications

Help Me Decide Wizard

Microsoft Office Specialist (MOS 2007) - Excel 2007

Type: Course
Vendor: Microsoft
Code: EXCEL_07

<< Back

Add To Cart

Check My Skills

Price: 1295.00 ZAR

On this page:

Overview
Course Outline
People who purchased this product also purchased

Overview

The smart way to learn Office Excel 2007! Master the fundamentals of working with the latest version of Excel, including how to navigate the new user interface. You’ll learn how to create a wide-variety of documents, how to present information visually with charts, and how to add graphics to your spreadsheets. You will discover how to work with features to make data entry faster, how sort and filter data, how to create dynamic lists with Pivot Tables, and even how to publish your documents to the Web—plus more!

Course Outline

Chapter 01 - What is New in Excel 2007?
Estimated Study Time: 1 hour(s) and 45 minute(s)

Becoming Familiar with the New User Interface
Managing Larger Data Collections
Using the New Microsoft Office File Format
Formatting Cells and Worksheets
Managing Data Tables More Effectively
Creating Formulas More Easily by Using Formula AutoComplete
Summarizing Data Using New Functions
Creating Powerful Conditional Formats
Creating More Attractive Charts
Controlling Printouts More Carefully
Key Points

Chapter 02 - Setting Up a Workbook
Estimated Study Time: 2 hour(s) and 5 minute(s)

Creating Workbooks
Modifying Workbooks
Modifying Worksheets
Customizing the Excel 2007 Program Window
Key Points

Chapter 03 -Working with Data and Data Tables
Estimated Study Time: 1 hour(s) and 45 minute(s)

Entering and Revising Data
Moving Data within a Workbook
Finding and Replacing Data
Correcting and Expanding Upon Worksheet Data
Defining a Table
Key Points

Chapter 04 -Performing Calculations on Data
Estimated Study Time: 2 hour(s) and 5 minute(s)

Naming Groups of Data
Creating Formulas to Calculate Values
Summarizing Data That Meets Specific Conditions
Finding and Correcting Errors in Calculations
Key Points

Chapter 05 -Changing Document Appearance
Estimated Study Time: 2 hour(s) and 5 minute(s)

Formatting Cells
Defining Styles
Applying Workbook Themes and Table Styles
Making Numbers Easier to Read
Changing the Appearance of Data Based on Its Value
Adding Images to a Document
Key Points

Chapter 06 -- Focusing on Specific Data Using Filters
Estimated Study Time: 1 hour(s) and 50 minute(s)

Limiting Data That Appears on Your Screen
Manipulating List Data
Defining Valid Sets of Values for Ranges of Cells
Key Points

Chapter 07 -- Reordering and Summarizing Data
Estimated Study Time: 1 hour(s) and 50 minute(s)

Sorting Data Lists
Organizing Data into Levels
Looking Up Information in a Data List
Key Points

Chapter 08 - Combining Data from Multiple Sources
Estimated Study Time: 2 hour(s) and 5 minute(s)

Using Data Lists as Templates for Other Lists
Linking to Data in Other Worksheets and Workbooks
Consolidating Multiple Sets of Data into a Single Workbook
Grouping Multiple Sets of Data
Key Points

Chapter 09 - Analyzing Alternative Data Sets
Estimated Study Time: 1 hour(s) and 45 minute(s)

Defining and Editing Alternative Data Sets
Defining Multiple Alternative Data Sets
Varying Your Data to Get a Desired Result Using Goal Seek
Finding Optimal Solutions with Solver
Analyzing Data with Descriptive Statistics
Key Points

Chapter 10 - Creating Dynamic Lists with PivotTables
Estimated Study Time: 1 hour(s) and 45 minute(s)

Analyzing Data Dynamically with PivotTables
Filtering, Showing, and Hiding PivotTable Data
Editing PivotTables
Formatting PivotTables
Creating PivotTables from External Data
Key Points

Chapter 11 - Creating Charts and Graphics
Estimated Study Time: 1 hour(s) and 45 minute(s)

Creating Charts
Customizing the Appearance of Charts
Finding Trends in Your Data
Creating Dynamic Charts Using Pivot Charts
Creating Diagrams by Using Smart Art
Key Points

Chapter 12 - Printing
Estimated Study Time: 1 hour(s) and 45 minute(s)

Adding Headers and Footers to Printed Pages
Preparing Worksheets for Printing
Printing Data Lists
Printing Parts of Data Lists
Printing Charts
Key Points

Chapter 13 - Automating Repetitive Tasks with Macros
Estimated Study Time: 2 hour(s) and 5 minute(s)

Introducing Macros
Creating and Modifying Macros
Running Macros When a Button Is Clicked
Running Macros When a Workbook Is Opened
Key Points

Chapter 14 - Working with Other Microsoft Office System Programs
Estimated Study Time: 2 hour(s) and 5 minute(s)

Including Microsoft Office System Documents in Excel 2007 Worksheets
Storing Excel 2007 Documents as Parts of Other Microsoft Office System Documents
Creating Hyperlinks
Pasting Charts into Other Documents
Key Points

Chapter 15 - Collaborating with Colleagues
Estimated Study Time: 2 hour(s) and 5 minute(s)

Sharing Data Lists
Managing Comments
Tracking and Managing Colleagues' Changes
Protecting Workbooks and Worksheets
Authenticating Workbooks
Saving Workbooks for the Web
Key Points

- Chapter 01 - What is New in Excel 2007?
- Chapter 02 - Setting Up a Workbook
- Chapter 03 -Working with Data and Data Tables
- Chapter 04 -Performing Calculations on Data
- Chapter 05 -Changing Document Appearance
- Chapter 06 -- Focusing on Specific Data Using Filters
- Chapter 07 -- Reordering and Summarizing Data
- Chapter 08 - Combining Data from Multiple Sources
- Chapter 09 - Analyzing Alternative Data Sets
- Chapter 10 - Creating Dynamic Lists with PivotTables
- Chapter 11 - Creating Charts and Graphics
- Chapter 12 - Printing
- Chapter 13 - Automating Repetitive Tasks with Macros
- Chapter 14 - Working with Other Microsoft Office System Programs
- Chapter 15 - Collaborating with Colleagues

(detailed outline...)

People who purchased this product also purchased

- WORD_07: Microsoft Office Specialist (MOS 2007) - Word 2007
- OUTLOOK_07: Microsoft Office Specialist (MOS 2007) - Outlook 2007
- ACCESS_07: Microsoft Office Specialist (MOS 2007) - Access 2007
- CBP_BUS_ETQ_E: Certified Business Professional - Business Etiquette and Professionalism Series
- PPOINT_07_E: Microsoft Office Specialist (MOS 2007) - PowerPoint 2007