120 PCWorld APRIL 2020HERE’S HOW
IMAGE: MICROSOFTE
xcel has over 475 formulas in
its Functions Library, from
simple mathematics to very
complex statistical, logical,
and engineering tasks such as IF
statements (go.pcworld.com/ifst, one of
our perennial favorite stories); AND, OR,
NOT functions; and COUNT, AVERAGE, and
MIN/MAX.
The basic functions covered below
are among the most popular formulas in
Excel—the ones everyone should know.
To help you learn, we’ve also provided aspreadsheet with all the formula examples
we cover here (go.pcworld.com/xlfm).- TODAY/NOW
There are 24 Date and Time functions listed
on the drop-down menu under Formulas >
Date & Time: 11 Date formats, 10 Time
formats, and as many user-defined custom
formats you can create. The TODAY function
reveals the current month, day, and year;
while the NOW function reveals the current
month, day, year, and time of day. This is a
handy function if you’re one of those
Excel formulas: The most popular
functions and tools
Make sure these date and time functions, math tricks, and data manipulation tools
are all at your disposal. BY JD SARTAIN