Google Sheets: Advanced Formulas and Functions

Jan 4, 2018
SEO Courses & Tool
0 0

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

SALE PAGE | Price: $150

Google Sheets: Advanced Formulas and Functions: Videos, PDFs | Size: 298 MB

SIGN UP

Leave a Comment