Training

Microsoft Excel – Intermediate

Become more effective in your reporting processes. Gain useful data manipulation skills!

Microsoft Excel – Intermediate

Duration: 2 days | 12 hours

Available delivery methods:

Classroom

Become more effective in your reporting processes. Gain useful data manipulation skills!

Course Information

In this second course of our Microsoft Excel specialization, you will build on the strong foundations of the Essentials course. Here, you will discover a wide range of skills and techniques that will become a standard component of your everyday use of Excel. It will also build a solid foundation on the Advanced level of this specialization. These key techniques and tools will give you the ability to automate and improve efficiency to your everyday tasks in Excel.

This course is tailored for participants who perform regular analysis on business information like product/service performance, operational expenses, payroll/ wage processing, bank reconciliations, tracking employees’ information and expect exceptional figures and trends to be easily spotted as a basis for decisions (e.g. overdue invoices, sales over target, missing/ repeated records.

Key areas covered on the course include:

  • The use of $ for Cell referencing (locking formulas);
  • Useful data cleansing processes (comparing lists, identify & remove duplicates);
  • Testing specified conditions using logical functions (IF, Nested-IF and Ageing analysis);
  • Handling genuine errors result by use of IFERROR, ISERROR;
  • Using Text functions (LEFT, RIGHT, TRIM, CONCATENATE) to return the number of specified characters from a given text or join two/more text strings; Using the Flash-Fill feature;
  • Retrieving and reconciling data made easier by use of VLOOKUP, HLOOKUP;
  • Excel features to make powerful charts
  • Manipulating dates (MONTH, TODAY, WORKDAY, YEAR, DATE)
  • Control user input in a worksheet using Data Validation (drop-down lists, dates validation, etc.);
  • Consolidating data from multiple worksheets (by Position, by Category, using a Formula);
  • Summarizing data using PIVOT-TABLES;
  • Apply cell formatting using inbuilt Conditional Formatting.

Prerequisites

There are no formal prerequisites, but you should have Essential Excel skills.

What is Microsoft Excel?

Microsoft Excel is a spreadsheet program originally developed by Microsoft in the late 1980s. The industry standard spreadsheet for businesses all over the world, Excel allows the collection, processing and manipulation of data in a tabular format. Excel forms part of the Microsoft Office suite of software.

What’s included in this course?

2 days’ worth of Instructor-led, practical and interactive training, a course pack including all presentation slides, and a certificate.

 Learners taking this course are:

  • Economists
  • Accountants
  • Financial Analysts
  • Auditors
  • Customer Care Reps

What key skills will I gain in this course?

  • Pivot Chart
  • Pivot Table
  • Conditional formatting
  • Microsoft Excel

 Do you offer In-house corporate training?

We offer corporate trainings for a minimum number of 6 participant at your preferred venue.

Find out more


Or call us now
+254 20 222 95 66
+254 716 56 88 99
+254 732 56 88 99

 

Interested in our training courses?

Get 20% off!

...on select training bundles.

Our Best Selling Courses

Microsoft Excel - Essentials

Become more effective in your reporting processes. Gain useful data manipulation skills!

Advanced Analysis & Visualization in Excel

Make the process of “Data to Decisions” efficient and cost effective.

Analytics for Finance Professionals in Excel

Drive productivity, efficiency, transparency and lower risk as a Finance professional.

Advanced PowerPoint

For professional, engaging in presentations that yield results.

Microsoft Excel - Intermediate

Become more effective in your reporting processes. Gain useful data manipulation skills!

Report Automation with Excel VBA/Macros

Get ahead of others! Automate the mundane tasks and create stunning reports with greater flexibility.

Microsoft Power BI

Connect, Integrate, Model and Visualize Business Data Reliably!

Microsoft Excel - Advanced

Connect, Integrate, Analyze and Visualize data like a pro!

Advanced Excel + Financial Modelling & Forecasting in Excel

Efficiently build an effective and robust financial model based on real-world financial modelling challenges.

Data Analysis & Visualization in Power BI

Connect, Integrate, Model and Visualize Business Data Reliably!

R for Data Science

Python for Data Science

Are you ready to transform your business?

Contact Us

0716 56 88 99

Pin It on Pinterest