user

About This Course

Microsoft Excel is a spreadsheet program included in Microsoft Office suite of applications. Spreadsheets will provide you with the values arranged in rows and columns that can be changed mathematically using both basic and complex arithmetic operations.

In addition to the standard spreadsheet features, Excel offers programming support via Microsoft’s Visual Basic for Applications (VBA), the ability to access data from external sources via Microsoft’s Dynamic Data Exchange (DDE).

Microsoft Excel was first released for Macintosh systems in the year 1985, followed by the first Windows version in 1987.

  • Learning Objectives

  • We train you to use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and excel formulas and streamline their operational work.
  • Students will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others.
  • Get individuals to leverage on Excel advanced functionality to simplify and streamline their day-to-day work
Enrol Now

Advance Microsoft Excel

Course Content

-Getting Started/Introduction to Excel Spreadsheet
-Selecting cells or ranges
-Modifying spreadsheets
-Merge or split cells
-Sort and filter functionality
-Formatting spreadsheets
-Working with Formulas in Excel
-Working with charts in excel
-Pivot Tables and Charts
-Other functions- if, ifelse, average, max, min, nested-if etc
-Spreadsheet modification,
-Advanced Table/Range Options
-Vlookup and HLookup
-Array Functions
-What if Analysis
-Macros and VBA
and many more..

Enrol Now

Have Questions? Let us know

Online Live Classes Available

You can now learn from your Home or offices with our Instructor-Led live online, interactive training on ICT and computer skills. Live Online classes feature all the same benefits of live instructor interaction while saving on travel time and cost. You can also have your classes recorded, which you can watch again for revision. All online classes include practical hands-on – all you need is internet access

Enrol Now
  • N 50,000.00
Enrol Now
  • Duration: 4 weeks
  • Language: English
  • Morning Session: 9am - 1pm
  • Afternoon Session:2pm - 5pm
  • Weekend:Available on Request

Other courses