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 ...
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...
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 ...
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...
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 ...
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 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...
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...
We have sent your quick reference guide for creating Dashboard.
Please check your inbox to receive Your Gift.
Happy Learning !!
Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.
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...