+1 650 491 3131

Power BI

Is Power Bi, the silent death of SSRS?

Published by Excelgoodies . 2 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 . 2 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 . 6 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 . 6 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 . 6 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