Google Sheets for Accountants


CPE Credit: 2 hours

This course provides a concise overview of Google Sheets, a cloud-based spreadsheet 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, Google integration, and third-party add-ons. Discover a whole new array of spreadsheet features you won’t find in Excel that can accelerate your financial workflow and boost your number-crunching powers.

Topics Covered

• Different Sheets apps: web, offline & more
• Compatibility with Excel
• How to create, edit and format
• Work with sheets, rows and columns
• Publish and embed your spreadsheet
• Functions and formulas
• Create and edit charts
• Tools
• Spreadsheets settings, views & printing
• Work with data
• Add-ons
• Forms

Learning Objectives:

• Explore the key capabilities and user interface of Google Sheets
• Highlight spreadsheet features unique to Sheets which are not available in Excel
• Create, edit and manage numbers, text, data and formulas using Sheets