Using Excel 2013's Power Query and Power Map: Part of Excel's Power BI Suite
Excel Power Query and Power Map are new tools that are part of the Power BI suite available in Excel 2013 Professional Plus and Office 365 ProPlus. …
Continue ReadingShowing items from windows platform
Creating a Storyboard with PowerPoint 2013
In order to create a storyboard with PowerPoint you will have to have installed Visual Studio 2013 Premium, Ultimate or Team Foundation. Then you can …
Continue ReadingAn Introduction to Power Pivot in MS Excel 2013
Power Pivot is a free add-in for Excel that allows you to import and manipulate huge sets of data from multiple sources. The Pivot charts you create …
Continue ReadingUsing Power View in MS Excel 2013
Excel Power View allows you to create interactive charts that give users the ability to create ad-hoc reporting based on the set of data they wish to …
Continue ReadingHow to Save Your Powerpoint Presentation as a Video & Share in MS PowerPoint 2013
PowerPoint 2013 has some great options for allowing you to share your presentation with others who aren’t able to attend a live presentation. This …
Continue ReadingUsing Sparklines in Excel 2013: A Tutorial
Sparklines were introduced in Excel 2010 and are back in Excel 2013. This simple chart lets you visualize a series of values right next to the values …
Continue ReadingCreating and Saving a Theme in Microsoft Word 2013
Tired of resetting document colors and fonts every time you create a new Word doc? Save your preferred choices as a custom theme, and apply them to a …
Continue ReadingCustomizing a Theme in Microsoft PowerPoint 2013
Planning on creating multiple presentations and want each one to have the same look and feel? Spend a little time up front creating a custom theme, …
Continue ReadingHow to Create an Organizational Chart in PowerPoint 2013: DIY
If you have the need to display a reporting structure within your organization you can easily create an Organizational chart using PowerPoint 2013. …
Continue ReadingUsing the Developer Tab in Excel 2013: An Overview
The Developer Tab in Excel allows power users to utilize automation functions such as macros and allows you to develop applications using forms and …
Continue ReadingCreating Customized Headers in Microsoft Word 2013
Want to make your Word document look more polished and professional? Create a unique header that includes your logo, your organization’s colors, …
Continue ReadingGuide to Building a Boxplot in Excel 2013 with Step-by-Step Instructions
Boxplots are handy charts for visualizing sets of data along with statistical facts related to that data such as median and percentile ranges. …
Continue Reading