# Text Functions In Excel – MS Excel Functions Tutorial Part 4

In previous post we learnt mathematical functions in excel. In this post, we will learn Text Functions in Excel. Introduction To Excel Formulas & Functions Inserting Formula, Function & Named Range In Excel Mathematical Functions In Excel Text Functions In Continue reading

# Mathematical Functions In Excel – MS Excel Functions Tutorial Part 3

In previous posts, we learnt what are excel functions and formulas and how to insert formulas, functions and named ranges in excel. In this post, we will focus on Mathematical Functions in Excel. Introduction To Excel Formulas & Functions Inserting Continue reading

# Inserting Formula, Function & Named Range In Excel – MS Excel Functions Tutorial Part 2

In previous post, we learnt what are excel functions and formulas and what is the difference between these two. In this post, we will learn how to insert functions and formulas in Excel. We will also learn about Named Ranges Continue reading

# Introduction To Excel Formulas & Functions – MS Excel Functions Tutorial Part 1

Every day we perform countless calculations at our workplaces. Imagine how difficult it will be to perform all the calculations manually. Thanks to our calculators! But what if we have a large dataset and need to perform important and lengthy Continue reading

# 21 Ready To Use Free Excel Macros

We have been writing Excel Macros for quite a while now and we figured out they are absolutely necessary to reduce time & efforts. Most importantly, when there is a repetitive job to be done, Excel Macros come very handy. Continue reading

Applications like Microsoft Word, Power Point, PDFs – all have option to create Table Of Contents. Well, Excel is an excellent tool – why shouldn’t it have a table of contents too? There are instances when you have lot many Continue reading

# Macro To Delete Blank Columns In Excel WorkSheet

Earlier we shared an Excel Macro to delete blank rows from Excel WorkSheet. We thought an excel macro to delete blank columns should be as useful as the previous one was. Of course it is a tedious job to scroll Continue reading

# Useful Applications Of Conditional Formatting In Excel – MS Excel Conditional Formatting Tutorial Part 5

Well, so far we have learnt a lot about conditional formatting through various examples and in this last tutorial on Conditional Formatting, we will learn see how conditional formatting is used in real world – you must trust us, it’s Continue reading

# In-built Conditional Formatting Rules In Excel – MS Excel Conditional Formatting Tutorial Part 3

So, we learnt about applying conditional formatting to highlight cells based on criteria in previous post, in this post we will explore the conditional formatting option in greater detail. Introduction To Conditional Formatting In Excel How To Apply Conditional Formatting Continue reading

# How To Apply Conditional Formatting In Excel – MS Excel Conditional Formatting Tutorial Part 2

In previous post, we learnt about why do we need conditional formatting and types of conditional formatting (Part 1). In this tutorial, we will learn how to apply conditional formatting. Introduction To Conditional Formatting In Excel How To Apply Conditional Continue reading