Course Content
Microsoft Excel 2016 Advanced
    About Lesson

    After completing this course, participants will have learned to:

    Topic 1

    Automating Worksheet Functionality

    • Workbook Properties
    • Macros
    • Conditional Formatting
    • Data Validation

    Topic 2

    Auditing Worksheets

    • The Trace Cells Feature
    • Invalid Data
    • The Watch Window
    • Outlines

    Topic 3

    Analyzing and Presenting Data

    • Sparklines
    • Scenarios
    • Add-In Types
    • Analysis ToolPak
    • The Power View Add-In

    Topic 4

    Working with Multiple Workbooks

    • Data Consolidation
    • The Consolidate Dialog Box
    • Consolidation Functions
    • External References
    • The Compare and Merge Workbooks Feature

    Topic 5

    Exporting Excel Data

    • The Export Process
    • The Get External Data Group
    • Delimited Text Files
    • Methods of Importing Text Files
    • The File Publishing Process
    • Publish as Web Page Dialog Box
    • Web Queries
    • The New Web Query Dialog Box

    Topic 6

    Importing and Exporting XML Data

    • XML
    • XML Components
    • XML Schemas
    • XML Maps
    • The XML Source Task Pane
    • Import and Export XML Data