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
HOW TO DEFINE AND SOLVE A PROBLEM BY USING SOLVER ON MS EXCEL

HOW TO DEFINE AND SOLVE A PROBLEM BY USING SOLVER ON MS EXCEL

by Bashiru Adeitan | Nov 4, 2016 | Articles and Short Tutorials, Microsoft Excel Articles

  Good Morning. How was your night? Hope you are doing fine. Today, I will be teaching you how to define and solve a problem by using “Solver” on MS Excel. Hide All Solver is part of a suite of commands sometimes called what-if analysis (what-if analysis: A...
HOW TO DEFINE AND SOLVE A PROBLEM BY USING SOLVER ON MS EXCEL

HOW TO USE A FUNCTION IN A FORMULA ON MS EXCEL

by Bashiru Adeitan | Nov 2, 2016 | Articles and Short Tutorials, Microsoft Excel Articles

  Good Afternoon. How has been your day? Today, I will continue with the series on creating formulas using ms excel. On Monday (31st November, 2016), I exposed you to how to create formulas. In addition to entering formulas that perform basic math — such as...
HOW TO DEFINE AND SOLVE A PROBLEM BY USING SOLVER ON MS EXCEL

HOW TO APPLY DATA VALIDATION

by Bashiru Adeitan | Nov 2, 2016 | Articles and Short Tutorials, Microsoft Excel Articles

  Good Afternoon. How has been your day? Today, I will like to enlighten you something which some users of MS Excel have been experiencing difficult about. It is how to apply data validation.   What is Data Validation Used for? Hide All You use data...
HOW TO ENABLE OR DISABLE MACROS IN OFFICE FILES

HOW TO ENABLE OR DISABLE MACROS IN OFFICE FILES

by Bashiru Adeitan | Nov 2, 2016 | Articles and Short Tutorials, Microsoft Excel Articles

Good Morning. Hope you had nice night rest. Today, I will be taking on what is titled “How to enable and disable macros in office files”. I hope at the end of this you will have some reasonable and helpful to learn. A macro is a series of commands that you can use to...
HOW TO CREATE AN ORGANIZATION CHART USING MS EXCEL

HOW TO CREATE AN ORGANIZATION CHART USING MS EXCEL

by Bashiru Adeitan | Nov 1, 2016 | Articles and Short Tutorials, Microsoft Excel Articles

Good Afternoon. How has been your day? I will like to open your eyes to an aspect of powerpoint today. It is called organisation chart. You might have been wondering how people create their charts. You know what you too can do same with the help of Microsoft Excel....
HOW TO CREATE AN ORGANIZATION CHART USING MS EXCEL

HOW TO CREATE A FORMULA USING MICROSOFT EXCEL

by Bashiru Adeitan | Oct 31, 2016 | Articles and Short Tutorials, Microsoft Excel Articles

Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more. A formula always starts with an equal sign (=). Just as we have series of formulas in mathematics, physics, chemistry and the...
« 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)

  • 3
  • 57
  • 54
  • 47,628

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