Description

Covering a wide range of advanced skills for Microsoft Excel 2013, such as creating and visualising elements, advanced formats, layouts, formulas and function and more, this selection of courses for financial management will take your analysis, reporting and presentations to a higher level. This comprehensive 10 pack is designed to deliver advanced skills using Microsoft Excel 2013.

Pack inclusions:

  • Creating and customising Visual Elements in Excel 2013
  • Advanced formats and layouts in Excel 2013
  • Advanced formulas and functions in Excel 2013
  • Using financial functions and What-If Analysis in Excel 2013
  • Using PivotTables, PivotCharts and Advanced Charts in Excel 2013
  • Manipulating data in Excel 2013
  • Data search, data validation and macros in Excel 2013
  • Presenting data using conditional formatting and sparklines in Excel 2013
  • Presenting data in tables and charts in Excel 2013
  • Performing calculations using functions in Excel 2013

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 2013. 

Creating and Customizing Visual Elements in Excel 2013

Master the skills of using visual elements in Excel 2013

Offerings

Name
Creating and customising visual elements in Excel 2013 (41370999) - Online

Data Search, Data Validation, and Macros in Excel 2013

Master the skills of data search, validation and macros in Excel 2013

Offerings

Name
Data search, data validation, and macros in Excel 2013 (41371011) - Online

Manipulating Data in Excel 2013

Learn the skills to organise data using built in features in Excel 2013

Offerings

Name
Manipulating data in Excel 2013 (41371007) - Online

Performing Calculations Using Functions in Excel 2013

An introduction to the basic concepts and terminology associated with formulas and functions.

Offerings

Name
Performing calculations using functions in Excel 2013 (41371035) - Online

Presenting Data in Tables and Charts in Excel 2013

Learn how to effectively use and customise tables and charts in Excel 2013.

Offerings

Name
Presenting data in tables and charts in Excel 2013 (41371039) - Online

Presenting Data using Conditional Formatting and Sparklines in Excel 2013

Learn how to apply conditional formatting, creating custom rules, and creating basic and advanced sparklines.

Offerings

Name
Presenting data using conditional formatting and sparklines in Excel 2013 (41371031) - Online

Advanced Formats and Layouts in Excel 2013

This course will give you an understanding on customising cells, adding forms, and creating templates to tailor your workbooks to your individual needs.

Offerings

Name
Advanced formats and layouts in Excel 2013 (41371047) - Online

Advanced Formulas and Functions in Excel 2013

Understand Excel 2013 function library including Date and time, Logical, and Lookup and reference categories to enable you to quickly complete tasks and analyse data.

Offerings

Name
Advanced formulas and functions in Excel 2013 (41371051) - Online

Using Financial Functions and What-If Analysis in Excel 2013

Understand how to use financial functions, iterative calculations, and the Watch Window to help you make better financial decisions and ensure the calculations are accurate.

Offerings

Name
Using financial functions and what-if analysis in Excel 2013 (41371055) - Online

Using PivotTables, PivotCharts, and Advanced Charts in Excel 2013

Learn how to create advanced chart elements, such as trend lines and dual axis.

Offerings

Name
Using PivotTables, PivotCharts, and advanced charts in Excel 2013 (41371059) - Online

Where appropriate, choose an offering for each course then click  

loading...