How to Automatically Unmerge Cells in Excel Searching ways to Automatically Unmerge Cells in Excel? In this post I’ll show you a free Excel tool that will Unmerge all the cells and fill the blanks with values to help you analyze your data! Free Download Download now for free our Excel Tool used in the video below: Unmerge Cells in Excel Automatically Watch this video and learn how to use our tool to Unmerge all the cells automatically: How does the tool work: The tool allows you to quickly Unmerge all cells in Excel and fill the blanks with values …
Read More

How to do VLOOKUP in Power BI Searching how to do VLOOKUP in Power BI? In this post I’ll show you how to use the Merge Queries function from Power BI to achieve this! Free Power BI Template Download Download now for free our Power BI template used in the video below: Merging Queries in Power BI Watch this video and learn how to do VLOOKUP in Power BI using the Merge Queries functionality: How does the ‘Merge Queries’ work: The Merge tables functionality from Power BI allows you to select common columns between 2 or more different tables, creating …
Read More

Group by range of values in Power BI Searching how to classify data or group by range of values in Power BI? Try these tips and start grouping your DATA now. Free Power BI Template Download Download now for FREE this template with the DAX function used in the video below. Create your own data group by range of values Watch this video and learn 2 Ways to Group DATA in Power BI by using visuals or DAX formula:https://youtu.be/HguiSaoo0p0 You can use this approach to Understand a population into different Age Groups Categorize products into different ranges of price Split a …
Read More

Send multiple emails at once from Excel Searching how to send multiple emails at once? Try this FREE email tool made in Excel and send hundreds of custom emails in just seconds! Free Download: MET (Massive Email Tool) Download now for FREE this email tool built in Excel and you will be able to send customized emails to several recipients in Outlook, and even add personalized attachments! How to use it Watch this video and learn how you can use today the Massive Email Tool to send multiple emails at once: What can you do with the MET tool Send …
Read More

How to Calculate Age (Days, Months or Years) in Excel During this week we posted our first video from the Hack of the Week series where we showed you How to Calculate Age in Excel in Days, Months or Years. The trick shown in the video is a trick to combine Excel’s hidden function DATEDIF and IFERROR to create a new formula, ensuring a correct calculation of age in days, months or years without errors.  The DATEDIF function Using the DATEDIF function on its own may result in a few errors and limitations, however our trick will allow you to use one single …
Read More

A Free Web Excel Translate Tool Do you work in an international environment where your colleagues have Excel installed in different versions and languages?Or perhaps – like in my case – you moved from a different country and now you need to relearn how to use Excel and its formulas, however it’s all in English this time. A Google Translate for Excel could be quite handy at these times!In this post I’d like to share about the Excel Translator, the free web Google Translate for Excel tool that has helped me BIG TIME since I moved from Brazil to Germany …
Read More