Course Outline
Introduction to Excel and Google Sheets
- Overview of spreadsheet tools and their role in various sectors, including for government
- Key differences and similarities between Excel and Google Sheets
- Setting up and navigating the workspace in both tools
Data Management and Organization
- Structuring and organizing data effectively to support public sector workflows
- Managing large datasets with tables and ranges to enhance governance and accountability
- Using filters, sorting, and conditional formatting for efficient data analysis
Advanced Formulas and Functions
- Essential formulas for business applications within government settings
- Advanced functions like VLOOKUP, INDEX-MATCH, and array formulas to streamline operations
- Customizing formulas for industry-specific use cases, including those relevant to public sector organizations
Data Visualization and Reporting
- Creating dynamic charts and graphs to enhance data presentation
- Generating automated dashboards to monitor key performance indicators
- Best practices for presenting data visually to support decision-making processes in government agencies
Collaboration and Integration
- Sharing and co-editing in Google Sheets to facilitate teamwork and collaboration within government offices
- Linking and importing data between Excel and Google Sheets to ensure data consistency across departments
- Integrating spreadsheet tools with third-party software to enhance operational efficiency for government projects
Templates and Automation
- Building reusable templates for reporting and tracking to standardize processes within government agencies
- Automating repetitive tasks using macros (Excel only) to save time and reduce errors
- Ensuring consistency and efficiency in shared templates to support seamless collaboration and accountability
Summary and Next Steps
Requirements
- Basic understanding of spreadsheet concepts
- Familiarity with data entry and simple calculations
Audience for Government
- Business professionals in the public sector
- Data analysts supporting government operations
- Administrative staff within government agencies
- Project managers overseeing government initiatives
- Any government employee seeking to enhance their spreadsheet skills
Testimonials (5)
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
I was recently struggling with some pivot table issues and the course gave me the knowledge to work with pivot tables quicker, smarter and more efficiently.
Arina Moayed-Dzenisa - Universal-Investment-Gesellschaft mbH Branch Poland Sp. z o. o.
Course - Microsoft Office Excel - poziom średnio zaawansowany
The tips for many of the functions that the trainer presented, which we can easily remember and implement in our future work
Emilija Stoilova - EPFL HBP PCO
Course - Analysing Financial Data in Excel
The fact he had dif excel and data sheets with exercises for us to do.
Deepakie Singh Sodhi - Queens College, CUNY
Course - Excel For Statistical Data Analysis
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.
