Tips and tricks to help you use Excel better.
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 a meeting with a local business recently I was asked if there is an easy way to “link” external documents, ex: Word documents, PDFs, other spreadsheets, from within a spreadsheet. The use case was a master agreement spreadsheet in which each line had supporting documentation that was maintained outside of the spreadsheet. The user wanted an easy way to organize these other resources and provide convenient links right from the mast spreadsheet.
Luckily there is an easy way to do this. Here’s how…
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.
Here is a super quick tip on copy formatting in Excel from one location to another.
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 – supposed 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.
When you are working with a mountain of data our simply cleaning up a report, repeatedly reaching for the mouse for basic tasks can get aggravating (at least for me!) To help keep your hands on the keyboard, here are my top 10 keyboard shortcuts in 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. We've received requests from clients asking how to create and use pivot…