BY INDUSTRY

BY FUNCTION

New

Power BI

Is Power Bi, the silent death of SSRS?

Published by Excelgoodies . 3 years ago

Well, the end-purpose of both tools is to help business users with high-end reporting. Where does the
difference lie? The changing.…Read More

Excel VBA

How to Show Progress on Status Bar using VBA?

Published by Excelgoodies . 7 years ago

The below code will add serial numbers up to 500 in your sheet and along with it will show progress on the
status bar. Sub progressStatusBar() Application.StatusBar= “Start Printing the… Read More

Microsoft Excel

Power of Paste Special – Multiply

Published by Excelgoodies . 8 years ago

For some of you this is already known, but I know there are users who are not aware of the
power of the Paste Special Dialog. Suppose you have been… Read More

Power BI

Is Power Bi, the silent death of SSRS?

Published by Excelgoodies . 3 years ago

Well, the end-purpose of both tools is to help business users with high-end reporting. Where does the difference lie? The changing role of Business Users from just “receiving” the powerful…

Keep Reading

Excel VBA

Is knowing Excel VBA a good starting point for learning any other programming languages?

Published by Excelgoodies . 3 years ago

Yes – If you are a “BUSINESS USER” (non-programmer) looking to get into programming (part time/full-fledged). My whole point stands on one belief – You learn best when “you connect what you learn…

Keep Reading

Excel VBA

How to Show Progress on Status Bar using VBA?

Published by Excelgoodies . 7 years ago

The below code will add serial numbers up to 500 in your sheet and along with it will show progress on the status bar. Sub progressStatusBar() Application.StatusBar= “Start Printing the…

Keep Reading

Excel VBA

Open XML File in Excel

Published by Excelgoodies . 7 years ago

Here are the primitive commands to open an XML file in Microsoft Excel. Sub Open_XMLFile() Dim OXML As Workbook Set OXML = Workbooks.OpenXML(“c:\sample.xml”) End Sub Sub Open_XML_File_As_List() Dim OXML As…

Keep Reading

Microsoft Excel

Why Vlookup when there is Index?

Published by Excelgoodies . 7 years ago

Vlookup: The syntax for Vlookup is: VLOOKUP(lookup_value,table_array, col_index_num,range_lookup) Index: The Syntax for Index is: INDEX( array, row_number, [column_number] ) Match: The Syntax for Match is: MATCH( value, array, [match_type] ) Problem:…

Keep Reading