ExcelHow to Create and Customise Radar Charts in Microsoft Excel
Evaluating multi-dimensional datasets—such as comparing employee competency ratings across multiple skills, benchmarking competing software products...
ExcelHow to Create and Customise Treemap Charts in Microsoft Excel
Visualising multi-tiered categorical data such as departmental budgets, global product inventory by category and sub-category,...
ExcelHow to Create and Customise Pareto Charts in Microsoft Excel
When analysing customer complaints, product defects, software bug reports, or project costs, businesses often need...
ExcelHow to Create and Customise Funnel Charts in Microsoft Excel for Sales Pipelines
Tracking conversion drop-offs across sales pipelines, recruitment funnels, marketing lead funnels, and customer checkout flows...
ExcelHow to Create and Customise Sunburst Charts in Microsoft Excel for Hierarchical Data
Visualising multi-tiered categorical data such as company organisational hierarchies, multi-level product revenue streams, or departmental...
ExcelHow to Create and Customise Box and Whisker Charts in Microsoft Excel
Box and Whisker charts (also known as box plots) are powerful statistical visualisations designed to...
ExcelHow to Use the STOCKHISTORY Function in Microsoft Excel to Track Market Prices
Importing historical financial data and stock closing prices into Excel historically required manual CSV downloads...
ExcelHow to Use the FORMULATEXT Function in Microsoft Excel to Inspect and Audit Formulas
Auditing complex financial models and engineering spreadsheets often requires checking the underlying formula logic in...
ExcelHow to Use the SCAN Function in Microsoft Excel for Running Totals and Accumulations
Calculating running totals, cumulative balances, or rolling string concatenations in Microsoft Excel has traditionally required...
ExcelHow to Use the PERCENTOF Function in Microsoft Excel to Calculate Proportional Shares
Calculating the proportion that a subset of data represents relative to an overall total has...
ExcelHow to Generate Dynamic QR Codes in Microsoft Excel Using the IMAGE Function
Learn how to generate dynamic, scannable QR codes directly inside Microsoft Excel cells using the...
ExcelHow to Use the TRIMRANGE Function in Microsoft Excel to Clean Dynamic Arrays
Learn how to use the TRIMRANGE function and trim reference operators in Microsoft Excel to...
ExcelHow to Use ARRAYTOTEXT and VALUETOTEXT Functions in Microsoft Excel
Learn how to use ARRAYTOTEXT and VALUETOTEXT in Microsoft Excel to convert cell ranges and...
ExcelHow to Use the PIVOTBY Function in Microsoft Excel to Create Dynamic Cross-Tabulations
Summarising multi-column business records in Microsoft Excel has traditionally required inserting a Pivot Table. In...
ExcelHow to Create Dynamic Dependent Drop-Down Lists in Microsoft Excel
Data entry errors in spreadsheets often occur when users select mismatched combinations—such as selecting ‘France’...
ExcelHow to Use the TEXTSPLIT Function in Microsoft Excel to Separate Delimited Text
Splitting text strings containing commas, hyphens, slashes, or custom delimiters historically required relying on Excel’s...
ExcelHow to Use the LET Function in Microsoft Excel to Optimise Complex Formulas
In large financial models, engineering spreadsheets, and corporate reporting dashboards, formulas frequently grow into complex,...