- Level 1
- Level 2
- Level 3
- Booking
Microsoft Excel 2007 Level 1
(1 day - £245, plus VAT)
Prerequisites
Computer literacy: the ability to use a mouse and keyboard; familiarity with common computer software; the ability to open and save files.
Course Goals
To familiarise delegates with the core features of Microsoft Excel 2007. At the end of the training, delegates will be able to create, manipulate and format worksheets and charts.
Course Outline
Excel Fundamentals
Examining the Excel 2007 Workspace
Exploring File Management Fundamentals
Importing and Exporting Files
Using the Online Help System
Recovering from Crashes
Worksheets
Moving Around Regions
Understanding Selection
Techniques for Entering Data
Managing Worksheets
Viewing Worksheets
Protecting Worksheets
Workbooks
Managing Multiple Workbooks
Opening Multiple Windows for the Same Workbook
Hiding and Protecting Workbooks
Editing Worksheets
Worksheet Editing Techniques
Copying, Cutting, and Pasting
Inserting and Deleting
Undoing Previous Actions
Editing Cell Contents
Finding and Replacing Stuff
Editing Multiple Worksheets
Worksheet Formatting Techniques
Formatting Fundamentals
Using Themes and Cell Styles
Formatting Conditionally
Formatting in Depth
Using Template Files to Store Formatting
Creating Graphics
Using the Shapes Tools
Creating WordArt
Creating SmartArt
Inserting Graphics
Formatting Graphics
Working with Graphic Objects
More Tricks with Graphic Objects
Printing and Presenting
Controlling the Appearance of Your Pages
Specifying What and Where to Print
Adjusting Page Breaks
Using Print Preview
Setting Printer Driver Options
Creating Portable Documents
Creating Formulas
Building Formulas
Formula Fundamentals
Formulas that don't Use Functions
Using Functions: A Preview
Working with Formulas
Using Functions
Using the Built-In Function Reference in Excel
Exploring the Syntax of Functions
Inserting Functions
SUM, COUNT, MAX, MIN AND AVG
Relative and Absolute Cell References
Basic Charting Techniques
Selecting Data for Your Chart
Choosing a Chart Type
Changing the Chart Type
Switching Rows and Columns
Choosing a Chart Layout
Choosing a Chart Style
Moving the Chart to a Separate Chart Sheet
Adding, Editing, and Removing a Chart Title
Adding, Editing, and Removing a Legend
Adding and Positioning Data Labels
Adding a Data Table
Adding Axis Titles
Displaying Gridlines
Adding Text Annotations
Changing the Font or Size of Chart Text
Microsoft Excel 2007 Level 2
(1 day - £245, plus VAT)
Prerequisites
Working knowledge of Excel, ability to create formulas and format data and cells. Familarity with the basics of creating Excel charts is also assumed.
Course Goals
To provide Excel users with a more in-depth knowledge of Excel formulas, functions, formatting and charts; to introduce them to the creation and manipulation of Excel tables.
Course Outline
Intermediate Excel Functions
Understanding Mathematical Functions
Understanding Text Functions
Understanding Logical Functions
Understanding Information Functions
Understanding Lookup and Reference Functions
Formatting and Calculating Date and Time
Understanding How Excel Records Dates and Times
Entering Dates and Times
Formatting Dates and Times
Calculating with Date and Time
Working with Date and Time Functions
Advanced Charting
Selecting Chart Elements
Repositioning Chart Elements with the Mouse
Formatting Lines and Borders
Formatting Areas
Formatting Text
Working with Axes
Working with Data Labels
Formatting Data Series and Markers
Modifying the Data Source for Your Chart
Using Multilevel Categories
Adding Moving Averages and Other Trendlines
Adding Error Bars
Adding High-Low Lines and Up and Down Bars
Saving Templates to Make Chart Formats Reusable
Managing Information in Tables
How to Organize a Table
Creating a Table
Adding Totals to a Table
Sorting Tables and Other Ranges
Filtering a List or Table
Using Formulas with Tables
Formatting Tables
Linking and Embedding
Embedding vs. Linking
Embedding vs. Static Pasting
Embedding and Linking from the Clipboard
Embedding and Linking with the Object Command
Managing Links
Linking vs. Hyperlinking
Using Hyperlinks
Creating a Hyperlink in a Cell
Assigning a Hyperlink to a Shape, Image, or Chart
Selecting a Cell or Object Without Triggering the Hyperlink
Using Formulas to Create Hyperlinks
Back to top
Microsoft Excel 2007 Level 3
(1 day - £245, plus VAT)
Prerequisites
A good knowledge of all of Excel's basic and intermediate features and shortcuts.
Course Goals
To offer experienced Excel veterans a challenging look at some of the program's most advanced features.
Course Outline
Functions for Financial Analysis
Calculating Investments
Calculating Depreciation
Analyzing Securities
Using the Euro Currency Tools Add-In
Functions for Analyzing Statistics
Analyzing Distributions of Data
Understanding Linear and Exponential Regression
Using the Analysis Toolpak Data Analysis Tools
Working with External Data
Using and Reusing Data Connections
Opening an Entire Access Table in Excel
Working with Data in Text Files
Working with XML Files
Using Microsoft Query to Import Data
Using a Web Query to Return Internet Data
Performing Data Analysis
Using Arrays
Linking Workbooks
Auditing and Documenting Worksheets
Outlining Worksheets
Consolidating Worksheets
Performing What-If Analysis
Using Data Tables
Using the Scenario Manager
Using the Goal Seek Command
Using the Solver
Analyzing Data with PivotTable Reports
Introducing PivotTables
Creating a PivotTable
Rearranging PivotTable Fields
Refreshing a PivotTable
Changing the Numeric Format of PivotTable Data
Choosing Report Layout Options
Formatting a PivotTable
Displaying Totals and Subtotals
Sorting PivotTable Fields
Filtering PivotTable Fields
Changing PivotTable Calculations
Grouping and Ungrouping Data
Displaying the Details Behind a Data Value
Creating PivotCharts
Collaborating
Collaborating on a Network or by E-Mail
Saving and Retrieving Files on Remote Computers
Sharing Workbooks on a Network
Combining Changes Made to Multiple Workbooks
Security and Privacy
The Trust Center
File Security
Other Security Features
Back to top
Book a Microsoft Excel 2007 Course