Microsoft Excel 2010 Level 2 œ Virtual Class

1 Day Course
Code VCEX10L2

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

In Microsoft Office Excel 2010: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2010 to streamline and enhance your spreadsheets with templates, charts, and formulas

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide all

Calculating Data with Advanced Formulas (5 topics)

  • Apply Cell Range Names
  • Calculate Data Across Worksheets
  • Use Specialised Functions
  • Analyse Data with Logical and Lookup Functions

Organising Worksheet and Table Data (5 topics)

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Worksheet or Table Data
  • Calculate Data in a Table or Worksheet

Presenting Data using Charts (4 topics)

  • Create a Chart
  • Modify Charts
  • Format Charts

Analysing Data using PivotTables, Slicers and PivotCharts (4 topics)

  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyse Data Using PivotChart

Customising and Enhancing Workbooks (4 topics)

  • Customise Workbooks
  • Manage Themes
  • Create and Use Templates

Prerequisites

Before attending this course, students must be able to: Create basic spreadsheets Select and edit data Perform basic formatting Open, close and save files Create basic formulas œ AutoSum Use Insert Function to create built-in functions Work with absolute references Use the AutoFill feature Browse the internet

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections