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

Play

Pivot tables, animations, file types, oh my! All of your Microsoft Office 2007 for PC questions answered, in one-minute videos.

Course details

87 Lessons, 87 Quizzes

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

Excel Formulas for PC 2007

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

  • 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 Values Using Basic Arithmetic
  • Perform Logical Tests with AND and OR
  • Use MIN and MAX
  • Count the Instances of a Value
  • Use SUM, SUMIF, and SUMIFS
  • Calculate Averages
  • Lock the Row and Column of a Cell Reference
  • Change an Error Value
  • Name a Cell Range

Format Worksheets in Excel 2007 for PC

Create spreadsheets, use basic formulas, and view revisions.

  • Move and Edit Cells
  • Add Headers, Footers, and Page Numbers
  • Adjust Page Margins and Orientation
  • Show or Hide Print Titles and Gridlines
  • Format Text Appearance
  • Merge Cells
  • Format Numbers
  • Add Borders to Cells
  • Use the Format Paintbrush
  • Resize Columns and Rows
  • Add or Remove Columns and Rows
  • Lock Rows and Columns
  • Create a Chart or Graph
  • Find and Replace Items
  • Add and Manage Additional Sheets
  • Use Auto Fill
  • Filter Data

Present with PowerPoint in Office for PC 2007

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

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

Create Documents on Microsoft Word for PC 2007

Create, edit and share documents on Microsoft Word for PC 2007.

  • Create A New Document
  • Add A Table Of Contents
  • Add a Bookmark
  • Add Headers and Footers to a Document
  • Add Page Numbers
  • Add Tables
  • Change a Table's Design
  • Change a Table's Layout
  • Add a List
  • Change Line Spacing
  • Change Page Setup
  • Change Paragraph Indents
  • Change the Default Styles
  • Change Page Design
  • Format Text
  • Insert Footnotes
  • Insert Images
  • Format Images
  • Spell Check a Document
  • Turn on Track Changes
  • Review and Accept Changes
  • Customize the Quick Access Toolbar
  • Add a Link
  • Paste Special
  • Change Your Document View

Analyze Data with Pivot Tables in ffice for PC 2007

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
  • Choosing Functions
  • Group Items
  • Extract Data
  • Insert a Calculated Field

What-if Analysis in Excel for PC 2007

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

Microsoft Office is a set of desktop applications that businesses use to create documents, presentations, data analysis, and more. The most commonly used programs are Word, PowerPoint, and Excel. Although there are many versions of Microsoft Office, these lessons focus specifically on Microsoft Office 2007 for PCs.

In these lessons, you'll learn more on:

  • Excel Formulas for PC 2007
  • Format Worksheets in Excel 2007 for PC
  • Present with PowerPoint in Office for PC 2007
  • Create Documents on Microsoft Word for PC 2007
  • Analyze Data with Pivot Tables in Office for PC 2007
  • What-if Analysis in Excel for PC 2007

Microsoft Office 2007 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 2007 for PC. Our learning ecosystem will help you develop your team's Microsoft Office 2007 for PC skills and advance within your organization through advanced Office suite knowledge. Watch, learn, and test your team’s knowledge with Grovo to make the best of your Microsoft Office 2007 for PC training.

Advanced Analytics & Reporting
Our integrated reporting system will ensure your team is constantly developing the essential skills necessary to perform within Microsoft Office 2007 for PC. Microsoft Office 2007 for PC training, through quick 1-minute videos, ensures that individuals on your team are consistently developing their skillset. 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.