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.

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. 

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.

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.

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.

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.

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…

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.

Getting Started with Microsoft OneNote

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.

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!

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.