Pulling RSS data into Excel (or: Using Excel to Search Craigslist) – Part 1
This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team.
Excel
Transform data into insightful spreadsheets to help you analyze trends and visualize information.
Refine results
Product
Audience
Publish date
-
-
Free Excel templates save time for busy parents, students, and teachers
This week’s post is written by Amy Miller. -
Crabby’s Monday tip: Change where the cursor moves after entering data in Excel
I tell you, I learn new things—sometimes even elementary things, that even typing monkeys already know—about Office programs every day and today I’m offering the newest one.
-
True or false, IF provides the answer
Today’s post is brought to you by Frederique Klitgaard. -
You Asked: What the heck is Scroll Lock
This week’s post is written by Amy Miller. -
Word of the week: Close (the header or footer, and get back to your document)
We get a lot of comments from people who have added a header or a footer and can’t get back to the body of their document.
-
Solutions to Three Common Problems when Using VLOOKUP()
This article assumes a basic familiarity with the VLOOKUP() function, one of the easiest ways to lookup up a key value in one worksheet or block of data and return a related piece of information from a second worksheet or block of data. -
Running a SQL Stored Procedure from Excel (No VBA)
In some organizations, the IT department wants all interaction with the server to be done through Stored Procedure. -
Scatter charts with PowerPivot
Rob over at http://powerpivotpro.com has a interesting post on scatter charts and PowerPivot: At right is a list of all chart types in Excel. -
Build your own board game, create playing cards
We recently published an energy calculator template from one of our content partners in Canada, Microsoft Home Magazine. -
Adding Every Other Cell in a Column
Today’s author is Bill Jelen, author of 24 books on Microsoft Office Excel. -
New and Improved Solver
Thanks to Eric Patterson for putting together this post.