Master Excel Macros, Outlook VBA, Python scripts, Formulas, and Office tricks with over 500 free step-by-step guides.
Save Web Page as PDF from Chrome, Edge or Firefox? This method of saving a webpage to PDF has been tested in Chrome & Edge. But, we assume that these are the sa...
How to Calculate Net Run Rate (NRR) - IPL Points Table? The direct formula to calculate Net Run Rate is given below: 1. NRR = RRF - RRA RRF - Run Rate For RRA -...
How to Replace #N/A error in Excel Formula & Vlookup? In many of the Excel formula, we get #N/A as return value. Espcially we get this quite often in Vlookup fo...
VBA Code to Sort Outlook Emails by Date In Outlook app, when you are viewing the mails in any folder, You have option to Sort them based on Received date/time, ...
WhatsApp Latest Update Here is a very good news for all those who are using Whatsapp Web. Whatsapp Web: Obviously most people know what it is. It is an option t...
Add Google Sheets Drop Down List Here are the steps to create a drop down list in Google sheets. We will be using the data validation built in option to do this...
Delete a Drop down data valition list in Excel A drop down list in Excel also has another term "Data valiation list". These drop down lists usually has a list o...
How to unhide all sheets in Excel using VBA code? To unhide all sheets in Excel, if you would like to set it manually, then refer to the image at end of this pa...
Make VBA Userform to Close with Escape Key Usually developers add a command button to close or exit a userform. Sometimes, if the end user is going to close the...
Word Document Password Protection - 2 most used Methods Yes, there are more than one methods available to password protect a Word document. And it confused the ...
Get all Digits or Numbers within a String If you want to extract all the digits present in alphanueric string like "alpha123how23its98done", use this function. ...
How to send/view SMS in PC? A recent update from Android enables us to check the SMS messages from within a web browser. Also, we can send new SMS messages. Tho...
How to send Whatsapp Message without saving Number? Use the option mentioned in this page to send Whatsapp message without saving number your mobile contacts. O...
Happy New Year 2022 - Holidays List This page, not only list 2022 holidays USA, but also: You get the details of long weekends & plan your vacation accordingly ...
India 2022 Holiday List with Long weekend vacation plans Here is the list of holidays for the year 2022 along with number of holidays on weekdays. And also a sp...
VBA Loads a XML file into a Excel Sheet An XML file is like a simple text file but structured in a predefined format using tags. Sometimes you need to view an X...
Finding an existing file & its path using Excel VBA When writing Excel VBA code that works with external files like XML or JSON, it is important that you have c...
How to convert a range of Cell in Excel to Image file? The following VBA code is a User Defined Function (UDF) that can save a group of continuous cells as a JP...
Finding last row or column in a worksheet using VBA Do you want to find out the last nonempty cell in both vertical (row) and horizontal (column) direction. You...
VBA Code to Delete Signature from Outlook Email When automating email from Outlook, You might want to delete the signature that got added autoamtically. So, tha...
Find how many dimensions an Array has? We use array to store multiple values under same variable name. This array can be a simple one dimensional array or multi...
Why Crypto currency markets are down today? Date: 11-Nov-2021 (Wednesday) Here are few possible reasons for recent Crypto currency market crash. 1. China crackd...
VBA - Userform Combobox In userform, we can have a combobox to display list of items as dropdown. User will be able to choose one of the items from this list. T...
Get Youtube link with Time Parameter (Android/PC) To timespamp a video url or to get the Youtube video link URL with current time, you can use one of these meth...
A. Insert Numbers with Leading Zeroes in Excel To add leading zeroes in Excel to a number, use one of these methods. But before using one of these methods, you ...
Actually Its Better than Adsense If you are already a owner of a website or blog and you are looking to increase your revenue, then this article is for you. All...
Schedule Excel VBA Macro to Run Daily Automatic VBA Macro is used to automate lot of repeated tasks in Ms Office applications like Excel, Access, Outlook, Power...
How to run a macro from another workbook? It is possible to run a macro present in a workbook to be execued from another workbook. To do this, we need the follo...
Export VCF to Excel using Google Account To convert Export VCF to Excel use your Google account and follow these simple steps. This will guide you to import the...
How to change Text encoding from ANSI to UTF8? If there are multiple txt files or programatically you need to change the encoding of a file from ANSI to UTF8 or...
Excel VBA to Automate Chrome using Selenium In this topic we will learn how to install Selenium library in Windows PC & initiate Chrome browser. Selenium is a f...
How to Upgrade Windows 10 to 11? Here are the simple steps to upgrade your Windows 10 OS to Windows 11 version. Before upgrading please check from this link for...
Hiding Icons in Windows 10 desktop Many users keep all frequently used files, folder shortcuts in desktop. Some time the desktop even gets filled in with so man...
Windows 10 - Weather Taskbar - Remove/Add option In Windows 10, this weather widget is available in taskbar by default for many users. Windows 10 Weather Foreca...
Bluestacks - Adroid Emulator - Install APK, Apps & Games in PC Bluestacks is an Android emulator app taht enables a Android developer to test their app or game ...
Enable Windows 10 Search box To quickly make Search Box/Bar visible in Windows 10, follow these eacy steps. Right Click on Taskbar Choose Search Enable Search b...
How to open VBA code or Macro code in an Excel file? You will be able to open VBA (Visual Basic for Applications) code written within a Excel file using any of ...
Dos Command for Current logged in username Get the CLI (command line interface) function for finding current logged in username in different operating systems i...
Worksheet Name & CodeName In Excel, the worksheets will have two names. One is like its caption & other is object Name. In the VB editor, in project explorer (C...
How to convert Python program to Exe file? Though there are different options to convert Python to Exe file, I prefer PyInstaller. It converts Python program to...
Wired Equivalent Privacy (WEP) WEP is a security algorithm for IEEE 802.11 wireless networks. It was introduced with the original 802.11 standards ratified in 1...
Booting process of the Linux operating system The following are the 6 high level stages of a typical Linux boot process: BIOS (Basic Input/Output System): The B...
Defer and Async attributes in JavaScript, they both are boolean attributes these attributes are used with script tags to load the external JavaScript file effic...
Daemon thread in java: Daemon thread is a low priority thread providing services to the user thread. This thread runs in the background to perform tasks such as...
You might have seen many websites detecting your browser and displaying the details of your browser on the web pages or checking the version of the browser to t...
Blockchain : A blockchain is a digital, distributed ledger of all the transactions made in the system. It is open to anyone. The information is transferred to a...
What is a Honeypot? A honeypot is a system that is network-attached and is deployed as a decoy to lure cyber attackers and to find, change or study hacking proc...
Nowadays every websites is dynamic in nature. Websites has the capability to To retrieve data from database in PHP Using MYSQL from a remote server. It fetches ...
What is localStorage in javascript? The local storage is the storage location provided by the browser and that allows us to store key/value pairs in a web brows...
What is sessionStorage? sessionStorage is an object for the current session much like the localStorage , sessionStorage can also store data in the memory of the...
What is AJAX? AJAX stands for asynchronous javascript and xml. It is a technique where we can request data from the server without reloading the entire page, it...
Stack is a linear data structure ( an abstract data type ) with a fixed capacity. Linear data structure which is simple to use and allows adding and removing el...
Network Programming The term network programming refers to writing programs that execute across multiple devices (computers), in which the devices are all conne...
What is DAX? DAX stands for D ata A nalysis e X pressions and is the language behind Power BI. DAX is a formula expression language used in Analysis Services, P...
Introduction The development of personal computers brought about tremendous changes in business, industries, science & education. Business today relies on compu...
Network Programming with Java Sockets The java.net package of the J2SE API contains a collection of classes and interfaces that provide the low-level communicat...
In today's world, the data sets we have is huge and we can have so many criteria to be followed on the data For Example: Sum Average etc. Let us say we have N p...
Indexed sequential access file combines both sequential file and direct access file organization. In indexed sequential access files, records are stored randoml...
Files The file is a collection of records related to each other. The file size is limited by the size of the memory and storage medium. There are two important ...
Introduction The Dynamic Host Configuration Protocol is also known as DHCP , It is a network management protocol used on Internet Protocol(IP) , wherein Dynamic...
What are Transactions in DBMS? A small unit of a program that contains several low level tasks are called Transactions. Basic Concept of transaction : A transac...
A shell script is a computer program designed to be run by the Unix/Linux shell. A shell is a command-line interpreter and typical operations performed by shell...
IPL Qualification Criteria for Mumbai Indians Vs SRH This page has the details calculation & scenario for Mumbai Indians to qualify for IPL Play offs round. Sin...
SQL commands: SQL commands are the instructions, given to a database to perofrm some functions and tasks there are also called queries, these commands or rather...
DIPL2020 Points Table - Season 13 - Dubai Let's see how the points table stands now. Pos Team Pld Won Lost Tied N/R Net RR Pts Q Mumbai Indians MI 14 9 5 0 0 1....
The word polymorphism means having many forms. This feature of object-oriented programming allows us to perform a single action in different ways. In other word...
IPL 2021 Points table Note: Dream 11 - IPL 13 2020 Points Table IPL13 is proving to be tougher than any other season. New teams are coming up at the top of the ...
What is DBMS? DBMS stands for Database Management System which is a software used to manage databases. For Example, MySQL, Oracle, etc. are some of the popular ...
Singly Linked List is the list that holds the links to the next node and so on, each node points to the next node, but the main drawback is it does not point to...
A Queue is a linear data structure, following a particular order FIFO (First In First Out) where we can insert elements at one end and remove elements in the ot...
Garbage Collection in Java Garbage Collection means and as the name implies freeing up of space by the waste objects or garbage to avoid memory leaks. Since obj...
Detect Sheet Protection Whenever working with a worksheet ever wondered why some menu buttons are not working or ribbon icons are greyed out and no functionalit...
Queue Interface: The Queue Interface in Java Collections provide functionality as a Queue in the real-life, it extends the collections interface. It represents ...
What is a LET function in Excel? The LET function in excel is used to assign the name of the calculations of the result. This allows storing of intermediate res...
Similar to Arrays in java Linked List is also a Linear data structure. In Linked List unlike arrays elements are not stored in a contiguous locations and they a...
Maximum SubArray Sum is the problem of finding the sum of contiguous subarray elements with in an array of numbers form arr[1...n] You might ask what is a subar...
What is Two pointer technique? A two pointer technique is a technique where given a sorted array we have two starting points or two points of consideration as t...
What is Collections Framework in Java? In Java collection is an object that represents a group of objects (such as the classic Vector class). A Collections fram...
ArrayList class is based on the List Interface in java which is based on array data structure. ArrayList is widely used for its functionality and flexibility it...
A regular expression (shortened as regex ) is an extremely useful way of matching common patterns and texts such as emails, phone numbers, URLs etc. almost all ...
The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined....
The Intersect method is used to Returns a Range object that represents the rectangular intersection of two or more ranges. If one or more ranges from a differen...
Functional programming techniques can help in making code easier to understand at a glance and read and test, Functional programming has been making quite a spl...
Random texts are a great, they can be used as the filler texts where you want to show representational text. Or we can generate random text to use as password g...
What is Ethereum? Ethereum is an open source, globally decentralized computing infrastructure that executes programs called smart contracts . Ethereum uses a bl...
VBA code to convert html to plain text, this helps us to make the html code readable by stripping all the html tags from the html code and printing/rendering th...
When we make a form for others to fill out it is helpful to have some tips to let them know what the cell represent so that they fill out the correct details in...
How to hide/Unhide Sheet Tabs in Excel? By default Excel displays the tabs at left hand side bottom. Using this Users can navigate to any worksheet present in t...
How to Set No or Cancel as default Msgbox button? In Msgbox with YesNo or OkCancel buttons, the first button will be set as default button. i.e., once the messa...
Array in JavaScript Arrays are variables that can store ordered collection of values in them which can be of different data types, with each having a numeric po...
[VBA] Read Drop Down List Values Add a data validation drop down list as explained in this page . Skip this step if there is already a validation created in the...
How to enable JavaScript in different browsers? JavaScript should be enabled in the browser if a website has functionalities implemented in js. For example, HTM...
How to Remove DropDown box in Excel & VBA? If you know the cell address that you are going to delete, then it is easy. But there are times, where we might want ...
List Files in Folder using Excel VBA To get list of files in a directory, just give the folder path as input to this function. It will read the file in the fold...
JavaScript to Remove Element in Array JavaScript arrays are variables that can store ordered collection of values in them which can be of different datatypes, w...
1. How to Remove #N/A error in Excel Formula & Vlookup NA Errors? To remove #N/A error, first You should find a way to detect it within the Excel formula. Unfor...
How to add Data validation drop down list in Excel VBA? Two different methods to create drop down list are explained here - but all are related to validation li...
Display HTML Code in Wordpress Post In Wordpress posts if we write any HTML codes in Text editor, the code will not be displayed. Instead of code, Wordpress, se...
This page explains how to save a word document to PDF using: VBA Code PDF Converter Manually Save Word as PDF Both the methods are simple & straight forward. Le...
HTML Form - Email Validation with JavaScript Email validation is very important in HTML forms. Here we have discussed how to validate email addresses using Java...
Fiverr - Microjobs Posting Platform If you are looking to hire quality expert to get your job done, Fiverr is right choice. Either you can post Job details with...
IPL Teams & Franchises County cricket was never this famous in India before IPL. Currently, 8 teams will play the 13th edition of IPL T20 tournament, which star...
Is Excel File already Open - Check in VBA? While opening a Excel file or be it any file with VBA, You may need to check if it is already opened by another user ...
Delete Folder using Excel VBA Macro This Excel VBA code will get folder path as input, check if it exists. Then it will delete if it exists. Important Note: Do ...
How to upgrade Windows 7 to Windows 10? Microsoft Windows 7 official support has ended on January 14 2010. More users are rushing up to upgrade to Windows 10. I...
User Input Msgbox with Yes No Cancel Some time the VBA code has to get approval from user with Yes/No/Cancel optop. Here is the simple code snippet that get the...
PHP to verify if a File exists in Directory In PHP, to check if a file exists in a folder path - use the function: ' file_exists '. Syntax: file_exists ('filepa...
How to check if a file exists in path using Python? There are 2 functions available in Python to check this directly using os.path. Try the below Python code sn...
Excel VBA Macro to Copy File This page explains about 2 options to do file copy using Vba. CopyFile option from FileSystemObject VBA.Filecopy The first one has ...
Enroll for WhatsApp Beta Tester in Play Store These are steps to become a beta tester for Whatsapp or any app in Android Play store. Open Play Store Search What...
Download WhatsApp Beta version apk You can download the latest version of Whatsapp apk from Play store, if you have enrolled as beta tester. How to join as Beta...
How to send image with original quality in Whatsapp? Follow these steps to send images to your friends with original quality in Whatsapp Messenger. Open Whatsap...
Extract Files from Zip Archive to Folder - Unzip in Python This Python code will extract or unzip all the files in a Zip file. All files in the zipped archive w...
Checking WhatsApp Version Here are the steps to check what version of WhatsApp is installed in your smartphone. Open WhatsApp Messenger. Click on options (3 dot...
What are these 2 Latest updates from WhatsApp? Not sure how many know that these 2 latest updates are available in their WhatsApp messenger latest version (2.20...
Chennai Super Kings or CSK is one of the most consistent performing teams in IPL. Along with Captain Dhoni & few unchanged players right from the start of IPL, ...
Delhi capitals match schedule IPL 2020 Date Time Day Team1 Team2 Venue 30-Mar 8 PM Mon DC KXIP Delhi 3-Apr 8 PM Fri KKR DC Kolkata 5-Apr 8 PM Sun RR DC Guwahati...
Kings XI Punjab Team Squad Date Time Day Team1 Team2 Venue 30-Mar 8 PM Mon DC KXIP Delhi 4-Apr 8 PM Sat KXIP SRH Punjab 8-Apr 8 PM Wed KXIP MI Punjab 11-Apr 8 P...
Kolkata Knight Riders Schedule Date Time Day Team1 Team2 Venue 31-Mar 8 PM Tue RCB KKR Bengaluru 3-Apr 8 PM Fri KKR DC Kolkata 6-Apr 8 PM Mon KKR CSK Kolkata 9-...
Mumbai Indians Team Schedule Date Time Day Team1 Team2 Venue 29-Mar 8 PM Sun CSK MI Mumbai 1-Apr 8 PM Wed SRH MI Hyderabad 5-Apr 4 PM Sun MI RCB Mumbai 8-Apr 8 ...
Rajasthan Royals schedule IPL 2020 Date Time Day Team1 Team2 Venue 2-Apr 8 PM Thu CSK RR Chennai 5-Apr 8 PM Sun RR DC Guwahati 9-Apr 8 PM Thu RR KKR Guwahati 12...
Royal Challengers Bangalore schedule IPL 2020 Date Time Day Team1 Team2 Venue 31-Mar 8 PM Tue RCB KKR Bengaluru 5-Apr 4 PM Sun MI RCB Mumbai 7-Apr 8 PM Tue RCB ...
SunRisers Hyderabad (SRH) Sunrisers Hyderabad was established in 2012 by Kalanithi Maran of SUN Network. It was included in the IPL after Deccan Chargers (found...
Export Excel Range to Image (jpg/png/gif) using Vba? This code ill convert the data in Excel workbook into a jpg image file as how it is displayed on screen. Th...
[VBA] Change Selection - Update Drop Down List in Excel This does not require any special code. It can be done just by changing the value in the particular cell...
Python - Weather Report for any City There is a similar article to this in which the weather report is obtained using Excel Vba code . To use this open weatherm...
City Weather Report in Excel Excel Vba code in this page gets current local weather report using free api from openweathermap. To use this code, you need these ...
Excel Macro - Create 1D Array from Vba Array This is one of the easy methods to initialize an array . If you convert data in worksheet directly to vba array, th...
VBA Array Sort - Using Excel Sort In this page, we have given a Excel vba code snippet that works well for sorting array of 1 dimension. You can also customize ...
Sort Function in Python Code In Python, You can sort a list or array of numbers & strings using the built in function. The code below creates a numeric & string...
How to Initialize an Array in Vba? Different methods to assign values to array are explained here. Starting from basic to few easy methods to initialize array w...
How to add new item to existing array? In VBA, an array is always an fixed size of data values. If you have to add new item, then size of the field also has to ...
How to find Your VBA Version? The below code will get the VBA version detail using pre-compiler directives. We cannot display the value in thee variables. But i...
Activate Night Mode for Excel Here is the easy method to enable dark mode in Excel & other MS Office applications. Click 'File' in Menu. Select 'Account'. Choos...
Activate Windows 10 Dark Mode Steps to enable dark mode in Windows 10 operating system is given below: Click Windows Start (Left bottom corner Windows icon) Sel...
Enable Google Chrome Dark mode in Desktop/Android In Google Chrome, Dark Mode is not an explicit option. It is burried in advanced options. You can tweak advanc...
Firefox - Dark Mode - Desktop The night mode can be enabled in Firefox using the below option directly. Open Firefox browser Click on Settings (Burger icon on t...
Appointment/Meeting Invites using VBA In addition to handling Emails, MS Outlook application also handles calendar appointments & meeting invites. All these ite...
Select & Copy Only Visible Cells in Excel In Excel, a row or column may be hidden when we use auto-filter option or manually hide them. Add an auto-filter over ...
What is my Public IP Address? There are no direct methods to get public ip address in VBA. This has to be done by using a web service using below steps: Open IE...
Verify Email Address Format in VBA Code in this page will verify if a email id is in proper format. This code uses regex pattern matching. To do this, first You...
VBA - Find Temporary Folder Path To save any intermediate data files, instead of creating a folder, You can use system default temporary folders. This way, ther...
How To Save Word Document as PDF? PDF refers to “Portable Document Format”. In order to avoid copying or alteration of information by the third party or unautho...
Create Excel file copy with Date & Timestamp in Vba In Vba we can access files & create new files. While doing such file operations, You may have to save a data...
[show_ip] This page displays the public IP address assigned to your computer. This shows the IPV4 address. To view IPV6, open command prompt & use the command i...
Get VBA Code to Convert Excel to Xml Vba code in this page reads table data by each row and adds it to Xml dom element. Once all the cell values are added, it i...
Citizenship Act & CAA 2019 This article does not present any views about the latest Amendment to Citizenship Act 1955. But we have provided the links where the ...
VBA code to create Outlook email This code will create a new email item in Outlook. Using this code, You can automate creating emails in Outlook application. Al...
Computer IP Address - Local & Public IP stand for Internet Protocol address. It is assigned to every network device - be in a computer, smartphone, router etc.,...
VBA Code to Zip File or Folder Just like this vba code, this also uses the Windows default file compressor. There is only one difference between this code and U...
Extract Zip - Unzip files with VBA To extract Zip file content, You can use windows default "Compressed (Zipped) Folder" application. There is no inbuilt object...
How to get Last day of Month? Excel has many option to find this End of Month. But in this page, We have given only the direct method. In Excel this formula can...
Dictionary Object - Accessing all Keys & Items In this article, You can get code to access a Dictionary object key & item in a loop. There are 5 different metho...
Excel VBA Scripting.Dictionary "Dictionary" is a datatype similar to an array, but in addition it can hold a group of variable or objects. Another available dat...
Delayed Delivery Option in Gmail - Schedule Emails When running in a chronic life where forgetting becomes daily bread for the populace, it is always important ...
VBA Code to Find My Documents Folder Path This code will get the folder path directly pointing to the 'Documents" folder. Using this code, the documents folder ...
How to Rename a file with Excel VBA? To rename a file with VBA, use the function mentioned below. Usually, You can find a lot of function used in VBA under the ...
How to Make VBA to Wait for Few Seconds? Sometimes You have to make code execution to halt (vba wait time) for few minutes. This happens when VBA code has depen...
How to Combine Sheets from Multiple Excel to One? This flexible Excel app in this page will merge Worksheets from multiple Excel files to one file. The User get...
Recall Sent Mail in Gmail In the busy agile world everything happens so quick with no time. Mistakes also happen as quick as life. There is no time to regret in...
Google Photos does not provide unlimited space for photo uploads by default. User has to choose the options explained below during upload or later as explained ...
Clear Excel VBA Immediate Window Manually There is no explicit option to clear immediate window. Just select all content in Immediate window using control + A, ...
Google Photos - Shared Album Link not working You created an album & sharing it with Your friend using the URL or by directly adding them from contacts. But, Yo...
VBA Code to Check if Sheet with Name exists? This Excel vba code will check if sheet with a specific name exists in the workbook. As per Microsoft specification...
Custom Order or Alphabetical Order This page has VBA code that can arrange worksheets in a Excel file in: Custom Order as per user preference Alphabetic Order o...
How to Store Notepad & Sticky Notes Online? We use Windows Notepad App or Sticky notes app so much extensively. It is easy to store easy reference text data in ...
Comment Block & Uncomment Block In VBA to comment a multiple lines of code with single step: There is no keyboard short available commenting. But VBA editor has...
What is actually Facebook hacker cup? The Facebook Hacker Cup is an annual worldwide programming competition. Hackers from all over the globe, compete against e...
Aren’t these words curious & interesting? State = Taste Bored = Robed Save = Vase Angel = Glean Stressed = Desserts What are these called? These are the Anagram...
VBA code to delete all #N/A error in Excel #N/A error can occur as a return code from any Excel formula like Vlookup, Lookup etc., If you copy paste data only f...
How to Click Hyperlink in Excel with VBA Macro? There are 2 methods available to click a hyperlink in Excel. Both the methods do open the URL in the default bro...
How to count number of #N/A error in Excel? Number of occurrence of #N/A error in a column can be found by using the formula: Countif(<column>,"#N/A") Consider,...
Get list of all Hyperlinks in Excel file This macro produces a hyperlink index sheet. To get list of hyperlinks in each worksheet, the Vba code in this page fol...
Print Directory List in Python To get list of sub-directories present in a computer folder, use the code below. Edit the folder path mentioned in the variable “...
Find Computer Name in Excel VBA In this page, get three different vba code to get Computer name. Environment variable Windows Api wScript.Network To get the com...
List all User Accounts in Windows using VBA In vba use this code to get windows user account names & their domain names. Copy paste this code into your Excel vb...
Display Today's Date & Time in VBA Function used to displaz the current date / time is Vba.Now() This function will return the date & time in this default forma...
Save File with Date Time Stamp In Excel vba we can create new file or save the current workbook with different name. In that case, sometimes we add date, time o...
Extract File Extension from Path A file extension is the text part of a file name after the last Dot '.' . This extension name is usually used by the operating ...
How to add Date Time stamp in Notepad File There are 2 ways to do this. First one is manual & the other is automatic. 1. Press F5 will insert current date & tim...
What happens with spell check? First the spell check process will happen on current cell. The process will take each word in the cell for correct spelling. If a...
Cmd Prompt Command to List Available Wifi Networks To list the available wifi networks in your PC wlan connection, the MS Dos command prompt service 'netsh' can...
What is Facebook Cryptocurrency all about? Who knows!!! You may soon buy these Coins right from Whatsapp & FB Messenger. Imagining life without the social media...
Remove Duplicates in Google Sheets If you want to remove duplicates entries in Google sheets easily, follow these instructions Before that, consider that You ha...
Excel VBA - Remove Duplicates from Data Range To remove duplicate values from a data range or column, this VBA code is going to use the build in option 'Removed...
1. Conditional Formatting: Highlight & Find Duplicates in Excel Find duplicate values in Excel files by using "Conditional Formatting" as explained below. Excel...
How to set color in alternate Rows? In Excel, alternate Rows/columns can be shaded using one of these 3 methods. Conditional Formatting Vba code to color altern...
How to get list of installed Packages? You can use this simple command from the cmd prompt. There are two command available to list all the installed packages. ...
VBA Web scraping with Internet Explorer Web scraping is the process of extracting data available to public. For example: You might want to extract stock histori...
Find MAC Address using VBA A MAC address is a unique ID assigned to a Network adapter & it stand for Media Access Control Address. There can be more than MAC ad...
VBA Check if Computer is Connected to Network Is your Excel or other Ms office application is fetching data from Internet ? Do You also wish to check if the com...
Excel VBA & Menu Option - Sort By Color Excel has option to Sort a column based on these 4 items. Sort based on Value Sort based on Cell color or Background col...
List all Network Adapters using Excel VBA Excel VBA code in this page can list all the network adapters in your computer along with its complete attributes. Net...
Save WhatsApp Profile Picture With the recent update from Whatsapp, save profile picture or share profile picture option is removed. This is really a good move....
Calculate Percentage in Excel Percentage can be explained as a proportion or ratio between two numbers in 100 scale. i.e., 250 out of 1000 is 25% (i.e., 250 : 1...
Anagram Solver Basic App This Anagram Maker app does not require any installation other than MS Excel. It requires MS Excel to be already installed with VBA mac...
Check if Two words are Anagram Anagrams are two or more different words with same combination of letters. For example: now, won, own How do we compare & verify ...
1. Check if AutoFilter is On or Off in any Worksheet This below vba function returns True if autofilter is enabled in a worksheet. otherwise returns false. Note...
Step by Step to Install Python Download Install file for latest Python or the version that suits your application from this link. Python Install file can be dow...
Archive or Zip all files in Directory The code in this page will Zip directory full of files. It will first get folder path as input. Then loop thru the directo...
import sys, string, os os.popen(r"path") To run the outside executable file in your computer through Python, this is the easiest way. You need to download an ex...
Print Current User Account Name in Python Here is the simple way to get the user name by using python code. Note: It is adviced not to use this function for any...
import os os.system('shutdown -s') This coding for shutdown the computer eventually. After running this code, a message saying "You are about to be signed out i...
Python Code to List all Files from Desired Folder To get list of files present in a computer folder to a string variable, use the code below. Edit the folder pa...
Get VBA Environment Variables in Excel By VBA environment variables, it actually means the Windows system environment variables. These environment variables hav...
Enable Grayed Option on Excel Right Click Does some of the options on the right click command bar is disabled or grayed out in your Excel Worksheets. Though it ...
CSV File List - Rename Files in Folder Using Python This is a simple code snippet that I developed for one my recent project. The current name of list of files ...
Best Freelance Platforms As usual I signed up with lot of freelance websites like Upwork, Guru, Remote, Fiverr & Freelancer Out of all these, Fiverr worked out ...
Is PUBG getting banned in India? Recently, many of the internet users came across a letter stating that PlayerUnknown’s Battleground, popularly known as PUBG, i...
Fortnite Game Fortnite is a popular online video game, which comes with a couple of game modes to play. One of the modes-Fortnite: Battle Royale is a completely...
Excel - Enable Disable Commands & Options There are about 150+ options available with the code presented in this section. The notable options are "Status Bar" a...
Browse File Dialog in Excel VBA In Excel file, if you are doing any folder operations or trying to read content from another text,xlsx, csv file. It is better t...
Copy Worksheet to another Excel file VBA Command: Worksheet.copy You are working in an Excel file. You want to copy one of the sheets in the current workbook to...
Excel VBA Optimized - Reduce Run Time You can use this code in almost all of your macro code. This will improvise your code run time drastically. Macro that run...
Option Explicit - Not Working - Fix Yes. It is very strange that my client reported that Excel app I delivered gave "Variable not defined" error. But, when I op...
Number to String Conversion When we say converting a "number to string", it is not about changing a number 1 to 'One'. If you are looking for such conversion, i...
Excel List All Defined Names with Formula Defined names are using to simply the long formula into a short & meaningful name. These names can be defined in Excel...
Creating Defined Name with Formula in Excel Defined names or Custom Formula are used to simply the long formula into a short & meaningful name. These names can ...
VBA Delete File from Computer Folder There should be multiple ways to do it. In this article, I have given 2 methods . One is by using Filesystemobject & other ...
Palindrome Program in Python Following Python code will check if a string is palindrome or not. Solution: Define string to check for palindrome. Create a functi...
Python Code To Generate Random Number Problem Statement Random number is a series of numbers with unpredictable sequence. Following code will generate random nu...
How to scrape Website using Python BeautifulSoup? Applicable To: Python 2.7, 3 or above Data scraping is a method to get data from the websites for business pur...
Python Program to read a book (docx Word document) & store it in a DataFrame in Python. Problem Statement: Following code will read a book from the system in a ...
Python Code To Reverse A String Problem Statement: How to reverse a string in Python? How Does it Work? Following code will reverse the string using external Sl...
Facebook Streaks Facebook Messenger is testing a streaks feature to show users how long and how often they've been messaging their friends Facebook is now setti...
You can delete a single message at a time from both the mobile app version of Facebook Messenger & the desktop version of Messenger, but you cannot delete multi...
Convert Number Format or Currency Format This is something I learned today. One of my friends called me for a help. He has Excel sheet with numbers like this. 3...
What is a Keylogger? A keylogger app is used to record every keystrokes even though it is not in focus i.e., while running at background. Here this code is code...
"All of Google was built because we started understanding text and web pages. So the fact that computers can understand images and videos has profound implicati...
VB6 Text To Speech Application Pre-Requisite: Make sure that you system already has TTS (SAPI - Win32 Speech API) is installed. If it is not installed, download...
Tensorflow Tensorflow was developed by researches & engineers from ' Google Brain Team' in Google's AI organization. It is an open source software library for h...
This tutorial tells how to install Tensorflow in the prebuilt configuration in both Windows 10 and Ubuntu 16.04(for both CPU & GPU) Currently, 64-bit Python onl...
GB WhatsApp WhatsApp the very well known social app now a days that connect friends families and the world together. Now there is the new modified version of th...
Is GB WhatsApp Risk? Both GBWhatsApp and WhatsApp are almost same in terms of interface, installation, sending and receiving messages. The only difference betwe...
How To Download Whatsapp Status Video? The trending videos were first found in Facebook and in YouTube now even simple and handy options available , the WhatsAp...
C++ Swap Function Swap function is used to interchange two values in variables with each other. For example variable x contains 10 and y contains 20, after swap...
Types of Inheritance in C++ The process of inheriting properties of objects of one class by objects of another class. The class whose properties are inherited b...
How to enable Image preview or Thumbnails in Windows Folder? If you have recently installed Windows Os, then some system does not display the image preview in y...
Dijkstra Algorithm - Finding Shortest Path Dijkstra’s Algorithm is designed to determine the shortest routes between the source node and every other node in the...
The crossword puzzle is one of the brilliant game for all age groups. Following is the synonyms, crossword Answers and other related words found the word named ...
Deleting Facebook Account The following steps will guide you through the account deletion process. Login to your Facebook account. Follow this link to delete yo...
Get Maximum & Minimum Values in Worksheet Range Sometimes, we need to find the max or min data in a worksheet. If there are a few data, you can easily get the d...
How to Get Age from Date of Birth (DOB)? The very easiest way to calculate person’s age from using their birthday in Excel is using this formula. Syntax: DATEDI...
Drop Down List in Google Sheets Here are the steps to add data validation drop downlist. Click on spreadsheet cell. Click Menu - Data - 'Data Validation' Choose...
I just learned this exciting option today. These days we get many memes & quotes in Whatsapp. If it is an interesting one, we want to get more details about the...
Compare Columns & Highlight Duplicates or Unique Values Here is how you can compare multiple columns in Excel & change the background color for duplicate values...
Do not Call Registry SMS Option - Start DND Are you annoyed by so many Marketing & Promotional calls? Here is the simplest method to stop those calls & sms mess...
How To Find Number of days between Two Dates? Sometimes we need to know the exact time gap or days in between two consecutive years or months. Here you will fin...
Worksheet Date & Time - How to Split it? In worksheet type this function to get Time enter the formula '=Now()' . It will return the default value as today's da...
Adding WeekDays to Date - Excel Formula & VBA Code This is helpful in planning duration for a project, budget or anything that is related to number of working d...
Excel Formula - Calculate Number of Working Days This function is different from just Calculating the difference between Two dates. Here we will use the functio...
Finding Uppercase Words in String? Use this direct method to find out whether any lengthy string has words with all Caps. For example: This line has one WORD as...
How do I Convert PDF files into Word PDF (Portable Document Format) is a file format that has captured all the elements of a printed document as an electronic i...
Enable Greyed Insert Button in Excel Sometime the Row Insert or Column insert button get disabled/greyed out. Unsure of what happened. Here are few hints to bri...
Excel VBA Find String - In Range of Cells Get code to perform search operation for a string in Excel worksheet cell range. Commands Used: Range.Find & Range.Fin...
Amount in Numbers To Words - Both Million & Crores Get Amount converted from Number to Words both in Millions & Crores format. In many accounting, billing & inv...
VBA Code To Access All Open Excel Files The code below will loop through all workbooks that are open in current system. If you want to scan through all the open...
Lucky Numbers & Numerology in Excel Numerology or Lucky number is calculated commonly using these 2 input methods. Person's Name Person's Date of Birth This pag...
Convert Videos in Youtube To mp3 Online Free Downloads These days when people think of online entertainment, the first thing that comes to their mind is YouTube...
Column Number to Alphabet Letter Get vba code & Excel formula to get Column letter from column number, in here. For example, If you pass '1' to the function in ...
Column Letter to Number For each cell in worksheet the address will have column Letter and then Row number. For example: A1, B1, C1, etc., There is another repr...
In Excel macro, using the range or selection object, merge cells & unmerge operations can be done. Nothing much to explain in this. But just remember that: once...
Excel Subscript & Superscript Subscript or superscript are mostly used in scientific notation or in Chemical equations. Like: E = MC 2 . 2 as super script to me...
Google Docs Subscript & Superscript This article explains how to write subscripts & superscripts in Google docs Spreadsheet. There is no keyboard shortcut or fo...
Excel Add-in Files - Editing Sheets Excel add-in xlam or xla (2003 format) file is a collection of macros, that can be included in Excel app. Once add-in is ena...
Android - SmartPhone - Human's Second Brain Everyday hectic or light ,happy or moody it always includes a very important material. Yes, You guess it right. It i...
A Fun Social Media Experiment - inVLand It means “ inVirtualLand ” – Does it sound like ‘Alice in Wonderland’. Yes. The idea is derived from the movie " Alice T...
360 Panorama - Camera Apps You are in an absolutely eye catching ambiance with your favorite gang. You want to click a picture that covers the whole people & be...
Find Lost Phone - Android, iPhone, Windows - Track Missed Mobile It happened to me a few weeks before - just recently. Felt so desperate to get my lost phone ba...
How to Get Whatsapp for Business App? For now it is available for few countries - USA, UK, Indonesia, Italy & Mexico. Is it available in your country? Click her...
How to Screen Record - iPhone, Android, Windows, Mac? Want easier method than getting a camera & record screen !!! :-) You will get one App each for screen reco...
How to Assign a Macro - to a hyperlink in Excel? Did you just thought a button click or keyboard shortcut - are the only possible way. Run macro using hyperlink...
Eclipse Viewing Glasses - How to Make At home? To experience that is going to happen once in many years is just awesome and fun. One such special and awesome fe...
How to assign keyboard shortcut to a vba macro? Not all Vba code needs a GUI. Some users love to run them using a shortcut key. How to create a vba macro keyboa...
How to Test if Outlook is Open or not? Are you automating any task with Ms Outlook App? Then, sometimes, you need to verify that the Outlook is already running ...
VBA - Insert Inline Image - Into Email Bo0dy Wondering how to attach inline images in Outlook email? It can be done by converting the default text or rich text ...
Excel to HTML Table Do you want to copy the Excel Table to a webpage? Most of the time, It is easy to represent data in table format. Excel spreadsheet is the o...
Whatsapp Hidden Media Files Wonder how to save your friends Whatsapp Status? Believe me. It is that easy to extract any media files from statuses & group messag...
Choose From Multiple Outlook Email Accounts Marketing people send tons of emails daily, to their customer base. If a customer is not interested in the offer, th...
Delete all Shapes in Excel Workbook In Excel a shape object can be: A square box, round, call outs, star, arrow, line etc., Do you want to clear all these shape...
OS Specific VBA Code Does your clients report OS related issues often? Sometimes, Yes. The Vba macro might end up in Microsoft 32 bit or 64 bit or a Mac IOS sys...
Csv File Open Looking for simplest Python CSV codes? We have here - code for both Python Csv read & write, using the CSV api. The code uses the commands in the ...
1. Disable Images in Firefox, IE & Chrome Speed up browsing by Turning off images in Firefox & other browsers. Yes it is also called as Text only mode. Note: Se...
Extract Data From Website Using VBS (vbscript) To get website data to using vbscript (.vbs) file, we need to know 2 processes. First one is to extract HTML code...
Excel VBA - Copy Active Workbook Get syntax for vba function to copy active workbook or external workbook saved in the folder. For both these purpose, we will b...
Bitcoin Chart - Market Trend - Current Price Do you want a Bitcoin chart or Current Price to be displayed in your website main content or sidebars. Well then. I...
Bitcoin Price Ticker in Excel This is really a fine code that I have come up with accidentally. I was only searching for how to add Cryptocurrency market chart ...
strftime For quick syntax & options help with this function, type >>help ("time.strftime") . This will list all the basic help that you are in need. If you are ...
Bitcoin Trading - Where to Start Be it Bitcoin or any other crypto-currency, check for the list of trustable sources from its official website. Here we have the...
Get Historical Stock Quotes - Google Finance Historical Stock Quotes are required as a first data item when you considering buying a stock. Lets say you are inv...
JSON To CSV - Python Json Tutorial Use this code to parse Json to csv or Excel. Actually, this code write to a csv file, which can be opened in a Excel file as ...
Parse JSON - Converter in Excel This name often reminds me of the film Jason Bourne . But this JSON is a file format standard. In this page, You can get JSON co...
How to Create Organization chart in Excel? Do you want to do add Org Chart thru this menu option? Click on Excel Menu -> Insert -> Smart Art. Choose Hierarchy c...
Excel VBA Dir - Directory Listing - All Subfolders The macro will fetch all subfolders & folders under subfolders till its last child folder. You just have to i...
VBA Range to 2D Array These list of topics are covered in this page. Vba Code to initialize 2D Array with Range Vba to write Array data to worksheet Resize Arra...
Convert Array of 2 Dimension to 1 Dimension In Excel VBA , we use 2D arrays quite often. This is because, we convert Excel Worksheet Range to Array and do the d...
Excel VBA sorting Range of multiple Columns How to Sort a Excel range of data? Do it either thru VBA Sort Range code or Built-in menu option. I have presented b...
How to Connect Access Database in Excel Macros? Updating Excel Spreadsheet from Access Database using this step by step Excel VBA Access Macro code is just that...
Get File Property Using Excel VBA Try these code to get the property of a file in the computer folder. By file property, I mean the Username who created it, Fil...
File Operations - VBA, Python, VBS, C, C++ & DOS It is important for any programming language to open text file or get data from external file or write to a ext...
Clear Cookies, Cache, Browsing History From Excel VBA delete cache, cookies, browsing history, temporary internet files used by IE or MSHML2 xmlhttp requests. T...
Read XML using Excel VBA XML is the file format that is widely used to transfer data over internet or between 2 systems with different platforms. The most widel...
How To Make Glue Slime with Borax? Stress Busters: Are you always tired of doing same tiring hectic works and you think you are out of relaxation. Stress the ma...
How to Copy Excel Chart in PowerPoint Slides using VBA Macro - Step by Step Tutorial Requirement: We need to copy several charts from Excel in Powerpoint slides...
Tricks To Skyrocket Your Website Traffic With Reddit While you are running an online business, the most essential and stressful task you have to undertake is dr...
How To Save All Photos From Facebook To Computer? Download Facebook Photo Album is right in albums page itself. Just in front of our eyes, yet we miss to notice...
How To Add Options to Quick Access Toolbar The steps will guide you to add controls or command to Quick Access Toolbar in Excel or Ms Word. 1. Click on “Customi...
In Excel - What is a Pivot Table? Pivot Table is used to consolidate or summarize a table with huge volume data. Pivot table or Pivot chart are very quick power...
How to Export Outlook Calendar to Excel? Download Outlook Calendar Appointments to Excel using one of these 2 methods. Outlook Calendar Export to CSV Outlook VB...
Create a New Workbook with VBA Quick trick with Outlook, Word,Excel VBA create new workbook while run-time on the go. Note: To create a Excel file from Outlook ...
Show Developer Tab Menu - Excel Office 2010 or Above To enable ‘Developer Tab' in the Menu for Excel & Word, this steps can be followed. Prerequisite: To enable...
Excel Consolidate Data Function To Summarize This option enables user to consolidate in Excel. Summarize data from different worksheets to one sheet. Data from ...
What is the Fibonacci Number Sequence? Fibonacci series is a sequence of numbers. Any number in the list is a sum of last 2 numbers ahead of it (i.e., Last 2 pr...
How To Add Hyperlinks in Excel Using Formula? Higher version of MS Excel like 2007 or above have built in function to add links. Select a cell to insert a hyper...
How to Reduce Anxiety Level? It is all about 'letting it go' of the continuously rising thoughts about your past happening or a future event. Do not try to trac...
Excel Compare Two Columns & Report Differences Learn how to compare multiple columns in Excel with huge volume of data. Find duplicate entry in 2 columns using ...
Excel Count Colored Cells with VBA ColorIndex To count colored cells in Excel using VBA color codes, use this code. This code will check for VBA color index in ...
Excel VBA Color Index List Excel color index are used to change either a worksheet's background(Interior), font or border color. There are 56 colors that has pr...
Convert VBA Color Codes to RGB or HEX To convert the Excel vba color index list to RGB, HEX, Long/Decimal use these functions. This covers almost all type of Co...
Can I have Two Whatsapp Accounts on One Phone? Yes, it is possible. Follow these steps. Open Play Store in your Smartphone. Search for one these suggested Dual ...
Can You Video Chat On WhatsApp? Update: Nov 14 2016 - WhatsApp Video call facility if officially released. Just Update the app from PlayStore / App Store and en...
1. Add Drop down list with Excel Data validation? A data validation list in Excel enable users to choose only predefined values from a drop down option. If user...
Call Excel VBA Shell Command Object Output There are 2 methods to read Excel vba shell command output. Write the vba shell command prompt output to a text file ...
What is Display Resolution? The number of Pixels displayed in your Monitor is called Screen Resolution. It is represented as how many Pixels displayed in Screen...
Convert Excel VBA 32 Bit to 64 Bit To solve Compile error: 'The code in this project must be updated for use on 64-bit systems', continue reading If you upgrade...
Open Vcf File Online & Excel With these free tools You can open vcf file & view the contacts details. This page has 4 choices, with the best one first. First on...
VBA to Add Semicolon to Email Addresses in Excel If you have Email Ids in Excel, then create distribution list using this app or VBA code. We come across situat...
Check IF VBA String Contains Letters or Alphanumeric There is no string operator or function that performs VBA check if string contains only letters. There is w...
Import Data from Excel to Excel To pull data from another workbook to current active Excel, try these methods. Data Import option to query data from another wor...
Convert Formatted Cell in Excel to HTML To get the font and formatting style of a text in worksheet follow these methods. Excel Worksheet Cell format – Single F...
Get Stock Quotes in Excel Use this simple technique to get free stock market data as an Excel stock price list. Have you been a stock market investor dumping a ...
How to Automate Emails From Excel? Get macro to send email from Excel & email Excel file as attachment using VBA. In this page, you will learn and get code for ...
How to Send email to all contacts in Outlook? Use one of the following methods to send Email blast from Outlook. i.e., mass email in Outlook to a large audience...
C Program to print Hello World C programming is consistently in 2 nd position after Java for its popularity as per TIOBE index (a software quality company that ...
Examples of Prime numbers Prime number is the one that is divisible only itself & the number ‘1’ (without giving any reminders). If you divide it with any other...
Palindrome Examples In this article, we will explain how to do a C program of Palindrome to handle both Text & numbers. What is a Palindrome? It is a word, sent...
How to Sync contacts with Facebook? Handy tips to allow Facebook Sync Contacts to Phone with OS like., Android, iOS(Iphone), Windows are explained in this artic...
Export Contacts from Facebook to Excel To export Facebook contacts to Excel with email addresses or CSV/vCard (.vcf) format use this trick. Facebook contacts to...
Swift IOS Tips – One of Best Development Language Ever since its release in September 2014, Swift programming language has become the best development language ...
JavaScript Functions With in VBA: The Merger Include a reference to ‘Microsoft Script Control 1.0’ as explained below, before proceeding with further JavaScript...
Setup CRON Schedule Jobs In this article you will learn to make a simple PHP script execute repeatedly at certain time interval. To do this, it is assumed that ...
Website Backup to Dropbox using PHP Dropbox auto backup can be done using PHP as explained in following steps: Download Dropbox SDK . Login to Dropbox. Get Acce...
Fully Functional Email Sign up Form Code Web admins & bloggers use different kinds of animated email sign up forms to increase their reader base. There are lots...
Make Your Free Time Last Longer With These Productivity Tools Nowadays it is common that we strive to do the most work in the least amount of time. With the con...
Excel VBA To Select & Copy Visible Cells In Excel, sometimes few rows wont be in visible state, when auto-filter is enabled or made hidden by any user. In such ...
What to ask Siri in your iPhone? If you are an iPhone user, Siri is the one function that you should be able to make the most use of. Siri is a wonderful virtua...
Facebook Like Generator - Click all Like Button Do you get lot of interesting articles in your Facebook timeline. And you want to click 'Like' to your friends w...
IPL Points Table - 2021 Season 14 Here is the updated IPL points table & this year it is proving to be tougher than any other season. New teams are coming up at...
Cricket has always been more than a game for this nation. There are innumerable instances wherein people have shown unparalleled support towards the game. Like ...
Spy Android & IOS Device Secretly Ok so you’re here, for whatever reason or motive that led you to search out this article, you probably want to know how it can...
How to Run Android Apps on PC? Android operating system that changed everything. Crucial for the existence of smartphones, this operating system is the unanimou...
Stop Receiving Unwanted Text Messages Mobile phones have become an inevitable part of everyone’s life. Knowing this, companies around the world have identified ...
iOS 9, the latest version of the iOS operating system has been out there for a long time now. Compared to the previous versions of the iOS, the new iOS 9 operat...
What this VCF converter Can Do? Get this VCF to Excel Universal converter, to perform the below listed operations. Convert any VCF file to Excel with no limitat...
Non-Repeating Numbers - With Excel RND function In Excel VBA or any programming language we have built in function to generate random number. But it will genera...
Does your Whatsapp Crash Often? For last few days, WhatsApp messenger was crashing so frequently in my Android phone. It happens ,whenever I type a message & cl...
Engineering Unit Conversion Table In Excel If you want to convert kg to lbs, meter to feet or liter to gallon -this Engineering Unit Converter Excel app can per...
Convert XML Files to Excel - 5 Methods to Import To Import XML data to Excel you can use any of these listed methods. VBA to import XML to Excel Quick VBA to Co...
Election Results Official To view the official results from Election Commission check in the page mentioned below. Also, you can view candidate wise vote counts...
Do you have hundreds or thousands of inbound emails in your Inbox with important data fields? Maybe your business is receiving leads or order confirmations by e...
Printable Excel Calendar 2022 Template To get yearly printable calendar template in Excel for any year, use our free download or follow these steps. Most of us ...
In one of the earlier topics we learned how to generate Random numbers in Excel & Google Spreadsheet . Now, we will see how to get values from Random Columns us...
WhatsApp Stop Unwanted Forward Messages After the activation of Group Chats in WhatsApp, everyone got excited and crazily created lot of New Groups. As time pas...
Sudoku Solver - Excel Games Puzzle Sudoku is one of the famous Math games that will test your memory capability. Here is the list of instructions about how to p...
How To Create Excel Data Table? A Data Table generates different scenarios for your formula. You can use it to do What-if analysis. Lets first create a Excel Ta...
How to Subtract Numbers in Excel? There is no built in function in Excel to perform subtraction. Use one of the methods explained below. In Excel, we could perf...
How to Add in Excel? Open Excel Workbook and follow the steps mentioned below. Select Range of Cells that you want Sum in Excel sheet & Click ‘AutoSum’ in Home ...
Excel Functions Vs Array Formula In this article, we are going to search for value in a Excel table without using Vlookup function. The formula that we are goin...
WhatsApp Group Messages or News Feeds Junk? Raise Your Hand If You are also one of them who ignore new Messages in a WhatsApp Group Chat !!! These days there ha...
How To Hide Desktop Icons of Active Apps? As the name suggests the Windows Operating System executes the application as different Windows. User sees the Desktop...
Before Starting Your Diwali Vacation Trip Instead of all usual travel checklist, we have tried to come up few important activities that you could quickly take c...
How to Lock a Folder in Windows 7 or Above? Microsoft keeps on upgrading its Windows Operating System consistently to improve User experience and Security. Thes...
Unprotect Excel Sheet - Without Knowing Password Get VBA Macro code in this page, that will help you to generate an alternate password to un-protect Excel sheet...
Indian Users can buy products from this link . International Users can buy from below links. Read our Terms & Conditions at end of this page before purchasing. ...
Random Numbers in Excel Formula, VBA & SpreadSheets Is it any Guessing Game? Yes. If you can predict the next number these functions can generate then, Microsof...
On The Go Entertainment Is Just A Click Away Life is so fast and stressed that sometimes it’s hard to tell where the day goes by and how quickly time flies. In ...
Making of #N/A Error & Solve it If You are an Frequent MS Excel User, then you should have seen those Unexpected return codes from Formula that start with Hash(...
How to Compare Two Excel Sheets for Differences? How do you compare Excel Spreadsheets? To assure quality of a software, compare Excel files as explained below....
Youtube Facebook Video Downloader Online Use these tips to download video by direct method or by using their URL. Ever wondered how to save a Facebook video, Yo...
Cloud Backup and Storage - Why not an Extra External Hard Disk? Is my external hard disk not enough? It might be, but just that question arises - "Why not use a...
Task Manager in Excel - How to use Excel to Monitor Servers or PC? There are in built application in Windows to view what applications are currently running in ...
Facebook Addiction Symptoms & How to get rid of it As per Buddhist meditation – ‘Right Mindfulness is to remain focused on ourselves continuously without gettin...
Amazing Settings available in Facebook Many users just spend so much time only in sharing or reading news feeds. but, only few care to dig the hidden secrets fr...
How to Extract Data from PDF to Excel or Word? There are plenty of online services and tools available to convert a PDF to a Word document. Few PDF documents ha...
Auto Send Instant Office Communicator Message from Excel This article explains how to send instant messages to your friends through Excel. The code in this page...
Excel VBA Print & Save as PDF Commands This article provides code for creating PDF from Excel & Vba print macro Excel 2010 or versions less than that. Just like...
Convert Excel to Access Database Use this simple method to learn how to create Access database from Excel spreadsheet. Programmers convert Excel to Access datab...
Macro for Vlookup Tutorial A Vlookup function search for ‘value’ in the first column of ‘table Range’ & returns a value from the same row. Syntax: =Vlookup (‘va...
.ics File Format (ICalendar) Events like meeting requests, tasks, alarms, to do list etc., are stored in Calendar application. This Calendar application could b...
After the acquisition of Whatsapp by Facebook, everyone is expecting some integrated features between these apps. But till now, there has not been any significa...
Web Scraping & Keywords Analysis Tool - SEO Get the Excel with VBA code for Scraping Keywords from Website to help in your SEO tasks. Search Engine Optimization...
WhatsApp Voice Call Feature – Is it true? Updated April 4th: Whatsapp Voice call is available now with version 2.12.5 available in Play Store. Whatsapp voice ca...
Facebook Safety Tips How can you check how much of your personal data is visible to outside world? Try these Steps. Log out from your Facebook Account. Try to G...
Auto Outlook Archive Email What does it mean to archive an email? When we get too many emails in Inbox @ work, it wastes our time in browsing through all mail i...
Mail Merge with Excel and Word This is a Built in Option in Microsoft Word for sending personalized mails or letters, to a mass mailing list. If you have Micros...
Compatibility Issues working with Application in Older Version Of Office After the recent upgrades in Microsoft products, we can notice few compatibility issues...
ICC Cricket World Cup 2015 Fixtures Indian Crickets Fans may not have forgotten the World Cup 2011 Final Victory Moments. Dhoni's Team lifting the Cup along wit...
How to Make a QR Code for VCARD What is QR Code ? QR Code is a 2 dimensional bar code represented in a square pixel matrix. We can store alphanumeric data insid...
Whatsapp For PC - Web App Whatsapp announced an update on Jan 21 2015 - that it has enabled Whatsapp for Web. Already there are tons of Articles floating in eve...
How do you check your internet usage and optimize it? These days, every member in family has mobile phones. And it is more likely that everyone could be using s...
Types of Mortgage Loan Interest Rates There are broadly two common types of interests in Mortgage Loans. In the first type, Interest is set to a Fixed rate of L...
All about QR Codes Have you ever wondered the possibility of storing the huge amount of data say a movie in a single A4 sheet paper? In this digital world, ever...
URL to IP Address - Intro In Computer networking, IP address can be one of these 2 types & are represented in decimal/hexadecimal dotted format. IPv4 - 32 bit (...
Conversion From CSV to VCF (or vCard) To convert a contacts from CSV to vCard file business contact format, use this easy tips. CSV stands for Comma Separated V...
Is it ‘OK’ to share non-reliable Messages in Social Media Stop Spam Messages We spend lot of time in Facebook, Twitter, Google Plus or any other Social Media, S...
GeoIP to Location Lookup Database - Find Website IP Many websites and software provide free GeoIP - IP to location lookup services. If we input an IP address to...
How to Play 2048 Game? 2048 game is played in the 4 x 4 tile. To play this game You need to use 4 arrow keys in the keyboard (top, right, bottom, left). With ea...
Speed Up Google Chrome Be it a Computer or a Smartphone, we do so many things through it such as hearing songs, watching movies, editing documents. But most of ...
Precious Moments - In our Hands: Smart phones have emerged as better half of everyone’s life. Android smartphones and devices remember a lot rather than what we...
Facebook Timeline - News Feeds - Wall Posts In this article, we are going to explain, How to use Facebook OpenGraph API to extract your FB data in JSON format? ...
Email Address Harvesting Software To collect Email Ids from website, use this Mass Email extractor or Email harvesting software. This is mainly used by marketti...
How to backup Android Phone to PC? We would be happy if there is some app that could copy & store everything. Not only phone data. I mean, everything Life event...
Fetch Email Addresses - Quick Install & Test Code Open MS Outlook and Select any mail in Inbox or any other Folder Open new Excel Workbook, Alt+F11, Copy Paste ...
Social Media to Most Popular Facebook Games Are you bored of continuously staring at FB Photos, status updates, news feeds from you Friends? Give a visit to the...
Excel VBA Telnet Client for Remote Connect We use Telnet Client sessions to control or manage systems that does not have a keyboard or monitor attached to it. A...
Index: Create List of Worksheet Names with Hyperlinks Ever came across this question !!! What is the maximum limit for number of sheets in Excel? Answer is: The...
1. Excel Delete Multiple Blank Rows (Built in Option) To remove blank rows in Excel, Open the worksheet & follow these menu options. Select data range that has ...
Video Games are for Adults too!!!It is now Android Games There are times when Video Games are invented for Children, to kill the time during their vacation holi...
Usual Sorting of Data or Table in Excel To Sort a Column Data in Excel, the user has to select the data range or column and then choose option “Sort & Filter”. ...
Dual Sim Means 2 Whatsapp on 1 Phone I did not believe that Whatsapp dual login is possible until I found out this technique. In earlier days Whatsapp for dual ...
Update Timeline without Logging into FB You are reading through your Gmail or Office Mails on a busy day and came across some interesting news. Suddenly, you fe...
Candy Crush & Block Game Invites on Facebook To block game requests on Facebook, follow this simple tweak inside the FB settings. Probably some of us have never...
Login Automatically into Social Media Networks in IE using Excel These days’ people spend too much time in Social Media Networks like Facebook, Twitter, and Goo...
Install WhatsApp in PC or Use Android Emulator To install WhatsApp messenger in your PC, Download WhatsApp for Windows or Mac from this . Install & Open the app...
Excel VBA To Download File from Website URL In this article you will get VBA code to download file from any website URL. Consider your have a list of files to d...
Display Related Posts with Thumbnails from Current Post Category Using the below PHP code, we can generate related post links from the current post category and...
About Sitemap.xml Sitemap XML file is used by the search engines to find out the complete list of the pages of the website. Along with url link of the page, it ...
How To Take Backup of Social Media Profile? Do you want a full backup Facebook data from your profile to your system? Or be it any other Social media that you h...
Steps to create Shortcode for Google Ad Units Shortcodes can be used for many purposes, using it for adsense is just one of them. In this article, we cover the ...
Secure FTP Upload Thru Different Methods FTP automation is done to transfer data from PC or web server to a FTP file hosting service. Often this data is served ...
Google AdSense not showing up on Category-Tag Pages Have you ever encountered this scenario ? In few pages of the website like Category / Tag pages, Google Adse...
WordPress Excerpt Length Customize Generally for the Blog websites, bloggers don't generally prefer a static page to appear on Front Page or Home page. Instead,...
Need of Social Media Networks Be it a Business or Personal Blog, its success is closely tied with S ocial Media Networks . Social Media helps to spread the info...
Activate VBA Text to Speech (TTS) in Excel In this article you will learn about these topics related to TTS in Excel. Install Text to Speech (TTS - SAPI Windows...
Google Adsense and Where this Yellow Box Issue Occurs? Google Adsense is one of the key monetizing platform used by the Website/Blog publishers which is authori...
Why do we need to Enable PHP Code in Text Widget In certain cases, we need to execute the PHP code inside Text widget. But if we just place the PHP code inside ...
Display Popular Posts with Thumbnails without Plugins Display Popular Posts with Thumbnails using PHP Code Popular post is not the readily available feature und...
Enable Shortcodes in Text Widget (Wordpress) Write your own PHP Code to Enable Shortcodes in Text Widget: Text widgets are just wonderful feature available in W...
Create Child Theme in Wordpress Create a Child Theme in Wordpress Without Plugins If you are a beginner in the development area of Wordpress, then this article ...
VBA Username in Excel, Outlook, Word etc., Using Excel VBA you can get username who is currently logged in & active, get author name who edited the Excel workbo...
Recent Posts Thumbnails - Swap Coding in Place of Plugins Are you a lover of programming & don’t like to hunt for plugins on small things? You are not alone in ...
Trouble Remembering Too Many Login Credentials - Password Management with Encryption This article explains some techniques on how to make your own password mana...
How To Password Protect Excel & Word Documents? The Article explains how to secure a document with built in options & then a corresponding VBA Code snippet. The...
How do we refer Synonym for a word usually? Dictionary - Find Synonym For Word To view synonym of a text in MS Word, We have to place the cursor on the word, th...
Excel VBA Shutdown Computer - Visual Basic Code Note: Save all your unsaved Documents before Testing this Code This VB6 or VBA Shutdown, Log off or Reboot the c...
Work Life Balance and Time Management Schedule and Balance Work Vs Life This article explains how to Automate Locking a Windows Workstation and schedule your Te...
Excel Import Data From Another Workbook - VBA Codes To pull data from an external Excel file, use on of these scenarios. Closed Excel file: Using VBA Import dat...
How to Merge Files in Excel using VBA? Get VBA merge text files Excel macro code in this article. In our daily work routine we deal with lot of data & log files...
Tata IPL 2022 - Schedule in PDF & Excel This year IPL15 matches time table is officially announced. Here is a summary of the event along with IPL 2022 schedule ...
VBA to get Excel Cell Background Color RGB Code & Change it Hope you would like these in-depth Excel cell color formatting techniques. In Excel macro to get cel...
Export Emails From Outlook to Excel with Date and Time To Export Outlook email data to Excel & archive mails, we have 3 options here. Menu option for Outlook to...
How To Convert VCF To Excel? To convert contacts in VCF to Excel, You can use one of these methods. Download our vCard to Excel App Excel VBA Conversion Code - ...
How to Create a Worksheet in Excel? MS Office provides option to create dynamic spreadsheet in Excel during run-time. Also, users can do to other worksheet oper...
Excel Trim Not Working - Remove Unwanted Characters Is Your Excel function TRIM not able to remove non-displayable characters? A Trim function will remove only ...
Excel VBA AutoFilter multiple criteria for Data Range Learn MS Excel advanced filter option & accessing it from VBA with this simple tutorial. We will cover the...
Anagram Maker - All possible Words Combination Generator Get Excel VBA code to create your own Word Combination Generator in 2 mins. Just follow these simple st...
How to Change Excel Date Format? Excel date format related function are grouped in Menu-> Formula -> Date & Time Option. Using this, we can get today's date & t...
Outlook VBA Save Attachments Use this code to Automatically Save email Attachments to a Folder. In this article, we will be getting Outlook VBA code to perform ...
Excel VBA IF Else - For Each After the Hello World program, there was no topics posted for beginners in OfficeTricks. So here is one that would benefit the lear...
Convert Text To Date in Excel or Number For Excel date format conversion manual or VBA follow these 2 methods. Excel automatically converts the data types to it...
One Click - Save Screenshot to an Image File and Attach in Excel. This topic explains some basics about creating a Print screen Automation Tool in Excel VBA Mac...
Google App Scripts This topic is about writing a Hello World script that will enable us start learn on how to automate tasks in Google Spreadsheets or Google Do...
Converting Excel to VCF with Just One Click To convert CSV or Excel To VCF, follow these simple instructions: Download & Open Excel to vCard file converter app....
Export HTML Table to Excel - When Web query does not work To Import a HTML table in a web-page we can use, Web Query option in Excel to import it to Excel or Fr...
Are we Using Start Up Folder Option We have option in Windows to add the list of application to be launched during a system start up. But, we do not use it ofte...
Hierarchy: As a User, When we edit data in excel document manually we use keyboard or mouse pointer to traverse through different worksheets or cells. It is not...
Call Macro if Cell Value Changes Learn how to create a VBA Range macro to run when any specific cell value changes. Also we don't have to explicit use any User ...
Built-in Excel Worksheet Functions This Is What We Do When Excel Does Not Have A Formula That We Need Desperately. There are plenty of Excel Worksheet Functions...
Office Communicator Verify - User Status Office Communicator display list of Friends added in it along with their availability status (whether they are availabl...
How to Import application list from Task Manager to Excel? Well, this can be done with the help of the Windows API Function from the library Kernel32. Using thi...
VBA Code to Extract Data from Website to Excel To perform HTML screen scrapping or get webpage data into Excel using VBA code, read these easy tips. Programmers...
Excel VBA - Create, Delete, Exists, Copy, Move, Open Folder Operation Be it any operation on a system directory, like any of these: List Folder or check folder ...
Excel VBA Outlook Calendar - Bulk Upload Tasks Easy trick on how to add a Calendar Item in Outlook from list of reminders/appointments in Excel. Manually creati...
Shouldn't Have Combined these two topics into One: In this blog a Formula actually means the Worksheet Functions, that we use in excel sheets directly that begi...
Excel VBA Schedule Macro to Run at Specific Time Here you will learn - How to add Excel VBA Timer Event to run macro automatically at certain time & how to crea...
What is a macro in excel? This is a fine option that can be used to learn Excel VBA Macro . When the "Record Macro" in switched ON: Manual operation done to exc...
Get Folder List with VBA Dir - Remove Empty Folders To get the list of folders within a folder through VBA, it would have been nice if the command name is VBA D...
How To Send Bulk Email From Outlook Using Excel? Learn the best ways on how to send email from Excel VBA to multiple recipients here. Download "Send Mass Email ...
1. Add Excel Command Button from Quick Access Toolbar This is Applicable for Excel 2007 and above versions. This page has quick tips to insert command button in...
Insert Excel Calendar Control or Date Picker The steps to insert a Calendar control differs for Excel 34 bit & 64 Bit versions. Check Excel Version: To know whe...
1. To know how to insert the Calendar Control in worksheet, read the below topic. /insert-calendar-control-in-worksheet/ 2. After inserting, how to get the valu...
Remove Duplicates in Excel Worksheet To remove duplicate values in Excel, follow these steps. Open the Excel Workbook. Select the Range of values that has dupli...
Get easy step by step guide to code a Excel Vba hello world program. It is perfect place to start Excel Programming for beginners. 1. Excel VBA "Hello World" Ma...