Microsoft Excel Power Query Append Operation With Multiple Data Sets
Microsoft Excel Tips and Tricks Microsoft Excel’s Power Query feature allows you to append multiple data lists, creating a master[…]
Read more
Category: Excel
New Excel TEXTSPLIT Function to Separate words with Ease (includes cool tips)
Microsoft Excel Tips and Tricks Until now, splitting words to separate cells or breaking up long text strings in Excel[…]
Read more
3 NEW Excel Text Functions I wish I had years ago!
Microsoft Excel Tips and Tricks TEXTSPLIT, TEXTAFTER and TEXTBEFORE make rearranging text in Excel easier than we’ve ever had it.[…]
Read more
15 Advanced Excel functions every data analyst should *KNOW*
Microsoft Excel Tips and Tricks Learn the most important Excel functions and how to use them for business data analysis.[…]
Read more
How to link two files in Excel – 2 ways to solve the problem
Microsoft Excel Tips and Tricks I have a price list Excel workbook & sales data workbook. In this video, let’s[…]
Read more