Using IF with AND, OR, and NOT functions in Excel
WEBIn Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
Filter by using advanced criteria - Microsoft Support
WEBFilter by using advanced criteria. If the data you want to filter requires complex criteria (such as Type = "Produce" OR Salesperson = "Davolio"), you can use the Advanced Filter dialog box. To open the Advanced Filter dialog box, click Data > Advanced.
Find or replace text and numbers on a worksheet
WEBUse the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else.
Excel functions (by category) - Microsoft Support
WEBWorksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
Change the scale of the vertical (value) axis in a chart
WEBBy default, Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to better meet your needs.
Customize the list of recently used files in Office apps
WEBMicrosoft Office programs display the last few documents you opened in that program so that you can use those links to quickly access the files. This feature is turned on by default, but you can turn it off, turn it back on, clear, or adjust the number of files that it displays.
Date and time functions (reference) - Microsoft Support
WEBUse date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
Manage your household budget in Excel - Microsoft Support
WEBThis Excel template can help you track your monthly budget by income and expenses. Input your costs and income, and any difference is calculated automatically so you can avoid shortfalls or make plans for any projected surpluses. Compare projected costs with actual costs to hone your budgeting skills over time.
Automatically number rows - Microsoft Support
WEBUse the ROW function to number rows. In the first cell of the range that you want to number, type =ROW (A1). The ROW function returns the number of the row that you reference. For example, =ROW (A1) returns the number 1. Drag the …
Excel calendar templates - Microsoft Support
WEBBrowse through the calendar templates, choose an Excel calendar template that is best for you. Click the Download button on the template page, open the template file in Excel, and then edit and save your calendar.
Copy and paste using the Office Clipboard - Microsoft Support
WEBThe Office Clipboard allows you to copy up to 24 items from Office documents or other programs and paste them into another Office document. For example, you can copy text from an email message, data from a workbook or datasheet, and a graphic from a presentation, and then paste them all into a document. By using the Office Clipboard, …