LET function - Microsoft Support
Similar to variables in programming, LET is accomplished through Excel's native formula syntax. To use the LET function in Excel, you define pairs of names and associated values, and a calculation that …
Excel help & learning - support.microsoft.com
Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Create a simple formula in Excel - Microsoft Support
Press Enter (Windows) or Return (Mac). Let's look at another variation of a simple formula. Type =5+2*3 in another cell and press Enter or Return. Excel multiplies the last two numbers and adds the first …
Insert the current date and time in a cell - Microsoft Support
Let's say that you want to easily enter the current date and time while making a time log of activities. Or perhaps you want to display the current date and time automatically in a cell every time formulas are …
Subtract numbers in Excel - Microsoft Support
Let's say you want to find out how many inventory items are unprofitable (subtract profitable items from total inventory). Or, maybe you need to know how many employees are approaching retirement age …
Add or subtract time in Excel - Microsoft Support
Let's say that you need to add two different time values together to get a total, or you need to subtract one time value from another to get the total time spent working on a project. As you'll see in the …
Stop automatically changing numbers to dates - Microsoft Support
Stop Excel from entering dates automatically by changing numbers to dates. You can format cells as text before you enter numbers. Or if you have just a few numbers to work with, enter a space before …
Check if a cell contains text (case-insensitive) in Excel
Let's say you want to ensure that a column contains text, not numbers. Or, perhapsyou want to find all orders that correspond to a specific salesperson. If you have no concern for upper- or lowercase text, …
Sum values based on multiple conditions - Microsoft Support
Let's say that you need to sum values with more than one condition, such as the sum of product sales in a specific region. This is a good case for using the SUMIFS function in a formula. Have a look at this …
Present your data in a Gantt chart in Excel - Microsoft Support
Learn how to create a Gantt chart in Excel. Create a Gantt chart to present your data, schedule your project tasks, or track your progress in Excel.
Import data from the web - Microsoft Support
Import data from the web Applies To Get started with Power Query and take your data transformation skills to the next level. First, let's import some data. Note: Although the videos in this training are …