Intermediate Excel course is tailored for participants who perform regular analysis on business information using Microsoft Excel. This includes business performance, operational expenses, payroll processing, bank reconciliations, tracking employees’ info, etc. The skills acquired enable the participant produce reports that make exceptional figures and trends to be easily spotted. Some trends that can be spotted are overdue invoices, sales over target, missing or repeated records etc. This enhances decision making.
This course addresses intermediate skills that expose the learner to data mining techniques that save countless hours.
Participants are expected to be able to:
- Use various techniques such as VLOOKUP and TEXT functions to manipulate data.
- Present data summaries (reports) visually through charts and conditional formatting.
- Use Pivot Tables to summarize large volumes of data.