Target Audience: This workshop has 3 different levels – beginning, intermediate, and advanced – and is for the whole community.
Duration: All levels – beginning, intermediate and advanced – have a total duration of 12 Hours divided into 3 Sessions of 4 Hours – Saturday from 9am – 1pm.
When: dates to be announced soon.
How do you create, edit and manage spreadsheets for research, management, finance, accounting or administration? The possibilities for applying the basic, intermediate, and advanced functions of Microsoft Excel are literally endless. In this workshop we will learn how to use this versatile tool to create and manage professional-quality spreadsheets.
Come to Change Makers to find out how it works!
Why this topic?
Microsoft Excel is one of the most complete and versatile calculation tools used professionally and in an educational context.
The general objective of this set of workshops is to provide participants with knowledge and practices in spreadsheet operation, and optimization and automation of its use in the entire range of Microsoft Excel resources, particularly in terms of data management tools and other intermediate and advanced functions.
Entry Level:
- The Excel workspace.
- Creating and editing spreadsheet books.
- Using spreadsheets.
- Apply basic formatting tools.
- Using custom lists.
- Graphically formatting cells.
- Identifying calculation operators.
- Building a calculation expression.
- Printing and page setup.
- Configure work environment.
Intermediate level:
- Use the spreadsheet and perform graphing and formulae.
- Present flexible solutions as to how to manage a job to be done.
- Use commands that apply to operations that handle specific types of data.
- Use pre-defined functions to perform tasks on data sets.
- Create dashboards.
Advanced Level:
- Identify all the calculation capabilities leveraged by the use of functions, using data contained in various worksheets.
- Perform data simulation and pivot tables.
- Perform scenario analysis, using the capabilities made available by Excel.
- Create reports from the information contained in the worksheets.
- Use the ability to automate routine tasks.
- Organize and manage data lists.
If you are curious to learn the more “technical” terms and get a deeper look into the topics to be covered in the workshop: