Google Sheets: Advanced Formulas and Functions
Google Sheets: Advanced Formulas and Functions
MP4 | Video: 720p | Duration: 3:11:43 | English | Subtitles: VTT | 366.3 MB
MP4 | Video: 720p | Duration: 3:11:43 | English | Subtitles: VTT | 366.3 MB
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.
Topics include:
- Entering formulas
- Creating, editing, and deleting named ranges
- Using mathematical functions such as SUM and AVERAGE
- Summarizing data
- Analyzing financial data
- Working with dates and times
- Looking up values
- Multiplying arrays