Office 2013 For Dummies Video Training, Deluxe Edition
4.4 (8 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.
1,586 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Office 2013 For Dummies Video Training, Deluxe Edition to your Wishlist.

Add to Wishlist

Office 2013 For Dummies Video Training, Deluxe Edition

Learn Office 2013 right now with this easy to follow, self-paced course! For Dummies. Making Learning Easier!
4.4 (8 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.
1,586 students enrolled
Last updated 7/2013
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 10 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn common Office tasks
  • Learn skills in Word, Excel, Outlook, PowerPoint, and Access
  • Organize your e-mail, calendar and contacts
  • Add charts, graphics and audio to presentations
  • Search and filter a database
  • Create appealing and easy-to-read documents and spreadsheets
  • Crunch numbers and store data
  • Customize your Ribbons
View Curriculum
Requirements
  • All Internet browsers, including Internet Explorer, Safari, Chrome, and Firefox
Description

Get the keys to unlock Office 2013 with this comprehensive course. Find you way around the Office 2013 interface and learn all about the latest Office features with this fun and friendly For Dummies course. You’ll walk step-by-step through the most common Office tasks and be on your way to dressing up your documents in Word, creating fantastic formulas in Excel, conquering your inbox with Outlook, adding some punch to your presentation with PowerPoint, developing databases in Access, and so much more! This course also includes a 825 page Office 2013 All-in-One For Dummies eBook, multiple cheat sheets and Part of Tens, quizzes at the end of each lesson, and an educational PowerPoint!

Visit www.dummies.com and www.wiley.com

Who is the target audience?
  • Beginner to Advanced Microsoft Office users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
126 Lectures
21:03:03
+
Working with Any Office Program
16 Lectures 30:19

Everything has to start somewhere! Here's where to find the Office 2013 tile on the Windows 8 Start screen, how to open Office, and two ways to close it when you're done. 

Preview 00:49

Older Windows system? Don't worry — this lesson shows you where to find Office 2013 and how to open and close it on Windows 7.

Preview 01:12

Here's what you need to know to find and open an existing file, edit it, create a new file, choose a location to store the file, and save files when you're done.

Preview 04:14

The Ribbon interface keeps the most commonly used commands handy, but if it's new to you, it takes a little getting used to. This lesson shows you how the Ribbon works, the four types of icons it holds, and all the things you can do with it.

Preview 03:24

The commands on the Ribbon control only a few of the many things you can do with Office 2013 documents. In this lesson you discover how to access and use dozens of additional options found in dialog boxes and menus.

Working with Dialog Boxes and Menus
01:33

Pop-up toolbars offer terrific shortcuts for making basic edits. Here's how to take advantage of them.

Working with the Pop-Up Toolbar
00:54

Now it's time to look at the actual process of making standard edits to a document. This lesson shows you how to select part of your document, move it to a new location, or get rid of it completely — and how to get it back if you change your mind.

Select, Copy, Cut, Paste, and Delete
02:38

The Quick Access Toolbar is designed to keep the commands you use most often right where you need them. But if Office 2013 hasn't picked the right commands for you, it's easy to customize that toolbar by adding things you need and removing those you don't. You can do the same with the Ribbon, and here's how.

Customizing the Ribbon and Quick Access Toolbar
02:09

Before you print that document, make sure it looks the way you want. Here's how to preview each page, choose Landscape or Portrait orientation, and print as many copies as you need.

Preview 01:54

One of the coolest features of Office 2013 is that you can share data between programs. This lesson shows you how to take a chart from Excel and paste it into a PowerPoint presentation.

Sharing Documents between Programs
01:59

Everyone needs a little help now and then! This lesson shows you how to find what you need to know in the Office 2013 Help system.

Using the Office Help Window
02:12

If you work from multiple devices, such as a smartphone or tablet as well as your desktop or laptop, storing your files on SkyDrive is smart. They'll be available to any of your devices as long as you're connected to the Internet. Here's how to save a file to SkyDrive and access it from anywhere.

Connecting to SkyDrive
01:30

Are you working with some sensitive information? It's easy to password-protect your files, as you'll see from this quick lesson.

Password Protecting Your Files
01:29

Ah, the dreaded viruses. They're out there, and while getting an antivirus program and keeping it up to date is the first line of defense, Office 2013 also lends a hand with its built-in macro protection feature. This lesson explains how to activate it and what the different settings do.

Guarding Against Macro Viruses
02:14

Tired of plowing through long series of commands to find the one you want? This lesson shows you how to access great shortcuts with a right-click.

When in Doubt, Right-Click the Mouse
00:58

Change your mind? Want to see how a slight variation would look, but not certain you'll keep it? Memorize the tricks in this lesson so you can easily undo and redo commands, and experiment all you want.

Undoing and Redoing with Shortcuts
01:10

Working with Any Office Program
5 questions
+
Expressing Yourself with Word
9 Lectures 21:26

Word may be the most-used Office application of all. Here's how to get started creating a Word document and giving it a professional look.

Adding and Editing Text in a Document
02:36

Word documents are flexible. In this lesson, you learn how to add a page to your document, break text into two pages, insert paragraphs into existing text, and create a cover page.

Starting New Paragraphs, Sections, and Pages
02:19

Fonts affect how your document looks. Find out how to choose and change a font, adjust the size, and use the Format Painter in this lesson. And if you change your mind, you'll also learn how to change everything back.

Basic Text Formatting
03:11

You can choose how text is aligned in your document, and adjust the amount of space between lines of text. This lesson shows you how.

Basic Paragraph Formatting
01:28

Want to speed up the formatting process? You can use preset styles, or choose a preformatted template that applies styles as you create your document. Learn to use both in this lesson.

Formatting with Styles and Templates
01:31

Adjusting margins or tabs from Word's default settings can help make your documents easier to read. This lesson helps you find the Ruler and set margins and indentations exactly as you want them to be.

Setting Margins
02:19

Building big documents? You can help readers navigate by including headers and footers that provide information such as chapter names or page numbers. Here's how to do it.

Adding Headers and Footers
02:45

Oops! You thought you were writing about the 3rd edition, and now you discover it's actually the 4th. In this lesson, you'll find out how to quickly locate every "3rd" and replace it with "4th", as well as how to find any word or phrase throughout the document.

Finding and Replacing Words
03:13

What a bright idea! Make it easy to spot the headings by putting them in colored text, or call attention to a section of your document with a highlight color. This lesson explains it all.

Applying Colors
02:04

Expressing Yourself with Word
5 questions
+
Excel Essentials
10 Lectures 29:36

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.

Launching (and Quitting) Excel
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. 

Going Backstage
01:50

The most commonly used options in Excel are tied up with a ribbon — or at least, located on one. In this lesson, you learn what’s there, how to work with each component, what Tabs do, and how to keep the Ribbon out of your way.
Using the Excel Ribbon
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.

Customizing the Quick Access Toolbar
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
02:15

Venture deeper into the world of Excel and understand these two important features. This lesson explains both, along with advice for touchscreen users and tips for entering values.

The Formula Bar and the Status Bar
02:38

Before you can crunch any numbers, you must learn your way around Excel's worksheet area. In this lesson, you learn about current cells, how to move to the cell where you want to enter data, how to make your way through the columns, and special techniques for use on touchscreen devices.

Navigating the Worksheet Area
04:43

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
02:55

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
01:19

To successfully use Excel 2013, there are some basic skills you have to master. Here are the Top 10!
Top Ten Beginner Basics
04:47

Excel Essentials
3 questions
+
Creating Excel Spreadsheets
8 Lectures 41:51

Like anything having to do with numbers, Excel likes organization. This lesson shows you how to arrange your information in the columns and rows, various ways to get the information into the right cell, and how to fix data entry errors.

Doing the Data-Entry Thing
04:10

Excel recognizes three data types: text, values, and formulas. This lesson explains the different types and how they work, how to designate negative numbers and fractions, and what to do with times and dates.

Exploring Excel's Data Types
07:34

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
03:25

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
08:18

In this lesson, you venture into the functions that make Excel function. Learn to search for, choose, and enter a function; specify and edit function arguments; and update formulas.

Using the Insert Function Button
06:19

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 Button and Quick Analysis TotalsTools
03:29

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
05:23

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
03:13

Creating Excel Spreadsheets
4 questions
+
Editing Excel Spreadsheets
12 Lectures 35:55

More often than not, you'll need to work with more than one cell of your worksheet. Learn how to select exactly the cells you need by using your mouse, keyboard, or touchscreen.

Making Cell Selections
03:06

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
03:22

Excel's mini-bar offers a shortcut that lets you apply common formatting changes to a group of cells within the Worksheet area. It's quick and easy, and here's how it's done.

Formatting Cells with the Mini-bar
01:27

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
04:52

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
02:34

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
04:14

You can give your worksheet its own look with Cell Styles. This lesson shows you how to choose one of the readymade styles or create your own, then save your style for future use.

Working with Styles
01:40

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
01:52

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
03:22

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
04:35

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
02:29

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
02:22

Editing Excel Spreadsheets
5 questions
+
Printing Excel Spreadsheets
7 Lectures 17:57

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
01:25

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
02:54

Sometimes, only a hard copy will do. Learn how to print your entire worksheet, choose a select portion to print, and cancel the job if you change your mind.

Printing the Current Worksheet
03:07

You can use the Page Layout tab to set up your worksheet for just the appearance you want. In this lesson, find out how to set margins and page orientation, choose print titles to appear on each page, and print with gridlines or headings.

Setting Up Your Pages
04:23

Need to add a header and/or footer into your Word document to display information - like titles, chapter names or date? Word 2013 even gives you predesigned templates to work from to make it even easier!

Inserting Headers and Footers
03:15

Ah, those pesky page breaks! This lesson shows you how simple it is to be sure they occur where you want them to.

Solving Page Break Problems
00:44

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
02:09

Printing Excel Spreadsheets
3 questions
+
Organizing Excel Spreadsheets
6 Lectures 16:57
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
01:58

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
03:44

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
04:57

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
01:44

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
02:59

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
01:35

Organizing Excel Spreadsheets
4 questions
+
Analyzing Excel Data
6 Lectures 23:00

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
06:46

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
02:40

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
03:32

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!

Data Analysis with Creating Pivot Tables
02:22

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
04:03

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
03:37
+
Creating Excel Charts, Graphics, and Data Lists
11 Lectures 27:51
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
02:53

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
02:29

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
02:56

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
02:04

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
01:40

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
02:11

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
03:29

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 or Hiding Graphic Objects
02:09

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, Editing, and Navigating Data Lists
01:28

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
04:24

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
02:08

Creating Excel Charts, Graphics, and Data Lists
5 questions
+
Linking, Automating, and Sharing Excel Spreadsheets
4 Lectures 11:57
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
04:05

Add-ins give you access to a wide array of additional Excel features and calculating functions. In this lesson you'll learn where to get them and how to install these handy little programs.

Using Excel Add-Ins
01:40

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
03:45

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, and Reviewing Worksheets Online
02:27

Linking, Automating, and Sharing Excel Spreadsheets
2 questions
4 More Sections
About the Instructor
John Wiley & Sons, Inc.
4.3 Average rating
1,120 Reviews
29,064 Students
35 Courses
Video Training

Founded in 1807, John Wiley & Sons, Inc. has been a valued source of information and understanding for more than 200 years, helping people around the world meet their needs and fulfill their aspirations. Wiley and its acquired companies have published the works of more than 450 Nobel laureates in all categories: Literature, Economics, Physiology or Medicine, Physics, Chemistry, and Peace.

Wiley is a global provider of content and content-enabled workflow solutions in areas of scientific, technical, medical, and scholarly research; professional development; and education. Our core businesses produce scientific, technical, medical, and scholarly journals, reference works, books, database services, and advertising; professional books, subscription products, certification and training services and online applications; and education content and services including integrated online teaching and learning resources for undergraduate and graduate students and lifelong learners. Wiley's global headquarters are located in Hoboken, New Jersey, with operations in the U.S., Europe, Asia, Canada, and Australia. The Company is listed on the New York Stock Exchange under the symbols JWa and JWb.