Export VCF to Excel file using Google. Load Vcard file to Excel and convert them to a CSV file. This way it is easy to import the contacts to xls file.
Excel VBA Selenium Chrome – with Sample Code
January 13, 2022
Learn how to install Selenium library for Excel VBA & launch Chrome browser to extract data from Web browser. Also get latest Chromedriver for Chrome.
VBA to Change File Encoding ANSI to UTF8 – Text to Unicode
January 13, 2022
Get VBA code to convert .Txt ANSI encoding to UTF8 Unicode format. ALso learn how to do UTF convertion using built in function in text editors.
How to open VBA in Excel – Macro code editor?
January 13, 2022
Learn how to open VBA code in Excel. Get different options to open Excel macro code as per steps explained in this article.
Get Sheet Object Caption and Codename
January 13, 2022
Get Excel worksheet caption & name (or Object name or Codename) using VBA Macro. This is a readonly property and cannot be renamed using code without giving access to VBA Project Model.
Power BI – DAX
January 13, 2022
What is DAX? DAX stands for Data Analysis eXpressions and is the language behind Power BI. DAX is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. With the help of DAX, analysts discover ways to analyze data and come up with great ideas and insights […]
SUM and Average of Top N Values in Excel
January 13, 2022
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 products in our superstore and we have to find the total number of sales made in […]
Dynamic Host Configuration Protocol
January 13, 2022
Introduction The Dynamic Host Configuration Protocol is also known as DHCP, It is a network management protocol used on Internet Protocol(IP), wherein Dynamically assigning an IP address to other network parameters so the device can easily communicate with other IP networks. A DHCP server enables the device to request IP […]
Dream11 IPL 2020 – Points Table – Team Positions
January 13, 2022
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.107 18 Q Delhi Capitals DC 14 8 6 0 0 -0.109 16 Q Sunrisers […]
IPL 2020 Points Table PDF – Winners List
January 13, 2022
IPL 2021 Points table Note: Click on this link to get latest points table for IPL 2021. 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 points table. It’s only the […]
