Posts Tagged 'Excel tips'

Jul
26

How to flip data in Excel: reverse columns vertically and rows horizontally

Flipping data in Excel sounds like a trivial one-click task, but surprisingly there is no such option. In this tutorial, you will find a few quick ways to flip tables vertically and horizontally preserving the original formatting and formulas. Continue reading

Jul
19

How to create and use dynamic named range in Excel

If you are working with a continuously changing data set, you may want to make your named range dynamic so that it automatically expands to accommodate newly added data. In this tutorial, you will find detailed step-by-step guidance on how to do this. Continue reading

Jul
11

Excel named range - how to define and use names in Excel

Names in Excel are a paradoxical thing: being one of the most useful features, they are often considered pointless or nerdy. This tutorial will teach you different ways to create a named range in Excel to make your formulas much easier to write, read, and re-use. Continue reading

Jun
29

Excel calculations: automatic, manual, iterative

To be able to use Excel formulas efficiently, you need to understand how Microsoft Excel calculates them. Not less important are calculation settings that can speed up, slow down or even stop your Excel calculations as well as maintain their accuracy. Continue reading

Jun
21

How to do calculations in Excel

When it comes to calculations, there is almost noting that Microsoft Excel cannot do, from totaling a column of numbers to solving complex linear programming problems. Apart from that, you can use Excel as a calculator to do math - add, divide, multiply, and subtract numbers as well as raise to power and find roots. 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

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

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

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
 
 
Older posts →