Overview
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.
You will have 365 days to access to this course.
Audience
Anyone looking to expand their financial management skills using Microsoft Excel 2013.
Choose an offering for each one of the bundle components then click on 'Add To Cart' button below:
Advanced formats and layouts in Excel 2013 (79770239) - Online
Overview
Excel 2013 provides many advanced features to customize formats and layouts. Data can be customized to any format and adding a customized fill series can not only save you time, but help ensure consistency and accuracy in your work. Customizing cells, adding forms, and creating templates all help tailor your workbooks to your individual needs. Conditional formatting can also format ranges according to specific criteria. Finally, Excel provides tools to help create workbooks that are accessible and consider international audiences.
Objectives
- Create a custom data format in Excel 2013
- Create a custom fill series in Excel 2013
- Decide how to create a custom data format and fill series in Excel 2013
- Apply custom styles in Excel 2013
- Add form fields to a workbook and create a template in Excel 2013
- Add form fields to a workbook and create a template in Excel 2013
- Choose how to create a custom cell style and form control in Excel 2013
- Apply advanced conditional formatting in Excel 2013
- Apply advanced conditional formatting in Excel 2013
- Decide how to apply advanced conditional formatting and filtering in Excel 2013
- Check for accessibility issues in Excel 2013
- Decide how to provide accessibility in a workbook in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.
Offerings
There are no Offerings available for this course.
Advanced formulas and functions in Excel 2013 (79770227) - Online
Overview
The Excel 2013 function library includes a number of functions in the Date and time, Logical, and Lookup and reference categories that enables you to quickly complete tasks and analyze data. Date and time functions allow you to capture dates and times properly. This course covers date and time functions such as NOW, TODAY, DATE, and NETWORKDAYS. Logical and IF-type functions help you make decisions. This course covers IF, AND, OR, AVERAGEIFS, COUNTIFS, and SUMIFS. Lookup and reference functions allow you to perform table lookups to return required information about specific worksheet cells. This course covers lookup and reference functions such as LOOKUP, VLOOKUP, and HLOOKUP. Excel 2013 also provides tools to identify, trace, and troubleshoot errors.
Objectives
- Use date and time functions in Excel 2013
- Decide how to use date and time functions in Excel 2013
- Use logical functions in Excel 2013
- Choose the logical functions to use in Excel 2013
- Transpose data in Excel 2013
- Look up data with functions in Excel 2013
- Decide how to look up data with functions in Excel 2013
- Trace errors in Excel 2013
- Decide how to trace errors in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.
Offerings
There are no Offerings available for this course.
Creating and Customizing Visual Elements in Excel 2013 (79770195) - Online
Overview
Excel has more than just charts to offer in the way of visual presentation. Graphic tools such as pictures, shapes, SmartArt, WordArt, and screenshots are all ways to enhance the visual impact of documents that tend to be dominated by numbers and text. The course shows how to insert and edit shapes, text boxes, and pictures. We'll see how to add a SmartArt graphic and we'll demonstrate how to add watermarks to your spreadsheets. We'll also look at how you can use workbook themes to enhance the presentation of your data.
This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Objectives
- Add text boxes and shapes in Excel 2013
- Add a text box and shape in Excel 2013
- Insert a picture in Excel 2013
- Insert a SmartArt Graphic in Excel 2013
- Add and edit pictures and SmartArt in Excel 2013
- Apply a watermark in Excel 2013
- Change the workbook theme in Excel 2013
- Add a watermark and create a theme in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.
Offerings
There are no Offerings available for this course.
Data Search, Data Validation, and Macros in Excel 2013 (79770219) - Online
Overview
Excel 2013 provides time-saving tools to manage data, validate data, and automate repetitive tasks. You can import files, and add and adjust columns and rows, as well as edit workbook properties. Find and replace allows users to find and replace data, in a specific format, or within the worksheet or workbook. It also allows you to use wildcard characters to customize the search. Data validation can be applied to a cell or range to restrict the data being entered. You can put upper and lower limits, restrict the number of characters, put items in a list, or validate against other cells. You can also add error alerts and identify invalid data. This course will also introduce you to macros in Excel and show you how to automate repetitive tasks to make working in Excel easier.
Objectives
- Edit workbook properties in Excel 2013
- Change the row height and column width in Excel 2013
- Find and replace data in Excel 2013
- Decide how to find and replace data in Excel 2013
- Add basic data validation to a worksheet in Excel 2013
- Use advanced data validation in Excel 2013
- Decide how to use data validation in Excel 2013
- Run a macro in Excel 2013
- Create a macro in Excel 2013
- Decide how to record a macro in Excel 2013 and make it available on Quick Access Toolbar and ribbon
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.
Offerings
There are no Offerings available for this course.
Using Financial Functions and What-If Analysis in Excel 2013 - Online
Overview
Excel 2013 provides powerful financial functions and data-analysis tools that enable you to explore data and to make educated business decisions based on that data. Using financial functions, iterative calculations, and the Watch Window can help you make the make better financial decisions and ensure the calculations are accurate. This course will cover What-if Analysis which enables you to retrieve required results from formulas by determining the data the formula requires, forecast worksheet outcome models, and to see how changing values in formulas affect the formula results. These tools include Goal Seek, Scenario Manager, and Data Tables. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.Objectives
- Use financial functions in Excel 2013
- Enable iterative calculations in Excel 2013
- Decide how to use financial functions in Excel 2013
- Decide how to allow circular references in Excel 2013
- Add a watch to a cell in Excel 2013
- Decide how to watch cells in Excel 2013
- Use Goal Seek to find the input for a result in Excel 2013
- Compare scenarios with Scenario Manager in Excel 2013
- Create a data table in Excel 2013
- Decide how to use what-if analysis in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Using PivotTables, PivotCharts, and Advanced Charts in Excel 2013 (79770235)
Overview
One of the most powerful tools that Excel 2013 provides is the collection of PivotTables, PivotCharts, and PowerPivot. These tools allow you to 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 addition to these benefits, PowerPivot has the ability to handle huge amounts of data, quickly and easily. The course also shows how to create advanced chart elements, such as trend lines and dual axis.
This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.Objectives
- Using PivotTables, PivotCharts, and Advanced Charts in Excel 2013
- Create a PivotTable in Excel 2013
- Edit a PivotTable in Excel 2013
- Decide how to create a PivotTable in Excel 2013
- Create a PivotChart in Excel 2013
- Decide how to create a PivotChart in Excel 2013
- Use PowerPivot to create a PivotTable in Excel 2013
- Decide how to use PowerPivot in Excel 2013
- Use advanced chart features in Excel 2013
- Choose advanced elements to apply to charts in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.
Offerings
There are no Offerings available for this course.
Manipulating Data in Excel 2013 (Update Avail.)
Overview
Excel 2013 provides multiple features for organizing and managing data, including sorting and filtering tools that are essential to data analysis. Using data organization features, you can sort, filter, and group and outline data so that you can focus on its key parts. Properly arranged data using the commands in the Data tab allows you to present your data in a logical and easy to understand manner. This course explores organizing data in Excel 2013 using the built-in features. It also covers converting text to columns for easy of splitting text. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Objectives
- Sort data in Excel 2013
- Group data in Excel 2013
- Decide how to sort and group data in Excel 2013
- Filter data in Excel 2013
- Choose how to filter data in Excel 2013
- Convert text to columns in Excel 2013
- Decide how to convert text to columns in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Performing Calculations Using Functions in Excel 2013 (79770211) - Online
Overview
Excel 2013 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 basic concepts and terminology associated with formulas and functions. It also covers various ways of referring to cells and cell ranges and demonstrates how to use basic functions including logical and IF-type functions.
This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Objectives
- Create a basic formula in Excel 2013
- Reference cells in formulas in Excel 2013
- Create a named range in Excel 2013
- Reference cells and create a named range in Excel 2013
- Use basic functions in Excel 2013
- Decide the best way to use basic formulas and functions in Excel 2013
- Create formulas using basic logical functions in Excel 2013
- Create an IF-type formula in Excel 2013
- Decide how to create IF-type functions and nested formulas in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.
Offerings
There are no Offerings available for this course.
Presenting Data in Tables and Charts in Excel 2013 (79770187) - Online
Overview
Using the tables and charts features in Excel 2013, you can create attractive and well-organized representations of worksheet and workbook data. Both tables and charts can be easily inserted and customized. This course demonstrates how to effectively use and customize tables and charts in Excel 2013; it explores available table styles and chart types and the best use of each type. And the course shows how to change the different elements of a table or chart to provide an effective visualization of your data.
This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Objectives
- Create a table in Excel 2013
- Format a table and customise a table style in Excel 2013
- Decide how to create a table in Excel 2013
- Create a chart in Excel 2013
- Add elements to a chart in Excel 2013
- Change the appearance of a chart in Excel 2013
- Decide how to create a chart in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Presenting Data using Conditional Formatting in Excel 2013 (79770191)
Overview
Excel 2013 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. 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 are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. This course covers applying conditional formatting, creating custom rules, and creating basic and advanced sparklines.
This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Objectives
- Apply conditional formatting to a worksheet in Excel 2013
- Decide how to apply conditional formatting to a worksheet in Excel 2013
- Create custom conditional formatting rules in Excel 2013
- Choose the best way to customise conditional formatting rules in Excel 2013
- Create a basic sparkline in Excel 2013
- Create an advanced sparkline in Excel 2013
- Decide how to create and edit sparklines in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.
Offerings
There are no Offerings available for this course.