Week 6 – Advanced Excel for Supply Chain Reporting ✅
Today, I took my students through the first half of Week 6, focusing on foundational tools that transform messy operational data into professional supply chain reports.
What we covered:
🔹 Advanced Conditional Formatting
– Applied to logistics data: delayed shipments (red), delivered (blue), in-transit (yellow)
– Set up stock-out risk alerts on inventory sheet based on reorder levels
🔹 Data Validation
– Created dropdown menus for Supplier and Region filtering
– Ensured data integrity for cleaner analysis
🔹 Dynamic Charts
– Built charts that update automatically as data changes
– Used for visualizing lead time trends and logistics costs by supplier
🔹 Power Query for Data Transformation (where we stopped today)
Real data used in class:
· Logistics data (26 orders: lead time, cost, delivery status, supplier)
· Inventory data (26 SKUs: current inventory, reorder level, stock-out risk)
Student takeaway:
Power Query alone saves hours of manual Excel work. One refresh = clean, analysis-ready data.
📅 Continuing Friday – Advanced Power Query, Scenario Analysis, What-if Modelling & Professional Report Design
#SupplyChainAnalytics#AdvancedExcel#PowerQuery#ConditionalFormatting#DataValidation#DynamicCharts#ExcelBootcamp#ProofOfWork
Day 9 of Data Analysis
Today's focus: Conditional formatting in Power BI. Conditionalformatting is changing the appearance of values based on conditions. Instead of just using numbers you use color,data bars, icons.
#DataAnalysis
✨ Dynamic Icons in Azure Maps in Power BI
New in Power BI!
Step 1: Prepare the Data
Create a table with Latitude and Longitude fields.
Step 2: Build the Azure Map
Insert an Azure Maps visual in Power BI.
Choose a marker type.
Built-in and custom icons are available starting with the January 2026 update!
Step 3: Apply Conditional Formatting NEW!
Use conditional formatting for marker rotation (0–360 scale) and apply conditional formatting for marker color.
Very cool
#powerbi#azuremap#conditionalformatting
Users expect more than basic grids—they want familiar spreadsheet reporting in apps. With Spread .NET, a .NET spreadsheet component, you can deliver pivot tables, formulas, data binding, and export-ready layouts that feel familiar and powerful.
Build financial reports, dashboards, and trackers with intuitive UI, conditional formatting, and print-ready views. See how Spread .NET brings advanced spreadsheet reporting to your enterprise app: bit.ly/4nb8kLJ#dotnet#spreadsheets#microsoftexcel#reporting#pivottables#formulas#databinding#dashboards#conditionalformatting#developers#coding
Let your data speak for itself! Conditional Formatting is a game-changer for building reports. For more free, in-depth Excel training, subscribe to my YouTube channel (Link in Bio)! #ExcelTips#ConditionalFormatting#DataAnalysis#Productivity
Master Conditional Formatting in Excel
lnkd.in/dfNd6i9X
Unlock the true power of your data with this comprehensive CrispExcel webinar, now available as a recorded video! In this session, we dive deep into Conditional Formatting, one of Excel's most visual and impactful tools.
Whether you're tired of sifting through rows of numbers or want to highlight critical insights instantly, this webinar is for you. Learn how to transform your raw data into dynamic, easy-to-understand visual dashboards.
In this webinar, you'll discover how to:
*Highlight key trends: Quickly spot highs, lows, duplicates, and unique values.
*Visualize data: Use data bars, colour scales, and icon sets to bring your spreadsheets to life.
*Apply rules effectively: Master various rule types, including 'Greater Than', 'Less Than', 'Top/Bottom', and custom formulas.
*Manage and edit rules: Keep your formatting organized and efficient.
Identify outliers: Use conditional formatting to instantly pinpoint data anomalies.
*Create dynamic dashboards: Build interactive reports that update automatically.
Perfect for anyone looking to enhance their Excel skills and present data more effectively. Stop just looking at data, start seeing it!
#CrispExcel#ExcelTutorial#ConditionalFormatting#ExcelTips
Learn to Use Conditional Formatting in Excel to highlight trends, spot errors, and make your data Pop!
Stand a chance to take your DA skills to the next level with us📊
#ExcelTips#ConditionalFormatting
1/2...