From the Grovo Library Learn How To Use Microsoft

Play

Online tools that get work done: all of your Microsoft Office questions answered, in one-minute videos.

Course details

18 Lessons, 17 Quizzes

Tags: Advanced Organization, Collaborate and Manage Projects, Make and Share Presentations, Work & Productivity

Use Excel Formulas in Office for PC 2010

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

  • Introduction to Excel Formulas
  • 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

Analyze Data with Pivot Tables

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

  • Introduction to Pivot Tables
  • Structure Data for a Pivot Table
  • Create a Pivot Table
  • Rows, Columns, and Values
  • Filter a Pivot Table

Learn how to use Microsoft Office

Microsoft Office is a suite of applications, servers, and services that aim to increase individual and group productivity in a working environment. Learn how to use Excel, Word, PowerPoint and more applications that will increase productivity, communication and functionality in the workplace. Master functionality and increase efficiency.

In these lessons, you'll learn how to:

  • Use Excel Formulas in Office for PC 2010
  • Analyze Data with Pivot Tables
  • Manage Excel Spreadsheets
  • Excel Formulas for PC 2007
  • Manage Excel Spreadsheets in Office for PC 2010
  • Analyze Data with Pivot Tables in Office for PC 2013
  • Format Worksheets in Excel 2007 for PC
  • Excel Formulas for Office 365
  • Present with PowerPoint in Office for PC 2010
  • Use Excel Formulas in Office for PC 2013
  • Create Text Documents in Word 2010
  • Create Text Documents in Word for Mac 2011
  • Calculate Formulas in Excel for Mac 2011
  • Manage Email Accounts from Outlook for PC 2013
  • Manage Excel Spreadsheets in Office for Mac 2011
  • Create Office 365 Documents
  • and more....

Microsoft Office Training & Development Courses

Grovo gives you the content, technology, and service you need to get your team up to speed with Microsoft Office. Our learning ecosystem will help you develop your team's Microsoft skills and advance within your organization as a productive document manager. 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 create and present documents online. Training through quick 1-minute videos ensures that the individuals on your team are developing into efficient project collaborators. 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.