Excel Explained
253 FOLLOWERS
Features short and practical examples for beginner and intermediate Excel users. Radu shares short lessons and tips on how to work smarter with Excel and improve the way you perform daily tasks.
Excel Explained
1y ago
Sometimes, the data in your spreadsheet may not be formatted as you need it to be. Removing extra characters can be tedious, and doing it manually is time-consuming and prone ..read more
Excel Explained
2y ago
To identify a VAT rate based on a simple tax rate table, you can use the VLOOKUP function. For this example we have also used a Data Validation List ..read more
Excel Explained
2y ago
Learn how to change text case to UPPER, lower or Proper format and combine text from different cells to obtain the desired result ..read more
Excel Explained
2y ago
Learn how to find duplicates in Excel. Perform the check in the same column or compare two different sheets, using conditional formatting or formulas ..read more
Excel Explained
2y ago
If you need to calculate subtotals based on item type (or whatever common criteria), you can easily do so using the SUMIF function ..read more
Excel Explained
2y ago
If you want to take your Excel skills to a new level, you have to learn how to use INDEX And MATCH, combine multiple functions and write complex formulas ..read more
Excel Explained
2y ago
If you are looking to count cells not between two numbers in Excel using COUNTIFS, then you are in for a disappointment. That's because COUNTIFS uses the AND logic when ..read more
Excel Explained
2y ago
In this article, I'll explain how to count cells that contain odd numbers in Excel. This example uses two functions: SUMPRODUCT and MOD. Before we begin, I suggest that you ..read more
Excel Explained
2y ago
Learn how to troubleshoot and fix #NULL!, #REF!, #DIV/0!, #NAME?, #N/A, #NUM, #VALUE, and ##### errors in Excel (practical examples included ..read more
Excel Explained
2y ago
Learn how to troubleshoot and fix #NULL!, #REF!, #DIV/0!, #NAME?, #N/A, #NUM, #VALUE, and ##### errors in Excel (practical examples included ..read more