Posts Tagged 'Excel functions'

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
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

Jun
14

Basic Excel formulas & functions with examples

Being primarily designed as a spreadsheet program, Microsoft Excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems. This tutorial aims to teach you the essentials of Excel functions and show how to use basic formulas in Excel. Continue reading

Jun
7

How to square root in Excel: SQRT function and other ways

Squaring a number and finding a square root are very common operations if mathematics. But how do you do square root in Excel? Either by using the SQRT function or by raising a number to the power of 1/2. Continue reading

May
31

How to calculate standard deviation in Excel

In statistics, the arithmetic mean and standard deviation are two closely related concepts. But while the former is understood by most, the latter is comprehended by few. The aim of this tutorial is shed some light on what the standard deviation is and how to calculate it in Excel. Continue reading

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

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
5

Excel LOOKUP function with formula examples

There are a handful of different ways to look up and match in Excel. This tutorial discusses the LOOKUP function that is designed to handle the simplest cases of vertical and horizontal lookup. 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
 
 
Older posts →