MICROSOFT EXCEL – INTERMEDIATE LEVEL

By LIVE ONLINE PROGRAM

Date:

9 & 10 Aug 2022 (Every session 9am - 5pm)

Tue & Wed

Venue:

LIVE ZOOM

INTRODUCTION FOR MICROSOFT EXCEL – INTERMEDIATE LEVEL

In this course, you will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. You will also apply conditional formatting, outline with                subtotals and groups, display data graphically with charts and sparklines. Additionally, you will also understand PivotTables, PivotCharts, and slicers.

 

LEARNING OUTCOME FOR MICROSOFT EXCEL – INTERMEDIATE LEVEL:

  • Learn the building blocks of Intermediate Excel functionality
  • Link Workbooks and Worksheets
  • Work with Range Names and Sort and Filter Range Data
  • Analyze and Organize with Tables
  • Use Conditional Formatting and Display Data Graphically
  • Outline with Subtotals and Groups
  • Understand PivotTables, PivotCharts, and Slicers

 

FOR WHOM:

Those wishing to increase their knowledge of Excel to create more in-depth worksheets and improve the presentation of data.

 

REQUIREMENTS:

  • A working knowledge of creating/formatting simple spreadsheets, basic formulas and functions
  • Excel Introduction course or equivalent knowledge or experience.

 

COURSE CONTENT

1. Linking Workbooks and Worksheets

  •     Linking Workbooks and Worksheets
  •     Linking Worksheets with 3D References
  •     Understanding the Consolidate Feature

 

2. Working with Range Names

  •     Using the Name Box and Define Name
  •     Using Create from Selection

 

3. Sorting and Filtering Range Data

  •     Differences Between Sorting and Filtering
  •     Sorting Lists
  •     Filtering Lists
  •     Creating Subtotals

 

4. Analyzing and Organizing with Tables

  •     Creating Tables and Understand the Benefits
  •     Understanding the Elements of a Table
  •     Formatting a Table
  •     Sorting and Filtering Tables
  •     Filtering with Slicers
  •     Calculating with Tables

 

5. Using Conditional Formatting

  •     Highlight Cells and Top Bottom Rules
  •     Data Bars, Icon Sets, and Color Scales
  •     Using Custom Fonts and Colors
  •     Using Custom Conditional Formatting
  •     Modifying or Removing Conditional Formatting

 

6. Displaying Data Graphically

  •     Creating Charts
  •     Understanding Chart Elements
  •     Formatting Charts
  •     Creating Dual Axis Charts
  •     Creating a Chart Template
  •     Displaying Trends with Slicers

 

7. Understanding PivotTables, PivotCharts and Slicers

  •     Creating a PivotTable
  •     Working with PivotTable Fields Pane
  •     Formatting PivotTable
  •     Creating a PivotChart
  •     Formatting PivotChart
  •     Using Slicers and Timeline Slicers

For more information, please leave your enquiry!

Microsoft Excel -Intermediate Level

ENQUIRY form

    ORGANIZATION DETAILS





    PERSON-IN-CHARGE DETAILS



    FOR FURTHER INFORMATION, PLEASE CONTACT US!

    MICROSOFT EXCEL – INTERMEDIATE LEVEL

    By LIVE ONLINE PROGRAM

    Date:

    17 & 18 May 2022 (Every session 9am - 5pm)

    Tue & Wed

    Venue:

    LIVE ZOOM

    INTRODUCTION FOR MICROSOFT EXCEL – INTERMEDIATE LEVEL

    In this course, you will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. You will also apply conditional formatting, outline with                subtotals and groups, display data graphically with charts and sparklines. Additionally, you will also understand PivotTables, PivotCharts, and slicers.

     

    LEARNING OUTCOME FOR MICROSOFT EXCEL – INTERMEDIATE LEVEL:

    • Learn the building blocks of Intermediate Excel functionality
    • Link Workbooks and Worksheets
    • Work with Range Names and Sort and Filter Range Data
    • Analyze and Organize with Tables
    • Use Conditional Formatting and Display Data Graphically
    • Outline with Subtotals and Groups
    • Understand PivotTables, PivotCharts, and Slicers

     

    FOR WHOM:

    Those wishing to increase their knowledge of Excel to create more in-depth worksheets and improve the presentation of data.

     

    REQUIREMENTS:

    • A working knowledge of creating/formatting simple spreadsheets, basic formulas and functions
    • Excel Introduction course or equivalent knowledge or experience.

     

    COURSE CONTENT

    1. Linking Workbooks and Worksheets

    •     Linking Workbooks and Worksheets
    •     Linking Worksheets with 3D References
    •     Understanding the Consolidate Feature

     

    2. Working with Range Names

    •     Using the Name Box and Define Name
    •     Using Create from Selection

     

    3. Sorting and Filtering Range Data

    •     Differences Between Sorting and Filtering
    •     Sorting Lists
    •     Filtering Lists
    •     Creating Subtotals

     

    4. Analyzing and Organizing with Tables

    •     Creating Tables and Understand the Benefits
    •     Understanding the Elements of a Table
    •     Formatting a Table
    •     Sorting and Filtering Tables
    •     Filtering with Slicers
    •     Calculating with Tables

     

    5. Using Conditional Formatting

    •     Highlight Cells and Top Bottom Rules
    •     Data Bars, Icon Sets, and Color Scales
    •     Using Custom Fonts and Colors
    •     Using Custom Conditional Formatting
    •     Modifying or Removing Conditional Formatting

     

    6. Displaying Data Graphically

    •     Creating Charts
    •     Understanding Chart Elements
    •     Formatting Charts
    •     Creating Dual Axis Charts
    •     Creating a Chart Template
    •     Displaying Trends with Slicers

     

    7. Understanding PivotTables, PivotCharts and Slicers

    •     Creating a PivotTable
    •     Working with PivotTable Fields Pane
    •     Formatting PivotTable
    •     Creating a PivotChart
    •     Formatting PivotChart
    •     Using Slicers and Timeline Slicers

    For more information, please leave your enquiry!

    Microsoft Excel -Intermediate Level

    ENQUIRY form

      ORGANIZATION DETAILS





      PERSON-IN-CHARGE DETAILS



      FOR FURTHER INFORMATION, PLEASE CONTACT US!