Excel 2010 Video Training - Basic, Intermediate and Advanced Level

Home
Computer Office Skills
Excel 2010 Video Training - Basic, Intermediate and Advanced Level

Home
Computer Office Skills
Microsoft Office 2010
Excel 2010 Video Training - Basic, Intermediate and Advanced Level

Excel 2010 Video Training - Basic, Intermediate and Advanced Level

Price:

$149.00

SKU:

Excel2010all

Shipping:

$5.95 (Fixed shipping cost)

Product Description

Microsoft Excel 2010 Video Training Baisc, Intermediate, Advance and Expert Level

Why learn the new features on your own if you can easily take our Microsoft Excel 2010 training courses to master the new version of the most popular spreadsheet program used worldwide. The self-study Excel 2010 training videos are cost-effective since everything you need to learn with is included in the course so you do not have to spend extra money on additional materials. We have certified instructors teaching our Microsoft Excel 2010 training course so that you get a quality and comprehensive education. After learning from our self-study Excel 2010 training videos, you will be a more knowledgeable professional and be able to use your skills to enhance your computer skills.

Microsoft Excel 2010 Basic

1.0 Orientation to Excel
1.1 Introduction
1.2 Overview Excel 2010
1.3 Navigating Excel: About the Ribbon
1.4 Customizing the Ribbon
1.5 Quick Access Toolbar
1.6 Finding Help
1.7 Summary

2.0 Working with Data
2.1 Introduction
2.2 Entering Data
2.3 Saving Workbooks
2.4 Selecting Cells and Ranges
2.5 Navigating the Spreadsheet
2.6 Basic Formulas
2.7 Basic Functions
2.8 Summary

3.0 Worksheet Formatting
3.1 Introduction
3.2 Changing Fonts
3.3 Cells Borders and Colors
3.4 Column Width and Row Height Modification
3.5 The Number Group
3.6 The Alignment Group
3.7 The Styles Grouip
3.8 The Themes Grouip
3.9 Summary

4.0 Worksheet Alterations
4.1 Introduction
4.2 Deleting and Adding Cells
4.3 Hiding and Unhiding Rows
4.4 Finding and Selecting Tools
4.5 Using Spell Check
4.6 How to use Copy and Paste Function
4.7 Summary

5.0 Handing Large Workbooks
5.1 Introduction
5.2 Worksheet Tab Configuration
5.3 View and Zoom
5.4 Setting Panes and Split Windows
5.5 Working with Multiple Windows
5.6 Summary

6.0 Printing and Sharing
6.1 Introduction
6.2 Printing your Workbook
6.3 Advanced Printing Options
6.4 Sharing as Other File Types
6.5 Summary

Microsoft Excel 2010 Intermediate

1.0 Working with Tables
1.1 Introduction
1.2 Creating a Table
1.3 Formatting a Table
1.4 Sorting Data in a Table
1.5 Filtering Data
1.6 Conditional Formatting
1.7 New Conditional Formatting in Excel 2010
1.8 Data Calculation and Subtotal
1.9 Summary

2.0 Pivot Tables
2.1 Introduction
2.2 Creating a Pivot Table
2.3 Modifying a Pivot Table
2.4 Formatting a Pivot Table
2.5 Apply Formatting Options
2.6 New Sparklines Feature in Excel 2010
2.7 Summary

3.0 The Illustration Group
3.1 Introduction
3.2 Adding and Adjusting Pictures
3.3 Adding and Adjusting Pictures
3.4 Using SmartArt to Demonstrate Workflow
3.5 Grahpic Object Grouping and Layering
3.6 Summary

4.0 Intermediate Formula and Functions
4.1 Introduction
4.2 Naming Cells and Ranges
4.3 Creating Advanced Formula
4.4 Using Advanced Functions
4.5 Logical Functions
4.6 Lookup Functions
4.7 Summary

Microsoft Excel 2010 Advanced

1.0 Workflow Improvement
1.1 Introduction
1.2 About Macros
1.3 Create Macro
1.4 Editing Macros
1.5 Data Validation
1.6 Converting Text to Columns
1.7 Saving Time with Auto-Fill Tricks
1.8 File Properties
1.9 Summary

2.0 Collaboration with Excel
2.1 Introduction
2.2 File Security
2.3 Track Changes
2.4 Commenting
2.5 Working with Multiple Authors
2.6 Importing and Exporting Files
2.7 Summary

3.0 Analying Data
3.1 Introduction
3.2 What-if Examples
3.3 Data Tables
3.4 Scenario Manager
3.5 Goal Seek
3.6 Summary

4.0 Working with Multiple Workbooks
4.1 Introduction
4.2 Workspace Formation
4.3 Data Condensing
4.4 Cell Linking Across Workbooks
4.5 Link Editing
4.6 Summary

5.0 Worksheet Examination
5.1 Introduction
5.2 Correcting Formula Errors
5.3 Formula Observation and Assessment
5.4 Summary

6.0 Excel and the Internet
6.1 Introduction
6.2 Worksheet Publishing
6.3 Importing from the Intenet
6.4 Summary

Microsoft Excel 2010 Expert

1.0 Advanced Pivot Table Features
1.1 Introduction
1.2 Grouping in Pivot Tables
1.3 Calculation in Pivot Data
1.4 Creating and Modifying Pivot
1.5 Summary

2.0 Using Text Functions
2.1 Introduction
2.2 Cleaning up Data
2.3 Preparing a Mailing List
2.4 Summary

3.0 Using Time and Date Functions
3.1 Introduction
3.2 Working with Time in Excel
3.3 Creating a Schedule with Date and Time Calculations
3.4 The Networkday Function
3.5 Summary

4.0 Financial Application
4.1 Introduction
4.2 Credit Repayment Schedule with NPER
4.3 Making Investment Decisions
4.4 Cell Linking Across Workbooks
4.5 Summary

5.0 Advanced Data Analysis
5.1 Introduction
5.2 Introducing Solver
5.3 Using Solver to Optimze Variables
5.4 Functions to Analyze Statistics
5.5 Analysis Took Pack Overview
5.6 Correlation and Histogram Information
5.7 Summary

6.0 Advanced Charting and Graphics
6.1 Introduction
6.2 Working with Data Series
6.3 Data Analysis Chart Tools
6.4 Summary

Learning Anywhere and Anytime with Microsoft Excel 2010 Tutorials

If you've been putting off getting the Microsoft Excel 2010 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 2010 training CD. Simply install the disc on your computer or laptop and begin learning about the major changes found in the 2010 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 2010 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 2010 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 2010 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 2010 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 2010 has been redesigned, consider enrolling in a Microsoft Excel 2010 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 2010, 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 2010 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 2010 training.