Microsoft Excel 2010 Level 2

Microsoft Office Excel 2010 Level 2


Duration

1 day


Course Overview

You will work with various tools to analyse data in spreadsheets. You will also organise table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.
Target Audience

This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data and customising workbooks.
Prerequisites

Before starting this course, students are recommended to take the following Indicia Training course or have equivalent knowledge:
Microsoft Office Excel 2010 Level 1.


Course Objectives

Upon successful completion of this course, students will have the necessary skills to:

· Organize worksheet and table data using various techniques.
· Create and modify charts.
· Insert and modify graphic objects in a worksheet.
· Customize and enhance workbooks and the Microsoft Office Excel environment.


Course Content
Further Formulas and Functions
Review of Formulas and Functions
Working with Dates and Percentages
Functions and the Formula Palette
Absolute Cell Addressing
Displaying Underlying Formula
Printing and Formatting
Printing Techniques
Custom Formatting
Hiding Columns and Outlining

Worksheets and Workbooks
Working with Multiple Worksheets
Working with Multiple Workbooks
Creating a Workspace

Working with Lists
Filtering Data
Sorting Dats
Analysing Data using Subtotals

Charts
Creating Charts
Modifying Charts
Printing Charts
Further Customisation

Other Features
Sharing Workbooks
Worksheet Auditing
Adding Comments to Cells