Text Functions in Excel
Excel text functions add, extract, and edit text. Excel has over 30 text functions to edit, format, and clean data. It is so much more than number crunching.
Text Functions in Excel Read More »
Financial Functions in Excel
Excel has 55 financial functions to solve financial problems. Excellent financial analysis requires using many financial functions in Excel. These functions use time value of money (TVM) calculations to solve many financial problems.
Financial Functions in Excel Read More »
Creating Graphs in Excel
Excel can display several types of graphs to visualize data. There are at least 26 different graph types in Excel.
Creating Graphs in Excel Read More »
Statistical Analysis in Excel
Excel has many statistical functions useful for data analysis. These Excel statistical functions include SUM, AVERAGE, STDEV.S, LARGE, and MAX.
Statistical Analysis in Excel Read More »
Lookup Functions in Excel
Excel can select a specific value from a long list of values. These are called lookup functions. The most important lookup functions are VLOOKUP and XLOOKUP.
Lookup Functions in Excel Read More »
VLOOKUP Tutorial for Excel
VLOOKUP is a popular and useful function in Excel. It is one of the top 10 most popular Excel functions. Every Excel user should know VLOOKUP.
VLOOKUP Tutorial for Excel Read More »