Excel tutorials, functions and advanced formula examples, page 2

Oct
5

How to capitalize first letter in Excel cells

How can we change the case of the first letter from lower to upper in Excel cells? Do we have to type each character manually into every cell? Not anymore! Today I will share three methods of capitalizing first letters in your table. Continue reading

Oct
4

How to multiply cells in Excel with formula examples

This tutorial shows how to use the multiplication operator in Excel and how to write a formula to multiply cells, columns and rows, numbers and percentages, and more. Continue reading

Oct
3

How to add, edit and delete checkboxes and drop-down lists in Google Sheets

When you work with Google spreadsheet, sooner or later you might need to use some functionality that you've never used before. Checkboxes and drop-downs can quickly turn out to be such features. Let's see how useful they can be in Google Sheets. Continue reading

Sep
27

Excel IFERROR function with formula examples

"Give me a formula, and I shall make it return an error," an Excel user would say. In this tutorial, we won't be looking at how to return errors in Excel, we'd rather learn how to prevent them in order to keep your worksheets clean and your formulas transparent. Continue reading

Sep
20

Excel TODAY function to insert today's date and more

You want to put today's date in some cell? Or you wish to highlight the current date in your Excel calendar? Or you'd like to find the date closest to today? All this can be done by using the Excel TODAY function and this tutorial will teach you how. Continue reading

Sep
13

Excel MOD function to get remainder and more

The Excel MOD function is designed to get the division remainder, but it can do much more than its original purpose. In this tutorial, you will find a few non-trivial uses of MOD in Excel that may prove useful in your worksheets. Continue reading

Sep
7

How to work with conditional formatting in Google Sheets

Highlighting certain data with color is a great way to draw attention to the records. Wouldn’t it be great if such format change happened automatically for specific cells? This is where conditional formatting comes in handy. Google Sheets can do this work for us, all we need is to explain what we want to get. Continue reading

Sep
6

Excel RANK functions with formula examples

When you need to determine the relative position of a number in a list of numbers, the easiest way is to sort the numbers in ascending or descending order. If for some reason sorting is not possible, the Excel RANK function is the perfect tool to do the job. Continue reading

Aug
24

Back to Basics: edit and comment on data, review the changes, print and download from Google Sheets. Even offline

We continue our "Back to Basics" journey by digging deeper into editing Google Sheets. Today, in addition to learning some simple features like formatting and deleting the data, we’ll discuss how to add comments and notes, work offline, and quickly review all the changes made to the file. Continue reading

Aug
17

Back to Basics: sharing, moving and protecting the data in Google Sheets

Moving on to another stop of our "Back to Basics" journey, today I will tell you more about managing your sheets. Learn how to share, move and protect your data in Google Sheets. Continue reading

Excel add-ins and Outlook tools - Ablebits.com
Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-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
 
 
← Newer posts
 
Older posts →