Overview
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.
Audience
Anyone looking to expand their skills using Microsoft Excel 2010.
Choose an offering for each one of the bundle components then click on 'Add To Cart' button below:
Applying Basic Data Formatting in Excel 2010
Overview
Excel 2010 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. 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. This course also explains the various options for formatting numbers in Excel 2010.Objectives
- Apply basic text formatting
- Apply and copy cell formatting
- Recognise how alignment commands change the position of text
Audience
Individuals and business users with basic computer literacy
Offerings
There are no Offerings available for this course.
Getting Started with Excel 2010
Overview
Excel 2010 is the newest version of Microsoft's comprehensive spreadsheet tool that offers features that support a wide range of functions. The Ribbon menu is unique to Microsoft Office and stacks the many features of Excel into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all file-level tools, such as those used for saving, printing, and sharing your files. This course explores these topics and many other basics of Excel 2010, including opening the application, creating new spreadsheets, entering data and, AutoFill features. It also provides an introduction to the many tools that will help you create and use your spreadsheets productively.Objectives
- Identify the features of spreadsheets
- Recognise the functions of key Excel 2010 interface elements
- Create a new workbook
- Enter data in a given scenario
- Open a workbook based on an existing template
Audience
Individuals and business users with basic computer literacy
Offerings
There are no Offerings available for this course.
Manipulating Formulas and Using Forms in Excel 2010
Overview
Excel 2010 provides a large variety of statistical functions that allow you to perform data analysis on worksheet data, several cube functions that allow you to return information from cubes, and the means of working with arrays. In addition, using the Developer tab, you can further customize an Excel workbook to increase its functionality with form and ActiveX Controls. This courses discusses various statistical functions, include those designed to work with averages, determine the median, pinpoint rank and percentages, and sample populations. In addition, this course explores the available cube functions, such as CUBEMEMBER, CUBESET, and CUBEVALUE. Summarizing data using conditional functions such as SUMIF and COUNTIFS are also covered. This course also examines the methods Excel 2010 provides for working with arrays, including one-dimensional and two-dimensional arrays. Adding form and ActiveX Controls to Excel worksheets is also covered.Objectives
- Use statistical functions in Excel 2010
- Use conditional functions in Excel 2010
- Use array formulas in Excel 2010
- Use advanced Excel functions
- Add and edit ActiveX Controls in an Excel worksheet
Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Offerings
There are no Offerings available for this course.
Moving and Getting Around in Excel 2010
Overview
While it can look complicated and daunting, navigating the Excel interface isn't as difficult as it first appears. This course will show you how to move around the Excel interface using the various keys on the keyboard, such as the Home and End keys, and Ribbon commands. The course also covers the ways in which you can view and arrange workbooks and worksheets to be the most useful and shows you how you can access Excel's many Help features.Objectives
- Recognise how to navigate around Excel in a given scenario
- Discuss Excel commands
- Alter your view of the worksheet
Audience
Individuals and business users with basic computer literacy
Offerings
There are no Offerings available for this course.
Reviewing and Protecting Content in Excel 2010
Overview
Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The tools for performing these tasks are grouped conveniently on the Ribbon and include the Spelling, Research, and Thesaurus tools; a Translate tool; tools to insert, edit, and review Comments in a worksheet; and tools for tracking changes and protecting workbooks. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools.Objectives
- Use Excel's proofing tools
- Use the Excel comments feature
- Use track changes in Excel 2010
- Apply worksheet and workbook protection
Audience
Individuals and business users with basic computer literacy
Offerings
There are no Offerings available for this course.
Saving, Sending, and Printing Excel 2010 Workbooks
Overview
Excel 2010 makes it easy for you to save, print, and share workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it to save a hard copy or share with someone else. New features of Excel 2010 also allow you to easily collaborate with others by using the Sharing option in Backstage view. All of these options – saving, printing, and sharing – are grouped together on the File tab for convenience. This course describes these Excel features and explains how to use them to increase your efficiency and productivity.Objectives
- Save a workbook in a different format
- Change the default save options in Excel 2010
- Share and send a workbook
- Use the Page Setup settings to prepare a worksheet for printing
Audience
Individuals and business users with basic computer literacy
Offerings
There are no Offerings available for this course.
Using Conditional Formatting, Tables, and Sparklines in Excel 2010
Overview
Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Tables can be used to logically present data in an easy to read fashion and table styles provide a way to make your workbooks more attractive and professional looking. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines, a new feature of Excel 2010 are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. These features – tables, styles, conditional formatting, and sparklines – how to access them and how to use them, are covered in this course.Objectives
- Apply conditional formatting rules
- Use sparklines to show data trends
- Format sparklines
- Sort and filter table data
- Use conditional formats to highlight data
Audience
Individuals and business users with basic computer literacy
Offerings
There are no Offerings available for this course.
Using Basic Functions with Excel 2010
Overview
One of the great features of Excel 2010 is its ability to perform a wide variety of functions to make your use of Excel 2010 easier and more fun. Functions are inbuilt formulas that save you time by allowing you to choose one that suits your needs rather than having to create a complex formula from scratch. This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency as well as the changes made to some function names that make them more intuitive. It describes the useful feature of Excel's status bar that automatically displays basic calculations as well as the Function Library, which groups useful functions. The most common use of functions, calculating basic financial, logical, date and time data is also covered.Objectives
- Identify the characteristics of functions in Excel
- Perform basic calculations using Excel's most commonly used functions
- Use financial functions
- Use date and time functions
- Use logical functions to help perform calculations on worksheet data
Audience
Individuals and business users with basic computer literacy
Offerings
There are no Offerings available for this course.
Using Basic Formulas in Excel 2010
Overview
Excel 2010 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the concepts and terminology associated with formulas, and demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise.Objectives
- Identify elements of a formula
- Recognise how Excel calculates precedence in a formula
- Create and insert formulas
- Use names in formulas
- Correct common error values
- Define a name reference and use it in a formula
- Copy and paste a formula between cells
Audience
Individuals and business users with basic computer literacy
Offerings
There are no Offerings available for this course.
Inserting Basic Charts in Excel 2010
Overview
Using the charts feature in Excel 2010, you can create attractive and well-organized representations of worksheet and workbook data. Charts can be easily inserted and customized from the Charts group on the Insert tab of the Ribbon. This course demonstrates how to effectively use and customize 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 visualization of your data.Objectives
- Recognise when to use different Excel charts
- Insert a chart
- Identify the elements of an Excel chart
- Update an existing Excel chart's style, layout, or location
- Change the data range on which a chart is based
Audience
Individuals and business users with basic computer literacy
Offerings
There are no Offerings available for this course.
