• June 7, 2023
  •  

Create Clock in Your PC Using Batch File Script

You can make digital clock on your PC just using this simple batch file code.  You can save this script in any folder and execute. Below is the step-by-step guide to let you create your batch file. Step 1: Open Notepad in your system. Step 2: Copy the below code in Notepad: 1234567891011121314151617@echo off Title […]

Read More
excel-shortcut-keys-beginner-simplemsoffice

Excel Shortcut Keys for Beginner and Advanced

In this post, we are providing shortcut keys that can be used in your daily office work, especially in Excel Work. You can save lots of time by using these keys. Some of them you may already be aware of. These shortcut keys can be used for Formatting, Working with Workbooks, Calculation, and Special Symbols […]

Read More

Interview Questions on Power BI – Vol 1

Power BI has become a powerful business intelligence tool nowadays and many companies prefer this BI tool because of its visualization and performance. And this is a Microsoft product so this tool is highly compatible with Microsoft Excel, Power Query, and SQL. So this series of questions and answers is dedicated to helping aspirants. And […]

Read More
microsoft-powerpoint-shortcut-keys-simplemsoffice

Microsoft Power Point Shortcut Keys

If you are working with Microsoft Office PowerPoint then these shortcut keys will surely save you time. Shortcut keys always help you work to do fast.  Read: Microsoft Word Shortcut Keys Read: Microsoft Excel Shortcut Keys We have consolidated the most frequent MS PowerPoint shortcuts that will help in your daily work or office work. […]

Read More
microsoft-word-shortcut-keys-simplemsoffice

Microsoft Word Shortcut Keys

Shortcut keys always help you work to do fast. If you are familiar with MS Word, and you want to speed up your work then these keyboard shortcuts will save you lots of time. And you will become a little bit expert in Word. We have consolidated the most frequent MS Word shortcuts that will […]

Read More
microsoft-excel-shortcut-keys-simplemsoffice

Microsoft Excel Shortcut Keys

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 […]

Read More
create-function-in-vba-simplemsoffice

How to Create Function in Excel VBA

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 […]

Read More
convert-text-files-into-excel-using-vb-simplemsoffice

How to Convert Text Files into Excel Using VBA Script

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. […]

Read More
open-files-from-excel-list-using-vba-simplemsoffice

How to Open Files From Excel List Using VBA Script

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 […]

Read More
copy-files-from-ftp-location-using-vba-simplemsoffice

Copy Files From FTP Location Using VBA Script

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. […]

Read More