Advanced Microsoft Excel Training Course

Advanced Microsoft Excel Course Contents

Excel Course Contents

• Manage workbook changesApply advanced conditional formatting and filtering

  • Track changes, manage comments, identify errors, troubleshoot with tracing, display all changes, retain all changes
  • Write custom conditional formats, use functions to format cells, create advanced filters, manage conditional formatting rules

• Prepare a workbook for internationalization and accessibility

  • Modify tab order among workbook elements and objects, display data in multiple international formats, modify worksheets for use with accessibility tools, utilize international symbols, manage multiple options for +Body and +Heading fonts

• Look up data with functions

  • Utilize the LOOKUP function, utilize the VLOOKUP function, utilize the HLOOKUP function, utilize the TRANSPOSE function

• Apply advanced date and time function

  • Utilize the NOW and TODAY functions, use functions to serialize dates and times

• Create advanced chart elements

  • Add trendlines to charts, create dual axis charts, create custom chart templates, view chart animations

• Create and manage PivotTables

  • Create new PivotTables, modify field selections and options, create a slicer, group records, utilize calculated fields, format data, utilize PowerPivot, manage relationships

• Manage multiple workbooks

  • Modify existing templates, merge multiple workbooks, manage versions of a workbook, copy styles from template to template, copy macros from workbook to workbook, link to external data

• Apply custom data formats

  • Create custom formats (Number, Time, Date), create custom accounting formats, use advanced Fill Series options

• Apply custom styles and templates

  • Create custom color formats, create and modify cell styles, create and modify custom templates, create form fields

• Apply functions in formulas

  • Utilize the IF function in conjunction with other functions, utilize AND/OR functions, utilize nested functions, utilize SUMIFS, AVERAGEIFS, and COUNTIFS functions

• Create scenarios

  • Utilize the watch window, consolidate data, enable iterative calculations, utilize What If analysis tools (including Goal Seek), utilize the Scenario Manager, use financial functions

• Create and manage PivotCharts

  • Create new PivotCharts, manipulate options in existing PivotCharts, apply styles to PivotCharts