Microsoft Excel 2007 Courseware
Microsoft Excel 2007 Full Day Courseware Titles
Click a title to move down the page.
- Excel 2007 Level 1:
Beginner's Guide to Microsoft Excel - Excel 2007 Level 2:
Get More Out of Your Spreadsheets Using Microsoft Excel - Excel 2007 Level 3:
Advanced Analysis and Functionality of Microsoft Excel
Stand-alone 90-minute Microsoft Excel 2007 workshops/modules
Click a title to move down the page.
- Getting to Know the Microsoft Excel Environment
- Planning and Creating Spreadsheets in Microsoft Excel
- Worksheet Management & 3-D Formulas in Microsoft Excel
- Graphics and Printing in Microsoft Excel
- Creating and Using Microsoft Excel Templates
- Sorting and Filtering Data in Microsoft Excel
- Number Crunching with Formulas and Functions in Microsoft Excel
- Showcase Your Data Visually with Charts in Microsoft Excel
- Using the What If Analysis and Scenario Manager to Plan for the Future in Microsoft Excel
- Make Sense of Your Data with PivotTables and Pivot Charts in Microsoft Excel
- Reviewing and Sharing in Microsoft Excel
- Automating Repetitive Tasks with Microsoft Excel Macros
Microsoft Excel 2007 Level 1:
A Beginner's Guide to Microsoft Excel
Microsoft Excel 2007 Level 1: A Beginner's Guide to Microsoft Excel introduces spreadsheet concepts and functionality to the beginner.
Course Objectives:
- Explain the Excel interface
- Work with data in a worksheet
- Navigate in a worksheet
- Save and print data
- Plan and create a new workbook
- Create and modify formulas using mathematical operators
- Insert and delete columns and rows
- Understand order of operations
- Format a worksheet
- Cut/Copy/Paste
- Understand view and zoom options
- Use Freeze Panes
- Recognize relative vs. absolute formulas
- Use 3-D formulas
- Work with drawing tools
- Use different Print techniques
Cost: $19.95
Microsoft Excel 2007 Level 2:
Get More Out of Your Spreadsheets Using Microsoft Excel
Get More Out of Your Spreadsheets Using Microsoft Excel is a course for the intermediate Excel user. In this course we look at ways to analyze our data, explore more advanced formulas and turn our numbers into eye-catching charts.
Course Objectives:
- Work with templates
- Perform single and multi-level sorts
- Create automatic subtotals
- Use AutoFilter
- Apply conditional formatting
- Link multiple worksheets
- Work with chart
- Add a photograph as an element
- Create a template for charts based on the look you design
- Send an Excel chart to Word
Cost: $19.95
Microsoft Excel 2007 Level 3:
Advanced Analysis and Functionality of Microsoft Excel
Advanced Analysis and Functionality of Microsoft Excel adds greater flexibility and depth of analysis to our data. The tools in this course allow us to share our work with other users, create pivot tables to consolidate and group our data in helpful ways. Additionally, we’ll, perform “what-if” analysis of our data to evaluate data based on variables, and we’ll create macros to automate repetitive tasks.
Course Objectives:
- Create Scenarios
- Design Data Reports
- Create Summaries
- Work with Goal Seek
- Explore Pivot Table Components
- Create a Pivot Table from a Data Source
- Modify Pivot Table Formulas
- Move fields onto a Pivot Table
- Group Data based on Range Criteria
- Use Comments
- Work with Changes
- Protect an Individual Sheet
- Set Passwords/Restrict Access
- Name/Record a Macro
- Save/Recall a Macro
- Assign a Keyboard Shortcut to a Macro
- Create a New Macro Run a Macro
Cost: $19.95
Getting to Know the Microsoft Excel Environment
This workshop provides Excel 2007 novices with a working understanding of the Excel environment. Each area of the Excel window will be covered. In addition, you will learn to edit and save an Excel 2007 workbook at the end of this workshop.
Course Objectives
- Attain familiarity with the Excel 2007 interface
- Open an existing Excel spreadsheet
- Navigate an existing Excel spreadsheet
- Select cells in a spreadsheet
- Input new data into spreadsheet
- Edit data
- Use the AutoSum feature
- Save a spreadsheet
- Learn basic print features
Cost: $6.95
Planning and Creating Spreadsheets in Microsoft Excel
A great course for newcomers to Excel who have used spreadsheets created by other users but have not yet created many of their own. The lessons guide you through the steps of creating a spreadsheet, from planning through formatting.
Course Objectives
- Learn the four steps to the spreadsheet creation process
- Create and save a new sheet
- Create formulas from scratch
- Insert new columns and rows into a worksheet
- Delete single/multiple rows and columns
- Create more complex formulas using the mathematical principle of order of operations
- Format text and numbers
- Add borders
- Apply fill colors to backgrounds
- Learn to use Format Painter
Cost: $6.95
Worksheet Management & 3-D Formulas in Microsoft Excel
Worksheets provide a logical and intuitive way to organize your data. Frequently, multiple worksheets are used to further separate data into categories such as date or product type. The ability to work with data in multiple worksheets is a necessary skill for Excel users. This course covers working with multiple worksheets including the creation of formulas that reference information from several different worksheets. It also covers viewing and zoom options and the freeze panes function.
Course Objectives
- Know the difference between cutting and copying
- Change the zoom level
- Use the Page Layout and Page Break views
- Freeze rows or column headings to keep them in view
- Create formulas with relative cell references
- Create the average, minimum and maximum values of a cell range
- Use the Name Box to give cells descriptive names
- Create formulas with absolute references using named ranges and the F4 key
Cost: $6.95
Graphics and Printing in Microsoft Excel
Excel has long been the geek of the Microsoft Office family. In 2007 Excel got a graphic upgrade. However, Excel is still not a “what you see is what you get” program. This course examines how to insert and manage graphics in Excel and covers the printing techniques to achieve the desired look when it comes out on the page.
Course Objectives
- Use Shapes and WordArt
- Learn to select one of many graphic elements in a worksheet
- Use the Drawing Tools ribbon to edit objects
- Edit objects with text
- Compare different views for worksheets with graphics
- Insert page breaks
- Remove page breaks
- Repeat columns or rows when printing
- Show/Hide gridlines
- Show column and row headings when printing
Cost: $6.95
Creating and Using Microsoft Excel Templates
Templates are a way to take a spreadsheet and reuse it over and over again without going through the time-consuming steps to make copies of existing files. Templates are perfect for spreadsheets that are repeatedly needed, such as on a weekly, monthly or quarterly basis.
Course Objectives
- Save a file as a template
- Locate your templates folder
- Enter data and observe calculations
- Make changes to an existing template
- Save a template to the templates folder
- Open a Microsoft Office Online template
- Edit a Microsoft Office Online template
Cost: $6.95
Sorting and Filtering Data in Microsoft Excel
Data, Data everywhere but what does it all mean. Data tells a story and sorts and filters help define that story. This function-packed workshop covers how to sort your data by multiple criteria, filter data using auto filter and custom filters and use conditional formatting to make it look good.
Course Objectives
- Perform single and multi-level sorts
- Create automatic subtotals
- Use AutoFilter
- Use multiple filter criteria
- Apply conditional formatting
- Create manual conditional formatting rules
- Combine formatting rules with filters
Cost: $6.95
Number Crunching with Formulas and Functions in Microsoft Excel
This course focuses on how to work with formulas and functions in Excel worksheets. Formulas are equations that perform calculations on values in your Excel worksheet. Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.
Course Objectives
- Link multiple worksheets
- Create a Workspace
- Create functions – IF, ROUND, VLOOKUP, PMT
- Use the TODAY function
Cost: $6.95
Showcase Your Data Visually with Charts in Microsoft Excel
Almost everyone has seen or worked with a chart at one time or another--charts illustrate data, relationships, or trends, graphically. Like the saying “a picture is worth a thousand words” charts are often a better tool for presenting information than hard-to-read numbers. This course covers just about everything there is to know about charts. The dazzling charts you will be able to create after you finish this course will impress both you and your colleagues.
Course Objectives
- Create a basic column chart
- Move a chart from the data sheet to a new sheet
- Add a title to a chart
- Select the appropriate data range
- Change chart type to pie
- Format data labels
- Add color to chart elements
- Add a photograph as an element
- Create a template for charts based on the look you design
- Send an Excel chart to Word
Cost: $6.95
Using the What If Analysis and Scenario Manager to Plan for the Future in Microsoft Excel
What-If analysis allows us to look input data and then ask what-if questions of our data based on specific criteria and variables. Data tables allow us to find variations in, for example, loan amounts based on variations in interest rates. By using the Scenario Manager in Microsoft Excel, it is possible to model problems that are more complicated than data tables can handle, involving as many as 32 variables. The Goal Seek command is used to produce a value when some, but not all variables are known.
Course Objectives
- Create several scenarios based on potential budget variations
- View and edit scenarios
- Use named cells
- Generate a summary report
- Create data tables based on one or more variables
- Construct a goal seek command
- Edit the goal variables
- Implement the Solver
Cost: $6.95
Make Sense of Your Data with PivotTables and Pivot Charts in Microsoft Excel
Once you have created a list in Excel, there are many ways to analyze the data. A PivotTable is often the most effective way to summarize and analyze list data. This course explains the ins and outs of PivotTables, including how to create them, modify their structure, and edit the data a PivotTable is based on. The course also covers portraying the data in an interactive PivotChart.
Course Objectives
- Examine PivotTable components and navigate through them
- Click and drag to move existing components
- Use the PivotTable field list to modify a pivot table
- Move fields onto a PivotTable
- Create a PivotTable from a data source
- Modify the table to change the PivotTable layout
- Refresh data using the refresh data button
- Modify PivotTable formulas
- Group data based on specific range criteria
- Show data for each “page” item on a new sheet in your workbook
- Create a new PivotChart
Cost: $6.95
Reviewing and Sharing in Microsoft Excel
If an Excel Spreadsheet is created in a vacuum and no one knows how it was created, does it make an impact. In this lesson, we look at ways of sharing Excel files among multiple users and tracking changes made to said sheet. Topics covered include adding and editing comments, tracking changes and a review of auditing features.
Course Objectives
- Insert comments
- Edit comments
- Highlight changes
- Accept/reject changes
- Trace dependents/precedents
- Understand sharing
- Allow multiple users to edit simultaneously
- Protect an individual sheet in a workbook
- Set a password
Cost: $6.95
Automating repetitive Tasks with Microsoft Excel Macros
Simple, powerful, and easy to customize, Excel macros can save you time and increase your productivity. Macros called loops are especially useful for working with ranges of data. Whether you’ve only heard about macros or already used them in Excel, this course serves as a great introduction.
Course Objectives
- Understanding Macros
- Understanding Personal Macro Workbook
- Using Relative References
- Recording Macros
- Playing a Macro
- Editing a Macro
Cost: $6.95
©2008 KnowledgeWave Training, INC. All rights reserved. Terms and Conditions
