Excel tutorials, functions and advanced formula examples

Jul
22

Merge two or multiple cells in Excel without losing data

The tutorial demonstrates different techniques to quickly merge two cells in Excel and combine multiple cells without losing data in Excel 2016, 2013, 2010 and lower. Continue reading

Jul
15

CONCATENATE in Excel: combine text strings, cells and columns

In this tutorial, you will learn various ways to concatenate text strings, cells, ranges, columns and rows in Excel using the CONCATENATE function and "&" operator. Continue reading

Jul
8

Excel random number generator - how to use RAND and RANDBETWEEN functions

The tutorial explains the specificities of the Excel random number generator algorithm and demonstrates how to use RAND and RANDBETWEEN functions in Excel to generate random numbers, dates, passwords and other text strings. Continue reading

Jul
1

How to convert time to decimal number, hours, minutes or seconds in Excel

The tutorial demonstrates different ways to convert time to decimal in Excel. You will find a variety of formulas to change time to hours, minutes or seconds as well as convert text to time and vice versa. Continue reading

Jun
24

How to calculate time in Excel - time difference, adding / subtracting times

The tutorial explains different ways to calculate times in Excel and demonstrates several methods of adding times and calculating time difference. You will learn a few useful formulas to sum times and add hours, minutes or seconds to a given time. Continue reading

Jun
23

Excel time format & how to use NOW and TIME functions to insert time

In this tutorial, you will learn the specificities of Excel time format as well as how to add a timestamp using shortcuts or insert updatable current time using the NOW function. You will also learn how to apply special Excel time functions to get hours, minutes or seconds from a time stamp. Continue reading

Jun
11

Beyond Spelling and Grammar Check

In this guest post, Daniel Heuman of Intelligent Editing, explains how you can use PerfectIt to take the proofreading capabilities of MS Word to an entirely new level. Continue reading

Jun
10

Excel date functions - formula examples of DATE, TODAY, etc.

This is the final part of our Excel Date Tutorial that offers an overview of all Excel date functions, explains their basic uses and provides lots of formula examples. Continue reading

Jun
3

Download Ultimate Suite 2016 BETA

Since Microsoft released Excel 2016 and Windows 10 Preview, we have been in a hurry to support them. Thus we are happy to report that we have just released an update of our flagship product Ultimate Suite for Microsoft Excel. … Continue reading

Jun
3

Using DATE function in Excel - formula examples to calculate dates

The tutorial explains the syntax and uses of the Excel DATE function and provides formula examples for calculating dates. Continue reading

Older posts →