How to Use Free Microsoft Office Online
This first article in the Introduction to Data Analysis series will walk you through setting up Microsoft’s free Office Online and introduce you to using Excel Online with OneDrive.
5 Steps to Improve Your Excel Data Tables
You can improve your data visualizations productivity by using the built-in table functionality available in Excel. This tutorial and sample Excel workbook, available on GitHub, will move you from raw table to interactive analysis in less than 5 minutes.
How to Convert Excel Tables Fact Tables Using Query Editor
If you have an excel table that is built for data entry, it may not be in the best format for data analysis or your data model. By using Query Editor, you can keep the original table and create a version that you can use for analysis as a dimensional fact table.