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 · 4 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 ReadingPower Automate
Published by Excelgoodies · 5 days ago
Tired of spending hours on repetitive tasks? Power Automate workflows can handle daily emails, approvals, reminders, and reporting automatically. These 10 practical examples show how to save time, reduce errors, and boost productivity. Discover how automation can free your workday in 2025.
Keep ReadingVBA & Python
Published by Excelgoodies · 5 days ago
Accounting teams rely on Excel for almost everything: journal entries, reconciliations, month-end close, and financial reporting. While ERP systems (like SAP, Oracle, or Dynamics) handle core processes, accountants often spend hours cleaning data, posting entries, and reconciling accounts manually in Excel.
Keep ReadingVBA & Python
Published by Excelgoodies · 6 days ago
Whenever the topic of VBA (Visual Basic for Applications) comes up, there’s always a heated reaction. Some say it’s outdated. Others think only IT departments can use it. Yet millions of professionals still rely on VBA every day — especially in finance, accounting, and operations.
Keep ReadingPower Automate
Published by Excelgoodies · 6 days ago
Struggling with slow approvals, messy onboarding, or inconsistent reporting? Power Apps + Power Automate can solve the top 5 business problems faster in 2025. Learn how these low-code tools streamline workflows, reduce errors, and save valuable time. Empower your team to work smarter, not harder.
Keep Reading