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

Excel Data Validation

by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles

Data validation Data validation is very important in the sense that it helps us avoid mistakes that can be avoided. Let’s assume you are recording student exam marks and you know the minimum is 0 and the maximum is 100. You can take advantage of validation...

Setting the print area and printing (Print View) & Page Layout

by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles

The print area is the part of the worksheet that you would like to print out on paper. The quick and easy way of doing it is by using the following shortcut commands Ctrl + P You will get the following print preview. Press Esc button to exit print preview...

how to Format data in Microsoft Excel

by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles

We all love beautiful things don’t we? Formatting in Excel helps us achieve exactly that. We can make our spreadsheets more presentable. We will use the data in the arithmetic operations table. We will make the column names; Bold Align serial numbers to the left...

THE SCREEN LAYOUT

by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Word Tutorials and Articles

How to Add in Excel

by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles

S/N ARITHMETIC OPERATOR FIRST NUMBER SECOND NUMBER RESULT 1 Addition (+) 13 3 16 2 Subtraction (-) 21 9 12 3 Division (/) 33 12 2.75 4 Multiplication (*) 7 3 21 Let’s now use Microsoft excel to achieve the above results Create a folder on your computer in my...

Important Excel shortcuts

by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles

Ctrl + P used to open the print dialogue window Ctrl + N creates a new workbook Ctrl + S saves the current workbook Ctrl + C copy contents of current select Ctrl + V paste data from the clipboard SHIFT + F3 displays the function insert dialog window SHIFT + F11...
INTRODUCTION TO MICROSOFT EXCEL

INTRODUCTION TO MICROSOFT EXCEL

by Oluwaseun | Jun 21, 2019 | Articles and Short Tutorials, Microsoft Excel Articles

What is Microsoft Excel? Microsoft Excel is a spreadsheet program that is used to record and analyze numerical data. Think of a spreadsheet as a collection of columns and rows that form a table. Alphabetical letters are usually assigned to columns and numbers are...

Quick Access Toolbar

by Oluwaseun | Jun 17, 2019 | Articles and Short Tutorials, Microsoft Word Tutorials and Articles

The quick access toolbar is a customizable toolbar that contains commands that you may want to use. You can place the quick access toolbar above or below the ribbon.   To change the location of the quick access toolbar Click on the arrow at the end of the toolbar...

Menu

by Oluwaseun | Jun 17, 2019 | Articles and Short Tutorials, Microsoft Word Tutorials and Articles

MENUS Microsoft Word 2013 maintains the same menu system with Word 2007 and 2010. Recall that the office Button in word 2007 was replaced with FILE in word 2010.   You should remember this features as you work within  Word 2013 The Microsoft Office Button The...

HOW TO START A MICROSOFT WORD

by Oluwaseun | Jun 17, 2019 | Articles and Short Tutorials, Microsoft Word Tutorials and Articles

There are two ways to start a Microsoft Word; Double click on the Microsoft word icon on the desktop ( if available) Click on the start button→ ALL programs → Microsoft office 2013 → Word 2013   OR Click on Start Button → From the search box → Type Word 2013 →...
« 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
  • 262
  • 190
  • 47,833

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