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.

In this blog post we will show you a very handy mathematical function that performs two operations in one, multiplication and addition. Using =SUMPRODUCT() allows you to return the sum of the products of corresponding ranges or arrays. In our example below we show you how to use the SUMPRODUCT Function to get a grand total. Our Video below shows you how you may currently be calculating your grand total, and we also show you exactly, step-by-step how to use this function.

Students and educators from select schools can use their .edu email accounts to get the Microsoft Office 365 Software Suite for free and waive the yearly subscription fee for as long as they are enrolled at their school at the Microsoft Store. A yearly subscription to Office 365 would normally cost $279.96 over 4 years. Office 365 includes Word, Excel, PowerPoint, OneNote, Outlook, Access and Publisher, as well as cloud support, SkyDrive online storage space and 60 minutes of Skype calls per month. Only select schools qualify for this deal. Check to see if your school is listed.