by dayo ade | Jan 14, 2021 | Microsoft Excel Articles
Today we are going to be talking about how to use Pivot Table in Excel. Our data set consists of 213 records and 6 fields. Order ID, Product, Category, Amount, Date and Country. Insert a Pivot Table To insert a pivot table, execute the following steps. 1. Click any...
by dayo ade | Jan 14, 2021 | Microsoft Excel Articles
Welcome to another tutorial from Megatek ICT Academy, today we are going to be talking about conditional formatting for numbers, in another tutorial we talked about conditional formatting for text. In this tutorial we are going to be learning how to...
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...