Microsoft Excel Step by Step Training for Beginners!
4.7 (103 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.
12,215 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.7 (103 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.
12,215 students enrolled
Created by Jed Guinto
Last updated 9/2015
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
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
Description

WHAT’S YOUR STORY?

  1. Are you a business professional needing to up-skill?
  2. Are you struggling to get a pay-rise and/or promotion?
  3. Are you a recent graduate with an empty looking resume and no job experience?
  4. Have you recently been laid off, fired or had a contract end?

If you answered 'yes' to any of the above then having “Expert Microsoft Office Skills” will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here's why. 

The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you’re not up-skilling, you’re falling behind. It’s scary I know. I’ve experienced this myself.

A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics.

This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory.

 

ONLINE TRAINING AND THE MOST COMMON PROBLEMS

One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time.

Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy.

 

COURSE DELIVERY STYLE

I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing.


WHAT YOU’LL LEARN IN THIS COURSE

In this course I'll take you from knowing nothing about Microsoft Excel to being able to use formatting options, the quick access toolbar, table navigation, row and column control, IF functions, line graphs and charts, image control and artistic effects, text editing features, printing setup and much more! 


ABOUT ME

  1. Member of the Udemy Council
  2. Co-Founded Paperclip Learning which teaches Microsoft Office
  3. Over 60,000 students
  4. Over 130,000 enrollments
  5. Over 5,000 Positive Reviews
  6. Over 20 courses on Udemy

Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics.


TESTIMONIALS

Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks!

Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!!

Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing.

Spencer Berkman - Extremely knowledgeable and clear on instructions.

E Frank - Simple to learn techniques and instructor made it all really easy. Thank you!

Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach

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
08:39:59
+
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
06:18

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
08:28

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
05:09

Before You Start
00:18
+
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
06:02

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
06:23
+
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.

Topics
00:54

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
02:02

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
07:19

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

Creating Table Headings
07:19

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
08:41

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
04:50

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
05:58

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
03:34

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.

Summary
08:18

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.

Quiz
01:12

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
08:19
+
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?
02:23

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
03:31

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
04:22
+
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.

Topics
01:02

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
01:32

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
08:01

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
05:37

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
07:41

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
02:46

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

Adding and Deleting Rows and Columns
05:00

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
03:26

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
06:13

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
06:01

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

Summary
04:02

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.

Quiz
01:20

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
05:45
+
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!
00:05

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)
03:51

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.

Topics
02:14

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
01:38

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
07:32

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"
07:36

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
09:07

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.

Quiz
01:47

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
06:38
+
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.

Topics
02:20

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
01:59

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
04:10

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
06:56

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?
00:26

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
06:51

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.

Summary
04:00

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.

Quiz
01:33

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
08:10
+
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.

Topics
02:22

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
01:43

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
06:08

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
04:27

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
09:38

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
08:17

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

Summary
03:44

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.

Quiz
01:04

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

Quiz Solution
07:07
+
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.

Topics
04:04

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
00:59

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
04:45

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
06:56

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
04:16

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
07:49

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
08:41

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
05:55

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

Summary
11:42

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.

Quiz
01:41

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

Quiz Solution
08:12
2 More Sections
About the Instructor
Jed Guinto
4.4 Average rating
5,440 Reviews
70,808 Students
20 Courses
+70,000 Students, +5,000 Reviews, Professional Trainer

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. Over 60,000 students
  3. Over 130,000 enrollments
  4. Over 5,000 Positive Reviews


WHAT MY STUDENTS SAY ABOUT ME:

Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks! 

Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!!

Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing.

Spencer Berkman - Extremely knowledgeable and clear on instructions.

E Frank - Simple to learn techniques and instructor made it all really easy. Thank you!

Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach.


BIOGRAPHY:

Jed Guinto has an academic background in Aerospace Engineering, System/Database Design, Computer Programming and High Density Data Analysis. He has an Advanced Diploma in Aerospace Engineering, a Bachelor's Degree in Aerospace Engineering with Honours and a Graduate Certificate in Engineering Management. 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 traveled 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 and developed his programming and automation skills. 

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. During this time, he began teaching Excel online. 

In 2015, he was awarded the ARC Discovery Grant Scholarship to pursue his study into Nonlinear Vibro-Acoustics for aircraft carbon-composite applications. Part of experience involved working under former NASA Ames Senior Research Engineer Dr. Jon Watmuff in teaching Computational Engineer Analysis methods to undergraduate students. Surveys from the students he taught had a satisfaction rating of 94%. 

In 2016, he founded Paperclip Learning which teaches Microsoft Excel online. 

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.