Posted inPower of Microsoft Office
Pareto Chart: Expose the Vital Few Contributors in Your Data Visualization
See how to build a Pareto Chart in Excel in two different methods to expose the vital few contributors in your data visualization.
Posted inPower of Microsoft Office
Make Vital Few Contributors Stand Out in Your Visuals Using Treemaps and Maps
Create visuals that make the vital few contributors in your data stand out using Treemaps and Maps in Excel.
Posted inPower of Microsoft Office
Convert Numbers to Words in Excel
NumberToWords is a significant custom Excel function in the toolbox of Accounting and Finance folks. It helps them to write numeric monetary values in words.
Posted inPower of Microsoft Office
Building Gauge Visualization in Excel
Gauge visualization is often used to display a single quantitative measure compared to a preset target value. This is how to build it in Excel.
Posted inPower of Microsoft Office
Combine Cells in Excel using the TEXTJOIN() Function
Use TEXTJOIN function to combine text from multiple ranges in Excel with the ability to specify a delimiter used between text values.
Posted inPower of Microsoft Office
Using Goal Seek to Back-Solve a Formula in Excel
Using Goal Seek in Excel to back-solve a formula for a specific input value that drives a predefined output.
Posted inPower of Microsoft Office
Creating a Heatmap using XLOOKUP and Conditional Formatting
Using XLOOKUP and Conditional Formatting to create a heatmap that gives a quick insight and a story to tell about COVID during 2021 around the globe.
Posted inPower of Microsoft Office
When is Using “SWITCH” Function More Efficient Than Using “IFS” in Excel?
IFS can be used instead of SWITCH in Excel but not necessarily the opposite. Both are important. Each one is better used than the other in specific situations.
Posted inPower of Microsoft Office
Using “IFS” Function instead of Nested “IF” in Excel
Using IFS in Excel instead of nested IF to check whether one or more conditions are met and to return a value that corresponds to the first TRUE condition.
Posted inPower of Microsoft Office
Using NLP in Excel with the Analyze Data Wizard
Using NLP in Excel to answer your narrative questions and get insights into your data with the Analyze Data wizard.