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

Play

Microsoft Office serves as a foundation software suite for many teams. Getting your team proficient with Office is key to productivity. All of your Microsoft Office 2010 questions answered, in one-minute videos.

Course details

96 Lessons, 96 Quizzes

Tags: Advanced Organization, Collaborate and Manage Projects, Make and Share Presentations, Send and Store Files

Use Excel Formulas in Office for PC 2010

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 SUM, SUMIF, and SUMIFS
  • Use MIN and MAX
  • Count the Instances of a Value
  • Vlookup
  • Hlookup
  • Using the IF and AND Functions
  • Use the FIND Function
  • Look Up Values Using INDEX and MATCH
  • Combine Values from Multiple Cells
  • Calculate Present Value with the PV Function
  • Use the FV Function
  • Use the PMT Function

Analyze Data with Pivot Tables

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

Conditional Formatting in Excel 2010 for PC

Use conditional formatting to organize your Excel spreadsheets.

  • Format Using Logic and Cell References
  • Build a Formula in a Corresponding Range
  • Manage Conditional Formatting Rules

Present with PowerPoint in Office for C 2010

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

  • Create Slides
  • Organize Slides
  • Add Text Boxes
  • Add Shapes
  • Draw Lines
  • Insert Images in a Presentation
  • Arrange Objects
  • Align Objects
  • Add a Table
  • Change a Table's Design
  • Change a Table's Layout
  • Insert a Table From a Spreadsheet
  • Transition Between Slides
  • Animate Objects
  • Set Up a Slideshow
  • Rehearse Timings
  • Record Your Slideshow
  • Add Speaker Notes
  • Create a Presentation

Create Text Documents in Word 2010

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

  • Create A New Document
  • Add a List to a Document
  • Add a Table of Contents
  • Add Bookmarks
  • Add Headers and Footers to a Document
  • Add Page Numbers
  • Add Tables
  • Change a Table's Design
  • Change a Table's Layout
  • Change Line Spacing
  • Change Page Setup
  • Change Paragraph Indents
  • Change The Default Styles
  • Change Page Design
  • Format Text
  • Insert Footnotes
  • Insert Images
  • Format Images
  • Crop and Rotate Images
  • Spell Check A Document
  • Turn on Track Changes
  • Review and Accept Changes
  • Share a Document
  • Add a Link
  • Paste Special
  • Save Your Document
  • Copy and Paste from the Clipboard
  • Change Your Document View

Manage Excel Spreadsheets in Office for PC 2010

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

  • Move and Edit Cells
  • Format a Cell's Text
  • Format Numerical Data
  • Change Cell Alignment
  • Add Cell Borders and Colors
  • Adjust Row Height and Column Width
  • Add and Manage Additional Sheets
  • Use the Format Paintbrush
  • Merge Cells
  • Use Auto Fill
  • Find and Replace Items
  • Create a Chart or Graph
  • Filter and Sort Tables
  • Lock Rows and Columns
  • Add Headers, Footers, and Page Numbers
  • Adjust Page Margins and Orientation
  • Show or Hide Print Titles and Gridlines
  • Insert Sparklines
  • Customize Sparklines

What-if Analysis in Excel for PC 2010

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 2010 for PC

Microsoft Office 2010 is a suite of software tools that greatly improve the average knowledge worker's productivity. Microsoft Office 2010 includes tools like Word, Excel, and Outlook. Learning how to use these common tools effectively will have a profound effect on your teams productivity.

In these lessons, you'll learn how to:

  • Use Excel Formulas in Office for PC 2010
  • Analyze Data with Pivot Tables
  • Conditional Formatting in Excel 2010 for PC
  • Manage Excel Spreadsheets in Office for PC 2010
  • Present with PowerPoint in Office for PC 2010
  • Create Text Documents in Word 2010
  • What-if Analysis in Excel for PC 2010

Microsoft Office 2010 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 2010. Our learning ecosystem will help you develop your team’s Microsoft Office 2010 skills and advance within your organization as a team leader. Watch, learn, and test your team’s knowledge with Grovo to make the best of your Microsoft Office 2010 training.

Advanced Analytics & Reporting
Our integrated reporting system will ensure your team is constantly developing the essential skills necessary to perform within the Microsoft Office 2010 platform. Microsoft Office 2010 training through quick 1-minute videos ensures that the individuals on your team are developing into efficient digital workers. 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.