mahmood razzimahmoodrazzimy.hashnode.dev·Aug 23, 2023What is MatMul? How to calculate it?MatMul is short for matrix multiplication, which is a mathematical operation that takes two matrices and produces another matrix. To calculate MatMul, we need to ensure that the number of columns in the first matrix is equal to the number of rows in ...Discussneural networks
Preeyal Jyotikadatanalytics.hashnode.dev·Jul 28, 2023Mastering MS ExcelHey there, fellow data enthusiasts! 👋 So, you're diving into the world of data analysis and just discovered a treasure trove of MS Excel shortcut keys that will revolutionize your workflow. Buckle up, because we're about to embark on an exhilarating...Discuss·10 likesms excel
Nibesh Khadkakcl.hashnode.dev·Jun 5, 2023Find the Last Row In Google Sheets With Google Apps Script!Hello!, I wrote a blog on finding the last non-empty rows a couple of months ago. Since then, I have found a better, faster, and easier method, which works in most cases. Find the Last Row & Column You can copy and paste one of the following function...Discuss·168 readsGoogle Apps Scriptsgoogle apps script
John Githuijohnmg.hashnode.dev·May 22, 2023Visualizing Data in Excel: Charts and Conditional FormattingThese are visualizations used to visually represent data in bars and graphs. Not every stakeholder and user of data may be well-equipped with data skills. Charts are better used to relay information, and findings and pick up trends in data. To create...Discuss#data visualisation
John Githuijohnmg.hashnode.dev·May 22, 2023Excel Formulas: Mastering Data ManipulationThe key thing to know about formulas is that they begin with an “ = ” sign. I feel like this is important to begin with because as a beginner I would always forget that, and start wondering why my formula is not working. Remembering this will definit...Discuss·26 readsexcel
Nibesh Khadkakcl.hashnode.dev·Apr 29, 2023How To Delete Empty Rows and Columns In Google Sheets?Welcome to this very short daily blog where I give a very simple script to automate Google Products. In this chapter, we'll custom menu that'll delete empty rows and columns in current active spreadsheets. Delete Empty/Extra Rows and Column The follo...Discuss·232 readsGoogle Apps Scriptsgoogle apps script
Nibesh Khadkakcl.hashnode.dev·Apr 28, 2023How Separate the First and Last Names in Spreadsheets?Would you like to separate the column in your spreadsheet that consists of the full names of people into first and last names? Well then stick this very simple script to your spreadsheets apps script editor and you'll be able to do just that. Split ...Discuss·117 readsGoogle Apps Scriptsgoogle apps script
Nibesh Khadkakcl.hashnode.dev·Apr 24, 2023How to Insert Multiple Rows in Google Sheets with Apps Script?Hello and welcome to our blog series on automating Google Sheets with Apps Script. In this tutorial, we will guide you on how to insert multiple rows in Google Sheets using a simple script. We'll explore how to use UiApp to create a custom user inter...Discuss·814 readsGoogle Apps Scriptsgoogle sheets
Nibesh Khadkakcl.hashnode.dev·Mar 17, 2023Removing Duplicates in Google Sheets: A Guide for Non-codersUgh.., I have so many duplicate rows in my spreadsheet. Well so do many other people. With the script in this article, you can introduce a menu button that lets you delete duplicate rows in your spreadsheet. This blog is the second part of the blog I...Discuss·111 readsGoogle Apps Scriptsgoogle apps script
Nibesh Khadkakcl.hashnode.dev·Mar 1, 2023How to Highlight Duplicate Rows in Google Sheets?You use sheets a lot and sometimes have difficulty identifying duplicate rows. Then after this blog, you’ll be equipped with a script that’ll highlight duplicate rows in your sheet. Namaste! This is Nibesh Khadka. I am a freelancer that develops scri...Discuss·1 like·286 readsGoogle Apps Scriptsgoogle apps script
