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 Tips and trick : Learn MS Excel by making 7 Projects

Name: Excel Tips and trick : Learn MS Excel by making 7 Projects
Rating: 4.2 (922 reviews)

Boost your understanding of Microsoft Excel - Learn how to use MS Excel by creating over 7 simple Excel projects

Created byYassin Marco MBA

Last updated 2/2024

English

What you'll learn

Creating various Excel applications
Being able to use microsoft Excel for various simple tasks
Learning how to work with various Excel functions
Understanding how to use different tools with MS Excel

Course content

8 sections • 35 lectures • 6h 9m total length

Introduction6:55
practice-driven learning guides you through key microsoft excel functions and charts across ten projects, building real-life skills from basics to more complex tasks.
2- What is microsoft Excel10:29
Learn what Microsoft Excel is as an electronic spreadsheet app, and how it stores data, creates charts and dashboards, analyzes finances, forecasts stock prices, and automates tasks with macros.
3- The basics of microsoft Excel16:47
Explore the basics of Microsoft Excel, including the interface, workbooks, simple calculations, formatting, tables, charts, data imports, and the developer tab for macros.

4-Project 1 Part 14:28
Build two tables in Excel to track daily income, expenses, and sources for a month, using formulas and conditional formatting to color gains, losses, and zeros.
5-Project 1 Part 219:59
Build a beginner budgeting table in Excel with income and expenses, totals, and dates, using formulas like sum, max, min, and average; add sources and conditional formatting.
6-Project 1 Part 312:38
Extend an Excel project by adding income and expense sources with letter codes and generated data, then apply conditional formatting and organize in a table.
7-Project 1 Part 43:56
Master budget tracking in Excel by filtering incomes and expenses by date and source, view June's numbers, and paste values for clean data; this sets up future charts and calendars.

8-Project 2 Part 15:19
Create a calendar-based income and expenses tracker in Excel, building on project one, with daily totals, a win/loss function, conditional formatting, and a final chart to visualize income.
9-Project 2 Part 211:41
Import and organize data from the first project into a sheet to build a calendar-based dashboard in Excel, calculating income, expenses, and totals with sums and references across June dates.
10-Project 2 Part 319:10
Import data, fill the calendar with June dates, and create an auto-updating chart showing income, expenses, and total; apply text, if, and conditional formatting for clear insights.

11-Project 3 Part 15:39
Build an Excel employee schedule with a calendar scheduler to track hours, salaries, and daily and weekly expenses, distinguishing full-time and part-time staff using look up and if functions.
12-Project 3 Part 215:23
Learn how to build a simple five-employee schedule database in Excel, using VLOOKUP to auto populate names and salaries, track weekly hours and part-time or full-time status.
13-Project 3 Part 316:57
Generate random hours between 4 pm and 7 pm, determine part or full time, convert differences to hours by multiplying by 24, and compute salaries with a lookup.
14-Project 3 Part 45:36
Use lookup to fetch hours and totals from a table, then apply an if test to classify employees as full time or part time, with automatic updates.

15- Project 4 Part 18:02
Advance to project four by building an Excel dashboard that tracks employee expenses. Create per-employee databases linked to a calendar and add transport, food, and limits.
16-Project 4 Part 224:50
Create employee databases and a dashboard that summarize hours, transport, food, and overnight stays; link daily data to a master dashboard and apply limits for payments.
17-Project 4 Part 319:26
Learn to build an Excel dashboard by calculating total hours and weekly salary, then apply if functions to enforce daily limits on food, transport, and overnight stays.
18-Project 4 Part 411:45
Master Excel by building a complete dashboard that auto-fills daily spending with random numbers, applies limits, computes totals, and creates dollar-only charts for analysis.

19-Project 5 Part 15:46
Explore building a simulated stock in Excel for project 5, with random daily moves, candlestick charts, and basic analysis (max, min, mean, median) plus future price range projections.
20-Project 5 Part 216:22
Build a small stock simulation in Excel by creating a date table and calculating open, high, low, close, and daily change with random 1–3% moves.
21-Project 5 Part 314:50
Build an Excel stock-analysis table, compute max, min, and average price changes, lock opening prices, and create a candlestick chart to visualize monthly stock movement.
22-Project 5 Part 413:18
Explore how to use standard deviation in Excel to predict a stock's monthly price range by applying opening, closing, high, and low prices with a two-sigma spread.
23-Project 5 Part 56:36
Learn to use standard deviation to set February stock price ranges, applying 3x or 2x multipliers for 99% or 95% confidence, with updated data from the prior month.

24-Project 6 Part 17:29
Recreate a baccarat-style game in Excel to test a simple player or banker betting strategy across 100 trials, using random numbers and charted results to explore long-term outcomes.
25-Project 6 Part 221:58
Learn to program a baccarat game in Microsoft Excel by building dealer and banker logic, card values, sums, and draw rules using nested if and random functions.
26-Project 6 Part 314:23
Explore Excel project work by debugging sums and adding a bankroll calculator for player and banker bets, with absolute references and conditional formulas.
27-Project 6 Part 47:26
Explore building and testing an Excel betting calculator using if logic, 95 percent of bets, and bankroll tracking, then visualize results with charts for project 6.

28-Project 7 Part 15:15
Create a green book project for a class of 10 using Excel functions to manage grades, convert numbers to letters, build a database, and visualize results with charts.
29-Project 7 Part 217:48
Build a grade book in excel for ten students across subjects, using ran between to generate scores, weighted by 30, 25, and 45 percent, and map results to letter grades.
30-Project 7 Part 37:22
Create a simple student gradebook in Excel by listing student numbers and names, tracking six subjects, and computing highest, lowest, and average grades with cell references and borders.
31-Project 7 Part 45:34
Explore how to compute max, min, and average grades in Excel, and visualize results with charts to identify each student's strengths and weaknesses.
Conclusion5:21
Learn Microsoft Excel by building real projects and practicing budgeting, stock simulations, and other hands-on tasks for small business and daily use.
Thank you0:06
Thank you0:06
Bonus Lecture0:24

Requirements

Having a basic understanding of what MS Excel is
Wanting to learning about MS Excel
Having a computer
No practical experience needed

Description

Learning how to properly work with Microsoft can be very complicated espescially if you never worked with this applicaiton before. This is why, this course have been created, to help you learn how to work with Microsoft Excel and what are all the mazing things that you can do with this application. If you:

- Need to learn the basics of Microsoft Excel for work

- Always wanted to create various projects with this application

- Are currently in school and have to understand some Excel concepts

- are simply curious about this Microsoft App

Then you are definely at the right place and will probably love this course and everything that it has to offer. Indeed, not only you will learn and understand all the basic concepts and everything aroud the microsoft Excel application but you will have a lot of practice throught out this course. The goal here is that by the end of this course you have a solid and strong understand of how to use microsoft Excel in order to create your own basic applications that will allow you to do various things like the different projects that we will create in this course.

The structure of the course

The way this course have been built, is made to help you understand and learn everything you need to know about Java script. Indeed, you will understand all the basics of this programming language. From the starting point where you are going to learn how to use simple Excel buttons or how to open and save your current project to the more advanced part that contains things such as IF statement, lookups or various other excel functiosn and various practical projects, this course has everything you need to start your Microsoft Excel journey. Also, this course has been created not only to help you learn Microsoft Excel but to also, help you have a clear understanding of all the basics of this Application and what you can do with it. Also, this course will teach something very important concepts that can be used everytime that you work with this application. Indeed, by creating various projects, you will learn to think like a developper and this can be useful not only in Excel apps creation but even if you start programming in any object oriented language like python for Example. In other words, if you don't have any Excel or programming experience prior to this course, by completing it you will learn the programming logic and this will help succed not only with microsoft excel functions but it's useful if you start programming in any object oriented programming language.

Also, this course is built around a very simple but effective logic that is learning by practice. Indeed, this simply means that this course is definely not theoritical even if it contains some classes that present various MS Excel concepts. In other words, this course is built on a logic of learning by practice . This means that you will find plenty of projects all over the course to help you understand and master this Application to finaly achieve your end goal of learning how to use microsoft Excel.

For who is this course designed

There is a lot of Microsoft Excel courses that exist all over the internet. But, this course is definely different. Indeed, all the concepts that can be found in this course are simplified to help you understand them more in depth and a lot easier. Also, it's important to mention that each element in this course is presented with a multitude of various practical examples that will allow you to practice everything that you will learn all over the course. In other words, if you never wrote a single excel function or did any use of this application prior this course and you always wanted to start somewhere then you will probably love this course. The way this course is presented and structured is here to help you achieve your obective of starting to work with microsoft Excel and have a solid understanding of this application by the end of this course.

Why should I take this course

If wotking with Excel is something that you always had a passion for and you always wanted to learn more about this amazing apoplication then you should definitely take this course. The first thing that this course will teach you is understanding the logic of around this application or in other words how what are different uses that you can make with it and the various real life situations where Excel can be useful. You will also learn various MS Excel concepts as well as create various Projects and simple applications all over the course.

There is no risk involved in taking this course

This course comes with a 100% satisfaction guarantee, this means that if your are not happy with what you have learned, you have 30 days to get a complete refund with no questions asked. Also, if there is any concept that you find complicated or you are just not able to understand, you can directly contact me and it will be my pleasure to support you in your learning.

This means that you can either learn amazing skills that can be very useful in your professional or everyday life or you can simply try the course and if you don't like it for any reason ask for a refund.

You can't lose with this type of offer !!

ENROL NOW and start learning today :)

Who this course is for:

People interested in Ms Excel
Students wanting to learn how to use Excel
People curious about learning a new topic

Excel Tips and trick : Learn MS Excel by making 7 Projects

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 34min

Project 14 lectures • 41min

Project 23 lectures • 36min

Project 34 lectures • 44min

Project 44 lectures • 1hr 4min

Project 55 lectures • 57min

Project 64 lectures • 51min

Project 78 lectures • 42min

Requirements

Description

Who this course is for: