Channel Title: Indzara - Simple and Effective Templates Channel Description: Indzara.com provides 150+ free & premium high-quality Excel, Google Sheet and PowerBI templates covering areas of Small Business Management, HR, Project Management, Data Visualization, Finance Management, Stock Market, Calendars and more. My name is Dinesh Natarajan Mohan. I believe that simple tools can lead to effective solutions. These simple templates are designed to help us make smarter decisions, save time by automating manual tasks and eliminate human errors by leveraging computers. You will also save money by using our free and affordable premium templates. Our philosophy is SIMPLE and EFFECTIVE. This channel will have videos about templates as well as How-to videos about Excel. If you have any questions about Excel and would like us to post a solution as video, please post it as a comment. We sincerely hope the solutions are helpful and look forward to your feedback. Please Subscribe to this channel to be notified of future videos. <video> How to Unpivot Data in Excel using formulas? Description: Unpivoting data is a method in data transformation, allowing you to transform complex data into structured data. In this video, we'll show you how to unpivot data in Excel using simple formulas with TOCOL, CHOOSECOLS and SEQUENCE functions. Here’s what we’ll cover: 2:22 - Setup & Table Creation - Convert data into a table 2:40 - Creating the YEAR Column - Generate a sequence for each year. 4:31 - Generating the QUARTER Column - Repeat quarters across years. 5:42 - Creating the SALES Column - Collect data across quarters. 7:25 - Tips to use the functions for various other types of datasets. With Excel’s TOCOL and SEQUENCE functions, you can unpivot various other datasets such as monthly, annual or weekly datasets. For more read our the article on Unpivoting data: https://indzara.com/how-to-unpivot-data-in-excel/ Our Data Visualization Toolkit: https://indzara.com/product/data-visualization-excel-templates/toolkits/data-visualization-toolkit/ Don’t forget to subscribe for more Excel tutorials! </video> <video> Test your MACD Trading Strategy in Excel Description: The MACD (Moving Average Convergence Divergence) Strategy Backtester Template is an Excel-based solution that allows you to backtest their MACD trading strategies using historical market data. The template provides instant calculations and visualizations for swing trading analysis. Template https://indzara.com/product/stock-market-excel-templates/macd-strategy-backtester/ ‎ Timestamps 00:00 Introduction to MACD backtester template video 00:15 Example of backtesting TSLA stock 03:42 Three Requirements for using this solution 04:52 Limitations / Applications of the template 06:28 Backtester Template Demo - Inputs to the template 08:58 Backtester Template Demo - Output - Strategy Report Card 12:09 Trading timeline chart 13:15 Equity trend chart and Cumulative Profit/Loss chart 13:46 Trading summary and details of trades 16:59 MACD chart 19:33 Candlestick chart Videos/Links Free MACD Template video https://youtu.be/ZUsh8zHBj6o MACD Indicator template https://indzara.com/free-excel-template-for-macd-technical-indicator/ Microsoft Subscription https://www.microsoft.com/en-us/microsoft-365/ Technical calculations - Definitions https://support.indzara.com/support/solutions/articles/62000232832-macd-strategy-backtester-key-definitions-calculations FEATURES Instant calculation of trading metrics and performance indicators Trading timeline view Equity curve Cumulative profit/loss chart MACD technical indicator charts Candlestick price charts with volume Detailed trade-by-trade analysis Support for both long and short trading strategies Latest signal detection for current market conditions Customizable MACD settings Multiple signal event handling options REQUIREMENTS 1. Microsoft Subscription https://www.microsoft.com/en-us/microsoft-365/ 2. Our Template 3. Internet Access </video> <video> Master Resource Management with Our Free Excel Capacity Calculator Template Description: Are you struggling to align projects with your available workforce? Our free Excel Capacity Calculator Template is the ultimate solution for efficient resource management and project planning. This tool transforms how you can handle resource allocation, ensuring productivity, meeting deadlines, and fostering growth. 📈 Who Needs This Calculator and Why? • HR professionals aligning talent with tasks • Project managers ensuring timely project completion • Team leaders optimizing crew performance 🔑 Key Features: • Simple and customizable data entry process • Fully automated calculations and intuitive dashboard • Calendar view accounting for vacations and overtime 📥 Download Links and Detailed Instructions: Visit our blog post for all the details and to download the template and the sample file here https://indzara.com/capacity-calculator-excel-template/ #ResourceManagement #ExcelTemplate #ProjectPlanning #CapacityCalculator #FreeDownload </video> <video> Predict 2024 US Elections - Free Excel Template! Description: Are you ready to predict the 2024 U.S. Presidential race? This template helps you enter your predictions for the U.S Presidential elections for 2024, and the template will calculate the electoral votes, chances of each candidate winning and any scenarios for a tie result. Get ready to dive into the numbers and make your predictions! Read the step-by-step guide on how to use the 2024 U.S. Presidential Election Predictions Template: https://indzara.com/2024-us-election-predictions-in-microsoftexcel/ Here’s what we’ll cover: 1:09 Enter the Winner for Non-Competitive States: Start by filling in your predictions for the states that are typically non-competitive. 1:18 Automatic Electoral Vote Calculations: Based on your inputs, the template will total the electoral votes for each candidate and highlight any undecided votes. 1:37 Input Predictions for Competitive States: Enter your predictions for the states that are typically non-competitive. 2:30 Tie Scenarios Display: Any scenarios where the election could end in a tie are highlighted in the bottom right, so you can explore this rare possibility. 3:15 US Map Auto-Updates: The geographic map of the U.S. will visually update based on the data you enter. 3:34 Identify Must-Win States with a Red Flag: As you enter more predictions, any state crucial to either candidate will be flagged in red for easy identification. 4:20 Waffle Chart of Winning Chances: On the bottom left, a waffle chart will show the win probability for each candidate of the remaining states Make your predictions, learn about possible outcomes, and track the path to victory or a potential tie right from your Excel sheet! </video> <video> Dinesh's Data to Decisions | Transform your Excel Skills in 2025 Description: Welcome to "Dinesh's 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. Check the Data to Decisions Blogs here: https://indzara.com/datatodecisions/ </video> <video> Client Testimonial: Retail Business Manager Pro Description: Download our Simple and effective Retail Business Manager Pro today. The Retail Business Manager (Pro) is suited for managing inventory and sales if you are running a retail business of buying products from suppliers and selling to customers. You can manage inventory at multiple warehouse locations using this template. Download the #excel version here 👇🏽 https://indzara.com/product/retail-inventory-and-sales-manager-excel-template/ Download the #googlesheets version here 👇🏽 https://indzara.com/product/inventory-management-excel-templates/retail-business-manager-pro-google-sheets-template-multiple-locations/ #indzara #exceltips #excelformula #exceltutorials #googlesheetstutorial #googlesheetstutorials #spreadsheet </video> <video> Tornado Charts in Excel: For Only Positive Values Explained! Description: Unlock the power of Tornado Charts in Excel with our detailed tutorial focusing on scenarios where only positive values are considered. In this comprehensive video from the #datatodecisions series, we guide you step-by-step through creating a Tornado Chart, also called as a Butterfly chart to visually compare data across different categories. This chart is perfect where there are two dimensions where one of these dimensions has two possible positive values against a measure, this is your go-to chart! Check the detailed blog post to create this chart: https://indzara.com/create-tornado-chart-in-excel/ ****************************************************************************** Are you looking for a quick, instant chart-maker template where you can enter just data and have charts readily created for you? Check our latest product, the Instant Chart Maker from our Data Visualization Toolkit in Excel: https://indzara.com/product/data-visualization-excel-templates/data-visualization-toolkit/ ****************************************************************************** Check our Premium Bar Chart Excel Template here: https://indzara.com/product/data-visualization-excel-templates/bar-chart-excel-template/ Here’s our collection of Visualization templates from Indzara: https://indzara.com/data-visualization-excel-templates/ For more such tutorials, visit https://indzara.com/datatodecisions/ Don't forget to like, subscribe, and hit the notification bell for more Excel tips and tutorials! Leave your questions and comments below, and we’ll be happy to help. #excelmadeeasy #exceltips #excelchartstutorial #exceltricks #datavisualization #barchart </video> <video> Statistical Process Control Charts in Excel Description: Discover how Control Charts, also known as Statistical Process Control (SPC) charts, can revolutionize your business process monitoring. These powerful tools help you determine if your processes are operating within control by analyzing various metrics. Whether you're in eCommerce, manufacturing, finance, or IT, SPC charts can provide valuable insights. For instance, in eCommerce, measure order fulfillment efficiency, track failed orders, assess upsell effectiveness, and monitor product return rates. In manufacturing, keep an eye on product dimensions, while in finance, track billing attempts. For IT, evaluate the number of bugs and missed project deadlines. Learn how SPC charts can enhance your process control and drive improvements. To know more about this go through our detailed blog here: https://indzara.com/statistical-process-control-chart-excel-template/ ****************************************************************************** Are you looking for a quick, instant chart-maker template where you can enter just data and have charts readily created for you? Check our latest product, the Instant Chart Maker from our Data Visualization Toolkit in Excel: https://indzara.com/product/data-visualization-excel-templates/data-visualization-toolkit/ ****************************************************************************** For more such tutorials, visit https://indzara.com/datatodecisions/ #excelmadeeasy #exceltips #excelchartstutorial #exceltricks #datavisualization #spccharts #spc </video> <video> 14 Practical uses of the new GROUPBY Function Description: In this video, we delve into 14 practical applications of the new GROUPBY function in Microsoft Excel. 01:36 1. Simple Aggregation of a Value column by an attribute 03:59 2. Formatting - Adding Headers 05:20 3. Formatting - Show or Hide Totals 05:45 4. Formatting - Sorting 07:04 5. Filtering while aggregation 08:50 6. Multiple aggregations on a value column - horizontal layout 11:41 7. Multiple aggregations on a value column - vertical layout 12:23 8. Aggregations on multiple value columns (adjacent) 15:31 9. Aggregations on multiple value columns (non-adjacent) 18:06 10. Aggregations by multiple row fields (Hierarchy) 21:18 11. Aggregations by multiple row fields (Table) 23:02 12. ArrayToText Aggregations 25:24 13. How to refer to the GROUPBY result in a new formula? 26:45 14. Conditional formatting on GROUPBY result We demonstrate these features using a comprehensive dataset of 582 Test Matches played by the Indian Cricket team. Whether you're an Excel enthusiast or a data analyst, this video provides insights into optimizing your data analysis processes with GROUPBY. Join us to enhance your Excel skills and discover how this function can streamline your workflow and improve data management. We have put together a whole bunch of materials on this topic of Data to Decisions which you can check here: https://indzara.com/datatodecisions/ #indzara #datatodecisions #spreadsheet #learning #tutorial #simple #effective #solutions </video> <video> Floating Bar Charts in Excel: Step-by-Step Tutorial! Description: Welcome to the latest video from #datatodecisions In this video, we'll look at the steps to create a simple floating bar chart that can handle both negative and positive values in your data. This video guides you through setting up your data and creating visually appealing floating bar charts that are perfect for highlighting changes and comparisons over time. Enhance your data visualization skills with this practical guide. Don’t forget to like, subscribe, and hit the notification bell for more Excel tutorials. Share your questions and feedback in the comments below! ****************************************************************************** Are you looking for a quick, instant chart-maker template where you can enter just data and have charts readily created for you? Check our latest product, the Instant Chart Maker from our Data Visualization Toolkit in Excel: https://indzara.com/product/data-visualization-excel-templates/data-visualization-toolkit/ ****************************************************************************** We have a detailed explainer blog to create this chart here: https://indzara.com/create-a-floating-bar-chart-in-excel/ Check our Premium Bar Chart Excel Template here: https://indzara.com/product/data-visualization-excel-templates/bar-chart-excel-template/ Here’s our collection of Visualization templates from Indzara: https://indzara.com/data-visualization-excel-templates/ For more such tutorials, visit https://indzara.com/datatodecisions/ #excelmadeeasy #exceltips #excelchartstutorial #exceltricks #datavisualization #barchart </video> <video> Hijri Calendar 2025 + 24 stunning calendar designs | Download Now! Description: Welcome to our Yearly Calendar Launch, where we unveil our 25th Calendar Design, the Hijri Calendar! Thoughtfully crafted for Microsoft Excel and Google Sheets, this template combines the Hijri and Gregorian calendars. Excel: https://indzara.com/free-excel-template-for-calendar-2025-with-25-formats/ Google Sheets: https://indzara.com/google-sheets-calendar-2025-with-25-formats/ 🎥 In This Video: 1️⃣ Introducing the Hijri Calendar: A unique dual-display calendar that prominently features both Hijri dates alongside Gregorian dates. 2️⃣ Easy Customization: Learn how to adjust the year, starting month, week start day, weekends, and even add holidays or events in the settings sheet. 3️⃣ Planning Made Simple: See how holidays and events auto-sync across both calendars for efficient scheduling. 4️⃣ Printable PDF Option: Export your calendar with a single click for offline use. 5️⃣ Explore All 25 Designs: Get a glimpse of our full collection, with the Hijri Calendar as the star of the show. Timestamps 0:00 – Introduction: Welcome to our Yearly Calendar Launch! 0:03 – Introduction to 25th Calendar Design : Hijri Calendar 0:23 - Hijri Calendar Overview: Seamless integration of Hijri and Gregorian dates. 0:33 – Customizing the Settings: Adjust year, starting month, and more! 0:50 – Holidays & Events Sync: Auto-highlighted holidays and events. 0:55 – Example Customization: How to set up the current Hijri Year 1446. 1:06 – Dual-Display Feature: Prominent Hijri dates with Gregorian subscripts. 1:27 – Updating the Calendar: Includes Hijri Years 1446 and 1447, updated every December. 1:45 – Exporting to PDF: One-click export for printing. 1:58 – All 25 Designs: A look at the complete collection with the Hijri Calendar highlighted. 2:15 – Call to Action: Download the 2025 Calendar template, like, share, and subscribe. 📌 Why You’ll Love It: Perfect for managing personal, religious, or professional tasks. Designed to keep your plans organized and stress-free. 🎉 Get Yours Now: Download the 2025 Hijri Calendar templates and all our other beautifully crafted designs here: {Download link Coming Soon - leave a comment if you need one now} 💡 Don’t Forget: Like | Share your thoughts | Subscribe for more innovative tools and templates to simplify your life! Happy planning, and we’ll see you in the next video! 🎉 </video> <video> Creating Tornado Charts for Sensitivity Analysis in Excel Description: Welcome to yet another video from #datatodecisions. Our in-depth tutorial on creating Tornado Charts for Sensitivity Analysis in Excel enhances your data analysis skills. In this video, we demonstrate how to create a Tornado chart, specifically for performing sensitivity analysis. This tutorial is perfect for project managers, financial analysts, and anyone looking to make data-driven decisions. Enhance your data visualization skills with this practical guide. Don’t forget to like, subscribe, and hit the notification bell for more Excel tutorials. Share your questions and feedback in the comments below! ****************************************************************************** Are you looking for a quick, instant chart-maker template where you can enter just data and have charts readily created for you? Check our latest product, the Instant Chart Maker from our Data Visualization Toolkit in Excel: https://indzara.com/product/data-visualization-excel-templates/data-visualization-toolkit/ ****************************************************************************** The detailed blog post for this chart creation is here: https://indzara.com/create-tornado-chart-for-sensitivity-analysis-in-excel/ Check our Premium Bar Chart Excel Template here: https://indzara.com/product/data-visualization-excel-templates/bar-chart-excel-template/ Here’s our collection of Visualization templates from Indzara: https://indzara.com/data-visualization-excel-templates/ For more such tutorials, visit https://indzara.com/datatodecisions/ #excelmadeeasy #exceltips #excelchartstutorial #exceltricks #datavisualization #barchart </video> <video> Mastering Excel's XLOOKUP Function Description: Welcome to another interesting episode of “Data to Decision”. XLOOKUP is a versatile and powerful function. In this series, we will explore 9 practical and powerful examples of Excel's XLOOKUP function that will unlock the full potential of XLOOKUP for real-world applications. From simple lookups to complex multi-condition searches, this episode is packed with practical examples to take your Excel skills to the next level. 📌 Timestamps: 00:04 Introduction to XLOOKUP 01:00 Case 1: Simple Lookup for Exact Match - Returning Bonus as “0” for employees not available in the List 03:06 Case 2: Fill Values When No Match is Found - Returning Bonus as “0” for employees not available in the List 04:01 Case 3: Extract First or Last Occurrence - Finding an Employee's First or Last Salary 06:02 Case 4: Extract Lookup Values for a Range - Finding First Salary for all employees 08:16 Case 5: Lookup Values Without Exact Match - Finding rating from another table 11:30 Case 6: Partial Match Using Wildcards - Finding employees with partial name match 13:11 Case 7: Retrieve Multiple Columns - Return multiple columns 14:18 Case 8: Lookup with Multiple Conditions - Finding employees with name and department match 15:36 Case 9: Find Latest Record Based on Date - Finding salary based on date 18:49 Closing Thoughts 💡 Key Takeaways: Handle lookup scenarios like exact match, No match, first or last occurrence, match for a range, values for a range, values for multiple columns, wildcards, multiple conditions 💡 Don’t forget to like, subscribe, and hit the bell icon to stay updated on Excel tips and tutorials! #exceltutorialforbeginners #XLOOKUP #DataAnalysis #MicrosoftExcel #DataToDecisions </video> <video> How to select top candidates for a job using Microsoft Excel? Solution for Recruiters! Description: Looking to assess and choose the best candidates for a new role within your organization? Candidate Screener is the solution designed specifically to analyze the skills of existing employees based on your current skill ratings, helping you make strategic decisions for recruiting. In This Video, You'll Learn: 1:29 - Structure the candidate data (candidate and their skills) in table structure. 1:39 - Organize skills/measurements in an ordinal way. 2:19 - Create a score for each candidate. 2:39 - Extract only the candidate who fits the requirements. 3:22 - Shortlist the Top Candidates matching the criteria (Top 5) 4:01 - Compare the Top 5 shortlisted candidates using a plot chart. 5:03 - Comparing candidates and the skills with radar chart Who Will Benefit from Candidate Screener? * HR Managers who want to efficiently evaluate and promote talent * Department Heads aiming to identify high-potential team members for specialized roles * Talent Development Officers focused on aligning skills with strategic needs * Hiring Committees looking to save time in recruitment by choosing qualified candidates efficiently Candidate Screener helps you make the best decisions for employee placement. Watch now to see how it can elevate your hiring process! Give your valuable feedback on this use case in the comments section! </video> <video> How to Create a Box and Whisker Plot Chart in Excel? Description: Discover how to create a Box and Whisker plot in Excel to analyze salary distributions across different departments in your organization. Learn the concepts, key components of the plot, formulas available in Microsoft Excel, sample plots and many more covered in this video. This video includes step-by-step instructions for creating and formatting your chart for clear visual appeal. Read more about this chart here https://indzara.com/create-box-whisker-plot-in-excel/ Enhance your data presentations with our pre-designed charts from the Data Visualization Toolkit. Click the link to know more about the product https://indzara.com/product/data-visualization-excel-templates/toolkits/data-visualization-toolkit/ </video>

Contacts and Links

Description

Indzara.com provides 150+ free & premium high-quality Excel, Google Sheet and PowerBI templates covering areas of Small Business Management, HR, Project Management, Data Visualization, Finance Management, Stock Market, Calendars and more.

My name is Dinesh Natarajan Mohan. I believe that simple tools can lead to effective solutions.

These simple templates are designed to help us make smarter decisions, save time by automating manual tasks and eliminate human errors by leveraging computers. You will also save money by using our free and affordable premium templates.

Our philosophy is SIMPLE and EFFECTIVE.

This channel will have videos about templates as well as How-to videos about Excel. If you have any questions about Excel and would like us to post a solution as video, please post it as a comment.

We sincerely hope the solutions are helpful and look forward to your feedback. Please Subscribe to this channel to be notified of future videos.

Videos from channel