The TAN function is a Math and Trigonometry function, and its purpose is to return a tangent of a number or angle. In this post, we show you how to use the TAN function in Microsoft Excel.

Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

While I'll always argue that SUM is my favorite and most-used Excel formula, there are plenty of other powerful functions included in the software. These features go far past using Excel as a digital ...

Common examples of Excel functions include SUM, AVERAGE, and MIN. More advanced common Excel functions include using VLOOKUP to find specific data, and using IF to make a conditional formula.

Using Flexible Functions in Excel Watch this video on YouTube. Expand your understanding of interactive dashboards with additional resources from our extensive library of articles.

Excel is so much more than just a spreadsheet or a simple database for cataloging your DVD collection. One of its many additional functions includes using it as an architectural design tool.

Microsoft Copilot, the new AI-powered tool integrated into Excel, transforms the way you perform data lookup and merging tasks using functions like VLOOKUP and XLOOKUP. This step-by-step guide ...

One of Excel's core features is its ability to perform calculations using functions and formulas. Although these terms are often used interchangeably, they have distinct meanings.

One of the advantages of using the PIVOTBY function instead of traditional PivotTables is its ability to automatically update with new data. As your dataset changes, so do your summaries, ensuring ...

Using a combination of MID and multiple FIND functions, this formula is ugly, to say the least – and things get a lot worse for more complex extractions. Again, Google Sheets does this better ...