Gain control of editing your Word documents with some quick methods of selecting text that you may have never knew existed. Many of us have certain ways that we are accustomed to when selecting text, paragraphs and lines. What are some easy ways to select text in Word? Use both keyboard shortcuts and your mouse to speed up this common task!

Often, many of us click around from tab to tab to find the buttons on the Ribbon and features that we need. Maybe you use the Quick Access Toolbar to make your workflow faster. What about something better? Is there a way to have your favorite buttons and features in one place? Can you create a custom tab in Microsoft Word? Can you customize the Ribbon with the commands you want? Yes you can! Here's how.

Using tables in Word is a great way to display information in a grid format. You may be accustomed to setting tab stops and organizing your lists using this method. It looks great, but there’s a better way. What is the best way to organize existing text into a table? Well, that’s using the Convert Text to Table feature.

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.