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