Description

Explore the essentials of Microsoft Excel 2010 for finance and accounting professionals with this comprehenisve selection of courses including basic functions, formulas charts and data formatting, how to use conditional formatting tables and sparklines and more. This 10 pack of courses is designed to power up you skills in Microsoft Excel 2010.

Pack inclusions:

  • Getting started with Excel 2010
  • Using conditional formatting, tables and sparklines in Excel 2010
  • Using basic functions with Excel 2010
  • Using basic formulas in Excel 2010
  • Inserting basic charts in Excel 2010
  • Manipulating formulas and using forms in Excel 2010
  • Applying basic data formatting in Excel 2010
  • Moving and getting around in Excel 2010
  • Saving, Sending, and Printing Excel 2010 Workbooks
  • Reviewing and Protecting Content 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 skills using Microsoft Excel 2010. 

Applying Basic Data Formatting in Excel 2010

This course explores the processing of formatting cells and text, using tools such as the format painter and changing the way text is presented in order for it to be more visually appealing in Excel.

Offerings

Name
Applying basic data formatting in Excel 2010 (41370907) - Online

Getting Started with Excel 2010

This course explores the basics of Excel 2010, providing an introduction to the many tools that will help you create and use your spreadsheets productively.

Offerings

Name
Getting started with Excel 2010 (41370903) - Online

Manipulating Formulas and Using Forms in Excel 2010

This course discusses various statistical functions, including those designed to work with averages, determine the median, pinpoint rank, percentages, and sample populations. In addition, this course explores the available cube functions, and the methods for working with arrays.

Offerings

Name
Manipulating formulas and using forms in Excel 2010 (41370991) - Online

Moving and Getting Around in Excel 2010

This course will show you how to move around the Excel interface with ease, including using the various keys on the keyboard, such as the Home and End keys, and Ribbon commands.

Offerings

Name
Moving and getting around in Excel 2010 (41370911) - Online

Reviewing and Protecting Content in Excel 2010

Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools.

Offerings

Name
Reviewing and protecting content in Excel 2010 (41370927) - Online

Saving, Sending, and Printing Excel 2010 Workbooks

This course describes specific Excel features that allow you to easily collaborate with others. Explore how to use these features to increase your efficiency and productivity.

Offerings

Name
Saving, sending, and printing Excel 2010 workbooks (41370919) - Online

Using Conditional Formatting, Tables, and Sparklines in Excel 2010

Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand.

Offerings

Name
Using conditional formatting, tables, and sparklines in Excel 2010 (41370923) - Online

Using Basic Functions with Excel 2010

This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency.

Offerings

Name
Using basic functions with Excel 2010 (41370935) - Online

Using Basic Formulas in Excel 2010

This course introduces the concepts and terminology associated with formulas in Excel, and demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise.

Offerings

Name
Using basic formulas in Excel 2010 (41370931) - Online

Inserting Basic Charts in Excel 2010

This course demonstrates how to effectively use and customise charts in Excel 2010; it explores available chart types and the best use of each type; and shows how to change the different elements of a chart to provide an effective visualisation of your data.

Offerings

Name
Inserting basic charts in Excel 2010 (41370939) - Online

Where appropriate, choose an offering for each course then click  

loading...