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.0 (83 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.
10,771 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 109
  • Length 8.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2014 English

Course Description

JOIN MY COMMUNITY OF OVER 11,000 STUDENTS AND LEARN AMAZING TECHNIQUES, TIPS, TRICKS AND SECRETS THAT I'VE ACCUMULATED OVER 15 YEARS OF ACADEMIC AND PROFESSIONAL TRAINING!

+++++++++++++++++++++++++++

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!
  2. FULL AND FREE LIFETIME ACCESS
  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!!

What are the requirements?

  • 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

What am I going to get from this course?

  • 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!

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome, Course Introduction, Course Structure, Life Management Tools
04:20

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

06:18

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.

08:28

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!

05:09

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.

Before You Start
Article
Section 2: Basic Controls
05:53

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.

03:56

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.

06:57

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.

06:02

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.

06:23

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.

Section 3: Hotdog's anyone?
00:54

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.

02:02

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.

06:58

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.

07:19

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

07:19

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

05:21

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.

08:41

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.

04:50

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.

05:58

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.

03:34

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.

03:26

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.

08:18

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

01:12

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.

08:19

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.

Section 4: The Quick Access Toolbar
02:23

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.

04:13

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.

03:31

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.

04:22

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.

Section 5: My Chocolate Factory
01:02

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.

01:32

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.

08:01

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.

05:37

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.

07:03

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.

07:41

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.

02:46

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.

05:00

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

03:26

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.

03:16

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.

06:13

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.

06:01

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.

04:02

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

01:20

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.

05:45

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.

Section 6: Life Management Tools
00:58

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.

How to download the files!
Article
06:47

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.

06:36

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.

03:51

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.

06:20

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.

Section 7: If I was Jamaican, my name would be.....
02:14

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.

01:38

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.

02:21

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.

07:32

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.

07:36

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.

09:07

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.

05:00

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

01:47

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.

06:38

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.

Section 8: I wish I was that rich!!!
02:20

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.

01:59

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.

07:30

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

04:10

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.

06:56

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.

06:14

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.

What Topics Do You Want Me To Cover?
Article
06:51

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.

04:36

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.

04:00

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

01:33

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.

08:10

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.

Section 9: I suck at Art!!!
02:22

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.

01:43

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.

06:08

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.

06:40

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.

04:27

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.

09:38

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.

08:17

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.

03:44

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

01:04

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.

07:07

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

Section 10: My wife is going to love me after this!!!
04:04

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.

00:59

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.

03:43

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

04:45

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.

06:56

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.

04:23

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.

04:16

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.

07:49

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.

08:41

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.

05:55

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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jed Guinto, 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!'

Achievements

  1. Member of the Udemy Council
  2. +43,000 students
  3. +2800 Positive Reviews
  4. 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), a Graduate Certificate in Engineering Management (RMIT 2011) and is currently doing his Ph.D. in Advanced Composite Structures and Nonlinear Acoustic Systems (RMIT 2015-Present). 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 to begin his Ph.D studies at RMIT. His focus is on Damage Diagnosis of Composite Structures through the use of Nonlinear Ultrasonic Techniques. His research will have applications in the Aerospace, Mechanical and Computer Engineering fields with additional applications in Health and Medicine.

He will be researching under renowned Aerospace Engineers such as Professor Chun Wang, former Head of Advanced Composites Technologies Research for Air Vehicles, Defence Science and Technology for Australia and current Professor and Director of the Sir Lawrence Wackett Aerospace Centre at RMIT University. He will also be working under former NASA Ames Senior Research Engineer Dr. Jon Watmuff in teaching Computational Engineer Analysis methods to undergraduate students.

Complete Biography

Jed was born in Philippines but grew up in Melbourne, Australia. He has achieved success in the fields of aerospace engineering design, project management, database development and space research. One such achievement was his Final Year Undergraduate Thesis research and design of an Extra-Vehicular Activity (EVA) Space Glove to be used by astronauts on space walks. His design involved the use of Shape Memory Alloy Polymers as artificial muscles to increase strength, mobility, longevity, dexterity and control of astronauts. His designs earned him the award for research from the National Committee for Space and Radio Science (NCSRS) and the National Space Society of Australia (NSSA) at the largest Space Conference in Australia; the Australian Space and Science Conference (ASSC) held at the University of Queensland in 2010.

In the same year, he managed a team of 11 students in the design of an Environmentally Friendly Commercial Jetliner the size of the Airbus A320 and Boeing 737. He facilitated the conceptual design, preliminary design, documentation, presentation, research and analysis which earned each and every student no less than a Distinction as their final grade.

Additional research he performed was Dynamic Stability Analysis of an aircraft at the Royal Australian Air Force (RAAF). This involved flying to an altitude of one kilometre and using lasers to determine aerodynamic behaviour through a variety of manoeuvres. Once again, under his leadership, the team of 10 students were awarded nothing less than a Distinction.

In 2011, he earned the privilege of working and studying at Consaro GmbH, a German Engineering company with 25 years of expertise in the field of Aerospace Engineering, Lightweight Structures and Composites, located in Augsburg, Germany. There he performed Structural Strength Analysis on lightweight aircraft structures such as the Airbus A320, Airbus A330, Airbus A340, Airbus A350 and the Boeing 747-400 series. Investigations he performed included load path analysis of complex mechanical systems, component strength analysis and stability analysis on thin walled structures.

In 2012, he began volunteering for organisations such as Edmund Rice Community Refugee Services and the Smith Family Services. Here he educated and mentored underprivileged and disadvantage youth students ranging from 7 to 18 years old in the fields of physics, english, biology, chemistry and mathematics. This experience has been one of the turning points in his life which have resulted in the educational courses he has now developed.

It was in Germany he began his journey into computer programming, application development and large scale data analysis with data sets reaching into the millions. He went on to refine these skills and was employed as the Ford Motor Company Asia Pacific and Africa Tooling Systems Engineer for Global Asset Management (2013-2014). His contributions in the field of data management, database design, software automation and statistical analysis have been utilised across several continents around the world.

His vision for the future is to share as much of his knowledge as he can to others around the world so that they have the tools to better their lives and those around them. To make learning and education fun, simple, accessible and affordable for those who have long given up on it. His belief is that it is never too late to learn and that curiosity is the key to all success.

Ready to start learning?
Take This Course