Basic and Intermediate Microsoft Excel 2013 for anyone

Easy, understandable and bite-size lessons for students, professionals, household managers and anyone else!
4.6 (4 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.
19 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 83
  • Length 6 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 3/2015 English

Course Description

In this Microsoft Excel 2013 course, I will introduce you to the basic concepts of Microsoft Excel 2013 and together we will slowly work through all that Microsoft Excel 2013 has to offer.

Whatever age, background or job, my course is intended on teaching anyone a comprehensive and solid foundation of Microsoft Excel 2013, that also applies to Microsoft Excel 2007 and 2010.

Furthermore, this course will cover most aspects that someone is required to know in order to successfully take the MOS (Microsoft Office Specialist) Excel exam.

Each video will contain me talking you through a certain concept in Microsoft Excel 2013, while at the same time showing how to use this concept in the video. I will go step-by-step so that everyone will be able to follow and understand what I am doing.

The lectures will contain a clear structure of:

  • Why the contents of the lecture are important to know.
  • What you can do with the contents of the lecture
  • How to do what I am explaining in the lecture

Throughout the course there are several videos where, together with me, you will create a basic Excel tool using the knowledge you have thus far obtained. This will serve to show you what you can do with Microsoft Excel 2013, as well as solidify the learnt concepts.

Upon completion of the course you will be able to work with Microsoft Excel 2013 in any basic office, school, university or personal setting.

What are the requirements?

  • You should already have installed Microsoft 2007, 2010 or 2013.

What am I going to get from this course?

  • Use excel in the best way possible to enhance your (professional) life

What is the target audience?

  • This Microsoft Excel 2013 course is meant for beginners and intermediates who want to learn or enhance their skills in and usage of Microsoft Excel 2013. No prior knowledge is needed when starting this 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: The Beginnings
02:03

In this lecture I will be introducing you to Microsoft Excel 2013, what it is, what it can do, and why you should learn to use it.

01:10

In this lecture I will be talking about what you can expect to be able to do at the end of the entire course.

05:36

In this lecture I will be talking about the elements of the File Menu, and how it helps you use Microsoft Excel 2013 in a better way.

04:42

In this lecture I will be talking about all the items on the Ribbon, and talk about the different segments it is divided in.

04:45

In this lecture I will be talking about how you can customize and personalize Microsoft Office 2013 in such a way that it works better for you.

4 questions

Test your knowledge of the past section!

Section 2: The Worksheet
04:27

In this lecture we will be looking at how you can print your excel file or how you can export it to PDF.

02:49

In this lecture we will look at how to navigate your worksheets, and how to name and create multiple worksheets. We will even look at how you can give each of your worksheet tabs a different color.

02:32

In this lecture we will look at how you can protect your worksheet so that no one else can make changes, unless they have the password.

02:04

In this lecture we will be looking at how you can hide and unhide your worksheets and workbooks.

03:51

In this lecture we will look at in what ways you can interact with the rows and columns in your workbook.

05:30

This lecture is a summary of all the concepts dealt with so far in the section.

03:55

This lecture is an assignment to test your practical knowledge of the concepts explained in this section.

8 questions

Test your knowledge of the section!

Section 3: Layout
05:05

In this lecture we will be looking at how you can freeze and split your panes within the worksheet, as well as look at some other sheet options.

02:47

In this lecture we will be looking at how you can implement different themes into your excel file to make it look just the way you want it to.

01:35

In this lecture we will look at how to add backgrounds to spice up your excel files.

01:51

This lecture is a summary of all the concepts dealt with so far in the section.

03:02

This lecture is an assignment to test your practical knowledge of the concepts explained in this section.

5 questions

Test your knowledge of the section!

Section 4: Data Basics
08:36

In this lecture we will go into the data basics, starting with how to enter data and the different data formats that are present in excel.

02:08

In this lecture we will look how you can refer to cells from another cell, and how this can even cross worksheets and workbooks.

07:10

In this lecture we will look at the copying and pasting of data, and the variations of referral that make copying and pasting a little bit easier.

05:11

In this lecture we will look at how the FILL handle, AutoFill and Flash Fill can provide you some easy-of-use and efficient working in Excel.

02:41

In this lecture we can look at how to undo any mistakes you make, and how to redo any actions you undid.

03:09

In this lecture we will look at how you can find data in Excel effectively, and how to replace it.

04:43

In this lecture we will look at the various paste options that are present in Excel to help you to be more effective in Excel.

06:01

In this lecture we will look at how you can let Excel validate the things that users put into your Excel file.

05:57

This lecture is a summary of all the concepts dealt with so far in the section.

07:07

This lecture is an assignment to test your practical knowledge of the concepts explained in this section.

9 questions

Test your knowledge of the section!

Section 5: Formatting
04:32

In this lecture we will look at how to add some flair to the cells in your workbook.

03:11

In this lecture we will look at how you can use merging and wrapping cells to make the layout of your excel file more pleasant.

04:09

In this lecture we will look at how you can use content alignment and cell direction to make the layout of your Excel file more appealing.

03:06

In this lecture we will look at how you can use the Format painter to quickly get any beautiful formatting on one cell to any other cell you desire, and how to clear anything you don't want anymore.

02:26

This lecture is a summary of all the concepts dealt with so far in the section.

04:19

This lecture is an assignment to test your practical knowledge of the concepts explained in this section.

7 questions

Test your knowledge of the section!

Section 6: Basic Formulas & Functions
04:04

In this lecture we will look at the basics of creating a formula in Excel.

03:58

In this lecture we will look at three core functions present in Excel, the SUM function for adding values together, the AVERAGE function for finding averages, and the COUNT function to see how many entries a certain range of data has.

11:01

In this lecture we will look at the important logical IF function, and the logical adaptions of the SUM, AVERAGE, and COUNT functions: the SUMIF, AVERAGEIF and COUNTIF functions.

02:58

In this lecture we will look at two functions that enable you to quickly find the maximum and minimum value in large sets of data.

04:02

In this lecture we will look at the RIGHT, LEFT, and MID functions that will enable you to quickly select a number of characters from a piece of text.

03:14

In this lecture we will look at four functions that help you to easily manipulate text.

08:12

In this lecture we will look at how you can name ranges of data to your liking, how to use them in functions and what the Intersection Operator is and does.

06:20

In this lecture we will look at all the different ways of calculating things in Excel and in what order Excel calculates them.

03:18

In this lecture we will look at yet another way of referring to other cells; 3D referencing. Enabling you to get lots of data along multiple worksheets.

05:10

In this lecture we will look at how you can group pieces of your worksheet together, add subtotals to ranges of data and even subtotals within the already subtotaled ranges of data.

05:52

In this lecture we will look at the annoying circular reference error, what it is, why you should avoid it and how to avoid it. Also, we will look at how to trace precedents and dependents of cells.

05:13

This lecture is a summary of all the concepts dealt with so far in the section.

07:50

This lecture is an assignment to test your practical knowledge of the concepts explained in this section.

10 questions

Test your knowledge of the section!

Section 7: Applying Our Knowledge 1
19:58

In this long lecture, we will build an elegant budgeting tool step-by-step using the concepts learnt so far. This will help you to experience what Excel can enable you to do, and take you through using and practicing with the concepts that we have dealt with. And as a nice bonus, at the end you will have a fully functional budgeting tool to use for yourself!

Section 8: Tables
04:32

In this lecture we will look at how you can create a table in Excel.

03:56

In this lecture we will look at the power of tables using table sorting and searching.

04:38

In this lecture we will look at the power of tables using table filters and slicers.

01:21

This lecture is a summary of all the concepts dealt with so far in the section.

02:44

This lecture is an assignment to test your practical knowledge of the concepts explained in this section.

5 questions

Test your knowledge of the section!

Section 9: Basic Graphs
04:04

In this lecture we will look at how you can visualize your data using graphs.

10:36

In this lecture we will look at all the different types of graphs that are present in Excel, when to apply them, and what type of data they are useful for.

07:40

In this lecture we will look at how you can customize a graph to your liking.

03:25

In this lecture we will look at how you can insert cool one-cell graphs into your worksheet

01:22

This lecture is a summary of all the concepts dealt with so far in the section.

03:16

This lecture is an assignment to test your practical knowledge of the concepts explained in this section.

8 questions

Test your knowledge of the section!

Section 10: Graphical Objects
02:49

In this lecture we will look at how to insert SmartArt into your worksheet.

02:28

In this lecture we will look at how to insert shapes into your worksheet.

02:48

In this lecture we will look at how to insert pictures and screenshots into your worksheet.

01:43

This lecture is a summary of all the concepts dealt with so far in the section.

04:40

This lecture is an assignment to test your practical knowledge of the concepts explained in this section.

4 questions

Test your knowledge of the section!

Section 11: Advanced Formatting
02:48

In this lecture we will look at how you can use comments to review an Excel file easily.

06:02

In this lecture we will look at the visual power of conditional formatting, and how you can harness this power.

05:50

In this lecture we will look at even more visual power of conditional formatting.

Summary of Advanced Formatting
01:09
Section 11 Assignment
03:43
5 questions

Test your knowledge of the section!

Section 12: Security
02:45

In this lecture we will reminisce on workbook protection that we dealt with in the beginning of the course, as well as look at some further security concepts.

04:00

In this lecture we will continue looking at how you can use several security options to protect your workbook and sheets.

Summary of Security
02:28
Section 12 Assignment
02:54
5 questions

Test your knowledge of the section!

Section 13: Advanced Navigation & Handling
03:03

In this lecture we will look at a list of useful short-cuts in Excel that will make your Excelling life a lot easier.

02:16

In this lecture we will look at how you can analyze sets of data quickly and easily using Quick Analysis.

02:26

In this lecture we will look at how you can link to files and webpages outside of your Excel file, and even how you can insert Word documents and more into your Excel file.

Summary of Advanced Navigation & Handling
01:19

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Tobias Vermeer, Easy Excel for Everyone

My name is Tobias Vermeer, but you all can call me Toby, and I am an International Business Adminsitration student from The Netherlands.

My experience in Excel is quite extensive. I have been able to obtain my Microsoft Office Specialist certificate in Excel, which is an official certificate by Microsoft handed out after taking part in an exam to show your expertise within a certain part of Microsoft Office. For me this was Excel. Furthermore, I have developed (financial) tools and databases in excel for a Dutch pharmaceutical company with both the use of pure Excel functions and formulas and Visual Basic (VBA). These tools ranged from simple financial statements to project analysis, revenue tracking and more. Also, I have done statistical & economical analysis using Excel as part of the excellency program at my university and have done risk and investment analysis within Excel as well. The statistical & economical analysis involved using Excel for simulating demand and supply curves within the global coffee market to prove and visualize certain economical occurrences. The risk analysis involved creating a large market simulation in Excel to accurately define the risk rate of an investment project for a company. Alongside that I have adopted Excel as a hobby and try to constantly find new ways to improve my skills and create new, useful tools and programs. As such I have already been able to create a wide range of useful tools, like personal budgeting tools, planning tools, economical simulations and more. I am constantly trying to learn and improve.

My goal here is to teach everyone who wishes to know more about Microsoft Excel in an easy and understandable way, so that everyone can enjoy the power of Excel!

Ready to start learning?
Take This Course