Data Literacy

Microsoft Excel is the preferred spreadsheet software for many individuals and businesses to manage their data and reporting. Yet most are only using 20% of the features of this powerful productivity tool. In this one-day workshop, you will learn the basics of creating, modifying, formatting and printing worksheets. You will learn to use basic formulas and functions and manage large workbooks to analyze and understand data.

During this intermediate one-day Excel program you will learn and practice higher level Excel functionality to further made sense of spreadsheets and larger data sets. By using hands-on practical techniques you will be able to analyze complex data sets, organize and visualize data in simple meaningful terms, faster data list management and querying and working with corporate and professional templates.

This advanced level, one-day course is intended to help everyday users of Excel present their data in more effective ways using PivotTables and PivotCharts. Users will also learn advanced analysis tools like the Scenario Manager, Goal Seek, Data Tables, and advanced functions. Basic macros will also be covered in this course.

Public programs and initiatives are under constant pressure to show clear evidence of results. This workshop equips participants with practical tools to connect objectives to measurable outcomes. Through hands-on exercises, you will learn how to design logic models, identify performance indicators, and build evaluation frameworks that withstand the scrutiny of decision-makers, funders, and oversight bodies. The focus is on applying proven methods in real-world contexts so you leave with skills you can immediately use in planning, reporting, and accountability.

This two-day workshop will provide you with an overview of how to understand financial information without requiring an in-depth knowledge of math, bookkeeping, or accounting practices. In addition to providing the basics of financial statements, you will also learn how financial information can support financial management objectives and decision-making. You will receive practical tips on how to analyze reports and data to identify key elements to provide a clearer picture of your business to highlight your financial position and identify financial areas requiring your attention. You will gain insight to better evaluate the information you are receiving from your financial data.

This two-day workshop is designed to provide you with tools, templates and a lexicon for developing and implementing a performance measurement framework that is used to support planning, priority setting and investment decisions. Through robust and useful results framework and performance information profiles, you’ll learn techniques for supporting the Government’s Results and Delivery Agenda.

This two-day course will help you understand how to identify and work with database components; open tables to locate, edit and enter data; create and customize tables; use input masks and data validation techniques; create table relationships ensuring data integrity; create and customize table forms; work with queries to extract, edit and perform calculations with table data; create and customize reports; import and export data into tables and preview and print data objects.