MS Office, Acrobat & PC Tips | Cornerstone Business Solutions

An easy way to reveal useful system details By Ed Bott Every version of Windows includes a handful of utilities designed to give you information about your system and its current configuration. The Systeminfo utility is especially lightweight and useful. This...

ASAP Utilities – Simply a “Must Have” Add In for Serious MS Excel Users

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part One

I’m often asked how I do what I do in MS Excel with such ease and speed. Part of the answer is years of experience and part of the answer comes down to using some help and ASAP Utilities is one of my key helps. The good folk who put this tool together know what...

Backing Up Business Data — It’s Crucial!

by Chris Hunter | Feb 15, 2016 | Computer Software

There’s no particular peculiar virtue in religiously backing up business data. It’s just that the consequences of not doing so are potentially catastrophic. Many businesses feel secure that their data are reasonably safe. They have good anti-virus software or a...

Backing Up Business Data — It’s Crucial!

by Chris Hunter | Mar 24, 2016 | Disaster Planning & Recovery, Viruses

There’s no particular peculiar virtue in religiously backing up business data. It’s just that the consequences of not doing so are potentially catastrophic. Many businesses feel secure that their data are reasonably safe. They have good anti-virus software or a...

Balancing Text in MS Word Columns

by Chris Hunter | Mar 22, 2016 | Microsoft Word Tips

Break These 10 Habits – Make Your PowerPoint Presentation Outstanding

by Chris Hunter | Mar 21, 2016 | Microsoft PowerPoint Tips

Calculate Conditional Running Totals in MS Excel

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part One

Choosing between Vlookup and Index-Match formulas

by Chris Hunter | Mar 4, 2020 | Microsoft Excel Tips - Part One

From Excel Zoom INDEX()+MATCH() and VLOOKUP(), both have their proponents and opponents. Both of these formulas perform almost the same function. Both have pros and cons. In today’s tutorial we will try to compare their usage and that how they can be used to get most...

Clean Up MS Excel Data of Printable Artifacts

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part One

Clear Fields in an Access Combo Box for Easier Data Entry

by Chris Hunter | Feb 27, 2016 | Microsoft Access Tips

Combine Text and Dates in the Same Cell

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part One

Computer Attack: Do You Need a Firewall?

by Chris Hunter | Feb 24, 2016 | Viruses

Computer viruses, hackers, worms, spam, spyware, adware – isn’t a computer safe anymore? The sad fact is that any computer linked to the outside world via a network or an internet connection can be attacked. The computers in your business must all be considered a...

Conditional Formatting to Find Locked and Unlocked Cells

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part One

Copy Hundreds of Rows of Excel Formulas in Three Steps

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part One

Count If Functions for Two Conditions

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part One

Create a Form in MS Access

by Chris Hunter | Feb 27, 2016 | Microsoft Access Tips

Create a List Box in MS Excel to Ensure Data Entry Accuracy

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part Two

Create a MS Excel Chart That Automatically Updates with New Data

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part One

Create Your Own MS Outlook Signature

by Chris Hunter | Mar 21, 2016 | Branding, Microsoft Outlook Tips

Creating a Floating Column Chart in MS Excel

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part One

Creating a Summary Report in MS Excel with Data Consolidation

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part One

Creating an Index Sheet for a MS Excel Workbook

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part One

Loading... Taking too long? Reload document | Open in new tab Download [69.91 KB] The necessary VBA code for insertion into the Index page is below. Private Sub Worksheet_Activate() Dim wSheet As Worksheet Dim M As Long M = 1 With Me .Columns(1).ClearContents...

Creating Random Text in MS Word

by Chris Hunter | Mar 22, 2016 | Microsoft Word Tips

There are times where one needs to quickly generate text in a document to fill a column or to test a layout and you don’t want to cut and paste from another document. Well there is a solution. Here’s how to generate random text in Word: On a blank line in a Microsoft...

Cross Footing Logic – Avoiding Costly Errors

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part Two

Customizing Workbook Printing in MS Excel

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part Two

Takeaway: If all of your Excel spreadsheets need to contain a certain header and must print in a specific view, then you’ll relish this time-saving trick. The text below explains how you can create a custom Excel template that will allow you to automatically set the...

Data Entry: Built-In Functions to Simplify Data Entry

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part Two

Delete Duplicate Rows in a MS Excel Worksheet

by Chris Hunter | Mar 20, 2016 | Microsoft Excel Tips - Part Two

A common scenario in a data analysis project is the need to first identify and eliminate duplicate records. A typical example might be where you need to eliminate duplicate rows with information that matches in columns like last name, street address, phone number,...

Knowledge Bank

Tags

Chris Hunter, MBA