Using Power Query to Clean Your Excel Data
Thursday, May 9th, 2019 / by Excel Champ
Power Query is a handy feature in Excel that helps you to clean your data, and change it into the format that you need it in. Power Query has been available in Excel for a long time, although in Excel 2016 it was called Get and Transform instead. This tool is an ETL (Extract, Transform […]
Read More
Venturing Away from Excel’s Home Tab: The Data Tab
Tuesday, August 28th, 2018 / by Excel Champ
If you tend to avoid venturing away from Excel’s home tab, where you feel most comfortable, you are missing out on some features that could make your life easier. The Excel 2016 Data Tab, for example, is packed with useful functionality. In this post, we will review the functionality available in the “Get & Transform,” […]
Read More
How to Leverage Excel in Your Day-to-Day Work
Wednesday, May 2nd, 2018 / by ExcelHelp
Excel is the Top End-User Application Excel has been a valuable tool for people in many different professions for some time now. Many careers require that applicants demonstrate their knowledge of this Microsoft program. Almost every user knows the basic features that Excel offers, which includes data gathering, storage and analysis, but even daily Excel […]
Read More