Intermediate Ms Excel

In-Person/Online

2 Days

English/Arabic

Learning Objectives

   Apply key excel functions and formulas.
   Change and customize the workbook appearance to optimize spreadsheets.
   Manage spreadsheets using filter and sort table data capabilities.
   Re-order and summarize data effectively.
   Use data from multiple sources.
   Perform data visualization using basic charts.

In-Person/Online

2 Days

English/Arabic

Learning Objectives

   Apply key excel functions and formulas.
   Change and customize the workbook appearance to optimize spreadsheets.
   Manage spreadsheets using filter and sort table data capabilities.
   Re-order and summarize data effectively.
   Use data from multiple sources.
   Perform data visualization using basic charts.

Modules

Module 1: Performing Calculations, Functions and Formulas

Module 2: Managing Workbook Information

Module 3: Working With Multiple Worksheets and Workbooks

Module 4: Working With Data in Lists

Module 5: Using Illustrations in Excel

Module 6 : Working With Charts: Create and Modify Charts

Module 7 : Conditional Formatting

Our Partners