Business Professionals
Techno-Business Professionals
Power BI | Power Query | Advanced DAX | SQL - Query &
Programming
Microsoft Fabric | Power BI | Power Query | Advanced DAX |
SQL - Query & Programming
Microsoft Power Apps | Microsoft Power Automate
Power BI | Adv. DAX | SQL (Query & Programming) |
VBA | Python | Web Scrapping | API Integration
Power BI | Power Apps | Power Automate |
SQL (Query & Programming)
Power BI | Adv. DAX | Power Apps | Power Automate |
SQL (Query & Programming) | VBA | Python | Web Scrapping | API Integration
Power Apps | Power Automate | SQL | VBA | Python |
Web Scraping | RPA | API Integration
Technology Professionals
Power BI | DAX | SQL | ETL with SSIS | SSAS | VBA | Python
Power BI | SQL | Azure Data Lake | Synapse Analytics |
Data Factory | Databricks | Power Apps | Power Automate |
Azure Analysis Services
Microsoft Fabric | Power BI | SQL | Lakehouse |
Data Factory (Pipelines) | Dataflows Gen2 | KQL | Delta Tables | Power Apps | Power Automate
Power BI | Power Apps | Power Automate | SQL | VBA | Python | API Integration
Power BI
Published by Excelgoodies · 4 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 · 8 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 · 9 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
VBA & Python
Published by Excelgoodies · 2 days ago
Are you tired of rewriting the same VBA code over and over in Excel? In 2025, efficiency is key, and having a library of ready-to-use VBA snippets can save you hours of work. These 20 handpicked snippets are designed to automate tasks, streamline workflows, and become your go-to tools forever. Get ready to supercharge your Excel skills and work smarter, not harder!
Keep ReadingVBA & Python
Published by Excelgoodies · 2 days ago
In 2025, while automation tools like Power Automate are on the rise, VBA still holds its ground as Excel’s most powerful built-in ally. It’s fast, flexible, and works seamlessly without cloud dependencies. For many professionals, VBA remains the go-to choice for precision control and reliable automation inside Excel.
Keep ReadingExcel Formulas
Published by Excelgoodies · 2 days ago
Messy data can slow down any Excel project, but 2025 brings smarter ways to clean it faster. With Power Query, you can automate repetitive tasks, spot errors instantly, and transform chaotic datasets into actionable insights. Ready to level up your Excel skills and save hours of work? Let’s dive into the top advanced data cleaning hacks you need this year.
Keep ReadingVBA & Python
Published by Excelgoodies · 2 days ago
In 2025, automation tools like Python and Power Automate dominate the spotlight — but VBA still holds its ground. For quick Excel automation, macros, and data tasks, VBA often beats modern tools. Here are 10 real-world scenarios where VBA still wins.
Keep ReadingVBA & Python
Published by Excelgoodies · 2 days ago
Excel doesn’t have to be a time-drain. In 2025, smart VBA hacks let you cut down manual work, streamline processes, and boost productivity like never before. Get ready to transform your spreadsheets.
Keep Reading