Excel Index Formula is probably one of the most favorite Excel Formulae of many. In my previous post, I had mentioned my favorite Excel formula. And it was not INDEX(). In my excel training sessions, when I happen to ask my participants about their favorite Excel formula, I am not surprised to hear the answer...Read More

I frequently visit the “Investor Relations” section of numerous companies. On one such occasion, I stumbled upon an Investor PowerPoint Presentation of a Global Auto major (BMW Jan 2014). I was mesmerized by the look of a PowerPoint picture in certain slides and started exploring techniques on how to highlight in PowerPoint slides.   The...Read More

Learn a new PowerPoint trick using picture tools: Magnifier Case Study: Let’s say my company has launched a new water dispenser. I would like to highlight the new features of the product. To do so, I will like to use a magnifier like an effect to attract the viewers attention (Picture tools). This is a...Read More

Comparison Between Alteryx vs KNIME Data Analytics Platform. Alteryx is a self-service data analytics tool. Alteryx makes the process of ETL easier. Alteryx is a super tool that combines the functionalities required for Data Preparation, Geo-Spatial Analytics, and Data Science. Before knowing the exact difference between Alteryx and KNIME you should know What is Alteryx...Read More

The Quartile Function in Excel helps to return the quartile of a data set in Excel. Going further in this tutorial, you’ll see how to find Quartile using Excel. You’ll observe that the Quartiles are several times used in sales and also while inspecting the sample data. The Quartile Function in Excel will support you while...Read More

Business Analyst in an organization helps to bridge the gap between IT and the actual business flow. learn about Business Analyst Interview Questions he takes into consideration the business process, data, requirements, and provides necessary recommendations to the business superiors for the business to flourish further. Now let us make you more confident and lead...Read More

Power BI Interview Questions and Answers is a vast topic. The interviewer can ask any questions according to his choice. Power BI Interview Q&A contains the essential questions gathered by our experts with years of experience and drilling down with other like-minded personnel about the possibilities of a particular problem to be asked. In the...Read More

This example describes how to create a calendar in Excel. The calendar is an important part of keeping all your activities, appointments, meetings and events organized. You can do a lot with a calendar. People use them as a timesheet to make a work or school schedule to track a project and much more. There are a...Read More

To crack the interview, it is very important to know what are the possible Data Analyst Interview Questions. It gives you an idea about how the interview questions will be like, whether you know the answers and if you know the answers, then to ultimately boost your confidence. Confidence is the key to crack any...Read More

This article is been written to find calculate the ratio in Excel   Ratio: In simple mathematics, relationship or comparison between two more numbers is known as ratios. Ratios are normally written as “:” to show the connection between two numbers, for instance. You can learn such an advanced excel tutorial in our advanced excel...Read More

Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows in Alteryx by quickly blending and preparing the data without any programming skills. As it is used so extensively it is very handy to know Alteryx Shortcuts. Dive into the following Alteryx Shortcuts...Read More

Do you know that Power Query can clean your data and remove rows that have inaccurate data? If you are not aware of this feature then go through the below steps. Remove Rows With Errors By Power Query Let’s take an example. As shown in the below picture there is some revenue that has invalid...Read More

As explained in the above example, we have generated a conditional column for the given query. If we want to split this query into two, Power Query will help us in doing so. To get more in-depth knowledge about Power Query, then check our latest Power Query Course that provides high-class videos with life time...Read More

One of the features of the Power Query is that it allows you to promote the first row as column headers. Let’s take an example where you have the data set as shown below. Use First Row As Headers By Power Query Here, the headers are not meaningful as it is showing the headers as Column1,...Read More

Power Query helps you to perform a series of steps to modify your data. One of the steps is to split a column by the number of characters easily. How to Split Column in Power Query This is helpful when you have columns that you want to split by an equal number of characters, for...Read More

What will you get in excel formula shortcuts? You will come to know every single excel formula shortcuts and how to use it. You can use this shortcuts you optimize your daily work. With the help of this tutorial, I had helped almost 10000+ visitors to improve the skills and save time at the office....Read More

INTRODUCTION TO PIVOT TABLE IN EXCEL When you have a large amount of data in your worksheet and you can’t analyze or sort the data then Pivot Table in Excel helps you to carry out the task easily and more conveniently. Pivot Tables are powerful functions in excel. We are going to start with what...Read More

Think sometimes you need an icon to be pasted or used somewhere that is not available in your system. In such cases, it is better to Create your own PowerPoint Icon using PowerPoint tools. It is much easier than it seems. Imagine the number of possibilities that you can unlock by using this tool to...Read More