Excel 2010/365 - Level 2

Duration: Instructor Led Learning - 1 Day

At Course Completion:
Upon successful completion of this course, students will be able to:

 

  • Use advanced financial and statistical formulas
  • Organise the worksheet and table data
  • Create, edit and style bar, line and pie charts
  • Analyse data using PivotTables, Sparklines, and PivotCharts
  • Insert and modify Microsoft document objects in a worksheet
  • Customise the Microsoft Office Excel environment using masks and validations   

Excel 2010 Intermediate Outline:


Lesson 1: Calculations, Datasets and Advanced Formulas

Apply Validations for Cell Ranges
Using a Named Range
Linking Data Across Multiple
Worksheets
Adding Financial and Text
Functions
Using If Functions

Analyse Data with
V and H Lookups


Lesson 2: Organising the Worksheet and Table Data

Create and Modify Tables
Format Tables
using the Format As Table Function

Using the Sort, Filter and SubTotal Features
Adding Advanced Functions to Calculate and Display Data


Lesson 3: Presenting Data Using Charts

Creating Simple and Advanced Charts
Edit Chart
Data
Using the Format Chart Features
Adding Styles to Charts


Lesson 4: Analysing Data Using PivotTables, Sparklines, and PivotCharts

Create a PivotTable Report
Analyse Data Using
Advanced PivotChart Tools

Adding Sparkline Charts to Excel Cells


Lesson 5: Inserting Graphic Objects

Insert and Modify Objects to an Excel Sheet
Draw and Modify Shapes
and SmartArt Graphics
Insert Linked Microsoft Documents such as MS Word and PowerPoint


Lesson 6: Customise and Develop the Excel Spreadsheet Environment  

Customise the Excel Spreadsheet
Customise
and Link Entire Workbooks
Develop Re-usable Excel Templates

 View Excel Advanced 2010 Outline

Excel 2010 Level 2 Outline.pdf Excel 2010 Level 2 Outline.pdf
Size : 176.27 Kb
Type : pdf