Learn Microsoft Excel 2013

Fast moving, easy to follow Microsoft Excel 2013 tutorial from the e-learning experts!
0.0 (0 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.
15 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 102
  • Length 3.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 9/2013 English

Course Description

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.

What are the requirements?

  • Microsoft Excel 2013

What am I going to get from this course?

  • 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.

What is the target audience?

  • 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.

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: Introduction and Auxiliary Materials
Introductory Lecture
Preview
01:43
Section 2: An Introduction to Excel 2013
05:13

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.

02:07

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.

01:05

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.

01:07

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.

00:59

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.

00:48

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

01:00

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.

00:52

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!

01:08

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.

03:39

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.

01:45

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.

03:15

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.

01:35

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.

01:48

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.

01:20

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!!

01:55

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.

Section 3: Behind the Scenes with Backstage View
01:26

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.

01:07

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

01:02

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!!

01:33

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!

01:36

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

01:19

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.

01:27

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.

01:11

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!

01:18

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

01:01

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.

03:32

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.

Section 4: Working with Workbooks and Worksheets
02:50

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.

01:30

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!!!

01:46

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!

02:07

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

01:45

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.

01:46

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.

02:32

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.

01:45

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.

01:58

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!

03:27

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!!

03:30

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.

02:57

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.

01:31

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!

01:42

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!!

Section 5: Working with Data
01:29

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.

02:10

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.

03:15

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.

02:49

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!

01:31

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.

01:40

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

02:08

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.

01:43

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!

01:05

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

Section 6: Conditional Formatting
02:02

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!

02:48

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.

01:44

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.

02:04

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.

02:15

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.

01:34

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.

02:09

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.

03:14

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.

02:14

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.

Section 7: The Basics of Formulas and Functions
03:54

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.

02:40

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.

02:34

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.

01:34

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

02:16

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.

01:46

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.

02:02

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!

02:15

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.

03:10

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

04:22

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!

02:57

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.

02:46

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.

Section 8: Working with Tables
02:09

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

01:53

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

01:08

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

01:12

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

01:25

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!

01:19

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!

01:37

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.

01:26

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.

01:49

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!

01:27

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

02:13

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!!

01:24

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!!!

01:02

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.

02:24

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!

02:05

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.

01:33

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!

Section 9: Graphics, Printing and Review Features
01:30

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.

01:18

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!

03:06

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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

ClipTraining LLC, Learn what you need, when you need!

ClipTraining is a leading creator of eLearning for Microsoft Office, Microsoft Windows, and many more business applications. The ClipTraining Library is a continuously growing resource for educating and supporting individuals, K-12 students, and business organizations. Through to-the-point, task-based lessons called Clips, every student is empowered with on-demand knowledge to expand their skills. Having access to our courses is like working with the expert by your side!

Ready to start learning?
Take This Course