Business Skills

Active Listening

Team members are always more willing to actively participate and invest their time and energy when they feel their voice is being heard and their opinion is being taken in to consideration. Active Listening is a method of effective communication where the listener focuses on what is being said by the speaker and shows attention using verbal and nonverbal communication cues.

22 Minutes

DISC Behavioral Styles

Effective communication starts with understanding our own behavioral style, being able to understand others' styles and being flexible to adapt. In this webinar, time will be spent determining your own strengths, identifying others' styles.

42 Minutes

Facilitate Difficult Meetings

Difficult meetings are unavoidable, especially for those in a leadership position. But developing the proper facilitation skills to navigate through the meeting can make all the difference in the world.

38 Minutes

StrengthsFinder 2.0

Maximize Your Personal Leadership Power and Team Strengths with StrengthsFinder 2.0.

44 Minutes

Time Management

Learn how planning can increase your time management efforts.

15 Minutes

TKI Five Modes of Conflict

Because no two people handle are the same, there is not a single method for handling conflict. As a leader, you must be able to assess the situation and handle the type of conflict with the type of people accordingly. TKI provides the skills needed to determine most appropriate approach and method of resolution for each conflict.

17 Minutes

Access 2016

Querying a Database in Access

In this lesson, you will see how queries enable you to create reusable instructions that perform complex operations on dynamic table data lightning fast and precisely the same way each time. Queries also provide the added benefit of enabling you to join data from multiple tables on the fly.

23 Minutes

Excel 2016

Basic Math in Excel

Using basic math functions to manipulate your data is one of the features that makes Excel so powerful.

11 Minutes

Collaborating with Others in Excel

Working with others on a workbook can become unmanageable, resulting in multiple files and recommended changes manually entered. Learn to track editions by person, merge them into one workbook, then accept or reject changes. Send worksheet data to others in the body of an e-mail message, and password-protect your workbook for added security.

23 Minutes

Conditional Formatting

Conditional formatting helps users to quickly focus on important aspects of a spreadsheet or to highlight errors and to identify important patterns in data.

13 Minutes

Create a Macro in Excel

Instead of repeatedly performing routine and/or complex tasks, let Excel remember them for you so they can be carried out with a click or a keystroke - then store them on your Quick Access toolbar for easy access.

11 Minutes

Create Lookup Formulas In Excel

When you want to pull information from a table, the Excel VLOOKUP function is a typical solution. Its ability to dynamically lookup and retrieve information from a table is a game-changer for many users, so you'll find it everywhere.

23 Minutes

Creating Logical Formulas in Excel

A formula is statement written by the user to be calculated. Formulas can be simple or complex. A formula can contain values, references to cells, defined names, and functions. Excel is very flexible in the way that these logical operators can be used. For example, you can use them to compare two cells, or compare the results of one or more formulas.

13 Minutes

Customizing the Excel Environment

Customize the settings in Excel to create a personalized environment with interface options that you need to easily access.

22 Minutes

Datasets in a Table in Excel

Learn to sort data to quickly organize your data and to find the data that you want. Learn to filter data to display only the rows that meet criteria that you specify and hide rows that you do not want displayed, for one or more columns of data.

36 Minutes

Edit a Macro

Taking a look at the programming code used in a macro (either ones you have recorded or macros created by others) is a great way to help you understand how the macro is put together and how it works. You can do this examination, and make changes to your macros, by editing them.

26 Minutes

Excel Power Pivot Demo

Pivot tables are one of Excel's most powerful features. Use Pivot Tables to summarize large amounts of data. This is a good way to quickly see all the values that appear in a field and also find typos, and other inconsistencies.

13 Minutes

Excel VBA Creating a Code from Scratch

Practice creating procedures from scratch in the visual basic editor. We will walk through creating a procedure in Word, Excel, and PowerPoint.

23 Minutes

Excel VBA Making Decisions in Your Code

Computers behave intelligently in large part because programming languages include commands that test conditions, then brank to appropriate code based on the results of that test.

15 Minutes

Exporting and importing Data in Excel

Export and import data from other sources in to Excel to share your information with other people and include data from other sources.

16 Minutes

Filtering Data in Excel

Filtering data in Excel lets you take large sets of data and filter down to just the individual records you need. It saves time, and allows you to gather very specific data from large data sets.

12 Minutes

Formatting in Excel

Most Excel users know how to apply basic numeric and text formats. But users who push beyond the basics will create more readable and effective sheets. In addition, knowing how to apply just the right formatting to specific cells quickly and easily helps users work more efficiently.

88 Minutes

Formulas in Excel

When you enter a formula in a table column, Excel creates a calculated column. This column uses a single formula that's automatically extended to additional rows in the column and adjusted for each row. You just enter a formula once, and Excel immediately fills it down to create the calculated column - there's no need to use the Fill or Copy command.

30 Minutes

Importing Data and Data Validation in Excel

Create a form in Excel that pulls data from a database.

23 Minutes

Mixed Chart Types in Excel

Mixed type or combo (combination) charts combine two styles of charts, such as Excel's column chart and line chart. This format can be helpful for displaying two different types of information or a range of values that varies greatly.

17 Minutes

Organizing and Analyzing Data in a Table in Excel

Sort criteria for an Excel table are saved with the workbook so that you can reapply the sort to that table each time that you open the workbook.

36 Minutes

Organizing Datasets in Excel

31 Minutes

Pivot Tables in Excel

Learn how PivotTables allow you to quickly summarize all your data in just a few clicks.

11 Minutes

Sorting and Filtering in Excel

You can quickly organize the data to best suit your needs using Excel's sort and filter features.

11 Minutes

Transition to Excel 2016

Learn the newest features and functions in Excel 2016.

8 Minutes

Working in Multiple Worksheets

Use multiple worksheets in Excel when working with a large amount of data so it is better organized and easier to find content.

9 Minutes

Working with Charts

Discover how to work with charts and graphs in Excel, and visualize your data in a new way.

92 Minutes

Working with Macros in Excel

Macros allow you to replay a series of events, such as keystrokes or mouse clicks to save time in Excel.

72 Minutes

Working with Tables in Excel

To make managing and analyzing a group of related data easier, you can turn a range of cells into a Microsoft Office Excel table. A table typically contains related data in a series of worksheet rows and columns that have been formatted as a table. By using the table features, you can then manage the data in the table rows and columns independently from the data in other rows and columns on the worksheet.

27 Minutes

Getting Started with Formulas in Excel 2016

Create basic formulas applying the correct structure. Create formulas using the function libraries of Excel.

Formulas
Calculate Totals Using The Quick Analysis Tool
Excel Functions
Relative vs Absolute Cell References
Structured References

Add a Formula to a Table Column
Disabling the Use of Table Names in Formulas
Named Ranges
Common Excel Errors

Functions in Excel 2016

Explore Excel's wide variety of built-in functions in the function libraries.

Date Functions
Text Functions
Logical Functions
AND/OR Functions
Lookup and Reference Functions

Statistical Functions
The Convert Function
INDEX Function

Sorting, Filtering, and Other Data Commands in Excel 2016

Explore a variety of techniques for displaying precisely the information you need in a given moment or for a particular purpose. Use subtotals to stay apprised of activity in smaller groups of numbers.

Basic Sorting and Filtering
Sort Data
Formatting Using the Quick Analysis Tool
Using Conditional Formatting
Using AutoFilter

Find and Remove Duplicate Data
Advanced Filters
Using Filter Operators
Create Subtotals
Copying Filtered or Subtotal Data

Text to Columns
The Watch Window

Working with Charts in Excel 2016

Charts allow you to present numeric information in an attractive, easily edited, and highly customizable graphical form. Choose one of Excel's many built-in styles to present your information for maximum impact, and display the impact of trends or forecasts according to data you choose.

Creating A Chart
Visualize Data Using The Quick Analysis Tool
Recommended Charts
Format a Chart
Quick Format Buttons

Modifying Chart Data
Working with Trendlines
Sparkline Charts
Create a Combo Chart
Format Chart Data Labels

Saving a Custom Chart as a Template

Working with Tables in Excel 2016

Work with Tables and Slicers in Excel 2016.

Create an Excel Table
Modify an Excel Table
Using AutoFilters in Excel Tables
Slicers in Tables
Table Totals

Formatting in Excel 2016

Learn the basics of rows and columns - the structure through which excel stores your information - and how to manage them. Explore techniques for quick entry and basic calculations. Explore a variety of techniques for giving data a visually attractive, easy-to-understand appearance.

Formatting Worksheets
Excel Mini Toolbar
Working with Live Preview
Cell Borders and Fill Options
Working with Text Alignment

Cell Formats
Working with Styles
Header and Footer
Automatically Fill a Row or Column
Flash Fill

Formatting Using the Quick Analysis Tool
Working with Templates
Working with Themes
Screenshot

Getting Started with Excel 2016

Learn your way around the excel window, the basics of creating and saving excel files, and how to view and arrange worksheets for ease of use.

Elements of the Excel 2016 Window
Getting Help
Excel Options
Managing Workbooks
Excel File Formats
Saving Your Workbook
Managing Worksheets
Rows and Columns

Entering Data
The Quick Analysis Tool
Find and Select Data
The Excel Status Bar
Document Views
Workbook Views
Page Layout
The Office Clipboard

Paste Options
The Paste Values Feature
Using the Paste Special Feature
Apps for Office
Setting the Print Area and Print Titles
Preview & Print

Customizing the Excel 2016 Environment

Make your Excel interface yours!

Customize the Excel Ribbon
The Quick Access Toolbar
Customize the Excel Options General Page
Customize the Excel Proofing Options
Customize How Your Excel Worksheets are Saved

Customizing the Excel Options Advanced Settings

Exporting and Importing Data in Excel 2016

Flow data into and out of Excel.

Exporting Your Excel Data
Data Export File Types
Importing External Data
Importing Data from Text
Importing Data from the Web

Creating a Web Query

Working with Multiple Worksheets in Excel 2016

While data are routinely stored on a single worksheet, excel does not limit your calculations to that sheet. Use a variety of methods to collect, calculate, and present information from many sheets simultaneously in the format you choose.

Working Across Worksheets or Workbooks
Working With Worksheet Tabs
Changing the Worksheet Tab Color
Multiple Sheet Formulas
Consolidating Data

Collaborating with Others in Excel 2016

Learn to work collaboratively, using built in Excel tools.

Data Validation
Protecting Microsoft Excel Worksheets
Send a Workbook to a Recipient as an Attachment
Share an Excel Workbook
Track Changes in Excel

Use Comments in Excel
Merging Excel Workbooks

Working with Styles, Themes, and Shapes in Excel 2016

Simplify the process of creating professional-looking Excel documents.

Working with Styles
Working with Themes
Working with Shapes

Tips and Tricks in Excel 2016

Become an Excel Expert.

Customize the Excel Ribbon
The Quick Access Toolbar
Keyboard Shortcuts
Changing the Worksheet Tab Color
The Excel Status Bar
Protecting Microsoft Excel Worksheets

Recover Unsaved Workbooks
The Office Clipboard
Automatically Fill a Row or Column
Basic Sorting and Filtering
View Multiple Worksheets Side by Side
The Split View Feature

Cell Formats
The Paste Values Feature
SmartArt
The Align Feature
The Selection Pane

Excel 2016

Working with PivotTables in Excel 2016

PivotTables enable you to organize and summarize your data so that it includes the information you want to display and excludes the rest. Change a PivotTable's focus by moving the fields to different locations, and create PivotCharts to represent the data in a graphical format.

PivotTables
Edit a PivotTable
Working with PivotTable Fields
Grouping in PivotTables
PivotCharts

Add Slicers to a PivotTable
Add Timelines to a PivotTable

Working with Macros and Objects in Excel 2016

Instead of repeatedly performing routine and/or complex tasks, let Excel remember them for you so they can be carried out with a click or a keystroke - then store them on your quick access toolbar for easy access. Enhance the appeal and impact of your worksheet by including visual objects that supplement your data, then format and arrange them for maximum effect.

The Developer Tab
Microsoft Excel Trust Center
Working with Macros
Working with Shapes
Edit a Macro

Working with PowerPivots in Excel 2016

Explore the built-in functionality of PowerPivot, a free add-in for Microsoft Excel. PowerPivot builds on the concept of PivotTable data and cross-tabulation feature.

Enabling PowerPivot in Excel
Getting Started with PowerPivot
Create a PowerPivot Data Model
Creating and Managing PowerPivot Relationships
Add KPIs to a PowerPivot or a PivotTable

PowerPivot Functions
Add Calculations in a PowerPivot
The Power View Feature
Filter and Highlight Data in Your Power View Report

PowerPoint 2016

Integrating Microsoft Office Files in PowerPoint

Learn to create a presentation based on a Word outline and insert content from a Word document and Excel spreadsheet. Learn to create hyperlinks to external files.

49 Minutes

Slide Master in PowerPoint

Slide masters are designed to help you create great looking presentations in less time, without a lot of effort. When you want all your slides to contain the same fonts and images (such as logos), you can make those changes to the Slide Master, and they'll be applied to all your slides.

55 Minutes

Word 2016

Transition to Word 2016

Learn the newest features of Word 2016.

11 Minutes

Formatting in Word 2016

Use a wide variety of formatting options to enhance the appearance of your text, including color, font, size, and even animation! Learn how to arrange text on a page to increase clarity and visual interest using formatting features, then preview and print your document.

Working with Text
Formatting Text
Text Effects
Using Tabs for Text Alignment
Formatting a Document

Sort Information in a List
Print Preview and Print

Getting Started with Word 2016

Learn your way around the word window, the basics of creating and saving word files, the various ways in which to display a file in order to see just the elements you need in a given moment, and the basics of entering text.

Elements of the Word 2016 Window
Managing Word Documents
Reading a Word Document
Viewing Documents
Getting Help

Word Options
Cut, Copy, and Paste Options

Working with Tables in Word 2016

Learn to use Tables in Word.

Creating a Table
Formatting a Table
Customize Table Appearance
Modify Table Structure
Convert Text into a Table

Insert a Microsoft Excel Table in Word
Sort Table Data
Formulas and Functions

Working with Charts in Word 2016

Learn to work with the Chart tool in Word.

Creating a Chart in Word
Chart Components
Resize a Chart
Modifying a Chart
Customize Structure

Format Chart Appearance
Updating Chart Data
Changing the Chart Type
Editing Chart Data

Working with Shapes and Graphics in Word 2016

The implications of numerical and categorical information or business processes can be difficult to convey using the written or spoken word. Instead, show your audience what you mean via Word's dynamic visuals.

Working with Text Boxes
Working with WordArt
Inserting Equations and Symbols
The Selection Pane
Working with Shapes

Working with Pictures
Working with SmartArt
Editing Shapes in SmartArt Graphics

Document Collaboration and Revision in Word 2016

Learn to use the Collaboration and Revision tools in Word 2016.

Reviewing Tools
Working with Comments
Track, Accept, and Reject Changes
Review and Compare Documents
Protecting Documents

The Reference Features in Word 2016

Use Word's built-in reference tools.

Table of Contents
Create an Index
Create Footnotes and Endnotes
The Bookmark Feature
Create and Apply a Caption

Cross-reference Document Information
Mark Citations for a Table of Authorities
Create a Table of Authorities

Useful Tools in Word 2016

Some features in Word can simply make your life easier.

Editing a PDF
Page Borders and Colors
The Cover Page Feature
Spelling and Grammar Check
Find and Replace

The Thesaurus
The Quick Part Gallery
Bullets and Numbering
AutoCorrect and AutoFormat
Using Watermarks

Screenshot

Working with Styles and Themes in Word 2016

Simplify the process of creating professional-looking Word documents.

Working with Styles
Modifying a Style
Working with Document Themes

Customizing Your Word 2016 Environment

Make the Word environment your own!

Customizing the Word General Options
Customizing the Word Proofing Options
Customizing How Your Documents are Saved
Customizing the Word Options Advanced Settings
Customize the Word Ribbon

The Quick Access Toolbar

Formatting Letters and Creating Mail Merges in Word 2016

Learn to properly format a letter and perform a mail merge.

Working with Letter Format Options
Creating a Mail Merge
Creating Envelopes and Labels

Access 2013

Getting Started with Access 2013

Become familiar with the arrangement of the access screen, the components of a database, and how to get help when necessary. Learn the recognized approach for planning a database, then create the basic structure.

Elements of the Access 2013 Database Window
The Access Navigation Pane
Creating a New Database
Comparing Views
Setting the Tabbed Documents View Option

The Database Design Process
Naming Conventions
Getting Help

Access 2013: Comparing Views

From: Getting Started with Access 2013

Comparing Views

Access 2013: Creating a New Database

From: Getting Started with Access 2013

Creating a New Database

Access 2013: Setting the Tabbed Documents View Option

From: Getting Started with Access 2013

Setting the Tabbed Documents View Option

Access 2013: The Access Navigation Pane

From: Getting Started with Access 2013

The Access Navigation Pane
Changing Viewable Objects
Create a Custom Group

Access 2013: Using Microsoft Access Help

From: Getting Started with Access 2013

Using Microsoft Access Help
Query Basics in Access 2013

Query Basics in Access 2013

Queries allow you to ask questions of the information in your database. Explore the four approaches to asking such questions.

Types of Queries
Creating Basic Queries
Controlling Query Data Part 1
Controlling Query Data Part 2

Access 2013: Creating a Calculated Field

From: Query Basics in Access 2013

Creating a Calculated Field
Adding Multiple Criteria in Query Design

Access 2013: Use the Query Design View

From: Query Basics in Access 2013

Use the Query Design View
Use the Simple or Crosstab Query Wizards

Access 2013: Using Filters in the Datasheet View

From: Query Basics in Access 2013

Using Filters in the Datasheet View
Removing Filters in the Datasheet View
Adding Single Criterion in Query Design

Relationships in Access 2013

Explore how Access utilizes relationships to connect data.

Primary Key Fields
Creating Table Relationships
Working with Subdatasheets

Table Basics in Access 2013

Having planned and created your database file, begin by adding or editing tables, which will store data. Next, tell access how the new tables relate to each other and begin entering data.

Using the Datasheet View to Create Tables, Add Fields, and Assign Data Types
Creating Tables
Data Types
Complex Data Types
Database Object Models - Application Parts

Access 2013: Associate Data to the Rich-text Memo Feature

From: Table Basics in Access 2013

Associate Data to the Rich-text Memo Feature
Allow Multiple Values for a Data Field
Use the Calculated Data Type

Access 2013: Database Object Models - Application Parts

From: Table Basics in Access 2013

Database Object Models - Application Parts
Create a Custom Application Part

Access 2013: Use the Datasheet View

From: Table Basics in Access 2013

Use the Datasheet View
Create a User Defined Data Type

Access 2013: Using the Design View

From: Table Basics in Access 2013

Using the Design View

Working with Reports in Access 2013

Access offers the ability to create reports on the information it houses. Learn to generate these reports, and create your own specialized reports for future use.

Report Types
Exporting Reports to PDF
Interactive Layout View for Forms and Reports
Enhancing Forms and Reports
Working with Reports in the Design View

Managing Control Properties
Using Functions

Creating Forms in Access 2013

Forms make it easier to collect the information you want. Learn to build forms, through which you or other users can add, edit, or view the information stored in your database.

Form Types
Working with Forms in the Design View
Enhancing Forms and Reports
Specifying Control Properties
Adding Controls

Customizing and Controlling Tables in Access 2013

Control the way access stores, handles, and displays table information, using special formatting to facilitate data entry and minimize error.

Specifying Field Properties
Using Input Masks
Creating Lookup Columns

Working with Macros in Access 2013

Instead of repeatedly performing routine and/or complex tasks, let access remember them for you so they can be carried out with a click or a keystroke - then store them on your quick access toolbar for easy access.

Creating Macros
Working with Embedded Macros
Event vs. Event Properties

Advanced Queries in Access 2013

Add power to your basic queries by including calculations, setting criteria, and formatting information for maximum visual impact.

Total Queries
Crosstab Queries
Expression Builder Feature
Advanced Query Calculation
Action Queries

Enhancing Form Usability in Access 2013

Go beyond standard forms.

Adding Command Buttons
Using the Themes Group
Organizing with Tab Controls
Working with Subforms

Working with Other Microsoft Applications and Access 2013

Share data between access and other Microsoft office applications.

Importing External Data
Exporting Data
Using Office Links Options

Excel 2013

Getting Started with Formulas in Excel 2013

Create basic formulas applying the correct structure. Create formulas using the function libraries of Excel.

Formulas
Calculate Totals Using The Quick Analysis Tool
Excel Functions
Relative vs Absolute Cell References
Structured References

Add a Formula to a Table Column
Disabling the Use of Table Names in Formulas
Named Ranges
Common Excel Errors

Excel 2013: Add a Formula to a Table Column

From: Getting Started with Formulas in Excel 2013

Add a Formula to a Table Column

Excel 2013: Calculate Totals Using The Quick Analysis Tool

From: Getting Started with Formulas in Excel 2013

Calculate Totals Using The Quick Analysis Tool

Excel 2013: Common Excel Errors

From: Getting Started with Formulas in Excel 2013

Common Excel Errors

Excel 2013: Disabling the Use of Table Names in Formulas

From: Getting Started with Formulas in Excel 2013

Disabling the Use of Table Names in Formulas

Excel 2013

Excel 2013: Excel Functions

From: Getting Started with Formulas in Excel 2013

Excel Functions

Excel 2013: Formulas

From: Getting Started with Formulas in Excel 2013

Formulas

Excel 2013: Named Ranges

From: Getting Started with Formulas in Excel 2013

Named Ranges

Excel 2013: Relative vs Absolute Cell References

From: Getting Started with Formulas in Excel 2013

Relative vs Absolute Cell References

Excel 2013: Structured References

From: Getting Started with Formulas in Excel 2013

Structured References

Functions in Excel 2013

Explore Excel's wide variety of built-in functions in the function libraries.

Date Functions
Text Functions
Logical Functions
AND/OR Functions
Lookup and Reference Functions

Statistical Functions
The Convert Function
INDEX Function

Excel 2013: AND/OR Functions

From: Functions in Excel 2013

AND/OR Functions

Excel 2013: Date Functions

From: Functions in Excel 2013

Date Functions

Excel 2013: INDEX Function

From: Functions in Excel 2013

INDEX Function

Excel 2013: Logical Functions

From: Functions in Excel 2013

Logical Functions

Excel 2013: Lookup and Reference Functions

From: Functions in Excel 2013

Lookup and Reference Functions

Excel 2013: Statistical Functions

From: Functions in Excel 2013

Statistical Functions

Excel 2013: Text Functions

From: Functions in Excel 2013

Text Functions

Excel 2013: The Convert Function

From: Functions in Excel 2013

The Convert Function

Sorting, Filtering, and Other Data Commands in Excel 2013

Basic Sorting and Filtering
Sort Data
Formatting Using the Quick Analysis Tool
Using Conditional Formatting
Using AutoFilter

Find and Remove Duplicate Data
Advanced Filters
Using Filter Operators
Create Subtotals
Copying Filtered or Subtotal Data

Text to Columns
The Watch Window

Excel 2013: Advanced Filters

From: Sorting, Filtering, and Other Data Commands in Excel 2013

Advanced Filters

Excel 2013: Basic Sorting and Filtering

From: Sorting, Filtering, and Other Data Commands in Excel 2013

Basic Sorting and Filtering

Excel 2013: Copying Filtered or Subtotal Data

From: Sorting, Filtering, and Other Data Commands in Excel 2013

Copying Filtered or Subtotal Data

Excel 2013: Create Subtotals

From: Sorting, Filtering, and Other Data Commands in Excel 2013

Create Subtotals

Excel 2013: Find and Remove Duplicate Data

From: Sorting, Filtering, and Other Data Commands in Excel 2013

Find and Remove Duplicate Data

Excel 2013: Formatting Using the Quick Analysis Tool

From: Sorting, Filtering, and Other Data Commands in Excel 2013

Formatting Using the Quick Analysis Tool

Excel 2013: Sort Data

From: Sorting, Filtering, and Other Data Commands in Excel 2013

Sort Data

Excel 2013: Text to Columns

From: Sorting, Filtering, and Other Data Commands in Excel 2013

Text to Columns

Excel 2013: The Watch Window

From: Sorting, Filtering, and Other Data Commands in Excel 2013

The Watch Window

Excel 2013: Using AutoFilter

From: Sorting, Filtering, and Other Data Commands in Excel 2013

Using AutoFilter

Excel 2013: Using Conditional Formatting

From: Sorting, Filtering, and Other Data Commands in Excel 2013

Using Conditional Formatting

Working with Charts in Excel 2013

Creating A Chart
Visualize Data Using The Quick Analysis Tool
Recommended Charts
Format a Chart
Quick Format Buttons

Modifying Chart Data
Working with Trendlines
Sparkline Charts
Create a Combo Chart
Format Chart Data Labels

Saving a Custom Chart as a Template

Excel 2013: Create a Combo Chart

From: Working with Charts in Excel 2013

Create a Combo Chart

Excel 2013: Creating A Chart

From: Working with Charts in Excel 2013

Creating A Chart

Excel 2013: Format a Chart

From: Working with Charts in Excel 2013

Format a Chart

Excel 2013: Format Chart Data Labels

From: Working with Charts in Excel 2013

Format Chart Data Labels

Excel 2013: Modifying Chart Data

From: Working with Charts in Excel 2013

Modifying Chart Data

Excel 2013: Quick Format Buttons

From: Working with Charts in Excel 2013

Quick Format Buttons

Excel 2013: Recommended Charts

From: Working with Charts in Excel 2013

Recommended Charts

Excel 2013: Saving a Custom Chart as a Template

From: Working with Charts in Excel 2013

Saving a Custom Chart as a Template

Excel 2013: Sparkline Charts

From: Working with Charts in Excel 2013

Sparkline Charts

Excel 2013: Visualize Data Using The Quick Analysis Tool

From: Working with Charts in Excel 2013

Visualize Data Using The Quick Analysis Tool

Excel 2013: Working with Trendlines

From: Working with Charts in Excel 2013

Working with Trendlines

Working with Tables in Excel 2013

Work with Tables and Slicers in Excel 2013.

Create an Excel Table
Modify an Excel Table
Using AutoFilters in Excel Tables
Slicers in Tables
Table Totals

Excel 2013: Create an Excel Table

From: Working with Tables in Excel 2013

Create an Excel Table

Excel 2013: Modify an Excel Table

From: Working with Tables in Excel 2013

Modify an Excel Table

Excel 2013: Slicers in Tables

From: Working with Tables in Excel 2013

Slicers in Tables

Excel 2013: Table Totals

From: Working with Tables in Excel 2013

Table Totals

Excel 2013: Using AutoFilters in Excel Tables

From: Working with Tables in Excel 2013

Using AutoFilters in Excel Tables

Formatting in Excel 2013

Formatting Worksheets
Excel Mini Toolbar
Working with Live Preview
Cell Borders and Fill Options
Working with Text Alignment

Cell Formats
Working with Styles
Header and Footer
Automatically Fill a Row or Column
Flash Fill

Formatting Using the Quick Analysis Tool
Working with Templates
Working with Themes
Screenshot

Excel 2013: Automatically Fill a Row or Column

From: Formatting in Excel 2013

Automatically Fill a Row or Column

Excel 2013: Cell Borders and Fill Options

From: Formatting in Excel 2013

Cell Borders and Fill Options

Excel 2013: Cell Formats

From: Formatting in Excel 2013

Cell Formats

Excel 2013: Excel Mini Toolbar

From: Formatting in Excel 2013

Excel Mini Toolbar

Excel 2013

Excel 2013: Flash Fill

From: Formatting in Excel 2013

Flash Fill

Excel 2013: Formatting Using the Quick Analysis Tool

From: Formatting in Excel 2013

Formatting Using the Quick Analysis Tool

Excel 2013: Formatting Worksheets

From: Formatting in Excel 2013

Formatting Worksheets

Excel 2013: Header and Footer

From: Formatting in Excel 2013

Header and Footer

Excel 2013: Screenshot

From: Formatting in Excel 2013

Screenshot

Excel 2013: Working with Live Preview

From: Formatting in Excel 2013

Working with Live Preview

Excel 2013: Working with Styles

From: Formatting in Excel 2013

Working with Styles

Excel 2013: Working with Templates

From: Formatting in Excel 2013

Working with Templates

Excel 2013: Working with Text Alignment

From: Formatting in Excel 2013

Working with Text Alignment

Excel 2013: Working with Themes

From: Formatting in Excel 2013

Working with Themes

Getting Started with Excel 2013

Learn your way around the excel window, the basics of creating and saving excel files, and how to view and arrange worksheets for ease of use.

Elements of the Excel 2013 Window
Getting Help
Excel Options
Managing Workbooks
Excel File Formats
Saving Your Workbook
Managing Worksheets
Rows and Columns

Entering Data
The Quick Analysis Tool
Find and Select Data
The Excel Status Bar
Document Views
Workbook Views
Page Layout
The Office Clipboard

Paste Options
The Paste Values Feature
Using the Paste Special Feature
Apps for Office
Setting the Print Area and Print Titles
Preview & Print

Customizing the Excel 2013 Environment

Make your Excel interface yours!

Customize the Excel Ribbon
The Quick Access Toolbar
Customize the Excel Options General Page
Customize the Excel Proofing Options
Customize How Your Excel Worksheets are Saved

Customizing the Excel Options Advanced Settings

Excel 2013 Advanced Filters

Make use of Excel's built in tool to handle complex data-sets.

Set up the Criteria Range
Apply Advanced Filters
Display All Data

Exporting and Importing Data in Excel 2013

Flow data into and out of Excel.

Exporting Your Excel Data
Data Export File Types
Importing External Data
Importing Data from Text
Importing Data from the Web

Creating a Web Query

Excel 2013: Creating a Web Query

From: Exporting and Importing Data in Excel 2013

Creating a Web Query

Excel 2013: Exporting Your Excel Data

From: Exporting and Importing Data in Excel 2013

Exporting Your Excel Data

Excel 2013: Importing Data from Text

From: Exporting and Importing Data in Excel 2013

Importing Data from Text

Excel 2013: Importing Data from the Web

From: Exporting and Importing Data in Excel 2013

Importing Data from the Web

Excel 2013: Importing External Data

From: Exporting and Importing Data in Excel 2013

Importing External Data

Working with Multiple Worksheets in Excel 2013

Working Across Worksheets or Workbooks
Working With Worksheet Tabs
Changing the Worksheet Tab Color
Multiple Sheet Formulas
Consolidating Data

Excel 2013: Changing the Worksheet Tab Color

From: Working with Multiple Worksheets in Excel 2013

Changing the Worksheet Tab Color

Excel 2013: Consolidating Data

From: Working with Multiple Worksheets in Excel 2013

Consolidating Data

Excel 2013: Multiple Sheet Formulas

From: Working with Multiple Worksheets in Excel 2013

Multiple Sheet Formulas

Excel 2013: Working Across Worksheets or Workbooks

From: Working with Multiple Worksheets in Excel 2013

Working Across Worksheets or Workbooks

Excel 2013: Working With Worksheet Tabs

From: Working with Multiple Worksheets in Excel 2013

Working With Worksheet Tabs

Collaborating with Others in Excel 2013

Learn to work collaboratively, using built in Excel tools.

Data Validation
Protecting Microsoft Excel Worksheets
Send a Workbook to a Recipient as an Attachment
Share an Excel Workbook
Track Changes in Excel

Use Comments in Excel
Merging Excel Workbooks

Working with Styles, Themes, and Shapes in Excel 2013

Simplify the process of creating professional-looking Excel documents.

Working with Styles
Working with Themes
Working with Shapes

Tips and Tricks in Excel 2013

Become an Excel Expert.

Customize the Excel Ribbon
The Quick Access Toolbar
Keyboard Shortcuts
Changing the Worksheet Tab Color
The Excel Status Bar
Protecting Microsoft Excel Worksheets

Recover Unsaved Workbooks
The Office Clipboard
Automatically Fill a Row or Column
Basic Sorting and Filtering
View Multiple Worksheets Side by Side
The Split View Feature

Cell Formats
The Paste Values Feature
SmartArt
The Align Feature
The Selection Pane

Working with PivotTables in Excel 2013

PivotTables
Edit a PivotTable
Working with PivotTable Fields
Grouping in PivotTables
PivotCharts

Add Slicers to a PivotTable
Add Timelines to a PivotTable

Excel 2013: Add Slicers to a PivotTable

From: Working with PivotTables in Excel 2013

Add Slicers to a PivotTable

Excel 2013: Add Timelines to a PivotTable

From: Working with PivotTables in Excel 2013

Add Timelines to a PivotTable

Excel 2013: Edit A PivotTable

From: Working with PivotTables in Excel 2013

Edit A PivotTable

Excel 2013: Grouping in PivotTables

From: Working with PivotTables in Excel 2013

Grouping in PivotTables

Excel 2013: PivotCharts

From: Working with PivotTables in Excel 2013

PivotCharts

Excel 2013: PivotTables

From: Working with PivotTables in Excel 2013

PivotTables

Excel 2013: Working with PivotTable Fields

From: Working with PivotTables in Excel 2013

Working with PivotTable Fields

Working with Macros and Objects in Excel 2013

The Developer Tab
Microsoft Excel Trust Center
Working with Macros
Working with Shapes
Edit a Macro

Excel 2013: Edit a Macro

From: Working with Macros and Objects in Excel 2013

Edit a Macro

Excel 2013: Microsoft Excel Trust Center

From: Working with Macros and Objects in Excel 2013

Microsoft Excel Trust Center

Excel 2013: The Developer Tab

From: Working with Macros and Objects in Excel 2013

The Developer Tab

Excel 2013: Working with Macros and Objects in Excel 2013

From: Working with Macros and Objects in Excel 2013

Working with Macros and Objects in Excel 2013

Excel 2013: Working with Shapes

From: Working with Macros and Objects in Excel 2013

Working with Shapes

Working with PowerPivots in Excel 2013

Explore the built-in functionality of PowerPivot, a free add-in for Microsoft Excel. PowerPivot builds on the concept of PivotTable data and cross-tabulation feature.

Enabling PowerPivot in Excel
Getting Started with PowerPivot
Create a PowerPivot Data Model
Creating and Managing PowerPivot Relationships
Add KPIs to a PowerPivot or a PivotTable

PowerPivot Functions
Add Calculations in a PowerPivot
The Power View Feature
Filter and Highlight Data in Your Power View Report

Outlook 2013

Customize Your Outlook 2013 Environment

Make your Outlook interface yours!

Customize the Outlook Ribbon
The Quick Access Toolbar
Customize the Outlook Options General Page
Customizing the Outlook Options Mail Settings
Customizing the Outlook Options Advanced Settings

Getting Started with Outlook 2013

Learn your way around the outlook window and use the various 'panes' that keep information available at a glance. Explore Outlook's new message management features that keep critical information at the fore automatically.

Getting Started with Outlook
Elements of the Outlook Window
The Outlook Ribbons
The File Tab
The Quick Access Toolbar

Getting Help
E-mail Folders
Reading Pane
The Outlook To-Do Bar
Instant Search

Composing Messages

Outlook 2013: Composing Messages

From: Getting Started with Outlook 2013

Composing Messages
E-Mail Basics
Managing Attachments
Using Tags

Outlook 2013: E-mail Folders

From: Getting Started with Outlook 2013

E-mail Folders

Outlook 2013: Elements of the Outlook Window

From: Getting Started with Outlook 2013

Elements of the Outlook Window

Outlook 2013

Outlook 2013: Getting Help

From: Getting Started with Outlook 2013

Getting Help
Using Microsoft Outlook Help

Outlook 2013: Getting Started with Outlook

From: Getting Started with Outlook 2013

Getting Started with Outlook
Email
Calendar
Tasks
Notes

Journal

Outlook 2013: Instant Search

From: Getting Started with Outlook 2013

Instant Search

Outlook 2013: Reading Pane

From: Getting Started with Outlook 2013

Reading Pane
Display the Reading Pane
View Messages in the Reading Pane
Save Attachments from the Reading Pane
Preview an Attachment

Sort Messages

Outlook 2013: The File Tab

From: Getting Started with Outlook 2013

The File Tab
File Tab Functionality

Outlook 2013: The Outlook Ribbons

From: Getting Started with Outlook 2013

The Outlook Ribbons
The Home Ribbon Tab
The Send/Receive Ribbon Tab
The Folder Ribbon Tab
The View Ribbon Tab

Outlook 2013: The Outlook To-Do Bar

From: Getting Started with Outlook 2013

The Outlook To-Do Bar
Display the To-Do Bar
Hide the To-Do Bar

Outlook 2013: The Quick Access Toolbar

From: Getting Started with Outlook 2013

The Quick Access Toolbar
Add Standard Quick Access Toolbar Buttons
Customizing the Quick Access Toolbar

Managing Your Calendar in Outlook 2013

Customize your appointments to make them informative and easy to find. Let Outlook handle the details of scheduling meetings and relevant information automatically.

Customizing the Outlook Options Calendar Settings
Managing Calendar Views
The Overlay View
Managing Calendar Layouts
Creating Multiple Calendars

Using the Scheduling Assistant
Find a Meeting Room
Categorize Your Meetings
Managing Calendar Requests for Another Person
Adding Meeting Notes Using OneNote

Outlook 2013: Adding Meeting Notes Using OneNote

From: Managing Your Calendar in Outlook 2013

Adding Meeting Notes Using OneNote
Sharing Notes
Taking Notes
Managing Your Contacts in Outlook 2013

Outlook 2013: Categorize Your Meetings

From: Managing Your Calendar in Outlook 2013

Categorize Your Meetings

Outlook 2013: Creating Multiple Calendars

From: Managing Your Calendar in Outlook 2013

Creating Multiple Calendars

Outlook 2013: Customizing the Outlook Options Calendar Settings

From: Managing Your Calendar in Outlook 2013

Customizing the Outlook Options Calendar Settings

Outlook 2013: Find a Meeting Room

From: Managing Your Calendar in Outlook 2013

Find a Meeting Room

Outlook 2013: Managing Calendar Layouts

From: Managing Your Calendar in Outlook 2013

Managing Calendar Layouts
Daily Task List
Folder Pane
Reading Pane
To-Do Bar

Outlook 2013: Managing Calendar Requests for Another Person

From: Managing Your Calendar in Outlook 2013

Managing Calendar Requests for Another Person

Outlook 2013: Managing Calendar Views

From: Managing Your Calendar in Outlook 2013

Managing Calendar Views
Change the Calendar View
Create a New Calendar View
Edit Calendar Views

Outlook 2013: The Overlay View

From: Managing Your Calendar in Outlook 2013

The Overlay View

Outlook 2013: Using the Scheduling Assistant

From: Managing Your Calendar in Outlook 2013

Using the Scheduling Assistant

Managing Your Contacts in Outlook 2013

Customize your appointments to make them informative and easy to find. Let Outlook handle the details of scheduling meetings and relevant information automatically.

Customizing the Outlook Options People Settings
Importing Contacts
Editing a Contact
Attaching an Image to a Contact
Adding Tags to Contacts

Deleting a Contact
Forwarding Contacts
Sharing Contacts
Working with Contact Groups
Printing Contacts

Using the Outlook Social Connector

Outlook 2013: Adding Tags to Contacts

From: Managing Your Contacts in Outlook 2013

Adding Tags to Contacts

Outlook 2013: Attaching an Image to a Contact

From: Managing Your Contacts in Outlook 2013

Attaching an Image to a Contact

Outlook 2013: Customizing the Outlook Options People Settings

From: Managing Your Contacts in Outlook 2013

Customizing the Outlook Options People Settings

Outlook 2013: Deleting a Contact

From: Managing Your Contacts in Outlook 2013

Deleting a Contact

Outlook 2013: Editing a Contact

From: Managing Your Contacts in Outlook 2013

Editing a Contact

Outlook 2013: Forwarding Contacts

From: Managing Your Contacts in Outlook 2013

Forwarding Contacts

Outlook 2013: Importing Contacts

From: Managing Your Contacts in Outlook 2013

Importing Contacts
Importing Contacts from an Outlook Data File

Outlook 2013: Printing Contacts

From: Managing Your Contacts in Outlook 2013

Printing Contacts
Printing One Contact
Printing All Contacts

Outlook 2013: Sharing Contacts

From: Managing Your Contacts in Outlook 2013

Sharing Contacts

Outlook 2013: Using the Outlook Social Connector

From: Managing Your Contacts in Outlook 2013

Using the Outlook Social Connector
Turning on the Outlook Social Connector
Viewing Updates

Outlook 2013: Working with Contact Groups

From: Managing Your Contacts in Outlook 2013

Working with Contact Groups
Creating a Contact Group
Adding Notes to a Contact Group
Deleting a Contact Group

Managing Your Messages in Outlook 2013

Arrange messages onscreen in an order that matches how you work. Customize messages with your own information and style, and add information to messages that integrate them automatically with other outlook elements. Easily stay in control of detailed information regarding an individual or organization.

Manage Your Messages
Conversations
Signatures
Categorize and Follow Up
Automatic Replies

Working with Contacts
Create a Contact Group
Set Message Delivery Options
Spell and Grammar Check a Message

Outlook 2013: Automatic Replies

From: Managing Your Messages in Outlook 2013

Automatic Replies

Outlook 2013: Categorize and Follow Up

From: Managing Your Messages in Outlook 2013

Categorize and Follow Up
Categorize an E-mail Message
Flag a Message for Follow Up

Outlook 2013: Conversations

From: Managing Your Messages in Outlook 2013

Conversations
Turn On Conversations
Navigate Conversations

Outlook 2013: Create a Contact Group

From: Managing Your Messages in Outlook 2013

Create a Contact Group

Outlook 2013: Manage Your Messages

From: Managing Your Messages in Outlook 2013

Manage Your Messages
Read and Unread Messages
Sort Messages
Create a New Folder
Move Messages Between Folders

Outlook 2013: Set Message Delivery Options

From: Managing Your Messages in Outlook 2013

Set Message Delivery Options

Outlook 2013: Signatures

From: Managing Your Messages in Outlook 2013

Signatures

Outlook 2013: Spell and Grammar Check a Message

From: Managing Your Messages in Outlook 2013

Spell and Grammar Check a Message

Outlook 2013: Working with Contacts

From: Managing Your Messages in Outlook 2013

Working with Contacts
The People Pane
Create a New Contact
Assign a Contact to a Category
Search for a Contact

Send a Message to a Contact

The Calendar Feature in Outlook 2013

Customize your appointments to make them informative and easy to find. Let Outlook handle the details of scheduling meetings and relevant information automatically.

Elements of the Calendar Window
The Calendar Peek
View the Calendar
The Calendar Background Color
Appointments

Working with Appointments
Edit and Delete Calendar Entries
Meetings
Manage Meeting Requests
Send a Calendar Via E-Mail

Tasks on Calendars
Share Outlook Calendars
Calendar Groups and the Schedule View

Outlook 2013: Appointments

From: The Calendar Feature in Outlook 2013

Appointments
Schedule an Appointment
Update Calendar Entries

Outlook 2013: Calendar Groups and the Schedule View

From: The Calendar Feature in Outlook 2013

Calendar Groups and the Schedule View
Using Outlook 2013 Tools

Outlook 2013: Edit and Delete Calendar Entries

From: The Calendar Feature in Outlook 2013

Edit and Delete Calendar Entries
Edit Calendar Entries
Delete Calendar Entries

Outlook 2013: Elements of the Calendar Window

From: The Calendar Feature in Outlook 2013

Elements of the Calendar Window

Outlook 2013: Manage Meeting Requests

From: The Calendar Feature in Outlook 2013

Manage Meeting Requests
Track Meeting Responses
Update Meeting Requests
Cancel Meeting Requests

Outlook 2013: Meetings

From: The Calendar Feature in Outlook 2013

Meetings
Schedule a Meeting
Reply to a Meeting Request

Outlook 2013: Send a Calendar Via E-Mail

From: The Calendar Feature in Outlook 2013

Send a Calendar Via E-Mail

Outlook 2013

Outlook 2013: Share Outlook Calendars

From: The Calendar Feature in Outlook 2013

Share Outlook Calendars
Share Your Calendar With A Contact
Open a Shared Calendar

Outlook 2013: Tasks on Calendars

From: The Calendar Feature in Outlook 2013

Tasks on Calendars
Add Tasks in the Calendar View

Outlook 2013: The Calendar Background Color

From: The Calendar Feature in Outlook 2013

The Calendar Background Color

Outlook 2013: The Calendar Peek

From: The Calendar Feature in Outlook 2013

The Calendar Peek

Outlook 2013: View the Calendar

From: The Calendar Feature in Outlook 2013

View the Calendar

Outlook 2013: Working with Appointments

From: The Calendar Feature in Outlook 2013

Working with Appointments
Schedule a Recurring Appointment
Set an Appointment Reminder
The Categorize Feature
Edit Categories

Using Outlook 2013 Tools

Use tasks to assign work to complete within a certain time frame. Include all aspects of a task - including contacts, resources, categories, and priority - and measure your progress toward completion. Use notes to capture and manage those bits of miscellaneous information. Let Outlook track your daily activity automatically with the journal feature, making it easy to see how you spend your time and document your work.

Using Outlook Tools
Create a Task
Update Task Information
The Notes Feature
Working with Journal Entries

Outlook 2013: Create a Task

From: Using Outlook 2013 Tools

Create a Task
Create a Task in the New Task Dialog Box
Create a Task in the Tasks Window
Assign a Task to a Different Person

Outlook 2013: The Notes Feature

From: Using Outlook 2013 Tools

The Notes Feature
Create a Note
Move a Note
Resize a Note
Send a Note to a Contact

Assign a Note to a Category

Outlook 2013: Update Task Information

From: Using Outlook 2013 Tools

Update Task Information
Update a Task General Information
Mark a Task Complete in the Tasks Window
Mark a Task Complete in the Task Dialog Box
Delete a Task

Outlook 2013: Using Outlook Tools

From: Using Outlook 2013 Tools

Using Outlook Tools

Outlook 2013: Working with Journal Entries

From: Using Outlook 2013 Tools

Working with Journal Entries
Accessing the Journal Feature
Manually Create a Journal Entry
Categorize a Journal Entry
Share a Journal Entry

Organizing Folders and Emails in Outlook 2013

Use folder and email rules and options to keep your messages and folders organized in Outlook 2013.

Create an Outlook Rule from a Template
Create an Outlook Rule from a Blank Rule
Empty Deleted Items on Exit
Setting Junk E-Mail Folder Options
Manage Items in Your Junk E-Mail Folder

AutoArchive Settings for Outlook
Manual Archive of Outlook Items
Create a Personal Folder (PST)

Outlook 2013: AutoArchive Settings for Outlook

From: Organizing Folders and Emails in Outlook 2013

AutoArchive Settings for Outlook
General AutoArchive Options
Folder AutoArchive Options

Outlook 2013: Create a Personal Folder (PST)

From: Organizing Folders and Emails in Outlook 2013

Create a Personal Folder (PST)

Outlook 2013: Create an Outlook Rule from a Blank Rule

From: Organizing Folders and Emails in Outlook 2013

Create an Outlook Rule from a Blank Rule

Outlook 2013: Create an Outlook Rule from a Template

From: Organizing Folders and Emails in Outlook 2013

Create an Outlook Rule from a Template

Outlook 2013: Empty Deleted Items on Exit

From: Organizing Folders and Emails in Outlook 2013

Empty Deleted Items on Exit

Outlook 2013: Manage Items in Your Junk E-Mail Folder

From: Organizing Folders and Emails in Outlook 2013

Manage Items in Your Junk E-Mail Folder

Outlook 2013: Manual Archive of Outlook Items

From: Organizing Folders and Emails in Outlook 2013

Manual Archive of Outlook Items

Outlook 2013: Setting Junk E-Mail Folder Options

From: Organizing Folders and Emails in Outlook 2013

Setting Junk E-Mail Folder Options

Advanced Message Management in Outlook 2013

Using Quick Steps
The Clean Up Feature
Recover Deleted Items
Sharing Outlook Folders
Redirect Email Replies

Delegate Access and Permission Roles
Managing Email on Behalf of Another Person

Outlook 2013: Delegate Access and Permission Roles

From: Advanced Message Management in Outlook 2013

Delegate Access and Permission Roles
Setting Delegate Permissions

Outlook 2013: Managing Email on Behalf of Another Person

From: Advanced Message Management in Outlook 2013

Managing Email on Behalf of Another Person
Replying to an Email
Creating an Email

Outlook 2013: Recover Deleted Items

From: Advanced Message Management in Outlook 2013

Recover Deleted Items

Outlook 2013: Redirect Email Replies

From: Advanced Message Management in Outlook 2013

Redirect Email Replies

Outlook 2013: Sharing Outlook Folders

From: Advanced Message Management in Outlook 2013

Sharing Outlook Folders

Outlook 2013: The Clean Up Feature

From: Advanced Message Management in Outlook 2013

The Clean Up Feature

Outlook 2013: Using Quick Steps

From: Advanced Message Management in Outlook 2013

Using Quick Steps
Default Quick Steps
Creating a Quick Step

Advanced Message Options in Outlook 2013

Using Message Themes
Message Page Color
Inserting Illustrations
Inserting Links
Working with Text

Inserting Symbols
Inserting Tables
Managing Sensitivity Levels
Adding Voting Options to Messages
Request Delivery and Read Receipts

PowerPoint 2013

Creating a Presentation in PowerPoint 2013

A presentation is simply a collection of slides to be displayed in a specified order. Begin by developing your individual slides and choosing on-slide animations. Next, setup slide-to-slide transitions.

The Start Screen
Methods for Creating a Presentation
Create a New Presentation
Elements of a Slide
Slide Layouts

Working with Slides
Entering Text in a Slide
Text Boxes

PowerPoint 2013: Create a New Presentation

From: Creating a Presentation in PowerPoint 2013

Create a New Presentation
Create a Presentation from a Template or Theme
Create a New
Blank
Presentation

Use Office.com Template

PowerPoint 2013: Elements of a Slide

From: Creating a Presentation in PowerPoint 2013

Elements of a Slide

PowerPoint 2013: Entering Text in a Slide

From: Creating a Presentation in PowerPoint 2013

Entering Text in a Slide
Add Text to a Slide
The Font and Paragraph Groups
Format Text
Change Text Alignment

PowerPoint 2013: Methods for Creating a Presentation

From: Creating a Presentation in PowerPoint 2013

Methods for Creating a Presentation

PowerPoint 2013: Slide Layouts

From: Creating a Presentation in PowerPoint 2013

Slide Layouts
Change the Slide's Orientation
Change the Slide's Layout

PowerPoint 2013: Text Boxes

From: Creating a Presentation in PowerPoint 2013

Text Boxes
Add a Text Box
Move a Text Box
Resize a Text Box
Rotate a Text Box

PowerPoint 2013: The Start Screen

From: Creating a Presentation in PowerPoint 2013

The Start Screen

PowerPoint 2013: Working with Slides

From: Creating a Presentation in PowerPoint 2013

Working with Slides
Insert a New Slide
Delete a Slide

Customizing Your PowerPoint 2013 Environment

Make the PowerPoint interface yours!

Customize the PowerPoint Ribbon
Customize the Quick Access Toolbar
Customizing the PowerPoint Proofing Options
Customizing the PowerPoint General Options
Customize How Your Presentations are Saved

Advanced PowerPoint Options

PowerPoint 2013: Advanced PowerPoint Options

From: Customizing Your PowerPoint 2013 Environment

Advanced PowerPoint Options

PowerPoint 2013: Customize How Your Presentations are Saved

From: Customizing Your PowerPoint 2013 Environment

Customize How Your Presentations are Saved

PowerPoint 2013: Customize the PowerPoint Ribbon

From: Customizing Your PowerPoint 2013 Environment

Customize the PowerPoint Ribbon
Understand the Customize the Ribbon List

PowerPoint 2013: Customize the Quick Access Toolbar

From: Customizing Your PowerPoint 2013 Environment

Customize the Quick Access Toolbar
Alternate Methods for Adding Commands to the Quick Access Toolbar

PowerPoint 2013: Customizing the PowerPoint General Options

From: Customizing Your PowerPoint 2013 Environment

Customizing the PowerPoint General Options

PowerPoint 2013: Customizing the PowerPoint Proofing Options

From: Customizing Your PowerPoint 2013 Environment

Customizing the PowerPoint Proofing Options
Modify Proofing Options
AutoCorrect Options

Customizing Your Slide Show in PowerPoint 2013

Gather input from others for additional input, choosing with a few clicks which editions to incorporate. Once your presentation is complete, easily tell PowerPoint precisely how you want it to behave during presentation: make it presenter- or self-led, create 'shows within the show' to present certain content to a certain audience, let PowerPoint package all supplementary files to be sure nothing gets left behind, and more.

Creating Custom Themes
Customizing Your Slides
Embed Fonts
Customizing Slide Transitions
Custom Shows

Rehearse Timings
Record Your Slide Show Presentation
Secure Your Slide Show Presentation

PowerPoint 2013: Creating Custom Theme

From: Customizing Your Slide Show in PowerPoint 2013

Creating Custom Theme
Create and Edit a Custom Theme
Save a Custom Theme

PowerPoint 2013

PowerPoint 2013: Custom Shows

From: Customizing Your Slide Show in PowerPoint 2013

Custom Shows
Create a Custom Show
Start a Custom Show Presentation

PowerPoint 2013: Customizing Slide Transitions

From: Customizing Your Slide Show in PowerPoint 2013

Customizing Slide Transitions
Apply Slide Transitions to Multiple Slides

PowerPoint 2013: Customizing Your Slides

From: Customizing Your Slide Show in PowerPoint 2013

Customizing Your Slides
Edit a Slide Layout
Add a Header and Footer to a Slide or Notes and Handouts

PowerPoint 2013: Embed Fonts

From: Customizing Your Slide Show in PowerPoint 2013

Embed Fonts
Embed TrueType Fonts

PowerPoint 2013: Record Your Slide Show Presentation

From: Customizing Your Slide Show in PowerPoint 2013

Record Your Slide Show Presentation
Record Narrations

PowerPoint 2013: Rehearse Timings

From: Customizing Your Slide Show in PowerPoint 2013

Rehearse Timings

PowerPoint 2013: Secure Your Slide Show Presentation

From: Customizing Your Slide Show in PowerPoint 2013

Secure Your Slide Show Presentation
Password Protection
Mark a Presentation as Final

Delivering Your Presentation in PowerPoint 2013

Reviewing Your Presentation
Timing and Narrations
Print Handouts and Notes
Speaker Notes
Preview and Print Your Presentation

Set Up the Show
The Presenter View

PowerPoint 2013: Preview and Print Your Presentation

From: Delivering Your Presentation in PowerPoint 2013

Preview and Print Your Presentation
Print Preview
Print
Print from the Quick Access Toolbar

PowerPoint 2013: Print Handouts and Notes

From: Delivering Your Presentation in PowerPoint 2013

Print Handouts and Notes
Print Handouts
Send Your Notes to Word

PowerPoint 2013: Reviewing Your Presentation

From: Delivering Your Presentation in PowerPoint 2013

Reviewing Your Presentation
AutoCorrect
Spell Check
Thesaurus

PowerPoint 2013: Set Up the Show

From: Delivering Your Presentation in PowerPoint 2013

Set Up the Show

PowerPoint 2013: Speaker Notes

From: Delivering Your Presentation in PowerPoint 2013

Speaker Notes
Add Speaker Notes to Slides
Print Speaker Notes

PowerPoint 2013: The Presenter View

From: Delivering Your Presentation in PowerPoint 2013

The Presenter View

PowerPoint 2013: Timing and Narrations

From: Delivering Your Presentation in PowerPoint 2013

Timing and Narrations
Rehearse Timings
Record Narrations

Formatting Text in PowerPoint 2013

Use a variety of techniques to add and edit written information on your slides. Explore several formatting methods that give them an attractive and easy-to-understand appearance, and use special features that let you change content and/or appearance across the presentation with a single command.

Formatting Text
Working with Live Preview
The Format Painter
Formatting Text Boxes
Cut, Copy, and Paste

The Paste Special Command
Find and Replace
Create and Format Bulleted or Numbered Lists
Create Slides from a Word Outline
Organizing Text Using the Outline View

PowerPoint 2013: Create and Format Bulleted or Numbered Lists

From: Formatting Text in PowerPoint 2013

Create and Format Bulleted or Numbered Lists
Create a Bulleted or Numbered List
Customize Bullets or Numbers

PowerPoint 2013: Create Slides from a Word Outline

From: Formatting Text in PowerPoint 2013

Create Slides from a Word Outline
Insert an Outline into a Presentation

PowerPoint 2013: Cut | Copy | and Paste

From: Formatting Text in PowerPoint 2013

Cut , Copy , and Paste
Cut , Copy , and Paste Options
The Clipboard

PowerPoint 2013: Find and Replace

From: Formatting Text in PowerPoint 2013

Find and Replace
Find Text in a Presentation
Replace Text in a Presentation

PowerPoint 2013: Formatting Text

From: Formatting Text in PowerPoint 2013

Formatting Text
Selecting Text
The Mini Toolbar

PowerPoint 2013: Formatting Text Boxes

From: Formatting Text in PowerPoint 2013

Formatting Text Boxes
Formatting Text
Formatting a Text Box

PowerPoint 2013: Organizing Text Using the Outline View

From: Formatting Text in PowerPoint 2013

Organizing Text Using the Outline View

PowerPoint 2013: The Format Painter

From: Formatting Text in PowerPoint 2013

The Format Painter

PowerPoint 2013: The Paste Special Command

From: Formatting Text in PowerPoint 2013

The Paste Special Command

PowerPoint 2013: Working with Live Preview

From: Formatting Text in PowerPoint 2013

Working with Live Preview

Getting Started with PowerPoint 2013

Learn your way around the PowerPoint window, the basics of creating and saving PowerPoint files, and the various ways of viewing a PowerPoint file in order to edit, arrange, and rehearse it.

Elements of the PowerPoint Window
The PowerPoint Ribbon and Contextual Tabs
The File Tab
The Quick Access Toolbar
Getting Help

Ribbon Display Options
Apps for Office
PowerPoint Options
Navigating and Viewing a Presentation
PowerPoint Views

The View Tab and Master Views
The Window Group
Saving a PowerPoint Presentation
The Status Bar

PowerPoint 2013: Apps for Office

From: Getting Started with PowerPoint 2013

Apps for Office
Insert an App
Hide an App
Unhide an App

PowerPoint 2013: Elements of the PowerPoint Window

From: Getting Started with PowerPoint 2013

Elements of the PowerPoint Window

PowerPoint 2013: Getting Help

From: Getting Started with PowerPoint 2013

Getting Help
Use PowerPoint Help

PowerPoint 2013: Navigating and Viewing a Presentation

From: Getting Started with PowerPoint 2013

Navigating and Viewing a Presentation
Navigate Using the Keyboard
Navigate Using the Mouse
The Protected View

PowerPoint 2013: PowerPoint Options

From: Getting Started with PowerPoint 2013

PowerPoint Options

PowerPoint 2013: PowerPoint Views

From: Getting Started with PowerPoint 2013

PowerPoint Views
Presentation Views
Slide Show Views

PowerPoint 2013: Ribbon Display Options

From: Getting Started with PowerPoint 2013

Ribbon Display Options

PowerPoint 2013: Saving a PowerPoint Presentation

From: Getting Started with PowerPoint 2013

Saving a PowerPoint Presentation
Save Changes to a File
Save Changes as a New File

PowerPoint 2013: The File Tab

From: Getting Started with PowerPoint 2013

The File Tab
The File Tab's Commands
Recover an Unsaved File

PowerPoint 2013: The PowerPoint Ribbon and Contextual Tabs

From: Getting Started with PowerPoint 2013

The PowerPoint Ribbon and Contextual Tabs
Default Ribbon tabs
Contextual Tabs

PowerPoint 2013: The Quick Access Toolbar

From: Getting Started with PowerPoint 2013

The Quick Access Toolbar
Add Buttons to the Quick Access Toolbar

PowerPoint 2013: The Status Bar

From: Getting Started with PowerPoint 2013

The Status Bar

PowerPoint 2013: The View Tab and Master Views

From: Getting Started with PowerPoint 2013

The View Tab and Master Views
Master Views

PowerPoint 2013: The Window Group

From: Getting Started with PowerPoint 2013

The Window Group
The Window Group's Command

Organizing Slides in PowerPoint 2013

Learn the various ways of adding, editing, arranging, and otherwise handling the basic building blocks of a PowerPoint file to achieve precisely the presentation you desire.

Organizing Slides
The Slide Sorter View
The Outline View
Working with the Slide Master
Customize the Slide Master

Modify the Notes Master
Modify the Handout Master
Reuse Slides from an Existing Presentation

PowerPoint 2013: Customize the Slide Master

From: Organizing Slides in PowerPoint 2013

Customize the Slide Master
Edit the Slide Master
Add Placeholders to the Slide Master

PowerPoint 2013: Modify the Handout Master

From: Organizing Slides in PowerPoint 2013

Modify the Handout Master

PowerPoint 2013: Modify the Notes Master

From: Organizing Slides in PowerPoint 2013

Modify the Notes Master

PowerPoint 2013: Organizing Slides

From: Organizing Slides in PowerPoint 2013

Organizing Slides
Add a New Slide
Duplicate Slides
Delete a Slide
Modify a Slide

Arrange Slides
Sections

PowerPoint 2013: Reuse Slides from an Existing Presentation

From: Organizing Slides in PowerPoint 2013

Reuse Slides from an Existing Presentation

PowerPoint 2013: The Outline View

From: Organizing Slides in PowerPoint 2013

The Outline View
Create Slides in Outline View
Edit Slides in Outline View

PowerPoint 2013: The Slide Sorter View

From: Organizing Slides in PowerPoint 2013

The Slide Sorter View
Display the Slide Sorter View
Duplicate a Slide
Delete a Slide
Change the Slide Order

Hide a Slide
Unhide a Slide

PowerPoint 2013

PowerPoint 2013: Working with the Slide Master

From: Organizing Slides in PowerPoint 2013

Working with the Slide Master

Working with Graphics in PowerPoint 2013

Rulers, Guides, and Gridlines
Background Styles
Insert a Shape
Shape Categories
Managing Shapes

Format Shapes
Object Order
Group Objects
Using Object Orientation
Inserting Clip Art, Videos, Pictures, and Screenshots

PowerPoint 2013: Background Styles

From: Working with Graphics in PowerPoint 2013

Background Styles

PowerPoint 2013: Format Shapes

From: Working with Graphics in PowerPoint 2013

Format Shapes
The Format Shape Pane
Resize and Move a Shape

PowerPoint 2013: Group Objects

From: Working with Graphics in PowerPoint 2013

Group Objects

PowerPoint 2013: Insert a Shape

From: Working with Graphics in PowerPoint 2013

Insert a Shape
Shape Categories

PowerPoint 2013: Inserting Clip Art

From: Working with Graphics in PowerPoint 2013

Inserting Clip Art
Videos , Pictures , and Screenshots
Insert Clip Art
Insert a Video
Insert a Picture

Insert a Screenshot

PowerPoint 2013: Managing Shape

From: Working with Graphics in PowerPoint 2013

Managing Shape
Resize a Shape
Move a Shape
Add Text to a Shape

PowerPoint 2013: Object Order

From: Working with Graphics in PowerPoint 2013

Object Order
Move an Object Behind Another

PowerPoint 2013: Rulers | Guides | and Gridlines

From: Working with Graphics in PowerPoint 2013

Rulers , Guides , and Gridlines
Rulers
Gridlines
Guides and Smart Guides

PowerPoint 2013: Using Object Orientation

From: Working with Graphics in PowerPoint 2013

Using Object Orientation
Arrange an Object Using the Mouse
Arrange an Object Using the Picture ore Drawing Tools Format Tab

Working with SmartArt Graphics in PowerPoint 2013

Creating SmartArt Graphics
Editing Shapes in SmartArt Graphics
Adding Text to SmartArt Graphics
Applying SmartArt Styles
Animate SmartArt Graphics

PowerPoint 2013: Adding Text to SmartArt Graphics

From: Working with SmartArt Graphics in PowerPoint 2013

Adding Text to SmartArt Graphics

PowerPoint 2013: Animate SmartArt Graphics

From: Working with SmartArt Graphics in PowerPoint 2013

Animate SmartArt Graphics
Animate Individual Shapes

PowerPoint 2013: Applying SmartArt Styles

From: Working with SmartArt Graphics in PowerPoint 2013

Applying SmartArt Styles

PowerPoint 2013: Creating SmartArt Graphics

From: Working with SmartArt Graphics in PowerPoint 2013

Creating SmartArt Graphics
Insert a SmartArt Graphic onto an New Slide
Insert a SmartArt Graphic onto an Existing Slide
SmartArt Layouts

PowerPoint 2013: Editing Shapes in SmartArt Graphics

From: Working with SmartArt Graphics in PowerPoint 2013

Editing Shapes in SmartArt Graphics
Edit Using the SmartArt Tools Tabs' Commands
Arrange Objects Using the Selection Pane

Adding Visual Interest and Interactivity in PowerPoint 2013

Liven up your presentation with pictures, movies, sounds, and buttons that let the presenter or user jump to different locations within the presentation, or even to a web site!

Insert WordArt
Working with Sound
Working with Sound Options and Styles
Working with Video
Linking and Embedding Objects

Hyperlinks
Create an Action
Animating Objects
Advanced Animation Effects
Merge Shapes to Create a New Shape

Using Edit Points to Create a New Shape
Apply Color Matching to Shapes
Cropping Pictures
Adjusting Pictures

PowerPoint 2013: Advanced Animation Effects