• Please enter your name and surname above
  • Please enter your company name above
  • Section 1: Sharing and Maintaining Workbooks

    This objective may include but is not limited to: setting advanced properties, saving a workbook as a template, and importing and exporting XML data.
    This objective may include but is not limited to: protecting the current sheet, protecting the workbook structure, restricting permissions, and requiring a password to open a workbook.
    This objective may include but is not limited to: merging workbooks and setting Track Changes options.
  • Section 2: Applying Formulas and Functions

    This objective may include but is not limited to: tracing formula precedents, dependents, and errors, locating invalid data or formulas, and correcting errors in formulas.
    This objective may include but is not limited to: setting iterative calculation options and enabling or disabling automatic workbook calculation.
    This objective may include but is not limited to: using an array formula and using a SUMIFS function.
    This objective may include but is not limited to: finding and correcting errors in functions, applying arrays to functions, and using Statistical, Date and Time, Financial, Text, and Cube functions.
  • Section 3: Presenting Data Visually

    This objective may include but is not limited to: using Trend lines, Dual axes, chart templates, and Sparklines.
    This objective may include but is not limited to: using automated analysis tools and performing What-If analysis.
    This objective may include but is not limited to: manipulating PivotTable data and using the slicer to filter and segment your PivotTable data in multiple layers.
    This objective may include but is not limited to: creating, manipulating, and analyzing PivotChart data.
    This objective may include but is not limited to: choosing data sets from external data connections.
  • Section 4: Working with Macros and Forms

    This objective may include but is not limited to: running a macro, running a macro when a workbook is opened, running a macro when a button is clicked, recording an action macro, assigning a macro to a command button, creating a custom macro button on the Quick Access Toolbar, and applying modifications to a macro.
    This objective may include but is not limited to: inserting form controls and setting form properties.