News

Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or rows from your data without nesting several functions in your formula ...
You could conceivably make a screen-capture of any data source, save the screen-capture as an image file, then extract the data and import it into Excel.
Learn how to use the new Microsoft Excel REGEX functions to easily extract, clean and format data for easy data visualization and analysis ...
Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.
Excel Charts are an attractive way to show data. This article explains several ways to export, convert & save Excel charts as Images with just a few steps.
This is the demonstration file to accompany the article, How to quickly extract delimited data using Microsoft Excel Power Query by Susan Harkins.