Microsoft Excel 2013 Simplified: Enhance your Resume Easily

Become proficient in Excel and enhance your resume to advance in your career. Concepts based, simple to understand.
4.1 (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.
23 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 19
  • Length 2 hours
  • Skill Level Beginner Level
  • 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 4/2015 English

Course Description

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.

What are the requirements?

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

What am I going to get from this course?

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

What 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.

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: Start Here: Getting Started and Understanding Some of the Basic Concepts
Article

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.

07:17

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.
5 questions

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

18:18

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.
4 questions

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.

07:19

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.
10:19

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.

2 questions

Just a basic review before we proceed any further.

03:54

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.
Section 2: Working with Data: Sorting, Filtering and Charts
06:06

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.

4 questions

Just a couple questions for emphasis.

08:28

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.

3 questions

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.

Section 3: Advanced Features: Percentages, IF statement, Financial Calculations, etc.
06:42

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.

04:54

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.

07:37

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.

09:56

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.

05:15

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.

03:43

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.

06:08

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.
Section 4: Other Tools in Excel: Setting the Print Area, Linking Data with Word, Import etc
04:34

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.


05:04

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.

04:20

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.

2 questions

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

01:49

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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sali Kaceli, 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.

Ready to start learning?
Take This Course