Microsoft Excel Step by Step Training for Beginners!
4.6 (95 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
11,152 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel Step by Step Training for Beginners! to your Wishlist.

Add to Wishlist

Microsoft Excel Step by Step Training for Beginners!

Learn all the basics of Microsoft Excel and begin creating amazing templates and tables in just a few hours!!
4.6 (95 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
11,152 students enrolled
Created by Jed Guinto
Last updated 9/2015
Current price: $10 Original price: $100 Discount: 90% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 8.5 hours on-demand video
  • 6 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Basic controls – Opening Excel, Navigation, Scrolling Zooming
  • A Quick Glimpse of the Power of Excel – Full Table Design, fill handle, Autosums, Basic Formula’s, Formatting, Wordart, Status Bar
  • The Quick Access Toolbar – Productivity Tool, Keyboard Shortcuts
  • Cell and Sheet Control – Cell Inputting, Table Navigation, Formatting Cells, Copying and Pasting, Fonts, Row and Column Manipulation, Sheets, Screen Tiling
  • “If” function – Logic Functions, “If” Formula, “And” Formula, “Or” Formula
  • Charts and Graphs – Line Graphs, Scatter Plots, Column Charts, Pie Graphs, Trend Lines
  • Images and shapes – Inserting Images, Print Screen, Grouping, Cropping, Brightness, Contrast, Colouring, Resizing, Rotation, Frames
  • Cleaning and Preparing a Table for Presentation – Spellchecker, Search and Replace, Text Cleaning, Pasting Types, Sort and Filter, Freeze Panes, Custom Borders, Cell Merging
  • How to Print like an Artist – Page Views, Setting Print Area, Paper Size, Orientation, Print Margins, Scaling, Headers and Footers, PDF Print, Printing
  • Life Management Tools – Custom designed spreadsheets to assist in planning holidays, Finances and Dinner!
View Curriculum
  • Microsoft Excel 2007 or later
  • Access to a computer
  • Access to the internet
  • Pdf file reader (Adobe Acrobat, Adobe Reader, etc. This should come standard with your computer)
  • No prior Excel knowledge required
  • Access to computer and internet
  • Paper and pen to take notes



Created: 1 August 2014

Last Updated: 17 April 2015


Course Achievements

  1. Over 4,700 satisfied students
  2. Over 15 positive reviews
  3. Average of 4,000 minutes consumed every month


Course Description

Immediately increase your productivity by learning the ins and outs of this revolutionary program

No prior knowledge required to get started – just the program, a computer, internet and YOU!

NEW! Now comes with LIFE MANAGEMENT TOOLS! - Pre-designed templates you can use immediately to help you manage your life!


Course Details

  1. It is designed for the beginner but if you're looking to freshen up on your skills, come on in!
  3. All future lectures, videos, documents and upgrades included FREE


Instructor Achievements

  1. Member of the Udemy Council
  2. +19,000 students (totalling ~40,000 enrolments)
  3. Average of 300-500 enrolments per day (Highest enrolment rate in one day was 1400 students)
  4. +500 Positive Reviews (5 Star Average Rating across all courses)
  5. +18 Live courses (+20 courses in production)
  6. Incorporated my Udemy courses into RMIT University Laboratory Tutorials for Undergraduate Aerospace Engineers


What Udemy has said about the Instructor

'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust!'


What students have already said about this course

  1. Louise Escuela I hope you continue designing courses. They do more good than you may know. Considering this was your first course, I can't wait in anticipation for your next course. When you retire, I hope you consider entering the teaching profession. You have a rare gift!
  2. Vern Reo This course is extremely well done for those who haven't a clue when it comes to Excel. The instructor covers a lot of ground in a well-structured and simple teaching style. I'm only 40% through this course and can already perform most tasks I'll ever need for my job. I highly recommend this course.
  3. Diana T Engaging, positive course. I am going through the course now, and the more I advance, the more confident I feel when using Excel daily at work, Jed really has the right attitude towards this course and his students, and does a great job at boosting people's confidence! Thank you, Jed!
  4. Jose Lopez Garcia Awesome course for Beginners. I was a complete beginner before taking this course - no more! After several days looking for a good course on Excel, I decided to purchase Jed's. Jed gives specific and very clear explanations throughout the course. And he always supported me with all of my questions! The overall production quality is just excellent. Thanks Jed for such a professional course!
  5. Brenda Florence Jarolímková Short, but simple and effective! I really enjoyed this one because it starts with things I was able to catch up quickly with and yet felt that this is going to be useful in the future. Very nice course.


Still Not Sure About Me?

Check out MY PROFILE for a complete listing of my FREE COURSES and have a test run! Let me prove to you that I'm the man for the job!


Enrol Now and Experience the Benefits

  1. I'll show you step-by-step, I'll explain and highlight every single button I press, I'll draw around important area's and icons with on-screen drawing tools, I'll zoom into small and hard to see area's so you don't miss a single thing!
  2. With over 15 years of experience using Microsoft Excel, I'll let you look over my shoulder as I teach you the fundamentals.
  3. I'll show you exactly how to master this technique in a fraction of the time it takes the average person to learn on their own from books, YouTube videos, blogs and forums!
  4. By mastering this technique you'll become the most productive and most efficient person at your job and at home!
  5. New doors and opportunities will begin opening up for you personally and professional with each new technique you acquire!

Click the “TAKE THIS COURSE" button, top right, NOW!!...every hour you delay you're missing out on huge opportunities!!

Who is the target audience?
  • This course has been designed for the absolute beginner. Never touched Microsoft Excel before? Then you’ve found the right place.
  • If you’re intermediate or expert and want to freshen up on the fundamentals, no problem, come on in!!
  • People from any country
  • People of all ages
  • If you're only going to take a small part of the course, then this is not for you. To experience the full effect, you must take the full course
Students Who Viewed This Course Also Viewed
Curriculum For This Course
109 Lectures
Welcome, Course Introduction, Course Structure, Life Management Tools
5 Lectures 24:33

Welcome and congratulations on taking the first step to learning this wonderful program and increasing your productivity by 10,000%

Preview 04:20

Hey guys. Now I’ve constructed this course in the following manner. For each section there will be an introductory lecture which explains what you’ll be learning in that section. This will then be followed by an explanation of the Case Study we’ll be working on. Now I’ve create case studies rather than just generic examples because it’s more fun, more interesting and you can really see how you can apply the Case Study example to your own life. After the Case Study we go straight into the lectures where videos go for about 4-7 minutes long on average.

Now once the lectures are finished I do a quick summary of everything you learn in that section. We then follow this with a quiz where you can test out your skills. I have placed some tricks and curveballs in those quizzes to really see if you’re paying attention. Now because I’m a student myself, I like to be walked through the solution rather than just being told what the solution is. So I’ve also included a video where I go through the solution step by step. I don’t leave anything out. That way you can repeat the quiz if you want to and just copy what I do as practice.

Course Structure

Hey guy welcome back. Now the topics I’ve selected and the content within each has been carefully selected in order for you guys to obtain a balanced understanding of Microsoft Excel. For example, there’s no point teaching you every formula in the book if you don’t know how to create a table. Or showing you guys how to do fancy artwork but then not know how to print it out. And lastly how to create huge and complex calculations if you don’t even know how to save your work!

Topics Covered In This Course

Now in this section we’re going to look at 3 spreadsheets I’ve designed called Life Management Tools. These are spreadsheets that I use in my life that help me manage numerous things.

Life Management Tools

Before You Start
Basic Controls
5 Lectures 29:11

Hey guys and welcome to the first lecture of the course where we will be doing some actual Excel work. Now this course is for beginners so I am going to teach how to go from knowing nothing to becoming a master in Excel.

We're going to begin with learning how to open the program using a couple different methods.

Preview 05:53

Hey guys and welcome to the next lecture. Here I’m just going to go briefly through the menu ribbon. This is more for those who are transferring from Microsoft 2003 and this is the first time you’re seeing the ribbon. Now if you’ve already given it a try and found that you couldn’t find anything and starting thinking the old way was better, well you’re wrong! I actually think that this menu ribbon style is far superior to the original for a number of reasons. But before we get to those reasons lets go through it.

Preview 03:56

In this lecture we’ll be looking into how to move the page around. I have to admit that this skill is definitely underrated. I think the reason most people don’t practice this is because they don’t realize how much time their wasting on trying to get the right view. Also, I don’t think they’ve ever seen someone who is highly skilled at doing these things. So here for the very first time in internet history we’re going to become the masters of scrolling.

Preview 06:57

Hello boys and girls. So like scrolling, zooming in and out is also one of the most underrated techniques in Excel. You won’t believe how time people use trying to get the right of their data. And also, what people don’t understand is that because they think they’re only losing one or two seconds here and there, over the long run you could be losing days or weeks. So what I’m going to do is show you the different ways to zoom and get the right view so that you can get to work quickly and efficiently. Lets begin.

Page Zooming

In this lecture I’ll be going through the different elements on the screen. This is so if you click something by accident, you’ll know what it is and how to fix it. So we’ve already covered the menu ribbon so we won’t do that again.

Screen Controls Explained
Hotdog's anyone?
14 Lectures 01:14:11

Hey guys. Welcome to the next section where we will be learning how to create your first table from start to finish. Now the reason I have decided to do a full analysis is so that you don’t have to wait till lecture 10 or 11 or even completing the course before you can start applying basic techniques to your lives. Just the ability to create a table and do one basic function is enough to absolutely revolutionize the way you do business. Now this section will include everything from creating your very first table with headings and basic formatting all the way up to performing some pretty cool formulas.


The case study we’ll be looking at is a topic that is very near and dear to my heart and my stomach, and that topic is hotdogs. I’ve put together an imaginary hotdog business where we will be buying hotdogs to sell, sell the hotdogs, buy more stock and then try and forecast or project how many hotdogs we’ll sell for the rest of the year. Immediately you can see the capabilities of excel when I used the word forecast.

One of the things I do on a daily basis is try and determine patterns and forecast for different things in my life like my finances, business needs, company goals and so on. Imagine where you could apply these same techniques in your lives. Imagine being able to plot your expenses and to statistically prove that you have enough money for the house, for the kids or even if its just for fun. Things like making sure your lemonade stand is making enough money to cover your expenses. As the topics get more complex and you start doing larger and larger analysis just remember that it all started here. Learning how to create and calculate your first table. So, lets get started.

Case Study

The very first thing you should do before you do absolutely anything else in Excel is to save your work. You won’t believe how many times people don’t save their work or don’t save it properly. If there was one thing I could teach you guys, even if you don’t learn anything else in this course is to develop the habit to save your work. And not just save it, but save it properly. This has saved me and the companys I’ve worked for hundreds or even thousands of dollars.

Preview 06:58

Here we're going to learn how to create your first title. We're going to do some basic formatting and get you started.

Creating Your Title

Here we're going to learn how to create and format some table headings. Font, alignments, etc.

Creating Table Headings

Hey guys welcome back. The next thing we’re learning is using the Fill Handle. The fill handle is an incredible tool that I think most people haven’t yet learned to use creatively. Now what the Fill Handle does is determine patterns in your data and forecasts the next set. For example, if you type in Monday, Tuesday and Wednesday, Excel will guess that the next day to fill in is Thursday! Pretty neat. But you can go a step further. You can go at different increments. For example, you can type in 0, 10 and 20. Excel will then forecast that the next number is 30. You can do this for decimal places, formula’s and even formatting. But for now let’s do the basics.

Preview 05:21

Hey guys. For this lecture we’ll be doing your very first mathematical equation. Now I know everyone loves maths and everyone’s good at it so we won’t have a problem here right. Wrong! Most people suck at match and if you are one of these people you are going to love what we’re going to do next. The power of Excel is that it can perform these powerful calculations for you and carry them through. What do I mean by this? When you’re in school and trying to calculate something with multiple steps, you have to carry the results from part A, into part B. This is where the mistakes happen. In Excel we can set it up so you can see exactly where the information is coming from and where it’s going next. But enough talk let’s do it.

Basic Formula's 1 - Adding and Subtracting

Hey guys welcome back. Now I’ve already showed you how to create formula’s. But there’s another way so that Excel builds the formula for you and that’s called the Autosum function. Now Autosum can’t create every single formula but it can create the basic ones. Let’s begin.

Autosum Functions: Totals and Averages

Hey guys welcome back. This next lecture we’ll be doing some more formulas but instead of just calculating totals and averages, we’ll be doing some basic forecasting. Based on the information we’ve calculated, we’re going to forecast how many hotdogs we’re going to sell a year based on these trends and also how many per month. Let’s begin.

Basic Formula's 2 - Multiplying and Dividing

Hey guys welcome back. For this lecture we’re not going to be doing any formula’s instead I want to show a neat function of Excel and that’s the status bar calculator. As you’ll notice from the previous lectures, sometimes it’s necessary to check if the formula we have creating is linked up properly. One of the ways to do this to simply highlight the field like so, and Excel will automatically calculate some basic values in the status bar. Values like the average, count, maximum, minimum etc are automatically calculated. This is also helpful if you don’t necessarily want to calculate it on your work page.

Using the Status Bar Calculator

Hey guys welcome back to the last lecture of this section. Here we’re going to add a bit of style and swag to your sheet. Kids love this next function and when I was younger I used it to the point where it was absolutely unnecessary. But it was fun and that’s why I did it.

Preview 03:26

In this section we're going to go over everything we've learned in this section.


Hey guys. So now that you guys have finished watching the lectures it’s time to test out your skills. I have provided a quiz similar to what we have worked on for this section. The topic this time is the Top Ten Movies. Please download the excel working file. It contains all the tasks you need to complete. Good luck.


Alright guys I hope you enjoyed the quiz and were able to retain everything and apply what you’ve learned. Don’t be disappointed if you weren’t able to answer all questions. As long as you learned something then this section was a complete success for me and for you. Like I said, Excel is like a language and you can only really learn one word at a time.

Quiz Solution
The Quick Access Toolbar
4 Lectures 14:29

Hey guys welcome to the next section called “The Quick Access Toolbar.” Now that you guys are a bit familiar with Microsoft Excel and icons and scrolling and all that I’d like to teach you this awesome tool to make your life so much easier. Now for those of you coming from 2003 Excel, you’ll notice firstly the difference in the menu tabs. What you’ll also notice is that the menu tab can be minimized which gives you better visibility of your worksheet because there is more room. Now for a lot of the functions there are shortcuts but not for all of them. So instead of opening and closing the menu tab all the time, Microsoft has developed the Quick Access Toolbar.

What is the Quick Access Toolbar?

Hey guys welcome back. Let’s try adding icons to the toolbar. So far you’ve learned some basic formatting, some cell formatting and wordart. Let’s try adding the Bold, Italic and Underline formatting.

Preview 04:13

In this lecture we're going to learn how to rearrange the icons so you can really get the most out of the Quick Access toolbar. Also, this allows you to customize it to your liking.

Reordering the Ribbon

Now one thing I’ve noticed with a lot of people is their fascination with shortcuts or hotkeys. Now let me tell you, when you get to the point where you’re barely even touching your mouse to do any work, then you are probably in the top few percentage of Excel users who would be considered gurus or experts. If you do the math, the number of times you switch from keyboard to mouse could be as much as 1000 times per day or more. If each time you switch you’re your wasting 1 second, assuming you work 8 hours a day, 5 days a week and 50 weeks a years, then you’re wasting almost two weeks just on switching from keyboard to mouse.

Add this to all the other techniques you’ll eventually master and all the time you can save, you could potentially be doing almost 10 times the work of the average user if not more in the same time span. Absolutely incredible if you can get that good.

Controlling the Ribbon from the Keyboard
My Chocolate Factory
15 Lectures 01:08:45

Hey guys, welcome to the next section where we will be covering some more elements. Now this will build on the knowledge you’ve gained from the first section so if you’re still a bit rusty on some of those elements that’s ok. Continue with this section and if you need to go back a revise please free to. I’m not going anywhere.

So in this section we’re going to covering the different ways to input information in a cell or multiple cells, we’ll learn about table navigation, copying and pasting data, we’ll be doing some fonts again but this time with a bit more detail, I’ll also be introducing rows and columns and what they’re used for, then we will be learning about sheets and why they are such an important element and then we’ll finish off by learning about the different page views we can use like tiling. So let’s top talk and get to it. See you guys soon.


Hi everyone, the Case Study we’ll be doing is a listing of Chocolate bar sales for multiple companies. The reason I chose this case study is well because everyone loves chocolate. You’ll from the table here that it doesn’t look its best. There are gaps, some missing data and the spacing just doesn’t look right.

So what we’ll be doing is something which whenever excel files are exchanged some form of this takes place. I’m talking about data cleansing. If you’re an absolutely brand new user it will be difficult for you to distinguish between good data, bad data and then really bad data. But once you finish this course and you’re standards have increase, when you meet another person who is an average user, you’ll immediately recognise that for you to use their information you’re going to have to clean it up.

So along with the important function’s we’ll be learning here I’ll be introducing you into the world of data cleansing. Happy times so lets begin.

Case Study

Hey guys. In this lecture we’ll be looking at the different ways to enter data. Now you may think this is somewhat of an unnecessary lecture. However, I beg to differ. The reason being is that each method of inputting data has its advantages and disadvantages depending on what you’re trying to do. Use the wrong method for the wrong situation and you could be spending 10 times longer than you should.

Different Ways to Input Data

Hey guys. This lecture is more an in between lecture where I’m going to teach you a bit of a shortcut. Now when you start building tables you’ll start to notice that usually not all the cells are filled with information which is normal. Sometimes you also want to travel within the table or between tables with very little ease and without the use of the mouse. One way to do that which doesn’t include scrolling is using Control Up, Down, Left or Right.

Table Navigation

Hey guys welcome back. In this lecture we’ll be covering the basics of copying and pasting. Now it’s hard to imagine why copying and pasting would have a basic level followed by some harder levels. The reason for this is because when you get to more advanced elements such as importing and exporting information not only to other Excel documents but also other programs, using the right copying, cutting and pasting function is essential. Unfortunately I don’t very many people take the time to learn the differences between the different types of copying and pasting which results in worksheets that worked one day, but not the next. So lets begin by doing some basics Copying, Cutting and Pasting.

Preview 07:03

Hey guys welcome back. In this lecture we’ll be covering another way to format cells. Now earlier you guys learned how to do it using the buttons on the home tab. However, there are some additional font functions you can do through what’s called the Format Cells Window.

Format Cells Window

Hey guys. In this lecture we’re going to start using rows and columns. Learning how to use rows and columns is an extremely useful tool in Excel. The reason is because once you start using large tables, you can easily manipulate the table by adding, deleting or moving’s rows and columns rather than individual cells. Let’s do this now for our table and clean it up.

Moving Rows and Columns

In this section we're going to learn the different ways to delete rows and columns.

Adding and Deleting Rows and Columns

Hey guys. Now let’s start using sheets. Now what are sheets? Sheets are basically additional pages in your workbook. Much like a book has multiple pages. In the same workbook you can have multiple pages as well, also known as sheets. You can add as many sheets as you like or basically until Excel runs out of memory. I do recommend limiting the amount of sheets you use as it can slow your computer down quite dramatically if you’re not careful. Ok so let’s begin.

Introduction to Sheets: Adding and Deleting Sheets

Hey guys. In this lecture we’ll be learning how to rename a sheet and also how to change the colour of the tab. Now this is actually quite important because once you start using multiple sheets, you want a way of categorising them and colour is a great way to do that.

Preview 03:16

Hey guys. The last lecture we’ll be doing is moving and copying sheets. This is possibly the most important skill to master with sheets. The reason is because sometimes you have a workbook with multiple sheets but you only want to send one through an email. So instead of sending the whole document which sometimes may be too large for an email you just want to send that one sheet. Be careful though because if you have a formula in the one you separate which connects to another sheet, it may not work once you move it to a new workbook. So enough talk let’s begin.

Introduction to Sheets: Moving and Copying

Hey guys welcome back. Now this next trick I picked up not too long ago and has absolutely transformed the way I work. Now tiling the screen is more of a productivity tool. Now as you now know, in Excel you can have multiple sheets of information. However, sometimes you need to travel back and forth because you need information from one to put into another or you’re trying to set up a formula and so on. So what this function does is allow you to multiple sheets open from the same document. That way you don’t have to keep jumping back and forth. Might be a little bit hard to understand so let’s get to the demo.

How to Add a New Window: Tiling the Screen

In this section we're just going to go through all the things that we learned in this section.


Hey guys. So now that you guys have finished watching the lectures it’s time to test out your skills. I have provided a quiz similar to what we have worked on for this section. The topic I’ve selected here is a table which calculates your credit card repayments. Don’t worry there’s no formulas for you to do. I have provided tasks for you to complete. Good luck.


Alright guys I hope you enjoyed the quiz and were able to retain everything and apply what you’ve learned. Don’t be disappointed if you weren’t able to answer all questions. As long as you learned something then this section was a complete success for me and for you. Like I said, Excel is like a language and you can only really learn one word at a time.

Quiz Solution
Life Management Tools
6 Lectures 24:37

Hey guys congratulations on completing all the lectures. I hope you guys learned a lot and can see where you can really apply what you’ve learned here to things in your own life. Remember, a formula is just a formula until you apply it to your life.

So now that you’re finished with all the lectures it brings us to the Life Management Tools Section. These are spreadsheets that I’ve design which you guys can use for things other than business purposes.

My belief is that Excel isn’t just for business need’s, it can be used to manage different things in your life like holidays, special occasions, your finances and even choosing what to eat for dinner!

So now let’s go through the tools and I’m going to explain how to use each of them. Alright guys see you soon.

Preview 00:58

How to download the files!

The first one we have is the holiday planner. One of the worst things about going on a financially unplanned holiday is that first when you get there it turns out you don’t have enough money to do the things you want to do. The second is that you come back from holiday and you’ve spent way more than you wanted.

Preview 06:47

Hey guys welcome back. Now this tool I’ve created is something very similar to what I use every few days to manage my expenses. This tool will track your income and expenses to see if your spending more than you make. What I do is I record general values for my expenses and then put all my different types of income. Then when I’ve graphed this I can see if I’m financial growing or decaying. Extremely important. Nothing worse than reaching the end of the year and realizing you haven’t saved a single cent.

Preview 06:36

This was a last minute addition to the course. Unfortunately I didn't realize you couldn't upload files with Macro coding. Therefore, I've created this lecture to show you how to set it up.

What's For Dinner? (Setup Procedure)

Hey guys welcome back. This is a fun one. Now what I’ve done here is introduced Microsoft Visual Basic for Application. This is an extra function in Excel which allows you to program excel to perform calculations for you.

Now the reason I’ve included this is to give you a quick glimpse of where you can go or what you’ll be able to do if you continue to pursue learning this program.

Preview 06:20
If I was Jamaican, my name would be.....
9 Lectures 43:53

Hey everyone and welcome to the next section, the “If” function. The “If” function is an extremely powerful tool, not only in Excel but in many other programs as well. In fact, once you begin using this function, it is the ticket to the next level of Excel. What the “If” function does is it compares a value to different types of conditions and provides a response depending on how you value lies within those conditions. Now that sounds like a mouthful and it’s hard to picture it for the first time. But once you get it on paper, you see how the information flows it becomes so easy.

So what we’re going to do is go through this function really slowly and step by step. By the end of this section you’ll be able to write a basic “If” function with multiple conditions. The topics we’ll be covering include a detailed explanation of what Logic functions are, building your first “If” function, dealing with blanks, using the “Or” function, using the “And” function and finally finishing with using the “Greater/Less Than” function.

Alright guys, enough talk let’s get to it.


Hey guys welcome back. The case study we’ll be doing is a conversion sheet I’ve written which determines what your Jamaican name is and what your favourite saying is based on the first letter of your name, your eye colour and your age. So what we’re going to do is use different combinations of the “If” function in order to extract data which matches the conditions or criteria that you set. I think very quickly you can start seeing the benefits of knowing this function because it allows you to extract very specific bits of data out of large sets of data. So let’s get to it. See you guys soon.

Case Study

Hey guys welcome back. Now I know some people have trouble trying to visualize the logic function. For first-timers this can be quite difficult. So what I’ve prepared is an “If Function Map” that you guys can print out, use as a reference, create “If” functions, take to work, etc. As you can see here I’ve included two examples which are really basic. Now what this will do is allow you to see how the data flows.

Preview 02:21

Hey everyone welcome back. Let’s build your first “If” function. Now we’re going to start here in the first table and as you can see there is the alphabet on the left followed by a list of names. What we’re going to be doing is using the first letter of your name to extract your Jamaican name. Here’s how you do it.

Building you first "If" Function

Hey guys welcome back for the next lecture. In this lecture we’re going to be learning about the “Or” function. Now the great thing about Excel is that you can combine multiple formulas or multiple conditions in the one cell. Compared to if you did it on paper, you would have multiple lines trying to calculate one result.

Using the "Or" Function"

Hey everyone welcome to the next lecture. Now in this lecture we’ll be doing something very similar to the “Or” function. This time we’re using the “And” function. So what is the difference between the “Or” and the “And” function. Well let’s go back to our dress example. You go back to the store to buy another dress. You go to the lady I want to buy a dress that is blue and goes all the way to my feet. Now if she comes back with a blue dress which stops at the knee well then you don’t buy it. It’s the same going the other way. If she brings back a dress that goes to the floor but is the colour orange well then you also don’t buy it. Both conditions need to be met before you buy the dress. That’s basically how the “And” function works.

Using the "And" Function

In this section we're just going to go through all the topics that we learned in this section.

Preview 05:00

Hey guys. So now that you guys have finished watching the lectures it’s time to test out your skills. I have provided a quiz similar to what we have worked on for this section. For this quiz we’ll be determining 3 of your personality traits. Now this is not a real personality tester. I’ve made this up and it’s completely fictional. It’s just for fun. OK so as usual the instructions are in the working file. Good luck and see you soon.


Alright then guys I hope you enjoyed this test. Let’s go through it and I’ll show you guys exactly how I would solve this problem.

Quiz Solution
I wish I was that rich!!!
12 Lectures 54:45

Hey guys welcome to the next section. For those of you who love colourful and shiny things this section has designed for you. Here we will be learning about Charts and Graphs. What I have provided to you guys is only the original data table and what we will be doing is analysing the information and trying to find patterns in the data using graphs.

Now the ability to do this is going to prove extremely helpful in visualizing information. You see when we look at a table we see some obvious things. No matter what the data may be representing, we can see who has the most money, or the most number of goals, etc. However, the little changes in patterns are hard if not possible to visualize unless you had a tool like Excel.

What I’m going to be teaching you guys here is how to create not just visually appealing graphs and charts, but also the proper way to present them. Along with this I’ll show you how to format them and add extra information so that whoever the reader is, they can look at it and within a few moments have a general idea of what you’re trying to explain. There is nothing worse in business than getting graph and asking what does this axis represent? Is this in millions, billions or Taiwanese dollars? What do the colours mean? Or worst of all, someone who replies “what the hell am I looking at?

So enough talk let’s get straight into it. See you guys next time.


Hey guys. The case study we will be looking at is a list of the Top 30 richest people in the world. The table here shows their age, where they’re from, they’re current net worth and their net worth a few years. A lot of this data I made up so don’t be shocked if it’s different from what you’ve read in the papers.

So with this data we’re going to plot 4 different things. The first will be a line graph showing the Net Worth as you go down the list. The next graph will be a Scatter Plot showing the distribution of Net Worth depending on Age. This will be followed by a Column graph which compares the ages of all top earners. Lastly, we’ll be doing a part chart to show the distribution of Net Worth as a percentage.

Alright guys let’s get to it.

Case Study

In this lecture we're going to learn how to create your first Line Graph.

Preview 07:30

Hey guys welcome back. Now before we continue with other things I want to show you guys how to add more than one piece of data to your line graph. Now this will be a good second run through in case you had trouble getting it right in the previous lecture.

Creating a Line Graph 2 - Formatting

Hey guys welcome back. In this lecture we’ll be creating a Scatter Plot graph. Now how is this different from creating the Line Graph we did earlier. Well, besides the chart select, everything else is basically the same. That’s the beauty when you start using graphs. Whenever you construct the way you insert data or format fields is almost exactly the same.

Creating a Scatter Plot

Hey guys welcome back. In this lecture we’ll be continuing with Scatter Plots. What we’re going to do now is add a Trend Line. Now the Trend Line function is extremely helpful when you’re trying to derive a pattern from your data. It’s also really helpful in trying to forecast coming results.

Preview 06:14

What Topics Do You Want Me To Cover?

Hey guys, welcome back. In this lecture we’ll be covering how to create a column graph. Now in this example we’re going to be plotting the age of each of the billionaires then display their age at the top of each column. Pretty cool. Let’s begin.

Creating a Column Graph

Hey guys welcome back. For this lecture we’ll be creating a Pie graph. Now I love pie graphs because you’re able to see how all the data is broken up. So I mostly use this to represent percentages. So let’s begin.

Preview 04:36

In this section we're going to go through all the things we learned in this section.


Hey guys. So now that you guys have finished watching the lectures it’s time to test out your skills. I have prepared a quiz which shows weekly expenses. This is a tool similar to what I use for myself. Your job is to analyse the data using graphs and charts. The instructions have been provided in the Excel file attached. Good luck guys and see you soon.


Alright then guys I hope you enjoyed this test. Let’s go through it and I’ll show you guys exactly how I would solve this problem.

Quiz Solution
I suck at Art!!!
10 Lectures 51:10

Hey guys welcome to the next section, using Images and Shapes. Now this section isn’t as technical as some of the others. This is more of an art topic I’d say. Now just because it isn’t technical doesn’t mean you shouldn’t take it seriously. Actually, this is one of the most common places of frustration. I see a lot of people who simply want to place an image into Excel and get so frustrated because they can’t shape it just right. The reason for this is because people don’t understand the basics of controlling images. Things like moving images around, or rotating them, cropping, colouring, brightness, sharpness, etc. These are fundamental tools which sad to say most of the population don’t know how to use.

So what we’ll be doing is a few examples where we will really get into how to use these basic shapes. Then how to transform these basic shapes into very colourful images as a whole. Alright guys, see you soon.


Hey guys, welcome back. The case study, or case studies I should say we will be looking at is firstly a constellation of Leo which is my star sign, then an image of the famous one of my favourite actors, Mr. Bean, then lastly we’ll be looking at a PANDA bear and playing spot the difference. For each one we’ll be performing different types of formatting, shape alterations, image enhancements, framing, etc. Alright guys, see soon.

Case Study

Hey guys. To start this lecture you’re going to have download the files I have attached and save them on your desktop. What we’ll be doing is learning the different ways to import these images into Excel. Now each method has its advantages and usually what I see is people selecting their favourite one. The methods are: Insert Image Function, Microsoft Paint Extract and Print Screen.

Importing Image Files: Insert Image Function and Print Screen

Hey guys, welcome back. The first thing we’ll be doing in this lesson is moving things around so we can see everything. To do that, simply click on an image and drag to your desired location. So let’s put the PANDA bear at the bottom, Mr. Bean on the right and the constellations on the left like so. Pretty easy.

Preview 06:40

Hey guys welcome back to the next lecture where we will be enhancing our pictures using some pretty cool effects. So why do we need these effects. Well the first reason is you want images to be clear and pop out of the screen. Nobody want a boring image. Also, sometimes you have images that aren’t very clear and so you need to clean them up in a sense. To do all this we’re going to use some adjustment tools. So let’s begin.

Formatting the Image: Corrections, Colour and Artistic Effects

Hey guys welcome back. The next lecture we’re going to be doing includes playing Spot the Difference. I have to admit that I’m pretty awesome at this game and there is no 5 year old who’s even close to me. So yes, that is on my Resume.

Ovals – Formatting, Rotation, Grouping

Hey guys welcome back. For this lecture we’re going to be using Text Boxes, Squares and Lines on Mr. Bean. For those of you who don’t know who Mr. Bean is please look him up because he is one of the funniest actors ever. So what we’re going to actually be doing with Mr. Bean is highlighting certain parts of his face, labelling them and then connected the highlighted area with the text using a connected line. So let’s begin.

Squares and Textboxes: Formatting, Connecting Shapes and Picture Frames

In this section we're going to go through everything we learned in this section.


Hey guys. So now that you guys have finished watching the lectures it’s time to test out your skills. I’ve prepared a quiz which involves one of my favourite cartoon characters, Spongebob Squarepants. Your job is to clean up this image and label it. I’ve provided instructions as always. Enjoy and good luck.


Alright guys. So in this lecture i'm going to go step by step on how to solve this quiz.

Quiz Solution
My wife is going to love me after this!!!
13 Lectures 01:13:06

Hey guys welcome to the next section. In this section we’ll be learning how to clean a table for presentation. Now usually I wouldn’t put a section together for this but too many times I see reports and documents that lose a bit of their impact because it hasn’t been formatted correctly. Remember, when you provide information in the form of a document or presentation your representing yourself. Now I’ve been working with data for a long time and I can tell just from the information provided whether it’s in an email, document or printed report what kind of person I’m dealing with. Simply from the tools they’ve used to clean the report, gives me an idea of what kind of person I’m working with.


Hey guys welcome back. The Case Study we’ll be using in this section will be cleaning a grocery list. I’ve kept this as basic as I can but one thing I’d like you guys to remember is that the principles can extend for tables substantially larger than this. So by understanding these basic principles, even larger tables as long as 100,000 rows long, will eventually be no problem for you. Alright so let’s get started.

Case Study

Hey guys. So the first thing we’re going to learn is the Spellchecker. This is pretty basic but is extremely helpful for when you start dealing with larger sets of data. It prevents from having to go into every single cell and try to find where the errors are if there are an

Preview 03:43

Hey guys welcome back. In this lecture we’re going to learn how to search for information. Now this is a very useful tool in trying to find specific values or text in a large sea of data.

How to Search and Replace Text

Hey guys welcome back. The next tool we’re going to be using is one of the most powerful tools in Excel. A lot of people won’t agree with me here and I think because it takes a bit of skill and creative to really bring out the best in this tool. This tool is called the Format Painter.

Format Painter Basics

Hey guys welcome back. For this lecture we’re going to learn some pretty cool formulas. I actually only discovered this a few months ago and the reason I discovered it was that one of my work mates has an unhealthy obsession with using capital letters for everything! So the formulas we’re about to use clean up text very efficiently.

For example, if the text in your spreadsheet, is a mixture of capital and lower case letters and there’s no consistency, you can apply these formula’s and it can make all the text lower case, upper case, or proper case which we’ll get to in a second. So let’s begin the demonstration on the days of the week.

Preview 04:23

Hey guy’s welcome back. This is going to be a short one. What we’ll be learning here are the different types of pasting. Now so far you only know how to copy one cell into another. When you do this you’re actually copying a couple of things. Firstly you’re copying the formatting from one cell into another. Next you’re copying any formulas already in the cell into a new position. Lastly you’re copying the values from one spot to another.

Different Types of Pasting

Hey guy’s welcome back. In this lecture we’re going to be rearranging an entire table. Now as you can see from the days of the week, they’re not in order. So in order to fix that we have to use the Sort and Filter Tool. What this tool will do is look at one parameter in your table and then alphabetise it or reorder them from highest to lowest depending on what you want. We want to reorder the days so that its in order.

Sort and Filter

Hey guy’s welcome back. For this course we’re going to learn about Freeze Panes. Now when I first learned how to do this is was by accident and so I thought I actually broke Excel. Now Freeze do is allow you to split you’re screen so that you see a lot more information from different parts of the work book.

Freeze Panes

Hey guys welcome back. In this lecture we’re going to be looking at different types of bordering. Now one of the cool things you can do with Excel is create very unique borders depending on what you’re doing. For our case, the border lines we’ve used here are a little boring. So we’re going to jazz it up a bit. So far, we’ve been using the preset border options. This time we’re going to create some custom ones.

Using Borders and Merged Cells

So in this section we're just going to go through all the things we learned.


Hey guys. So now that you guys have finished watching the lectures it’s time to test out your skills. So this time I’ve prepared a table that I think guys and girls should familiarise themselves with. It’s a gift guide that men can use to get the perfect gift for their girlfriend based on a number of factors. Now this is all in good fun so nobody take it too seriously.

Now the way this works is that depending on what kind of occasion it is and the mood she’s in will determine the gift you buy her. Guy’s pay attention because this could save your life. Your job is to clean up this table. Enjoy and good luck.


In this lecture we're just going to go through the solution for this quiz, step by step.

Quiz Solution
2 More Sections
About the Instructor
Jed Guinto
4.3 Average rating
5,156 Reviews
62,058 Students
21 Courses
Aerospace Engineer, Researcher, Entrepreneur, Programmer

Udemy Start Date: July 2014

What Udemy has said about my courses:

'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust!'

PC Mag:

'Jed Guinto is something of an Udemy wunderkind!'

'There are all-stars, such as Mr. Guinto, who do well by any metric!'


  1. Member of the Udemy Council
  2. +60,000 unique students
  3. +130,000 enrolments
  4. +5,000 Positive Reviews
  5. Incorporated my Udemy courses into RMIT University Laboratory Tutorials for Undergraduate Aerospace Engineers

Quick Biography

Jed Guinto is an Australian technical trainer who specialises in Aerospace Engineering, System/Database Design, Computer Programming and High Density Data Analysis. He has an Advanced Diploma in Aerospace Engineering (RMIT 2006-07), a Bachelor's Degree in Aerospace Engineering with Honours (RMIT 2008-10) and a Graduate Certificate in Engineering Management (RMIT 2011). He has been trained by some of the brightest and innovative minds in Aerospace, Automotive, Manufacturing, Mechanical and Computer Engineering in the world.

In 2011 he travelled to Augsburg, Germany as an Aerospace Engineer and performed Structural Strength Analysis on aircraft's such as the Airbus A320, A330, A340, A350 and the Boeing 747.

In 2012 he returned to Australia to tutor and mentor underprivileged and disadvantaged school students in physics, english, biology, chemistry and mathematics.

From 2013-14 he was employed by Ford Motor Company as the Asia Pacific and Africa Tooling Systems Engineer. Programs and Databases he developed have been utilized in several countries.

In 2015, he was awarded the ARC Discovery Grant Scholarship and granted Full Research Funding for the next 3 years from the Australian Government at RMIT. Part of experience involved working under former NASA Ames Senior Research Engineer Dr. Jon Watmuff in teaching Computational Engineer Analysis methods to undergraduate students.

In 2017, he worked at Careers Training Group, an organisation focused on Aged Care and Early Childhood training. His main role was to develop analytic systems to connect people with technology.