Advanced Microsoft Excel 2019

Advanced Microsoft Excel 2019 Courseware (EXC2019.3)

Microsoft ExcelMicrosoftMicrosoft Office

This Advanced Microsoft Excel 2019 course will take you through the key functionalities of Microsoft Excel, from creating Pivot Tables, auditing worksheets, using various data tools, to recording and using macros. You will also learn how to work collaboratively and effectively with others, explore various random useful features, and understand how to harness the power of the cloud. Each module is accompanied by practical exercises to help consolidate your learning.

This is the updated version of 55270AC from the retired Microsoft Courseware Marketplace. Note that we a newer version that covers Excel 2021 and 365.

Publisher: Webucator

Benefits

  • Master the use of Pivot Tables and Pivot Charts, including creation, functionality enhancement, inserting slicers, and the multi-select option.
  • Develop skills to audit worksheets using tools such as Tracing Precedents, Tracing Dependents, and Show Formulas.
  • Enhance your data manipulation abilities with techniques like text to columns conversion, linking to external data, controlling calculation options, data validation, data consolidation, and goal seeking.
  • Discover effective ways to protect your work and collaborate with others, including protecting worksheets, workbooks, password protection, and marking a workbook as final.
  • Dive into the world of macros, learning how to record, run, edit and add them to the Quick Access Toolbar.
  • Explore various random yet useful features like Sparklines, Microsoft Translator, workbook internationalization, accessibility considerations, and importing/exporting files.
  • Understand how to utilize cloud services for storing and accessing your Excel files.
  • Gain hands-on experience through practical exercises, reinforcing the concepts and techniques covered in the course.

Outline

  1. Using Pivot Tables
    1. Creating Pivot Tables
    2. More PivotTable Functionality
    3. Inserting Slicers
    4. Multi-Select Option in Slicers
    5. PivotTable Enhancements
    6. Working with Pivot Tables
    7. Inserting Pivot Charts
    8. Working with Pivot Tables (exercise)
  2. Auditing Worksheets
    1. Tracing Precedents
    2. Tracing Precedents (exercise)
    3. Tracing Dependents
    4. Tracing Dependents (exercise)
    5. Showing Formulas
  3. Data Tools
    1. Converting Text to Columns
    2. Converting Text to Columns (exercise)
    3. Linking to External Data
    4. Controlling Calculation Options
    5. Data Validation
    6. Using Data Validation (exercise)
    7. Consolidating Data
    8. Consolidating Data (exercise)
    9. Goal Seek
    10. Using Goal Seek (exercise)
  4. Working with Others
    1. Protecting Worksheets and Workbooks
    2. Password Protecting a Workbook (exercise)
    3. Password Protecting a Worksheet (exercise)
    4. Password Protecting Ranges in a Worksheet (exercise)
    5. Marking a Workbook as Final
  5. Recording and Using Macros
    1. Recording Macros
    2. Recording a Macro (exercise)
    3. Running Macros
    4. Editing Macros
    5. Adding Macros to the Quick Access Toolbar
    6. Adding a Macro to the Quick Access Toolbar (exercise)
  6. Random Useful Items
    1. Sparklines
    2. Inserting and Customizing Sparklines (exercise)
    3. Using Microsoft Translator
    4. Preparing a Workbook for Internationalization and Accessibility
    5. Importing and Exporting Files
    6. Importing Text Files (exercise)
    7. Copying Data from Excel to Word (exercise)
    8. Copying Charts from Excel to Word (exercise)
  7. Cloud
    1. Using the Cloud
    2. Using the Cloud (exercise)

Required Prerequisites

  • Intermediate Excel Skills
License

Length: 1 day | $20.00 per copy

LicenseRequest More InformationDownload Sample CopyRequest Trainer Evaluation Copy
What is Included?
  • Student Manual
  • Student Class Files