Microsoft Excel 2010

Course Description:

This course is intended to prepare user to navigate Microsoft Office Excel 2010 software at the feature and functionality level. Users will be familiar with and know how to use more of the common features and understand the capabilities of Microsoft Office Excel 2010. The user will be able to demonstrate competence in using some of the Excel features such as filtering, managing data and creating charts.

Course Objectives:

This course prepares the users for the practical usage of Microsoft Excel.

Prerequisites:

The users should be able to navigate Microsoft Office Excel 2010 software at the feature and functionality level.

Course Duration: 18 Hours

Course Outline:

Managing the Worksheet Environment

  • Navigate through a worksheet.
  • Print a worksheet or workbook.
  • Personalize environment by using Backstage.

Creating Cell Data

  • Construct cell data.
  • Apply AutoFill.
  • Apply and manipulate hyperlinks.

Formatting Cells and Worksheets

  • Apply and modify cell formats.
  • Merge or split cells.
  • Create row and column titles.
  • Hide and unhide rows and columns.
  • Manipulate Page Setup options for worksheets.
  • Create and apply cell styles.

Managing Worksheets and Workbooks

  • Create and format worksheets.
  • Manipulate window views.
  • Manipulate workbook views.

Applying Formulas and Functions

  • Create formulas.
  • Enforce precedence.
  • Apply cell references in formulas.
  • Apply conditional logic in a formula.
  • Apply named ranges in formulas.
  • Apply cell ranges in formulas.

Presenting Data Visually

  • Create charts based on worksheet data.
  • Apply and manipulate illustrations.
  • Create and modify images by using the Image Editor.
  • Apply Sparklines.

Sharing worksheet data with other users

  • Share spreadsheets by using Backstage.
  • Manage comments.

Analyzing and Organizing Data

  • Filter data.
  • Sort data.
  • Apply conditional formatting.

Working with Lists

  • Converting a List to a Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List
  • Grouping and Ungrouping Data in a List

Call us at +65 6227 7996 for scheduling details.

 
Inquire now and fill up the form below:

Your Name (required)

Your Email (required)

Enter The Course You are Interested

Your Message

Security Code:
captcha

58 − 57 =