Excel News and Insights | Microsoft 365 Blog

Published September 7, 2010

2 min read

True or false, IF provides the answer

Today’s post is brought to you by Frederique Klitgaard. Frederique is a writer on Office.com It’s easy to understand why the IF function appears in the top 10 list of popular Excel functions. It’s a versatile function that can be used for all sorts of tasks.

Published August 24, 2010

1 min read

You Asked: What the heck is Scroll Lock

This week’s post is written by Amy Miller. Amy is a writer for Office.com. She’s written and edited content for Excel, Access, OneNote, and InfoPath.

Published July 21, 2010

<1 min read

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. You have a couple of options. You can double-click in the body of the document. You can also use the Close button.

Published June 10, 2010

7 min read

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.

Published June 7, 2010

1 min read

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. This adds a level of risk management and makes the DBAs feel better.

Published February 24, 2010

1 min read

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. But not all of them are supported as PivotCharts.

Published January 13, 2010

1 min read

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. During that process, they let us know about a board game activity that they recently published on their site, and we love it!

Published September 23, 2009

1 min read

Adding Every Other Cell in a Column

Today’s author is Bill Jelen, author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com, which includes more than 300,000 questions and answers about Excel. Jenny asks “Is there a quick way of adding every other cell ?

Published September 21, 2009

2 min read

New and Improved Solver

Thanks to Eric Patterson for putting together this post. In Excel 2010, we have made a number of improvements to Solver that make it easy for beginners to get started and more advanced ones to find solutions to all types of problems.

Published July 7, 2009

3 min read

Use the VBA SaveAs Method in Excel 2007

Today’s author is Ron de Bruin , an Excel MVP. You can find more useful tips and links to Excel add-ins at his website: http://www.rondebruin.nl/ You see a lot of old SaveAs code that does not specify the FileFormat parameter.

Published June 30, 2009

3 min read

Week Numbers in Excel

Today’s author is, Ron de Bruin, an Excel MVP. You can find more useful tips from Ron and links to Excel add-ins at his website: http://www.rondebruin.nl/ There are four primary week numbering systems in use worldwide. Each system has subtle differences that you should be aware of.

Published March 12, 2009

6 min read

Excel VBA Performance Coding Best Practices

Today’s author, Chad Rothschiller, a Program Manager on the Excel team, is back with a follow up from his previous post on VBA and Excel performance. I want to start off this post by thanking everyone who sent in their examples in response to my January request.

Product: Excel

True or false, IF provides the answer

You Asked: What the heck is Scroll Lock

Word of the week: Close (the header or footer, and get back to your document)

Solutions to Three Common Problems when Using VLOOKUP()

Running a SQL Stored Procedure from Excel (No VBA)

Scatter charts with PowerPivot

Build your own board game, create playing cards

Adding Every Other Cell in a Column

New and Improved Solver

Use the VBA SaveAs Method in Excel 2007

Week Numbers in Excel

Excel VBA Performance Coding Best Practices

Get started with Microsoft 365