Fill-in the details.
By clicking any of the above buttons, I agree to the terms & conditions and privacy policy, and I consent to receive updates via SMS or email.
By clicking any of the above buttons, I agree to the terms & conditions and privacy policy, and I consent to receive updates via SMS or email.
Power BI | MS-SQL | ETL with SSIS | VBA | Python
Advanced Excel | MIS Reporting | Power Query
VB Programming | VBA | MS-Office Automation
Power BI | Power Pivot | Power Query | Basic DAX
Advanced Excel | MIS Reporting | Model Building
Power BI
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
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
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
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
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
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
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
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
