All Articles by Dheeraj Vaidya, CFA, FRM
Showing 1-60 of 1,746 articles
VBA User-Defined Functions + AI: Custom Formula CreationPower BI Performance Analyzer + Copilot: Query OptimizationBest Online MBA Programs in the MidwestAI VBA Email Automation: Outlook Integration MacrosGoogle Sheets GEOCODE + Gemini: Location IntelligenceExcel Stock Data Types + AI: Real-Time FinancialsPower BI Custom Visuals + Copilot: Code-Free CreationVBA Workbook Open Events + AI: Startup AutomationGoogle Sheets QUERY + Gemini: SQL from Plain EnglishExcel Data Bars + AI: In-Cell Visualization IntelligencePower BI Key Influencers + Copilot: Driver AnalysisWhat Skills Do You Need to Build a Successful Career in AI and Machine Learning?Power BI Drillthrough Pages + AI: Context IntelligencePower BI Composite Models + AI: Hybrid Data OptimizationGoogle Sheets SPARKLINE + Gemini: Mini-Charts AutomatedVBA Custom Ribbon + ChatGPT: Personalized ToolbarsPower BI Row-Level Security + Copilot: Auto-RulesAI Excel Slicer Connections: Cross-Report IntelligenceGoogle Sheets ArrayFormula + AI: Bulk Operations Excel Power View + Copilot: Interactive Reports InstantlyPower BI AI Q&A: Natural Language Visual CreationWhat Are IT Staffing Services? A Complete OverviewVBA Application Events + AI: Workbook-Level AutomationGoogle Sheets Custom Charts + Gemini: Viz from PromptsExcel Data Model Relationships + AI: Auto-DetectionPower BI Smart Narratives + Copilot: Auto-Report WritingAI VBA Form Controls: Dynamic User Interface GenerationGoogle Sheets FILTER + Gemini: Smart Array ExtractionExcel Dynamic Named Ranges + AI: Self-Expanding LogicPower BI Decomposition Trees + AI: Root Cause InstantlyVBA Dictionary Objects + ChatGPT: Fast Lookups AutomatedPower Query Parameter Tables + AI: Dynamic ETL PipelinesVBA Worksheet_Calculate Events + AI: Real-Time TriggersGoogle Sheets Custom Functions + AI: LAMBDA Without CodePower BI Field Parameters + Copilot: Dynamic Axes InstantlyAI Excel Table Formulas: Structured References Made SmartAI Excel Data Types: Stocks, Geography, Custom ObjectsVBA Worksheet Events + AI: Proactive AutomationPower BI Bookmarks + Copilot: Dynamic StorytellingPower BI + Google Sheets: Live Data FederationVBA Error Handling + AI: Bulletproof Code GenerationPower BI AI Insights: Automatic Anomaly DetectionGoogle Sheets Custom Menus + Gemini: User InterfacesVBA Class Modules + AI: Object-Oriented Excel AppsGoogle Sheets REGEX + Gemini: Pattern MagicPower BI + Excel Live Connection: Two-Way AI SyncVBA UserForms + AI: Smart Dialog Boxes That ThinkPower BI Paginated Reports + Copilot: Instant PDFsGoogle Sheets IMPORTRANGE + AI: Cross-Sheet MasteryChatGPT for Power Query: M Code from Plain EnglishVBA Event Handlers: AI Generated Worksheet TriggersNatural Language DAX: Power BI Measures Made EasyHow to Debug VBA with AI-Powered Error DetectionPower BI AI Visuals: Smart Charts That Update ThemselvesHow to Integrate Gemini AI Directly in Excel WorkbooksGoogle Sheets LAMBDA + AI: Custom Functions InstantlyVBA + ChatGPT: Convert Excel Logic to Automation5-Minute AI Pivot Tables: Drag Less, Prompt MoreExcel Copilot vs Gemini Sheets: Complete 2026 ComparisonTop AI Tools for Excel Dynamic Arrays (2026 Edition)