12014930

8/4/2019 12014930

1/7

Course: Microsoft Excel 2007 (Complete)

Course designed to teach you how to use Microsoft Excel 2007 spreadsheets, explaining all the application functions and learning how to use the

program to create and modify spreadsheets, both simple and complex.

Lessons Theoretical hours Practice hours Total hours

30 36 30 66

This course contains a handbook in digital format.

This course is only available for LMSs compatible with SCORM or AICC.

CONTENTS

Module 1: Microsoft Excel 2007 Basic

Introduction to Microsoft Office 2007 suite describes the different programs that comprise it, as well as looks at the common

elements and characteristics of the programs in this suite: the programs' environments, how to open and save documents,

templates, the help system, document properties and the Office clipboard.

Lesson 1: Introduction to Excel 2007

Introduction to Microsoft Office 2007 office automation suite and the different programs that comprise it. The

environment or Office user interface is presented.

Chapter 1: How Excel is used

Chapter 2: Main parts of the program

Chapter 3: Other elements in the environment

Chapter 4: The first book

Chapter 5: Exiting Excel

Chapter 6: Practical exercises

Lesson 2: Workbooks and worksheets

Basic work with Office 2007 suite documents is described. Look at how to create new documents, open existing

documents and save them. The template concept is introduced, as well as working with documents from previous

Office versions.

Chapter 1: Workbooks and worksheets in Excel

Chapter 2: Navigating worksheets

Chapter 3: Create and delete sheets

Chapter 4: Move and copy sheets

Chapter 5: Saving books


Lesson 3: Entering data (I)

The use of the Office 2007 suite help system in order to obtain information about its programs is described. Other

common elements are also described, including the use of clip art in documents and the clip organizer.

Chapter 1: Data in Excel

Chapter 2: Ways of entering data

Chapter 3: Entering numbers and text

Chapter 4: Entering Dates

Chapter 5: Inserting symbols


Lesson 4: Entering data (II)

2009 Computer Aided Education, S.A. Page 1/7

8/4/2019 12014930

2/7


Description of other common elements in the Office 2007 suite programs: adding properties to documents in order

to identify them, document search with the dialogue box, opening and using the clipboard (both Windows and

Office) in order to copy, cut and paste elements.

Chapter 1: Filling a group of cells with data

Chapter 2: Creating series

Chapter 3: Creating trends

Chapter 4: Check spelling


Lesson 5: Modifying sheets

Description of the basic functions of a Microsoft Excel 2007 spreadsheet, learning the features available in the

program to create and modify simple spreadsheets. This module explains how to create books and spreadsheets,

viewing and entering data in sheets, basic formatting and printing.

Chapter 1: Editing cells

Chapter 2: Cut, copy and paste

Chapter 3: Cutting and copying with the mouse

Chapter 4: Inserting and deleting cells

Chapter 5: Find and replace

Chapter 6: Practical Exercises

Lesson 6: Organizing and printing sheets

Introduction to Excel, the spreadsheet editing and creation program, describing how to launch and close the

program, and the basic environment: windows, the Ribbon and other elements.

Chapter 1: Windows

Chapter 2: Page Layout

Chapter 3: Page breaks

Chapter 4: Printing


Lesson 7: Cell formatting

Description and use of the documents used in Excel spreadsheets, called workbooks. Working with sheets:

navigating through them, inserting, modifying, deleting, copying ... You also learn how to save your Excel

documents.

Chapter 1: What is the cell format

Chapter 2: Width and height of cells

Chapter 3: Data alignment

Chapter 4: Text font

Chapter 5: Borders and backgrounds


Module 2: Microsoft Excel 2007 Advanced

Describes how to enter data (numbers, text, dates, symbols ...) in an Excel spreadsheet, explaining the different types of data and

introducing the concept of a formula.

Lesson 8: Formulas

Learn the various techniques and features that can be useful in automatically filling data into cells: building series

and trends, filling adjacent cells correctly. Also learn how to check the spelling and grammar in Excel documents.


8/4/2019 12014930

3/7


Chapter 1: What are formulas

Chapter 2: References to cells

Chapter 3: References to other sheets

Chapter 4: Moving and copying formulas

Chapter 5: Names in formulas


Lesson 9: Functions

This lesson explains how to modify the data entered into spreadsheet cells: editing data, cut, copy and paste, insert

and remove cells. Also describes the process of search and replace in Excel and how to undo and redo actions.

Chapter 1: What are functions

Chapter 2: Automatic sum

Chapter 3: Insert a function

Chapter 4: Inserting references

Chapter 5: Nested functions


Lesson 10: Advanced cell formatting

How to organize windows in Excel to show several documents, several sheets of the same document or several parts

of a sheet in a document. Also describes how to print Excel spreadsheets, learning about all the available options

and the configurations that can be applied.

Chapter 1: Number formats

Chapter 2: Personalized formats

Chapter 3: Cell styles

Chapter 4: Search by format


Lesson 11: Themes and conditional formatting

Learn about several basic options for formatting cells in an Excel spreadsheet: introduction to cell formatting,

height, width, border and backgrounds, font used and text alignment in the cell.

Chapter 1: Working with themes

Chapter 2: Applying conditional formats

Chapter 3: Advanced conditional formatting

Chapter 4: Inserting drawings and pictures


Lesson 12: More on editing sheets

A description of the advanced features in Microsoft Excel 2007 spreadsheets, viewing and using formulas, functions

and charts. Also describes the advanced aspects relating to editing sheets and formatting cells. Learn about using

Excel to create web pages to display spreadsheet data.

Chapter 1: Special paste

Chapter 2: Organizing with panes

Chapter 3: Hiding rows, columns and sheets

Chapter 4: Comparing books


Lesson 13: Creating charts

Using formulas in Excel spreadsheets: how to write them, operators, referencing cells in the same sheet and other


8/4/2019 12014930

4/7


sheets, relative, absolute and mixed references, and how to copy and paste formulas that contain references.

Finally, describes the use of cell names or cell ranges in formulas.

Chapter 1: Introduction

Chapter 2: Creating a chart

Chapter 3: Changing the appearance

Chapter 4: Chart elements

Chapter 5: Formatting elements

Chapter 6: Adding data


Lesson 14: Uploading data to the Web

Description and use of existing functions in Excel spreadsheets: introduction to functions, Excel suggested

functions, nested functions, inserting references in functions...

Chapter 1: Inserting hyperlinks

Chapter 2: Navigating with links

Chapter 3: Saving as a web page

Chapter 4: Other file formats


Module 3: Microsoft Excel 2007 Expert

Describes several advanced options regarding cell formatting in Excel spreadsheets: number formats, personalized formats and

applying a style to a cell.

Lesson 15: Arrays and external references

Describes the use of themes and conditional formatting to customize cells in Excel spreadsheets. Also explains how

to insert shapes and pictures in Excel sheets.

Chapter 1: Array formulas

Chapter 2: Array constant

Chapter 3: External references (links)

Chapter 4: Working with external references

Lesson 16: Lists

Explains advanced editing options in Excel spreadsheets: paste special, hide rows, columns or sheets and sheets in

organized in panes. Also describes how to compare books in parallel.

Chapter 1: Basic concepts

Chapter 2: AutoComplete

Chapter 3: Forms

Chapter 4: Sorting lists

Chapter 5: Data validation

Chapter 6: Extending formats and formulas

Lesson 17: Filters and tables

Creating and modifying charts in an Excel spreadsheet, by using the data it contains.

Chapter 1: Filtering data

Chapter 2: Advanced filter

Chapter 3: Copying filtered data

Chapter 4: Working with filtered lists


8/4/2019 12014930

5/7


Chapter 5: Working with tables

Lesson 18: Subtotals

Describes how to insert hyperlinks in Excel spreadsheets to navigate between them. In addition, all the options

available in Excel to upload books or spreadsheets to the web and export to other file formats.

Chapter 1: Automatic subtotals

Chapter 2: Subtotal organization

Chapter 3: Charts with subtotals

Chapter 4: Advanced totals

Lesson 19: Working with formulas

Description of the more advanced features in Microsoft Excel 2007. Explains how lists work, and the various

operations that can be performed on them (filters, management, data validation, subtotals...), working with

formulas, links and matrices, advanced chart concepts, accessing external data, dynamic tables and charts, data

analysis, templates and collaborating with other users.

Chapter 1: Errors in formulas

Chapter 2: Formula auditing

Chapter 3: Inserting comments

Chapter 4: Calculation controls

Chapter 5: Search functions

Lesson 20: Advanced chart topics

Working with matrices in formulas (which return several values at the same time) in an Excel spreadsheet, studying

the use of constant matrices in formulas. Also describes working with external references (or link) between Excel

workbooks.

Chapter 1: 3-D charts and chart templates

Chapter 2: Chart elements

Chapter 3: Data in a secondary axis

Chapter 4: Using pictures in charts

Chapter 5: Printing charts

Lesson 21: Accessing external data (I)

Creation and use of lists in an Excel spreadsheet, seeing how we can use a form to view data from them, and how

you can sort the data and validate the information entered into the cells.

Chapter 1: Accessing text files

Chapter 2: Access databases

Chapter 3: Updating data

Chapter 4: Accessing data on the Web

Lesson 22: Accessing external data (II)

What they are and how filters are applied to lists in Excel spreadsheets: filter data to extract only specific

information, automatic and advanced filters, and working with filtered data. Also describes how to designate ranges

of cells as tables.

Chapter 1: Accessing databases

Chapter 2: Create a data source

Chapter 3: Creating a query

Chapter 4: Working with Microsoft Query


8/4/2019 12014930

6/7


Chapter 5: Queries with parameters

Lesson 23: PivotTables and PivotCharts

Overview of creating subtotals obtained from the data in a list in Excel, in order to perform partial and general

calculations. Also shows how you can create charts using subtotals and the use of various functions to calculate

totals and subtotals.

Chapter 1: Creating PivotTables

Chapter 2: Working with PivotTables

Chapter 3: Updating and PivotCharts

Chapter 4: Consolidating data

Lesson 24: Data analysis and macros

Describes how to work with formulas in Excel, the various tools that facilitate this process (formulas errors, the

watch window used to evaluate formulas, watching formulas, cells precedents and dependents, comments...). Also

examines the process of calculating the values of cells (manual and automatic calculation and various options

along that line) and the use of several search functions.

Chapter 1: Goal seek

Chapter 2: Data tables

Chapter 3: Scenarios

Chapter 4: Solver

Chapter 5: Macros

Lesson 25: Templates and Views

Creating complex charts in an Excel spreadsheet, using existing data: type and format of the chart and its elements,

how to add pictures, edit and print the chart.

Chapter 1: What are templates?

Chapter 2: Creating templates

Chapter 3: Custom views

Chapter 4: Zoom and other views

Chapter 5: Book properties

Chapter 6: Digital signatures

Lesson 26: Working with other users

Working with external data in an Excel book, including data created with various other applications (databases,

etc.). Learn how to access data from text files, Access databases or Internet sites.

Chapter 1: Restricting file access

Chapter 2: Creating a shared workbook

Chapter 3: Working in a shared book

Chapter 4: The change history

Chapter 5: Sending and combining books

Module 4: Microsoft Excel 2007 Professional

Working with external data in an Excel book, from files and databases using Microsoft Query. Shows the steps to create the link

between the database and Excel, learning how to create queries to obtain the data in Excel that you want from these external files,

using the assistant to create queries or working directly with Microsoft Query (in this case, even providing queries with

parameters).

Lesson 27: XML and Excel


8/4/2019 12014930

7/7


Creating and working with pivottables and pivotcharts in Excel spreadsheets, using abstract functions to display

data. Also describes how to consolidate data from several sheets.

Chapter 1: What is XML

Chapter 2: XML Maps

Chapter 3: Importing XML data

Chapter 4: Opening XML documents

Lesson 28: Forms

Description of several utilities which Excel provides that can help when interpreting and analyzing data from a

book: searching for the formula objective, using a data table to calculate different results in an operation, scenarios

(to obtain results based on changing data cells) and the Solver tool to solve problems. Finally we introducing Excel

macros and their use.

Chapter 1: Form elements

Chapter 2: Selecting options

Chapter 3: Other controls

Chapter 4: Working with forms

Lesson 29: Using common functions (I)

Explains the use and creation of new templates in Excel, used in creating new books or spreadsheets. Also explains

how you can store different views of the same book, the properties of an Excel document and introduces the concept

of digital signatures.

Chapter 1: Several ways to do the same thing

Chapter 2: Counting blank cells

Chapter 3: Consolidating with 3D references

Chapter 4: Nesting IF functions

Lesson 30: Using common functions (II)

Explains how you can protect Excel books and sheets, so that users can only modify the data indicated, and how to

create and work in shared books, which can be modified by multiple users simultaneously. It also describes the

process of sending a book for other people to review and how to combine books.

Chapter 1: Calculating totals with formulas

Chapter 2: Totals with criteria

Chapter 3: Conditions

Chapter 4: Searching for records


12014930

Documents