How-to articles, tips & tricks for MS Office

Jul
25

How to create waterfall chart in Excel (bridge chart)

In this article we will go above and beyond creating basic graphs and have a closer look at a special chart type – the Waterfall chart in Excel. You will find out what a waterfall chart is and how helpful it can be. You will know the secret of creating a waterfall chart in Excel 2010 - 2013 and learn about different utilities that can do it for you in a minute. Continue reading

Jul
24

Top 5 Tips For Coding Excel VBA Macros

VBA, Visual Basic for Applications, is the programming language that Excel understands and although Excel provides an easy to follow macro wizard, using VBA enables you ultimate control in ensuring the macro performs exactly as you want it to. A macro is simply a set of instructions and is usually created by letting Excel record the series of instructions that you want it to later remember and perform automatically. Here are top five tops for coding Excel VBA macros. Continue reading

Jul
22

How to enable macros in Excel 2010-2013

This tutorial teaches how to enable macros in Excel 2010-2013. You'll also find step-by-step instructions showing how to disable macros in Excel or turn them on via Message bar and Backstage view. In addition you'll find a tip to run a macro even if all macros are disabled and get a link to a piece of code that gets users enable macros in a workbook. Continue reading

Jul
21

How to insert page numbers in Excel 2010-2013

This article explains page numbering in Excel 2010-2013. Find out how to insert page numbers in Excel if your workbook contains one or multiple worksheets, how to set a custom number for the starting sheet or delete number watermarks added incorrectly. Continue reading

Jul
17

Excel VLOOKUP tutorial for beginners - syntax and formula examples

This VLOOKUP tutorial explains the syntax and provides a number of examples that illustrate the most common usages of the VLOOKUP function in Excel. Continue reading

Jul
15

How to insert and remove page breaks in Excel

The Excel page break option helps you see where page breaks will appear when your worksheet is printed. In this article I'll show you several ways to insert them manually or by condition. You'll also learn how to remove page breaks in Excel 2010-2013, where to find the Page Break Preview, hide and show the marking lines. Continue reading

Jul
10

How to use Excel COUNTIFS and COUNTIF with multiple criteria

The tutorial explains how to use COUNTIFS and COUNTIF formulas with multiple criteria in Excel. You will find a number of examples for different data types – numbers, dates, text, wildcard characters, non-blank cells and more. Continue reading

Jul
9

How to rotate charts in Excel - rotate bar, column, pie and line charts

This post describes how to rotate a chart in Excel 2010-2013. You'll learn different ways to spin bar, column, pie and line charts including their 3-D variations. Besides, you'll see how to reverse the plotting order of values, categories, series and legend. Those who often print graphs and charts will read how to adjust the sheet orientation for printing. Continue reading

Jul
8

Transform your crosstab to list with Unpivot Table for Excel

If you’ve been searching the web for an easy and flexible way to unpivot data in Excel, you are in the right place at the right time. Ablebits have just released a new tool for Ultimate Suite. This little add-in will easily convert your crosstab table to a normalized list. Continue reading

Jul
2

COUNTIF in Excel - count if not blank, greater than, duplicate or unique

The article explains Excel COUNTIF function, provides a number of examples and warns about possible quirks when using COUNTIF with multiple criteria and specific types of cells. Continue reading

Older posts »