Font size:

Description:

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

Course Price
Automating Excel 2010 Tasks Using Macros $74.95
Analyzing Data with What-if Analysis in Excel 2010 $74.95
PivotTables and PivotCharts in Excel 2010 $74.95
PivotTable Filters, Calculations, and PowerPivot $74.95

Bundle Price: $169.00
Total Savings: $130.80


Automating Excel 2010 Tasks Using Macros

To automate repetitive tasks, Excel 2010 provides a time saving feature known as a macro. These small programs, created using either a simple macro recorder or by using the more complex VBA language, allow you to record the numerous steps involved in accomplishing a task so that they can be played back automatically when the macro is run. This results in time savings and increased efficiency in day-to-day tasks. This course will introduce you to macros in Excel and show you how to leverage their power to make you work with Excel easier.
  • identify the features of Excel 2010 macros
  • use the Macro Recorder to record and run a macro
  • identify the steps in recording a macro using the macro recorder
  • edit and delete macros
  • run a macro in different ways
  • prepare for recording a macro
  • record and run a macro
  • assign a macro to the developer tab on the Ribbon
  • add a macro the Quick Access Toolbar

Analyzing Data with What-if Analysis in Excel 2010

Excel 2010 provides powerful data-analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. And you can use additional what-if analysis components, data tables and scenarios, to forecast worksheet outcome models and to see how changing values in formulas affect the formula results.
  • use Goal Seek for data analysis
  • use Solver to perform data analysis
  • create scenarios using the Scenario Manager
  • manage Excel 2010 what-if scenarios
  • create a data table for what-if analysis
  • recognize how to project values in a series
  • use what-if analysis to find out how to achieve a desired result
  • use what-if analysis to determine the maximum or minimum value of one cell by changing other cells
  • use what-if analysis to forecast best-case and worst-case results
  • use what-if analysis to explore a possible set of outcomes at a glance

PivotTables and PivotCharts in Excel 2010

One of the most powerful tools that Excel 2010 provides is a PivotTable that allows you to dynamically reorganize and display your data. PivotTables can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. PivotTables also allow you to choose and change what you want to summarize, quickly and easily. This course will introduce you to PivotTables and show you the many benefits they provide.
  • create a PivotTable report
  • rearranging data in PivotTable reports
  • customize PivotTable reports
  • modify a PivotTable report's design
  • create a PivotChart
  • modify a PivotChart report
  • create a PivotTable report
  • customize a PivotTable report
  • create a PivotChart report

PivotTable Filters, Calculations, and PowerPivot

PivotTables are a handy tool for summarizing large amounts of data efficiently and making it more manageable. Sometimes, though, it's useful to be able to filter the data in a PivotTable, and Excel 2010 provides filtering functionality for this specific purpose. For those people who require a more visual representation of data, Excel 2010 provides a new feature called a Slicer, which is basically a graphical representation of a PivotTable filter. Excel also provides a number of ways in which you can apply calculations to the data in PivotTables in the form of summary functions and custom calculations. All of these useful features of Excel 2010 are introduced and described in this course.
  • use calculations in PivotTable reports
  • filter data in PivotTable reports
  • create and use slicers
  • identify the functions of elements of the PowerPivot interface
  • identify the features of PowerPivot for Excel add-in
  • change functions in PivotTable reports
  • create your own formula in a PivotTable report
  • enable multiple filters and apply a Report filter
  • use slicers to filter data in a PivotTable report
Register Now
Microsoft Office 2010: Advanced Excel Part 2 e-learning bundle
  • Course ID:
    252391
  • Duration:
    4 hours
  • Price:
    $169