• What's your favorite thing about Excel PivotTables?

    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?

    ...
  • Freeze Panes made simple (Video)

    Ever wanted to see just a part of your Excel worksheet that's way over on the right? You scroll over and find the information you're looking for, but your row or column headings-sometimes both-have disappeared. Or maybe you want to see data in one row that's at the bottom of your worksheet (which might contain hundreds or even thousands of rows). How can you go to that row and still see how its data has been categorized in the headings? By using the Freeze Panes commands on the View tab in Excel.

    ...
  • Samples for learning conditional formatting: icons, formulas, cell values, and more

    When we released Excel 2010, we published a workbook for you to download, which contains samples of conditional formatting rules. The samples are really helpful for learning how to track trends, check status, spot data, and find top values. Some samples are for busineses and some just for fun. You can find out how to compare bicycles by using a rating scale; calculate sales for a specific region and target; and more.

    ...
  • Tip: Add a watermark to an Excel worksheet

    image of watermarksIf you're collaborating or creating sensitive material in Excel, you probably need either a DRAFT or CONFIDENTIAL watermark. Excel doesn't come with a built-in way to add a watermark, but there's a pretty painless way to do so. We show you how and give you sample watermarks to get you started.

    ...
  • Q & A: Things you really want to know about Excel IF function

    Some of the most frequently asked questions that we receive are about Excel's IF function. In this previously published Q&A, a writer on the Excel team answers some of the most common questions. 

    ...
  • Conditional Formatting Rules Simplified

    Conditional Formatting ExampleConditional formatting is a popular feature and is a great way to easily identify cells with a range that meet some criteria. However, users often want to create conditional formatting rules that go beyond comparing a cell’s value to a single value or a single cell reference - row or column comparisons are commonly requested operations. In this blog post, we will learn how to use relative references in conditional formatting rules to make such tasks easier.

    ...
  • Go beyond the basic chart type

    Floating column chartExcel comes with lots of predefined chart types, including column, line, pie, and so on. However, many of you ask how to make other kinds of charts, such as floating column charts, Gantt charts, combination charts, org charts, flow charts, hierarchy charts, histograms, or Pareto charts.

    Though these charts aren't available in the list of predefined chart types, don't worry. There are ways to create them in Excel.

    ...
  • Circular Reference? Excel's most popular (!#?%) error message explained

    Circular Reference Millions of people using Excel don't get why they see the "circular reference" error message right after they've entered a formula. The message means that your formula is trying to calculate its own cell--kind of like when a dog chases its own tail. Because so many of you (millions) searched on "circular reference" on Office.com, we thought we should very clearly explain how to remove or fix your formula.

    ...
  • Simplifying data entry with a list box and VBA code

    We show you how we used an ActiveX list box control and some VBA code to allow our users to enter multiple choices in cells.

    ...
  • Excel: The Basics (Video)

    Photo of imaginary Office 911 emergency control centerFor those of us who crunch words instead of numbers, Excel can be intimidating. We don't know the difference between a workbook and a worksheet, and for sure don't know to ask about conditional formatting (a cool way to visually display data). Then one day your boss asks you to create a report--with numbers. Gulp.

    In this video, the Office 911 emergency responders show a beginning Excel user how to add a table to a worksheet so she can better organize and view her data.

    ...

« First ...     6 7 8 9 10