Dinesh's Data to Decisions

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.

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 to Highlight Columns above a Target Value 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 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 an Actual vs Target Chart 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 an Actual vs Target Chart that Highlights Achieved Targets 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 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 an Actual vs Target Chart with Variances Displayed with Arrows?	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 Small Multiple Column Chart?	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 an Actual vs. Target Chart with Variances Displayed With Arrows - V2?	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 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 show Actual vs Budget vs Forecast 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 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 Stacked Column Chart with Slider 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 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