Google Sheets for Accountants

  Product ID : GAWA-0001

  Level : Intermediate

  Duration : 100 Minutes

Garrett Wasny, MA, CMC, CITP/FIBP is an award-winning Internet search advisor, author and presenter based in Vancouver, British Columbia, Canada and former Price Waterhouse management consultant. Garrett’s academic credentials include a Bachelor of Arts with Honours (BA Hons) degree and a Master of Arts (MA) degree. His professional accreditations include Certified Management Consultant (CMC), Certified International Trade Professional (CITP) and FITP (FITT International Business Professional).  

Garrett has written four books, dozens of e-books and hundreds of articles on Internet strategy and tactics for leading publishers, business clients and Continuing Professional Education (CPE) organizations. His books include World Business (McGraw Hill, New York), How to Conquer the World (Government Institutes, Washington, DC) and Advanced Googling (Google Books, Mountain View, California). His e-books include Advanced Googling for Accountants Parts I, II and III, Google Apps for Accountants, Google Business Tools for Accountants, Google Big Data and Forecasting Tools for Accountants, and Google is Not Enough for Accountants. He’s also published hundreds of articles on Internet topics in scores of leading business publications and newspapers across North America.

Over two decades, Garrett has delivered thousands of presentations on advanced Googling and Internet strategy to hundreds of leading accounting institutes, industry associations, Fortune 500 companies, small and medium-sized enterprises, business schools and other legal, medical, engineering, pro sports and executive education organizations worldwide. Garrett’s search courses are approved and accredited by NASBA (National Association of State Boards of Accountancy), the Chartered Professional Accountants of Canada (CPA Canada) and other respected governing bodies which regulate continuing professional education in the North American accounting profession and business world.

Garrett has won numerous awards for his writing, speaking and web design. These include two Price Waterhouse national writing prizes, an Internet World New York public speaking award, and Study Web and ExpoWorld commendations for excellence in developing global trade content for the Internet. Full disclosure: Garrett Wasny is an independent, agenda-free technology advisor who provides objective and non-commercial information and is not affiliated with Google Inc. He receives no commission or compensation of any kind from the entities and companies he reviews in his seminars, webinars and consulting assignments.

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.

Learning Objectives

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

Who Should Attend

Practitioners who want to explore Sheets as an Excel alternative or complementary tool rich in collaboration, mobile and knowledge features.

Topic Background

  • Sheets apps for web, mobile and offline
  • Excel compatibility
  • 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 and printing
  • Work with data
  • Add-ons
  • Templates
  • Forms
  • $200.00

Recorded / Download Access