Microsoft Excel Academy

Course ID
MEA
Level
Professional Development Programmes
Method
In-Person
LMS: OCN
In Person
N270,000
Live Online

Our Excel Academy is a week long professional proficiency course divided into two (2) stages; Basic & Intermediate Excel Stage and Advanced Excel Stage.

Excel is a spreadsheet program created by Microsoft. It features calculations, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications amongst others.

The first stage of this course is designed to give students an introduction to Microsoft Excel; it covers all the basic knowledge a student needs such as entering data, building organized workbooks, performing calculations and several simple functions, working with multiple worksheets, formatting the appearance of data and building charts and pivot tables for achieving impressive presentation and smart analysis.

 DateDuration
Face-to-FaceStarts March 11, 20245 days

It features calculations, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications amongst others.

The second stage is a more advanced class bothering on skills like relative, absolute and mixed references, relational, nested and compound IF functions, maths and statistical functions and advanced PIVOT table amongst others.

Financial modelling using the Excel Spreadsheet is applicable to almost all aspects of businesses using a variety of functions to construct likely future financial status of a given scenario or project. This is made possible by the ability of users to perform what-if-analysis, simulation, optimization, financial statements analyses, financial assets modelling, bankruptcy prediction etc.

Microsoft Excel is arguably the most popular and widely used spreadsheet application program for a vast range of business purposes. This programme gives students the opportunity to horn their skills in MS Excel from the introductory stage through to the intermediate and the advanced levels within a very short but proficient term.