Using Microsoft Excel and Google Sheet for Reporting

Friday, September 23, 2022

11:20 AM - 12:20 PM

Description

There will be half hour devoted to doing reports in Excel and another doing reports in Google sheets.

Brief overview of the similarities and differences in the two programs:

  • In both programs: utilizing pivot table and functions to create better reports and better interactive reports.
  • Excel: How to link reports together by using queries & connection and merging multiple reports. Reviewing new functions in excel (example Xlookup)
  • Google Sheets: How to link reports together by using queries and importing another google sheet from a different workbook.
Track
Managing Bookkeeping
CE
1.0 CPD unit
Location Name
Plaza 4
Virtual Access
Live-streamed