I love Excel. Yes, that makes me a nerd and I’m okay with that.
Numbers, algorithms, charts, and dynamic outputs just hit a part of my brain and soul as well as offer an intellectual challenge that is so stimulating. (Does that make me weird? I’m okay if it does)
So when I found out this Excel tips infographic, I knew I wanted to share it. I actually knew everything on the list, but it got me geeking out.
Here are my three favorite tips that I use all of the time.
- Conditional formatting is huge in Excel and perfect for making your files dynamic.
- Autofill is a great quick aspect of Excel, but what they don’t show you is that Excel is now smart enough to interpret how you want to fill it. Try it out.
- Vlookup is my latest and great tool that I use for numerous reports, including calculating data for the Top Church Tech Blogs lists I do.
What are some of your favorite Excel tricks?
[via Microsoft Training]
Do you have any other excel tricks you use regularly?
Eric Dye says
YES! EXCEL TRICKS!