e-learning IT Training Course it certification desktop applications custom development e-learning, distance learning, online training

Home >> Desktop Applications >> Microsoft Office Training >> Office 2010

Microsoft Excel 2010 Online / CBT Training Course

microsoft excel 2010 training videos

 

Video Course Duration: 10 hours 23 minutes

Not Available
Available

Learning Format:
CBT Training
Online Training
Lab Simulation:
24/7 Online Mentoring:
License Type:
Single User
Single User
Access Length:
Perpetual
12 Months
Price:
$149.00
$349.00
(If you have multiple users, please inquire for volume pricing.)
View Microsoft Excel 2010 Training Outline

 

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. You can also choose a variety of other Microsoft Office training courses after you finish this one.

Available Excel 2010 Learning Formats

    • CD
    • Online
    • Network Deployable

     

Learn Microsoft Excel 2010 Training via Online

We have an Excel 2010 online training option that allows you to learn on your computer whenever you want. Busy professionals just need to sign into their online account when enrolled in our elearning programs, allowing them to still have a life and not have to devote extra time by taking a traditional schooling class. All you need to successfully take our online Excel 2010 training videos is reliable Internet connection so those that have easy access to it will enjoy taking this course.

Learn Microsoft Excel 2010 CBT Training Videos on CD / DVD

If you do not want to take the online option, we also have a self-study Excel 2010 CBT course. Just like the online one, you still learn from the computer but with our Microsoft Excel 2010 training CD. The self-paced Excel 2010 computer based training videos feature instructor-led sessions that you can view any time you want. With our self-paced Excel 2010 CBT course, you can learn at whatever speed you want so fast learners can speed ahead while slower learners can take their time with our computer based training program.

Microsoft Excel 2010 Training Outline:

Microsoft Excel 2010 Basic

1.0 Basic Excel Elements

Introduction
Starting Excel
The Ribbon and the New Backstage
Opening an Existing Workbook
Opening a Recently Used Workbook
Creating a New Workbook
Saving Your Workbook
Closing a Workbook
Exiting Excel
Summary

2.0 Basic Excel Details

Introduction
Scrolling With and Without Scroll Bars
Moving Around the Worksheet
Left Click vs. Right Click
Worksheet Tabs
Where are the Dialog Boxes?
Setting up the Page Layout
Previewing and Printing a Workbook
Getting Help
Summary

3.0 Selecting and Editing Techniques

Introduction
Selecting an Entire Worksheet
Selecting a Range of Cells
Selecting Nonadjacent Cells and Ranges
Selecting Columns and Rows
Changing Column Width or Cell Height
Hiding and Unhidden Rows and Columns
Moving and Copying Data
Using Drag and Drop
Editing Information in Cells
Using Undo and Redo
Summary

4.0 Data Entry Techniques

Introduction
Entering Information into Single Cells
Entering Information into Multiple Cells at Once
Deleting Information
Typing Text vs. Numbers
Learning AutoFill Basics
Using AutoFill Tricks
Summary

5.0 Performing Calculations

Introduction
Understanding Formula Operators and Order of Operations
Using Real Numbers to Do Math
Using Cell References to Do Math
Letting the Sum Button do the Math for You
Creating Simple Formulas
Using Common Functions
Using the Insert Functions Dialog Box
Using AutoFill to Copy Formulas
Editing Formulas and Functions
Summary

6.0 Formatting with Fonts and Alignments

Introduction
Changing the Actual Font and Font Size
Embellishing Fonts
Aligning Text Within a Cell
Displaying Text Vertically or at an Angle
Using the Text Wrap Feature or Wrapping Text Manually
Using the Merge and Center Tool
Summary

7.0 Formatting Cells

Introduction
Putting Color into the Cell Background
Bordering Cells
Creating the Proper Number Format with a Click of a Button
Applying Number formats Using the Drop-down Tool
Copying Formats with the Format Painter
Using Built-In Styles
Applying Conditional Formatting
Summary

8.0 Working with the Excel Data

Introduction
Finding and Replacing information
Sorting Data
Copying or Moving Sheet Between Workbooks
Inserting and/or Deleting Columns and Rows
Naming Ranges
Using Various Excel Views for Working Efficiently
Checking Spelling
Inserting Page Breaks
Summary

 

Microsoft Excel 2010 Intermediate

1.0 Multiple Pages, Worksheets and Workbooks

Introduction
Viewing and Arranging Multiple Worksheet Windows
Linking Data Between Worksheets
Navigating in Multiple Workbooks
Linking Workbooks
Selecting Multiple Workbooks
Creating and Opening a Workspace
Freezing Panes
Summary

2.0 Creating Charts

Introduction
Creating a Chart with Consecutive Data
Creating a Chart with Non-Consecutive Data
Moving and Resizing chart Objects
Deleting Chart Objects
Adding Titles and Legends to the Chart
Changing the Chart Type
Changing the Chart Colors
Displaying the Data Table
Using the Charting Tools
Printing Charts
Summary

3.0 Intermediate Formula Techniques

Introduction
Using Named Ranges in Formulas
Using Absolute and Relative Cell References
Copying Formulas and Functions
Linking Worksheets with 3-D Formulas
Creating the PMT Function
Using the IF Function
Using the V-Lookup Functions
Using Nested Functions
Auditing Worksheets
Utilizing the Watch Window
Summary

4.0 Applying Additional Formatting Techniques

Introduction
Using Comments in a Worksheet
Modifying Existing Styles
Using Special Number Formats
Creating Custom Number Formats
Using Themes
Summary

5.0 Organizing Worksheet and Table Data

Introduction
Creating a Custom AutoFill
Creating Excel Tables
Sorting and Filtering Table Data
Sorting Data Based on Options
Removing Duplicate Records
Converting a Table Back to a Normal Cell Range
Summary

6.0 Inserting Graphic Objects

Introduction
Inserting Pictures and ClipArt
Modifying Pictures and ClipArt
Drawing and Modify Shapes
Using SmartArt Graphics
Formatting Graphics Objects
Layering and Grouping Graphic Objects
Using the Screenshot Tool
Summary

7.0 Analyzing Data with Pivot Tables and Pivot Charts

Introduction
Creating a Pivot Table
Filtering Data Using Slicers
Analyzing Data Using Pivot Charts
Summary

8.0 Finishing Details

Introduction
Setting the Print Area
Hyperlinking to Other Locations
Saving the Workbook as a Template
Changing Excel Properties
Customizing the Quick Access Toolbar
Summary


Microsoft Excel 2010 Advanced

1.0 Recording and Using Macros

Introduction
Showing the Developer Tab
Opening Workbooks containing Macros
Enabling Macro Security in Excel
Recording a Macros
Running a Macros
Understanding Absolute vs. Relative Recording
Viewing and Modifying Macros
Assigning Macros to shortcut Keys or to the Quick Access Toolbar
Assigning Macro to Buttons and Shapes
Creating a Macro to Automatically Run when the Workbook Opens
Deleting Macros
Saving a Workbook Containing Macros
Summary

2.0 Advanced Functions

Introduction
Logical Functions
Nesting Logical Functions
Eliminating Extra Spaces within Data
Changing Text to Proper Case
Combining Cells using Concatenate
Extracting a Portion of Text from a Field
Changing a formula to a Value
Using the SUMIF Function
Database Functions
Displaying and Printing Formulas
Summary

3.0 Collaborating with Others

Introduction
Protecting Worksheets
Protecting Workbooks
Sharing Workbooks
Setting Revision Tracking
Reviewing Tracked Revisions
Merging Workbooks
Summary

4.0 Working with Data Tools

Introduction
Turning Text into Columns
Validating Data
Creating a Data Validation List for Data Entry
Consolidating Data from Multiple Locations
Working with Scenarios
Goal Seek
Solver
Creating Sparkline
Installing the Analysis ToolPak
Summary

5.0 Managing Data

Introduction
Importing Data into Excel
Exporting Data from Excel
Creating Advanced Filters
Grouping Data
Ungrouping Data
Creating an Auto Outline
Clearing Groups and Outlines
Using the Subtotal Feature
Summary

 

Featured Customers

Featured Customers

Social Media

find k alliance on facebookfind k alliance on twitter

Download a Catalog

course catalog computer training

Download

Enterprise Training Solution

enterprise training solutions