Excel 2013 For Dummies Video Training, Deluxe Edition
4.2 (62 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.
6,286 students enrolled

Excel 2013 For Dummies Video Training, Deluxe Edition

Learn Excel 2013 right now with this easy to follow, self-paced course! For Dummies. Making Learning Easier!
4.2 (62 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.
6,286 students enrolled
Created by John Wiley & Sons
Published 4/2013
English [Auto]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • 12 downloadable resources
  • 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
  • Discover how to:
  • Launch Excel and navigate worksheets
  • Enter data and use AutoFill
  • Print formulas in a worksheet
  • Create pivot tables and pivot charts
  • Sort and filter data lists
  • Share workbooks via SkyDrive
  • All Internet browsers, including Internet Explorer, Safari, Chrome, and Firefox

Master Excel essentials with these step-by-step video tutorials, Excel All-in-One For Dummies e-book, Office 2013 cheat sheets, an interactive quiz, an instructional PowerPoint, and more!

This Excel 2013 video training course includes everything you need to go step by step through all the essential tasks involved in using Excel 2013. With over 90 Excel video lessons, you’ll get in-depth video training that provides the show-and-tell, covering the basics of launching and navigating the program, creating and editing spreadsheets, and printing your worksheets. Then you’ll learn how to get organized, analyze your data, create charts and data lists, and share your spreadsheets. You also have access to a customized 800-page e-book along with an array of Office 2013 and Windows 8 cheat sheets to help you learn the quick basics and get you moving along quickly. You will be able to test your knowledge by taking the For Dummies quiz and use the included PowerPoint that includes key instructional information for Excel 2013. In no time, you’ll be an Excel pro!

Who this course is for:
  • Beginner and Intermediate Social Media Marketers
Course content
Expand all 106 lectures 19:36:18
+ Getting Started with Excel 2013
9 lectures 24:49

Ready to embark on your journey through Excel? Get started by learning how to launch Excel 2013 on Windows 7 and Windows 8, pin it to your Start screen, and create a shortcut. Then find out how to call it a day by quitting Excel.

Preview 02:50

Get your backstage pass to gain insight into the workbook file you have open and active. Learn how to modify the workbook’s protection status, manage its versions, change the author, and more using the Backstage view. 

Preview 01:50

Time to cut the ribbon to quickly perform Excel tasks. From selecting tabs and organizing groups to clicking command buttons and launching the Dialog Box, you’ll begin to zip through the Ribbon as you work on your files.

Preview 03:30

Why not have it your way? Set up the Quick Access toolbar by adding the commands that you want to use. You’ll also be able to move buttons around to customize everything to meet your needs.

Preview 02:49

Do as I say! Set up commands in Excel so you can quickly select the ones you need. You’ll also find out some tricks for making it easier to hit the right button.

Selecting Commands

Time to go to the bar. The Formula bar displays the cell address and the contents of the current cell. The Status bar shows the current state of the Excel program, displays calculations, and lets you zoom in and out of the cells.

The Formula Bar and the Status Bar

Put on your captain’s hat to navigate your worksheet. You’ll begin by entering data in a cell, quickly move to the cell where you want to work, scroll through the columns, and more.

Navigating the Worksheet Area

Where’s the keyboard? If you’re on a touchscreen device and need to use the touch keyboard, this lesson is for you. It walks you through the ins and outs of using the touch keyboard to navigate around and enter your data.

Tips on Using the Touch Keyboard

You need help! Get online help with Excel 2013 any time you need it, whether you want info about how to use a command or a function. All it takes is a click of the button to find out more.

Finding Help
3 questions
+ Creating Spreadsheets
8 lectures 42:24

What’s a spreadsheet without data? Find out how to get started and organize your information in tables of data. Set up rows, headers, titles, and more as you enter data into your cells.

Doing the Data-Entry Thing

Text, value, or a formula? Learn how to correctly enter data and watch as Excel classifies it. Then get tips on entering times, dates, dollar amounts, and decimal points. 

Exploring Excel's Data Types

Whoops… how do I fix that? Don’t worry, Excel will correct your typing gaffes using the autocorrect feature. But if Excel misses it, find out how you can go back and quickly edit your mistakes.

Fixing mistakes with AutoCorrect

Excel may read your mind. The AutoComplete feature tries to complete your text entries to speed your work. You can also take advantage of Excel’s AutoFill feature to enter a series of sequential dates or numbers. 

AutoComplete, AutoFill, and Flash Fill

What’s your function? Find out everything you need to know about entering functions into a cell, from using the Insert Function button to the Function Arguments box.

Using the Insert Function Button

The AutoSum tool is worth its weight in gold. Whether it’s SUM, AVERAGE, COUNT, MAX, or MIN, you’ll learn how to use this tool. Then you’ll explore the Quick Analysis tool to make your spreadsheets sparkle with conditional formatting, charts, pivot tables, and more.

The AutoSum and Quick Analysis Tools

Did I just lose all that work?!? Don’t let this happen to you! Follow a good rule to live by and save your work any time you enter more information than you’d want to lose. This lesson gives you the quick tips to ensure everything is saved so there are no regrets.

Saving Your Workbooks

CRASH! What do you do now that you’ve done a lot of work but your computer crashes? The AutoRecover feature will help you get your file back. So sit back and get the scoop on setting up this feature to meet your needs.

Document Recovery
4 questions
+ Editing Spreadsheets
15 lectures 46:13

Choices, choices… which cells are you going to choose? And how are you going to select them? See how to select cells and cell ranges to get all the data and formatting you need. 

Making Cell Selections

The Format as Table feature is so automatic that the cell cursor just has to be within the table of data.  Click around to see how you can use this feature, from changing the table styles to making it look the way you want.

Using the Format as Table Gallery

What’s in the mini-bar? You’ll explore the mini-bar and how to use the buttons from the Font group of the Home tab. You’ll also utilize the Center and Merge & Center buttons and the Accounting Number Format, Percent Style, Comma Style, Increase Decimal, and Decrease Decimal buttons from the Number group.

Formatting Cells with the Mini-bar

Find the easy way out. This lesson shows you how to quickly adjust a column to best fit the information. If that doesn’t work, you’ll learn how to drag the borders of columns to get exactly what you want.

Calibrating Columns

Do you want bold and underlined words? How about Times New Roman or Calibri? 10 point or 12 point? Black or red? So many choices, and now you’ll know you to make them all!

Futzing with the Fonts

You’ve got the fonts down but now you have to align the text. From centering text vertically or horizontally to changing the type of line in the border, you’ll walk through the Alignment group features you can use.

Altering the Alignment

Add some style to your spreadsheet. Make your cells vibrant using the Cell Styles gallery. You’ll uncover how to create new styles, format cells, and save your new style for future use.

Working with Styles

For those occasions when you feel the urge to format on the fly, so to speak, use the Format Painter button. It’s the paintbrush icon in the Clipboard group on the Home tab. 

Fooling Around with the Format Painter

There are always conditions, and that includes formatting in Excel. Follow the easiest types of conditional formatting to apply to a worksheet cell range. Then apply conditional formatting to a data table is with the Quick Analysis tool. 

Conditional Formatting
Open Sesame! Opening a new workbook is easy, and this lesson shows you all the shortcuts so you can quickly get to work.
Opening Your Workbooks for Editing

We all make mistakes, so it’s a good thing you can undo them in Excel with the click of a button. You’ll also get the details on how to drag and drop text as well as cut, copy, and paste data to breeze through your worksheets..

Making Edits with Undo, Drag-and-Drop, Cut/Copy/Paste

A little shift to the right… a little shift to the left… there’s more to deleting cells than meets the eye. This lesson helps you delete cells the right way and shift information around where you need it to be.

Deleting Stuff

For those inevitable times when you need to squeeze new entries into an already populated region of the worksheet, learn to insert new cells in the region rather than go through all the trouble of moving and rearranging several individual cell ranges. 

Staying in Step with Insert

Good catch. That’s what you’ll be saying as Excel helps you catch and remove little spelling errors while suggesting replacements. 

Stamping Out Your Spelling Errors

The Text to Speech feature lets your computer read aloud any series of cell entries in the worksheet. It’s great for checking your printed source while the computer reads. This lesson walks you through how to use this option to cut down on mistakes.

Eliminating Errors with Text to Speech
5 questions
+ Printing
7 lectures 18:22

Gain instant access to the paging of the current worksheet. Learn how to activate and get the most out of this feature by clicking the Page Layout View button.

Previewing Pages in Page Layout View

To save paper and your sanity, print your worksheet directly from the Print screen, found in Excel’s Backstage view.  Excel’s Backstage view lets you do this and we’ll show you how.

Using the Backstage Print Screen
Printing the Current Worksheet

Printing is a breeze as long as you want to use Excel’s default print settings to print all the cells in the current worksheet. Learn how to add the Quick Print feature, define the print area, select ranges you want to print, and more.

Setting Up Your Pages

If you need to add a header or footer, this is where you’ll find out how to do it. And we’ll tell you how so everything looks nice, whether it’s the formatting, alignment, or overall design.

Inserting Headers and Footers

The Page Break preview feature in Excel lets you spot and fix page break problems in an instant.  Just move the mouse and click the button to make the adjustments.

Solving Page Break Problems

A basic printing technique you’ll learn how to use is printing the formulas in a worksheet instead of printing the calculated results of the formulas. 

Printing the Formulas in a Worksheet
3 questions
+ Getting Organized
17 lectures 49:32

The text is too big… no, it’s too small… now it’s just right! See how to use the zoom slider to zoom in and out of your Excel spreadsheet to change the view. 

Zooming In and Out

Zooming in and out on the worksheet can help you get your bearings, but it can’t bring together two separate sections so that you can compare their data on the screen. To manage this, find out how to split the Worksheet area into separate panes and then scroll the worksheet in each pane so that they display the parts you want to compare.

Splitting the Worksheet into Windows

How frustrating is it when you need to scroll down through all of your data but you lose your headings? Here we’ll tell you how to keep your headings still and freeze panes so you can have everything you need in front of you.

Fixed Headings with Freeze Panes

You’ve got something to say, so add a comment to a cell. This lesson shows you how to add the comment, type in the text, display the comment, move it, and finally print it out.

Adding, Editing, and Printing Comments

You can go a long way toward keeping on top of the location of important information in a worksheet by assigning descriptive names to cells and cell ranges. We’ll help you assign range names to a cell or cell range with these guidelines.

Naming Ranges

If you could only find that one key word in your spreadsheet… or maybe you need to replace a word that’s repeated countless times… using Excel’s Find and Replace feature makes it a breeze!

Finding and Replacing

If you want to find a cell that contains a particular entry so that you can change it, you can automate this process by using the Replace tab in the Find and Replace dialog box. We’ll walk you through the steps.

Replacing Cell Entries

Need to find something fast online? Have a word you need to look up? Use the Research pane so you can quickly search through a variety of resources online.

Doing Your Research

Do you need to switch to manual recalculation so you can control when the formulas in the worksheet are calculated? Find out how to put the workbook into manual recalculation mode.

Controlling Recalculation

Security! Security! Protect my data! After you more or less finalize a worksheet by checking out its formulas and proofing its text, we’ll help you guard against any unplanned changes by protecting the document. 

Protecting your Content

It can be extremely time-consuming to work in multiple worksheets, so there must be an easier way than clicking through the tabs. You’ll view the shortcuts to move through the worksheets and get to what you need.

Juggling Multiple Worksheets

Wouldn’t it be great if you can select multiple worksheets to make the same editing changes to all of them simultaneously? Well, you can, and we’ll take you through all the steps! 

Editing Multiple Worksheets at Once

You’ve spent countless hours on a report with multiple worksheets, and now you’re asked to add more information. How do you add a new worksheet, reorder them, or delete one? Excel makes it a snap, and so do we, with this lesson!

Adding, Deleting, and Reordering Worksheets

Time to split! This lesson shows you how to split a single workbook into worksheet windows and then arrange the windows so that you can view different parts of each worksheet on the screen.

Viewing Multiple Worksheets at Once

There are countless times that you need to view worksheets side by side to compare data. Use the View Side by Side command button on the Ribbon’s View tab to quickly and easily do a side-by-side comparison.

Comparing Worksheets Side by Side

In some situations, you need to move a particular worksheet or copy it from one workbook to another. Get ready to make the shift with this lesson that shows you how!

Shifting Sheets to Other Workbooks

Do you need to recap or total the values stored in a bunch of other worksheets in the workbook? Follow us as we create a summary worksheet to do all this.

Summing Stuff on Different Worksheets
4 questions
+ Doing Data Analysis
8 lectures 28:07

Data tables let you enter a series of possible values that Excel then plugs into a single formula. We’ll help you create two types of data tables: a one-variable data table that substitutes a series of possible values for a single input value in a formula and a two-variable data table that substitutes series of possible values for two input values in a single formula.

Playing What-If with Data Tables

Sometimes when doing what-if analysis, you have a particular outcome in mind, like a target sales amount or growth percentage. When you need to do this type of analysis, we’ll show you how to use Excel’s Goal Seek feature to find the input values to get the desired goal.

Playing What-If with Goal Seeking

Do you need to create and save sets of different input values that produce different calculated results? Find out how to play what-if simply by opening the Scenario Manager and having Excel show the scenario in the worksheet.

Using Scenario Manager

If you need to quickly and easily analyze summaries of large amounts of data by using a variety of summary functions, this is the lesson for you. We’ll walk you through pivot tables, which are pivotal to your Excel success!

Creating Pivot Tables

Formatting a new pivot table in Excel 2013 is quick and easy. All you need to do is click a cell of the pivot table to add the PivotTable Tools contextual tab to the Ribbon and then click its Design tab to display command buttons. We’ll walk you through it all.

Formatting Pivot Tables

When you create a new pivot table, Excel automatically adds drop-down buttons to the Report Filter field, as well as the labels for the column and row fields. Learn how to sort and filter this information with these helpful tips.

Sorting and Filtering Pivot Table Data

The fun of pivot tables is being able to restructure the table simply by rotating the column and row fields. Let the fun begin as you start modifying your pivot tables!

Modifying Pivot Tables

All that data is great, but summing it up in a chart is even better. Here’s where you’ll take your pivot table to create a pivot chart that displays its summary values graphically.

Creating Pivot Charts
+ Charts, Graphics, and Data Lists
14 lectures 35:13

Impress your bosses with charts that wow! From 2D and 3D column charts to line charts, bubble charts and more, find out how to display your data by creating ones that really catch the eye.

Making Professional-Looking Charts

Right after you create a new embedded chart in a worksheet, you can easily move or resize the chart. Make it look the way you want in the location you want with these helpful steps. 

Moving and Resizing Embedded Charts

What do you need to do with your chart? Add a missing element… remove an element that’s already displayed… reposition the chart title? Do it all with this lesson!

Customizing Charts and Chart Elements

When Excel first adds titles to a new chart, it gives them generic names. You need to make that chart your own and take charge. Take the steps to change that title to what you want!

Editing the Generic Titles in a Chart

Make it sparkle! Sparklines are tiny graphs generally about the size of the text that surrounds them. Find out how to use the new Quick Analysis tool to quickly add sparklines to your data.

Sparking Up the Data with Sparklines

Say it with text! But how do you do it? Simply add a text box, add your text, and format it the way you want — here's how. 

Telling All with a Text Box

You may have the data but do you have the graphics to make your spreadsheet stand out? Excel 2013 makes it easy to insert online graphic images into your worksheet, and so do we, with these helpful tips.

Working with Downloaded or Local Images

Now that your image is in your worksheet, you have to make changes to it. Whether you need to resize it, crop it, or drag it to a new location, here are the steps to follow.

Editing and Formatting Inserted Images

A great way to jazz up your worksheet is to add some fancy text using the WordArt gallery. We’ll take you through the WorldArt drop-down gallery, SmartArt, screenshots, and more ways to jazz everything up.

Working with WordArt, SmartArt, Screenshots, and Themes

Wait… my graphic objects overlap each other! You can change how they’re displayed. We’ll take you through how to send the objects backward or forward so that they reside on different layers.

Reordering the Layering of Graphic Objects

Sometimes you may find that you need to group several graphic objects so that they act as one unit. That way, you can move these objects or size them in one operation. Grouping or hiding objects is easy with this lesson.

Grouping and Hiding Graphic Objects

Creating a new data list in a worksheet is much like creating a worksheet table except that it has only column headings and no row headings. We’ll walk you through setting up your new data list.

Creating Data Lists

That’s a lot of data, but sorting and filtering data lists is a breeze. We’ll demonstrate how to sort and filter through a variety of different lists to display the data the way you need it.

Sorting and Filtering Data Lists

Sometimes you need to import data into a worksheet from other database tables or web pages. This is an external data query, and Excel simplifies this process.

Importing External Data
5 questions
+ Linking, Automating, and Sharing Spreadsheets
6 lectures 19:38

Apps for Office are small programs that run inside various Microsoft Office 2013 programs to extend their functionality. We’ll highlight the apps that will help you learn about Excel’s features, look up words in the Merriam-Webster dictionary, and more.

Using Apps for Office

Ready to extend Excel’s power? We’ll present the add-ins that give you access to a wide array of features and calculating functions not otherwise offered in the program.

Using Excel Add-Ins

Get ready to automate Excel worksheets by making the opening of other Office documents and Excel workbooks and worksheets just a mouse click away. Adding that hyperlink is easy with this lesson.

Adding hyperlinks to a Worksheet

Automation speeds everything up. You can accomplish this with macros to automate the Excel worksheet by enabling you to record complex command sequences. Find out how to use the macro recorder to let the automation begin!

Automating Commands with Macros

If you save your workbook files in the cloud on your Windows Live SkyDrive, we’ll help you easily share them and have other users open them in Excel on their own devices. You’ll also see how they can use their web browser with the Excel Web App if they don’t have Excel.

Sharing Workbooks via SkyDrive

Do you need to make last-minute edits but don’t have access to a device that has Excel installed? Don’t worry. If you store your file in your SkyDrive, this lesson shows you how you can edit your worksheets anyway.

Presenting and Editing Worksheets
2 questions
+ The Part of Tens
2 lectures 09:47

To successfully use Excel 2013, there are some basic skills you have to master. Here are the Top 10!

Top Ten Beginner Basics

If you’re looking for a quick rundown on what’s new and exciting in Excel 2013, look no further – here are ten neat features.

Top Ten New Features in Excel 2013
+ Excel 2013 For Dummies Personal Library
8 lectures 00:00

The comprehensive reference, now completely up-to-date for Excel 2013!

As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.

  • Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions
  • Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse
  • Details new ways to explore your data more intuitively and then analyze and display your results with a single click

Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.

Excel 2013 All-in-One For Dummies, Special Udemy Edition eBook
801 pages
Here are some of the best new and improved features to help you be even more productive. 
What's New in Excel 2013
1 page

Navigate your way through Excel 2013 by using keystrokes for moving the cell cursor to a new cell, learning simple rules of data-entry etiquette, and exploring common causes of some formula error values.

Cheat Sheet from Excel 2013 For Dummies
3 pages

Navigate Excel spreadsheets like a pro by using hot keys to execute File menu, editing, viewing, and formula commands.

Cheat Sheet from Excel 2013 All-in-One For Dummies
4 pages

The Visual Basic for Applications (VBA) programming language lets you automate many aspects of Excel by writing Sub and Function procedures (also known as macros), which can make you a more productive Excel user.

Cheat Sheet from Excel VBA Programming For Dummies
6 pages

Learn the top ten fundamental skills required to use Excel successfully, explore the do’s and don’ts that can make any Excel experience heavenly, and discover the top new features of Excel 2013.

Excel 2013 For Dummies: Parts of Tens
10 pages

Discover the answers to common VBA questions, expand your knowledge with ten Excel resources, find out what you should and shouldn’t do in Excel VBA, and explore the top ten VBA control structures.

Excel 2013 VBA Programming For Dummies: Parts of Tens
18 pages

This slide show highlights the top fundamental skills required to use Excel 2013 successfully.  If these tasks are all you master, you'll still be way ahead of the competition!  

Excel 2013 Educational PowerPoint
25 pages