This is a hands-on workshop for administrators, teachers or anyone who uses Excel or Google Sheets. In addition to basic functions, participants will be exposed to best practices in data management that can streamline processes and reduce errors. Unlike other technical trainings, this workshop is scenario-based, in which participants use the focus skills to accomplish common tasks found in an educational/administrative setting (e.g. creating a reusable report with graphs). By working through these scenarios, participants will work through common pitfalls and their solutions.
In this session we will be focusing on the following tools in Excel, along with best practices in data management:
- Data entry and organization
- VLookup (revisited)
- Pivot Tables
- Index-match
- Graphs (basic)
***For the best experience in this workshop, please have access to Microsoft Excel.***
Ms. Samn has extensive experience with Microsoft Excel, and brings in her experience as a SQL database designer and software developer to create easy-to-use, interactive, and versatile forms in Excel that minimize human error and maximize efficiency.