Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Excel with Microsoft Excel

Name: Excel with Microsoft Excel
Rating: 4.5 (8 reviews)

Learn Microsoft Excel with Practical Scenarios

Created byMary Bajisma Ashiru

Last updated 7/2025

English

What you'll learn

Master essential Excel functions and formulas to perform data entry, cleaning, and analysis with speed and accuracy.
Build dynamic spreadsheets using tools like Data Validation, Conditional Formatting, and Pivot Tables for real-world business use.
Apply logic-based functions such as IF, IFS, COUNTIF, and nested formulas to solve complex problems.
Create charts and visual dashboards to communicate insights effectively with stakeholders.
Use Lookup functions like VLOOKUP, HLOOKUP, XLOOKUP, and INDEX and MATCH to retrieve data efficiently from large datasets.
Record and use Excel Macros to customize automation in Excel.

Course content

19 sections • 87 lectures • 9h 7m total length

WELCOME TO THE COURSE!1:25
Hello and welcome to the Excel with Microsoft Excel course!
My name is Mary Bajisma Ashiru, and I am the founder of Bajismalytics, a training platform focused on helping individuals break into the world of data analysis with practical, relatable guidance.
I am a Data Analysis Coach and Consultant, and I have trained multiple students and professionals, from complete beginners to people already working in corporate environments, helping them unlock the power of Excel for business, data analysis, and career growth.
I am proud to be the first Nigerian female instructor teaching Microsoft Excel on Udemy.
This course was created to make Excel feel simple, useful, and powerful, especially for beginners, career changers, and professionals who want to upskill.
With the practical lessons in this course, I will walk you through everything from formulas and functions to PivotTables, charts, dashboards, and real-world projects. Everything is broken down step by step, in a way that is easy to understand and apply immediately.
At Bajismalytics, we believe that data skills are for everyone, and this course is your gateway into that world.
If you are ready to transform the way you work with data, then you are in the right place.
Click Enroll Now, and I will see you inside the course.
GETTING FAMILIAR WITH SOME TERMINOLOGIES IN MICROSOFT EXCEL9:22
In this video, you will learn how to launch Microsoft Excel and know some terminologies used in Microsoft Excel. Download the Microsoft Excel Shortcut Navigation Guide specially designed for you to easily use Excel shortcuts.
HOW TO COPY, CUT, PASTE, UNDO, AND REDO6:57
In this video, you will learn how to copy, cut, paste, undo, and redo both manually and with shortcuts.
USING THE BOLD, ITALICS, AND UNDERLINE FEATURE2:57
In this video, you will learn how to use the bold, italics, and underline features in Microsoft Excel.
FONT AND FONT SIZE3:18
In this video, you will learn about font and font size in Microsoft Excel. Download the Excel practice file used in this lecture.
FONT AND FILL COLOR2:51
You will learn the magic of font color and fill color in this video.
AUTOFITTING COLUMN WIDTHS2:25
Learn how to automatically fit column widths that are not uniform. Download the Excel practice file used in this lecture and also the screenshot showing the Enable Editing feature.
AUTOFITTING ROW HEIGHTS0:59
Learn how to automatically fit row heights that are not uniform. Download the Excel practice file used in this lecture.
ADDING BORDERS TO A WORKSHEET4:05
In this lecture, you will learn the importance of using borders and how to use them.

NAVIGATING CELLS WITH SHORTCUT5:13
In this video, you will learn how to navigate cells with shortcut. Download the Excel practice file used in this lecture and also the video showing how to press the keys.
SAVING AN EXCEL WORKBOOK3:34
In this lecture, you will learn how to save an Excel workbook on your computer.
SAVING AN EXCEL WORKBOOK IN MULTIPLE LOCATIONS1:55
In this lecture, you will learn how to save an Excel workbook in multiple locations on your computer. Download the Excel practice file used in this lecture.

ALIGNMENT2:49
In this lecture, you will learn how to use the various alignment types and the one that is best practice for use.
INSERTING AND DELETING ROWS AND COLUMNS3:33
You will learn how to insert and delete rows and columns in Microsoft Excel in this lecture. Download the Excel practice file used in this lecture.
DATA TYPES 16:52
In this lecture, you will learn about the various data types in Excel and how to change data types.
DATA TYPES 22:07
In this lecture, you will learn about other data types in Microsoft Excel.
WRAPPING TEXT, MERGING AND CENTERING4:39
In this video, you will learn how to wrap texts and also merge and center texts for easy structuring.
CHECKING THE NUMBER OF ROWS IN YOUR DATA3:03
In this lecture, you will learn how to determine the number of rows your dataset has.
FIND & SELECT5:03
In this lecture, you will learn how to use the find and select feature which is useful to locate data and update records in your data. Download the Excel practice file used in this lecture.

FILTERING5:43
In this lecture, you will learn how to use the filter feature to filter your data across various types of filtering methods. Download the Excel practice file used in this lecture.
SORTING6:05
In this lecture, you will learn how to correctly sort your data in a way that will not change the structure of your data.
TRANSPOSING A TABLE1:52
In this lecture, you will learn how to transpose a table in Microsoft Excel from a vertical table to a horizontal table. Download the Excel practice file used in this lecture.

SERIES FILL3:24
In this lecture, you will learn how to use the series fill effectively.
AUTO FILL (1)6:11
In this lecture, you will learn how to use the auto fill feature to populate a column(s) based on a formula. Download the Excel practice file used in this lecture.
REMOVING A FORMULA IN MICROSOFT EXCEL3:27
In this lecture, you will learn how to remove formula from cell(s) in Microsoft Excel. Download the Excel practice file used in this lecture.
FLASH FILL3:41
In this lecture, you will learn how to use the flash fill feature to populate a column(s) based on a pattern. Download the Excel practice file used in this lecture.
AUTO FILL (2)4:33
In this lecture, you will learn how to use the auto fill feature to populate a row(s) based on a formula. Download the Excel practice file used in this lecture.

UPPER, LOWER, AND PROPER FUNCTION5:27
In this lecture, you will learn how to change the casing of texts to either upper, lower or proper case.
LEFT AND RIGHT FUNCTION5:00
In this lecture, you will learn how to extract texts or characters from a string using the left and right function.
CONCATENATE FUNCTION4:53
In this lecture, you will learn how to join two or more texts or strings together. Download the Excel practice file used in this lecture.
LEN FUNCTION3:38
In this lecture, you will learn how to calculate the length of a text or string in Microsoft Excel. Download the Excel practice file used in this lecture.
TRIM FUNCTION3:29
In this lecture, you will learn how to remove unwanted spaces from a text string. Download the Excel practice file used in this lecture and also the Excel file with the trimmed version.
MID FUNCTION2:32
In this lecture, you will learn how to extract a specific number of characters from a text string starting at a position you define.
FIND AND SEARCH FUNCTION3:02
In this lecture, you will learn how to locate the position of a text or character within a larger text.
IS FUNCTIONS7:19
In this lecture, you will learn how to use various IS functions to return true or false based on the function you use.
COUNTBLANK FUNCTION, IDENTIFYING AND REMOVING BLANKS8:34
In this lecture, you will learn how to identify and remove blank rows from your data.
RAND, RANDBETWEEN, AND TEXT FUNCTION5:15
In this lecture, you will learn how to generate random numbers and also format numbers to text in Microsoft Excel.

LARGE AND SMALL FUNCTION4:28
In this lecture, you will learn how to use the large and small function to determine the n-th largest or smallest value from a list of values where n represents the number you define.
MAX AND MIN FUNCTION3:50
In this lecture, you will learn how to determine the maximum and minimum number from a list of numbers.
SUM, AUTOSUM, AVERAGE, AND PRODUCT FUNCTION5:24
In this lecture, you will learn how to use some basic aggregate functions.
ROUND FUNCTION5:05
You will learn how to round up numbers in this video. Download the Excel practice file used in this lecture.
INT FUNCTION1:50
You will learn how to return the integer part of a number in this video. Download the Excel practice file used in this lecture.
MOD FUNCTION3:57
You will learn how to retrieve the remainder of a division in Microsoft Excel in this video.
MODE FUNCTION0:58
In this lecture, you will learn how to determine the most frequent occurring value from a list of values.

IF FUNCTION3:50
In this lecture, you will learn how to use the IF function for conditional logic.
MULTIPLE IF STATEMENT8:45
In this lecture, you will learn how to nest IF statements for multiple conditions.
MULTIPLE IF STATEMENT PRACTICAL SCENARIO6:23
This lecture is a practical scenario of using multiple IF statements. Download the Excel practice file used in this lecture.
SUMIF FUNCTION2:44
In this lecture, you will learn how to calculate total based on a condition.
SUMIFS FUNCTION3:56
In this lecture, you will learn how to calculate total based on multiple conditions.
AVEARGEIF FUNCTION2:09
In this lecture, you will learn how to calculate average based on a condition.
AVERAGEIFS FUNCTION3:05
In this lecture, you will learn how to calculate average based on multiple conditions.
COUNTIF FUNCTION1:48
In this lecture, you will learn how to get a count based on a condition.
COUNTIFS FUNCTION2:26
In this lecture, you will learn how to get a count based on multiple conditions.

TODAY AND NOW FUNCTION1:39
You will learn how to get the current date and current time in Microsoft Excel in this lecture.
DATE FUNCTION1:17
In this lecture, you will learn how to get the date from a year, month, and day in Microsoft Excel. Download the Excel practice file used in this lecture.
TIME FUNCTION1:36
In this lecture, you will learn how to get the time from an hour, minute, and second in Microsoft Excel.
YEAR, MONTH, AND DAY FUNCTION3:47
In this lecture, you will learn how to extract the year, month, or day from a date. Download the Excel practice file used in this lecture.
DAYS FUNCTION WITH PRACTICAL SCENARIO3:19
In this lecture, you will learn how to get the day difference between two dates and also apply it in a practical scenario.
TRAVEL TIME TASK4:42
In this lecture, you will be completing a task. Download the Excel practice file used in this lecture.

Requirements

No prior Microsoft Excel knowledge is required.
Have a laptop that Microsoft Excel can work on.
Microsoft Excel 2007-2024 or Microsoft 365 Excel should be installed on your computer to follow along with instructor lectures.
Please note: Downloaded videos are for personal use only. If you enjoy the content, support the community by not sharing the files outside Udemy.

Description

Are you ready to finally understand how Microsoft Excel really works? Whether you are completely new to Excel or someone looking to sharpen and organize your existing skills, this course, Excel with Microsoft Excel, will give you the confidence and competence to use Excel effectively in your academic, business, or professional work.

This course is a practical, beginner-friendly journey that takes you step by step through real Excel tasks. You will learn how to create clean, organized spreadsheets, perform data analysis using essential formulas, and make sense of numbers with charts and reports. The course covers commonly used functions such as SUM, AVERAGE, COUNTIF, IF statements, and introduces powerful tools like VLOOKUP, XLOOKUP, Data Validation, Conditional Formatting, and Pivot Tables.

You will also learn how to create templates with Excel Macros without needing to write complex VBA code. This makes your work faster, easier, and more professional.

By the end of this course, you will be able to:

Enter, clean, and format data for better clarity
Analyze and summarize large data sets efficiently
Apply Excel functions to solve real-world problems
Build professional reports and dynamic dashboards
Use charts to visualize data clearly
Create Excel templates using simple macros

This course is ideal for students, office workers, entrepreneurs, virtual assistants, and aspiring data analysts who want to use Excel to save time, improve productivity, and gain an edge in their careers.

You will have access to over 80 structured video lessons, downloadable Excel files for practice, and lifetime access to the course content. Whether you are preparing for a job, managing business data, or simply trying to improve your spreadsheet skills, this course will give you the confidence and skills to succeed.

Enroll now and take your Excel skills to the next level with Excel with Microsoft Excel.

Content Usage Disclaimer:

All course materials, including videos, templates, and downloadable resources are intended solely for the personal learning use of enrolled students.

Redistribution, uploading, or sharing of these materials without written permission from Bajismalytics is strictly prohibited and violates both Udemy’s Terms of Use and copyright laws.

We appreciate your honesty and support in helping us keep quality, affordable education accessible to all.

Who this course is for:

This Microsoft Excel course will take you from beginner to intermediate level with practical scenarios.
If you are looking to level up your Excel skills as a student, graduate, business owner, working professional or an entrepreneur, this is the perfect course for you.

Excel with Microsoft Excel

What you'll learn

Explore related topics

Course content

INTRODUCTION TO MICROSOFT EXCEL9 lectures • 34min

NAVIGATING CELLS WITH SHORTCUT AND SAVING AN EXCEL WORKBOOK3 lectures • 11min

SOME OTHER FEATURES ON THE HOME TAB7 lectures • 28min

SORTING, FILTERING, AND TRANSPOSING A TABLE3 lectures • 14min

THE FILL FAMILY5 lectures • 21min

FREEZING PANES AND THE VIEW TAB3 lectures • 10min

TEXT FUNCTIONS10 lectures • 49min

NUMERIC/AGGREGATE FUNCTIONS7 lectures • 26min

CONDITIONAL/LOGICAL FUNCTIONS AND CONDITIONAL TOTALS9 lectures • 35min

DATE FUNCTIONS6 lectures • 16min

Requirements

Description

Who this course is for: