Megatek Ict Academy

As we celebrate International Women’s Day 2026, we celebrate the young women learning, building, and innovating in technology.
At Megatek ICT Academy, we believe that when girls and young women gain access to digital skills, coding, and tech education, they gain the power to create solutions, lead industries, and shape the future.
To every young woman dreaming of a career in tech —
your ideas matter, your voice matters, and the future needs you.
Let’s raise a generation of fearless female innovators.
⅜

Happy new year

Welcome to 2026

This Basic to Advance Microsoft Excel training course is designed to help you understand how to create spreadsheets in Excel, format and print workbooks, navigate the Excel user interface, create basic calculation formulas and commands, clear, sort and filter data, visualize data work with charts and carry out complex task like VBA, PIVOT etc.

COURSE CONTENT

Getting Started with Microsoft Excel
Text editing, columns and row fitting
Data manipulation
Data Formatting
Ranges
Data Validation
Arranging your data
Creating & Manipulating Charts
Basic Functions and Formulas
Advanced Formulas & Functions
Logical: IF, AND, OR, IFERROR, Nested IFs, IFS.
Lookup & Reference: VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP, INDIRECT, CHOOSE.
Text: LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN, TRIM, PROPER.
Date & Time: DATEDIF, EOMONTH, WORKDAY, TODAY, NOW.
Financial: IRR, NPV, Loan Modeling.
Array Formulas: Using Ctrl+Shift+Enter for complex calculations.

Data Management & Analysis
PivotTables & PivotCharts: Summarizing, grouping, calculated fields/items, slicers.
Data Validation: Dropdown lists, custom rules, error alerts, dependency lists.
Conditional Formatting: Advanced rules, formula-based highlighting, icon sets, data bars.
What-If Analysis: Goal Seek, Scenario Manager, Data Tables.
Sorting & Filtering: Advanced filtering, custom sorts, Subtotals.
Power Query (Get & Transform Data): Importing, cleaning, and transforming data from multiple sources.

Automation & Efficiency
Macros & VBA: Recording/running macros, assigning to buttons, basic VBA for automation.
Named Ranges & Dynamic Ranges: Simplifying formulas.
Quick Access Toolbar & Ribbon Customization.

Visualization & Reporting
Charts: Advanced chart types (combo, trend lines), secondary axes, sparklines.
Dashboards: Creating interactive reports with charts, slicers, and tables.

Workbook & Data Security
Protecting: Worksheets, workbooks, formula visibility.
Linking & Consolidating Data across multiple workbooks.

Training Date - 12th and 13th December, 2025.
Time - 10am to 4pm

Fill the form here to register now https://ictacademy.com.ng/basic-intermediate-and-advance-microsoft-excel-training-in-lagos/

Training will hold in the following centers
* AGEGE
SUITE B28, PRIMATEK PLAZA, OPPOSITE BRT PART, AGEGE. 08137214950.
* IKEJA -
1b, AKIN OSIYEMI STREET, ALLEN AVENUE, IKEJA. 08149363925.
* IKORODU
90, AYANGBUREN ROAD, OJOGBEN JUNCTION, IKORODU, LAGOS. 08026596871
* LAGOS ISLAND
SUITE 115, BLOCK A6, SURA COMPLEX, SIMPSON STREET, LAGOS ISLAND. 08027218200.

Fill the form here to register now https://ictacademy.com.ng/basic-intermediate-and-advance-microsoft-excel-training-in-lagos/

Call 08033146625 for more details

Microsoft Excel Free Training In Ikeja, Lagos.

Microsoft Excel is one of today’s most powerful and versatile business tools, but if you’re not familiar with its basic functions, formulas, commands and keystrokes, you’re setting yourself up for frustration and disappointment.

This Microsoft Excel FREE training seminar gives you strong fundamentals to build on AND help you to BECOME A PRO IN USING MICROSOFT EXCEL WITHOUT STRESS.

The class will be taken by Industry experts who will simplify the learning process.

Course Outline:
Introduction to Microsoft Excel
Quick Access Toolbar
Working with Font
Working with Data
Working with Sheets
Creating Charts
Conditional Formatting
Working with Functions
Working with Tables
Data Tools in Excel
Excel Shortcuts
Creating Charts
Working with Charts
Basic Calculation in Excel
Project: Preparation of a School Broadsheet / Invoice

NOTE: REGISTRATION IS COMPULSORY.

To register, visit https://ictacademy.com.ng/seminars/free-microsoft-excel-training-seminar-in-lagos/

Date - Saturday, 28th November, 2025
Time - 10am
Venue - 1b, Akin Osiyemi Street, Allen Avenue, Beside Item 7, IKEJA.

It will be a great learning period, dont miss it

International collaboration loading.

Today, our CEO met with Representatives of a Tech company based in Spain. They came to our office to discuss partnership and collaborations with Megatek Ict Academy.

We look forward to delivering value to our students at an international level.

It's a great pleasure for Megatek Ict Academy to be chosen as a partner of this giant Tech Company.

Watch out as the events unfold

Send a message to learn more

Hip, Hip, Hip Hurray

Guess who just finished his training in our training center, it's one of our students.

Congratulations to Mustapha, he just finished his training in Ui/Ux, he is now a certified Product Designer.

He has mastered the use of lots of tools and now ready to display his talent out there

Yes, you can be like Mustapha

Enroll today and start learning so you can become a pro.

Courses available include:
Software Development
Data Science/Analytics
Mobile Apps Development
Ethical Hacking
Cybersecurity
Autocad
Digital Marketing
Full stack web development
Front End develipment
Project Management Professional
Prince 2
Desktop Publishing
Revit Architecture
Revit Structure
Revit Mep
Prota Structure
Interior design Software
3dsmax
Internet of things
Networking (Ccna)
Microsoft Office
Artificial Intelligence
Graphics Design
Database Management (Oracle)
Ui/Ux
Oracle Primavera
Microsoft Project
Advance Excel
Business Analysis
Cloud Computing
Dev ops

We are located at:
Ikeja: 1b, akin osiyemi street, first bank bus stop, allen avenue, ikeja
Lagos Island: Suite 115, Block A6, Sura Complex, Simpson Street, Lagos Island
Agege: Suite B28, primaltek plaza, pen cinema, Agege.
Ikorodu - 90 Ayangburen road, opposite Cash and carry, Ikorodu.

Call 08033146625 or visit www.ictacademy.cm.ng to register