From the Grovo Library Learn How To Use Microsoft Office 2013 for PC


Insert, picture, from file, panic, reformat: all of your Microsoft Office 2013 questions answered, in one-minute videos.

Course details

292 Lessons, 291 Quizzes

Tags: Advanced Organization, Advance Your Career, Collaborate and Manage Projects, Internet Fundamentals

Manage Excel Spreadsheets in Office for PC 2013

Format cell text and numerical data, adjust page margins and orientation, and add headers, footers, and page numbers.

  • Introduction to Microsoft Excel
  • Understand Worksheets and Workbooks
  • Navigate the Microsoft Excel Layout
  • Customize the Ribbon
  • Customize the Quick Access Toolbar
  • Create a New Excel Document
  • Save Your Excel File
  • Recover Unsaved Work
  • Insert a Hyperlink
  • Use Task Panes
  • Work with Ranges
  • Move and Edit Cells
  • Format a Cell's Text
  • Merge Cells
  • Resize Columns and Rows
  • Format Numbers
  • Add Borders to Cells
  • Add Headers, Footers, and Page Numbers
  • Adjust Page Margins and Orientation
  • Insert a Page Break
  • Show or Hide Print Titles and Gridlines
  • Use Different Text Directions
  • Add a Background Image to a Worksheet
  • Apply a Predefined Workbook Theme
  • Customize a Document Theme
  • Add a Watermark
  • Apply a Predefined Cell Style
  • Create a Custom Cell Style
  • Lock Rows and Columns
  • Add or Remove Columns and Rows
  • Select and Move a Range
  • Create a Table
  • Change How a Table Looks
  • Work with a Total Row
  • Customize What You Want to Print
  • Use Pasting Options
  • Create a Chart or Graph
  • Find and Replace Items
  • Use Auto Fill
  • Filter Data
  • Insert Sparklines
  • Customize Sparklines
  • Insert Shapes in a Worksheet
  • Insert SmartArt in a Worksheet
  • Change Your Worksheet View
  • Work with Templates
  • Create a Custom Template in Excel
  • Insert Special Characters and Symbols
  • Run a Spell Check
  • Export Data from Excel
  • Work with Outlines
  • Create an Outline
  • Ensure File Compatibility
  • Protect Your Worksheet
  • Protect Your Workbook
  • Create a Digital Signature
  • Compare Workbooks
  • Review Worksheets Using Comments
  • Customize Elements of a Chart
  • Automate Sparklines
  • Use Formulas Within a Table
  • Determine Identical Strings
  • Combine Contents of Cells
  • Change Text Casing Using a Formula
  • Work with Large Spreadsheets
  • Functions to Work with Dates
  • Calculate How Many Days Are Between Two Dates
  • Make Data Entry Easier in Excel

Present with PowerPoint in Office for PC 2013

Build custom-themed presentations, animate slides, and present your finished product.

  • Introduction to Microsoft PowerPoint 2013
  • Navigate the PowerPoint Interface
  • Customize the Quick Access Toolbar
  • Customize the Ribbon in PowerPoint
  • Create a Presentation
  • Create a New Blank Presentation
  • Create a New Presentation from a Template
  • Create a Custom Theme
  • Create a Custom Template in PowerPoint
  • Create Slides
  • Use Slide Layouts and Slide Masters
  • Create a Custom Slide Layout
  • Rearrange Slides
  • Organize Slides in Sections
  • Choose How to View Your Slides
  • Add Text to a Slide
  • Add Text Boxes
  • Format Text in a Presentation
  • Insert a Bulleted or Numbered List
  • Change Paragraph Indent
  • Add Shapes
  • Position Text in a Shape or Text Box
  • Change Text Alignment and Direction
  • Split Text into Two Columns
  • Add a Footer
  • Draw Lines
  • Add an Image to a Slide
  • Format Images on a Slide
  • Add Artistic Effects to a Picture
  • Arrange Objects
  • Align Objects
  • Group and Ungroup Objects
  • Animate Objects
  • Insert a Table
  • Change a Table's Design in Your Presentation
  • Change a Table's Layout in Your Presentation
  • Use Pasting Options in PowerPoint
  • Insert a Table from a Spreadsheet
  • Insert Charts in Your Presentation
  • Customize the Appearance of a Chart
  • Edit Data in a Chart
  • Create a Combination Chart
  • Add a Secondary Axis to a Chart
  • Add a Trendline to a Chart
  • Create a Chart Template
  • Format Text Using the Format Painter
  • Find and Replace Text
  • Insert a Hyperlink
  • Insert WordArt
  • Insert and Edit SmartArt Graphics
  • Convert Text to SmartArt Graphics
  • Add Audio to a Presentation
  • Customize Audio Files
  • Insert a Video in a Slide
  • Use Motion Paths in Animation
  • Transition Between Slides
  • Add Speaker Notes
  • Rehearse Timings
  • Set Up a Slideshow
  • Record Your Slideshow
  • Run a Spell Check
  • Use the Custom Dictionary
  • Translate Content in PowerPoint
  • Save Your Presentation
  • Present Your Slide Show
  • Reduce the File Size of Your Presentation
  • Save a Presentation as a Movie
  • Change Document Properties
  • Combine Two Versions of Your Presentation
  • Password Protect a Presentation
  • Review Using Comments

Microsoft OneNote

Organize all your notes in one place with Microsoft OneNote.

  • Add a New Page
  • Add a New Section
  • Insert and Format a Table in OneNote
  • Reorganize Your Page
  • Create a Page Template
  • Insert and Format Text
  • Insert and Format a Picture
  • Invite Collaborators
  • Attach a File
  • Customize the Page Setup
  • Use the Send to OneNote Tool
  • Dock Your OneNote Windows
  • Drawing Tools
  • Use Tags

Use Excel Formulas in Office for PC 2013

Understand basic formula concepts, then apply commonly used formulas like VLOOKUP, FIND, INDEX, and MATCH.

  • Calculate Values Using Basic Arithmetic
  • Perform Logical Tests with AND and OR
  • Use MIN and MAX
  • Use SUM, SUMIF, and SUMIFS
  • Calculate Averages
  • Count the Instances of a Value
  • Lock the Row and Column of a Cell Reference
  • Vlookup
  • Hlookup
  • Use the IF, AND Functions
  • Use the FIND Function
  • Look Up Values Using INDEX and MATCH
  • Combine Values From Multiple Cells
  • Change an Error Value
  • Name a Cell Range

Advanced Formatting in Word 2013

Learn advanced techniques of formatting text and other content in Microsoft Word 2013 for PC.

  • Add A Table Of Contents
  • Add Bookmarks
  • Add Headers and Footers
  • Add Page Numbers
  • Work with AutoFormat
  • Write Equations with Symbols
  • Insert Footnotes
  • Format Images
  • Crop and Rotate Images
  • Change The Default Styles
  • Change Page Design
  • Use Different Paste Options
  • Insert Special Characters
  • Copy and Paste from the Clipboard
  • Change Paragraph Alignment
  • Choose a Text Style
  • Change the Spacing of Your Text
  • Use Page Breaks and Section Breaks
  • Use the Format Paintbrush
  • Set Indents and Margins with the Ruler
  • Designate Tab Stops
  • Add Watermarks
  • Aligning Pictures and Text Wrapping
  • Show and Hide Format Characters
  • Change a Table's Design
  • Change a Table's Layout
  • Using SmartArt Graphics
  • Using WordArt
  • Using Shapes and Callouts
  • Embed Audio and Video Files
  • Insert Files and Objects into a Document
  • Create a Custom Template
  • Advanced Microsoft Word Shortcuts
  • Organize and Collapse Headers
  • When to Use Bulleted and Numbered Lists
  • How to Use Punctuation in Lists

Automate Tasks in Word 2013

Use advanced features within Microsoft Word to automate repetitive or exacting tasks.

  • Work with Layers
  • Create Form Letters from a Spreadsheet
  • Create and Print Mailing Labels
  • Things You Can Do with Mail Merge
  • Create Speech from Text
  • Sort Lists
  • Translate Using Word
  • Create a Webpage
  • Things You Can Do with Macros

Analyze Data with Pivot Tables in Office for PC 2013

Properly structure your data, create a pivot table, then use your data as rows, columns, values, and filters.

  • Structure Data for a Pivot Table
  • Create a Pivot Table
  • Rows, Columns, and Values
  • Filter a Pivot Table
  • Create a Pivot Chart
  • Insert a Slicer
  • Choosing Functions
  • Group Items
  • Extract Data
  • Insert a Timeline
  • Insert a Calculated Field

Manage Email Accounts from Outlook for PC 2013

Customize your Outlook experience, then filter and categorize your messages

  • Compose a Message
  • Create a New Folder
  • Add Contacts
  • Add a Signature
  • Add Voting Options to a Message
  • Change Your Outlook Layout
  • Search For and Filter Messages
  • Add Categories
  • Filter Messages to a Folder
  • Flag an Outlook Message

Customize How You Work with Word 2013

Customize Microsoft Word for your own personal preferences and improve efficiency.

  • Customize AutoCorrect Options
  • Password Protecting a Word Document
  • Create Custom Shortcuts
  • Things You Can Do to Secure Your Document
  • Enable Add-Ins
  • Things You Can Do with Add-Ins

Collaborate on Documents in Word 2013

Review and collaborate over Microsoft Word 2013 documents efficiently.

  • Share a Document
  • Add Comments
  • Modifying Document Properties
  • Ensure File Compatibility
  • Compare Multiple Documents

Basic Formatting in Word 2013

Learn the basic steps of formatting text and other content in Microsoft Word 2013 for PC.

  • Introduction to Microsoft Word 2013
  • Navigate the Word Interface
  • Get Started with Text
  • Select and Move Text
  • Add a List
  • Add a Link
  • Change Line Spacing
  • Change Page Setup
  • Change Paragraph Indents
  • Format Text
  • Spell Check A Document
  • Find and Replace Text
  • Change Your Document View
  • Insert Images
  • Basic Shortcuts in Microsoft Word
  • Review Your Document Before Sharing

Create Text Documents in Word 2013 for PC

Create a document and add formatted text, then use advanced tools like a table of contents, headers, and equations.

  • Turn on Track Changes
  • Using the Format Painter

Conditional Formatting in Excel for PC 013

Learn to apply cell formatting that depends on a cell's values.

  • Format Cells Using the Quick Analysis Menu
  • Format Using Logic and Cell References
  • Build a Formula in a Corresponding Range
  • Manage Conditional Formatting Rules

Create Tables and Charts in Word 2013

Use tables and charts to present and work with information.

  • Add Tables in Word for PC 2013
  • Convert Tables to Charts

Create and Manage Documents in Word 2013

Create and manage Word documents by being able to save, locate and open existing files.

  • Create a New Blank Document
  • Create A Document From a Template
  • Closing a Document
  • Print Your Document
  • Common Errors to Avoid in Microsoft Word
  • Save Your Document
  • Recover Unsaved Files
  • Create Digital Ready Resumes

What-if Analysis in Excel for PC 2013

Explore how changes to a formula will affect its outcome, as well as work backwards from a formula’s outcome, and change an aspect to arrive at the correct solution.

  • Create a Data Table with One Variable
  • Create a Data Table with Multiple Variables
  • Find the Value That Completes an Equation
  • Compare Data Scenarios

Learn how to use Microsoft Office 2013 for PC

Microsoft Office is a suite of office applications used by over 1 billion users worldwide. Components include the popular Word, Excel, and PowerPoint, along with tools such as Access, Outlook, and OneNote. While the basics of these programs are understood with relative ease, learning the ins and outs will unlock their true potential.

In these lessons, you'll learn how to:

  • Manage Excel Spreadsheets in Office for PC 2013
  • Present with PowerPoint in Office for PC 2013
  • Automate Tasks in Word 2013
  • Use Excel Formulas in Office for PC 2013
  • Microsoft OneNote
  • Analyze Data with Pivot Tables in Office for PC 2013
  • Advanced Formatting in Word 2013
  • Manage Email Accounts from Outlook for PC 2013
  • Collaborate on Documents in Word 2013
  • Basic Formatting in Word 2013
  • Customize How You Work with Word 2013
  • Conditional Formatting in Excel for PC 2013
  • Create and Manage Documents in Word 2013
  • Create Text Documents in Word 2013 for PC
  • Create Tables and Charts in Word 2013
  • What-if Analysis in Excel for PC 2013

Microsoft Office 2013 for PC Training & Development Courses

Grovo gives you the content, technology, and service you need to get your team up to speed on Microsoft Office. Our learning ecosystem will help you develop your team's office skills within your organization. Watch, learn, and test your team’s knowledge with Grovo to make the best of your Microsoft Office training.

Advanced Analytics & Reporting
Our integrated reporting system will ensure your team is constantly developing the essential skills necessary to perform within Microsoft Office. Training through quick 1-minute videos ensures that the individuals on your team are consisently developing their skillsets. Our reporting system provides:

  • A flexible reporting interface
  • Overview of your team's performance
  • Report cards and detailed spreadsheet reports
  • Customizable email reports

More learning. Less management.

Grovo makes it easy to create, deliver, and measure training learners love.

Learn about the Grovo Platform

Ready to inspire your organization with better learning?

Simply fill out the form and a learning consultant will be in touch right away.