Welcome to “Data to Decisions” – a comprehensive series dedicated to transforming your Excel skills. Whether you’re a beginner or an advanced user, this series is tailored to help you navigate through the complexities of Microsoft Excel with ease. Our focus is on real-life scenarios, providing practical solutions to the challenges you face in data management at work.

From understanding the nuances of Excel formulas and functions to mastering the 7-step process outlined in our ‘Data to Decisions’ model—Collect, Explore, Prepare, Model, Calculate, Visualize, and Analyze— “Data to Decisions” addresses a wide array of topics. Each article and video is crafted to guide you step by step, turning intricate data-related tasks into manageable operations.

Data to Decisions

Featured Pages

Column Chart in Excel

Learn everything from what a column chart is and when to use it to some of the best formatting tips for achieving an easy-to-interpret visual.

Date Formulas in Excel

Stay tuned for our upcoming hub page dedicated to excelling with date formulas in Excel. From basic date functions to advanced calculations, we’ll cover everything you need to know to manipulate and analyze dates in Microsoft Excel with ease.

releasing soon

Products

Data Visualization Toolkit

Welcome to the inaugural release of the Data Visualization Toolkit by Indzara!

Data Visualization Toolkit
$39 Add to cart

Our toolkit is meticulously crafted to streamline your charting process while delivering visually stunning results.

The Instant Chart Maker template offers 32 pre-designed column chart templates, allowing you to create impactful visualizations with just a few clicks.

Data Transformation Toolkit

SNEAK PEAK

Designed to be your go-to resource for mastering date manipulation in Excel, this toolkit features a comprehensive collection of over 300 formulas.

From basic date calculations to intricate transformations, our toolkit covers a wide range of scenarios commonly encountered in Excel data analysis.

The Illustrative Column Chart Guide

Quick 1-page instructions for chart creation

Spotlight Tutorials

Our Masterclass in Excel Reports

Unlock the full potential of Excel as you immerse yourself in our in-depth master classes.
From foundational concepts to advanced techniques, each tutorial is meticulously crafted to provide you with the skills and confidence to excel in Report and Dashboard creation.

Play

The Data to Decisions Playlist

Learn essential Excel skills through easy-to-follow tutorials covering various topics, from creating charts to using advanced functions.

Search From Our Collection Of Excel Tutorials

Title	Description	Category
Find Unique Values with Formulas	Learn how to quickly find “unique” values in Excel using the UNIQUE function, instantly in your spreadsheets!	Data to Decision, Text Manipulation
Get Distinct Values in Excel	Learn the simplest way to extract distinct values from a list in Excel using the UNIQUE function in this blog.	Data to Decision, Text Manipulation
Extract Duplicate Values in Excel	Learn how to quickly find duplicate values in Excel using a combination of UNIQUE, COUNTIF, and FILTER functions.	Data to Decision, Text Manipulation
Extract Usernames from Email Address in Excel	This post is all about extracting the username part of email addresses. Learn the most simple method using TEXTBEFORE function in Excel.	Data Extraction, Data to Decision
Extract Domain Names from Email Address in Excel	This post shares the quickest way to extract domain names from email addresses using the TEXTBEFORE and TEXTAFTER functions in Excel.	Data Extraction, Data to Decision
Extract Extensions from Email Addresses in Excel	Learn to use the TEXTAFTER function in Excel to extract only the extensions from email addresses, instantly.	Data Extraction, Data to Decision
How to Calculate the Starting Dates of Months in Excel?	By the use of DATE, and SEQUENCE functions learn the simplest way to calculate the starting date of any month through this post	Data to Decision, Date Transformation
How to Replace Strings and Handle Nulls in Excel	Discover the simplest way to replace strings and manage null values in Excel using the IF function - an essential step in data preparation	Data Preparation, Data to Decision
How to Replace Partial Strings in Excel	Learn a simple technique for replacing partial text strings in Excel, optimizing data presentation, and ensuring consistency in data analysis.	Data Preparation, Data to Decision
3 Ways of Text Case Conversion in Excel	Discover a quick method for case conversion: Learn the practical uses of the Lower, Upper, and Proper functions in Excel	Data Preparation, Data to Decision, Text Manipulation
Fill Missing Values in Excel by Fill-Down Technique	Discover essential Excel techniques for filling missing values by fill-down. Learn how to use the IF and OFFSET functions to achieve this.	Data Preparation, Data to Decision
Fill Missing Values in Excel by Fill-Up Technique?	Discover essential Excel techniques for filling missing values by fill-up. Learn how to use the IF and OFFSET functions to achieve this.	Data Preparation, Data to Decision
How to Calculate the Ending Dates of Months in Excel?	Using the powerful DATE, EOMONTH and SEQUENCE functions in Excel, learn the simplest way to calculate the ending date of any month	Data to Decision, Date Transformation
How to Count the Number of Weekdays in a Month in Excel?	This post guides you through the use of the SEQUENCE, WEEKDAY, and SUM functions to count the number of weekdays of a month in Excel.	Data to Decision, Date Transformation
How to Generate all the Dates of a Year in Excel?	This post shows how to use the SEQUENCE, and DATE functions in Excel to generate all the dates for an year.	Data to Decision, Date Transformation
Generate all the Dates of a Month in Excel	Learn the quickest way to generate all the dates of a month using simple Excel formulas through this post.	Data to Decision, Date Transformation
How to Generate every Nth Day of a Week in Excel?	By employing the SEQUENCE function in Excel, learn the simplest method to generate every nth day from a given date	Data to Decision, Date Transformation
How to Generate Only a Specific Weekday in Excel?	Learn to generate a specific weekday of a week using simple Excel functions like WEEKDAY, FILTER and SEQUENCE from this post	Data to Decision, Date Transformation
How to Skip Weekends and Generate only Working Days in Excel?	Using Excel's simple yet powerful functions like WEEKDAY, SEQUENCE and FILTER, learn how to skip weekends and generate only working days	Data to Decision, Date Transformation
Generate the First Sunday of the First Week of a Month in Excel.	Learn to generate the first Sunday that occurs on the first week of a month with simple Excel formulas through this blog	Data to Decision, Date Transformation
Create a Dynamic Monthly Calendar with a Single Formula in Excel	With a single formula, you'll learn to create a dynamic monthly calendar instantly in Excel through this post	Data to Decision, Date Transformation
How to Compare Two Lists Using Formulas in Excel?	Discover the quickest and easy-to-follow technique to compare two lists in Excel using simple Excel functions in this post.	Data Comparison, Data to Decision
How to Compare Two Lists using Conditional Formatting in Excel?	Using conditional formatting, learn to quickly compare two lists in Excel. An extremely useful technique when you want to highlight changes in the source itself.	Data Comparison, Data to Decision
How to Extract Top/Bottom N Values from Lists in Excel?	Learn to effortlessly extract the top or bottom N values from your lists in Excel with this post. Elevate your Excel skills and gain deeper insights into your lists with our practical, easy-to-implement tips!	Data Extraction, Data to Decision
How to Sort Data by Multiple Columns in Excel?	Using formulas and conditional formatting this post shows a simple, visually appealing technique to sort multiple columns of your data in Excel instantly.	Data Extraction, Data to Decision
How to calculate Profitability by Product in Excel?	This post aims at using simple yet dynamic Excel functions to calculate the profitability by product when you have a list of transactions in Excel.	Data Extraction, Data to Decision
Learn to create a scatter plot with two series in Excel	Unlock the secrets of data visualization with our latest blog on creating a scatter plot. This blog shares the step-by-step process of transforming your raw data into a vivid, multi-series scatter plot.	Data to Decision, Visualization
Learn to create a bubble chart with two series in Excel	Visualization is made easy with our Data to Decisions blogs! Get a step-by-step tutorial on creating a bubble chart with two series and the analysis that can be made with this visual in this post.	Data to Decision, Visualization
How to Create Image-Based Drop-Down Lists in Excel?	Unlock the power of visual data in Excel! Learn effortlessly how to use the IMAGE function for creating interactive drop-down lists with descriptive alternate text, transforming the way you display information in your spreadsheets.	Data to Decision, Visualization
How to filter non-adjacent columns of data in Excel using formulas?	This blog teaches you the simplest technique to extract data from an Excel table using the dynamic FILTER function. Learn how to get non-adjacent columns, in any order with this powerful, dynamic Excel function.	Data Extraction, Data to Decision
How to extract data from a web URL into Excel?	Discover an efficient method for importing web-based data directly into Excel with Power Query. This blog covers the step-by-step instructions to streamline your data extraction process.	Data Extraction, Data to Decision
How to Extract Images Dynamically from Web URLs in Excel?	Master the art of dynamically extracting images from web URLs into Excel using the IMAGE function. This post offers practical tips and step-by-step instructions to enhance your spreadsheets with visual data	Data Extraction, Data to Decision
Learn to Remove a Specific Starting Character from a Text String Using Power Query	Master the essential Power Query skill of removing specific starting characters from text strings with this post . This tutorial offers step-by-step instructions, practical examples, and expert tips to help you efficiently clean and manipulate your data in Power Query.	Data Extraction, Data to Decision
How to unpivot a grid matrix data in Power Query?	Learn how to transform grid matrix data into a needed format by unpivoting columns with Power Query in Excel. This tutorial guides you through the steps of unpivoting data from other columns for better analysis and visualization.	Data to Decision, Data Transformation
Learn to Extract only UPPER Case Letters from the End of a String.	By using Excel’s CODE function, learn the easiest method to extract only the upper case characters from the end of a text through this blog post.	Data Extraction, Data to Decision
How to Filter Data Based on Matching Columns in Excel?	Learn to use one of Excel’s most popular, versatile, and powerful functions: FILTER to extract based on matching texts in a column. This post shares the step-by-step process of achieving this within minutes!	Data Extraction, Data to Decision
How to look up data using XLOOKUP in Excel?	XLOOKUP is a powerful and dynamic function that helps streamline the process of data retrieval in large datasets. Learn more about this function and how to use this through this blog.	Data Extraction, Data to Decision
Create a Banded Row Appearance of a Report in Excel using Conditional Formatting.	Looking to create aesthetically pleasing, visually appealing reports in Excel? This blog post teaches you how to use conditional formatting to create a banded row appearance to enhance your visuals.	Data to Decision, Visualization
How to create a dynamic column chart in Excel?	Discover the step-by-step guide to creating dynamic column charts in Excel, a vital tool for data analysis and presentation.	Data to Decision, Visualization
How to Create a Dynamic Column Chart Sorted by Measure Value in Excel?	Explore a crucial enhancement for dynamic column charts: sorting by measure value through this blog post. Learn the art of creating charts in Excel that can be sorted in both ascending and descending order.	Data to Decision, Visualization
Create a Dynamic Column Chart Limited by a Measure Value in Excel	This blog delves into creating dynamic column charts with a specific focus: limiting the chart by a measure value. Discover the techniques to set bounds in your dynamic charts, ensuring your data visualization is both precise and impactful.	Data to Decision, Visualization
How to Create a Column Chart with Dynamic Number of Columns?	Master the flexibility of Excel for visualization with our blog on creating column charts with a dynamic number of columns.	Data to Decision, Visualization
Create a Column Chart that Highlights the Maximum/Minimum Columns	Discover the technique to highlight maximum and minimum value columns in your Excel column charts with this blog post from Data to Decisions.	Data to Decision, Visualization
Learn to Create a Filled Map with Categories in Excel	Embark on a journey of visual discovery with our tutorial on creating a filled map with categories visuals in Microsoft Excel with this blog!	Data to Decision, Visualization
How to Compare Two Lists Using Power Query in Excel?	Master the art of list comparison in Excel: Our post shows you how to use Power Query to easily compare items between two lists.	Data Comparison, Data to Decision
How to Create a Filled Map Visual in Excel?	Learn how to craft a filled map visual in Excel with our comprehensive guide, perfect for transforming geographic data into interactive maps.	Data to Decision, Visualization
How to Create Data Bars in Excel?	This post is all about Excel formatting on creating data bars, a powerful tool for enhancing your spreadsheets with visual data insights.	Data to Decision, Visualization
How to Create a Column Chart with Multiple Series in Excel?	Uncover the steps to build a column chart with multiple series in Excel, enhancing your data analysis and presentation with layered, comparative insights.	Data to Decision, Visualization
How to Create a Column Chart with a Single Target in Excel?	Learn the simplest way to create a column chart with a single target line in Microsoft Excel with this post.	Data to Decision, Visualization
How to Create a Column Chart with Single Target and Highlight in Excel?	Learn to create a visually appealing column chart in Excel that can highlight columns above a given target or goal value.	Data to Decision, Visualization
How to Create a Column Chart with Multiple Targets in Excel?	Uncover the steps to build a column chart with multiple targets in Excel, enhancing your dashboards and presentation!	Data to Decision, Uncategorized, Visualization
How to Create Columns within a Column Chart in Excel?	This article is about creating a unique customization to a column chart by including a column within a column chart.	Data to Decision, Visualization
How to Filter Data using Multiple Conditions in Excel?	Learn how to use the dynamic and powerful Excel function: the FILTER function to filter your data based on multiple conditions.	Data Extraction, Data to Decision
How to Create a Line Chart with Multiple Series in Excel?	Discover how to swiftly and easily create a line chart with multiple series in Excel with our step-by-step guide.	Data to Decision, Visualization
How to Create a Line Chart with Highlighted Min/Max Points?	Elevate your dashboards and presentations with a line chart with highlighted minimum and maximum points in Excel, within minutes!	Data to Decision, Visualization
How to Create a Line Chart with Custom Marker Highlights?	This blog post is your guide to create simple, visually engaging line charts that can highlight markers above or below custom values.	Data to Decision, Visualization
How to Create a Multiple Series Line Chart that Highlights Only One Line?	Custom line charts in Excel: Learn the simplest way to create a multiple series line chart that highlights only one line with in this post.	Data to Decision, Visualization
How to Create an Interactive Line Chart with Dynamic X-Axis?	This post gives you the quickest method to create an interactive line chart where the X-axis can be controlled dynamically.	Data to Decision, Visualization
How to Create a Vertical Container Filler Chart (Progress Tracker) in Excel?	Tracking progress made easy! With this post, learn the simplest method to create a progress tracker in column charts in Microsoft Excel.	Data to Decision, Visualization
How to Create a Column Chart for Variances with Different Colors Excel?	Master the art of visualizing with our blog on creating a Column Chart to display Variances in Excel, with simple steps.	Data to Decision, Visualization
How to Create a Vertical Lollipop Chart in Microsoft Excel?	Unleash the power of Excel with our quick guide on creating Lollipop Charts, the visually engaging way to depict actual metrics effectively.	Data to Decision, Visualization
How to Create a Column Chart with Actual, Target, and Variance in Excel?	Elevate your Excel dashboards with our blog post on constructing a Column Chart that neatly displays the actuals, targets, and variances of a measure.	Data to Decision, Data Visualization
How to Create a Stacked Column Chart with Total in Microsoft Excel?	Streamline your data presentation with this post on creating a Stacked Column Chart that showcases data with aggregate totals.	Data to Decision, Visualization
How to Create Column Chart with Line for Time Series Data in Excel?	With this blog, learn to create an actual vs. target chart in Excel. Our post simplifies the steps needed to create this amazing visual!	Data to Decision, Visualization
How to Create a Column Chart with Line for Time Series and Highlight in Excel?	Elevate your charts with our insightful post on creating one that not only compares actual vs. target but also highlights achieved targets.	Data to Decision, Visualization
How to Create a Floating Column Chart in Excel?	Elevate your data visualization with a step-by-step guide to creating a Floating Column Chart in Excel- a great addition to your reports.	Data to Decision, Visualization
How to Create a Vertical Dumbbell Chart in Excel?	Learn the quickest method to create a dumbbell chart in Excel, a great addition to your regular dashboards and reports!	Data to Decision, Visualization
How to Create a Chart with Variance Arrows with Actual and Target Columns?	Learn the simplest method to create a dynamic Actual vs Target and variances displayed with arrows chart in Excel. Perfect for providing quick insights.	Data to Decision, Visualization
How to Create a Column Chart with Multiple Series and Small Multiple?	Learn to create a small multiple column chart that displays the data comparison and analysis and enhance your visual reporting.	Data to Decision, Visualization
How to Create a 100% Stacked Column Chart with Totals in Excel?	Craft a 100% stacked column chart in Microsoft Excel, showcasing not just the proportional contributions of each data series but also their cumulative totals for enhanced visualization.	Data to Decision, Visualization
How to Create a Chart with Variance Arrows with Actual Columns and Vertical Target Line?	Become proficient in data storytelling by following this post to design an Actual vs. Target chart in Excel. This tutorial includes instructions for adding variance arrows, enabling rapid and insightful analysis.	Data to Decision, Visualization
How to Create a Vertical Bullet Chart in Microsoft Excel?	Elevate your data visualization expertise with advanced bullet chart techniques in Excel, designed for a sophisticated comparison of actual performance against set targets, offering deeper insights into your metrics.	Data to Decision, Visualization
How to Create a Column Chart Comparing Three Measures in Excel?	Acquire the crucial techniques to accurately contrast Actual, Budget, and Forecast data through a straightforward chart designed in Microsoft Excel.	Data to Decision, Visualization
How to Create a Vertical Slider Chart in Excel?	Learn how to create a Slider Chart in Excel - Enhance your presentations with this simple chart and turn raw data into compelling visuals	Data to Decision, Visualization
How to Create a Slider with Context using Stacked Columns in Excel?	Elevate your data visualization skills by learning to create a Stacked Column Chart with a Slider in Excel through this post.	Data to Decision, Visualization
How to Create a Vertical Matchstick Chart in Excel?	This post will walk you through the steps to turn numbers into engaging, clear visuals by creating a Matchstick chart in Excel.	Data to Decision, Visualization
How to Create a Progress Tracker Using Stacked Column Chart in Excel?	Follow this post to create a progress tracker using stacked column charts within minutes in Microsoft Excel!	Data to Decision, Visualization
How to Create a Waterfall Chart in Excel?	Learn to create detailed Waterfall Charts in Excel with this blog post. We cover three variations to suit any data story you want to present!	Data to Decision, Visualization
How to Create a Dynamic Stock Price History Chart in Microsoft Excel?	Learn to create a stock price history chart in Excel, a perfect tool for tracking market trends - ready in minutes!	Data to Decision, Visualization
How to Create a Simple Column Chart by Category in Excel?	Turn your raw data into a compelling visual with a simple column chart in Microsoft Excel, apt for comparisons by category.	Data to Decision, Visualization
How to Create a Simple Column Chart by Date in Excel?	Create a visually appealing column chart in Excel for your time series data. This is great for comparing your data across time periods	Data to Decision, Visualization
Create a Column Chart with Multiple Targets and Highlights in Excel	Uncover the steps to build a column chart with multiple targets in Excel, highlighting the achieved columns for an enhanced dashboard!	Data to Decision, Visualization
How to Create a Dynamic Waterfall Chart in Excel?	This post is all that's needed to create stunning, dynamic waterfall charts in Excel. Learn to build these charts instantly with this post.	Data to Decision, Visualization
How to Create a Simple Bar Chart in Excel?	This post walks you through all the steps required to create a visually appealing simple bar chart in Microsoft Excel.	Data to Decision, Visualization
How to Create a Bar Chart with Multiple Series in Excel?	Learn how to create a dynamic bar chart with multiple data series in Excel for clear and compelling data visualization.	Data to Decision, Visualization
How to Create a Simple Stacked Bar Chart in Excel?	Learn how to create a stacked bar chart in Excel for effective data comparison and visualization in simple steps.	Data to Decision, Visualization
How to Create a Stacked Bar Chart with Totals in Excel?	Learn how to create a stacked bar chart with totals in Excel for effective data comparison and visualization in simple steps.	Data to Decision, Visualization
How to Create a 100% Stacked Bar Chart in Excel?	Learn how to create a 100% stacked bar chart in Excel to visualize compositions in your data instantly with this blog post!	Data to Decision, Visualization
How to Create a 100% Stacked Bar Chart with Totals in Excel?	Learn how to create a 100% stacked bar chart with totals in Excel to visualize the composition in your data with totals for each category	Data to Decision, Visualization
How to Create Bar within a Bar Chart in Excel?	Discover how to create a bar within a bar chart in Excel for detailed data comparison like target versus actuals.	Data to Decision, Visualization
How to Create a Simple Line Chart in Excel?	Learn how to create a simple line chart in Excel with our easy-to-follow guide, complete with step-by-step instructions and screenshots.	Data to Decision, Visualization
How to Create a Vertical Arrow Chart in Excel?	Discover how to create a vertical arrow chart in Excel with our comprehensive blog post, featuring clear step-by-step instructions.	Data to Decision, Visualization
How to Create a Box and Whisker Plot in Excel?	Learn step-by-step how to create a dynamic Box and Whisker Plot in Excel to visually identify the distribution of your data using quartiles.	Data to Decision, Visualization
How to Create a Tornado Chart for Only Positive Values in Excel?	Learn how to create a tornado chart in Excel with our step-by-step post. Perfect for comparative analysis, create this chart with simple steps.	Data to Decision, Visualization
How to Create a Pareto Chart in Excel?	This blog is all you need to create a simple Pareto chart in Excel. Analyze the influencing factors of your data with a single visual, instantly!	Data to Decision, Visualization
How to Create a Vertical Dot Plot in Excel?	Learn how to create a vertical dot plot in Excel with this post. Create this chart and make your distribution analysis easier!	Data to Decision, Visualization
How to Create a Dumbbell Chart with Scatter Plot in Excel?	Learn step-by-step how to create a dynamic Dumbbell Chart using a Scatter Plot in Excel to elegantly display ranges in values.	Data to Decision, Visualization
How to Create a Bubble Chart in Excel?	Learn how to create a bubble chart in Excel to visually compare three sets of data effortlessly. Perfect for data analysis and presentations.	Data to Decision, Visualization
How to Create a Floating Bar Chart in Excel?	Learn how to create a floating bar chart in Excel to visually compare ranges in data effortlessly. A truly unique chart to your reports!	Data to Decision, Visualization
How to Create a Tornado Chart for Sensitivity Analysis in Excel?	In this post, you'll learn the simple steps required to create a tornado chart for sensitivity analysis in Microsoft Excel.	Data to Decision, Visualization
How to use the GROUPBY function in Microsoft Excel?	14 practical uses of the new GROUPBY function in Microsoft Excel	Data to Decision, Data Transformation
How to Unpivot Data in Excel using formulas?	Unpivoting data is a common task in data transformation. In this article, we will learn how to use simple formulas to unpivot.	Data to Decision, Data Transformation
Enter your predictions for the 2024 U.S. Elections	Use this simple excel template to enter your predictions for the U.S Presidential elections for 2024, and let the template calculate the electoral votes, chances of each candidate winning and any scenarios for a tie result.	Data to Decision, Visualization
How to use the XLOOKUP function in Excel - 9 practical examples.	Explore nine practical xlookup examples that demonstrate the incredible flexibility of XLOOKUP, showing you how to maximize its potential for solving real-world challenges.	Data to Decision, Data Transformation

Data to Decisions

Featured Pages

Column Chart in Excel

Date Formulas in Excel

releasing soon

Products

Data Visualization Toolkit

Data Visualization Toolkit

Data Transformation Toolkit

SNEAK PEAK

The Illustrative Column Chart Guide

Quick 1-page instructions for chart creation

Spotlight Tutorials

Our Masterclass in Excel Reports

Unlock the full potential of Excel as you immerse yourself in our in-depth master classes.
From foundational concepts to advanced techniques, each tutorial is meticulously crafted to provide you with the skills and confidence to excel in Report and Dashboard creation.

easy-to-follow tutorials

The Data to Decisions Playlist

Learn essential Excel skills through easy-to-follow tutorials covering various topics, from creating charts to using advanced functions.

Search From Our Collection Of Excel Tutorials

Support

Stay Connected, Stay Updated!

Templates

HR Templates

Small Business Templates

Project Management Templates

Stock Market Templates

Data Visualization Templates

Calendar Templates

Other Templates