offers CPA exams, accounting degree training, CPE, and professional development for accountants and CPAs
Course/Product Description

Microsoft Excel 2007

Format: Self-Study Course

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
Share This: Share on Facebook

Share on Twitter

Share on Google+

Sales &Use Tax Workshop
Sales &Use Tax Workshop

Tax Court Exam Homestudy Program
Tax Court Exam Homestudy Program

Series 6 - Live &OnDemand Online Course
Series 6 - Live &OnDemand Online Course

Fundamentals Of Internal Auditing
Fundamentals Of Internal Auditing

Internal Audit School
Internal Audit School

Audit And Security For Cloud-Based Services
Audit And Security For Cloud-Based Services

Fraud Auditing Boot Camp
Fraud Auditing Boot Camp

Advanced Auditing For In-Charge Auditors
Advanced Auditing For In-Charge Auditors

1040 Training
1040 Training

Forensic Certified Public Accountant Designation
Forensic Certified Public Accountant Designation

Peachtree Seminars
Peachtree Seminars

How To Use QuickBooks
How To Use QuickBooks

Project Management Workshop
Project Management Workshop

How To Get Payroll Penalties Waived
How To Get Payroll Penalties Waived

Garnishments, Child Support Orders, And Other Levies
Garnishments, Child Support Orders, And Other Levies

Certified Payroll Administrator
Certified Payroll Administrator 5755 North Point Parkway, Suite 228 | Alpharetta, GA 30022 | 770-410-9941 |
Copyright 2017 | Web Site Development by OTAU