Microsoft Excel 2007 Intermediate
Aims for this course
Upon completion of the course the attendees will have built on the skills and concepts taught in Excel 2007 Module 1. Delegates will learn how to use multiple worksheets and workbooks efficiently, and they'll start working with more advanced formatting options including styles, themes, backgrounds, and watermarks. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables. Delegates will save workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file. This course also covers advanced charting techniques, worksheet auditing and protection, file sharing and merging, and workbook templates.
Course Agenda
Advanced File Tasks
Using
My Computer within Excel
Using
the My Places Toolbar
Navigating with My Computer
Performing Basic Tasks with My Computer
Changing Views
Saving
your Files
File
Formats
File Properties
AutoRecover
Upgrading a Workbook
Step-By-Step
Skill Sharpener
Using
Templates
Opening
a Template
Downloading a Template
Using a Template
Creating a Template
Working with Functions and Formulas
Using
Formulas in Excel
Understanding
Relative and Absolute Cell References
Basic Mathematical Operators
Using Formulas with Multiple Cell References
The Formula Auditing Buttons
Fixing Formula Errors
Displaying and Printing Formulas
Exploring
Excel Functions
What
are Functions?
Finding the Right Function
Some Useful and Simple Functions
Using
Functions in Excel
Inserting
Functions
Using Functions and AutoFill to Perform Difficult Calculations
Using the IF Function
Working with Nested Functions
Working
with Names and Ranges
What
Are Range Names?
Defining and Using Range Names
Selecting Nonadjacent Ranges
Using AutoCalculate
Working with Array Formulas
What
are Array Formulas?
Using Basic Array Formulas
Using Functions with Array Formulas
Using the IF function in Array Formulas
Managing Tables
Working
with Tables
What
is a Table?
Creating Tables
Modifying Tables
What is the Total Row?
Working
with Records and Fields
What
are Records and Fields?
Adding Fields by Inserting Columns
Adding Records by Inserting Rows
Quickly Adding Records to a Data Table
Deleting Records or Fields
Working
with Tables and Filters
Sorting
Data in a Table
What is an AutoFilter?
Custom AutoFilters
Using an Advanced Filter
Copying Filtered Records
Using
Excel as a Database
Filtering
with Wildcard Characters
Validating Your Data
What are Database Functions?
Enhancing your Workbook
Customizing
your Workbook
Inserting
a Symbol or Special Character
Adding and Editing Shapes
Creating and Altering Diagrams
Changing the Diagram Type
Incorporating Text
Adding a Signature Line
Working
with Text Boxes
Adding
a Text Box
Selecting a Text Box
Manipulating a Text Box
Formatting a Text Box
WordArt
Adding
WordArt to your Spreadsheet
Changing the Font Color
Changing the Outline Color
Adding Effects
ClipArt
Finding
ClipArt
Inserting ClipArt
Manipulating ClipArt
Inserting a Photographic Image
Using Objects
Creating
New Embedded Objects
Embedding Existing Files
Editing Embedded Objects
Embedding Parts of Files
Finalizing Your Workbook
Protecting
your Workbook
Protecting
your Workbook
Protecting your Worksheets
Unlocking Cells
Protecting your Excel Files
Step-By-Step
Finishing
Your Workbook
Using
the Document Inspector
Using the Compatibility Checker
Marking a Workbook as Final
Using Excel in Word
Inserting
Excel Data in Word
Linking Excel Data in a Word Document
Modifying Excel Data after Insertion
Insert an Excel Chart into a Word Document
Using
Excel and Access
Linking
an Excel Workbook to an Access Database
Importing Table, PivotTable, and PivotChart Data from Access
Transforming an Excel Workbook into an Access Database
Using
Excel With other Programs and Files
Using
Outlook to Send Excel Data
Opening an Excel File in a Different Format
Importing Data from a Text File
Importing Data from External Data Sources
Publishing a Workbook as a PDF File
Faxing a Workbook
Course Title
Microsoft Excel 2007 Intermediate
Cost per delegate
£145 +vat
Who is this course for?
Users with some experience in MS Excel 2007 or who have attended the MS Excel 2007 Foundation course
Related courses
> MS Excel 2007 Foundation
> MS Excel 2007 Advanced
> MS Excel 2007 Expert
When is this course running?
Click here to view the latest course schedule
