provides CE (continuing education), professional development, and designation study courses for engineering professionals

Format: Available Self-Study Courses

The following provides course information, as well as pricing, author, and educational credit information for the course you selected.

To order this course, click on one of the "Order" options at the bottom of the page.

Course/Product Description


Microsoft Excel 2007

Description: Here you are with a new version of Excel, but do you know how to work all the new changes and enhancements?

Don't get frustrated trying to teach yourself how to use all these new features since our Excel 2007 training course can teach you everything there is to know about the new Excel!

This course is taught by subject matter experts who have mastered the new version of one of the best spreadsheet programs around. Our course will teach you how to harness the power that you didn't even know existed and learn simple tricks and techniques.

Basic Course Outline

1.0 Creating a Basic Worksheet

1.1 Exploring the User Interface and the
1.2 Customizing the Quick Access Toolbar
1.3 Navigate and Select in Excel
1.4 Enter Data and Saving as a Workbook
1.5 Chapter Review Test

2.0 Performing Calculations

2.1 Creating Basic Formulas
2.2 Calculating with Functions
2.3 Copying Formulas and Functions
2.4 Chapter Review Test

3.0 Modifying a Worksheet

3.1 Manipulating Data
3.2 Working with Cells, Columns, and Rows
3.3 Search for Data in a Worksheet
3.4 Spell Checking a Worksheet
3.5 Chapter Review Test

4.0 Formatting a Worksheet

4.1 Modifying Fonts
4.2 Adding Borders and Color to Cells
4.3 Change Column Width and Row Height
4.4 Applying Number Formats
4.5 Using Styles
4.6 Chapter Review Test

5.0 Printing Workbook Contents

5.1 Printing Workbook Contents Using Default
Print Options
5.2 Setting Page Breaks
5.3 Chapter Review Test

6.0 Managing Large Workbooks

6.1 Formatting Worksheet Tabs
6.2 Manage Worksheets in a Workbook
6.3 Manage the View of Large Workbooks
6.4 Chapter Review Test

Intermediate Course Outline

1.0 Calculating Data with Advanced Formulas

1.1 Managing Cell and Range Names
1.2 Calculating Data Across Worksheets
1.3 Analyzing Data with Logical and Lookup
1.4 Chapter Review Test

2.0 Organizing Worksheet and Table Data

2.1 Creating and Modifying Tables
2.2 Formatting Tables
2.3 Sorting or Filtering Worksheet or Table
2.4 Calculating Data in a Table or Worksheet
2.5 Chapter Review Test

3.0 Presenting Data Using Charts

3.1 How to Create a Chart
3.2 Modifying Charts
3.3 Formatting Charts
3.4 Chapter Review Test

4.0 Analyzing Data Using PivotTables and

4.1 Creating a PivotTable Report
4.2 Analyzing and Modifying a PivotTable
4.3 Chapter Review Test

5.0 Inserting Graphic Objects

5.1 Inserting and Modifying Pictures and
5.2 Drawing and Modifying Shapes
5.3 Chapter Review Test

6.0 Customizing and Enhancing Workbooks
and the Excel Environment

6.1 How to Customize the Excel Environment
6.2 Customizing Workbooks
6.3 Managing Themes
6.4 How to Create and Use Templates
6.5 Chapter Review Test

Advanced Course Outline

1.0 Streamlining Workflow

1.1 Creating Macros
1.2 Adding Macros to the Quick Access
1.3 Editing a Macro
1.4 Using Conditional Formatting
1.5 Applying Data Validation to a Worksheet
1.6 Updating Worksheet Properties
1.7 Modifying Excel Options
1.8 Chapter Review Test

2.0 Collaborating with Others

2.1 Protecting Files and Sharing Workbooks
2.2 Merging Multiple Workbooks
2.3 Adjusting Macro Settings
2.4 Restricting Document Access
2.5 Chapter Review Test

3.0 Auditing Worksheets

3.1 Tracing Cell Precedents and Dependents
3.2 Troubleshooting Errors in Formulas
3.3 Watching and Evaluating Formulas
3.4 Creating a Data List Outline
3.5 Chapter Review Test

4.0 Analyzing Data

4.1 Adding a Trend Line to Charts
4.2 Create Scenarios and Performing What-If
4.3 Chapter Review Test

5.0 Working with Multiple Workbooks

5.1 Create a Workspace
5.2 Consolidate Data
5.3 Managing Linked Cells in Different
5.4 Chapter Review Test

6.0 Importing and Exporting Data

6.1 Exporting Excel Data
6.2 Importing a Table from Word
6.3 Importing a Delimited Text File
6.4 Chapter Review Test

Microsoft Excel 2007 CBT Training

Learn in the comforts of your home or office with our Excel 2007 training CD that is jam-packed with tons of interactive content that makes learning fun and easy. This computer based training course allows you the freedom to learn on your own time, which is great for busy professionals with little time to spare.

The Excel 2007 computer based training videos also provide you with a simulated environment that does not require you to have the program installed on your computer to learn successfully.

About The Provider: K Alliance provides computer based training (CBT) and online computer training videos.

We offer a complete e-learning solution in the form of either dvd, CD, intranet, or online training video courseware.

Our self-paced computer training videos include hundreds of choices in topics such as IT Training, Certification Training, Desktop Office and Soft Skills. No matter which method you prefer, K Alliance has courses to help you achieve your elearning goals.
Price: $149.00
More Info: Contact Us For More Information


Feature Items
Six Sigma Certifications
Six Sigma Certifications
Bud To Boss Management Training Seminar
Bud To Boss Management Training Seminar
Auditing Business Application Systems
Auditing Business Application Systems
ISO &QMS Certifications
ISO &QMS Certifications
The Intern Toolkit
The Intern Toolkit
Training On Medical Devices
Training On Medical Devices
Advanced Auditing For In-Charge Auditors
Advanced Auditing For In-Charge Auditors
Basic Project Management
Basic Project Management
MicroSoft Word Training
MicroSoft Word Training
Excel Training
Excel Training
QuickBooks: Live &On-Demand Webinars
QuickBooks: Live &On-Demand Webinars
CAD &AutoCAD Training
CAD &AutoCAD Training