Microsoft Excel 2013: Beginner to Advanced

Learn useful features and helpful functions with this online Microsoft Excel 2013 course.
4.1 (7 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.
28 students enrolled
$19
$35
46% off
Take This Course
  • Lectures 141
  • Length 10.5 hours
  • Skill Level All Levels
  • 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 5/2015 English

Course Description

Whether you have never used Excel, or want to master the more advanced features and functions of Excel 2013, this course will make you proficient in no time at all!

In this Microsoft Excel 2013 Training course, you will learn by watching the instructor actually conduct the exercises as she explains step-by-step how to perform these functions. The training starts with the absolute basics of creating your very first worksheet and slowly progresses through learning numerous capabilities of this very powerful program. The topics range from creating very basic formulas to more advanced functions like table editing, the help function and more.

The Microsoft Excel 2013 course will also strengthen the skills that you have already, while also giving you some new techniques for Excel:

  • To organize your worksheet and table data using various Options.
  • Create and modify charts.
  • Customize workbooks and enhance your Microsoft Office Excel Environment.
  • Modify graphic objects in a worksheet, analyze data using Pivot Tables, slicers and Pivot Charts.

Taking this course will explain the processes of how to accomplish some common tasks you need in Excel. You will learn to automate common tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

Check what you've learned at the end of each lesson with our quizzes.

Our Microsoft courses help you to prepare for the official Microsoft Office Specialist exam.

What are the requirements?

  • It is recommended to have a copy of Excel 2013 installed on your computer, although you could just as easily use someone else's computer as well...
  • This course will become increasingly more complicated as you continue through each lesson, so don't forget to bring your thinking cap!

What am I going to get from this course?

  • Organize worksheet and table data using various the Options.
  • Create and modify charts.
  • Customize workbooks and enhance the Microsoft Office Excel 2013 Environment.
  • Modify graphic objects in a worksheet.
  • Analyze data using Pivot Tables, slicers and Pivot Charts and more!

What is the target audience?

  • This course is meant for those who are only just beginning in Excel, all the way up to the most advanced Excel Users!
  • If you consider yourself a professional when working with Excel 2013, this course may not be for you... Although who knows? You may still learn a thing or two.

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: Excel 2013, Beginner - Course Overview
00:59

A short overview of what will be presented in this course.

Section 2: Lesson One - Getting Started with Excel 2013
00:26

A brief introduction of what will be covered in this lesson.

08:10

When you start Excel, two windows are displayed, one within the other. The outer window is the application window that usually fills the entire screen and provides various interactive tools and commands. In this video we will identify the elements of the application window.

16:10

When Excel opens, two windows are displayed, one within the other. The inner window is the workbook window, where you will work with all of your data. In this lesson we will take a look at the different elements that make up the workbook window.

07:18

In this video, we are going to create a basic Excel worksheet. By creating a simple worksheet, you can lay the foundation for creating more complex workbooks to store and work with your data.

Use the Help System
03:47
00:23

An end of lesson summary of what was covered in this lesson.

Getting Started with Excel 2013 - Quiz
3 questions
Section 3: Lesson Two - Performing Calculations
00:18

A brief introduction of what will be covered in this lesson.

10:21

Excel is a calculation tool. The correct entry of a formula is especially important for later calculations. In this video you'll learn about the configuration and entry of formulas.

12:26

When working with Excel, there is another way to calculate data which is to use mathematical functions. In this lesson, you will insert functions in a worksheet.

10:41

When entering functions in Excel, there is more than one way to do this. In this next video, we are going to learn how to enter in the functions Min and Max using the Function Library and AutoSum Button.

08:52

In many instances, similar formulas can be required to calculate similar data, and Excel enables you to reuse many workbook elements, including formulas, to save time. In this topic, you will reuse formulas by copying and pasting them.

10:02

Excel differentiates mainly between relative and absolute cell references. In this video you'll learn how to use absolute cell references in formulas. Make sure to understand this concept and you will master Excel soon.

00:21

An end of lesson summary of what was covered in this lesson.

Performing Calculations - Quiz
3 questions
Section 4: Lesson Three - Modifying a Worksheet
00:39

A brief introduction of what will be covered in this lesson.

09:24

In Excel 2013, the Auto Fill options enable you to specify how a selected cell range should be filled with data. In this video, we will take a look at how to use the Auto Fill.

06:51

In this video you'll learn how to undo, or redo, your work in Excel. This is especially important if you have made a mistake and want to back track to the wrong step.

07:10

To change the size of a cell, you must adjust the width of the column, the height of the row, or both. Excel provides several methods that you can use to change the size of cells. In this lesson we will learn how to adjust our column width and row height.

04:39

The Hide option enables you to suppress the display of columns or rows in a worksheet, while the Unhide option enables you to display previously hidden columns or rows. In this video we will learn how to hide and then unhide some of our data.

08:41

In Excel you can insert and delete cells, columns or rows to help make viewing your data easier. In this lesson we will learn how to insert and delete, cells, columns or rows.

07:05

When you need to update data in a large worksheet, manually searching for that data by visually examining each cell can be a time-consuming and tiresome process, and you may not even locate the data in question. By using Excel the cell names option, you can quickly and accurately locate data in large worksheets.

05:06

By using Excel options such as cell names and the Find and Replace commands, you can quickly and accurately locate and change data in worksheets of virtually any size.

06:17

In any situation where you are entering data into an electronic file, there is a chance that you might mistype or misspell a word, which can detract from the appearance and accuracy of your work.

00:30

An end of lesson summary of what was covered in this lesson.

Modifying a Worksheet - Quiz
4 questions
Section 5: Lesson Four - Formatting a Worksheet
00:30

A brief introduction of what will be covered in this lesson.

07:48

In this lesson, you will format a worksheet. One way to format worksheet data is to change the appearance of the text. In this topic, you will modify fonts.

06:52

One way to differentiate different cell areas and call attention to information is to use borders and colors to highlight certain cells. In this topic, you will add borders and colors to cells to highlight some important information in the data.

05:27

Another way to enhance the readability of your worksheet is to format the values that are displayed in the worksheet. In this topic, you will apply number formats.

08:37

When you enter data into a cell, Excel might not display the content within the cell exactly as you expected. Aligning the content within a cell improves the appearance of the worksheet.

09:08

When similar cells are formatted differently, this can cause confusion because of the inconsistency in formatting. Ensuring that formatting options are consistently applied throughout a workbook can be a time-consuming task. You can use cell styles to quickly apply multiple formatting options to cells at the same time for a neat and consistent appearance.

00:20

An end of lesson summary of what was covered in this lesson.

Formatting a Worksheet - Quiz
5 questions
Section 6: Lesson Five - Printing Workbook Contents
00:32

A brief introduction of what will be covered in this lesson.

07:53

When it is time to share a workbook with others, you might want to accomplish this by providing a paper copy. Firstly, however it is good to format the document for the convenience of the viewer. In this lesson, you will learn how to format a document that is ready to be printed.

07:59

Ready to share a workbook with others? If need be you could always print it, but don't forget to clean it up a bit before you do so. An attractive looking document has far more impact than a sloppy one. In this lesson, you will print the contents of a Microsoft® Office Excel® 2013 workbook.

00:22

An end of lesson summary of what was covered in this lesson.

Printing Workbook Contents - Quiz
2 questions
Section 7: Lesson Six - Managing Large Workbooks
00:28

A brief introduction of what will be covered in this lesson.

05:41

One way to make multi-page workbooks easier to navigate is to change the appearance of the worksheet tabs. In this topic we will learn how to manage our Workbook tabs by renaming, moving and deleting them.

08:08

Another facet of managing large workbooks includes moving sheets, inserting and removing sheets, hiding and unhiding worksheets, and referring to cells on other worksheets. In this topic, you will manage worksheets.

05:05

Another way to manage large workbooks is to change how workbook content is displayed. In this topic, you will manage the view of worksheets and workbooks by changing the way our data is displayed.

00:24

An end of lesson summary of what was covered in this lesson.

Managing Large Workbooks - Quiz
3 questions
Section 8: Lesson Seven - Customizing the Excel Environment
00:24

A brief introduction of what will be covered in this lesson.

07:36

When you start working with a new software application, the interface might not provide you with convenient access to all of the options that you need, or the interface might include options that you do not need at all. You can adjust some general and language options to make the application easier for you to use. In this topic we will learn how to change the general and language options to suite our personal needs.

03:42

You can customize options that deal with formulas and calculations by customizing calculations, how you work with formulas and you can also allow Excel to check for errors in your formula. In this topic, you will customize formula options.

02:53

In this topic we are going to customize options related to proofing and saving. By customizing proofing and save options, you can streamline your work processes to save time and effort.

07:44

In this topic we are going to customize the Quick Access Toolbar. By customizing the Quick Access Toolbar you can add or remove commands, remove all customizations and import or export customizations giving you fast and easy access to your most commonly used commands and options.

09:22

In this topic we will customize the appearance of the ribbon and the commands that are displayed, giving you fast and easy access to your commonly used commands and options.

04:24

Another way to customize Excel is to add functionality through the use of Microsoft Office add-ins. In this lesson, you will customize the functionality of Excel by enabling add-ins which will help increase your productivity.

05:10

As you become more experienced with Excel, you might find that there are certain advanced options that you want to customize like „after pressing Enter“-Action, Allow AutoComplete or change decimal separators. In this topic we are going to customize some of our Advanced Options.

02:59

In this lesson we are going to learn how to customize the Trust Center Options. Customizing options related to security issues will help keep your documents safe and your computer secure and healthy.

00:23

An end of lesson summary of what was covered in this lesson.

Customizing the Excel Environment - Quiz
6 questions
Section 9: Excel 2013, Beginner - Course Follow-Up
Course Follow-Up
Preview
00:45
Section 10: Excel 2013, Intermediate - Course Overview
01:04

A short overview of what will be presented in this course.

Section 11: Lesson One - Creating Advanced Formulas
00:50

A brief introduction of what will be covered in this lesson.

06:53

There is a large amount of data and it is not always easy to find the information you need quickly. In this video we will give a clear, concise and descriptive name to a single cell or a range of cells so the information is always readily available. This is called a Range Name.

03:37

Over time, you may no longer need to use a Range Name that you have created. Editing and deleting cell name ranges can only be done in the NAME MANAGER. Learn why and how to edit and delete cell names in this next video.

06:16

You want to reduce errors and increase the readability of your worksheets as the amount of data increases. Instead of using cryptic cell addresses, you can improve your workbooks by performing calculations using RANGE NAMES.

06:40

Creating advanced formulas in some cases, opens the door to some of the most advanced functionality Excel 2013 has to offer. In this video, you will learn what a function syntax is and how to find the functions that you are looking for.

02:51

There are lots of sales, and you need to calculate the number of each item sold. You will learn about the SUM function syntax and how to use the SUM function to get the information you need.

03:24

You need to figure out how long each person has worked at your company and the average of all employees combined. In this video you will learn about the AVERAGE function syntax and how to create an AVERAGE calculation.

03:44

You have a list of employees and you want to calculate the shortest term of employment. The Minimum (MIN) function will help you find the lowest value in large amounts of data.

03:14

You have a year's worth of sales data and you want to know which product sold the most. The Maximum (MAX) function will help you find the highest value in a large list of numbers.

07:07

Whenever you are looking to get the number of entries in a number field that is in a range or array of numbers, you would use the COUNT function to help find the correct result. In this topic, you will learn about the COUNT function syntax and how to use this function.

04:50

You may want to reduce a calculated value to a specific number of decimal places. In this video you will learn how to do this with the ROUND function.

04:27

To answer a question like "Which employees are candidates to be the Potential EU Branch Manager? “, you would use a logical function. We often have to deal with “Logical Tests” in IF Functions for example. You can however, use the AND function which enhances our capabilities to create sophisticated logical tests.

04:48

To improve the readability of our worksheets, we want to combine multiple cells into one cell and this is where CONCATENATE comes in. When working with this function, instead of using a "," to separate your arguments, you can also use the "&" symbol to achieve the same result .

04:42

To help you find answers to questions such as, "What year did Employee X start working here?" you could use either the VLOOKUP or HLOOKUP functions, depending on how your data is set up. They are powerful functions that enable you to find data based on specific criteria. In this topic we will learn how to use the VLOOKUP function.

00:32

An end of lesson summary of what was covered in this lesson.

Creating Advanced Formulas - Quiz
2 questions
Section 12: Lesson Two - Analyzing Data with Logical Functions
00:39

A brief introduction of what will be covered in this lesson.

06:13

You may find that in some cases you would like to increase the flexibility of the function, by increasing the number of possible outcomes. You can use the Nested IF function to accomplish this task, by placing a second IF function inside the first to test additional conditions.

03:38

To answer a question like "Is this author an early producer? “, you would use a logical function. In Excel 2013's there are seven logical functions that you can choose from and these functions run logical tests on your data. In this video we will be working with two functions, AND and OR.

00:25

An end of lesson summary of what was covered in this lesson.

Analyzing Data with Logical Functions - Quiz
2 questions
Section 13: Lesson Three - Organizing Worksheet Data with Tables
00:36

A brief introduction of what will be covered in this lesson.

05:00

Your data is not organized and it is hard to find specific information, now you would like to organize your data using a table. A table is a dataset composed of contiguous rows and columns that Excel treats as a single, independent data object. When a standard dataset is converted to a table, the header row converts from plain text labels into sortable fields. We will take a look at how to create and then modify your Excel tables.

03:56

It is the end of the quarter and you would like to sort your data to see the highest to lowest income earned, so you can start planning for the next quarter. To sort data means to change the order of data in a row or column and in this topic we will learn the basics of sorting.

02:34

After you have sorted your data, you may realize that there is some other information you would like to see, for example a specific market. Along with sorting you can also apply filters to your data and to filter data means to remove from your view, any data that does not meet certain criteria. In this lesson you will learn how to use the powerful AutoFilter options.

05:32

If the data you want to filter requires complex criteria like "Which authors have been with F&A for less than 5 years and have sold more than 500,000 books?” you can use The Advanced Filter dialog box. This allows you to create complex data filters that filter data on a variety of user-defined criteria. In this topic you will learn how to use The Advanced Filter option.

04:06

You have sorted your data and you realize that you have duplicates throughout your entire worksheet, so you decide that its best to remove these duplicates. In Excel 2013, you have the ability to remove duplicates and in this video you will learn how to do that.

06:08

To leverage the power of summary functions in tables, it's generally a good idea to add a Total Row to the table first. From the Total Row, you can indicate what type of summary calculation you're looking for, like COUNT for example. In this video we will learn how to insert the Total Row and how to use it.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.

Ready to start learning?
Take This Course