Project Based Microsoft Excel Course For Beginners

The best course for everyone who is wants to learn Microsoft Excel 2016

Created byAsogwa Mark Okechukwu

Last updated 6/2022

English

English [Auto],

What you'll learn

At the end of this course you will make yourself more employable by different organizations
At the end of this course you should confidently embark on any Excel related projects
At the end of this course you will know all the basic things required of an Excel student
At the end of this course you should be able to build different project dashboards with Excel
At the end of this course you should be able to build personal budget template with Excel
At the end of this course you should be able to use Excel and track your monthly expenditure
At the nd of this course you should know how to use Excel and plan your daily, weekly, monthly and yearly budget

Course content

6 sections • 28 lectures • 2h 32m total length

Why Microsoft Excel is important for everyone5:10
Master Microsoft Excel as a versatile tool for organizing, analyzing, and storing data; learn budgeting, charts, templates, and automation to boost productivity for business owners and students.
How you can make the best from this course5:46
Discover four steps to maximize results from this project-based excel course for beginners: minimize distractions, prepare notes, practice with a budgeting dashboard project, and review lessons twice.

How to launch Microsoft Excel5:18
Learn to launch Microsoft Excel from the Windows start menu, navigate the welcome page and templates, and create a blank workbook while exploring open files, accounts, and version notes.
Understanding quick access toolbar2:59
Learn how to locate and customize the quick access toolbar in the Excel window, adding or removing commands to show the items you need.
Understanding Microsoft Excel windows4:31
Explore the Microsoft Excel windows by examining the menu bar, formula bar, and name box, and distinguish between workbooks and worksheets, including views and zoom controls.
How to save workbook3:54
Save workbooks confidently by using save and save as, choosing folders, and using keyboard shortcuts like Ctrl+S and Ctrl+Shift+S to manage saves.

How to create labels3:39
Learn how to create labels in Excel to explain data, rename sheets for clarity, and build a monthly expenditure exercise that tracks items and costs across months.
How to add numerical values4:39
Enter numerical values into cells and notice Excel automatically aligns numbers and currency; use the fill handle to drag and copy or extend values across adjacent cells.
Different ways to clear cell contents in Excel1:02
Discover multiple ways to clear cell contents in Excel by selecting cells, pressing delete, or using the clear command in the editing group.
How to display contents correctly in Excel4:13
Learn how to display cell contents correctly in Excel by adjusting alignment and text orientation, enabling wrap text, and resizing rows and columns via the Home ribbon.
Cell formatting7:46
Learn to format cells in Excel by adjusting alignment, setting font size and bold, changing fonts, adjusting row height, and applying currency formatting with decimal places.
The best way to center-align contents across multiple cells in Excel2:47
Learn to center contents across multiple cells in Excel by selecting the range, choosing the horizontal center alignment option, and applying it even when cells are merged.
Date formatting4:18
Learn how to format dates in Excel by converting month text to date values and applying month-year formats, so dates like July 2021 display correctly.
Order of operation in Excel5:44
Explore the order of operations in Excel, see how multiplication precedes division, and practice building formulas with equals signs to master arithmetic in spreadsheets.
Basic functions in Excel7:16
Learn basic Excel formulas: autosum totals and verify sums on the status bar. Compute total, average, min, max, and counts with direct entry or cell references.
SUM() function6:56
Learn how to use the SUM() function in Microsoft Excel to add numbers across a range, verify totals, and analyze monthly expenses by item for beginners.
Absolute and relative referencing in Excel7:26
learn to use the sum function and master relative and absolute referencing in Excel, using the fill handle and dollar signs to lock the grand total for accurate percentages.
MAX(), MIN(), AVG(), COUNT(), COUNTA() function7:35
Master max, min, average, count, and counta functions in Excel; learn to specify a range, interpret the results, and distinguish counting numbers from non-numeric entries.
AVG() function continue5:56
Explore how to use the avg() function in Excel, including how to divide by the correct cell count, handle empty cells, and reference ranges to calculate accurate averages.

SUMIF(), SUMIFS() function5:49
Learn to use sumif and sumifs to total school fees by class or gender, using sum ranges and the correct criteria.
COUNTIF(), COUNTIFS() function5:52
Explore countif and countifs in Excel to count students by subject and gender, counting non blank cells with criteria to dynamically track subject enrollment.
VLOOKUP() and error handling in VLOOKUP() functions10:21
Learn to use vlookup to fetch student name, class, and gender by id, specifying table range, column index, and exact match, and implement descriptive error handling for not found values.
HLOOKUP() function3:10
Explore HLOOKUP for horizontal lookups in Excel, using lookup value, table array, and row index number, and choose exact (0) or approximate (1) matches to return the desired data.
INDEX(), MATCH() function6:52
Explore how the index function returns the value at the intersection of a row and column, and pair it with match to locate positions for exact lookups.
Combination of INDEX() and MATCH() function8:07
Explore how to combine index and match to mimic a lookup, filtering student details by student ID and returning name, class, gender, and score with absolute references.

Requirements

No previous knowledge require.
It is for absolute beginners
Give your time, PC and internet connection to take this course

Description

What to expect:

If you have been looking for a suitable Excel course for a complete beginner, you have come to the right place.

This course has helped a lot of students kick-start their analytical skills, and I believe it will do the same for you. I poured out my heart into this course because I am not withholding any knowledge from you.

Course Contents

This course is made up of 5 sections and a duration of 2 hours 30 minutes.

Section 1: Introduction

From the scratch, you will be guided on how to customize your quick access toolbar to keep your tools handy and also made to understand the work interface.

Section 2: Getting Started with Excel

Here we start by showing you how to launch the program and as well explain the pre-made templates

Section 3: References and basic functions

Here we covered the basic functions and also explained the different methods of referencing cells.

Section 4 : Conditional Functions

Here we covered the very basics of conditional or logical functions in Excel that is foundational for advanced courses

Section 5: PivotTables

Here we introduced PivotTables how to create and modify PVT

I decided to bring up the course for beginners first because I believe in learning from scratch and gradually.

Who this course is for:

This course is for everyone who is eager to learn new things
It is for those interested in data analysis, accounting and management
It is necessary for everyone to take this course

Project Based Microsoft Excel Course For Beginners

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 11min

Understanding Microsoft Excel launching and interface4 lectures • 17min

Cell formatting, Numerical values, Referencing and Intro to Basic Functions13 lectures • 1hr 9min

Excel Conditional and Intermediate Functions6 lectures • 40min

How to Create PivotTables in Excel2 lectures • 15min

Congratulations1 lecture • 1min

Requirements

Description

Who this course is for: