MS Excel 2010 Introduction

by InterSkill Australia Claim Listing

This course will help students prepare for the Microsoft Office Specialist exam for Excel 2010 (exam 77-882). For comprehensive certification training, students should complete our Introduction, Intermediate, and Advanced courses for Excel 2010

$450

Contact the Institutes

Fill this form

Advertisement

InterSkill Australia Logo

img Duration

1 Day

Course Details

This course will help students prepare for the Microsoft Office Specialist exam for Excel 2010 (exam 77-882). For comprehensive certification training, students should complete our Introduction, Intermediate, and Advanced courses for Excel 2010.

 

Course Description:

After completing this 1-day Excel 2010 Introduction training course course, students will know how to:

  • Start Microsoft Excel and identify the components of the Excel interface
  • Open an Excel workbook
  • Use the Help window
  • Navigate worksheets
  • Enter & edit text, values, & formulas
  • Examine the order of operations
  • Insert pictures
  • Use AutoFill
  • Save and update a workbook
  • Save a workbook as a PDF file
  • Move and copy data and formulas
  • Use the Office Clipboard
  • Use Paste Link
  • Work with relative and absolute references
  • Insert and delete ranges, rows, and columns
  • Use the SUM function, AutoSum, and the Average, Min, Max, Count, and Counta functions to perform calculations in a worksheet
  • Format cells, rows, and columns
  • Merge cells
  • Apply color and borders
  • Format numbers
  • Create conditional formats
  • Copy formatting
  • Apply table styles
  • Sort data
  • Use Find and Replace to update the formatting for specific content
  • Check spelling
  • Find and replace text and data
  • Preview and print a worksheet
  • Set page orientation and margins
  • Create & format headers and footers
  • Print gridlines
  • Create, format, modify, and print charts based on worksheet data
  • Work with various chart elements
  • Apply chart types and chart styles
  • Freeze panes and split a worksheet
  • Open and arrange a new window with the current worksheet content
  • Hide and unhide data
  • Set print titles and page breaks to optimize print output
  • Insert different even and odd headers
  • Manage multiple worksheets
  • Represent data graphically within cells by applying three forms of conditional formatting (data bars, color scales, and icon sets)
  • Insert and modify SmartArt graphics; and insert and modify screenshots
  • Perth Branch

    32/145 Stirling Hwy, Perth

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy