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.
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.
Anyone looking to expand their skills using Microsoft 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.
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.
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.
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.
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.
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.
Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand.
This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency.
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.
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.
Where appropriate, choose an offering for each course then click