Functions

Translate Text or Functions in Excel

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 ...

How to write notes inside a function in excel

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...

Building surveys and quizzes with excel

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 using excel

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 ...

Preparing for Excel job

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 Macros

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 ...

split text in excel

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

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...

create a dashboard In excel

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...

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.