ABTrainingCenter.com provides CE (continuing education), professional development, and NASD and insurance licensing and designation study courses such as Series 7, CFP, CLU, and CPCU designations for brokers, agents, and financial service providers
Course/Product Description
Title:

Microsoft Excel 2007

SKU:PA-1005411
Format: Self-Study Course
Order:Qty:
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
Ribbon
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
Lab


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
Lab


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
Lab


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
Lab


5.0 Printing Workbook Contents

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


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
Functions
1.4 Chapter Review Test
Lab


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
Data
2.4 Calculating Data in a Table or Worksheet
2.5 Chapter Review Test
Lab


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
Lab


4.0 Analyzing Data Using PivotTables and
PivotCharts

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
ClipArt
5.2 Drawing and Modifying Shapes
5.3 Chapter Review Test
Lab


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
Lab

Advanced Course Outline

1.0 Streamlining Workflow

1.1 Creating Macros
1.2 Adding Macros to the Quick Access
Toolbar
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
Analysis
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
Workbooks
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
Order:Qty:
Share This: Share on Facebook


Share on Twitter


Share on Google+


Securities Licensing
Securities Licensing

Insurance License
Insurance License

How To Conduct A Reasonable Accommodation Discussion
How To Conduct A Reasonable Accommodation Discussion

Return-To-Work Strategies
Return-To-Work Strategies

Adjuster Licensing
Adjuster Licensing

Texas All-Lines Adjuster Pre-Licensing ONLINE Course
Texas All-Lines Adjuster Pre-Licensing ONLINE Course

Xactimate Training-Live Online Training
Xactimate Training-Live Online Training

Associate in General Insurance (AINS)
Associate in General Insurance (AINS)

ARM
ARM

Associate in Premium Auditing (APA)
Associate in Premium Auditing (APA)

Earn Your CFP
Earn Your CFP

Surplus Lines Online Exam Prep Course
Surplus Lines Online Exam Prep Course

Workers′ Comp Training Seminar
Workers′ Comp Training Seminar

Cafeteria Plan Training &Certification Program
Cafeteria Plan Training &Certification Program

FMLA Training &Certification Program
FMLA Training &Certification Program

How To Read And Understand Financial Statements
How To Read And Understand Financial Statements

Google+ABTrainingCenter.com. 5755 North Point Parkway, Suite 228 | Alpharetta, GA 30022 | 770-410-9375 | support@ABTrainingCenter.com
Copyright ABTrainingCenter.com 2016 | Web Site Development by OTAU
Facebook