Posts Tagged 'Excel'

Jul
30

How to unhide and show hidden columns in Excel

From this article, you'll learn how to unhide columns in Excel 2010-2013. It will teach you to show all hidden columns or just the ones you select. Grab a special macro to unhide all columns in Excel automatically each time you open a worksheet and find out how to protect the hidden columns from being displayed. Continue reading

Jul
29

Advanced VLOOKUP formula examples: two-way lookup, nested vlookup with multiple criteria

In this VLOOKUP tutorial, you will find a number of advanced formula examples that demonstrate how to look up with multiple criteria, use two VLOOKUP functions in one formula, dynamically pull data from different sheets, and more. Continue reading

Jul
25

How to create waterfall chart in Excel (bridge chart)

This article looks at creating basic graphs and at a special chart type – the Waterfall chart in Excel. Read on to find out what a waterfall chart is and when you can find it useful. You'll learn what tools can help you with creating waterfall charts in Excel 2010 - 2013. 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

Older posts »