Microsoft Office Excel 2021

Course Length : 2 Days

Course Objectives: Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization

  • Get started with Microsoft Office Excel 2021.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.

Course Content

Lesson 1: Getting Started with Excel 2021 (5 Topics)

Lesson 2: Performing Calculations (3 Topics)

Lesson 3: Modifying a Worksheet (3 Topics)

Lesson 4: Formatting a Worksheet (6 Topics)

Lesson 5: Printing Workbooks (3 Topics)

Lesson 6: Managing Workbooks (3 Topics)

Course Length : 2 Days

Course Objectives : Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

    • Work with functions.
    • Work with lists.
    • Analyze data.
    • Visualize data with charts.
    • Use PivotTables and Pivot Charts.

Course Content :

Lesson 1: Working with Functions (9 Topics)

Lesson 2: Analyzing Data (3 Topics)

Lesson 3: Inserting Content Using Quick Parts (3 Topics)

Lesson 4: Visualizing Data with Charts (3 Topics)

Lesson 5: Using PivotTables and Pivot Charts (4 Topics)

    Course Length : 2 Days

    Course Objectives : Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

      • Work with multiple worksheets and workbooks.
      • Share and protect workbooks.
      • Automate workbook functionality.
      • Use Lookup functions, dynamic arrays, and formula auditing.
      • Forecast data.
      • Create sparklines and map data.

    Course Content :

    Lesson 1: Working with Multiple Worksheets and Workbooks (3 Topics)

    Lesson 2: Sharing and Protecting Workbooks (2 Topics)

    Lesson 3: Automating Workbook Functionality (3 Topics)

    Lesson 4: Using Lookup Functions, Dynamic Arrays, and Formula Auditing (4 Topics)

    Lesson 5: Forecasting Data(4 Topics)

    Lesson 6: Creating Sparklines and Mapping Data (2 Topics)