Tips and tricks to help you use Excel better.
Excel: 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.
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.
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.
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.
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.
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.
When 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.
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 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.