Excel tutorials, functions and advanced formula examples, page 21
Install and use Template Phrases on Outlook 2013 Reading Pane
We have just released a new update for Template Phrases. Install the latest version and enjoy using it on the reading pane in Outlook 2013; check out the improved macros and bug fixes. Continue reading
Making a cascading (dependent) Excel drop down list
The tutorial demonstrates how to create cascading drop down lists in Excel that display choices depending on the value selected in a previous dropdown. Continue reading
Creating a drop down list in Excel: static, dynamic, from another workbook
The tutorial demonstrates 4 quick ways to create an Excel drop down list - based on a list of values, range of cells, named range and a dynamic dropdown. Continue reading
More tools added to Ultimate Suite for Excel
Our summer has been busy with developing 3 new tools for Ultimate Suite and with fixing some major and minor bugs. Now you can try the new add-ins for swapping, flipping, and transposing columns, rows, and cells in your table. Continue reading
How to insert new columns in Excel
This post looks at how to add up new columns in Excel 2010-2013. Read on to learn shortcuts to insert one or more columns, including nonadjacent ones. Grab and share a special VBA macros to automate adding every other column. Continue reading
Excel VLOOKUP not working - solutions for N/A, NAME and VALUE errors
The tutorial explains how you can quickly cope with VLOOKUP not working problems in Excel, troubleshoot and fix common errors and overcome VLOOKUP's limitations. Continue reading
How to remove rows in Excel based on a cell value
This article lists several ways to delete rows in Excel 2016, 2013, and 2010 based on a cell value. In this post you'll find hotkeys as well as Excel VBA. Delete rows automatically or use the standard Sort and Find options in combination with helpful shortcuts. Continue reading
4 ways to do a case-sensitive vlookup in Excel
The tutorial explains how to make Excel VLOOKUP case-sensitive, demonstrates a few other formulas that can look up case in Excel and points out strengths and limitations of each function. Continue reading
The new improved version of Template Phrases for Outlook is out!
We released a new version of Template Phrases for Outlook 2013-2003. Some major and minor bugs are fixed and new macros are added. Now the file with your templates is moved to a new storage base which largely improves Outlook memory usage. Read on to learn more. Continue reading
INDEX & MATCH in Excel - better alternative to VLOOKUP
This tutorial demonstrates the key strengths of Excel's INDEX / MATCH function that make it superior to VLOOKUP. You will find a number of formula examples that will help you easily cope with many complex tasks when VLOOKUP fails. Continue reading
Relative and absolute cell references in Excel conditional formatting rules
Invest a few minutes and learn how to correctly use relative and absolute cell references in Excel conditional formatting rules. This knowledge will certainly save you far more time in the long run. Continue reading
How to hide and group columns in Excel
This tutorial shows how to hide columns in Excel 2010-2016. You will see the standard Excel Hide columns functionality in action as well as learn to group and ungroup columns with Outline. Continue reading
How to use VLOOKUP & SUM or SUMIF functions in Excel
In this tutorial, you will find a handful of advanced formula examples that demonstrate how to use Excel's VLOOKUP and SUM or SUMIF functions to look up and sum values based on one or several criteria. Continue reading
How to unhide and show hidden columns in Excel
From this article, you'll learn how to unhide columns in Excel 2016 - 2007. 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
How to use VLOOKUP in Excel: advanced formula examples
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
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 2016, 2013. Continue reading
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
How to enable macros in Excel 2016, 2013, and 2010
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
How to insert page numbers in Excel
This article explains page numbering in Excel 2019, 2016, 2013 and lower. 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
Excel VLOOKUP tutorial for beginners with 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
