This category groups all articles that are in some way related to Excel. For more detailed filtering, direct your attention to one of the thematically focused categories below
Don’t miss out from category:
This comprehensive case study brings together key principles of financial analysis to solve a real-world dilemmaassessing the profitability of a real estate purchase. Specifically, we will calculate the IRR (Internal rate of return) for an apartment. This analysis is complex, as it integrates cash flow, taxation, debt, and inflation. Therefore, I will guide you through… Read More »
Internal Rate of Return (IRR – internal rate of return) is a widely used concept in finance. It is mainly used to evaluate the profitability of an investment that generates cash flows over time (which often have to be estimated). Every company or investor must decide whether it makes sense to commit an initial investment… Read More »
Logical functions serve us to test conditions not only in Excel. They can be used in situation when we need to compare 2 or more values and find out if a certain condition is met. Often used function IF belongs to logical functions, except for this function, you will most often use functions AND and… Read More »
SUBTOTAL is a little strange function. There are 11 mathematical functions hiding inside it. We can calculate sum, arithmetic mean, spread, minimum/maximum and another statistic values using SUBTOTAL function. What’s more, we can limit whether we want to calculate even with hidden values which were hidden manually. All under roof of one function. SUBTOTAL –… Read More »
There is a huge number of functions for date and time in Excel. they are used to extract parts of the date or time type of cell. You may have needed to extract some certain parts of the data of date and time data types, for example month. All functions have identical and absolutely simple… Read More »
You have a huge table with many date entries in it. You need to find out which date is after 20th week of the year or if a certain date is Friday. MS Excel will help by three functions – WEEKNUM, ISOWEEKNUM,WEEKDAY . It is definitely more effective than searching in calendar. More so if… Read More »
This article is made for those who regularly export data from some database to Excel in order to analyze them or process some kind of automated report (using formulas connected to imported dataset) like I do regularly for some of my clients. Usually, we insert the data into Excel simply by copying it from some… Read More »
Right from the beginning let’s be clear. Even though this process is possible, don’t use it as your standard process. Instead use How to Execute SQL Query in Excel – Tutorial with Examples. But I will show you anyway. Processing SQL queries through procedures in Excel is not optimal in general, but sometimes there is… Read More »
Import of Excel sheet or csv file into SQL Server is a quite common task. You can find a guide on how to do it below. Let’s have an excel file containing data on companies: Steplist – Import Excel to SQL Database Example 1) Data import… Read More »
Did you ever need to compare 2 lists and test it for duplicities? The easiest way to do it in Excel is to use standard functions as VLOOKUP. Sometimes though, we might need to compare 2 lists where one of them contains typos. Here, Fuzzy lookup comes into play (can be downloaded here). Typical example… Read More »