Blogs

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 it would take to manually enter this data into new columns. To save time, I plan on using the Text to Columns wizard and Concatenate function rather than a complex formula. Once you learn the steps,...

Update: See near the bottom of this post for the latest Office how-tos on embedding Excel and PowerPoint files on web pages. You probably know how to use the COUNT function to count cells that contain a value. But what if you want to count only the cells that meet a condition, such as being greater than or equal to a number or date you specify, or that matches text? That's where the COUNTIF function comes in really handy. Keep reading to learn more, and try out this great function for free using...

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 . ...( read more ) Read More...

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. The week might be over, but thanks to the enthusiasm of the Excel community and to the Web, the information will continue to instruct Excel users at all levels of expertise. So thanks, Bill, and thanks...

Bill Jelen, MrExcel, has marked this week to honor the VLOOKUP function in MS Excel. Around the online Excel development community You will find contributions, usually blog posts, that gives various aspects for using or not VLOOKUP. I thought it would be interesting to create a case and see how VLOOKUP can be part of [...] Read More...

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 today's VLOOKUP Week door prize would be the best Ode to VLOOKUP. Check out the haikus and poems about undying VLOOKUP love already submitted, then or add your own by entering it as a comment...

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 it's taken on a life of its own with VLOOKUP t-shirts and coffee mugs, and a theme song and logo. ...( read more ) 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...