Learn Microsoft Excel 2013
3.8 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
25 students enrolled

Learn Microsoft Excel 2013

Fast moving, easy to follow Microsoft Excel 2013 tutorial from the e-learning experts!
3.8 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
25 students enrolled
Created by ClipTraining Inc
Last updated 9/2013
English [Auto]
Current price: $11.99 Original price: $19.99 Discount: 40% off
9 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • After completing this course you'll have the ability to prove your mastery of Microsoft’s standard spreadsheet application. With the skills learned in these easy to follow videos, any user will be fully competent and capable of working in a variety of business settings.
  • Microsoft Excel 2013

In this Microsoft Excel 2013 course, ClipTraining provides a comprehensive instruction starting with the basics and on through the advanced features.

With over 100 Video Tutorials and more then 4 hours of training; ClipTraining helps both the beginner and advanced user visualize what they are learning with step-by-step instruction from a Microsoft Excel Professional.

Watch as the instructor performs progressive operations in each video starting with the Basics of Worksheets. Then moving onto Formatting, Formulas, Illustrations and Charts, Printing, and finishing off with 20 part sections on Advanced Excel Features.

Along with the task-based, to-the-point videos, you'll receive an excellent downloadable 'ClipStart' PDF with helpful tips to get you started.

Take this course to learn all about Excel 2013 and be on your way to becoming a Microsoft Office pro.

Who this course is for:
  • Anyone interested in learning Excel 2013 from beginners to advanced users. This course will help you learn the basics or refresh your knowledge and then provide a deeper understanding of advanced features. These videos are ideal for visual learners.
Course content
Expand all 102 lectures 03:26:01
+ An Introduction to Excel 2013
16 lectures 29:36

Let's get started with Microsoft Excel 2013! In this clip, we will take a look around the Excel window, label the parts, and see how to better navigate the new interface.

Preview 05:13

In this clip we will take a close up look at the main tabs and groups on the ribbon. Group names on the ribbon will cluster similar commands in groups so you can save time looking for a command. See how screen tips can help you learn about a particular ribbon command.

Preview 02:07

In this clip we'll take a closer look at the Home Tab & the different groups such as Fonts, Editing, and more that we will be able to have quick and easy access to.

Preview 01:05

Would you like to be able to insert something in your worksheet? How about a table or a chart? In this clip we'll take a closer look at the Insert Tab and the different options it offers to us.

Exploring the Insert Tab

Need to change the page lay-out to better suit your needs? Then watch this clip and we'll take a closer look at the Page Layout tab & the groups we find in it.

Exploring the Page Layout Tab

Microsoft Excel 2013 offers a great place to help you build formulas. Take look into what the Formulas Tab has to offer.

Exploring the Formulas Tab

When we need help working with the Data in our spreadsheet, the Data Tab is a great place to look. We can manage our Connections, Sort and Filter, and Outline our Data.

Exploring the Data Tab

Reviewing Spreadsheets has never been easier than with the Review Tab. With groups such as Proofing and a way to track the changes, the Review Tab is a great asset to Microsoft Excel 2013!

Exploring the Review Tab

Let's not forget the View Tab. A great place to look at what your viewing in Excel. In this clip we'll take a closer look at the View Tab & the different groups it offers to us.

Exploring the View Tab

No more bland worksheets with default fonts and colors after this clip! Get the facts on how to quickly customize the look of your worksheet using different fonts. You never knew you could be so creative in Excel! See how to use bold, underline, and italics along with alot of other Font options to choose from in this quick clip.

Exploring the Font Group

Don't worry, after watching how to utilize the Font Dialog Box with its preview feature, you'll have all the confidence you need to get the most out of your fonts. This short lesson will get you quickly up to speed on this feature.

Exploring the Font Dialog Box

Explore how to precisely position your text; whether in a cell or a group of cells. One example provided in this lesson is how to use the Merge and Center command. This joins the selected cells into one larger cell and then centers the contents. This feature is practical when you need to use labels that span multiple columns.

Exploring the Alignment Group

Ever wonder how to make your text appear on an angle in your worksheet? Or how about to change it back if it is angled? Wonder no more after watching this brief tutorial clip! By using the Dialog Launcher in the Alignment Group we can see how to align and orient our text.

Exploring the Alignment Dialog Box

Use the Number Group to format your numbers. This lesson takes a closer look at number styles such as a comma, dollar sign, and other accounting formats along with increase and decrease commands.

Understanding the Number Group

Where is the command to open the Number Dialog Box? Find out in this clip. Also learn about different numerical categories you can assign to a cell or range such as currency, accounting, date, percentage, fraction and much more. All in just under 2 minutes!!

Using the Number Dialog Box

Do you think the Ribbon takes up too much space? See how we can hide the ribbon & still have easy access to the tools on it.

Hiding the Ribbon
+ Behind the Scenes with Backstage View
11 lectures 16:32

What happens when you click on the File Tab? You go into Backstage View! See what it looks like and how to get back to your spreadsheet.

Entering & Exiting Backstage View

Need more Info on your workbook? The Info category tells all!

Exploring the Info Option

Ready to make a New Workbook? The New category has quick ways to create it. With tons of templates available to choose from, just pick the one that you would like to use! It is just that easy!!

Exploring the New Option

Want to Open an existing workbook? See how easily accessible our recent files are. You also have the ability to use Skydrive to be able to access your files. Need to make sure you don't lose any of your files? Why not pin them so they can stay for as long as you need them, a great feature of Microsoft Excel 2013!

Exploring the Open Option

One of the most important things we can do is save our work. The Save and Save As categories helps us do just that.

Exploring the Save & Save As Options

See how you can preview your spreadsheet before you send it to the printer in this lesson. Plus we'll see lots of settings we can configure to make the page come out just right.

Exploring the Print Option

Need to share your Spreadsheet with a co-worker? Well guess what? Sharing your file just got easier with Microsoft Excel 2013! Share it as a PDF, or an XPS, share it to your Cloud and invite others to view it. This short clip will show you how.

Exploring the Share Option

In this clip we will learn how to share our files with someone who doesn’t have Microsoft Excel 2013. The File Tab and Export Group is a great tool. Let's learn how!

Exploring the Export Option

The Close category discusses exactly that, how to close your workbook in different ways.

Exploring the Close Option

The Account option allows you to sign in so you have access to areas like the Cloud for easy access to all of your files.

Exploring the Account Option

This is an area to use caution! The Options category changes how Excel looks and works -- but be careful! There is no reset button here, so you need to know what you did if you made some changes in this section. Let's take a quick look at some of the options that you have.

Exploring the Options Option
+ Working with Workbooks and Worksheets
14 lectures 31:06

This lesson shows off the Status Bar. From here you can also add features to display, such as the minimum and maximum values in cells. You will also learn how to see the sum of data through the Status Bar. Understand how to better utilize this helpful tool by watching this mini lesson.

Understanding Status Bar Results

In this clip we will see how to navigate through our worksheets. With the ability to create 255 worksheets in an Excel document, it's important to understand how to sort through them and access them. Find out how in just over a minute!!!

Understanding Worksheet Navigation

In this clip we will discuss how to Add or Delete Worksheets. Be careful when deleting a worksheet. That data will be permanently gone so make sure you really mean to delete it!

Adding & Deleting Worksheets

Isn't it better to see a worksheet named Sales rather than Sheet 1? See the best way to rename your sheets.

Renaming Worksheets

Don't let sensitive data become visible to others. See what it takes to hide your worksheets from view and then restore them back when needed.

Hiding & Unhiding Worksheets

What does it take to move around the order of worksheets? This clip explores how to easily move around your worksheets to the order that you need them in.

Moving Worksheets

Let's save time by copying an entire sheet rather than just the cells on the page. See why this is a great way to go.

Copying Worksheets

Another useful feature of Microsoft Excel 2013 is being able to Change Sheet Tab Colors. Watch this clip and see how it helps us to be as organized as possible.

Coloring Worksheet Tabs

See how to zoom in, zoom out, and how to get the most out of the zoom options. How do we do all that in such a short time? Click the clip to find out!

Using Zoom Controls

Templates can be a real time saver in setting up your worksheets. The following templates are automatically installed when you start using Excel 2013: Billing Statement, Blood Pressure Tracker, Expense Report, Loan Amortization, Personal Monthly Budget, Sales Report, and Time Card -- just to name a few!!

Working with Templates

Learn how to get around worksheets with keyboard commands like Enter, Tab, Arrow Keys, Page Up /Down, Home Key and more! You'll also be introduced to a couple of commands on the Home Tab in the Editing group on the Find and Select drop down menu. Discover how Excel pinpoints various aspects of your worksheet for you in this clip, for example cells that contain formulas.

Exploring Navigation Shortcuts

This lesson takes you over to the View Tab and examines the Workbook Views group. Examples of different views include Normal, Page Layout, Page Break Preview and more. Watch and learn how to switch between them.

Exploring Worksheet Views

When it comes to comparing data at the top of a large worksheet with the data at the bottom of the worksheet, splitting the worksheet will make it really easy to see both sets of data. In this clip you'll learn how to do it!

Splitting the Worksheet Views

The emphasis of this lesson is the Arrange All button located on the View Tab. This will let you tile all open Excel documents on the screen. Discover how to best use the Arrange Windows dialog box in just under 2 minutes!!

Arranging Worksheet Views
+ Working with Data
9 lectures 17:50

So, how do you build an Excel worksheet from scratch? This clip is the starting point for that as you learn how to enter data into a worksheet. Getting started here with the basics will make sure you have the right foundation moving forward.

Entering Data

So, how do you build an Excel worksheet from scratch? This clip is the starting point for that as you learn how to enter data into a worksheet. Getting started here with the basics will make sure you have the right foundation moving forward.

Inserting Different Data Types

Ready for a timesaver? Learn about a key tool in Excel – AutoFill. Watch and learn in this lesson how to quickly fill cells with data automatically.

Understanding AutoFill

Forget about typing January, February, March, etc. Learn how AutoFill can create this series and others like the days of the week, number sequences and dates. Also see how AutoFill can look at a sequential range of numbers and continue building the sequence for you. This is one clip you won’t want to miss!

Creating Series with AutoFill

By now we are all used to search engines automatically suggesting keywords as we type. Not one to be left behind, Microsoft Excel features this same capability. Watch this clip to see how to use this feature and also take a trip into advanced options to make sure your system is properly utilizing this feature.

Working with AutoComplete

Let's see how we can quickly, easily & perfectly adjust column width and row height.

Adjusting Rows and Columns with Autofit

We can also use the Ribbon to make adjustments to rows and columns, let's find out where to go and discuss if this is the best option.

Adjusting Rows and Columns using the Ribbon

In this clip we'll see that sometimes data we have in our spreadsheet doesn't have to be displayed. In just under 2 minutes, learn how we can hide columns and rows!

Hide Columns and Rows

Now that our columns and rows are hidden, what do we do if we need them back? Let's find out.

Unhide Columns and Rows
+ Conditional Formatting
9 lectures 20:04

What is Conditional Formatting? Conditional Formatting allows you to change the appearance of a cell, depending on certain conditions. Formatting your spreadsheet in this way allows you to see at a glance relevant information quickly through adding colorful graphics into the cells. This will be demonstrated through a data bar. Check it out!

Conditional Formatting with Data Bars

Sometimes the data bar doesn't quite look like what we imagine it should look like. Well in Microsoft Excel 2013 that is in your control! You can use the default settings or customize your own. Watch this clip to see how.

Configuring Data Bar Rules

Another style of conditional formatting is Color Scales. See how these can be used to display colors in your cells that represent the values contained therein.

Conditional Formatting Using Color Scales

Icon Sets let us add little graphics into the cells. The icons represent the values and allows us to easily see where values fall, without actually examining the numbers in the cells.

Conditional Formatting Using Icon Sets

Looking to see if your values are greater than or less than a particular value? See how conditional formatting with Highlight Cells Rules allows you to easily highlight cells that match your criteria.

Configuring Highlight Cells Rules

Learn how to quickly benefit from pre-configured rules that will show you the details such as the Top/Bottom 10%, and Items or Average in a series of data. This lesson shows you how to apply these and then locate these values in your cell range. An invaluable tool, learn how to use it quickly by watching this clip.

Working with Top/Bottom Rules

Why just use one set of rules? Learn how to benefit from a graphical representation of your selected rules; includes configuring cell data with multiple rules. Are you making a mess out of it? No problem, you’ll also see how to clean things up with the 'Clear Rules From Selected Cells' command.

Manage Multiple Conditional Formatting Rules

In this lesson we'll see how to create Cross Sheet references. What are these you ask? These are cell references to other worksheets in your workbook. See how you can graphically represent what is happening across one worksheet in a single cell.

Using Cross Sheet Conditional Formatting

Imagine this situation. You want to apply conditional formatting but your range of data has errors. No problem! Watch how Excel deals with this situation and how you can apply Conditional Formatting to ranges with errors.

Working with Conditional Formatting in Ranges with Errors
+ The Basics of Formulas and Functions
12 lectures 32:16

What is a Formula? In just a few minutes you’ll learn exactly what they are and when to use them. We'll also discuss operators and we'll see how to enter and edit those formulas. Here’s a hint: Formulas that involve adding, subtracting, multiplying and dividing usually start with an = sign. Watch and learn the rest of the formula in this clip.

Creating Formulas

What is a Function? How does it differ from a formula? Get the facts quickly in this brief tutorial clip. We'll also show you how to insert a function into your worksheet.

Understanding Functions

Learn about this incredibly useful shortcut tool: AutoSum that takes all the guess work out of getting a quick summary of data. Just take a minute and watch this clip.

Using AutoSum

There are 5 most commonly used functions, one of them being the Average function. See how easy it is to create this function.

Using the Average Function

The Count Function is useful when we need a count of items. This clip shows how quickly we can insert and use the Count Function.

Using the Count Function

Another of the 5 most commonly used functions is the Min function. We use it to pick the minimum value from a range. In just under 2 minutes learn to use this function.

Using the Min Function

The Max function will search your range and pick out the maximum value. See how easy it is to pop it into a cell! And yes! It does have a short cut!

Using the Max Function

The Function Library is located on the Formulas Tab and this group is replete with preset functions. See how screen tips point the way to the function you need. Gain a better understanding of this topic by viewing this quick clip.

Exploring the Function Library

Discover how to benefit from the Function Arguments dialog box. Understanding this dialog box will help in building all sorts of functions.

Using the Insert Functions Command

See how to use a Logical Function as well as the benefit of Logical Tests. If you watch this lesson, you can follow the example to mimic the results in your own worksheets!

Inserting Logical Functions

Get ready for a real time saver as you see the power of Text Functions located on the Formulas Tab. Learn how to concatenate up to 255 texts. Who knew we could perform functions on text? Another wonderful tool in Microsoft Excel 2013.

Working with Text Functions

Need a way to insert the date or the exact date and time? Here’s a quick clip on getting this data quickly and painlessly into your cells.

Using Date Functions
+ Working with Tables
16 lectures 26:06

Learn why you will want to convert your datalist to a table, and how to do it.

Creating A Table

Watch the power of a table when it comes to your table headers -- they are never missing anymore!

Viewing Table Headers

Sorting the datalist into an order that is useful is a big help, see how we can sort ascending and descending in this lesson.

Sorting Table Data

See the difference between a sort and a filter here. Filtering hides the data you are not interested in seeing.

Exploring Sort and Filter Commands

What if those little arrows we use for Sorting and Filtering are missing? This lesson details how to turn the Autofilter on in your datalist. Want to see it in action? Watch this short video lesson!

Preparing to Use Custom Sort

With your data prepared you are now ready for a Color Sort. So…how do we do a Color Sort? Just watch and learn and in just over a minute how to filter by color!

Performing a Color Custom Sort

Use the Custom Filter to help you view the data you need to see quickly and easily. Have the ability to be as specific as needed to help you sort your data. Also, see how we can view our data when multiple factors are involved in what we need to see.

Using Multiple Level Custom Sorts

Learn how to hide records you are not interested in seeing and only showing records you want to see. The distinction between Filtering and Sorting is that sorting rearranges your data whereas filtering gives you an opportunity to hide (not delete) what you don't want to see. This lesson will show you how to do it.

Exploring Data Filters

This clip continues with Data Filters but keys in on filtering multiple columns. Quick and easy. Watch this lesson and you’ll get the hang of this in a snap!

Filtering Multiple Columns

See how to use the Search feature to quickly filter your data, and how to clear filters.

Using Search Features

Need to add data to your table? Its quick and easy with Excel. See what to do when we need to add a row to our table. Just click and type, and check out the cool short cut too!!

Adding Data to a Table

Spelling and consistancy are very important. So when Typos are always an issue, avoid them by Picking the Item from a list! You are sure to be consistant and acurate and typo free! It doesn’t get any easier than this!!!

Pick an Item From A List

We find ourselves in the spot of needing to add a column to our table, what do we do? See how Excel automatically extends your table when you place a new column next to your table.

Adding Columns

Calculated Columns are slightly different when working within a table. Don't worry, this lesson shows you what to expect and how to build that formula!

Creating a Calculated Column

If you'd like to see totals at the bottom of your table, don't spend your time building a function. Microsoft Excel 2013 can do it for us!! -- use this checkbox to automatically add the total.

Adding a Total Row

The standard blue color we get is nice, but what if you'd like to change the color scheme? Can I preview what color scheme I want before I pick it? Of course you can! It's easy, watch and see!

Formatting Tables
+ Graphics, Printing and Review Features
13 lectures 30:10

Did you know that you can add Pictures or ClipArt into your spreadsheet? Pictures and ClipArt are a nice way to spruce up your spreadsheet. See where to go to easily insert them.

Inserting Pictures and ClipArt

Shapes can be a useful addition to your spreadsheet. Here we use a BIG arrow to draw attention to an area of the spreadsheet. Just pick your shape and click, hold and drag. Yes, it is just that easy!

Inserting Shapes

Although Excel isn't photo editing software, we can make some cool changes to our pictures. See how to use the contextual tab options to change up how your pictures appear.

Formatting Pictures

Shapes will pop in with a default color scheme, if you don't like it, change it! This lesson shows us the options.

Formatting Shapes

SmartArt graphics add color, shape, and emphasis to your text and data. It's easy to try out SmartArt graphics such as an organization chart, a time line or cycle. You can preview styles before choosing one, so you don't have to apply styles over and over again to find the one you want. And after you apply a style you can customize it with colors, animation, effects such as shadows, bevels, and glows, and more. This lesson demonstrates how to create and modify an organizational chart through SmartArt.

Adding SmartArt into Worksheets

Some SmartArt diagrams can display pictures, see how we can pop those pictures in and get a great looking graphic with just a couple formatting clicks. It's fast and easy! Learn how to do all of this in just a few minutes by watching this video lesson.

Adding Pictures in SmartArt

When we're ready to Print our spreadsheet it may need some adjustments. Let's look at the options found on the Page Layout tab and see how we can prepare for printing.

Customizing Print Options

When preparing for printing, it may be necessary to rescale the document to a specific paper width and height. This lesson shows you how to do that. See it in action now, by watching this quick clip!

Scaling Page Dimensions

The gridlines are the lines between the rows and columns in the sheet to make editing and reading easier. Learn how to turn on and off Gridlines and Headings. Note: These lines will not print unless Print is also checked in the Sheet Options Dialog Box.

Modifying Gridlines and Headlines

Microsoft Excel 2013 has made it nice and easy to insert Headers and Footers. Page Lay- Out View lets us see the Header and Footer design tabs. Use a default one or customize your own. It's up to you.

Creating Headers and Footers

This lesson will show you how to add print titles to a spreadsheet so your headings print on every page, without having to create those headings more than once. See how this can be done by watching this quick clip.

Printing Titles

The proofing tools provided in Excel are Spell Check and the Thesaurus. Check out all these tools in action in this quick video lesson.

Using Proofing Tools

Cell comments are a great way to provide additional information with your spreadsheet without having to add it into a cell. Watch this lesson to see where the information goes and how it displays.

Working with Cell Comments