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
Dynamic Array Formulas in Excel: The New Way to Work Faster

Dynamic Array Formulas in Excel: The New Way to Work Faster

by Peter Obikpe | Apr 1, 2026 | Microsoft Excel Articles

Older Excel formulas usually return one result in one cell. Dynamic Array formulas are different. They can return multiple results automatically into several cells. This is one of the biggest changes in modern Excel. Instead of copying formulas down row by row, one...
Named Ranges in Excel: The Secret to Cleaner and Easier Formulas

Named Ranges in Excel: The Secret to Cleaner and Easier Formulas

by Peter Obikpe | Apr 1, 2026 | Microsoft Excel Articles

Most Excel users write formulas using cell references such as A2, B15, or D20. As spreadsheets become larger, those references become difficult to understand. For example, compare these two formulas: =SUM(B2:B15) =SUM(Sales_Amount) The second formula is much easier to...
Stop Copying and Pasting: Use Power Query to Clean Excel Data Automatically

Stop Copying and Pasting: Use Power Query to Clean Excel Data Automatically

by Peter Obikpe | Apr 1, 2026 | Microsoft Excel Articles

Many Excel users still spend hours manually deleting blank rows, fixing dates, splitting names, and combining files. The problem is that these same cleaning tasks usually need to be repeated every time new data arrives. A smarter solution is to use Power Query in...
Power BI Field Parameters: Let Users Change Visuals Dynamically

Power BI Field Parameters: Let Users Change Visuals Dynamically

by Peter Obikpe | Apr 1, 2026 | Data Analysis

One of the newest and most powerful features in Power BI is Field Parameters. Most dashboards force users to view the same chart in the same way every time. Field Parameters allow users to choose what they want to see. Instead of creating separate visuals for every...
Power BI Dataflows: Build Reusable Data Pipelines Without Repeating Work

Power BI Dataflows: Build Reusable Data Pipelines Without Repeating Work

by Peter Obikpe | Apr 1, 2026 | Data Analysis

Many Power BI users import, clean, and transform the same data again and again in different reports. Over time, this creates duplicated effort, inconsistent calculations, and reports that become difficult to maintain. A smarter approach is to use Power BI Dataflows....
« 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)

  • 0
  • 2,973
  • 2,116
  • 50,544

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