-
A lot of you want to know the difference between gridlines and borders. Gridlines help you work in a spreadsheet, and borders help you highlight important information in one for your audience. Gridlines appear automatically so you can see how your data is organized into rows and columns; borders need...
-
Issue: I have a list of URLs with their corresponding page views. The URLs include a section of the site and the date when the page was published. I'd like to calculate the total number of page views by site section and the total number of page views by publication date. I want to reduce the time...
-
Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way. In this first one, she shows us how to change the default width of a column in a pivot...
-
If you want to look up a value in a table using one criteria, it's simple. You can use a plain VLOOKUP formula. But if you want to use more than one criteria, what can you do? There are lots of ways using several Excel functions such as VLOOKUP, LOOKUP, MATCH, INDEX, etc. In this blog post, I'll...
-
JP Pinto! Congratulations! His post was one of seven chosen by Bill Jelen as the most innovative ones published during VLOOKUP Week . He won a copy Bill Jelens book Microsoft Excel 2010 In Depth. You can find links to all seven posts and see the voting results in our wrap-up post of VLOOKUP Week . ....
-
Ugh. Excel. It's not as intuitive as a Word doc, and not as aesthetically pleasing as a PowerPoint presentation. If you're more creative than analytical, you might feel as though it's dry and boring and filled with numbers you'd rather not look at. However, I can tell you that after you...
-
VLOOKUP Week has ended. The brainchild of Excel MVP Bill Jelen, the idea inspired all things VLOOKUP, including VLOOKUP odes, haikus, vampires, and a way to track shark attacks. Setting all fun aside--Excel experts created a crazy number of useful and innovative applications of VLOOKUP in seven days...
-
In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. You most likely know the core set of functions that come with Excel and have heard that VLOOKUP is an easy way to look up a value in an...
-
Bill Jellen found it. Erica Rhein started it. She posted a comment on Facebook declaring her complete dependence on VLOOKUP. "I use Pivot Tables and VLOOKUP every day. I would be screwed at my job without it." To Bill's formula-possessed mind this statement equals a love poem. So he decided...
-
What strikes terror into the hearts of Excel beginners? VLOOKUP! Excel power users, though, can't live without it. Excel MVP Bill Jelen has declared March 25 - 31, 2012 to be VLOOKUP week . He's invited his fellow Excel experts to publish VLOOKUP posts on their sites during the week. Already...
-
Do you belong to LinkedIn ? Did you know that LinkedIn has lots of Excel user groups where Excel trainers, developers, financial modelers, and even Excel blackbelts compete to out geek each other--or just share information. (The Excel Blackbelt group is for data visualization experts.) ...( read more...
-
Do you belong to LinkedIn ? Did you know that LinkedIn has lots of Excel user groups where Excel trainers, developers, financial modelers, and even Excel blackbelts compete to out geek each other--or just share information? ...( read more ) Read More...
-
Ever wanted to see just a part of your Excel worksheet that's way over on the right? You scroll over and find the information you're looking for, but your row or column headings-sometimes both-have disappeared. Or maybe you want to see data in one row that's at the bottom of your worksheet...
-
When we released Excel 2010, we published a workbook for you to download, which contains samples of conditional formatting rules. The samples are really helpful for learning how to track trends, check status, spot data, and find top values. Some samples are for busineses and some just for fun. You can...
-
If you're collaborating or creating sensitive material in Excel, you probably need either a DRAFT or CONFIDENTIAL watermark. Excel doesn't come with a built-in way to add a watermark, but there's a pretty painless way to do so. We show you how and give you sample watermarks to get you started...