Microsoft Excel 2013: Beginner to Advanced
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.
29 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2013: Beginner to Advanced to your Wishlist.

Add to Wishlist

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.
29 students enrolled
Last updated 5/2015
English
Price: $35
30-Day Money-Back Guarantee
Includes:
  • 10.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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!
View Curriculum
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!
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 141 Lectures Collapse All 141 Lectures 10:16:50
+
Excel 2013, Beginner - Course Overview
1 Lecture 00:59

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

Preview 00:59
+
Lesson One - Getting Started with Excel 2013
6 Lectures 36:14

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

Preview 00:26

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.

Identify the Elements of the Application Window
08: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.

Identify the Elements of the Workbook Window
16:10

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.

Create a Basic Worksheet
07:18

Use the Help System
03:47

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

Getting Started with Excel 2013 - Summary
00:23

Getting Started with Excel 2013 - Quiz
3 questions
+
Lesson Two - Performing Calculations
7 Lectures 53:01

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

Preview 00:18

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.

Create Formulas in a Worksheet
10:21

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.

Insert SUM and AVERAGE Functions in a Worksheet
12:26

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.

Insert MIN and MAX Functions in a Worksheet
10:41

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.

Cut and Paste Commands
08:52

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.

Absolute Cell References
10:02

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

Performing Calculations - Summary
00:21

Performing Calculations - Quiz
3 questions
+
Lesson Three - Modifying a Worksheet
10 Lectures 56:22

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

Preview 00:39

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.

The Auto Fill Feature
09:24

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.

The Undo and Redo Commands
06:51

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.

Column Width and Row Height Alteration Methods
07:10

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.

The Hide and Unhide Options
04:39

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.

The Insert and Delete Options
08:41

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.

Cell Names and Range Names
07:05

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.

The Find and Replace Commands
05:06

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.

Spell Check a Worksheet
06:17

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

Modifying a Worksheet - Summary
00:30

Modifying a Worksheet - Quiz
4 questions
+
Lesson Four - Formatting a Worksheet
7 Lectures 38:42

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

Preview 00:30

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.

Modify Fonts
07:48

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.

Add Borders and Color to Cells
06:52

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.

Apply Number Formats
05:27

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.

Align Cell Contents
08:37

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.

Apply Cell Styles
09:08

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

Formatting a Worksheet - Summary
00:20

Formatting a Worksheet - Quiz
5 questions
+
Lesson Five - Printing Workbook Contents
4 Lectures 16:46

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

Preview 00:32

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.

Define the Basic Page Layout for a Workbook
07:53

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.

Refine the Page Layout and Apply Print Options
07:59

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

Printing Workbook Contents - Summary
00:22

Printing Workbook Contents - Quiz
2 questions
+
Lesson Six - Managing Large Workbooks
5 Lectures 19:46

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

Preview 00:28

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.

Format Worksheet Tabs
05:41

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.

Manage Worksheets
08:08

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.

Manage the View of Worksheets and Workbooks
05:05

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

Managing Large Workbooks - Summary
00:24

Managing Large Workbooks - Quiz
3 questions
+
Lesson Seven - Customizing the Excel Environment
10 Lectures 44:37

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

Preview 00:24

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.

Customize General and Language Options
07:36

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.

Customize Formula Options
03:42

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.

Customize Proofing and Save Options
02:53

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.

Customize the Quick Access Toolbar
07:44

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.

Customize the Ribbon
09:22

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.

Customize the Functionality of Excel by Enabling Add-Ins
04:24

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.

Customize Advanced Options
05:10

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.

Customize Trust Center Options
02:59

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

Customizing the Excel Environment - Summary
00:23

Customizing the Excel Environment - Quiz
6 questions
+
Excel 2013, Beginner - Course Follow-Up
1 Lecture 00:45
+
Excel 2013, Intermediate - Course Overview
1 Lecture 01:04

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

Preview 01:04
15 More Sections
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.3 Average rating
247 Reviews
4,743 Students
45 Courses

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.