Get in touch
Get in touch

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

  • Selecting and naming ranges
  • Using auto calculate
  • Using functions and formulas
  • Using auto sum and autofill
  • Using date & time functions
  • Using text functions
  • Using IF function

Module 2: Managing Workbook Information

  • Managing information
    • Clearing information
    • Deleting and inserting ranges
  • Moving and copying information
  • Copying formulas:
    • Understanding relative, absolute, and mixed formulas
    • Creating absolute and mixed references
    • Copying values only
    • Using autocomplete

Module 3: Working With Multiple Worksheets and Workbooks

  • Working across worksheets & workbooks
  • Working with multiple sheet formulas
  • Consolidating information
  • Linking information between workbooks
  • Working with large worksheets

Module 4: Working With Data in Lists

  • Understanding data lists
  • Creating and removing subtotals
  • Using data validation
  • Restricting cells to numbers/dates/times
  • Restricting cells to a list of values
  • Convert, sort, filter, and manage lists

Module 5: Using Illustrations in Excel

  • Working with clip art
  • Using shapes
  • Working with icons
  • Working with SmartArt

Module 6 : Working With Charts: Create and Modify Charts

  • Creating different chart
  • Modifying titles and labels
  • Modifying axes, gridlines, and legends
  • Working with data tables
  • Changing the data range
  • Working with data series
  • Deleting a chart

Module 7 : Conditional Formatting

  • Highlight cells rules
  • Top/bottom rules
  • Data bars, color scales, and icon sets
  • Adding your own formatting rules manually
  • Showing only one icon
  • Showing data bars and icons outside cells
  • Representing trends with icon sets
  • Building a legend for your conditional formatting

Our Partners

Phoenix
ILM
Certified MTA
PMI
MTA Learning

Welcome to our beta version!

We’re currently testing and improving our website before releasing the final version. 

As you explore, you may come across some bugs or areas that need improvement. 

We would love your help in reporting any issues you encounter via contact us page so we can make our site the best it can be. 

Thank you so much in advance,

HNI Team.