Public Workshop: Intermediate Excel
Not currently scheduled
Description:
If you have the ABC’s of Excel down, & would like to boost your productivity at work, the MDC’s Intermediate Excel is the perfect class for you. In the Intermediate session, we will take an in-depth look at sorting & filtering data. Next, participants will learn how format their Excel programs to include the Descriptive Statistics Analysis ToolPak, and how to read the output. What-If Statements, logical statements, and data validation will be reviewed, ultimately helping you streamline your tasks & improving your data management. Finally, participants will get a chance to experiment with PivotTables and PivotCharts. You’ll get a chance to play with Excel towards the end of the class & ask the facilitator one-on-one questions to help you solve some of your pressing data management problems.
Learning Outcomes
- Create What-If Statements
- Use logical statements
- Sort and filter data
- Review data validation
- Create PivotTables and PivotCharts