Description

Covering a wide range of advanced skills for Microsoft Excel 2010, such as customising visual elements, workbook setting, conditional formatting and number formats, organising data and objects, automating tasks using macros and more, this selection of courses for financial management you will take your analsis, reporting and presentations to a higher level. This comprehensive 10 pack is designed to deliver advanced skills using Microsoft Excel 2010.

Pack inclusions:

  • Customising visual elements in Excel 2010
  • Workbook settings, conditional formatting and number formats in Excel 2010
  • Organising data and objects in Excel 2010
  • Verifying Excel 2010 data and formulas
  • Automating Excel 2010 tasks using macros
  • Analysing data with What-If Analysis in Excel 2010
  • Adding visuals, themes, and styles to Excel workbooks
  • PivotTable filters, calculations, and PowerPivot
  • PivotTables and PivotCharts in Excel 2010
  • Using Lookup, Reference, Math and Text Functions in Excel 2010

These courses form part of the SkillsNet short course suite. Buy this SkillsNet value pack and save! 

You will have 365 days to access to this course.

Learning objectives

Audience

Anyone looking to expand their financial management skills using Microsoft Excel 2010. 

Adding Visuals, Themes, and Styles to Excel 2010 Workbooks

An introduction on how to change the themes and styles offered by Excel 2010.

Offerings

Name
Adding visuals, themes and styles to Excel 2010 workbooks (41370943) - Online

Analyzing Data with What-if Analysis in Excel 2010

Make educated business decisions with What-if Analysis in Excel 2010.

Offerings

Name
Analysing data with what-if analysis in Excel 2010 (41370967) - Online

Customizing Visual Elements in Excel 2010

Learn how to enhance your excel documents by using the right visual techniques.

Offerings

Name
Customising visual elements in Excel 2010 (41370947) - Online

PivotTable Filters, Calculations, and PowerPivot

Learn how to use PivotTable and filtering to summarise large amounts of data efficiently.

Offerings

Name
PivotTable filters, calculations, and PowerPivot (41370975) - Online

PivotTables and PivotCharts in Excel 2010

This course will introduce you to PivotTables and show you the many benefits they provide.

Offerings

Name
PivotTables and PivotCharts in Excel 2010 (41370971) - Online

Using Lookup, Reference, Math, and Text Functions in Excel 2010

This course explores rounding functions in Excel, and also provides a number of functions to make working with text easier.

Offerings

Name
Using lookup, reference, math, and text functions in Excel 2010 (41370987) - Online

Workbook Settings, Conditional Formatting, and Number Formats in Excel 2010

This course explores some of the more advanced ways that you can enhance your workbooks and data using Excel's powerful customisation features.

Offerings

Name
Workbook settings, conditional formatting, and number formats in Excel 2010 (41370951) - Online

Organizing Data and Objects in Excel 2010

Create better documents by using Excel 2010’s built-in features.

Offerings

Name
Organising data and objects in Excel 2010 (41370955) - Online

Verifying Excel 2010 Data and Formulas

Save time by learning the tools needed to audit formals and correct errors.

Offerings

Name
Verifying Excel 2010 data and formulas (41370959) - Online

Automating Excel 2010 Tasks Using Macros

Save time and increase efficiency in day-to-day tasks by Automating Excel 2010 Tasks Using Macros.

Offerings

Name
Automating Excel 2010 tasks using macros (41370963) - Online

Where appropriate, choose an offering for each course then click  

loading...