Intro to Excel
If you are new to Excel, this workshop is the perfect place to start increasing your confidence & familiarity with the program. Intro to Excel will include exploring basic navigation – you will take a tour through tabs, ribbons, and menus. Next, we will tackle building a worksheet from scratch, which includes learning about merging, freezing, and adding rows/columns. The workshop will also include introductory information about the difference between formulas and functions, knowing where to find them, and how to effectively use both. Finally, we will end the morning by delving into a few handy keyboard shortcuts, and learning about charts, graphs, fonts, borders, shading, and other customizable features.
Intermediate Excel
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.
Please bring your own PC laptop (Mac, tablet, and phone are not recommended)
LUNCH IS NOT PROVIDED
Invoices will be sent to email within 48 hours! No refunds!