Google Sheets for Accountants

Overview

This course provides a concise overview of Google Sheets, a cloud-based spreadsheet application by Google. Similar to Excel, the tool allows users to enter numbers, apply formulas, prepare graphs, create charts, use pivot tables and more. While Excel is the default tool and industry standard for most accountants, Sheets has many underrated capabilities which are clearly superior to Excel. These include online collaboration, team communications, mobility, version control, revision history, cloud storage, translation, Google integration, and scores of third-party add-ons. You'll walk away knowing how to use a whole new array of spreadsheet features not found in Excel that can boost your analytical powers and accelerate your financial workflow. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Prerequisites

None

Objectives

After attending this presentation you will be able to...

• Identify the key capabilities and user interface of Google Sheets
• Create, edit and format presentations using Google Sheets
• Recognize features unique to Google Sheets that are not available in Microsoft Excel
• Add plug-ins that extend the power of Google Sheets
• Use Google Slides in tandem with Microsoft Excel

Highlights

The major topics that will be covered in this class include:

• What is Google Sheets?
• Key Set Up Steps and Apps
• Key Strengths and Weaknesses
• Google Sheets vs. Microsoft Excel
• Google Sheets Versions
• Quick Start Guide
• Things You Can do in Google Sheets that You Can't Do in Excel
• Google Sheets Add-Ons
• Google Sheets Help Resources