Formula examples that demonstrate how to use Excel VLOOKUP and SUM or SUMIF functions to look up and sum values with one or several criteria. You can use these formulas on any data in any version of Excel 2013, 2010, 2007 or 2003. See the complete tutorial here: Excel...

10 Microsoft Word 2016 Tips Every User Should Know Andre Da Costa | August 26, 2016 in How-To Since Microsoft Word dethroned WordPerfect in the 90’s to become the de facto standard in word processing; it has accumulated quite some features over the years. Not every...

Last week I came across the great video that answers questions about the different versions of Microsoft Office. In the past purchasing Microsoft office was rather simple. Today, you have many options and frankly I think they can be somewhat confusing. This video by...

Receiving a payment in QuickBooks is easy. In this tutorial I will show you how to receive a payment within QuickBooks. As I previously mentioned, when you do something for the first time in QuickBooks you can tell it how to handle the process. The very first time you...

When you partake in my QuickBooks tutorials you will learn everything you need to know about QuickBooks. I offer more than 35 great QuickBooks tips and tutorials and if you review them in order it is the equivalent of taking a QuickBooks class. Why are the tips in...

Create a cross-reference Applies To: Word 2016 , Word 2013 , Word 2010 , Word 2007 | A cross-reference allows you to link to other parts of the same document. For example, you might use a cross-reference to link to a chart or graphic that appears elsewhere in the...

Managing your email inbox can make the difference in managing your time today, this week and forever. I just read a study that suggested the average person spends 13 hours a week managing and working with email. It is imperative that you make sure you are very...

Microsoft’s Website has a number of resources that you should take advantage of as an Microsoft Office user. Source: Explore Word 2016 – Office Support Explore Word 2016 Explore the document gallery The document gallery is where you can create a blank...

Microsoft Excel pivottables are a great way to take complex data and organize it so it is much easier to understand. Yesterday a client and I had a discussion about Microsoft Excel and working with pivot tables. I asked her if she knew about pivottables and she said...

Inserting Simple Text into Excel. In this tutorial we will take a look at putting data in Microsoft Excel; in this case some very simple text. You will learn how to edit text and different options for moving around cells. We will take a look at the concept of cell...

Tutorial – Excel 2010 – 10 Things you must know Uploaded on Aug 7, 2011 Tutorial explaining 10 of the most common must-know features in Microsoft Excel 2010, Excel is used world-wide and this tutorial shows slightly beyond the basics in a simple way of...

Easily Edit PDF Files in Word 365/2016 Learn iT! Training Published on Mar 16, 2016 Making changes to a PDF can be tricky. In Word 365/2016, opening and editing PDF files is more painless than ever before. In this brief video, acquire new skills to improve your...

Outlook can be customized to suit your needs. When you first open Outlook it can look radically different from the way it looks on your coworkers computer. These tutorials will get you comfortable working with and moving around in Microsoft Outlook 2013. Thank...

Microsoft Excel can be used for rather simple tasks or more complex calculations. As you gain more experience with Microsoft Excel you might find that you want to explore some of the formulas that work with an Excel. In this series of tutorials I will start taking a...