Microsoft Office

Unlock employee efficiency with our Microsoft Office training.

Microsoft Office Applications

Introduction

Excel is very much more than just a spreadsheet. In the very real sense of the word, Excel is a “number-cruncher”, the likes of which have only been equalled by Lotus 1-2-3 and which it has now surpassed. From humble beginnings, Excel has developed to become the spreadsheet everyone uses, be it simple home accounting to modular solutions in major corporations.

Prerequisites:

Use a mouse
Type and use a keyboard
Navigate through Windows files and folders
Work with Windows – minimise, maximise, open and close

Objectives
By the end of this course participants will be able to:

Create a basic worksheet by using Microsoft Office Excel.
Perform calculations in an Excel worksheet.
Modify an Excel worksheet.
Format a worksheet.
Print the content of an Excel workbook.
Manage an Excel workbook.

Microsoft Excel - Level 2 Data Analysis

Introduction

Excel has become very much more than just a simple spreadsheet. Although its roots are still in number management, today Excel’s uses cover a wide gamut – from simple data entry to complicated financial models and analysis.

A combination of practical demonstrations and peer teaching is applied for this course. Experiential learning approach is adopted where the learners will be required to consider the experience as a learning process joined with critical reflection which further qualifies for this theory to be applied for this course because at each segment, the learners are introduced to some form of experience after which they are asked to reflect on these experiences before sharing with each other and putting ideas into practice.

Objectives
Participants attending the programme will be to:

Use advanced formulas
Organise worksheet and table data using various techniques
Create and modify charts
Analyse data using PivotTables, Slicers, and PivotCharts
Insert and modify graphic objects in a worksheet
Customise and enhance workbooks and the Microsoft Office Excel environment

Microsoft Excel - Level 3 Advanced Features

Introduction

An often overlooked area of Excel is its power to derive answers from the data entered. This takes Excel out of the realm of a mere spreadsheet and into the realm of a “modeller”. The ability to build analytical solutions and conclusions.

Objectives

This course aims to empower existing Excel users who wish to take their skills further and venture into the areas of Data Modelling, Financial Expositions, Statistical Summaries and Scenario Management.

Microsoft Excel - Level 4 Dashboard Reporting

Introduction

Dashboards are very popular in the business today. They contain lots of information, sometimes dynamic, on one page, so that people have access to a vast array of information without the need to juggle between documents.

This highly acclaimed and informative course on Dashboard Reporting is one of the most required modern courses for corporate users of Microsoft Excel. Microsoft Office Excel is one of the best applications on the market for dashboard reporting, a technique that many Excel users may not be familiar with or know how to implement.

Objectives

Learn how to write reports that are easy to read and interpret.
Be able to build Dashboards that are quick and easy to update, in fact they can update themselves by pulling in data direct from your external database, Micro- soft Access, the web etc. at one click of a button if you set them up right.
Learn how to animate your charts with some simple VBA code.
Learn how to create reports that are fully interactive so the reader can change the view themselves; they can filter by product, time period or any parameter you choose, they can show and hide data using check boxes, drop down lists, and option buttons to name a few.

Microsoft Power BI

Introduction

Business intelligence (BI) is a term that has become increasingly common over recent years. Along with big data, data mining, predictive analytics, data science, and data stewards, BI is now very much part of business vocabulary. Much of the impetus behind this is the need for organizations to cope with ever-increasing datasets. It is now normal to have databases that contain millions of rows, requiring gigabytes, terabytes, or even petabytes, of storage space. Data is no longer confined to an on-premises server room – it is hosted in the cloud, feeds are taken from third-party providers, public datasets are freely available, and social media interactions generate ever-expanding datasets. Reporting and analysis is certainly not a new concept to business, but the difference between how data analysis is done today, compared with five or 10 years ago, is immense.

Data Analysis & Dashboard Reporting in Microsoft Excel

Introduction

Many of us struggle to make sense of all the data that is available in this information age. With such a deluge of reports and statistics which don’t mean anything or can’t be made sense of, it’s no wonder that data is often misinterpreted or not communicated at all. Learn how to synthesise information into a logical framework, summarise it into a meaningful format, and then display the summary into easy-to-read tables and graphs. Covering dashboard reporting, balanced scorecards, visual design of charts and tables.

Objectives

This course is very hands-on and practical. Each participant will be expected to create their own reports, charts and models utilizing the tools and techniques covered during the course.

By the end of the course, participants will:

Understand the principles of data analysis
Learn to synthesise and summarise information into a logical framework.
Consider when to use a chart or a table
Know how to use visual effects to improve their reports and presentations
Explore how to summarise, present and communicate data clearly and concisely
Learn the principles of good dashboard design and presenting data graphically
Discover the tools to analyse data & build reports using your existing Excel tools and skills (and perhaps a few you didn’t know you had).

Request for a Proposal

Request Now!

Course Details
Course Name*
Duration (days)*
Learners*
Start Date*
MM slash DD slash YYYY
End Date*
MM slash DD slash YYYY
Personal Details
Name*
Title First Last
Designation
Company*
Email*
Phone*
Address*
Street Address City Country
Name
This field is for validation purposes and should be left unchanged.

Microsoft Office

Microsoft Office Applications

Request for a Proposal

Course Details

Personal Details

Trusted by