Microsoft Excel – Intermediate Level

Home » Programmes » Microsoft Excel – Intermediate Level

Duration: 2 Days

Face to Face

MQA Approved and HRDC Refundable

About the Ms. Excel - Intermediate Level

Training in Microsoft Excel Intermediate is an in-depth program to gain professional knowledge which is much needed in any office. Through hands-on training, participants will learn how to leverage Excel for data management, analysis, and reporting. The course aims to enhance participants’ professional efficiency and productivity by harnessing the full potential of this software applications.

The course will introduce you to advanced functions such as conditional mathematics, date and time functions, logical functions, text functions, and lookup functions.

This is a very effective and up-to-date method of delivering interactive training.

Enquiry

Short Course

Enquiry details

Consent(Required)
This field is for validation purposes and should be left unchanged.

Learning Outcomes

  • Understand the excel interface and navigation
  • Basic Data Entry techniques and formatting;
  • Apply formulas and functions;
  • Sorting and filtering of data;
  • Create Charts and Graphs;
  • Manage worksheets and workbook;
  • Apply mail merging;
  • Use cell ranges in functions
  • Analyzing data using pivot tables and pivot charts

Date and Duration

  • 21st & 28th September (2 days)
  • 2 tea breaks & lunch offered
  • Location: Honoris Campus, Highlands

Course Content

  1. Data Validation Basics
  2. Data validation for text data
  3. Using formulas in validation criteria
  1. Absolute referencing
  2. Named cells
  3. Named ranges
  1. Creating tables
  2. Modifying tables
  3. Sorting data in tables
  4. Filtering data in tables
  5. Structured referencing
  1. Introduction to conditional formatting
  2. Using built-in conditional formatting
  3. Custom conditional formatting
  4. Conditional formatting using formulas
  1. VLOOKUP
  2. HLOOKUP
  3. INDEX and MATCH
  4. XLOOKUP
  1. SUMIF
  2. AVERAGEIF
  3. Numeric criteria
  4. Date criteria
  5. COUNTIF
  6. SUMIFS
  7. AVERAGEIFS
  8. COUNTIFS
  1. Criteria for choosing a type of chart
  2. Creating bar and column charts
  3. Introduction to chart customization
  4. Customizing bar and column charts
  5. Creating and customizing line charts
  6. Creating and customizing pie charts
  7. Creating and customizing combo charts
  8. Creating and customizing sparklines
  1. Introduction to pivot tables
  2. Using automatic pivot tables
  3. Creating a pivot table from scratch
  4. Creating calculated fields in the pivot table
  5. Sorting and filtering pivot tables
  6. Customizing pivot table

Course Requirements

  • You should ideally have Beginner Level skills already, if you do not these skills please consider taking the Beginner Excel Course
  • Bring your own laptop

Benefits of the Intermediate Excel Course

  • Confidence in the use of Excel effectively at work
  • Work quickly because of this additional knowledge
  • User-friendly system to make you professionally effective with this software

Apply Now

Unleash Your Potential