1 - day course
Print this page
Course Code: S1M32en
Who should attend?
This course is intended for users who are familiar with Microsoft Excel desktop.
Prerequisites
Excel for Microsoft 365/2021 - Level 1
Course Objectives
Upon completion of the course, participants will be able to accomplish the following:
  • Organize, protect, display, and enter data using various tools.
  • Use the IF function, use the IFS function, create linking formulas, and manage links.
  • Manage and arrange multiple workbooks, insert and manage multiple worksheets within a workbook.
  • Create and modify charts to present data effectively; customize charts to enhance their appearance.
  • Create, apply and modify styles to format worksheets consistently and quickly; use notes, text boxes to annotate worksheets and sparklines to highlight and visually represent data.
  • Become familiar with basic macro techniques for recording, writing, running, and maintaining macros, as well as adding them to the Quick Access Toolbar.
Course Content  
    Worksheet Organization
    Managing Range Names ; Creating and Using Workbook Templates ; Applying Worksheet Security ; Creating and Using Outlines ; Working with Data Validation ;
    Advanced Formulas
    Using the IF Function ; Using the IFS Function ; Linking Formulas ; Modifying and Restoring Links ;
    Using Multiple Workbooks and Worksheets
    Working with Multiple Workbooks ; Working with Multiple Worksheets ;
    Working with Charts
    Creating Charts ; Changing Chart Data ; Modifying Chart Elements ; Creating Custom Charts ;
    Applying Formatting
    Working with Styles ; Annotating Worksheets ; Using Sparklines ;
    Supplemental - Macros Overview
    Planning Macros ; Recording Macros ; Executing Macros ; Maintaining Macros ; Code Security ; Adding Macros to the Quick Access Toolbar ; Modifying Quick Access Toolbar Buttons ;