Microsoft Excel 2010 Online Video Course
£56.99 (inc. VAT)

Course Description

This MOS Excel 2010 training course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software. When you pass the Excel 2010 Exam 77-882, you achieve Microsoft Certified Application Specialist (MOS) status in Excel 2010.

The Microsoft Certified Application Specialist Certification, (MOS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2010. This course follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.

Course Length:
13 hours

About the author:

Ray Wagner, CISA, MOS, PMP

Ray began his IT education at James Madison University, where he excelled in the business school's Computer Information Systems program. Upon graduation, he began his career as a financial systems auditor where he was required to utilize and optimize the Microsoft Office applications. Once he mastered the applications, Ray began teaching co-workers how to effectively use their applications to increase their productivity. Life as an auditor also exposed Ray to project management fundamentals, and Ray was soon managing small auditing projects as a Senior Consultant. After a few years, Ray shifted gears and became a consultant for a project management contractor on a multi-million dollar government program where he was responsible for tracking program costs and schedules. Ray has since started a training company that allows him to manage a business as well as deliver application and project management training to a variety of clients.

System Requirements:
A multimedia PC with a 512 Kb/sec or faster Internet connection running Mozilla Firefox, Google Chrome or Microsoft Internet Explorer with Adobe Flash Player. Please note: You can improve performance by re-sizing and lowering the picture quality of the video.

Subscription:
1 year.

Course Contents

Module 1

  • Introduction
  • Course Outline
  • Introducing Excel 2010
  • The Excel Interface
  • Keyboard Shortcuts
  • Module Review

Module 2

  • Basic File Commands and Operations
  • Creating, Saving and Closing Workbooks
  • Personalizing Files and Opening Workbooks
  • Viewing Existing Workbooks and Applying Templates
  • Keyboard Shortcuts
  • Module Review

Module 3

  • Creating, Managing and Navigating the Worksheets
  • Creating and Managing Worksheets
  • Navigating the Worksheets
  • Keyboard Shortcuts
  • Module Review

Module 4

  • Entering and Managing Worksheet Data
  • Worksheet Basics and Cell Range Selection
  • Entering Cell Content and Multiple Cells
  • AutoContent and Undo, Redo and Repeat
  • Updating and Clearing Cell Content
  • Inserting and Deleting, Rows and Columns
  • Copying, Cutting, Pasting and Moving Contents
  • Keyboard Shortcuts
  • Module Review

Module 5

  • Formatting Cells and Worksheets
  • Formatting Cells and Applying Formats
  • Alignment
  • Merging Cells and Cell Styles
  • Numbers
  • Apply and Modify Formats
  • Using Table Features
  • Keyboard Shortcuts
  • Module Review

Module 6

  • Applying Formulas and Functions
  • Creating Formulas
  • Using Cell References
  • Managing and Updating Formulas
  • Creating Functions
  • Conditional Statements
  • Error Messages
  • Keyboard Shortcuts
  • Module Review

Module 7

  • Analyzing and Organizing Data
  • Find and Replace
  • Sorting
  • Filtering
  • Conditional Formatting and Keyboard Shortcuts
  • Module Review

Module 8

  • Naming and Hyperlinks
  • Naming Cells and Ranges
  • Hyperlinks
  • Module Review

Module 9

  • Displaying Data Visually Using Charts
  • Charting
  • Layout Chart Element Options and Format
  • Sparklines
  • Keyboard shortcuts
  • Module Review

Module 10

  • Preparing to Print and Printing
  • Preparing to Print with Page Layouts
  • Module Review

Module 11

  • Share Worksheet Data with Other Users
  • Sharing a Document and Managing Comments
  • Module Review

Module 12

  • Including Illustrations and Graphics in a Workbook
  • Inserting and Formatting Pictures
  • Inserting and Formatting Clip Art
  • Inserting and Formatting Shapes, Word Art and Text Boxes
  • Inserting and Formatting Smart Art
  • Keyboard Shortcuts
  • Module Review

Module 13

  • Customize the Excel Interface
  • Module Review
  • Course Review