Learn how to add leading zeroes in Excel for numbers in cell. You can add zeroes to the display formats or to values with formula and few simple methods.
How to run VBA Macro Daily without opening Excel file autiomtically?
November 26, 2024
Steps to schedule a macro to run daily automatically with sample code & setup scripts. Try this and test run by scheduling any VBA macro run automatically
Run Macro from Another Workbook – Excel VBA
November 26, 2024
Get code snippet to run macro from another workbook using Excel VBA command. This command works like a remote control to run VBA code in remote file.
Export VCF to Excel – Converter Online – Using Google Account
November 26, 2024
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 – Easy Sample Code
November 26, 2024
Install Excel VBA Selenium type library & launch Chrome browser for webdata extraction. Also other browsers like Firefox, Edge etc.,
VBA to Change File Encoding ANSI to UTF8 – Text to Unicode
November 26, 2024
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?
November 26, 2024
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
November 26, 2024
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
November 26, 2024
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
November 26, 2024
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 […]