Let it be a beginner or an excel expert Excel Keyboard Shortcuts is one of the most interesting/ favorite part of any (every) user. Why? Why to learn Excel Keyboard Shortcuts The answer is pretty simple. For Multiple reasons. Makes work easier enabling you to work more fast and accurate in the excel environment there …
Excel Keyboard Shortcuts – Must Know – Improve Your Productivity And Efficiency Continue Reading »
Can we select and filter data with a single click in excel. As expected, the answer is YES. In this post let us see how to do it. Filter is one of the well-known and most widely used function in excel. The basic way filter operates is identifying the value from the multiple values in …
Filter Data with a Single Click – Excel Efficiency Tip Continue Reading »
In this post let’s see how to Change Column Name from Alphabets to Numbers in Excel. Need to Change Column Name from Alphabets to Numbers We know that in excel rows are numbered and columns are named alphabetically. (Know More about excel terminology). However, when using few formulae (like vlookup) where we need to refer …
How to Change Column Name from Alphabets to Numbers in Excel Continue Reading »
In this post let’s know about the OFFSET Function in excel. Also, the Syntax, how to use along with limitations and alternatives to OFFSET function. What is “OFFSET” Function in Excel OFFSET function returns the value of a cell/ range that is a specified number of rows and columns away from a cell or range …
Excel provides different types of count functions each of them suiting to different situations. As the name specifies these functions help to count the number of cells in a given range/ cells based on the specified criteria. Let us see what Count and CountA functions in excel are, syntax and how to use these functions. …
How to Use the COUNT and COUNTA functions in Excel Continue Reading »
Excel Tables is one of the powerful options that help to handle and organize large sets of data effectively. Organizing/ Formatting the data in a structured format always makes the user’s job much easier to manage the data. By converting raw data into tables you can use multiple options which makes work easier and saves …
Tables in Excel – Creating and Using Excel Tables – Complete Guide Continue Reading »
In this post let’s see how to understand complex formulae by adding a comment in the formula. Few days back I met Kiran, a Friend of Mine. He works as an Analyst in one of the MNC’s and moved to Hyderabad recently due to a project. While we were discussing things related to our Job …
