Articles
Our latest articles are below, or you can filter by category using this dropdown:
Power Query for Data Preparation in Excel: An Introduction and Walk-Through for Beginners
Unlock the Potential of Power Query in Excel for Effortless Data Preparation! In this article, we demystify the art of transforming raw data into actionable insights. With step-by-step instructions and hands-on examples, you'll master the essential skills to save time, reduce errors, and supercharge your data analysis.
Let Excel do the Math: Easy tricks to clean and analyze data in Excel
One of the most common things I see when I work data in excel that others have compiled or analyzed is the under-use of Excel’s computational powers. In part, this has to do with setting up your data correctly to all Excel to do the work.
Video: How To Create a Visually Impactful Column Chart
A tutorial on creating column charts in Microsoft Excel. Learn the basics of creating and transforming your column charts into something clean, informative, and impactful.