Many beginning and intermediate Google Sheets users are familiar with basic functions and formulas, but have no experience with the more advanced calculations the program offers. In this course, Curt Frye walks through the intermediate and advanced functions for summarizing data, performing statistics, analyzing financial data, and more. Learn how to use references and named ranges; apply mathematical functions to multiply, round, and count values; identify outliers and rank values; calculate investments and loan payments; determine dates and times; look up values based on multiple criteria; and summarize arrays of data.
Learn More- Career Pathways
- What is Career Pathways?
- Architecture, Manufacturing , Natural Resources and Agriculture
- Arts, Communications, Media and Marketing
- Business, Public Service and Tourism
- Healthcare and Health Sciences
- Human Services, Consulting and Education
- Artificial Intelligence
- Science, Technology, Engineering and Mathematics
- Student Populations
- Gain Experience
- Build Career Skills
- Professional Documents
- Services & Resources