Overview
Covering a wide range of advanced skills for Microsoft Excel 2016, this selection of courses for financial management will take your analysis, reporting and presentations to a higher level.
Pack inclusions:
- Microsoft Excel 2016 Essentials: formulas and functions
- Microsoft Excel 2016 Essentials: formatting data
- Microsoft Excel 2016 Essentials: charts, tables, and images
- Microsoft Office 2016 Intermediate Excel: PivotTables and advanced charts
- Microsoft Excel 2016 Advanced: Power Pivot, custom formatting, fills, and forms
- Microsoft Excel 2016 Essentials: data presentation strategies
- Microsoft Office 2016 Intermediate Excel: creating custom visual effects
- Microsoft Office 2016 Intermediate Excel: macros and advanced queries
- Microsoft Office 2016 Intermediate Excel: PivotTables and advanced charts
- Microsoft Office 2016 Intermediate Excel: working with data
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 financial management skills using Microsoft Excel 2016.
Choose an offering for each one of the bundle components then click on 'Add To Cart' button below:
Microsoft Excel 2016 Essentials: Data Presentation Strategies
Overview
Microsoft Excel 2016 gives you many options for improving the presentation of your data. In this course, you will learn about adding visual impact to your data using Sparklines, linking to different locations using hyperlinks, and creating custom formatting rules. You will learn about the many tools Excel 2016 provides for visually enhancing the appearance of your data.
Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Microsoft Excel 2016 Essentials: Formulas and Functions
Overview
Microsoft Excel 2016 allows you to perform complex calculations on your workbook data. Being able to use formulas to complete calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. In this course, you will learn about the basic concepts and terminology associated with formulas and functions. You will learn about the various ways of referring to cells and cell ranges, and how to use basic functions including logical and IF-type functions.
Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Microsoft Office 2016 Intermediate Excel: Creating Custom Visual Effects
Overview
A picture may paint a thousand words but Microsoft Excel 2016 makes adding both words and pictures to your workbooks very straightforward. In this course, you will learn how to insert and style text boxes, shapes, and SmartArt. You will also learn about applying and customizing themes and watermarks.
Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
Offerings
There are no Offerings available for this course.
Microsoft Office 2016 Intermediate Excel: Macros and Advanced Queries
Overview
Using macros in Excel 2016 lets you save time when performing repetitive tasks. This course covers the options available when you are running macros, and also how to create your own custom macros. You will also learn about advanced functions that allow you to perform calculations using date and time, how to look up data, and how to perform advanced conditional queries.
Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
Offerings
There are no Offerings available for this course.
Microsoft Office 2016 Intermediate Excel: Share, Review, and Collaborate
Overview
Microsoft Excel 2016 provides a number of tools that allow you to share your work with others, and collaborate on Excel projects. With your Microsoft account, you can access services that facilitate online collaboration, and link to data in other workbooks and even databases. In this course, you will also learn about reviewing Excel documents and how to convey your thoughts on a document to others.
Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
Offerings
There are no Offerings available for this course.
Microsoft Office 2016 Intermediate Excel: Working with Data
Overview
Microsoft Excel 2016 gives you a number of options for sorting and organizing data. In this course, you will learn about basic alphabetical and numerical sorts through color sorting and custom configured sorts. The course also covers grouping, filtering, searching, and ensuring valid data is entered.
Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016.
Offerings
There are no Offerings available for this course.
Microsoft Excel 2016 Essentials: Formatting Data
Overview
Making your data look good is easy in Microsoft Excel 2016. You can format numbers and text, and apply styles to make your data stand out. In this course, you will learn how to create custom formatting and styles, and copy formatting from cell to cell. In addition to formatting and styling data in Excel 2016, you will learn how to position the data in your spreadsheet.
Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Microsoft Excel 2016 Essentials: Charts, Tables, and Images
Overview
Using tables, charts, and images in Excel 2016, you can create attractive and well-organized representations of worksheet and workbook data. These elements can be easily inserted into your workbook and customized as necessary. In this course, you will learn how to effectively use and customize tables and charts in Excel 2016. You will also learn how to use headers and footers to add additional information to your work.
Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Microsoft Office 2016 Intermediate Excel: PivotTables and Advanced Charts
Overview
In Microsoft Excel 2016, PivotTables and PivotCharts let you dynamically reorganize and display your data. They can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. You can choose and change what you want to summarize. In this course, you will also learn how to use advanced chart features like trendlines and dual axis charts.
Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
Offerings
There are no Offerings available for this course.
Microsoft Excel 2016 Advanced: Power Pivot, Custom Formatting, Fills, and Forms
Overview
Using Power Pivot in Microsoft Excel 2016, you can pull together huge amounts of data from different sources and analyze it. In this course, you will learn how to use Power Pivot, which was formerly an add-in and is now a feature of Excel 2016. This course also covers the creation of custom and conditional formatting and filters, as well as custom fills.
Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel; and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
Offerings
There are no Offerings available for this course.