## Excel Online Cheat Sheet

Excel Online Cheat Sheet - A Quick Guide To Excel's Web Version In this post, we cover Excel Online's main features. Looking for excel shortcuts? See our Excel Shortcuts Page! …

Skip to content
## Practice And Learn Excel Online For Free

##
Excel Online Cheat Sheet

##
Excel Mortgage Calculator

##
PPMT & IPMT

##
PMT

##
LET

##
SEQUENCE

##
RANDARRAY

##
FILTER Function

##
SORTBY

##
SORT Function

Excel Online Cheat Sheet - A Quick Guide To Excel's Web Version In this post, we cover Excel Online's main features. Looking for excel shortcuts? See our Excel Shortcuts Page! …

0 Comments

July 30, 2022

Below is a mortgage calculator which can be used to calculate the monthly payment, and see the payment schedule based on the data provided. Once the results are generated based…

January 12, 2020

Function Explained PPMT and IPMT are both financial functions that can help us find the Principal and Interest amount of a certain payment. PPMT function helps to calculate the Principal…

January 12, 2020

Function Explained PMT function is used to calculate the amount to be paid in each period on a loan or other financial instrument, such as bonds. Syntax =PMT(rate,nper,pv,[fv],[type]) rate -…

January 12, 2020

LET Function Explained LET function allows us to create names within a function, and assign values and calculations to these names so that they can be later re-used in the…

January 10, 2020

SEQUENCE Function Explained SEQUENCE function creates an array of sequential values. It is part of the Excel Dynamic Array Formulas. This is a group of formulas which allows the user…

January 10, 2020

Explanation RANDARRAY is a function that generates an array of random numbers. It is part of the Excel Dynamic Array Formulas. This is a group of formulas which allows the…

January 10, 2020

FILTER Function Explained FILTER returns a filtered list of values from a range that meet a certain criteria. It is part of the Excel Dynamic Array Formulas. This is a…

January 1, 2020

SORTBY Function Explained SORTBY function is used for dynamically sorting excel ranges by the values of other ranges. It is part of the Excel Dynamic Array Formulas. This is a…

December 28, 2019

SORT Function Explanation Sort function allows the user to dynamically sort ranges. It is part of the Excel Dynamic Array Formulas. This is a group of formulas which allows the…

December 24, 2019