Select Page

Resources & Blog: Tutorial

How to Create a Google AdWords Campaign

How to Create a Google AdWords Campaign Getting Started with a Google AdWords Campaign for your business As you search for something on Google.com, you’ll notice the first few results to appear are actually ads. Businesses and organizations pay to appear in these top positions to encourage searchers to click through to their website. These companies then pay Google by the click — this form of online advertising is known as a Google AdWords Campaign.   An ever-increasing number of businesses have found Google AdWords Campaigns...

read more

Top Three Long Document Time-Savers in Microsoft Word

Top Three Long Document Time-Savers in Microsoft Word Long document tricks and tips to save you time For your next book, magazine, research paper, or really long document you need to know these three time saving tricks in Microsoft Word to save you enormous amounts of time.  There are many built-in features of Word that you may not be properly taking advantage of, but the ones below have been some of the most overlooked. 1 – Automatic Table of Contents One of the most cumbersome, time consuming components of a long document is creating an...

read more

When is the right time to learn Visual Basic for Applications?

When is the right time to learn Visual Basic for Applications? Decide when to use the built-in Visual Basic for Applications tools or take your projects to the next level If you’ve ever tried to tackle a Microsoft Office Visual Basic for Applications (VBA) project yourself, then you know how daunting that can be.  While there are built-in Office tools to help you create macros and perform advanced data analysis, at some point you may realize that the default tools are not good enough.  By learning Visual Basic for Applications on your own, you can...

read more

From Excel Tables to PivotTables

From Excel Tables to PivotTables The evolution of Tables to PivotTables You (and, more importantly, your boss) love what you’ve created thus far in Excel.  You’ve spent hours entering your data into your worksheets, organizing the data using best practices, and creating advanced formulas to calculate what you need to see.  So, what have you learned about your data? At this point, it’s time to get involved with more Excel tools for data analysis.  As you get more creative with data analysis, you can extract useful information...

read more

Advanced Excel Data Analysis – Data Table

Advanced Excel Data Analysis – Data Table Data Tables can help you save time in Excel data analysis While working in Microsoft Excel on data analysis, there are a handful of built-in analysis tools available.  If you’re interested in studying the effect that a range of values has on the formula, you should consider setting up a data table. Let’s consider an investment analysis example to start.  Suppose that you want to see the future value of an investment with the annual deposit varying between $6,000 and $11,000.  You could...

read more