Home » Excel
Here we discuss the top financial functions in excel including the Yield Function, FV Function, NPV, and IRR Function, PV function, Rate Function, IRR Function, PMT and PPMT Function in excel.
Lookup functions are very important for financial analysis as it helps locate the right dataset from the large reference date. Here we discuss functions like VLOOKUP, HLOOKUP, Match, INDEX etc
Here we discuss the logic functions like IF Function, AND / OR Function, NOT Function and True Function.
Here we discuss the maths related functions and how to use them in excel. Most important functions discussed here are EVEN, ODD, ABS, SUM, SUMPRODUCT, SUBTOTAL, ROUND, AGGREGATE etc
Text functions help us manipulate the text within an excel. Here we discuss functions like PROPER, RIGHT, LEFT, TEXT, MID, LEN and Concatenate.
Date and Time Functions are very useful as they help us quickly perform calculations using date functions with much ease. Here we discuss TODAY, DATE, TIME, NOW, WEEKDAY and more.
Statistical Functions in excel helps us easily calculate statistical measures. Here we discuss AVERAGE, CORREL, COUNT and COUNTIF
Here we'll talk about the different types of charts in excel and we'll also learn how to create effective charts and make them interactive, including Column Chart, Stacked Column Chart, Excel Pie Chart and Excel Area Chart and more.
Information Functions in Excel are used to obtain information about the worksheets and their contents. Here are some information functions that are most frequently used in excel like ISNUMBER in Excel, ISERROR in Excel, ISBLANK in Excel and ISNA Function in Excel
Here we will discuss the dozens of tools in excel available to make the editing process as user-friendly as possible. With the following articles, you will learn about the various tools offered by Excel.
Here you'll see the tips and tricks for saving time in Excel, which will also help you increase your No Time productivity.
Here we discuss the VBA functions that are most useful and most frequently used. Below are the most popular built-in VBA functions.