Using Microsoft Excel and Google Sheet for Reporting
Friday, September 23, 2022
11:20 AM - 12:20 PM
Speakers
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