Microsoft Excel 2013 Simplified: Learn Excel in Just 2 Hours
4.2 (5 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.
25 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2013 Simplified: Learn Excel in Just 2 Hours to your Wishlist.

Add to Wishlist

Microsoft Excel 2013 Simplified: Learn Excel in Just 2 Hours

Pressed for time but want to learn Excel? Become proficient in Excel and enhance your resume to advance in your career.
4.2 (5 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.
25 students enrolled
Created by Sali Kaceli
Last updated 4/2015
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use Excel in a work environment for most of the day-to-day functions. You will start by understanding how functions and formulas work and how to use the effectively hands-on.
  • Apply learned concepts hand-on throughout the course to become proficient as a professional or as a student.
  • Understand not only the basic Excel stuff but also become proficient in using it in your daily work.
  • Learn how to use Excel functions from basic arithmetic calculations to advanced features to analyze the data.
  • Learn how to use Excel without getting frustrated: Explained in a way easy to understand and apply.
View Curriculum
  • The student will need Excel and Word installed in the computer. It is also best if you have two monitors or two devices. Watch the content and complete the course on one and then on the other complete the hands-on project.

At the end of the course you will be proficient in Excel by knowing how to use the most commonly used Excel functions in today's business environment. You will no longer be dreading Excel but rather enjoying it because of the concepts-based, and simple-to-understand approach.

Master Excel in just a couple hours.

  1. Master the basics such as using common functions and formulas
  2. Learn how to work with data such as sorting, filtering, quick analysis and most importantly the charts.
  3. Explore advanced features such as Percentages, IF statement, Financial Calculations.
  4. Learn how to effectively integrate Excel with Word for live reports, and importing and exporting data etc.

I designed this course from a concepts point of view, easy to understand and adaptable to newer upcoming versions of Excel. The high quality video lectures along with the assessments and hands-on working file, will make learning effective for you.

Who is the target audience?
  • This course is not only for the beginners who do not know anything about Excel but also for those that want to sharpen their skills in their job or field of study.
  • No prior knowledge needed. Just the willingness to get started.
  • If you are looking for very advanced functions that are not commonly used, then this course is not for you. However, you will learn the concepts on how things work and from there be prepared to figure things out on your own.
  • Anyone who wants to be a pro. in Excel by investing only a couple hours in the course.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
19 Lectures
Start Here: Getting Started and Understanding Some of the Basic Concepts
6 Lectures 47:51

Excel is the second most used application in a business environment. Whether you are a student, a professional in a general field or a financial guru, knowing how to use Excel effectively is a must. Moreover, it helps you become more effective in your job or career.

So in this journey together, you will learn in a practical way in first understanding how things work in Excel and then secondly applying them. The key in this course is to understand the concepts first and then actually do them. The reason for that is if you understand how spreadsheets work, then you can use any version of Excel, Google Sheets or even open source software in accomplishing your daily tasks. In this course we will use Excel 2013. However, if you follow closely, the same concepts and functions will work in the same way in prior versions.

Let's get started first by getting to learn about the application and where things are so that when we reference something, we would know where things are and make sense out of them.


In this section we are going to learn about:

  • The Quick Access Toolbar: Using and Customizing it
  • The Office Ribbon: The use, purpose and groupings of icons.
  • Naming and renaming the sheets in the worksheet.
  • Excel application options and customizing settings such as the Excel color theme and document default save location.
  • Understand cell references: what we mean when we say C6.
  • Types of values that we can enter in a cell and how to change these values.
  • Understanding the formula/function bar.
Preview 07:17

Before we proceed, let's check how we did so far.

Getting Started with Excel: Knowledge Check
5 questions

Now that you already know how to get around the Excel application, now we will learn a bit about:

  • Formatting cells and text: such as adjusting the font size, merging cells, adjusting the column width, and applying a quick style using the Live Preview feature.
  • Format the numbers in currency.
  • Entering the formula to automatically calculate the sum (total) for a bunch of numbers in a range. We will learn how to do this the manual way to understand the concepts first. In this part we will explain the components of a formula such as the = sign, the function and then the range. The range of numbers can be entered manually or by simply selecting it.
  • Understand how to use the Autofill feature in Excel. Using it with numbers or with other sequential items such as days, months etc.
  • Learn how to find the highest number via a formula.
  • Learn how to find the minimum value in a range by using a formula and then apply the autofill feature.
  • Learn how to find the average and use the autofill feature.
  • Learn how to count how many items are in a range via a formula.
While the video may be a bit long, it is very important to understand these concepts here as they are very foundational in the upcoming lessons. They of course are probably 40% of what someone does with Excel as well in a business environment. So stay tuned. Try to focus and complete the work.

Note there is also a working file that you can use to follow the videos. Learning Excel is like learning to play the piano. You have to practice hands-on to really get these concepts.
Preview 18:18

Make sure you review and follow the video hands-on first using the provided downloadable materials in lesson 2. So when ready, let's check whether you are ready to move to the next lesson.

Formatting and Basic Functions Knowledge Review
4 questions

Here in this section we are going to learn about 15% or more of what Excel users use in their day-to-day profession. It is really the basis of what one does with Excel. Here we use the cases with payroll and calculating deductions, monthly and annual income.

  • Calculate the sum of a couple values also by using the Autofill feature. Remember to use this feature.
  • Calculate the difference between two values using a formula. In this example, the total pay minus the deductions.
  • Calculate the net annual income by learning how to use the multiplication formula. At the same step also learn what the ### mean in a cell and how to correct it.
  • Learn how to calculate the weekly pay based on an annual income.
  • Also why not use actual values in a formula? See the end of the video.

Make sure that you use the hands-on working file attached below. If you downloaded it in the previous lesson, there is no need to download it again. It is the same file. It is provided here for convenience.
Arithmetic Calculations via Formulas: Multiplication, Division, Subtraction

This section may seem a bit out place at this stage of learning. However, it is introduced here because it will save you time and make your use of Excel more effective particularly when used in conjunction with the Autofill feature. After all, that is why you are taking this course.

  • So why use the Absolute References and how do they differ from Relative References? Remember that you want to use absolute references when referencing a single cell that serves as your 'criteria' or point of reference in a calculation that involves a bunch of cells particularly when you are trying to use the Autofill feature. To change a relative reference to an absolute reference, you would use the $sign in front of both the column and row and you can toggle the reference type by pressing F4 on the keyboard.
  • Mixed references: basically references that have a lock on only of the parts of the reference $C4 or C$4. These are used in the cases where you will have more then one point of reference in sequence (i.e in C3 you have discount 1, then in C4 you have Discount 2 etc.

Remember to use working file provided in the previous lesson. The content in this lesson is on the second worksheet under the Types of References: Basic Absolute References.

Understanding Types of Cell References: Relative, Absolute and Mixed References

Just a basic review before we proceed any further.

Arithmetic Calculations via Formulas & Types of References Knowledge Review
2 questions

So prior to advancing to the more advanced and fancy stuff in Excel, let's learn about conditional formatting and how it works with a set of data.

  • Conditional formatting provides a quick visual analysis by easily spotting trends by automatically applying colors or other visual effects. When we change a value, the data analysis changes automatically.
  • Customize the conditions manually or by using certain types of icons or top ten rules.
  • You will also learn how to use the Live Preview when applying conditional formatting.

Use the first page: Basic Calculations from the Working File provided earlier to practice hands-on.
Conditional Formatting and Quick Data Analysis
Working with Data: Sorting, Filtering and Charts
2 Lectures 14:34

Data sorting and filtering is another key area when working with data as a professional no matter what your field. In this lesson we learn how to:

  • Sort the data by different fields in an ascending or descending way.
  • How to apply filtering by one or more fields. This is a great feature to determine how you are doing in analyzing a product or sales etc. Note also how to use the filtering options by right clicking and then customizing the filtering parameters manually by using a Custom Filter.

Use the Data Filtering and Sorting worksheet from the Working File provided earlier.

Filtering and Sorting Data in an Excel Spreadsheet

Just a couple questions for emphasis.

Data Sorting and Filtering Knowledge Review
4 questions

One of the nice features of Excel is the visual representation of data by using charts. There are a few different types of charts and using the proper kind to represent your data is important. You want to ensure your audience understands the point you are trying to make based on the findings from your data.

  • In this lecture we will first explore using the use of bar charts by using multiple sets of data. Based on the type of the selected data, you can also use the Recommended Charts (new in version 2013). The key to creating charts is to first select the data that you want represent in a chart first.
  • Learn also about the Contextual Tools options for charts that show up when you are working with charts and the application of the various chart styles.
  • We will also learn here how to use the Line and Pie charts.

Use Charts 1 and Charts 2 Worksheets from the Working File for this lesson.

Creating and Using Charts

Let's just quickly make sure you understood a couple of the concepts related to charts before we move to the next section for this course.

Charts Knowledge Review
3 questions
Advanced Features: Percentages, IF statement, Financial Calculations, etc.
7 Lectures 44:15

Here we will learn how to create a summary worksheet from a bunch of other sheets. Basically how to post the values from one worksheet to another via a formula. This comes in handy for budgets.

There is another way to do this by using Named References. That lesson will be covered later in this course.

Use Cross-Sheet Calculations sheet in the working file for this project. Then also use January, February and March.

Cross-Sheet Calculations - Posting the Value from one sheet to another

Posting the percentage on how your investment or how your business is grown is key in Excel. In this lecture we will learn how to calculate the percentage via a formula. Fairly easy to do.

Use Calculating Percentages sheet from the working file.

Calculating Percentages for an Investment

The IF logical function is not used quite often in the workplace. However, knowing how to use it is always a good thing. It basically works like this. You are basically saying, if a certain cell value meets a criteria, then you post something like true (or whatever else in words) or you can post a value, if the condition is not true, then you want the computer to post something else.

So checkout the video to understand how this works. It can come in handy to have the computer determine the values or bonuses etc. based on a condition that you set. Note that here you can also use the Autofill and Absolute references that we learned earlier.

Use the If Statement sheet from the working file for this project.

Using the IF Statement in Excel

Learn how to calculate the Payment (PMT), Principal Payment (PPMT) and Interest Payment (IPMT) for a loan in Excel. It comes in handy if you are dealing with financial calculations as well as use it for personal loans etc.

Use the Financial Calculations sheet from the working file for this project.

Performing Financial Functions in Excel: PMT, PPMT, IPMT

Learn how to use named references in formulas in multiple worksheets within a spreadsheet. Instead of using the physical location as we learned earlier, here you can simply call the name of the reference and you are all set in posting the value.

Use Ranges and Drop-Down Lists worksheet for this project.

Using Named References in Excel 2013

If you want to ensure that the data is always entered correctly using validation rules and drop-down lists is always suggested. In this lecture you will learn how to create the lists and set validation rules.

Use Sheet 3 and Sheet 4 for this project from the working file.

Using Data Validation and Dropdown Lists to Minimize Data Entry Errors

Pivot tables are a powerful tool in looking at the data from various angles. I would say it is similar to blending the data and tinkering with it. So you will learn to tinker with the data.

  • The field names must be on the first row
  • The records must be in rows
  • No blanks in the rows, columns

Use the Pivot Tables worksheet from the working file for this project.
Using Pivot Tables in Excel
Other Tools in Excel: Setting the Print Area, Linking Data with Word, Import etc
4 Lectures 15:47

Learn how to set the print area in a spreadsheet prior to to customize printing. The print area is basically an area that you select/choose to print. So here we will learn how to set that.

Setting the Print Area

A lot of times you have to create monthly or regular reports where you will be pulling numbers from an Excel spreadsheet. Wouldn't it be nice to have a mechanism where you can simply change a couple things in your report and then pull the data from your live Excel spreadsheet.

In this video we will learn just that: Link a portion of our spreadsheet with a report in Word. Then we will change data in Excel and open the report and see that that data is automatically updated. Quite helpful.

See the Basic Calculations worksheet from the data file for this project.

Linking Excel Data with Word for Live Reports

Learn about mechanisms to import and export data particularly by using a .csv file. We will import data from a text file in .csv file and then learn how to export data to send to other systems.

See the Invoices List.txt file attached below for this project.

Importing and Exporting Data in Excel

It has been a while since we have not checked how we are doing. So let's see.

Brief Knowledge Review
2 questions

Learn how to share the spreadsheet via email, via the cloud or convert the file into PDF format. It will print only what was selected in the Print Area.

This module is pretty short. And if you made it this far, good for you. You deserve a break but it should have been worth the time.

Saving Data in PDF format directly from Excel
About the Instructor
Sali Kaceli
4.2 Average rating
5 Reviews
25 Students
1 Course
A Seasoned Technologist also Teaching at a U.S. University

With 17+ years of hands-on experience, a graduate degree in technology, certifications like MCSE, CNA and TCT and even teaching experience at a U.S. university, I strive to add value to my valued audience by providing concept-based and simple to understand technology lessons.

I believe technology is simple for anyone if it is presented the right way. My approach is to present the material in a simple way to understand the concepts and then be able to apply it easily.

Check out the courses on this site. You will not be disappointed.