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
Ifeoluwapo
Great resource
A perfect refresher course for me. Very succinct. Thanks
Ayuk
Excellent and Straight to the point
The instructor used the illustrations well and went straight to the point.
Abdulqudus
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
Daniel
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.
Olaseni
Highly Informative
I have gained immensely in this aspect. I enjoy the way Ahmed Oyelowo teach. His pace is accurate and concise.
Oloyede
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!!!!
Uchenna
Awesome
Learnt alot so far. Really helpful.
Johnson
Training Made Simple
Ahmed made the course look simple. That builds my confidence to move to harder modules.
Olalekan
Excellently delivered
Raishabanu
Excellent Basics
I am new to excel and this is friendly and easy learn for beginner
Morzooq
Awesome
The teaching is self-explanatory
Adekunle
great
inspiring
Adelowo
Superb
This course is well-taught and explanatory. This is one of the best online courses I have seen. Kudos to the tutor.
Adekunle
Microsoft Excel Basics
Easy to learn and understand
Oluwafisayomi
It has helped in making me understand the introductory aspect of Microsoft Excel, and the lectures are so easy to understand.
Imran
precisely understanding excel
this course is best for beginners. sir Ahmed Lecture is very precise to understand excel.
Oladimeji
It makes computation of data easier
It makes computation of data easier
Ridwan
Fantastic
Simple and direct
Omonzee
Working with Data 1
It was quite enlightening
Ahmed
Microsoft Excel Basics
Awesome and quite insightful. Great work Ahmed
Stephen
Review
Excellent tutor.
Sabria
Very Informative
I enjoyed this course a lot. Although I'm pretty experienced in Excel, I still learned some valuable information.
Sanni
microsoft excel basics
it is the best tutorial to understand the excel basis as a starter
Waheed
Intro & Simple Excel Operation
This is excel made easy. I give it to you
Kehinde
Microsoft excel basics
The course insightful and the lecturer is a great teacher
Saliu
Excellent
It was so easy to understand.
Joshua
INSIGHTFUL AND WELL BROKEN DOWN
I'm really enjoying this course!
ABDUL-AFEEZ ADEKUNLE
Its a nice course put together for we beginners
Excellent
Omotolani
Ahmed is an excellent teacher
Theresa
excellent tutorial
your style of teaching is top-notch. I have gained maximally from these set of tutorials
Oluwafemi
Intro & Simple Excel Operations
Great
Adebayo
Microsoft Excel Basics
Ahmed is really a teacher, a simplified and interesting one. When you enjoy a teacher, you enjoy the lesson.
a
Microsoft Excel Basics
very insightful
Queen
Excellent intro
Good to know those tiny hacks
Precious
Excellent
This is a good cause for beginners in Excel. The tutor is thorough and took time to break it down
Oseghemelo
Excel Basics
Simple and brief to understand
Sandra
Excellent
Excellent
Ayodeji
Great Delivery
Chibuike
Beautiful
A great class
Hussain
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
Oluwaleke
Awesome
Awesome
Bashiru
Microsoft Excel Basics
Very easy to understand
Adekemi Adebukola
Microsoft Excel Basics
Florence
Microsoft excel basic
Very impressive
Sam
Excel Basics
Well done. Great stuff
Oyeronke
Microsoft Excel Basics
the course is detailed and well explained with hands-on experience
Vinay
Excellent
Microsoft basics course helping me a lot to understand about the excel features. Thank you so much . please release lot more free courses
Aminat
Excel Functions
I didn't know much about this before, but watching the video really add to my excel knowledge
John Felix
Microsoft Excel Basics
I love the way concepts are illustrated.... The language is plain for a beginner to master
AmatulBaasit
Microsoft Excel Basics
Very straight to the point and comprehensive
K S
Excel Basics
Excellent learning from this course.
Frank
Awesome Delivery
The courses were delivered in simple and understandable manner. Anyone can easily apply anything learnt.
Shedrack
Excellent
Easy to understand
imoleayo
Perfect!
This course makes everything seem super easy
simon
Awesome course i personally recommend for one to persue it
Oluwatosin
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
Emmanuel
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.
Samuel
Excellent
The course is a perfect one for all beginers
Maryam
Exceptional
An exceptional refresher course
Nnamdi
Microsoft Excel Basics
its was insightful