by dayo ade | Mar 3, 2020 | Articles and Short Tutorials, Microsoft Excel Articles
Have you wanted to compare two different spreadsheets in MS Excel to figure whether or not the data in them is different, or alternatively, whether there are any duplicate rows? Manually going through the entire list of data is a herculean task. Fortunately, MS Excel...
by dayo ade | Mar 3, 2020 | Articles and Short Tutorials, Microsoft Excel Articles
Microsoft Excel is extremely versatile and this leads to it being the most popular spreadsheet software in the industry today. This widespread use of Excel is more often than not likely to lead to situations where you want to find the difference between certain...
by dayo ade | Feb 27, 2020 | Articles and Short Tutorials, Microsoft Excel Articles
There are multiple ways to accomplish everything in Excel. But sometimes, the quickest way is not the most obvious way. I just retired from the seminar circuit, but I present here four of the most painful customer stories. Each of these are from real people who ran...
by dayo ade | Feb 27, 2020 | Articles and Short Tutorials, Microsoft Excel Articles
The highly anticipated XLOOKUP function in Excel is available generally for all users across Windows, Mac, and Excel on the web. XLOOKUP is the successor to the iconic VLOOKUP function, which has been one of the most used functions in Excel. XLOOKUP helps users find...
by dayo ade | Feb 27, 2020 | Articles and Short Tutorials, Microsoft Excel Articles
Every financial analyst or accountant spends more time in Excel than they may care to admit. Based on years and years of experience, we have compiled the most important and advanced Excel formulas that every world-class financial analyst and accountant...