Excel tutorials, functions and advanced formula examples, page 17

Converting PDF files (text and image) to Excel

The article explains how to export different PDF files to Excel manually or using free online converters, and how to choose the conversion method best suited for a given file type. Continue reading

How to convert numbers to text using Excel TEXT function and other options

This tutorial shows how to convert number to text in Excel 2016 - 2010. See how to accomplish the task with the Excel TEXT function and use number to string to specify the formatting. Learn how to change number format to text with the Format Cells… and Text to Columns options. Continue reading

How to convert Excel files to PDF

This short tutorial describes 4 possible ways to convert Excel files to PDF – by using Excel's Save As feature, Adobe software, online Excel to PDF converters and desktop tools. Continue reading

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

Count & Sum by Color - the first Ablebits add-in for MAC is out

Do you have add-ins for MAC? This is one of the most popular support requests we get almost every day. It took our developers a while to look into the possibilities to create apps that would work in Excel 2011. Finally, about a week ago we received the long-awaited "Ready for Sale" from the MAC support team and Count & Sum by Color was published. 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 - a 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

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

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

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard