Medical Spreadsheet Applications
Description
Dive deeper into the world of spreadsheet proficiency with our advanced Excel course, the second installment in our series. This program builds upon foundational knowledge from the introductory course COMP 1100, focusing on practical skills to navigate complex data challenges efficiently. Through a combination of independent study and collaborative group work, participants will develop a comprehensive understanding of advanced spreadsheet design principles and practical applications. Throughout the course, students will explore 3-D referencing, enabling seamless manipulation of data across multiple sheets. They will also learn about security features for linked sheets, ensuring data integrity and confidentiality. Moreover, participants will master creating hyperlinks within workbooks and to files and websites, enhancing navigation and collaboration. Named ranges will be used to organize and manage data effectively, while advanced sorting and filtering skills facilitate insightful extraction from large datasets. As the course progresses, students will delve into data visualization, creating interactive dashboards for clear information presentation. Functions like SUBTOTAL and outline levels will streamline calculations and enhance data representation. Furthermore, participants will unlock Excel's analytical capabilities, mastering PivotTables, PivotCharts, and advanced analysis techniques. From single-variable to two-variable data tables, and from scenario analysis to Solver models, students will gain proficiency in tackling real-world analytical challenges. In essence, our advanced spreadsheet building course equips participants with practical skills to excel in today's data-driven environment. Graduates emerge as proficient Excel practitioners, ready to tackle complex data tasks with confidence.
Related Programs
Overview

- Institution: Fanshawe College
- Level: College
- Language: English
- Course Code: COMP5047
- Delivery Method: Fully Online/Distance
Disclaimer:
Check with the institution regarding start/end dates, prices, and delivery method. These may vary according to program, section, and/or semester.
Check with the institution regarding start/end dates, prices, and delivery method. These may vary according to program, section, and/or semester.