Excel Tips

Dear Friends,

Excel Tips and Tricks will probably not be able to make your work SUPER easy but it will definitely make you productive. In this Section we will be sharing small-small Tips and Tricks which can be used in our day-to-day life. Tips and Tricks must not always be related to Excel, it could be anything.

I am sure that we all know few Tips and Tricks which makes our day-to-day life easy. So let’s start sharing them and make a HUGE repository of Tips and Tricks.

Excel VBA Basics : All about Debugging Excel VBA code

Tags: , , , |

Dear All, Debugging VBA Code In Tutorial section for Beginners, I have written many basic articles like WHAT IS EXCEL MACRO, HOW TO [...]

Spreading data across Columns in Excel Without VBA Code

Tags: , , , |

In my previous article as you learnt how to split data using VBA SPLIT() function. In this Article I am going to explain you how [...]

Read and Write Document Properties of an excel Document – VBA

Tags: , , |

In this Article we will learn how to get document property of an excel workbook using Excel VBA. Before I jump in to the VBA [...]

Excel Trick – Sheet Protection – Protect it and Stay Free

Tags: , , , |

Dear Readers, I am back with another Excel Trick which is very much common while managing your sheet with certain security (protection). To protect the [...]

Excel Trick – SMART Method to make White Background

Tags: , , |

Dear Readers,   If you are a Microsoft Excel user then you must have come to a situation where you want to show you data [...]

Custom Formula to Reverse a String in Excel

Tags: , , , , |

Dear Friends,   This is a very small but useful Custom Function which can be used to reverse a string in excel. In VBA (Excel [...]

Excel VBA Tip – Expand / Collapse all the Groups in Excel

Tags: , |

Dear Readers, This is a small VBA tip to automate to expand or collapse groups created in Excel. Before I jump to VBA code about [...]

Things happening AUTOMATICALLY is WOW… but NOT ALWAYS

Tags: , , , |

Well friends before I start my article or tell you what I am going to talk about in this article, How many of you agree [...]

Spreading an Array values across Columns in Excel – VBA

Tags: , , , , |

All my avid readers from Computer Programming background must be thinking is it a big deal? Like other programming languages use loop to traverse all [...]

Excel Tip : How to save an Excel Addin (.xla) to Excel Workbook(.xls)

Tags: , , , , |

Hello Friends,   This is a small excel tip to convert a .xla or .xlam file to .xls or .xlsm file. This is a simple [...]