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

Check out more MS Excel courses in Australia

Keystroke Learning Logo

Microsoft Word Introduction

You will be given a solid foundation of skills upon which to build

by Keystroke Learning [Claim Listing ]
Axial Training Logo

MS Office

With most businesses using Word, Excel and PowerPoint for various work requirements, employees must have the foundational skills needed to use Microsoft Office

by Axial Training [Claim Listing ]
NDA Tasmania Logo

MS Word (Advance)

This course teaches how to produce long documents with a wide range of complex layouts and formats, use automatic numbering systems, import data from other applications, work on documents with others, automate word processing operations, produce complex automated business documents.

by NDA Tasmania [Claim Listing ]
Academy IT Logo

Powerpoint 2016 Introduction

The skills and knowledge acquired in Microsoft PowerPoint 2016 – Level 1 are sufficient to be able to create real-world slide shows. You will learn how to create, print and publish presentations

by Academy IT [Claim Listing ]
Odyssey Training Logo

Microsoft Word Introduction

This course has been developed for people wanting to learn the fundamentals of Microsoft Word to create professional correspondence and documents.

by Odyssey Training [Claim Listing ]

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