|
Home :: Self-Study CBT Training :: Desktop Training :: Microsoft Office Training :: Excel
Microsoft Excel 2007 Training Course on CD
 |
| |
|
|
| Microsoft Excel 2007 Training CDs w/ Hands-On Labs |
|
|
| Single User License |
$199.00 |
 |
| |
Now $39.00 |
Limited Time Sale! |
| |
|
|
| Multi-User Non-Concurrent License: |
|
|
| Multi-User Non-Concurrent License |
$399.00 |
|
| |
|
|
| Unlimited Online Desktop Library: |
|
|
| Subscription Term: 12 Months |
$299.00 |
|
| Subscription Term: 24 Months |
$549.00 |
|
| Subscription Term: 36 Months |
$699.00 |
|
Are you ready for the 2007 version of Microsoft Excel? A self-study MS Excel 2007 tutorial CD will get you up to speed on all of the features and functions of Excel 2007. By choosing a computer based training product from CBT Planet, you will learn in a simulated environment. This means you don’t need to have a copy of the Microsoft software on your computer in order to learn it!
Microsoft Excel 2007 training videos on cd ensures that you get the most out of your investment in the leading business spreadsheet program. You’ll learn how to harness the power that you didn’t even know existed. You’ll learn simple tricks and techniques as well as more complicated routines.
All you need to get started is an Excel 2007 training cd. Simply install the disc onto your computer and begin your studies. From entering formulas to working with data, you’ll learn the ins and outs of using spreadsheets and work more productively as a result. The self-study Microsoft Excel training cd shows you how. You’ll view interactive content including animations, step-by-step narrated videos, graphic illustrations and more. Then you’ll have the opportunity to do the steps yourself directly in the Excel CBT environment.
Let CBT Planet’s self-study MS Excel tutorial CD help you master the exciting changes that Microsoft has included in the 2007 version of Excel.
Course Instructor:
Debbie Dalrymple has been doing computer training since 1992. Starting her training career at Computer Learning Center in Washington DC working with DOS and early Windows applications she has transitioned to the latest Windows software that we know today. Throughout the past two decades Debbie has worked training students and providing technical support and consulting services in a variety of other industries such as Architecture, Law, Federal Government, Pharmaceutical and the Oil Industry as well as extensive non-profit work.
| Video Player Features and Functions |
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| Microsoft Excel 2007 Training Video CBT Features: |
| |
|
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
| |
|
| Outline: |
| |
|
| |
Microsoft Excel 2007 Basic
1.0 Creating a Basic Worksheet
1.1 Explore the User Interface and the Ribbon
1.2 Customize the Quick Access Toolbar
1.3 Navigate and Select in Excel
1.4 Enter Data and Save a Workbook
2.0 Performing Calculations
2.1 Create Basic Formulas
2.2 Calculate with Functions
2.3 Copy Formulas and Functions
3.0 Modifying a Worksheet
3.1 Manipulate Data
3.2 Working with Cells, Columns, and Rows
3.3 Search for Data in a Worksheet
3.4 Spell Check a Worksheet
4.0 Formatting a Worksheet
4.1 Modify Fonts
4.2 Add Borders and Color to Cells
4.3 Change Column Width and Row Height
4.4 Apply Number Formats
4.5 Using Styles
5.0 Printing Workbook Contents
5.1 Print Workbook Contents Using Default Print Options
5.2 Setting Page Breaks
6.0 Managing Large Workbooks
6.1 Format Worksheet Tabs
6.2 Manage Worksheets in a Workbook
6.3 Manage the View of Large Worksheets
Microsoft Excel 2007 Intermediate
1.0 Calculating Data with Advanced Formulas
1.1 Manage Cell and Range Names
1.2 Calculating Data Across Worksheets
1.3 Analyzing Data with Logical and Lookup Functions
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
3.0 Presenting Data Using Charts
3.1 How to Create a Chart
3.2 Modifying Charts
3.3 Formatting Charts
4.0 Analyzing Data Using PivotTables and PivotCharts
4.1 Creating a PivotTable Report
4.2 Analyzing and Modifying a PivotTable
5.0 Inserting Graphic Objects
5.1 Inserting and Modifying Pictures and ClipArt
5.2 Drawing and Modifying Shapes
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
Microsoft Excel 2007 Advanced
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 Workbook Properties
1.7 Modifying Excel Options
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
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
4.0 Analyzing Data
4.1 Adding a Trend Line to Charts
4.2 Create Scenarios and Performing What-If Analysis
5.0 Working with Multiple Workbooks
5.1 Create a Workspace
5.2 Consolidate Data
5.3 Managing Linked Cells in Different Workbooks
6.0 Importing and Exporting Data
6.1 Exporting Excel Data
6.2 Importing a Table from Word
|
| |
|
Learning Anywhere and Anytime with Microsoft Excel 2007 Tutorials
If you've been putting off getting the Microsoft Excel 2007 training you need because you simply lack the time or energy to attend traditional computer training classes, you'll love the convenience of the Excel 2007 training CD. Simply install the disc on your computer or laptop and begin learning about the major changes found in the 2007 release of Excel anywhere you happen to be and anytime you happen to want to study.
Regular classes can't compare to this format because with the Excel 2007 tutorial you get a front row seat to full screen demonstrations featuring instructor narration. You'll see the changes and finally figure out where all your favorite tools went. In addition to exploring the new interface, you'll learn about the new features and how to use Excel to its fullest. No matter what your current abilities are, you will find a course that will take you to the next level from beginning spreadsheet user to expert Excel user.
Instructor-led Excel 2007 tutorial videos give you a thorough tour of the Excel environment where you will see the features demonstrated and hear step-by-step explanations. Even if you haven't yet upgraded to the 2007 version of Microsoft Office, you'll get to explore the simulated environment and participate in hands-on exercises. By seeing Excel in action, learning what each function is for and how to use it, and practicing in a simulated environment, you will be well on your way toward mastering spreadsheet usage.
Best of all, all training takes place on either your computer or laptop for the ultimate in portable, anytime, anywhere study sessions.
The new version of Excel has undergone an extensive redesign which makes it tough for even seasoned users to get around. Using an Excel 2007 training CD is an ideal way for existing users to get their bearings and is even better for new users who want to learn Excel from the ground up.
Benefits of Microsoft Excel 2007 Training
If you work with numbers, chances are you also must use a spreadsheet from time to time. Do you know how to use your spreadsheets to their full potential? Excel has been the leading spreadsheet application for many years with many users knowing just enough to get by. Now that Excel 2007 has been redesigned, consider enrolling in a Microsoft Excel 2007 training course and moving beyond the status quo.
Not only does Excel sport a new look, it also has numerous enhancements. By learning and mastering Excel 2007, you will set yourself apart from everyone else. Rather than simply storing data in Excel, learn how to use the data. The powerful tools are waiting for you to use them. Enroll in a self-study Microsoft Excel 2007 tutorial training course and learn what those tools are, how they can benefit you, and how to use them. You'll be able to analyze your numbers, not just enter them. As you become more proficient with using this application, you'll become more valued within your organization. Your new skills will allow you to work more productively. Your in-depth understanding of relevant data will affect your job performance for the better. By better understanding the data you work with, you'll be able to make better decisions, projections, and recommendations.
Microsoft Excel is a leading spreadsheet for good reason: it's a powerful tool. And, it's getting better and better. Many of the old limitations are gone making Excel more versatile than ever. Find out how each of the function of Excel works so that you can take advantage of these powerful features by taking a Microsoft Excel 2007 training course.
Excel training isn't just for newcomers to the Office suite. Anyone who uses Excel, even seasoned users can increase their knowledge on their own through self-study Microsoft Excel 2007 training.
Free Excel 2007 Tutorials:
Spreadsheet Terminology - Microsoft Excel 2007 is an electronic spreadsheet program that is part of the Microsoft Office suite. You use Excel to organize, calculate, and analyze data. The tasks you can perform range from preparing a simple invoice to creating elaborate 3-D charts to managing an accounting ledger for a company.
Exploring the Excel Window - The Microsoft Excel window has several features that help you use the program. However, the first thing you need to know is how to start Microsoft Excel.
Interacting with Excel - The Ribbon is the main location for menus and tools. When you choose a Ribbon tab, the Ribbon displays groups that contain sets of related tools. Some tools are buttons you click to perform a task immediately. Some tools expand to display simple lists or menus, and some tools display galleries.
Entering and editing text and values - After you create a workbook, you can begin entering data in cells. Cell entries can include many types of data, including text and values. When you type, data is entered in the active cell.
Using Multiple Worksheets - For various resons, you may want to have more than workbook open at a time. You can open an dwork with as many workbooks as your computer memory permits. Each workbook has its own window and a unique button on the Windows taskbar
Linking WorkSheets with 3-D Formulas - Excel formulas can refer to cells or ranges in other worksheets, or a range of worksheets, within a workbook. This tyipe of formula creates a link between worksheets. When two worksheets are linked, any change that you make in the source cell is automatically updated in the linked cell.
Linking Workbooks - Just as you can link multiple worksheets within a workbook, you an also link multiple workbooks. You an do this by writing a formula in one workbook that refers to a cell, range, or name in another workbook. References to other workbooks are called external references. You can maintain workbook links even if the workbook that is referred to is renamed.
Managing Workbooks - If you find that you need repeatedly use the same set of Microsoft Excel 2007 workbooks, you can save them as a workspace. A workspace is a logical container of related workbooks that retains page setups, window sizes, and display settings. A workspace does not save the workbooks themselves, so you'll need to save changes in each workbook individually.
Logical Functions - You can use conditional logic in a formula to return a specific result depending on whether a certain test, or condition, is met. If the condition is true, one result will be calculated. If the condition is false, a difference result will be displayed.
Using Lookup Functions - You can find a value in a range of related data in a worksheet by using lookup functions. These functions find a value in the first row or column of a list and then return a corresponding value from another row or column.
Creating Data Tables - A data table is a range that displays the results of changing certain values in one or more formulas. The different values you want to enter in a formula are also included in the data table. A data table can have either a single variable or two variables.
Exporting and importing XML Data - Extensible Markup Language (XML) is a set of rules for structuring and designing data formats that are exchanged between applications. You can improt data from an XML file into an Excel workbook. You can also export data from a workbook to an XML file. To import or export XML data, you ue the XML Source task pane to map the workbook to a user-defined XML schema (.xsd file).
Articles:
|
