Results for:
How_2D00_To

• Combining Chart Types, Adding a Second Axis

  21 Jun 2012

  (This post was originally written and published by Katherine Fifer, an intern on the Excel 2007 team. We've updated it for Excel 2010 and added a sample worksheet to help you learn.) Often it is useful to create charts that compare different types of data. For example, you might want to compare a stock...
• Learn advanced filtering in Excel by tracking flying fish

  20 Jun 2012

  The fish-throwers at Pike Place Market are one of Seattle’s most popular tourist destinations. These guys can toss virtually any marine animal—salmon, crab, cod—and certainly they can catch! Flying fish might wow visitors, but if you own the fish shop, one of your main concerns is likely...
• Webinar: Excel PivotTables and Slicers

  11 Jun 2012

  In this week’s webinar, you’ll get an overview of two tools in Excel for crunching numbers so you can know what the numbers mean to your business: PivotTables and Slicers (new to Office 2010). References for this webinar: So you asked about PivotTables Quick Start: Create a PivotTable report...
• What's the dif? Gridlines vs borders in spreadsheets

  23 May 2012

  A lot of you want to know the difference between gridlines and borders. Gridlines help you while you're working in a spreadsheet; while borders help you highlight important information for people to see. Gridlines appear automatically showing you how the data is organized into rows and columns; while...
• Using multiple criteria in Excel Lookup formulas

  26 Apr 2012

  (This post is written by JP Pinto, the winner of the Great White Shark Award given for the best article written about VLOOLUP during VLOOKUP Week . We asked JP to share more of his Excel wisdom with you. JP Pinto blogs at Excel-User.com , where he writes Excel articles for common users to help improve...
• Simplifying data entry with a list box and VBA code

  14 Feb 2012

  To plan which topics to write during the next three months, our Office documentation team needed an easy way to enter values in an Excel worksheet limited only to values in a list. However, we couldn't use Excel's data validation feature because it only lets you select one item per cell. The solution...
• The Excel part of mail merge

  15 Nov 2011

  Hey, the holidays are fast approaching, which means you've got to get your cards signed, sealed, and delivered! This post goes out to those of you who keep your address list in Excel and need to figure out how to use it to create mailing labels in Word . Creating labels can be intimidating, mainly because...
• Tips on using seven heavenly text functions

  11 Oct 2011

  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...
• How to do percentages in Excel

  2 Aug 2011

  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...
• A capital idea: Changing case in Excel (video)

  10 Mar 2011

  People often ask how to change the case of text in Excel. This issue tends to crop up when you work with data from external sources. Unlike Word, Excel doesn't have a Change Case button or keyboard shortcut for magically switching between uppercase, lowercase, and proper case. Now, that doesn't mean...
• Can’t find the Chart Wizard? No worries

  7 Dec 2010

  Going, going, gone! Yes, it’s true that the Chart Wizard was removed from the product when we shipped Excel 2007, and we didn’t bring it back in Excel 2010. For those of you upgrading from Excel 97-2003, this may come as a big shock. The Chart Wizard provided a useful four-step process that...
• True or false, IF provides the answer

  7 Sep 2010

  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. For example, this function...
• Importing Text Files in an Excel Sheet

  10 Jun 2010

  Today’s author is Jan Karel Pieterse, an Excel MVP, who describes the process of importing text in great detail. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/ . In this article, I'll explain how to ease importing of .txt, .prn and/or .csv files into an existing...
• Solutions to Three Common Problems when Using VLOOKUP()

  10 Jun 2010

  Today’s author is Greg Truby, an Excel MVP, who addresses some common issues you may encounter when you use the VLOOKUP function. 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...
• Running a SQL Stored Procedure from Excel (No VBA)

  7 Jun 2010

  Today’s author is Mike Alexander, an Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. For more useful articles and videos, visit www.datapigtechnologies.com . We all know we can use MS Query to get data from a SQL server. Typically though, we pull from a Table...
• Create conditional drop-down lists

  24 Nov 2009

  Today’s author is Reinout Dorreboom from the Netherlands, a Technical Consultant at Getronics, where he has worked with Office applications for many years, and where his Microsoft Certified Training skills enabled him to help other people get up to speed with Excel. In Excel 2007 (and earlier)...
• Excel 2010: New Search Filter

  1 Oct 2009

  Exploring large data sets and creating filters has never been easier than with Excel 2010. Tables, PivotTables and PivotCharts now have a new search functionality that easily enables you to find what you need, filter and repeat for a faster more efficient way of navigating those enormous data sets. Filtering...
• Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers

  23 Sep 2009

  Thanks to Karen Cheng for putting together this series on Slicers. New to Excel 2010 are slicers, which are visual controls that allow you to quickly and easily filter your data in an interactive way. They float above the grid, like charts and shapes. Here’s an example of the same slicer in three...
• New and Improved Solver

  21 Sep 2009

  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. The purpose of this post is to review the improvements to Solver, and...
• More Conditional Formatting Features in Excel 2010

  11 Aug 2009

  In this blog post I’ll walk through some of the new Conditional Formatting features in Excel 2010 such as: Cross-Sheet References Robust Error Handling Performance Enhancements Cross-Sheet References In Excel 2010, you can create conditional formatting with references to a different sheet on the...