Prositions Inc.

Course OverviewLearn the basics of MS Word, Access, and Publisher or brush up on seldom used functions in Excel – the sky’s the limit with these tutorials, tips, and tricks for all the Office 2016 applications.

Course OverviewOffice 2016 is a collection of business applications; Access, Word, PowerPoint, and Outlook are a few applications included. This video explains how to discover which version of Office you have, which applications are included in that version, and how to keep your Office applications up to date.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Finding What's Included in Office 2016

Course OverviewOffice 2016 programs come with two ways of getting help: the help window and the Tell Me What You Want to Do text box. This video discusses how to learn about a command with the Help window and how to see a command in action with theTell Me What You Want to Do text box.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Finding a Command with Help and "Tell Me What You Want to Do" Features

Course OverviewIf you use the Research pane in past versions of Office, you'll appreciate the Smart Lookup feature in Office 2016. This video explains how tofind information about a selected word, phrase, or paragraph right within the Office program.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Doing Your Research with Smart Lookup in Office 2016

Course OverviewNo longer are you confined to saving files only to your local desktop. You can save files directly to OneDrive, Microsoft's online storage space; useful when you need to share files or work on multiple computers or devices. This video explains how to save all your important files to OneDrive, a similar process to saving your files to a hard drive.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Saving and Opening a File from Office 2016 to OneDrive

Course OverviewIt's easy to share files right from within an Office 2016 program. This video explains how to share a file through email or a sharing link through the Share button in Word, Excel, and PowerPoint.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Sharing a File Directly through Office 2016 Programs

Course OverviewWhen you have a large file, especially a large spreadsheet in Excel, it's extremely helpful to view two parts of the file at once. This video discusses how to open two windows for one file, arrange them side by side, and scroll them side by side.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Viewing a File Through More Than One Window

Course OverviewIf you don't want your Office 2016 programs to look like everyone else's, you can change the background and theme. This video explains the process to change both the screen background and the Office theme sothatevery time you open a program, it has a personalized look and feel.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Changing the Screen Background and Office Theme

Course OverviewThe Ribbon is an essential component to the way you work in Office 2016 programs. This video explains how you can add tools that you use all the time and deletethe tools you don't use often to customize the Ribbon to make it the most useful to you.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Customizing the Office 2016 Ribbon

Course OverviewYou'll want to be confident when saving files; you don't want to wonder later where your file is or even if it saved correctly. This video discusses how to designate a default location for your files, define a default format for Office 2016 programs, and set an autorecovery time.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Setting Options for Saving Office 2016 Files

Course OverviewTo keep your files as safe as possible from malicious viruses, you'll want to check out the Trust Center. This video explains how to get to the Trust Center and the level of protections you can enable.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Guarding Against Macro Viruses

Office

Course OverviewThe files you create with Word are documents. Every document begins with a template with built-in styles to get you off to the right start; even the blank template includes a few styles. This video shows how to choose a template that comes with Word or search for one on Office Support.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Starting a Word 2016 Document from a Template

Course OverviewWord isn't all about entering text. You'll also want to format text, check how the text looks on a page, or organize your work. This video explains how to choose the right view for the task that you want to accomplish, whether that's simply reading text, printing the file, or fixing the heading structure. Target AudienceAppropriate for All

Choosing a View in Word 2016

Course OverviewAfter you have text on the page, odds are you'll need to manipulate it in some way, whether it's to move, copy, or format it. This video shows the different methods to select text, which you need to do before you can perform any kind of action with it.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Selecting Text in Word 2016

Course OverviewAs your documents get longer, you'll want to know how to navigate from page to page or to a specific place the fastest way possible. This video offers key techniques on how to move around a document using keyboard shortcuts, the Navigation pane, or bookmarks. Target AudienceAppropriate for All

Moving Around Quickly in Word 2016 Documents

Course OverviewCreating breaks in strategic places gives you the ability to layout pages the best way possible. This video explains how to create a line, section, and a page break depending on what you're trying to accomplish.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Inserting Line, Section, and Page Breaks in Word 2016 Documents

Course OverviewMargins, the space along the edges, can be adjusted to fit information in the headers or footers or for printer specifications. This video shows how to adjust the margins in a file through the Layout tab or manually with the ruler.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Setting Up Margins in Word 2016 Documents

Course OverviewParagraph lines don't all have to start on the left edge; you can indent an entire paragraph (to emphasis it) or just the first line of a paragraph (to indicate the start of the paragraph). This video shows how to indent lines and paragraphs from the Home tab, with the ruler, or from the Paragraph dialog box.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Indenting Paragraphs and Lines in Word 2016 Documents

Course OverviewNumbering multi-page documents is extremely useful when you need to print a document. This video shows how to add numbers to a document two ways: in the header or footer or manually.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Adding Page Numbers to Word 2016 Documents

Course OverviewHeaders and footers are a convenient place to add identifying information about the file, such as filename, author, creation or revision dates, and page numbers. This video shows how to create a header and footer for an entire document, different headers and footers from different pages or sections, and how to format them.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Adding Headers and Footers in Word 2016 Documents

Course OverviewWhen you have symbols or other unusual text, the default space Word places between lines and paragraphs might not suffice. This video shows how to adjust the spacing through the Home tab and through the Paragraph dialog box for even more precise options.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Adjusting Space Between Lines and Paragraphs in Word 2016

Course OverviewBullet and number lists help organize text and makes it easily readable. This video explains how to start a list, add on to one, format it, or convert existing text to a list.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Creating Numbered and Bulleted Lists in Word 2016 Documents

Course OverviewTo align text exactly right, you'll need to work with tabs. Word offers five types of tabs. This video shows how toset a tab stop with the ruler, move a tab stop, and delete one.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Working with Tabs in Word 2016 Documents

Course OverviewYou may never need to manually hyphenate text in a Word file, but it's still handy to know. This video shows how to automatically or manually hyphenate words when you need to.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Hyphenating Text in Word 2016 Documents

Course OverviewWith styles, you can apply a bunch of formatting at once. This video explains how to find the Styles pane, and the three different styles you'll find there: character, paragraph, and linked.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Introducing Word 2016 Styles

Course OverviewYou can format a character (for fonts, borders, or languages) or a paragraph (for fonts, bullets, and text effects). This video shows how to apply a style through the Styles gallery, Styles pane, and the Apply Styles pane.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Applying Styles to Text and Paragraphs in Word 2016

Course OverviewAll templates offer style sets, which is an easy way to experiment with the overall look of a document. This video explains how to find the Style Set gallery, live preview style sets until you find one you like, and how to reset your document to the default style set.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Experimenting with Style Sets in Word 2016

Course OverviewThe Styles gallery, Styles pane, or Apply Styles task pane contain a lot of styles and finding the one you want can be difficult. This video discusses how to remove styles, put the styles in a certain order, and how to create a new template based on the changes.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Working with the Word 2016 Style Menus

Course OverviewDespite the many styles Word offers, you might need to create your own custom style. This video explains how to find an existing style to base your new style on, name it, add it to the style menus, and add it to a template.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Creating a New Style in Word 2016

Course OverviewSometimes, you'll just want to make small tweaks to an existing style; all paragraphs or text with that style are instantly updated. This video shows how to get to the Modify Styles dialog box to update an existing style.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Modifying a Style in Word 2016

Course OverviewIf you find yourself using the same styles and formats for documents, you'll want to create your template. This video explains how to modify an existing template, import styles from other templates, and how to save the template to make it available in the future.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Creating a Template in Word 2016

Course OverviewYou modify a template and its styles the same way you'd modify styles in a document; the only difference is that you're making changes to a template, not a document. This video explains how to find out where templates are stored so you can open and modify one.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Modifying a Template in Word 2016

Course OverviewTables are a great way to organize information in a consistent manner. This video explains the components of a table (cells, headers, gridlines) and then shows several ways Word offers for adding a table to a document.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Creating a Table in Word 2016

Course OverviewAfter you have an initial table, you'll probably want to adjust the layout to fit the text better. This video offers tips on how to adjust the width of columns and height of rows, resize the table, and use the AutoFit feature to have Word adjust the height and rows.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Laying Out a Table in Word 2016

Course OverviewYou're not stuck with the initial rows and columns the table has when you created it. This video explains how to add or delete individual or multiple rows and columns to a table.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Inserting Additional Rows and Columns to a Table in Word 2016

Course OverviewMerging and splitting cells are two there ways to customize tables to display information in a table. This video offers several ways to merge or split cells, such as buttons on the ribbon and drawing or erasing lines, to get the layout you need.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Merging and Splitting Table Cells in Word 2016

Course OverviewAfter you get the layout of your table right and you've entered text in the cells, it's time to format it. This video explains how to apply table styles, add a border, or make certain rows or columns stand out with a background color.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Formatting a Table in Word 2016

Course OverviewCharts give you the opportunity to convey information that allows readers to easily read it; the process to insert a chart is fairly easy in Word. This video explains how to insert a chart, and some of the various chart types you can choose from.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Creating a Chart in Word 2016

Course OverviewVisual elements, along with text, is the best of both world; when you have a persuasive picture to go with text, you can insert it right into a document. This video explains how to insert a picture from your hard drive, from OneDrive, or from the Internet.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Inserting a Picture in a Word 2016 Document

Course OverviewAfter you’ve inserted a picture, you'll need to adjust it so that it fit in with the text and the margins of the file. This video shows how to apply picture styles, picture effects, or minor edits, such as cropping or removing a background.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Editing Pictures in a Word 2016 Document

Course OverviewWhen you insert anything into a Word file, Word considers it an object, be it a shape, line, text box, image, photo, SmartArt graphic, WordArt image, or chart. This video explains how Word treats object and the methods you can use to position the object just right so it's not blocking anything else, and how to wrap text around the object.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Positioning and Wrapping Objects Relative to the Page and Text in Word 2016

Course OverviewGraphics and charts can be enhanced by arrows or shapes to draw attention to specific places. This video explains how to choose a line, arrow, or shape from the Shapes gallery and modify its appearance or shape to fit in with your graphic or chart.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Drawing Lines, Arrows, and Shapes in Word 2016

Course OverviewSpelling and grammar errors are hard to catch even with the best of intentions. This video explains how Word flags spelling and grammar errors, and shows how to correct mistakes one at a time or all at once.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Correcting Spelling and Grammar Errors in Word 2016

Course OverviewFinding and replacing text can be a tedious task if you attempt to do it yourself; Word's Find and Replace feature helps ensure you find all instances. This video explains how to use the Find command to find instances of a word and phrase and how to use the Replace feature to update a word or phrase with a new one.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Finding and Replacing Text in Word 2016

Course OverviewIf an initial search for a word or phrase in your document finds too many results, narrowing the results will help you find what you're looking for easier. This video offers tips on narrowing search results, such as wildcard operators, special characters, and case matches.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Narrowing Search Results in Word 2016

Course OverviewComments allow you to add notes to a Word file, either to remind yourself of something or share thoughts with a collaborator. This video explains how to add your comments, and view, edit, or delete comments that you or a collaborator added.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Adding Comments to a Word 2016 Document

Course OverviewIn order to see the changes you or anyone else makes to a document, you need to track the changes. This video discusses how to turn on and off the Track Change feature, how to view changes by everyone or specific reviewers, and how to accept or reject changes.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Tracking Changes in Word 2016 Documents

Course OverviewA theme comprises of colors, fonts, and effects to give your document a consistent look and feel. This video explains how to apply a theme as is, or customize one of the colors, fonts, or effects.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Choosing a Theme for a Word 2016 Document

Course OverviewBorders can make your document look fancy, and gives your document a finished look, especially when printing it. This video explains how to apply a border to an entire document, a section, or a page.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Adding a Border to a Word 2016 Document

Course OverviewIf you're composing a letter that's going out to multiple people, a mail form is the easiest way to set it up. This video explains how mail forms work, and how you can set up a mail form with a greeting for a letter and address blocks for envelopes.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Creating Mass Mailing Forms in Word 2016

Course OverviewWord includes several features to help you organize your documents. This video explains how to use Outline view, how to generate a table of contents, create indexes, footnotes, endnotes, and cross-references.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Exploring Helpful Tools in Word 2016

Word

Course OverviewYou can find out a lot about and customize your Excel installation through Backstage view. This video explains how to access Backstage view and the pieces of information you can find there, such as a file's properties and Excel's program settings,This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Going Backstage with Excel 2016

Course OverviewThe starting point of most commands is the Excel Ribbon. This video explains how to navigate the Ribbon and its tabs, and explains some of the commands you'll find on the Ribbon.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Becoming Familiar with the Excel 2016 Ribbon

Course OverviewHow you select commands on the Ribbon depends on whether you're using a device with a physical keyboard and a mouse or a device with a touchscreen. This video discusses how to select commands no matter the device you're using.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Selecting Commands on the Excel 2016 Ribbon

Course OverviewThe Quick Access toolbar only contains a few essential commands; to make it useful, you should add the commands you use most often. This video explains what commands are on the Quick Access toolbar by default, and then how to add, delete, and organize commands to it.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Customizing the Excel 2016 Quick Access Toolbar

Course OverviewWhen you enter formulas in Excel, the formula bar not only displays the formula but also contains other useful buttons. This video explains the three areas of the formula bar, shows how to enlarge the formulary bar, andhow to edit formulas using it.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Exploring the Formula Bar in Excel 2016

Course OverviewThe Worksheet area is where you work the most in Excel. This video explains how to find an active cell and input data and how to scroll through a worksheet.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Working in the Excel 2016 Worksheet area

Course OverviewIf you have a lot of related data, you'll want to put the data on different worksheets, rather on the same worksheet. This video explains how to add a second worksheet to a workbook, and then how to move back and forth between the worksheets.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Navigating Multiple Worksheets in an Excel 2016 Workbook

Course OverviewThe status bar might be an overlooked part of Excel, but it contains useful information. This video explains the data entry indicators you find on the status bar, the view buttons to switch views, and the Zoom slider.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Using the Excel 2016 Status Bar

Course OverviewNo matter what kind of device you're using, opening and closing Excel is fairly simple. This video explains how to find Excel on the Windows Start menu or search for it with Windows Search.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Launching Excel 2016

Course OverviewExcel Help comes in two forms: online help and the Tell Me What You Want to Do text box. This video explains when to use each and how to access them when you need help with Excel.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Getting Help When You Need It in Excel 2016

Course OverviewWhen you first open Excel, you're faced with the decision to start a workbook from a template or from scratch. This video offers advice on how to make the right choice for what you want to accomplish.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Starting a New Workbook in Excel 2016

Course OverviewYou'll spend a lot of time entering data in Excel. This video explains how you enter data directly in a cell and then how to complete the entry.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Entering Data in an Excel 2016 Worksheet

Course OverviewHow Excel treatsdata differs depending on what kind of data you're entering. This video explains how Excel treats and formats data it believes is text.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Entering Text in an Excel 2016 Worksheet

Course OverviewMost of the data entry you'll do in Excel revolves around numbers, the building blocks of formulas. This video explains how to enter positive and negative values and fixed decimal points.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Entering Values in an Excel 2016 Worksheet

Course OverviewDates can be tricky in Excel; they can be entered as text or a value depending on what you want to do with the data. This video discusses how you enter dates in a format Excel recognizes to format it as a value; everything else is text.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Entering Dates in an Excel 2016 Worksheet

Course OverviewFormulas, done correctly, will always give you up-to-date results with no additional work. This video explains how to input formulas, starting with an equal sign, the symbols for mathematical operators, and ending with how to tell Excel when the formula is done.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Setting Up Excel 2016 Formulas Correctly

Course OverviewComplicated formulas with multiple operators require you to enter them in the proper order to get the right result. This video explains how Excel calculates formulas so you can input numbers in the proper order to get the correct result.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Correctly Ordering Operators in an Excel 2016 Formula

Course OverviewEven after you get proficient with formulas, it's easy to make errors especially with complicated formulas; Excel lets you know with an error message. This video explains where to find the error messages and how to interpret them to fix your formula.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Identifying Formula Errors in Excel 2016

Course OverviewIf you make the same mistakes over and over, you'll want to set up AutoCorrect to automatically fix those mistakes for you. This video shows you how to customize AutoCorrect for the mistakes you make on a regular basis.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Fixing Errors with AutoCorrect in Excel 2016

Course OverviewIt's always a good idea to proofread and edit any cells before you finish your workbook. This video explains how to switch to Edit mode, edit a cell directly, and edit a formula in the Formula bar.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Editing Cells in an Excel 2016 Worksheet

Course OverviewYou can avoid a lot of mistakes by using AutoComplete; a feature that fills in an entry based on text in other entries. This video explains how AutoComplete offers suggestions on what to enter, how to accept a suggestion, and how to override a suggestion.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Using AutoComplete to Fill Cells in Excel 2016

Course OverviewIf you're entering a series of information, say months, numbers, or days of the week, you can let AutoFill complete the entries for you. This video explains how to have AutoFill in a series you've started, double-check that AutoFill is correctly filling the series, and how to override any mistakes it makes.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Completing a Series with AutoFill in Excel 2016

Course OverviewWhen you need to fill in columns with data from other columns, Flash Fill is the feature you want. This video shows how Flash Fill can extract data from one column to fill in a series of data in another column.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Filling in Data Fast with Excel 2016 Flash Fill

Course OverviewEvery once is a while you'll need to enter a special symbol or character, such as a foreign currency or currency or trademark character. This video explains how to find symbols in the Symbol dialog box and insert them into an Excel cell.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Inserting Special Symbols into an Excel 2016 Cell

Course OverviewFunctions can be tricky; when you need one, you're better off using Excel's built-in functions rather than building your own. This video shows how to start a function, choose a function its arguments directly in a cell or use the Insert Function tool.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Making Your Excel 2016 Formulas Function Better

Course OverviewAutoSum will help you insert functions as well. It can select range of cells to use as the function’s argument and automatically enters them as the argument. This video explains how to use AutoSum and correct any mistakes it might make.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Inserting Excel 2016 Functions with AutoSum

Course OverviewThe Quick Analysis tool makes it easy to total amounts in Excel. This video shows how to select the cells you want to add and total the cells with Quick Analysis.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Totaling Tables with the Quick Analysis Tool in Excel 2016

Course OverviewAfter you put a lot of hard work into your workbook, the last thing you want to happen is to lose it all. This video discusses how to save the workbook in different formats and how to designate a default location for Excel files.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Saving an Excel 2016 Worksheet

Course OverviewExcel 2016 offers a document recovery feature in case you do lose work. This video explains how the AutoRecover feature works to save files every few minutes and how you can recover work after a crash through the Document Recovery task pane.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Rescuing a Lost Excel 2016 Worksheet with AutoRecover

Course OverviewA lot of things you do in Excel revolve around selecting cells; a group of cells is a range. This video shows you the various ways you can select a range of cells, including just the active cell and how to use the cursor or error keys to extend a range.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Selecting a Group of Cells in Excel 2016

Course OverviewA simple formatting method is the Format as Table feature; with just a click of a button you can format a range of cells. This video explains how to choose formatting with this feature, how Excel guesses the correct range to format, and then how to correct Excel if it doesn't get the selection right.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Formatting with the Table Styles Gallery in Excel 2016

Course OverviewWhen you want to format related data in different ways, you'll want to use the formatting options on the Home tab. This video explains how you can select individual cells and apply various formatting, such as bolding headings or underlining totals, to individual cells.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Formatting with the Home Tab Options in Excel 2016

Course OverviewThe mini toolbar offers you another way to apply common formatting to data. This video explains how to get the mini toolbar to appear and the formatting options that you typically find on it.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Formatting Cells with the Mini Toolbar in Excel 2016

Course OverviewWith numbers, you might need more formatting options than are on the Home tab or the mini toolbar. This video explains the many formatting options you get through the Format Cells dialog box.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Formatting Numbers with the Excel 2016 Format Cell Dialog Box

Course OverviewIf you plan to calculate the difference between dates and times, you'll need to be sure Excel has formatted them correctly to get the right result. This video explains how to convert dates and time to the General format in the Format Cells dialog box.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Formatting Dates and Other Digits in the Excel 2016 Format Cell Dialog Box

Course OverviewWhen you have data that are different widths, you'll want to adjust the column widths so all the data shows. This video shows you how to use AutoFit to automatically adjust columns, manually adjust columns, or adjust columns from the Home tab.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Adjusting Column Widths in Excel 2016

Course OverviewThe default font that Excel uses is Calibri; odds are that font won't suit your purposes. This video explains how to change the font, font size, and other attributes from the Home tab of the Ribbon.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Choosing the Right Font in Excel 2016

Course OverviewIn addition to the simple formatting options, you might need to manipulate how data looks in cells by aligning, wrapping and rotating it. This video explains how to alter how data aligns, indent data, center data vertically, and wrap text within a cell.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Aligning, Wrapping, and Rotating Data in Excel 2016

Course OverviewTo emphasize sections of the worksheet or parts of a particular table, you can add borderlines or shading to certain cells. This video explains how to add or draw borders around cells, adjust borders, and fill in a cell with a fill color or gradient or pattern.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Adding Borders and Filling Cells in Excel 2016

Course OverviewThe Cell Styles gallery makes it simple to choose a style set and apply several different formatting attributes to a cell at once. This video explains how to apply a style through the gallery, create your own custom style and add it to the gallery, and copy styles from workbook to workbook.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Formatting with Style in Excel 2016

Course OverviewA really cool feature of Excel is conditional formatting; you can tell Excel that when data meets certain criteria to automatically apply specific formatting. This video discusses the conditional formatting that you can have Excel apply when data meets criteria you specify along with unformatting data when it fails to meet the criteria.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Using Conditional Formatting in Excel 2016

Course OverviewSplitting the worksheet area into panes allows you to see data in two separate areas of a workbook. This video shows how to split the worksheet area into two panes, either horizontal or vertical, or four panes, and how to turn the worksheet back into one cohesive whole at the end.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Splitting an Excel 2016 Worksheet into Separate Viewing Panes

Course OverviewIf your data has headings, it's nice to be able to see those even after you've scrolled down the screen. This video explains how to freeze the top row, or the heading, of a workbook so it stays onscreen no matter how much scrolling you do.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Freezing Panes in an Excel 2016 Worksheet

Course OverviewComments enable you to make notes about data in cells; they're an essential tool when you're collaborating with other people. This video explains how to add a comment to a cell, view comments, reply to comments someone else made, and delete comments when you don't need them anymore.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Adding Comments to an Excel 2016 Worksheet

Course OverviewDescriptive range names give you an easy way of locating ranges in the future and including them in formulas. This video explains the rules to naming ranges and how to create a formula around a range name instead of cell references.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Giving Descriptive Names to Excel 2016 Cells and Ranges

Course OverviewThe Find feature is useful especially when you have a large worksheet that you can't easily scan for a specific piece of data. This video explains how to use the Find box for simple searches, how to perform more complicated searches, and how to replace found data with updated data.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Finding and Replacing Data in Excel 2016

Course OverviewIf you need info to supplement data in a worksheet, head to Excels' Smart Lookup feature. This video showshow to look up the definition of a term or phrase, do additional research through the Bing search engine, or even hear how a word is pronounced with Smart Lookup.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Supplementing an Excel 2016 Worksheet with Smart Lookup

Course OverviewOdds are, you'll work with more than one worksheet at a time; you'll need to know how to navigate across them. This video explains how to move back and forth between worksheet, select some or allworksheets in a workbook, and deselect certain worksheets when you're done with them.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Juggling Multiple Excel 2016 Worksheets

Course OverviewWhen you have related data, you'll want to start another worksheet in a workbook. This video discusses how to add one or multiple worksheets to an existing workbook. how to assign descriptive names, color code them, and reorder worksheets.This video forms part of the course Microsoft Office 2016 for Dummies
 Target AudienceAppropriate for All

Adding Worksheets to an Excel 2016 Workbook

Excel

The Microsoft Office Suite is used extensively worldwide and in various professions for communications, organisations and teaching amongst other things. This course takes you through the basics of all aspects of Microsoft Office, including MS Word, Access, publisher and Excel, even going into detail about useful tips and tricks to make your work easier.

MS Office 2016 for Dummies

What you'll learn

Explore more technology skills