Havish Madhvapaty

Financial Analysis and Visualization using Power BI [SRCC GBO]

BULLET CHART

CLUSTERED BAR, STACKED BAR, 100% STACKED BAR

CLUSTERED, STACKED, 100% COLUMN CHART

COMBO CHART

DYNAMIC CHART USING FORM CONTROLS

DYNAMIC PIVOT CHARTS SLICERS AND TIMELINE

FILLED MAP, 3D MAP

FUNNEL

GAUGE CHART

HEAT MAP

INFOGRAPHICS

Gen AI Chat GPT + Python No Code

Automate Financial Data Cleaning, Modeling and Dashboarding with Power BI

COMPLETE TABLEAU COURSE

CHARTS

PowerBI Tableau Excel YTD as per Fiscal Year

Learn Excel What-If Analysis (Scenario Manager, Goal Seek, Data Table, Solver)

001 EXCEL SORT + UNIQUE FUNCTION

Append arrays in Excel using FILTERXML and LAMBDA

076 - VLOOKUP Function Argument

ROW CONTEXT AND FILTER CONTEXT

Create multiple documents using Mail Merge (with File Names picked from Excel)

Extract Folder and SubFolder Names in Excel using VBA

Reference Lines on Excel, Power BI, Tableau, Gen AI, and Python

Complete Power BI Course

020/100: Dynamic Form Control with Month and Variable Selection

Unique Values excluding Header

DAX FUNCTION CATEGORIES

Automate Pivot Tables with VBA

LINE BREAK WITH CODE AND CHAR

Find Repeat Customers

AVERAGE PER CATEGORY : POWER BI VS TABLEAU VS EXCEL

Zip and UnZip using VBA

023 Use AI to Write VBA Code

057 - STOP COLUMN WIDTH FROM CHANGING

Power BI - Change Currency to INR with Lakhs

CONVERTING NOMINAL RATE TO EFFECTIVE RATE

Pivot Table Summarize vs GROUPBY vs SUMMARIZE

PYTHON - COMBINE MULTIPLE EXCEL FILES, APPLY MERGE

VBA vs Apps Editor vs TypeScript

Find Last Row with Value (Text or Number)

WORKING WITH TEXT

032 - SHORTCUTS IN SLIDESHOW MODE

002 ADD PREFIX AND SUFFIX

021 - CONVERT PDF INTO PPT

CALCULATING CUMULATIVE PRINCIPAL AND INTEREST

Master Data Cleaning and Preparation [16 August 2022]

Excel Outlook Automation - Send Multiple Emails with Attachment

006 XLOOKUP WITH PARTIAL MATCH

Show Items in Custom Order in Power BI

Dynamic Ref Line on Excel, Power BI and Tableau

Convert multiple CSV to Excel

VBA - Combine Multiple Excel Files

003 TRANSPOSE WITH LINK