Upskill Technologies 

To insert a formula in a range you can use the range.formula command in VBA. Like for example you want to add the columnA +columnB values...

Here is the situation, check the below numbers in the picture. The task is to count the number of zeroes at the end after any number. Put...

Split worksheets into separate files Macro to create multiple workbooks from a master worksheet Recently as part of a consulting...

I have changed around 5-6 laptops in the last 10 years, I know that's not good but I have to due to various reasons, sometimes to get a...

Starting a series of challenges on VBA. Will extend this to SQL, Excel, Power BI, Tableau. Feel free to drop in a solution in the...

You love mail merge but I am sure that once in a blue moon when you have to do it you will have to google it and see how to create...

I recently encountered a problem while writing a query for an excel application where I use ADODB to retrieve a list of items from the...

With the pandemic pushing almost everyone to work from home and most of us are required to stay active on collaboration tools even if...

So you want to know how good you are in excel then make sure you download our test now. Its not a multiple choice question style test but...

Hi All- There has been a request from most of the students attending excel and VBA classes to show what SQL queries are and how SQL can...