Excel
Generate Codes Dynamically with a Pattern from Your Data
Sometimes you need to create a unique code for a list of Products, Sales transactions, Students or P...
Three Methods To Translate Text or Functions in Excel
If you ever wondered how to translate excel spreadsheets into another language. This blog will give ...
How to Lookup The LAST Non-Empty Cell Value In a Column or In a Row
You might have an Excel situation where you need to find the last non-empty cell value whether in a ...
Amazing Feature: 14 New TEXT functions
Microsoft Just announced today (16 March 2022) the release of 14 amazing new TEXT Functions that can...
Switching Charts with A Drop list
Table of Contents Switching Charts with A Drop-Down List 3 1. Creating a data preparation tab...
Useful New Functionality Dropdown just added to Excel
Table of Contents Dropdown in excel is one of the most useful feature. With the help of drop you can...
4 Easy Ways to Combine Files with Power Query
With the help of Power Query, you can work with multiple files and sheets and be able to combine the...
Complete Guide on Volatile Functions in Excel
Slow Excel Calculations? Search for Volatile Functions There are some functions in Excel called Vola...
The Ultimate Guide to Pivot Tables. Everything you need to know about Pivot Tables
Table of Contents Download the Exercise Files Because practicing is an integral part of the learning...
Write NOTES Inside a Function in Excel – Simple steps
One of the most common questions in my youtube channel is “How to Write NOTES inside a Functio...