Apply shading to alternate rows or columns in a worksheet
One way to apply shading to alternate rows or columns in your worksheet is by creating a conditional formatting rule. This rule uses a formula to determine whether a row is even or odd numbered, and then applies the shading accordingly. The formula is shown here:
LOOKUP function - Microsoft Support
Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, let's say you know the part number for an auto part, but you don't know the price.
Use sparklines to show data trends - Microsoft Support
Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Position a sparkline near its data for greatest impact. Select a blank cell at the end of a row of data. Select Insert and pick Sparkline type, like Line, or Column.
Analyze trends in data using sparklines - Microsoft Support
Sparklines are tiny charts inside single worksheet cells that can be used to visually represent and show a trend in your data. Sparklines can draw attention to important items such as seasonal changes or economic cycles and highlight the maximum and minimum values in a different color.
Look up values in a list of data - Microsoft Support
There are several ways to look up values in a list of data and to display the results. What do you want to do? To do this task, you can use the VLOOKUP function, or a combination of the INDEX and MATCH functions. For more information, see VLOOKUP function. In simple English it means:
Add a trend or moving average line to a chart - Microsoft Support
Learn how to add a trendline in Excel, PowerPoint, and Outlook to display visual data trends. Format a trend or moving average line to a chart.
Insert data from picture - Microsoft Support
Want to turn images that have table data into data that you can edit in Excel? With the Data from Picture feature, it's a snap. With the Data from Picture feature, you can insert data from a screen capture on your clipboard, or an image file from your computer.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
Change the column width or row height in Excel - Microsoft …
You can manually adjust the column width or row height or automatically resize columns and rows to fit the data.
Manage your household budget in Excel - Microsoft Support
Using a budgeting spreadsheet can help make your financial health a priority by keeping spending in check and savings on the rise! DIY with the Personal budget template. Prefer to do things yourself? This Excel template can help you track your monthly budget by income and expenses.
Keyboard shortcuts in Microsoft 365 - Microsoft Support
Many users find that using Microsoft 365 apps with keyboard shortcuts on an external keyboard helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.