Unlock employee efficiency with our Microsoft Office training.
DO YOU HAVE ANY QUESTIONS?   (+27) 87 898 8824
/ info@nes-africa.com
Microsoft Office
Microsoft Office Applications
Microsoft Excel - Level 1 Essentials
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.
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
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
Trusted by
Recent Testimonials View all Testimonials
I found the Course “CONCISE Dashboard Reporting in EXCEL” facilitated by Valentine – was extremely professional and very beneficial.
Carl K.
Concise Dashboard Reporting in Excel
Enjoyed the course, especially some of the content which was technical and really relevant to the level of or interests of the delegates.
Mila VD.
HR Metrics & Analytics
The presenter was knowledgeable about the topics, well prepared for the sessions, enthusiastic and interested.
Sameera M.
Auditing HR Processes
The objectives for each topic were identified and followed. This will enable me to apply the knowledge I gained. Plus, participation and interaction were encouraged.
Jocelyn F.
Accounts Payable
Enjoyed the general knowledge being passed and relating the course to our own personal financial situation and how we can use these policies for personal gain.
Zeen C.
Accounts Payable
The training presenter was well prepared for the session, enthusiastic and interested. Plus the material was well organised.
Mcdonald R.
HR Metrics & Analytics
A very enjoyable course with lots of current anecdotes to illustrate the course material.
Kathy H.
Accounts Payable
The objectives for each topic were identified and followed. Shared experience – relevant to every day. Very good coverage and really enjoyed being at the event.
Cariena V.
Accounts Payable
The presenter was well prepared, and answered the questions in a complete and clear manner. The objectives for each topic were identified and followed.
Nshalati M.
Accounts Payable
I enjoyed all aspect of the course content due to their inter-relatedness, plus the presenter was very knowledgeable and experienced.
Reatile E.
HR Metrics & Analytics
The course was refreshing to reflect on key areas of Human Resource and measure where my organisation is in relation to the topics covered.
Mokwadi M.
HR Metrics & Analytics
Enjoyed the interactions, different perspectives offered and the opportunity to open the thoughts of strategic HR Metrics and Analytics thinking.
Juliette J.
HR Metrics & Analytics
The training met my expectations. The course objectives and content for each topic were identified, followed, organised and easy to follow.
Darsha S.
Mastering Sales & Marketing using Social Media Tools