Introduction to Spreadsheets and Understanding Data

Catalog description

This course provides students with a flexible learning experience that transcends specific versions of Office, remaining relevant across platforms like Office 365, Microsoft 365, Office 2021, or Office Online. The course covers essential skills for data management in organizations. One crucial aspect covered in the course is using Excel worksheets to easily summarize and visualize data. Students learn how to create a worksheet with charts that represent data effectively. Specifically, they work with a budget that includes monthly estimates for income and expenses. Formulas and functions are taught to help students create dynamic worksheets. The course also explores various topics such as using option buttons, verifying formulas, applying themes, formatting numbers and text, utilizing conditional formatting, adjusting column widths and row heights, spell checking, alternative worksheet displays and printouts, and adding page headers and footers. Additionally, students are introduced to powerful features of Excel, including its extensive function library and the ability to answer what-if questions. They learn to work with multiple worksheets and workbooks, explore advanced formatting options for pie charts, such as exploding slices and leader lines. Importing data, sorting and querying tables, creating templates, and analyzing and interpreting data are also covered. Overall, this course equips students with a range of techniques to enhance their ability to create effective worksheets, draw meaningful charts, and leverage Excel's capabilities for data analysis and interpretation.