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.
Creating, editing, and deleting named ranges
Using mathematical functions such as SUM and AVERAGE
Analyzing financial data
Working with dates and times
Looking up values
SALE PAGE | Price: $150
Google Sheets: Advanced Formulas and Functions: Videos, PDFs | Size: 298 MB