Intermediate Excel Tips &Tricks presented by Stephany George at a Socializing for Justice ProfDev (low-cost professional development). SoJust is a cross-cultural, cross-issue progressive community, network and movement based on the philosophies of abundance and radical inclusion. Learn more and get connected at www.sojust.org.
Microsoft Excel is a program we all love to hate. Sometimes you swear that getting Excel to work the way you want is magic, especially when you see someone zoom through a spreadsheet without pause.
As a self-professed Excel nerd, when I see something new that I can't do, I have to find out how it's done. My skills have been self-taught and learned by struggling through online tutorials. Some of this information can be found on Microsoft's training website.
We've all experienced the trauma that comes from trying and failing to get Excel to work with us instead of against us. Here are some tips that will guide you through several basic skills every Excel user needs and introduce some intermediate techniques you can use to impress your boss, friends and family.
Conditional Formatting - Ever been jealous of how someone has color-coded their spreadsheet? Now you'll be able to do the same. Makes it easy to visually reference data.
VLookup - This tricky formula will help you find that one piece of information you need without having to scroll through the entire data set. Look for a specific piece of data in a column.