Microsoft Office 2016 for Free?

Posted by David Thibault  /  July 16, 2015  /  Microsoft Office   —   No Comments ↓

Well not exactly. Microsoft is offering a free download of Office 2016 preview. Just to be clear, Office 2016 is still in beta testing and Microsoft is looking for Office enthusiasts to test and share their experiences to help develop the final version of Office 2016. Microsoft expects to release Office 2016 sometime late in 2015.

Read More ›

Tags: Microsoft Office

3 Problems Solved with Office 365 File Storage Solutions

Posted by Dan St. Hilaire  /  July 13, 2015  /  Microsoft Office, Office 365, Productivity   —   1 Comments ↓

In an article he contributed to Fast Company entitled "4 Reasons Your Company Needs A Collaboration Upgrade, Stat" Jacob Morgan writes: "An organization is no longer limited to a physical structure or proximity; an organization is now limited only by its ability to connect employees and information together." So, what if that problem—among others—could be alleviated with one simple solution?

Read More ›

Tags: Microsoft Office, Office 365, Productivity

How to Migrate Microsoft Word 2003 AutoText Entries into Word 2010

Posted by David Thibault  /  May 27, 2015  /  Word, Microsoft Office   —   No Comments ↓

This is a step-by-step guide that will assist with migrating AutoText specifically from Microsoft Word 2003 to Word 2010. Migrating AutoText will save you, or more specifically, your users a considerable amount of time because they will not need to reenter their AutoText entries.

Read More ›

Tags: Word, Microsoft Office

Excel: Clean Your Sheets with TRIM and SUBSTITUTE

Posted by Jon Hood  /  May 21, 2015  /  Excel, Microsoft Office   —   No Comments ↓

Occasionally, dates or names won’t merge correctly into a spreadsheet. There are extra spaces, for example, and you may want to get rid of them. How do you clean up your spreadsheets quickly? Use the TRIM and SUBSTITUTE functions. Trim blank spaces and substitute text or blanks with something different and clean up hidden characters!

Read More ›

Tags: Excel, Microsoft Office

Excel: Enable or Disable Touch Mode and Mouse Mode

Posted by Jon Hood  /  May 15, 2015  /  Excel, Microsoft Office   —   No Comments ↓

Working with a touch-screen device can present a challenge when working with the Ribbon in Microsoft Office Applications. You may wonder how to enable Touch Mode in Excel, for example. Can you make the buttons bigger? Absolutely. You can create more open space on the Ribbon so commands are easier to tap.

Read More ›

Tags: Excel, Microsoft Office

Customize and Brand your Office 365 Web Based Sign In

Posted by Jon Hood  /  May 13, 2015  /  Microsoft Office, Office 365   —   No Comments ↓

 

Read More ›

Tags: Microsoft Office, Office 365

Excel: Use Flash Fill, Concatenate and Text to Columns

Posted by Jon Hood  /  May 5, 2015  /  Excel, Microsoft Office   —   1 Comments ↓

FLASH FILL: Excel 2013 has an awesome feature called Flash Fill. How does Flash Fill work? It gives you the ability to take a part of the data entered in a column of a worksheet table, type part of it into the next column over, and fill a series.

Excel detects patterns in your initial data entry! The application then figures out the data you want to copy and even offers a few choices to match exactly what you want. Fill a series without a formula! Instead of manually entering your data or copying and pasting, let Excel do the work. Here’s how...

Read More ›

Tags: Excel, Microsoft Office

Better Organize your Outlook in the Business Setting

Posted by Dan St. Hilaire  /  May 4, 2015  /  Outlook, Webinars, Microsoft Office, KnowledgeWave News, Industry News   —   1 Comments ↓

In this webinar, you’ll learn ways to gain control of your Outlook. This can be very challenging and we’ll show you ways to streamline your workflow and make your Outlook experience so much better. Many of us use Outlook all day but may be unaware of some of the amazing tools and underutilized options that will help you be more productive and organized!

Read More ›

Tags: Outlook, Webinars, Microsoft Office, KnowledgeWave News, Industry News

Excel 2013 Power User for CPA's Course

Posted by Dan St. Hilaire  /  April 29, 2015  /  Excel, Microsoft Office, Courses, KnowledgeWave News   —   No Comments ↓

Join KnowledgeWave, and our Excel expert David Thibault, for our specialized Excel 2013 Power User for CPA's. 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.

Read More ›

Tags: Excel, Microsoft Office, Courses, KnowledgeWave News

Creating a Drop-Down Parameter in Access 2010

Posted by Cindi Kline  /  April 15, 2015  /  Access, Microsoft Office   —   40 Comments ↓

Parameter queries in Access 2010 are a great way to choose what you wish to see as your query result each time you run the query. One of the downsides to parameters is not being able to easily create a drop-down list from which users may choose what they wish to see. However, there is a way to accomplish this, with a little additional work. 

Read More ›

Tags: Access, Microsoft Office

Excel: Right Click to Show a Vertical Worksheets List

Posted by Jon Hood  /  April 13, 2015  /  Excel, Microsoft Office   —   No Comments ↓

Some Excel workbooks contain many worksheets and it can be difficult to easily access them. Is there a way to make more tabs visible? You could certainly use the slider bar to navigate but that takes more time and can be tedious. Here is the easiest way to display multiple tabs in Excel for quick navigation.

Read More ›

Tags: Excel, Microsoft Office

Sharing and Collaboration with Office 365

Posted by Jon Hood  /  April 7, 2015  /  Microsoft Office, KnowledgeWave News, Industry News, Office 365   —   1 Comments ↓

In this introductory sharing and collaboration webinar, you’ll receive a tour of the user interface and the many Office 365 offerings. Our goal is to help you better understand how using Office 365 and SharePoint Online will streamline your workflow.

Read More ›

Tags: Microsoft Office, KnowledgeWave News, Industry News, Office 365

Excel: IFERROR

Posted by Jon Hood  /  April 1, 2015  /  Excel, Microsoft Office   —   No Comments ↓

Why do you get errors such as #N/A, #VALUE!, #REF!, #DIV/0!, #NUM! and #NAME when you know the formula is correct? What is IFERROR? The IFERROR function is an easy way to fix or change the way an error message is displayed in a cell.

Read More ›

Tags: Excel, Microsoft Office

Word: Enable or Disable Touch Mode and Mouse Mode

Posted by Jon Hood  /  March 13, 2015  /  Word, Microsoft Office   —   No Comments ↓

Working with a touch-screen device can present a challenge when working with the Ribbon in Microsoft Office Applications. You may wonder how to enable Touch Mode in Word, for example. Can you make the buttons bigger? Absolutely. You can create more open space on the Ribbon so commands are easier to tap.

Read More ›

Tags: Word, Microsoft Office

Word: Automatically Insert Text with AutoText

Posted by Jon Hood  /  March 10, 2015  /  Word, Microsoft Office   —   No Comments ↓

How do you enter the same text repeatedly in a Word document? You can easily insert blocks of preformatted text using what is called AutoText, or what is sometimes referred to as Quick Parts. Check out the quick and easy way to create AutoText entries by adding selected text to the AutoText gallery. This is an awesome feature that allows you to drop in common text and saves you time by not having to type it in every time!

Read More ›

Tags: Word, Microsoft Office