There's no denying that data is not the most inherently pretty thing to behold. An Excel spreadsheet, after all, is not exactly a Monet. Even if you have a thoroughly organized spreadsheet, there are definite benefits to making it more visually appealing. Beyond simply adding color or editing fonts, this effort should be focused on making your data more digestible for your audience. This way it can be easily shared with and understood by your higher-ups and end users, and in turn they can use it to drive actions and provide the basis for smart decisions. Enter: PowerPivot.
Dan St. Hilaire
Recent Posts
Using PowerPivot to Make Data Visually Digestible
Posted by Dan St. Hilaire / March 31, 2015 / Excel — No Comments ↓
Tags: Excel
Class Alert: MS 20411 Administering Windows Server 2012
Posted by Dan St. Hilaire / March 30, 2015 / Windows — No Comments ↓
KnowledgeWave hosts a live remote session for Administering Windows Server 2012, Microsoft Course, MS 20411 weekly. This is an authorized Microsoft Official Curriculum (MOC) course and is eligible for Software Assurance (SA) Voucher redemption. Please contact a KnowledgeWave representative at 800-831-8449 to enroll.
Tags: Windows
An End-User Introduction to SharePoint Online
Posted by Dan St. Hilaire / March 23, 2015 / Microsoft 365, SharePoint — 7 Comments ↓
As an IT professional you understand that businesses deploy SharePoint for many different reasons. Intranets, document management, collaboration and workflow automation are a few of the most popular reasons. End-users on the other hand, often times are confused, unwilling or have little to no desire for change. Providing users with some basic knowledge about SharePoint can assist businesses with user acceptance.
Tags: Microsoft 365, SharePoint
Top 4 Benefits of Custom Training for Your Users
Posted by Dan St. Hilaire / March 20, 2015 / Software Rollout / Deployment / Migration, Training — No Comments ↓
There's no denying the fact that training employees on new software can take a tremendous amount of time and effort. This problem is only compounded when the software you're dealing with isn't particularly popular and there aren't that many resources out there to help you. The solution for this predicament could be to create a custom curriculum. While this sounds like it could take a lot of work, you'll reap some major benefits in the end. In this post we'll take a closer look, so you can feel empowered in putting together a custom training agenda for your employees.
The 4-Step Software Rollout Plan
Posted by Dan St. Hilaire / March 7, 2015 / Software Rollout / Deployment / Migration — 3 Comments ↓
It's probably obvious that when you introduce a completely new software platform at your company you should have a training plan ready. But what you might not have realized is the importance of establishing such a plan when you're rolling out a newer version of something familiar—such as Office or email software.
Office 365 Evolved - Today's New Look!
Posted by Dan St. Hilaire / January 22, 2015 / Industry News, Microsoft 365 — No Comments ↓
Tags: Industry News, Microsoft 365
An Overview of Microsoft Office Online and the Office 365 Outlook Web App
Posted by Dan St. Hilaire / January 19, 2015 / KnowledgeWave Courses, Microsoft 365 — No Comments ↓
Discovering the Power of Conditional Formatting in Excel 2013
Posted by Dan St. Hilaire / December 11, 2014 / Excel, KnowledgeWave News, Microsoft 365 — No Comments ↓
Get the look, flow and feel you want with your spreadsheet my making your own rules! Excel has seriously powerful and useful tools that can apply formatting rules to specific sections of your spreadsheet. Conditional Formatting does just what its name implies. First, a certain criteria is set for a data range (i.e. values greater than 1000). Then users can define the formatting characteristics (i.e. bold and red text). Once you’ve set conditions and formatting, Excel finds the values matching our criteria and applies the appropriate formatting.
Tags: Excel, KnowledgeWave News, Microsoft 365
Changing Font and Spacing Defaults in Word 2010
Posted by Dan St. Hilaire / December 8, 2014 / Word, Microsoft 365 — No Comments ↓
If you have recently been upgraded to Word 2010, yup there are plenty of business that are moving to Office 2010, even with Office 2013 available, you may want to change the new default settings for fonts and spacing. This blog post will show you step-by-step how to get it done. Let’s get started…
Tags: Word, Microsoft 365
Technology Certifications and Employment Opportunities
Posted by Dan St. Hilaire / December 1, 2014 / KnowledgeWave News — No Comments ↓
Tags: KnowledgeWave News
Excel 2013 Power User Course for CPA's
Posted by Dan St. Hilaire / November 24, 2014 / Excel, KnowledgeWave Courses, KnowledgeWave News, Microsoft 365 — No Comments ↓
Join KnowledgeWave, and our Excel expert David Thibault, for our specialized Excel 2013 Power User for CPA's course schedule for May 21st. After you’ve exported data from QuickBooks to Excel what’s next? In this custom course, students will learn the advanced skills necessary to create business applications using Conditional Formatting, various Functions, Formulas and PivotTables. This is a great class for the Excel user looking to boost there skills to Power User status. This session is eligible for 7 CPE credits for Certified Public Accountants.
Tags: Excel, KnowledgeWave Courses, KnowledgeWave News, Microsoft 365
Get Started and Go beyond with Microsoft OneNote
Posted by Dan St. Hilaire / November 6, 2014 / KnowledgeWave Courses, Microsoft 365 — No Comments ↓
Getting Started with Microsoft OneNote
A First Look at Microsoft Windows 10
Posted by Dan St. Hilaire / October 16, 2014 / Windows — No Comments ↓
Microsoft is planning on launching Windows 10 early to mid- 2015. Wondering what the new Microsoft Windows 10 interface may look like? Our Director of Education, David Thibault gives you a brief tour. Join David for a first look at some of the exciting new features and changes that are expected to come with the next Windows OS release.
Tags: Windows
Taking Excel PivotTables & Charts to the Next Level
Posted by Dan St. Hilaire / October 16, 2014 / Webinars — No Comments ↓
Discover the advanced features of creating and working with PivotTables and PivotCharts. This webinar is recommended for those who have attended, Look at Your Data in a Whole New Way with PivotTables in Microsoft Excel 2010. In this advanced PivotTable webinar we will show you how to build PivotTables from external databases, customize PivotTables, work with subtotals, and how to use advanced PivotCharts features. This session will truly take your PivotTables to the next level!
Tags: Webinars
An Introduction to PivotTables in Microsoft Excel
Posted by Dan St. Hilaire / October 15, 2014 / Webinars — No Comments ↓
Grab a comfortable seat and we’ll walk you through a 30 minute Webinar on the basics of creating PivotTables. Find out what PivotTables are, how they work and how to create your own. Wondering how to change your PivotTable field settings? How to understand the lingo used in PivotTable reports? We’ll cover all that, too, in one mind-expanding half-hour. The next time you need to see comparisons, reveal patterns or analyze trends, you’ll know exactly what to do. We won't make you wait long for the next steps, as a follow up webinar showing you how to take your PivotTables to the next level, is offered on the 30th of October.
Tags: Webinars