5.0 /5
(60)

59
Introduction
Prerequisites
If you don't have Excel installed and want a Microsoft 365 version
Excel Knowledge Overview
Download Excel files used in the course
Understanding the Excel Environment
Changing Settings in Excel Optios
Saving & Protecting Excel Workbooks
Navigating between Excel Worksheets
Navigating between Excel Workbooks
Intro to Copying & Pasting
Pasting with Options
Using the Paste Option Dialog Box
Pasting from the Clip Board Button
Replicating Worksheet data with Move or Copy tool
Intro to Find & Replace
Find & Replace Options
Find & Replace using * Wild Card
Find & Replace using ? Wild Card
Find & Replace based on Cell Format
Understanding Cells
Increasing Cell Size, Row/Column Height & Width
Understanding Excel Data Types
Dates are treated like Numbers
Intro to Cell Formatting
Intro to Cell Formatting (2)
Intro to Numbers Formatting
Customizing Numbers Formatting
Behavior of Text and Numbers Formatting
Customizing Date Formats
Cell Formatting Sample
Intro to Data Sorting
Basic Data Sorting
Sorting Data that has empty rows or columns
A better way to sort
More sorting options
Advanced Sorting options
Intro to Data Filtering
Clearing Filters & Using Search for Filtering
Filtering data based on rules
Using Advanced Filtering
Freeze Panes
Use Outlines for Expand/Collapsible Buttons
Intro to Autofill and Fill Series
Using Fill Dialog Box
Fill Series with Linear & Growth
Fill Series based on Trends
Using Flash Fill
Intro to Data Validation
Creating Dropdown Lists
Text to Different Columns with Delimiters
Text to Columns using Fixed Width
Introduction to Excel Formulas
Writing simple formulas with primitive values
Introduction to Excel Functions
How to use Functions in Excel
Adding up with SUM function
Using Autosum to save time
Using AVERAGE, MIN, MAX, LARGE and SMALL

5.0 /5
(60)

  • Avatar
    Ifeoluwapo
    (5)
    Great resource

    A perfect refresher course for me. Very succinct. Thanks

  • Avatar
    Ayuk
    (5)
    Excellent and Straight to the point

    The instructor used the illustrations well and went straight to the point.

  • Avatar
    Abdulqudus
    (5)
    The style

    Hearing a fellow Nigerian speak while I learn boosted my morale and I wish to have more of this to guide me to becoming a data analyst

  • Avatar
    Daniel
    (5)
    Microsoft Excel Basics

    You are an excellent teacher. Your explanation and teaching methods are always on point. It also follows a logical order. Thank you for such a course.

  • Avatar
    Olaseni
    (4)
    Highly Informative

    I have gained immensely in this aspect. I enjoy the way Ahmed Oyelowo teach. His pace is accurate and concise.

  • Avatar
    Oloyede
    (5)
    Great Class

    Just when I thought I knew the all basics Basics, Boooom!!! This course covers almost all that you need to build a good foundation. spot on!!!!

  • Avatar
    Uchenna
    (5)
    Awesome

    Learnt alot so far. Really helpful.

  • Avatar
    Johnson
    (5)
    Training Made Simple

    Ahmed made the course look simple. That builds my confidence to move to harder modules.

  • Avatar
    Olalekan
    (5)
    Excellently delivered

  • Avatar
    Raishabanu
    (5)
    Excellent Basics

    I am new to excel and this is friendly and easy learn for beginner

  • Avatar
    Morzooq
    (5)
    Awesome

    The teaching is self-explanatory

  • Avatar
    Adekunle
    (5)
    great

    inspiring

  • Avatar
    Adelowo
    (5)
    Superb

    This course is well-taught and explanatory. This is one of the best online courses I have seen. Kudos to the tutor.

  • Avatar
    Adekunle
    (5)
    Microsoft Excel Basics

    Easy to learn and understand

  • Avatar
    Oluwafisayomi
    (5)
    It has helped in making me understand the introductory aspect of Microsoft Excel, and the lectures are so easy to understand.

  • Avatar
    Imran
    (5)
    precisely understanding excel

    this course is best for beginners. sir Ahmed Lecture is very precise to understand excel.

  • Avatar
    Oladimeji
    (5)
    It makes computation of data easier

    It makes computation of data easier

  • Avatar
    Ridwan
    (5)
    Fantastic

    Simple and direct

  • Avatar
    Omonzee
    (5)
    Working with Data 1

    It was quite enlightening

  • Avatar
    Ahmed
    (5)
    Microsoft Excel Basics

    Awesome and quite insightful. Great work Ahmed

  • Avatar
    Stephen
    (5)
    Review

    Excellent tutor.

  • Avatar
    Sabria
    (5)
    Very Informative

    I enjoyed this course a lot. Although I'm pretty experienced in Excel, I still learned some valuable information.

  • Avatar
    Sanni
    (5)
    microsoft excel basics

    it is the best tutorial to understand the excel basis as a starter

  • Avatar
    Waheed
    (5)
    Intro & Simple Excel Operation

    This is excel made easy. I give it to you

  • Avatar
    Kehinde
    (5)
    Microsoft excel basics

    The course insightful and the lecturer is a great teacher

  • Avatar
    Saliu
    (5)
    Excellent

    It was so easy to understand.

  • Avatar
    Joshua
    (5)
    INSIGHTFUL AND WELL BROKEN DOWN

    I'm really enjoying this course!

  • Avatar
    ABDUL-AFEEZ ADEKUNLE
    (5)
    Its a nice course put together for we beginners

    Excellent

  • Avatar
    Omotolani
    (5)
    Ahmed is an excellent teacher

  • Avatar
    Theresa
    (5)
    excellent tutorial

    your style of teaching is top-notch. I have gained maximally from these set of tutorials

  • Avatar
    Oluwafemi
    (5)
    Intro & Simple Excel Operations

    Great

  • Avatar
    Adebayo
    (5)
    Microsoft Excel Basics

    Ahmed is really a teacher, a simplified and interesting one. When you enjoy a teacher, you enjoy the lesson.

  • Avatar
    a
    (5)
    Microsoft Excel Basics

    very insightful

  • Avatar
    Queen
    (5)
    Excellent intro

    Good to know those tiny hacks

  • Avatar
    Precious
    (5)
    Excellent

    This is a good cause for beginners in Excel. The tutor is thorough and took time to break it down

  • Avatar
    Oseghemelo
    (5)
    Excel Basics

    Simple and brief to understand

  • Avatar
    Sandra
    (5)
    Excellent

    Excellent

  • Avatar
    Ayodeji
    (5)
    Great Delivery

  • Avatar
    Chibuike
    (5)
    Beautiful

    A great class

  • Avatar
    Hussain
    (5)
    Microsoft Excel Basics

    The course content is well designed and carefully structured with lots of information, new tricks and tips. I've learned a whole lot and I recommend this course for anyone who wants to learn Excel from scratch

  • Avatar
    Oluwaleke
    (5)
    Awesome

    Awesome

  • Avatar
    Bashiru
    (5)
    Microsoft Excel Basics

    Very easy to understand

  • Avatar
    Adekemi Adebukola
    (5)
    Microsoft Excel Basics

  • Avatar
    Florence
    (5)
    Microsoft excel basic

    Very impressive

  • Avatar
    Sam
    (5)
    Excel Basics

    Well done. Great stuff

  • Avatar
    Oyeronke
    (5)
    Microsoft Excel Basics

    the course is detailed and well explained with hands-on experience

  • Avatar
    Vinay
    (5)
    Excellent

    Microsoft basics course helping me a lot to understand about the excel features. Thank you so much . please release lot more free courses

  • Avatar
    Aminat
    (5)
    Excel Functions

    I didn't know much about this before, but watching the video really add to my excel knowledge

  • Avatar
    John Felix
    (5)
    Microsoft Excel Basics

    I love the way concepts are illustrated.... The language is plain for a beginner to master

  • Avatar
    AmatulBaasit
    (5)
    Microsoft Excel Basics

    Very straight to the point and comprehensive

  • Avatar
    K S
    (5)
    Excel Basics

    Excellent learning from this course.

  • Avatar
    Frank
    (5)
    Awesome Delivery

    The courses were delivered in simple and understandable manner. Anyone can easily apply anything learnt.

  • Avatar
    Shedrack
    (5)
    Excellent

    Easy to understand

  • Avatar
    imoleayo
    (5)
    Perfect!

    This course makes everything seem super easy

  • Avatar
    simon
    (5)
    Awesome course i personally recommend for one to persue it

  • Avatar
    Oluwatosin
    (5)
    introduction to excel

    The session is so self-explanatory and detailed. I enjoyed every bit of the session and i followed through the process and practiced alongside

  • Avatar
    Emmanuel
    (5)
    It broaden my knowledge on Excel as a useful tool beyond its simplicity

    I have been able to learn extra, have a deep knowledge and enjoyed simplicity on the Ms Excel course.

  • Avatar
    Samuel
    (5)
    Excellent

    The course is a perfect one for all beginers

  • Avatar
    Maryam
    (5)
    Exceptional

    An exceptional refresher course

  • Avatar
    Nnamdi
    (5)
    Microsoft Excel Basics

    its was insightful

View More Reviews