This interactive course focuses on the fundamentals of Microsoft Excel. Following along with the instructor, students will use The Center's laptops to explore the capabilities of Excel. Example datasets, along with hands-on data collection, are used to generate data. A final exercise challenges the participant to demonstrate what they learned by creating a control chart template they can utilize at their organization for process improvement.
Learning Outcomes
Upon course completion, student should be able to:
- Open, import and create Microsoft Excel workbooks
- Navigate a worksheet efficiently using keyboard shortcuts
- Create, manipulate and format tables to complete work tasks
- Utilize formulas and functions to perform calculations
- Embed sparklines in a worksheet cell to dynamically see trends
- Apply conditional formatting to explore patterns in your data