Tagged Content List

Results for: Formulas

• Use Webservice functions to automatically update Excel 2013 spreadsheets with online data

This post on exploring Webservice functions is brought to you by Lee Bizek, a Program Manager in the Excel Team. Have you ever wanted to incorporate data from online resources into your Excel spreadsheets, such as stock quotes, weather, Bing Search results or even Twitter feeds? With new Webservice functions...
• Tips on using seven heavenly text functions

Harness the power of the suite of Text functions, such as RIGHT, LEFT, MID, FIND, LEN, TEXT, and REPLACE, and you'll be an unstoppable force. Okay, maybe that's a bit over the top. But learning to use these functions can really build your formula prowess. And it can be fun! Still a little extreme with...
• Why not use Excel as your calculator?

Before I launch into the many advantages of using Excel, a bit of nostalgia: Remember the old desktop and handheld calculators? Maybe you do, or maybe you've only seen them in a museum or in your grandparent's home. If you really want one of these for your very own, maybe you can get one free (with a...
• Making sense of dollar signs in Excel

We've noticed some of you searching for help using "\$" – a dollar sign. In Excel, a dollar sign can denote a currency format, but it has another common use: indicating absolute cell references in formulas. Let's consider both uses of the dollar sign in Excel. Dollar signs denoting currency If you...
• How to do percentages in Excel

Today, I'm going to blaze through a few things you need to know about percentages in Excel. Of all topics, why percentages? Well, because whenever I review search data on Office.com, I frequently see search terms such as "percentages" and "percent increase" and "percent difference." Now, maybe you're...
• IF and only IF (video)

This post is all about IF--not the poem by Rudyard Kipling, or the 1971 hit song by Bread, but the function . The IF function is used in many Office programs, but most of us know it from Microsoft Excel: IF(logical_test, [value_if_true], [value_if_false]) IF is one of the most searched-for words on Office...
• Summarize Spreadsheet Data With Excel's Array Formulas

Today’s author is Charley Kyd, an Excel MVP, who has worked with spreadsheets in business since 1979, and has written books on spreadsheet use for McGraw-Hill and Microsoft Press. In 1990, he also created the first-ever Excel dashboard. You can find more useful tips and posts from Charley and other Excel...
• Use SUMPRODUCT to find the last item in an Excel list

Today’s author is Charley Kyd, an Excel MVP, who describes how to use the SUMPRODUCT function to find the last sequential item in an Excel list. Charley has worked with spreadsheets in business since 1979, and has written books on spreadsheet use for McGraw-Hill and Microsoft Press. You can find...