There are two other methods to use the FACT function. Method one is to click the fx button on the top left of the Excel worksheet. An Insert Function dialog box will appear.

In this article, I’ll show you how to include AND and OR operations in Excel’s FILTER () function. In several spots, you’ll read “AND and OR,” which is grammatically awkward.

Excel also has some more advanced volatile functions, such as OFFSET and INDIRECT. To use these, head to Excel, click the " fx " icon next to the formula bar, and use Excel's Insert Function guide ...

2. SUM functions Probably the most frequently used function in Excel (or any other spreadsheet program), =SUM does just that: It sums a column, row, or range of numbers—but it doesn’t just sum.

Using Excel as a scheduling tool is a great skill to have under your belt. Learn how to use SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions.