Blog

Formula Errors in Excel

If you are a person who use Excel a lot, you might have encountered with these Error Codes like #DIV/0!, #NAME?, #N/A, etc. Each of these error codes tell us something. It gives us information on how to troubleshoot an incorrect formula. Following are the most common Error codes in Excel and I will explain…

Different Methods to select Visible Cells only in Excel

In Excel, when we Copy-Paste from a dataset containing hidden rows, the hidden rows also get copied. In this blog post, we will see 3 different methods to select only the visible cells in Excel. Keyboard Shortcut Alt + ; is the shortcut to select visible cells in Excel. Select the cells and press Alt…

Copy and Paste into Visible cells in Excel

Filtered Rows and Hidden Rows In Excel, Rows that we hide manually and those Rows get hidden while applying Filters, work in different ways. When we copy-paste a value into the filtered cells they won’t be copied into the hidden cells. At the same time, if we hide some rows manually and copy-paste a value…

Different methods to Reverse a List in Excel

This article is about 3 different methods to Reverse a List in Excel. Following is a list of candidates applied for a job. Let’s see the different methods to reverse this list for scheduling the interview. 1. Reverse the list using a Helper column Create a helper column with sequential numbers (for example 1,2,3,..) adjacent…

Lesser-known Excel shortcuts

11 lesser-known, but pretty useful Keyboard Shortcuts in Excel are explained in this post. 1. Legacy shortcut for Creating Table Ctrl + T is a very popular Excel shortcut that is used to create Tables. But there is one more shortcut for creating a Table in Excel and that is Ctrl + L. Select the…

Connect Google Sheets to Excel

In this blog post, I will explain the step by step procedure to Connect Google Sheets with Excel using Power Query. Once a spreadsheet in Google Sheets is connected with an Excel file, the changes made in the Source (Google Sheet) will be reflected in the Excel file at the expense of a single mouse…

Microsoft Word Tips & Tricks

In this blog post, I will walk you through the Top 25 Tips & Tricks in Microsoft Word. 1. Insert Date and Time Alt + Shift + D is the shortcut for inserting Current Date into a word document. Similarly, Current Time can be inserted into a document using the shortcut, Alt + Shift +…

How to Connect Excel Tables

How to build Relationships between Excel Tables using the Data Model of Excel is explained in this Tutorial. Purpose of connecting Tables VLOOKUP and INDEX+MATCH formulas always get the job done, but a lot of them will essentially slow down the workbook. Moreover, the Lookup and Reference formulas also demands maintenance with addition or deletion…

Import Text from Excel to AutoCAD

In this blog post, I will explain about an ‘Excel formula’ that can be used to ‘Import Text from Excel to AutoCAD’. Suppose you have some data like the following that needs to be inserted into AutoCAD. The texts to be inserted into AutoCAD are in the column C and the X,Y Co-ordinates of the…

STOCKHISTORY Function (Beta) in Excel

In the second week of June 2020, Microsoft introduced a new Excel Function called STOCKHISTORY, with which we can pull the Historical data of Stocks Prices and Currency exchange rates into an Excel worksheet. Note: At present, STOCKHISTORY function is available only to the 50% of Microsoft 365 Subscribers in the Beta level of the Office…