Functions Articles
Articles tagged Functions, including related tutorials, examples, and walkthroughs.
6 articles
TRUNC Function in Excel: A Comprehensive Guide
Discover the power of Excel TRUNC function with this comprehensive guide. Learn practical applications, and excel at truncating numbers in Excel....
VLOOKUP Not Working with Text Values: 6 Fixes You Need
Fix your VLOOKUP not working with text issue using our troubleshooting tips. Don't let #N/A or #VALUE errors stop you from getting accurate results....
How to Use Goal Seek in Excel
Use this guide to learn how to use goal seek in excel as well as how to put it into action. To use Goal Seek, you will have to open a new sheet....
Pivot Tables (PV Table): Everything You Need to Know
When working with Excel spreadsheets, it can be difficult to extract the information you need from large sets of data. Pivot Tables (pv table) offer a great way to quickly condense and analyze, and present your data, all...
How to Use the AVERAGE Function in Excel
To figure out the average of a group of numbers, makes it easier for you to analyze important data. Learn how to use the average function in Excel right here....
SUMIF and SUMIFS in Excel: Syntax, Examples, and Differences
Learn when to use SUMIF or SUMIFS in Excel, with working text, wildcard, and date examples—and see how their argument order differs....
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us