Functions
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 you a clear guidance on how to do exactly that. Translation is more than just changing words from ...
An Intense Tutorial on Building Surveys and Quizzes
Building A Quiz, Survey or Questionnaire … Step by Step Building Quizzes, Surveys and Questionnaires either to test knowledge on any topic or collect answers… is extremely common and useful. In a prev...
Find and Replace… Amazing Functionality You Did Not Know
Table of Contents Mind Blowing Functionality of the “Find and Replace” Command This blog article maps to my video on the same topic. You can Download the Exercise File and follow along by ...
Prepare for a Successful Excel Job Interview
Excel Job Interview With over 15 years of experience in corporate training, I find that many clients are overestimating their knowledge in Excel. That’s why when you apply for a job requiring go...
Create Excel Games with Functions and Macro
Excel games can be created with the power of functions and macros. Creating a game inside excel is something no one thinks about except the ones who are passionate about excel. Let’s create one ...
Simple way to split text in excel (Timesaver)
Split text in excel with this simple excel formula. If you have a string of text, like a full name without spaces, and you want to split it into 2 columns: one for the first name and another one for t...
Retirement Planning in Excel (Easy and Effective method)
Retirement Planning in Excel using Functions, Dynamic Arrays, and Power Query To get the best out of Excel, you need to combine the different functionalities together in achieving your goal. In this p...
How to Create a Dashboard in Excel (Step-by-Step)
A dashboard is a simple and effective way to showcase data in excel. Learn how to create a dashboard In excel by following this blog. Let’s dive in… My First Dashboard is given below. You can Do...
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 Function in Excel” Sometimes I build complex functions with multiple levels of nesting. To make it ea...