Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Sharing and Linking Data, and Adding Office Apps to Excel 2013 $74.95
Advanced Formulas and Functions in Excel 2013 $74.95
Reviewing and Protecting Content in Excel 2013 $74.95
Advanced Formats and Layouts in Excel 2013 $74.95
Using Financial Functions and What-If Analysis in Excel 2013 $74.95
Using PivotTables, PivotCharts, and Advanced Charts in Excel 2013 $74.95

Bundle Price: $219.00
Total Savings: $230.70


Sharing and Linking Data, and Adding Office Apps to Excel 2013

Excel 2013 provides tools to allow you to share workbooks, connect to external data, and add Office Apps. You can log into Office using an Office 365 Organizational ID or Microsoft account, allowing you to carry your personalized Office settings with you. You can add online services including SkyDrive and SharePoint storage, as well as Microsoft accounts to access and share your images and videos with social media sites. This course will show you how to link to external data including Access databases and other Excel workbooks. Finally, it will show you how to add Office Apps from the Office Store to extend the functionality of Excel, on demand. 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.
  • add a service to Excel 2013 so you can save workbooks online
  • save a workbook online with Excel 2013
  • decide how to share content with Excel 2013
  • connect a workbook to external data in Excel 2013
  • choose how to add an external data connection in Excel 2013.
  • add an Office app to Excel 2013
  • decide how to add an Office app in Excel 2013

Advanced Formulas and Functions in Excel 2013

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. 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.
  • 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

Reviewing and Protecting Content in Excel 2013

Excel 2013 provides tools that allow you to manage multiple workbooks as well review and protect them while creating and sharing content. You can consolidate data, control recalculation, merge and manage versions of a workbook. Excel also provides the track changes feature allowing you to track, accept, or reject changes. When reviewing comments, you can edit, add, or delete comments. In addition, the spell checker reviews the spelling and allows you to change, ignore, or add to the dictionary. Finally, Excel allows you to protect a range, worksheet, or workbook with a password. 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.
  • consolidate data and merge workbooks in Excel 2013
  • decide how to consolidate data in Excel 2013
  • choose how to merge workbooks in Excel 2013
  • use Track Changes in Excel 2013
  • add and edit comments in Excel 2013
  • spell check a workbook in Excel 2013
  • decide how to use comments and track changes in Excel 2013
  • protect sheets and workbooks in Excel 2013
  • choose how to protect workbooks in Excel 2013

Advanced Formats and Layouts in Excel 2013

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. 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.
  • 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

Using Financial Functions and What-If Analysis in Excel 2013

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.
  • 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

Using PivotTables, PivotCharts, and Advanced Charts in Excel 2013

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.
  • 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
Register Now
Microsoft Office 2013: Power User Excel e-learning bundle
  • Course ID:
    252371
  • Duration:
    5 hours
  • Price:
    $219