I am working on a project that requires data that comes to me in an unusual format from the Bloomberg terminal. Each year's set of data comes in its own subfolder. I want to move all this data out …
Excel Tip: Freeze Chart Size from Cell Adjustments
As I mentioned in my MyExcelOnline podcast appearance, charting is one of the hardest Excel tools to master. My tip in the podcast showed how to add data with two keystrokes.Sizing your graph can also …
Continue Reading about Excel Tip: Freeze Chart Size from Cell Adjustments →
Excel for Healthcare Administrators: Who Should Take This Course?
Note: I have been receiving some great feedback on my course for healthcare administrators. One common question is who this course is for what a user should expect to get out of the course. To that …
Continue Reading about Excel for Healthcare Administrators: Who Should Take This Course? →
Use Excel to Schedule Old Blog Posts at Random via Bulk Buffer
Download the exercise file at https://drive.google.com/file/d/0B4GK... I use Bulk Buffer to re-distribute old blog posts and other content via scheduled posts at Buffer. Bulk Buffer allows you to …
Continue Reading about Use Excel to Schedule Old Blog Posts at Random via Bulk Buffer →
Bad Data Hygiene is a Career-Killer!
Here's my beef with most business education, something that I discuss in my course:Maybe you learn how to manage teams and schedules, but you sure don't learn how to manage data.Analysts commonly …
Continue Reading about Bad Data Hygiene is a Career-Killer! →
Retrieve Real-time Weather Data from Weather.gov in Excel using `FILTERXML()`
Download the exercise file here. Requires Excel 2013 or greater. These are new functions in Excel. You can import .XML data straight from the web into Excel with the WEBSERVICE( ) and FILTERXML( ) …