08033146625, 08092566265 training@ictacademy.com.ng
  • Facebook
  • X
  • Instagram
  • Facebook
  • X
  • Instagram
  • Gallery
  • About Us
    • Resources
      • IT Jobs
      • Articles
      • Tutorials
      • Software Download
      • Ebooks Downloads
      • Free ICT Seminars
      • Certificate Verification
    • Faculties
    • Go Social
    • Current Vacancies
    • Ex Student Employers
MEGATEK ICT ACADEMY
  • Upcoming Classes
  • Courses
    • Cybersecurity
    • Cloud Computing
    • Artificial Intelligence
    • DevOps
    • Digital Marketing
    • Building Information Modelling (BIM)
    • Computer Aided Design (CAD)
    • Programming (Coding)
    • Microsoft Office
    • Data Analysis
    • Data Science
    • Project Management
    • Software Development
    • Web Development
    • Product Design
    • Database Management and Admin
    • Mobile Apps Development
    • Branding/Graphics Design
    • Networking/Hardware
    • Machine Learning
    • Finance/Accounting
    • Oil & Gas
    • Business Analysis
  • Training
    • Corporate Training
    • Virtual Training
  • Events
    • Digital-Bootcamp-For-Women
    • 2nd ICT Quiz Competition for Public Primary Schools in Ikorodu
  • IT Certifications
  • Online Training
  • Articles
  • Gallery
  • Contact Us
  • LOGIN
Select Page
Clean Messy Data in Seconds: Mastering Power Query in Excel

Clean Messy Data in Seconds: Mastering Power Query in Excel

by Peter Obikpe | Mar 23, 2026 | Data Analysis, Microsoft Excel Articles

Working with messy data is one of the most common challenges in Excel. Datasets often come with issues such as duplicate rows, inconsistent formatting, missing values, and unnecessary columns. Cleaning this data manually can be time-consuming and error-prone. This is...
Stop Using VLOOKUP: Master INDEX and MATCH for Smarter Lookups in Excel

Stop Using VLOOKUP: Master INDEX and MATCH for Smarter Lookups in Excel

by Peter Obikpe | Mar 23, 2026 | Data Analysis, Microsoft Excel Articles

For many Excel users, VLOOKUP is the go-to function for searching data. While it is useful, it has several limitations that can make your spreadsheets inefficient and difficult to scale. This is where INDEX and MATCH come in. INDEX and MATCH provide a more flexible,...
Turn Your Data into Geography: How to Create Powerful Map Charts in Microsoft Excel

Turn Your Data into Geography: How to Create Powerful Map Charts in Microsoft Excel

by Peter Obikpe | Mar 7, 2026 | Data Analysis, Microsoft Excel Articles

Visualizing data geographically can reveal insights that ordinary tables and charts may not easily show. Microsoft Excel includes a powerful feature called Map Charts, which allows users to display location-based data on a map. With map charts, you can visualize...
Lock It Down: How to Password Protect Excel Sheets and Workbooks for Maximum Security

Lock It Down: How to Password Protect Excel Sheets and Workbooks for Maximum Security

by Peter Obikpe | Mar 7, 2026 | Microsoft Excel Articles

Microsoft Excel often contains sensitive information such as financial records, employee data, business reports, and confidential analysis. To prevent unauthorized access or accidental changes, Excel provides several password protection options. By password protecting...
Filter Excel Data Like a Data Analyst: Master the Filtering Feature in Minutes

Filter Excel Data Like a Data Analyst: Master the Filtering Feature in Minutes

by Peter Obikpe | Mar 7, 2026 | Data Analysis, Microsoft Excel Articles

When working with large datasets in Microsoft Excel, finding specific information quickly can become difficult. This is where Filtering becomes extremely useful. Filtering allows users to display only the data that meets specific criteria while hiding the rest....
The Ultimate Guide to Excel Worksheets: Organizing Your Data Like a Pro

The Ultimate Guide to Excel Worksheets: Organizing Your Data Like a Pro

by Peter Obikpe | Mar 7, 2026 | Microsoft Excel Articles

Microsoft Excel is one of the most powerful tools for organizing, analyzing, and managing data. At the heart of Excel lies the worksheet, which serves as the primary workspace where all data operations occur. Understanding worksheets is essential for anyone who wants...
« Older Entries
Next Entries »

CHOOSE A COOURSE

MICROSOFT PROJECT
ORACLE PRIMAVERA P6
AUTOCAD 2D / 3D
ARCHITECTURAL DESIGNER PRO
AUTOCAD PLANT 3D
AUTOCAD P & ID
AUTOCAD CIVIL 3D
AUTOCAD ELECTRICAL
AUTOCAD MECHANICAL
ARCHICAD
AUTODESK INVENTOR
SOLIDWORKS
REVIT ARCHITECTURE
REVIT MEP (Mech,Elect&Plumbing)
REVIT STRUCTURE
3Ds MAX
Comptia A+
Comptia N+
CCNA
ORACLE DATABASE 12C (OCA)
INFORMATION TECHNOLOGY
DESKTOP PUBLISHING
DATA PROCESSING
GRAPHICS DESIGN
DIGITAL MARKETING
ADVANCED EXCEL
SPSS
MICROSOFT OFFICE SUITE
VIDEO EDITING
WEB DESIGN

TUTORIALS

Articles

  • 3dsmax Articles (3)
  • AI Articles (11)
  • Articles and Short Tutorials (323)
  • Autocad Articles (34)
  • Autodesk Inventor Articles (4)
  • Chief Architect Articles (1)
  • Cloud Services Artiles (4)
  • Computer Repairs (Comptia A+) Articles (11)
  • Cybersecurity Articles (11)
  • Data Analysis (48)
  • Data Science (11)
  • Deep Learning Articles (3)
  • Digital Marketing Articles (11)
  • Dynamo Articles (6)
  • Events (1)
  • Graphics Design Articles (33)
  • Information Technology Articles (55)
  • Latest ICT JOBS (81)
  • Microsoft Access Articles (1)
  • Microsoft Excel Articles (75)
  • Microsoft Picture Manager Articles (10)
  • Microsoft Powerpoint Articles (59)
  • Microsoft Project Tutorials and Articles (17)
  • Microsoft Word Tutorials and Articles (35)
  • Mysql Database Articles (12)
  • News and Events (36)
  • Project Management Tutorials and Articles (177)
  • Python (11)
  • Revit Architecture Articles (6)
  • Seminars and Training (1)
  • Structural Analysis Articles (1)
  • Trends (42)
  • Upcoming Classes and Events (41)
  • Web Design Tutorials and Articles (87)

  • 1
  • 1,816
  • 1,463
  • 48,452

Quick Links

Corporate Training

Online Training

Physical Classroom Training

Virtual Training

Faculties

Teaching Methodology

Gallery

Vacancies

Course Categories

Project Management

Computer Aided Design (CAD)

BIM

Data Analysis/Analytics

Software Development

Database Management

 

Course Categories

Mobile Apps Development

Web Development

Office Productivity

Branding/Graphics

HSE

Get In Touch

Email: training@ictacademy.com.ng

Phone:  08033146625, 08149363925, 08027217145, 08137214950, 08026596871

Lagos Island:  Suite 1F, Lapal House, 235 Igbosere Road, Opposite High Court, Onikan, Lagos Island, Lagos.

Ikeja: 1b, Akin Osiyemi Street, Allen Avenue,  Beside Item 7, First Bank Bus Stop, Ikeja.

Agege:   Suite B28, Primaltek Plaza, Opposite BRT Park, Pencinema, Agege.

Ikorodu – 90, Ayangburen Road, Opposite Cash and Carry, Ikorodu, Lagos State.

  • Facebook
  • X
  • Instagram
Megatek Ict Academy@ 2011 - 2027.......Lagos Island -Suite 1F, Lapal House, 235 Igbosere Road, Opposite High Court, Onikan, Lagos Island ........Ikeja - 1b, Akin Osiyemi Street, Allen Avenue, Ikeja..........Agege - B28, Primaltek Plaza, PenCinema, Agege, Lagos State...........Ikorodu - 90, Ayangburen Road, opposite Cash and Carry, Ikorodu, Lagos State.

WhatsApp us now