Excel

Tips and tricks to help you use Excel better.


How To Excel At Excel: 6 Easy Excel Shortcuts To Make Your Life Easier

  • August 9, 2018

Keyboard ShortcutsExcel: The stomping ground for tracking metrics, building equations and navigating through the moving parts of a business and seeing what’s working and what’s not working. It’s a cornerstone tool for business.

Here’s a compilation of 6 easy Excel shortcuts and overlooked features to make your life easier. 

Read More

Free Encryption Tools To Protect Your Data

  • July 13, 2017

Encryption might seem like a difficult concept to grasp – the first thing that might come to mind is that it’s something only techies would understand or use. However, the idea of encryption is not difficult to understand and the tools are fairly easy to use.

In this post, we’re sharing free encryption tools you can use to protect your personal and professional data from being stolen or held via ransomware.

Read More

Linking To External Documents From Excel

  • January 26, 2017

In a recent meeting with a local business, I was asked if there is an easy way to “link” external documents (i.e., Word documents, PDFs, other spreadsheets) from within a spreadsheet.

The user wanted an easy way to organize these other resources and provide convenient links right from the mast spreadsheet. This post details how anyone can easily to do this.

Read More

AutoSave To Save The Day

  • December 15, 2016

I always have multiple applications (usually Word and Excel) open on my desktop.  All crammed with several projects I’m trying to work through to completion.

Often times I’ll leave these documents open WAY longer than I should (often overnight) and sometimes come in to find my machine rebooted because of maintenance or patching.

Working this way leaves me open to losing hours of work but AutoSave is there to save the day.

Read More

Copy Formatting In Excel

  • December 8, 2016

excel-painbrush

I’m a stickler for nicely formatted Excel spreadsheets.  Headers, data call outs, number formats, backgrounds, borders all need to look ‘right’ before my mind will allow me to start looking at the data – odd I know!

Once you get your spreadsheet data all setup and you turn to formatting, here is a quick tool to allow you to enforce consistency in formatting across cells. Use the ‘paint brush’ (Extra tip: this tool exists in Word also!)

Here is a super quick tip on copy formatting in Excel from one location to another.

Read More

3 Printing Tips For Excel

  • November 8, 2016

Printing at this point is fairly benign task (and frowned upon unless absolutely necessary by some).

Me? Sometimes it is critical I have something in my hands to fully digest what I’m looking at – suppose I’m old school that way! Here are several things I’ve learned about printing from Excel over the years that I hope will be a help to you.

Read More

10 Excel Keyboard Shortcuts You Need To Know

  • November 1, 2016

keyboard-shortcutsWhen you’re working with a mountain of data or simply cleaning up a report, repeatedly reaching for the mouse for basic tasks can get aggravating. It’s like a constant reminder that you’re wasting your time with something that can be solved by using shortcuts.

To help keep your hands on the keyboard and increase your productivity, here are keyboard shortcuts in Excel that’s sure to impress.

Read More

How To Create A Pivot Table In Excel

  • January 13, 2016

Excel TableIn this video, we will show you some great tips to help you get the most out of pivot tables, an excellent tool for organizing and analyzing data.

We’ve received requests from clients asking how to create and use pivot tables on Excel. In this video, we will show you some great tips to help you get the most out of pivot tables, an excellent tool for organizing and analyzing data.

Read More