If you are familiar with MS Excel, and you want to speed up your work then these keyboard shortcuts will save you lots of time. And you will become a little expert in Excel. We have consolidated the most frequent Excel shortcuts that will help in your daily work or office work. Even if you […]
If you have used excel, you also probably used some excel formulas like sum, average, count, etc. But do you know that these formulas are pre-loaded functions in excel? Yes, these all are functions and you can also create your own functions in excel using VBA coding. Creating a function for you will be very […]
By this vba code, you can convert all text files available in a folder into excel version. This code is very simple, just put in your code window and you are done. Folder Location: C:\Source Folder\ Step 1: Open Excel and Press key Alt+F11. It will open Microsoft Visual Basic for Applications Window. Step 2: Go to Insert >> Module menu. […]
If you have multiple files in a folder with different names and you want to open only some of them, then this simple code will help you. All file names are mentioned in excel sheet1. You can also add some working tasks in the VBA code, so it will open the file and save it […]
Suppose you want to download files from single or multiple FTP directories to the local folder, then this code will help you. You can download all available files or particular files from the FTP folder. FTP Server Address: 203.55.32.44 FTP Folder Location: “/HOME/Data_Files/” and “/HOME/Data_New/” Local Folder Location: C:\Source Folder\FTP Files\ Step 1: Open Excel and Press the key Alt+F11. […]
Suppose you have an Excel Workbook with multiple sheets. If you want to hide all sheets except one active sheet then you can use this code. It is very easy to code. Just follow the below steps and you are done. Step 1: You have to open Visual Basic Editor in Excel. Press the key Alt+F11. Step […]
Here is a simple VBA macro code to run SQL Query from excel. And you can assign a command button to execute your query. Also, you can get the output of that query in your excel sheet very easily. So for example let the Server name as sql_server_name, the Database as database_name, and TableName as […]
I am sharing some very important SQL Commands at the beginner level. These commands are very common and useful in everyday office work if you are using SQL. So, I am sharing different types of commands with syntax. Basically, SQL is a Structured Query Language or you can say Standard Language for accessing and manipulating […]
This python script can merge multiple pdf files without any limitations. It is easy to use and can combine files in a short moment. If you have many pdf files and you want to merge them into one pdf. So, there are so many online websites and software tools that can merge pdf files into […]
This is a very useful script to unzip all zip files in a folder with a single click. You can also run this script from the batch file. With this python script code, you can unzip a single zip file and multiple zip files. And with small changes, you can either extract the files in […]