Basic and Intermediate Microsoft Excel 2013 for anyone
4.0 (6 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.
26 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Basic and Intermediate Microsoft Excel 2013 for anyone to your Wishlist.

Add to Wishlist

Basic and Intermediate Microsoft Excel 2013 for anyone

Easy, understandable and bite-size lessons for students, professionals, household managers and anyone else!
4.0 (6 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.
26 students enrolled
Created by Tobias Vermeer
Last updated 3/2015
English
Current price: $10 Original price: $20 Discount: 50% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use excel in the best way possible to enhance your (professional) life
View Curriculum
Requirements
  • You should already have installed Microsoft 2007, 2010 or 2013.
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
83 Lectures
05:55:38
+
The Beginnings
5 Lectures 18:16

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.

Preview 02:03

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

Preview 01:10

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.

Preview 05:36

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

Preview 04:42

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.

Preview 04:45

Test your knowledge of the past section!

The Beginnings Quiz
4 questions
+
The Worksheet
7 Lectures 25:08

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

Printing and Exporting to PDF
04:27

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.

Navigating, Naming and Creating Multiple Worksheets
02:49

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.

Protecting your worksheet
02:32

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

Hiding and Unhiding
02:04

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

Interacting with rows and columns
03:51

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

Summary of The Worksheet
05:30

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

Section 2 Assignment
03:55

Test your knowledge of the section!

The Worksheet Quiz
8 questions
+
Layout
5 Lectures 14:20

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.

Freezing, Splitting Panes and other Sheet Options
05:05

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.

Themes
02:47

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

Backgrounds
01:35

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

Summary of Layout
01:51

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

Section 3 Assignment
03:02

Test your knowledge of the section!

The Layout Quiz
5 questions
+
Data Basics
10 Lectures 52:43

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.

Entering Data and Data Formats
08:36

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

Referring to Cells and other Worksheets
02:08

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.

Copying, Pasting and Absolute/Relative Referral
07:10

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.

The FILL Handle, AutoFill and Flash Fill
05:11

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

Undoing and Redoing things
02:41

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

Finding and Replacing Data
03:09

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.

Different Paste Options (Transposing, Only Values, Only Formatting etc.)
04:43

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

Data Validation
06:01

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

Summary of Data Basics
05:57

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

Section 4 Assignment
07:07

Test your knowledge of the section!

The Data Basics Quiz
9 questions
+
Formatting
6 Lectures 21:43

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

Changing Cell Fill, Font and Border
04:32

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.

Merging and Wrapping Cells
03:11

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.

Content Alignment and Direction of a Cell
04:09

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.

Format Painter and Clearing Cells
03:06

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

Summary of Formatting
02:26

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

Section 5 Assignment
04:19

Test your knowledge of the section!

The Formatting Quiz
7 questions
+
Basic Formulas & Functions
13 Lectures 01:11:12

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

Preview 04:04

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.

The SUM, AVERAGE and COUNT Functions
03:58

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.

The IF, SUMIF, AVERAGEIF and COUNTIF Functions
11:01

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.

The MAX and MIN Functions
02:58

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.

The RIGHT, LEFT and MID Functions
04:02

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

The TRIM, UPPER, LOWER and CONCATENATE Functions
03:14

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.

Name Ranges and the Intersection Operator
08:12

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

Calculation Operators and Order of Operations in Excel
06:20

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.

3D Referencing Cells
03:18

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.

Cell Grouping and Subtotals
05:10

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.

The Circular Reference Error and Tracing Precedents/Dependents
05:52

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

Summary of Basic Formulas & Functions
05:13

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

Section 6 Assignment
07:50

Test your knowledge of the section!

The Formulas & Functions Quiz
10 questions
+
Applying Our Knowledge 1
1 Lecture 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!

Building an elegant budgeting tool
19:58
+
Tables
5 Lectures 17:11

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

Creating a Table
04:32

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

Table Sorting and Searching
03:56

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

Table Filters and Slicers
04:38

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

Summary of Tables
01:21

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

Section 8 Assignment
02:44

Test your knowledge of the section!

The Tables Quiz
5 questions
+
Basic Graphs
6 Lectures 30:23

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

Creating a basic Graph
04:04

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.

Explaining the different Graph Types
10:36

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

Different Graph Options
07:40

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

Sparklines
03:25

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

Summary of Basic Graphs
01:22

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

Section 9 Assignment
03:16

Test your knowledge of the section!

The Graphs Quiz
8 questions
+
Graphical Objects
5 Lectures 14:28

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

SmartArt
02:49

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

Shapes
02:28

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

Screenshots and Pictures
02:48

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

Summary of Graphical Objects
01:43

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

Section 10 Assignment
04:40

Test your knowledge of the section!

The Graphical Objects Quiz
4 questions
5 More Sections
About the Instructor
Tobias Vermeer
4.0 Average rating
6 Reviews
26 Students
1 Course
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!