Excel tutorials, functions and advanced formula examples, page 2

May
24

Mean, median and mode in Excel

When analyzing numerical data, you may often be looking for some way to find the "typical" value. For this purpose, you can use one of the so-called measures of central tendency such as arithmetic mean, median or mode. Continue reading

May
19

How to calculate median in Excel

The median is one of the three main measures of central tendency, which is commonly used in statistics for finding the center of a data sample or population. Continue reading

May
16

Google Sheets IF function - usage and formula examples

Get to know Google Sheets IF function better with this tutorial: when is it used, how does it work and how it contributes to a much simpler data processing. Formula examples are included! Continue reading

May
10

How to insert picture in Excel: embed image into a cell, comment, header or footer

In this tutorial, we will look at how to insert image in Excel from your computer, OneDrive or from the web and how to lock a picture to a cell so that it adjusts and moves with the cell when the cell is resized, copied or moved. Continue reading

May
8

How to combine duplicate rows, merge values, and add subtotals in Google Sheets

Whether or not you're new to Google Sheets add-ons, you’ll love the news: now it takes three simple steps to combine duplicate rows and keep all unique information safe. Continue reading

May
3

How to convert Excel to JPG, PNG or GIF image

Whilst you can easily save an Excel file to many formats including PDF by using the standard Save As dialog, surprisingly, JPG is not in the list. Luckily, there exist a handful of different ways to convert .xls to .jpg, both desktop and online. Continue reading

Apr
26

How to align text in Excel

By default, Microsoft Excel aligns numbers to the bottom-right of cells and text to the bottom-left. However, you can easily change the default alignment or even align a column of numbers by a decimal point or a specific character. Continue reading

New Link Checker is out: the quickest way to fix broken links in your Word document

We are happy to introduce a new version of Link Checker for Microsoft Word! Now the add-in works faster and makes it easier to find the links, filter the results, and edit them instantly. And a nicer design will be the icing on the cake. Continue reading

Apr
18

Lookup in Excel: functions and formula examples

Looking up a specific value within a dataset is one of the most common tasks in Excel. And yet, there exists no "universal" lookup formula suited for all situations. In this tutorial, you will find an overview of the most popular Excel Lookup functions with formula examples and in-depth tutorials linked for your reference. Continue reading

Apr
12

How to add & subtract time in Excel to show over 24 hours, 60 minutes, 60 seconds

When subtracting and adding time in Excel, you may sometimes want to display the resulting time intervals over 24 hours in the hh:mm format, over 60 minutes in the mm:ss format, and over 60 seconds in the ss format. The task is a lot easier than it may sound, and you will know the solution in a moment. Continue reading

Excel add-ins and Outlook tools - Ablebits.com
Ultimate Suite for Excel Professionals
 
 
50+ 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 →