fbpx

Tutorials

QlikSense Vs Power BI

The need of the hour is to carry out the best data analytics of your business to make it successful. To carry out the analytics, it is necessary to have the perfect tools and methods. There are many data analytics tools available in the market but to find which is best suited for you is...
Read More

How to Embed Tableau Dashboard/Reports on the WebPage

The importance of creating reports or dashboards in Tableau is to share it across to the individuals who can get benefit from it. There are many ways to share, but the most interactive way is to embed Tableau Dashboard on a webpage. There are many possible reasons to embed Tableau dashboard in webpages. Here we...
Read More

QlikSense Vs Tableau – Comparison Between BI Tools

Qlik Sense vs Tableau: It is no doubt that today’s business relies completely on data analysis for successful strategies and decisions. As the importance of data is increasing there are very few platforms available for the analysis of Big data. There are two most prominent tools for business intelligence and data analytics – Qlik Sense...
Read More

Tableau Date Functions

Tableau is a self-service, highly recommended Business Intelligence, Data Analytics, and Visualization tool. It stands as a leader for nine times consecutively in Gartner’s Magic Quadrant for BI and data analytics. In this tutorial, we learn some essential/useful Tableau Date Functions to manipulate date values in Tableau Dashboards. Table of Contents What is Tableau Date...
Read More

Power BI Career Opportunities – Power BI Tutorials

Power BI Career Opportunities: Power BI is a self-service Business Intelligence and Visualization tool. For 12 years consecutively, Garner has recognized Microsoft as a leader in business intelligence and analytics platform. As the data is increasing day by day the need of performing proper analytics on this ever-increasing data also rises. Power BI is capable...
Read More

How to Create a Tableau Dashboard

Tableau is one of the best visualization software in the market and 7 years in a row as a leader in a Gartner Magic Quadrant for analytics and Business Intelligence platforms. Tableau is the most flexible, secure and an end to end analytics performing and visualization tool. It works on simple drag and drops functionality....
Read More

Tableau Features and Benefits | Key Features of Tableau 10

The critical reason for Tableau’s popularity is its incredible features. The features of Tableau are so overwhelming that it outruns almost all the other tools. Let us discuss the features of Tableau overall and the additional updated new features on Tableau 10 version.  Table of Contents Useful Features of Tableau1. Interacting by Asking Data:2. Tableau...
Read More

Tableau Career Opportunities – Tableau Tutorials

Tableau Career Opportunities: Tableau is one of the best Business Intelligence and Visualization software in the market and 7 years in a row as a leader in a Gartner Magic Quadrant for analytics and Business Intelligence platforms. Tableau simplifies raw data and converts it into an understandable format. Tableau is capable of creating impeccable and...
Read More

7 Benefits of Power BI – You Must Know

Power BI is a self-service BI analytics and visualization tool. As the business data is increasing, it is becoming impossible for tools like MS Excel to handle the huge amount of data and carry out all the analysis functions. Thus, most of the times analysts have to rely on incomplete data to perform analytics. Incomplete...
Read More

Tableau Data Types | Different Data Types In Tableau

Tableau Data Types gives us information about the kind of data stored in the data source. There can be a text value, data value, time value, Boolean value, etc. Tableau supports Data Types such as Boolean, String, Date & Date time, and Number. Let’s discuss each of them, along with is a symbol. Before going...
Read More

Top 9 Useful Power BI Features

Power BI is a self-service Business Intelligence and Data Visualization tool. Power BI has eased the lives of a lot of analysts by providing impeccable visualizations of the analyzed data. Due to the visualization insights from the data can be easily drawn. It is easy to make understand the insights of the analyzed data to...
Read More

Top 5 Essential Power BI Data Types

Power BI is a self-service data analytics and visualization tool. Power BI is now pre-integrated in office 365 product suit. Power BI integrates well with all Microsoft products. In this article, we discussed the top 5 Essential Power BI Data Types & its uses. A data type is necessary whenever you are dealing with the...
Read More

Power BI Analyst Salary Report 2020

Power BI is the self-service business analytics and visualization tool. It is known for preparing impeccable visualizations from the analyzed data. In today’s world, Data Visualizations is important in any field to make a decision. In this article, we discussed What is the Power BI Analyst Salary in US & Earning Potentials. Table of Contents Power...
Read More

Qlik Sense Interview Questions & Answers (Q&A)

The objective of learning any new thing is to get an upgrade in your career by getting employed in a new company with better quality via interview. An Interview is a decision-maker when it comes to the test of your learning. Keeping this thing in mind we have decided to help you with the Qlik...
Read More

Step By Step Guide to Learn Alteryx

Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the power of Big Data Analysis. Data analytics help to understand business problems by identifying them at the right time. Identification of a particular problem can lead to its possible solutions; in turn, it...
Read More

Business Analyst Interview Questions & Answer (Q&A)

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

Qlik Sense – A Data Visualization Tool

Qlik Sense Data Visualization Tool – Human brains are designed in such a way that it can easily pertain to the information showcased in a visual format rather than the written format. All the organizations collect data to find their business insights through analytics. This gathered data, is not fit to perform analytics and thus...
Read More

Alteryx Online Course

Are you tired of the crashing of excel every time when you try to work with tons of data? With Alteryx you will not face this problem ever again in your life. Before any of these features just check What is Alteryx? Alteryx is a self-service data analytics tool used to prepare, blend and transform...
Read More

Tableau Online Course

Tableau is a self-service Data Analytics and Visualization Tool. Tableau Online Course will help you to enhance your analytical and visualization skills and will enhance your working efficiency. Tableau Online Course will prepare you for Tableau Certification too. Before starting the course you can check the complete guide related to What is Tableau?  Tableau Online...
Read More

Power Query Training Course Outline

Are you among those people who spend hours of their precious work time in cleaning the data and transforming it into the proper format? You are not alone. There are many professionals who spend their time for hours or sometimes even days to clean and transform their data so that they can bring data into...
Read More

Step by Step Guide to Learn Tableau

Step By Step Guide to Learn Tableau: Tableau is one of the finest Business Intelligence and data visualization tools. Tableau is becoming popular with each day passing. It is useful in almost all industries. Huge organizations such as Amazon, Walmart, etc. have already started using it for their business. It is important to learn such...
Read More

101 Power BI Interview Questions and Answers[Q&A]

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

Top 5 Best Data Visualization Tools in 2020

Data is most important in today’s world. Almost all enterprises rely on data for their businesses. Data is gathered from all the available sources possible. The data gathered is used for analysis and to create visualizations. A lot of visualizations tools have emerged as the visualization of data is increasing. In this post, I am...
Read More

Tableau for Students – A Ultimate Guide

Tableau is a Self-Analytics and powerful Data Visualization tool. In almost every field, data is needed to be analyzed to come up with a conclusion about the well-being of an organization. Thus, Tableau is a very important tool to be learned in the education curriculum of the students. With this perspective in mind, Tableau is...
Read More

How to Find Circular Reference in Excel

In Excel, a Circular reference warning is received with raised eyebrows and terrified looks most of the time. But from our experience, we know it to be all smoke and no fire, which we will prove to you right here. So what really is a circular reference? It simply means that your formula includes a cell...
Read More

How to Create Calendar in Excel

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

Undo – Redo Shortcuts Keys in Excel

Undo, Redo shortcut keys for MAC & Windows and other foremost needed Functions: Easy and Essential keyboard shortcut functions of Excel you’ve been looking for. There is a list of essential Excel Shortcuts which will help you get in your Comfort Zone.  If you spend a lot of time in Excel then you must know about...
Read More

Combine Text with Date or Time in Excel – Reporting Tips

Many times you prepare financial reports in multiple sheets where you have to mention the date of signing report along with the certain text. There are multiple ways to combine text with a date or time in excel. If you want to learn more, please check our latest Excel Ninja Course for such type of...
Read More

Doughnut Chart in Power BI

In this article, we will discuss the Doughnut Chart in Power BI. A doughnut chart is the same as a Pie chart the only difference is that is has a hole in it like a doughnut. It is used to determine the relationship of the part to a whole. The blank space in between can...
Read More

Qlik Sense Filter Pane – Complete Guide

Qlik Sense helps us to visualize, load, combine, explore any amount of data easily without any bounds. Just like X-ray Vision, it delivers insights for each input data which “No other Query–based BI tools” can provide. Before discussing Qlik Sense Filter Pane lets check the What is Qlik Sense & its uses.  The application is...
Read More

Qlik Sense Operators – Ultimate Guide

Qlik Sense is a perfect combination of sophisticated AI, scalable multi-cloud architecture, associated analytics engine. It helps us to understand the input data by making the required changes. It could be termed as a benchmark for a new generation of analytics. In this tutorial, we discuss different types of Qlik Sense Operators that are helpful...
Read More

Qlik Sense Data Model – Qlik Sense Tutorial

Qlik Sense is a “Data Visualization Tool” which has gained a lot of popularity in “Business Intelligence” Industry because of the available features, architecture, key capabilities, products, customer services and user-friendly approach (The operations could be performed easily and effectively using “Drag and Drop” approach). Before discussing Qlik Sense Data Model, just know What is...
Read More

Power BI Visualization with Bars & Column Charts

In this article let us understand the Bar & Column Charts in Power BI visualization. One of the most common ways of visualizing the data is through Bar & Column Charts. In this type of chart, the visuals contain a rectangular bar. The length of the bar is proportionate to the data values.   To...
Read More

What are The Benefits of Being A Financial Analyst?

Being a financial analyst is one of the most popular career paths in finance. So check the ultimate benefits of being a Financial Analyst and start your career to become the most successful Financial Analyst.    Table of Contents Introduction to Financial AnalystBenefits of Being Financial AnalystConclusion Introduction to Financial Analyst While Financial Analysts have...
Read More

Download & Install KNIME for Windows & Mac

Table of Contents Introduction to KNIMEMinimum System requirements for the KNIME?KNIME for WINDOWSStep By Step KNIME Installation Guide for WindowsDifferent options for Windows:KNIME for MAC Step By Step KNIME Installation Guide for MACDifferent options for Windows: Introduction to KNIME KNIME is free and open-source software and it can be downloaded easily from the KNIME website....
Read More

Free Excel Course Training – Beginner to Advanced

42 Lessons, 15+ hours of FREE Excel Training Course ( FREE Videos) No Sign-Up Needed | Completely FREE | Scroll Down & Start Learning Today If you are keen to learn advanced Excel and brush up your Excel Knowledge this Excel Tutorial is just for you. Free Excel Course is for all the learners with...
Read More

Microsoft Business Intelligence(MSBI)

MSBI is an abbreviated form of Microsoft Business Intelligence. To understand MSBI, it is important to understand BI (Business Intelligence) first. Here we discussed different Business Intelligence tools including SSIS, SSRS, SSAS & many more. Similarly, What is MSBI? and its benefits. Table of Contents Data & InformationBusiness IntelligenceMSBISSIS (SQL Server Integration Services)SSAS (SQL Server...
Read More

Tips & Tricks and Common Pitfalls of KNIME

KNIME Analytics Platform is the strongest and most versatile free platform for drag and drops analytics, statistics, and machine learning. This tool is best for any data mining operations. Before checking the tips & tricks for KNIME first know the What is KNIME & its advantages.   Table of Contents Tips and Tricks of KNIME1....
Read More

Excel Vs Tableau

Most of the Excel users still have one particular doubt. They regularly keep on enquiring why one needs to move to software like Tableau as they are fully comfortable in working with Excel. They are able to do all the things which Tableau offers with the help of Excel. For all these uses, I can...
Read More

Different Types of KNIME Components (USER INTERFACE)

Components are KNIME nodes that you create with a KNIME workflow. They compress and abstract functionality and can have their own classy, interactive views. Components can be reused in the same workflows and also can be shared with others using KNIME Server or the KNIME Hub. They can also represent web pages in an Analytical...
Read More

Data Analyst Interview Questions and Answers [Q&A]

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

How to Calculate Ratio in Excel | Excel Formula

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 dashboard...
Read More

Importance of KNIME Analytics Platform

Table of Contents Why KNIME?Importance of KNIMEWhat’s so Great About KNIME? Why KNIME? KNIME Analytics Platform is open-source software built for powerful analytics. It is free and easy with drag and drop based Graphical User Interface (GUI). KNIME is designed in such a way that the user need not have to know how to code...
Read More

How to Create a Workflow in KNIME?

KNIME is a great tool for building analytical workflows. Creating a workflow using KNIME involves dragging and dropping built-in nodes into a canvas. There is a privilege to extend KNIME by adding nodes developed by the KNIME community or adding your nodes. The creation of workflows is very fast and user-friendly with KNIME. In this...
Read More

Features of KNIME Analytics Platform

The KNIME system can operate on multiple operating systems. In other words, it is compatible with the Windows 32bit and Windows 64bit version and stays updated with Vista and all machines under Windows 7. It can also function with numerous Linux systems like RHEL4/5 and Open SUSE 10.2/10.3/11.0. KNIME version 2.1 can also work on...
Read More

Alteryx Hotkeys – Alteryx Keyboard Shortcuts

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

Basics of Nodes and Workflow in KNIME | KNIME Tutorials

KNIME is one of the best analytics platforms. The knowledge of the KNIME Analytics Platform store in the Node Repository. So before Leaning the KNIME, you should first understand What is Nodes? and What are Workflows in KNINE? This gives you a good glimpse of the KNIME Analytics Platform. If you want to know more...
Read More

Tableau File Types and their uses – Tableau Tutorial

Each file is created to serve a definite purpose in software. The workflow of the software develops separate data at each stage. In the same way, Tableau has different types of file types too. Let’s discuss the file types in Tableau and their purpose and usage. Top 10 Reasons Why Tableau is a necessity for...
Read More

Read How to Remove Rows With Errors Using Power Query

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. Table of Contents Remove Rows With Errors By Power QueryStep 1: Load the data in Power Query EditorStep 2: Remove ErrorsStep 3: Close &...
Read More

Learn How to Split Queries In Power Query

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

How to Use First Row As Headers in Power Query

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. Table of Contents Use First Row As Headers By Power QueryStep 1: Load the data table in Power Query EditorStep 2: To...
Read More

Top 10 Reasons Why Tableau is a necessity for Business

Why Tableau is a necessity for Business? Due to the proliferation of the internet, data is increasing day by day. Thanks to the advent of Business Intelligence tools that help to manage vast amounts of data. One of the most popular tools that fall under this category is Tableau. Learn about the Introduction of Tableau...
Read More

Split Column in Power Query

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. Table of Contents How to Split Column in Power QueryStep 1: Open the Data Table in Power QueryStep 2: Split Column by Number of CharactersStep 3:...
Read More

Working with Excel Formula Shortcuts | Excel tips & tricks

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

Pivot Table in Excel for Beginners to Advanced User’s

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

How to create Icons in PowerPoint

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

How to compare two lists in Excel

In the tutorial, we will learn: How to compare two columns in Excel. We use various ways to compare two cells using functions in Excel. Some of these ways are: Comparing two columns row-by-row. Comparing many columns for row matches or differences. Highlight matches or differences between two columns. Highlight row matches and differences. Compare...
Read More

How to Attach File in Excel or Object in Excel Spreadsheet

Want to attach an existing or new file in excel? then you land on the perfect page. You can check our ultimate guide about how to attach a file in excel or an object. Still, there are multiple ways to attach a file in excel. Here we discuss some uncommon & common methods to attach...
Read More

INDIRECT Function with SUM, MAX, MIN & Independent Cell Value

Indirect Function in Excel returns a reference to a range. Excel Indirect functions are useful to create a reference that won’t change if columns or rows are inserted in a worksheet. There are a number of indirect functions in excel such as SUM, MAX, MIN & Independent Cell Value. In this tutorial, we explain one...
Read More

Find & Replace – using wildcard Character (*)

This time we’ll talk about “Find and Replace” and we’ll see its importance in the context of data cleaning. In fact, I have to start with the data which is going to illustrate how is this going to be used. For example, if I have a set of names with certain extra data with respect...
Read More

Insert a Picture into a Cell in Excel

Supposedly, you wish to fit in the logos of the Companies in your Excel Sheet. How are you going to do this? You need to know, how to insert a Picture into a Cell in Excel. To show pictures in the adjacent cell or any other cell, instructed in a column you must know how...
Read More

10 Ninja Tips in Excel

Excel Tips We have made this infographic on Top 10 useful Ninja Tips in Excel. A quick reference point for busy professional working on big financial Data models. Take a look at these Excel Shortcuts to improve your efficiency and productivity in excel. Subscribe now and Get a handbook on Excel Tips and Tricks: I...
Read More

Power BI Dashboard vs. Power BI Report | BI Dashboard

Power BI dashboard is usually known as a canvas and it can have only one page to tell a story using visualizations. Since it is restricted to one page, a perfect Power BI dashboard contains only the most important fundamentals of the story. So before creating the Power BI Dashboard or Report, let’s know What...
Read More

Create Power BI Layouts – Power BI Tips and Tricks

Power BI has this excessive functionality where you can go and download preset layouts which make your Power BI reports look more effective. There is a simple trick to create these Power BI layouts. You can create layouts in PowerPoint and then convert them into images. After that, you can insert them into your Power...
Read More

Download Power BI Templates | Power BI Tutorials

When you are using Power BI for your report analysis, you also need to create a few dashboards that can be really helpful and used often. You can restructure your process and update your reports by creating Power BI templates that give you the ability to upload a number of data sources and automatically rebuild...
Read More

Complete Guide of Power BI Download and Power BI Installation Steps

Power BI Download and Installation Guide Microsoft Power BI Desktop is designed for the data analyst. It consists of the interactive visualizations, with industry-leading data query and modeling built-in. You can generate and publish your reports to Power BI. Power BI Desktop helps you authorize others with timely critical information, anytime, anywhere. and Checkout Power...
Read More

How to use the Histogram in Excel (Step By Step Guide)

In case, if you plan to use the Histogram tool, you need to keep in mind and you have to make sure that the Analysis Tool Pak Add-in is installed on your system. Table of Contents Using the Histogram in Excel:Steps to Install histogram in Excel:Now, How to create histogram in Excel by using Data...
Read More

Alteryx Interview Questions and Answers | Alteryx Gallery – Public Gallery

Alteryx Interview Questions and Answers: Whether you are a fresher or an experienced professional, you need Alteryx Interview Questions and Answers to have a better understanding of Alteryx. Our real-time experts prepare these Top Alteryx Interview Questions and Answers, and this tutorial will help you to crack your next Alteryx job interview very quickly. With...
Read More

What is Flash Fill ? How to use flash fill in Excel ?

Before we learn how to use flash fill in Excel, there are some questions we need to address first. These questions are: What exactly is Flash fill? Why should we use it? And what can it do for you? Table of Contents What is Flash Fill?How to Use Flash FillWhen to use Flash Fill in...
Read More

5 Excel Charts Hack to Make Your Boss Smile | Excel Tips

Doesn’t it feel great to get that approval from your boss that everyone around you is striving for? Of course, it does. After reading this article, that dream is going to come true really soon. In today’s tutorial, we going to learn top5 Excel Chart Hacks to make your chart sexy.   Here are some...
Read More

Macro to convert Excel to PDF file

Looking to convert Excel to PDF File? Don’t worry we offer you the best practice to create PDF Files from Excel using VBA Macro. Which of these tasks is part of your daily work life? To Convert Excel to PDF Sending PDF attachments via email How to Convert Excel to PDF File Using VBA Micro...
Read More

Create a report in excel for sales data analysis using Pivot Table Techniques

Create a report in excel for sales data analysis is an important aspect of any business. Unless you are able to measure and analyse data, how can you improve your performance? It’s true that improving performance is a whole new story, but unless your data measurement isn’t accurate, you can never hope to reach the...
Read More

Add sizzle to your presentation with PowerPoint special effects

People ask me often – “Where did you learn all the PowerPoint special effects from?” I answer – “Investor Relations!” I frequently visit “Investor Relations” section of numerous companies. They contain Annual Reports, Quarterly Reports, and Investor Presentations, etc. I am always keen to go through their “Investor Presentations” reports. A few of them use...
Read More

Top 3 Ninja level charts for EVERY business…PowerPoint Tips

If my friends ask me my top three picks of the best charts that I use frequently, I will share these: Waterfall 2-axis Stacked Combo Thermometer Table of Contents Waterfall charts have few advantages:2-axis Stacked Combo:Thermometer Chart: Waterfall charts have few advantages: A: It can depict sequence in which an activity must be construed. Watch...
Read More

Power BI Architecture | Power BI Security

Microsoft Power BI is a self-service analytics tool. It is responsible for covering various topics of analytics such as data analysis, performing ETL, preparing datasets, modeling the data, report building, visualizations of the reports, and much more. To learn Power BI and deep dive into the possibilities, it is essential to learn its Architecture. This...
Read More

Create a Dependent Combobox in Excel and VBA

In this blog, we will discuss how to create a Combobox in Excel and as well as through VBA. List box & a Combobox are similar but have slightly different controls, to let users make multiple choices of items or to enter their own value in a list. Typical examples of items in these types...
Read More

Unprotect Excel | Excel Password Remover Online

Open password-protected the file from this simple excel tips & tricks. Learn how to unprotect excel or remove password from excel. Let me warn you upfront – THE MOMENT you learn applying this trick on How to Unprotect Excel, you’ll JUMP in ecstasy. If you are ready, then read on. Almost ALL Excel users wish at...
Read More

Remove Password from Excel Using VBA [Macros] Tutorial

How to remove password from Excel using VBA as part of our continued effort to give the valuable resource of learning for Excel VBA Macros tutorial students.   If you are following our blogs on a regular basis then probably you have gone through the blog where Rishabh have very clearly shown to us that...
Read More

Keep Duplicate Records in Power Query

Power Query in Power BI allows you to perform a series of steps to transform your data. One of the steps amongst this is to keep duplicate records. Table of Contents Keep Duplicate Records In Power QueryStep 1: Go to Power Query Editor from Power BI DesktopStep 2: Keep the duplicate rows in Power Query...
Read More

5 Powerful Tricks to Format cells in Excel

In this article, you will learn 5 Excel tricks on how to format cells in Excel. Applying these in excel will make your worksheet or spreadsheets look attractive and easy to read. Almost all Microsoft Excel users know how to change the date format, numbers and text formats using rows and columns.
Read More

How to Find Duplicate Values in Excel

You can Find duplicate values in Excel by reading this blog. An Excel sheet is a great way of packing lots of data into a dense area. But, these documents will become unmanageable and unwieldy when they’re in use for a long period of time. This example teaches you how to find duplicates in Excel....
Read More

Perform Google Search on Internet Explorer using Excel VBA | Excel VBA

First time in my life I have come across to create this type of automation and finally, I got success. Table of Contents How to search data in Google using Excel VBA:Please follow the below steps to get the result:Your code will look like below: How to search data in Google using Excel VBA: For...
Read More

How to Create Sparklines in Excel

Sparklines in Excel Imagine you have a result sheet for your students over the last 5 years and want to create a chart in Excel, which takes time. In that case, you are thinking if only there were some small mini-charts in a single cell. Well here is the solution. Ever had a worksheet of...
Read More

Tableau Interview Questions and Answers [Q&A]

Tableau software has become a basic need for any business as it helps to understand the growth and development of the company. Tableau is a data visualization tool that allows the user to develop an interactive Dashboard. In this article, we discussed the most important Tableau Interview Questions and Answers. Using Tableau software, any non-technical...
Read More

How to unlock or lock cells in excel- Single or multiple

Table of Contents How to lock or unlock cells in Excel?They are explained as follows:-A. If You Want the Majority of Cells Locked:B.  If You Want the Majority of Cells Unlocked:To leave the majority of the cells on the worksheet unlocked, follow these steps: How to lock or unlock cells in Excel? In Microsoft Excel...
Read More

Power Bi Dax Deduplication Based On Column

To do Power BI DAX deduplication based on column or to eliminate the duplicate data from a data set, Power BI has a weapon called DAX. Data Analysis Expressions (DAX) is a library of functions and operators that can be united to create formulas and expressions in Power BI Desktop. We can deduplicate any data...
Read More

How to Remove Duplicates in Excel | Find & Delete Duplicates

How to Find and Remove Duplicates in Excel In Microsoft Office Excel you have several ways to filter for unique values or find and remove duplicates in Excel. Now, you will learn how to find & remove duplicate values in excel. Use the Remove Duplicates command in the Data Tools group on the Data To...
Read More

Financial Analyst Interview Questions & Answers [Q&A]

Financial Analyst Interview Questions stated below is a boon for the individual going to face a business interview. We have gathered all the important points and questions asked in a financial interview by discussing with many interviewers and our experienced panel. Just go through the financial analyst interview questions before attending an interview to know...
Read More

How to Automate Mail Merge through VBA in Microsoft Excel | VBA

In this blog, I will try to cover how to get rid of Mail Merge by using the sample Excel VBA code. We all know how to do the mail merge in MS Word. But today I will discuss on mail merge in Excel. The data in your spreadsheet and you want to send the...
Read More

How to convert invalid date formats into valid data formats?

Unclean or Invalid Dates (DMY Format) should be converted to valid data formats. By default, Excel accepts date input in MM/DD/YY format (US format) unless you change the control panel settings of your PC. Example 22.10.2007 or 22/10/2007 date may be considered invalid. Now Splitting name into two columns as the First Name and Last...
Read More

Special Character Symbol List with Shortcodes in Excel

Table of Contents To activate the special character, you need to use an Alt keyboard sequence:Special Character Letter, you need to use an Alt keyboard sequence:Insert Special Character Symbol list in Excel To activate the special character, you need to use an Alt keyboard sequence: Num Lock key must be pressed, to activate the numeric key...
Read More

Alteryx Data Types | Alteryx Data Analytics

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. Alteryx has mainly 5 Data Types.   If you want to learn how to use these data types in Alteryx, then check our...
Read More

Alteryx Download and Install for Windows and Mac | Alteryx Designer

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. With drag and drop workflows and data cleansing techniques, it takes minutes to produce the output by performing analysis. Check out What is the Alteryx Designer?...
Read More

Calculate Elapsed Time in Excel

Do you want to calculate elapsed time in excel i.e. Add or Subtract hours, minutes and seconds to the time? Then you are landing on the perfect page. In this tutorial, we are going to learn how to calculate elapsed time in excel step by step. This method is used to make a time calculator...
Read More

Loop Multiple Sheets and Merge Data using Excel VBA Worksheets

In this blog article, we will be covering how to loop through multiple sheets and merge data in Excel VBA Worksheets as per our requirement. Just imagine you have a lot of files in a folder and for each file, you have 3 sheets. Table of Contents Let’s Start how to merge data in VBA Worksheets.Here...
Read More

How To Lock Cells in Excel | Unprotect Excel

Most of the time when you’ve worked on a Data set and you share your Spreadsheet with anyone you don’t want the Cells to change or shift. To avoid Modifications, MS Excel 2016 and its earlier versions let you lock cells in MS Excel. You can lock cells in Excel or Lock Specified Cells in...
Read More

How to use Pivot Table in Excel

In this Excel Training, I will show you the importance of pivot table in excel. Pivot table performs grouping numbers, grouping dates and grouping texts in a pivot table report. If you have not used pivot table before then you are going to love this feature of excel. If you already created one before, you...
Read More

Learn How to Create Index Column Using Power Query

There is one more interesting feature of Power Query where it lets you add an index column that serves as a row counter to your data. Table of Contents Power Query Helps To Create Index ColumnStep 1: Add Index ColumnStep 2: Select the Index ColumnStep 3: Move Index Column to the BeginningStep 4: Close and...
Read More

How to Display Formulas in Excel

If you are working on an Excel worksheet with a lot of formulas in it, it may become difficult to follow and keep track of all your formulas. Excel provides a simple way of displaying formulas in the cells instead of the result. This Excel Trick will help you to Display Formulas in Excel without any...
Read More

How to do Duplicate Columns in Power Query

You can also duplicate the columns easily using the Power Query Editor in Power BI. This can be helpful when you have columns that you want to duplicate & make some temporary/permanent alterations to it in the Power Query Editor but not to your source data. In this tutorial, we learn 3 cool steps to...
Read More

How to Lock Formulas in Excel?

How to Lock Formulas in Excel? Protech formula in Excel? Confused? Here is the blog to know how to lock excel formulas. Imagine Your boss wants you to protect a workbook, but she also wants to be able to change a few cells after you are done. So, before you password protected the workbook (or...
Read More

Excel Security | How to lock cells in excel

How to Keep my excel secured? Excel Security To lock cells How to lock cells in excel? while Maintaining the integrity of an excel file that has to be shared with peers is a challenging job? Earlier versions of MS excel had a password feature but they were widely criticized because they were pretty easy...
Read More

How to Use Excel VLOOKUP Formula

Table of Contents What is Excel VLOOKUP & How to Use?Excel Vlookup Formula TechniquesHow to Use Excel Vlookup Formula (Step-By-Step)#YodaHacks – Excel’s VLookup Formulas for Starters:#YodaHacks – Excel Vlookup Formulas with fixed table arrays: What is Excel VLOOKUP & How to Use? Excel VLOOKUP is an Excel function to lookup and retrieves data from a...
Read More

Create Magnifier Glass Effect in Powerpoint Picture

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 following...
Read More

Drag and Drop: 5 Simple MS Excel Shortcuts that really Work

Working on your Excel spreadsheets can be much faster than you think if you use this 5 Simple drag and drop MS Excel Shortcuts: Table of Contents 1. MS Excel Shortcut for Copying and Moving:2. MS Excel Shortcut for Copying and Moving Worksheets:3. MS Excel Shortcut for Dragging and Inserting:4. MS Excel Shortcut for Right...
Read More

PowerPoint Tips on converting text to graphics using Smartart

MS Word & PowerPoint Tips on how to convert a simple ordered or unordered List like converting text to graphics. Microsoft Word & PowerPoint has built-in shapes and designs in SmartArt Tool which can be used directly; while preparing project report or presentation you may need to design some charts, lists, graphs, shapes etc. In order to...
Read More

Create Report in Excel Using Pivot Table Techniques

Create a report in excel using a pivot table for sales data analysis is an important aspect of any business. Unless you are able to measure and analyze data, how can you improve your performance? It’s true that improving performance is a whole new story, but unless your data measurement isn’t accurate, you can never...
Read More

MS Excel Shortcuts Keys in PDF | Excel Keyboard Shortcuts

MS Excel Shortcuts Keys, when starting with Microsoft Excel, knowing a few ms excel shortcuts keys will reduce your work time and make it easier to work on Excel. Using the mouse to do all the task reduces your productivity. Here are the most used Excel shortcuts to use when you just begin working with...
Read More

How to Match Names in Excel Where Spelling Differ or Vary

Table of Contents How to use Fuzzy Lookup in Excel to Match NamesLet us See How Fuzzy Lookup Comes in Handy in Such Cases.Assign the threshold value How to use Fuzzy Lookup in Excel to Match Names Think: Sometimes, we need to find a match in-between tables. In such cases we find the data using...
Read More

Learn how to compare values in Excel

Comparing values in Excel is something that we all do once in a while. Microsoft Excel offers a number of options to compare and match data, but most of them focus on searching in one column. When using Excel for data analysis, accuracy is the most vital concern. Incorrect information may lead to missed deadlines,...
Read More

Basics of Power BI DAX | List of Power BI DAX Function with Example

Do you know about the Power BI DAX Function? Microsoft introduced its visualization tool in 2013 and named it as Power BI. Power BI is a cloud-based platform and can be handled beautifully to give the best visualization to even the most critical business data. It helps in evaluating and sharing the data and gets...
Read More

51 Amazing Power Query Tips & Tricks | Power Query Tutorial

Learn Power Query Tips and Tricks. Power Query is one of the most powerful features in Power BI and the easiest to learn. It is used for cleaning & transforming the data downloaded from ERP or accounting systems and display it in a report for Power BI to work with. You can learn more tips...
Read More

Quartile Function in Excel

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

Degree Symbol in Excel using Keyboard Shortcut

Degree Symbol Insert / Type in Excel What if you’re working on a Temperature Data? Here, you must learn how to use the degree symbol in the Excel data to show the numbers in Celsius and Fahrenheit. For this, one of the most important things is to use the degree symbol in data to show...
Read More

Time Travel with PowerPoint tricks – Smart Art for Powerpoint

Time travel has been a core theme for many Hollywood science fiction flicks. Well, let me make it a reality for you. You can zoom past an hour in less than five minutes with these special powerpoint tricks. 1) Convert boring bullet points in attractive SmartArt in 5 seconds – I borrowed some text from...
Read More

Remove Password from Excel or Unprotected Excel

How to remove password from excel spreadsheet or Unprotect Excel Spreadsheet without using any software or Password Remover. So what it includes?   This includes changing the file extension and manipulating its constituents to get an unprotected excel file or unlock an excel file. Almost ALL Excel users wish at some point or the other felt...
Read More

How to Customize PowerPoint Slides Only in 15 Minutes? | Powerpoint Presentation Tutorial

Is your boss constantly nagging your head to complete the PPT in few minutes? In such cases, use shortcuts to get your work done faster, smoother as well as qualitative. I exhibit five effective PowerPoint Presentation Tutorial that you wished you would know much before so that you would complete creating your presentation within no...
Read More

Countif function in Excel

COUNTIF function in excel counts cell meeting a single criterion. It will Count the Empty or the Blank Cells present in the Range. You can use COUNTIF Function to count or Calculate the number of Cells, the cells with dates, numbers, and text matching a specific criterion. The COUNTIF function Supports the logical operators (>,...
Read More

9 Excel Error in Formula and How to correct it

Do you feel agitated when you are engrossed in setting up formulas in your EXCEL and suddenly you see jargon of excel error like #NAME, #REF appearing in your excel spreadsheet? Table of Contents Here’s a list of top 9 mistakes that one makes while entering an Excel formula + tips on how to avoid them:1. Excel...
Read More

Learn How to Create a Horizontal Bar Chart in Excel

A horizontal bar chart may look appealing, but to make it may be troublesome. In this article, we going to learn how to create a Horizontal Bar Chart in Excel with 5 easy steps. Consider there are two tables i.e. Income and Expense Select the data with headers and Press Ctrl + T. Do it...
Read More

Password protect excel using VBA for a shared Excel file

Password protect Excel Sheet based on the User as part of excel vba tutorial. For Example, you have a master excel sheet in your centralized location. Now everyone can access the same file and if someone changes something on that it is very difficult or hard to track who has modified the same. Want to become an...
Read More

Learn how to use SUMIF Excel Function

The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet. You can try the SUMIF function to add...
Read More

Learn How to Create or Make Excel Scatter Plots

In this blog, learn how to make a scatter plot in excel and you will able to make excel scatter plots at the end of the blog. Choosing the right type of chart or graph can be key to convey the most important insights into your data—on sight. When do you want to dig a...
Read More

How to delete rows in excel based on a condition?

In this blog, I will discuss how to delete rows in excel based on the condition. Sometimes we get the data set from another person and the need to do a lot of work to clean this data set.   You need to delete a certain section of data that is not relevant or there are innumerable blank...
Read More

How to Merge Excel Files in to one Or into a Spreadsheet using Excel Macro

How to merge excel files or combine excel files into a single sheet from a different workbook using excel macro is the topic of this blog. But in the earlier blog, we have covered how to merge data in a single sheet when the data are coming from the same sheet. We are trying to cover...
Read More

Excel Advanced filter technique using the Subtotal excel function

Subtotal Excel formula of excel advanced filter is a definite hit, both for beginners and experienced users who haven’t seen this feature in action before. If you work with large data set and often arrange your data for analysis, It’s practically impossible for someone to make a conclusion by sampling looking at this massive data....
Read More

Turn ON or Turn OFF Scroll Lock in Excel

Imagine your report is due in an hour. You are working along in Excel, everything is going well, but suddenly you notice that you can no longer move around properly in your spreadsheet. You press the arrow keys, but instead of the cursor moving to another cell, the entire worksheet seems to be moving.  ...
Read More

Merge excel files into a single excel spreadsheet

In a continuation Excel VBA tutorial series of data manipulation using Macros; Today, we will try to merge excel files in a single excel spreadsheet. The source of the data may be from the same worksheet or from the closed workbook.   We will merge excel files into a single sheet. For example, individual states...
Read More

Working with Excel Date Functions {Cool Tricks}

Table of Contents What is Excel Date Functions?How is a date stored in Excel (Hint: Every valid date is a number)How to insert date in Excel using a Shortcut:How to change date format in Excel using a Shortcut:How to Detect Whether a Date is a Valid Date (Hint: ISNUMBER)How to Change Excel Date Format (Format...
Read More

How to Compare Two Columns in Excel?

How to Compare two Columns in Excel Step-By-Step. Find difficulty in finding the same text in Excel, you can have a look for comparing two columns for matches or differences in the same row Like a two-dimensional database. Excel is capable of storing many different types of data from small business contacts to personal income...
Read More

Excel Advanced Filters to split data into separate sheets using VBA

Excel Advanced filters technique are useful when you deal with a large dataset. In this blog, we will try to cover one of Excel Advanced filter techniques to understand how to split data into a separate sheet through VBA code (it’s a part of our Excel VBA tutorial program). For instance, we have a huge list of U.S....
Read More

Tricks to create Hyperlink in Excel | ‘How to’

Before We learn How to create Hyperlink, let’s Learn what is Hyperlink and in where we can use it. Table of Contents What are Hyperlinks?Below are the 5 Types of Hyperlinks:When and Where?Let’s go through the following steps to create this A CHEATSHEET that Solve your EXCEL Problems • eBook • Get Excel VBA Automation...
Read More

How to Split Cells In Excel

Merging and splitting cells in Microsoft Excel is very similar. Below are the steps required for merging and splitting cells in each of these programs. These steps help you with How to Split Cells in Excel. Follow the step by step process and split excel cells into multiple cells. This tutorial will help you to...
Read More

How to Calculate Profit margin in Excel | Profit Margin formula

Struggling with profit and loss? Or still, figuring out how to calculate the profit margin in excel? Here is your answer, the Profit margin is an important figure for business because it tells the percentage of each profited sale. Profit margins are important when pricing products, pursuing financing and generating sales reports.   If you...
Read More

How to Wrap Text in Excel Automatically and Manually

Wrap Text is the most known function of excel. There are times when there is difficulty to adjust long texts within an excel cell. When you’ve much text piled up and it should be present in the spreadsheets. Or if you have failed to fit your text in an Excel Cell. Excel Wrap Text option...
Read More

Difference between Excel Search and Find Function

The Find and Search functions seem to be identical by nature of their name. But they can be distinguished, by nature of their use for using Microsoft Excel problems. Below are the basic definition and difference between these two. Let’s start with their basic definitions and their syntax: Find function is used to query a...
Read More

Freeze Row & Column in Excel

Freezing rows and columns in Microsoft excel is one of the most used and useful tool while working on large data and while working with the dashboard. To freeze header row, freeze multiple rows, unfreeze panes, freeze multiple columns, etc. we need to go through the following tutorial. Table of Contents HOW TO FREEZE ROW...
Read More

Learn How to Display A Monospaced Font in Power Query

Normally data is viewed in the Unicode Font for any kind of data. But do you know you can also change this font to a monospaced font? With 3 easy steps, you can quickly display a monospaced font with Power Query. For more Power Query Tips & Tricks you can check our highly appreciated Power...
Read More

How to Add Comments In M Using Power Query

You can add comments to your code either with single-line comments that start with ‘//’ or multi-line comments that start with ‘/*’ and end with ‘*/’. Comment plays an important role to understand the code. In the future, if you want to change some part of code or want to share your code with your friend, who can easily understand...
Read More

Top 5 Steps to do Comments In Query Steps – Power Query Tutorial

Learn How to do Comments in Query Steps with Power Query. The new feature of Power Query allows you to add descriptions to each step in the Applied Steps pane. The step descriptions become comments in the M code in Power Query. If you write M code in the Advanced Editor window, then your comments appear...
Read More

Steps to Create A List Query From A Table Column

Power Query also allows you to create a list query from a data table available. The column from the given data table can be used to create a list query. This can be explained with the help of an example. Table of Contents Creating A List Query From A Table ColumnStep 1: Select the Column...
Read More

How to Manage Parameters in Power Query

Learn How to Manage Parameters in Power Query Step-by-Step. Power Query can create a query parameter and link it to the List Query. This is one of the most unknown features of Power Query. Let us study this unique feature along with an example. We have considered the same example of the list query explained...
Read More

Learn How to Rename A Column Using Power Query

One of the important and most needed features of Power Query is the Renaming Column Headers. Many people facing issues to rename column names using Power Query. We show you step by step process, how you can rename a column in Power Query very easily. To get in-depth knowledge related to Power Query and its...
Read More

Learn How to Merge Columns in Power Query

Merging columns is also a feature of Power Query which is very useful for transforming data. You can use this feature easily by following below steps. Table of Contents Merge Columns in Power QueryStep 1: Select the Columns in Power Query for MergingStep 2: Merge ColumnsStep 3: Add Separator to the Merged ColumnStep 4: Close...
Read More

Top 3 Steps to Append Queries Using Power Query

You can even append queries in Power Query. This feature is very useful if you want to combine two data tables together. Let us understand this using an example. As shown in the below picture, you have two sales data for the years 2015 and 2016. We want to combine these two data tables together....
Read More

Top 5 Steps to Extract Age Using Date in Power Query

Learn How to Extract Age using Date in Power Query. This is an amazing feature as it allows you to extract the age out of the date provided. Let us elaborate on this feature using an example. There are more similar functions that are very much useful in Power Query for Data Cleaning and Data...
Read More

How to Create Grouped Serial Numbers In Power Query

Steps to Create Grouped Serial Numbers in Power Query. If we have data for products and we want a unique identifier for each product name in the list. But as you can see below each product appears multiple times in the data table. Table of Contents Create Grouped Serial Numbers In Power QueryStep 1: Group...
Read More

How to Create A Sequential List Using Power Query

The Power Query M language allows you to create a list containing a sequence of numbers or characters very easily. This is possible when you are defining lists by using expressions in the format- To get in-depth knowledge about Power Query and its functions, check our latest high rated Power Query Course and become a...
Read More

Strikethrough in Excel & Word | Strikethrough Shortcut

Strikethrough in Excel & Word helps to delete it (Strikethrough Shortcut in Excel). An example sometimes, while creating a document we don’t need a few texts we can just delete it. But when we want to show the unwanted text we used Strikethrough text option. This option will let the text remain where it is....
Read More

Disable Relationship Detection for Beginners in Power Query

Disable Relationship Detection for Beginners in Power Query. This is another feature of Power Query that will speed up your queries. When you load your data into the data model from the power query, Excel will try to find and build relationships between the new data and other tables in the present in the data...
Read More

Advanced Editor With Power Query

Advanced Editor With Power Query can perform a lot of complex steps with any kind of data source. However wouldn’t it be fun unless you understand what is happening under the cover? This Power Query Tutorial will help you to understand how to use Advanced Editor. These complex steps are well explained by our Power...
Read More

Text To Column in Excel | Split Cells

Table of Contents TEXT TO COLUMNSHow to splits cells into multiple columnsSplit Cells into Multiple Columns. Observation:We have solved another interesting query of quite a few people, in case if you wish to convert an invalid date format into a valid date format. Click here:How to do text to columns in Excel? TEXT TO COLUMNS To separate...
Read More

Alteryx for Beginners – Alteryx Online FREE Course

Alteryx for Beginners Course is designed for the people who hardly know about Alteryx or how it can be used. We have kept in mind this type of Audience of ours who are the first-time users of technology beyond MS Excel. For them, MS Excel is the solution to all things. Check out What is...
Read More

How to Use Text to Columns in Excel

Do you know what Text to Columns is feeling right now? It is feeling sad and unappreciated. It is because it gets less credit than it actually deserves. Text to Columns in Excel is one of the most wonderful features in Excel. Here in this tutorial, you’ll learn about the various things you can do...
Read More

Use Excel’s Right Function With ‘M’ To Extract Left Side Data

If you want to use the Excel LEFT Function in Power Query, then you can’t directly go for it. This is because the Excel LEFT Function is not supported in M. To get in-depth knowledge related to Power Query and its functionality then Check Our Latest Power Query Course with 24×7 online support and lifetime...
Read More

Get The Length Of Strings Using ‘M’ in Power Query

Get the Text Length using Power Query M. If we want to use the Excel LEN function to get the length of strings, it is not supported in M. Let us see how to use the LEN Function in M to get the length of strings. Table of Contents Get Text Length Using ‘M’ Power...
Read More

5 Steps to Concatenate Data using ‘M’ in Power Query

How to use power query concatenate function? There are times when we want to perform such tasks that are not built in the user interface i.e. features that are not available on the ribbon. But still, this can be possible with Power Query’s programming language which is called M language.   Table of Contents Power...
Read More

Best Ways to Add Column From Examples in Power Query

Sometimes we need to transform the text from a huge data table which is not directly possible. But, with Power Query, you can easily do it using Add Column from Examples feature. If you want to learn more tips & tricks then you can check our high rated Power Query Course. This training provides excellent...
Read More

Best Ways to Import Data From XML in Power Query

You can easily load the data files like Excel spreadsheets in Power Query. But what if your data source is not in Excel spreadsheet? For that, you have to follow these following steps, suggested by our Power Query Training Experts. Each step is well explained with image visualization. Table of Contents Import Data From XML...
Read More

Split First & Last Name Using Power Query

Sometimes, when you have a data table which includes full names of candidates in one column and you want to separate the full name into first name and surname in different columns. Table of Contents Split First & Last Name With Power QueryStep 1: Select the column you want to splitStep 2: Split Column by...
Read More

Learn How to Replace Values in Power Query

There is a cool feature of Power Query which is known as ‘Replace Values’ feature. As the name suggests, it can replace any value with the new value you provide into your data table. You may go through step by step procedure where our Power Query Training expert has explained the topics in a detailed manner with...
Read More

Power Query Helps In Transposing Data

Transposing a data set is ultimately rotating data from rows to columns, or from columns to rows. To understand this concept, an example with the picture is given below.   Table of Contents Transposing Data By Power QueryStep 1: Open the data in Power QueryStep 2: Transpose the data tableStep 3: Use first rows as...
Read More

How to Group Numbers, Dates & Text in Pivot table in Excel

Now will talk about the Grouping Data features of the pivot table. This technique of grouping numbers, dates and text are not similar to a grouping of data by using data tab. This is something different. I am assuming that you must be knowing how to create pivot table in excel if you are not aware...
Read More

Online Excel Course – Online Excel Training Course

In this technological sound world, where access to a computer and online services are handy enough and can be accessed by any individual, classroom training at a dedicated fixed time is almost considered as an old-school thing. It is the age of online training. Whatever you want to or aspire to learn is just a...
Read More

Alteryx vs Tableau – Choose the right Data Analytics Tools

Alteryx vs Tableau – Which is the Winner in 2020? Nowadays, organizations prefer data proof over plain words. Thus, a massive amount of data is coming to the organizations to derive solutions to the problems or deriving insights into the future. Management of data is a painful task for organizations. Thanks to tools like Alteryx...
Read More

Difference between Business Analyst and Financial Analyst | Business Analyst vs Financial Analyst

Business Analyst vs Financial Analyst, like the name suggests, are both analytical roles that analyze data to help a business operate. Though both of them sound as if they are very similar, the fact is that they perform different tasks to help an organization run smoothly. Business Analysts concentrate on all aspects of running a...
Read More

Alteryx vs KNIME Comparison | Data Analytics tools

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

Data Science Interview Questions and Answers [Q&A]

Most Asked Data Science Interview Questions with Answers. Data Scientist is a crucial and in-demand role as they work on technologies like Python, R, SAS, Big Data on Hadoop and execute concepts such as data exploration, regression models, hypothesis testing, and Spark. Data Science Interview Questions and Answers are not only beneficial for the fresher...
Read More

Power BI vs. SSRS | Difference between Power BI and SSRS

Power BI vs SSRS – Comparison In this article, we will Compare Power BI and SSRS. As Power BI is built with new technologies, it is more in use and accessible. Due to its popularity, it is compared with lot many other technologies. Comparison improves the basis and clarifies which technology should be used. Power...
Read More

Power BI Data Sources and Power BI Services

Power BI Data Sources. Microsoft Power BI is a cloud-based business analytics tool. Power BI is available in the desktop version and services version. It is the best visualization tool and can handle even the most critical business data. It helps in sharing and evaluating the data and gets connected to all the data sources...
Read More

Power BI Components and Building Blocks of Power BI

Power BI is a Data Analysis and Visualization tool for BI users which helps them in performing analysis, data modeling and preparing reports from a wide range of data acquired from the data source. Need to know, find out What is Power BI.   Table of Contents Building Blocks of Power BIPower BI ComponentsPower QueryPower...
Read More

Power BI vs Tableau – Comparing Functionality, Pricing and Support

Today the world is more visual than ever before, Power BI and Tableau are the leaders holding a maximum market share of this domain. Power BI and Tableau are the two best software when it comes to Data Visualization. Although they both are quite similar in functionalities, as they both are needed for data visualization,...
Read More

5 Steps to Create your first Power BI Dashboard | Power BI Dashboard

A Power BI dashboard is usually known as a canvas and it can have only one page to tell a story using visualizations. Since it is restricted to one page, a perfect dashboard contains only the most important fundamentals of the story. A dashboard is not only attractive but also very interactive and highly customizable. The...
Read More

Complete Power BI Tips and Tricks – Power BI Dashboard Tutorials

Learn all the Power BI Tips and Tricks. Power BI is an interactive data visualization and analytics tool for business intelligence. You can use it to pull data from a wide range of systems in the cloud and on-premises and create dashboards that track the metrics that you want to analyze, or drill in and...
Read More

Custom Autofilter In Excel | Create Advanced Excel Filters using Excel VBA

In this blog, I will try to cover how to use a Custom Autofilter in Excel using Excel VBA. This Advanced Excel filter technique is meant for Advanced Excel users. We all know how to use a custom filter or advanced filter in Excel which is also knows as Excel VBA auto filter. Table of Contents...
Read More

Steps to Format Columns Using Power Query

Another important feature of Power Query is Format Columns. There are various formatting options available in Power Query for columns like Trim, Clean, Add Prefix, Uppercase, etc. In this example, we are going to see how to capitalize each word from the column using the formatting feature. Table of Contents Format Columns By Power QueryStep...
Read More

How to Navigate Query Editor Using Power Query

While using Power Query, you might’ve come across a step that reads ‘Navigation’  in Applied Steps pane and it is automatically created by Power Query. But, do you know what it is used for? Table of Contents Navigate Query Editor Using Power QueryStep 1: Drill Down ColumnStep 2: Drill Down RowStep 3: Drill Down Cell...
Read More

How to Edit A Query Using Power Query

Power Query also allows you to edit a query that you have already generated. Let’s take an example. Suppose you have a data table as shown below. Table of Contents Editing A Query By Power QueryStep 1: Select the ‘Experience’ columnStep 2: Check your data after applying Conditional ColumnStep 3: Refresh Data after updating Data...
Read More

Delete Steps Until End By Power Query

If you want to delete some steps, you can do it in one shot. The Power Query Delete Until End feature helps to delete as many steps up to the end in one click. Table of Contents Delete Steps Until End By Power QueryStep 1: Load the data and add Index ColumnStep 2: Delete Steps...
Read More

Data Type Conversion With ‘M’ Using Power Query

Data Type Conversion With ‘M’ with Power Query. Sometimes it happens that the things we want to do are not built in the user interface.  But Power Query’s programming language M has made this possible. Table of Contents Data Type Conversion With ‘M’ Using Power QueryStep 1: Select the columns that you want to concatenateStep...
Read More

Use Excel’s Right Function With M To Extract Right Side Data

How to Extract Right Side Data form Excel? If we want to use Excel’s RIGHT Function, it is not possible as it is not supported in M. But we can use the RIGHT Function in M in other way using Power Query and the Text. End formula! Table of Contents Use Excel’s Right Function With...
Read More

Replicating Excel’s Find Function With ‘M’ in Power Query

In the above example, you learned how to concatenate the columns using the M language. Unfortunately, not all of the Excel’s formulas can be used in M query. Table of Contents Replicating Excel’s Find Function With ‘M’ Using Power QueryStep 1: Select the Name ColumnStep 2: Add Custom ColumnStep 3: Find Position of Text using...
Read More

How to Add Conditional Column in Power Query

How to Add Conditional Column in Power Query Step-by-Step. In Power Query, there is a feature to add a new column called Conditional Column feature. You can define IF-THEN-ELSE conditions to add the conditional columns. When the conditions are fulfilled, the conditional column will automatically demonstrate the values that you have specified using IF-THEN-ELSE conditions....
Read More

Top Ways to Import Data From Text in Power Query

As you can import the data from Text/CSV, the same way you can import the data from the text file. The reason is that Power BI provides the same option to import the CSV file as well as a text file. Let us understand this with the help of below steps.   Table of Contents...
Read More

Best Ways to Import Data From CSV in Power Query

Now you know how to import data from an XML file in Power Query. But what if your data source is in the form of a CSV file? There is no need to worry if you have your data inside a CSV file (Comma Separated Values). This is because it’s very easy to import data...
Read More

Top 5 Ways to Import Web Data in Power Query

The good thing with Power Query is that there are multiple ways to pull in data. Table of Contents Import Web Data Using Power QueryStep 1: Get Data from WebStep 2: Enter URL to connect Web pageStep 3: Select data from NavigatorStep 4: Remove Top RowsStep 5: Remove Selected ColumnStep 6: Use First Row as...
Read More

Learn How to Filter Records Using Power Query

Filter records are a feature of Power Query that allows you to filter the data from your data table. Let’s see how to filter the records in Power Query with an example.   Table of Contents Filter Records By Power QueryStep 1: Load Data in Power Query Step 2: Filter data using Text FiltersStep 3: Filter...
Read More

How to Unpivot Data Using Excel Power Query

Power Query allows you to extract data from any source, clean and transform the data and then load it to another sheet within the Power BI Designer canvas. The power Query is an advanced excel online function that enables you to connect, discover, refine and combine data sources to meet your data analysis needs. Table...
Read More

Consolidate Multiple Excel Sheets Using Power Query

If you have multiple Excel worksheets that are in the same format and their underlying differences are their values and dates (e.g. January Sales List, February Sales List, March Sales-List, etc), then we can easily consolidate all the worksheets into one. The advanced excel function like Power Query will help you to consolidate multiple excel...
Read More

Consolidate Multiple Excel Workbooks in Power Query

The limitation of Excel of consolidating multiple Excel workbooks into one has overcome by Power Query.  Power Query can do this consolidation task in a couple of minutes. This is explained below within a few easy steps.   Table of Contents Consolidate Multiple Excel Workbooks By Power QueryStep 1: Open Excel Workbook from FolderStep 2:...
Read More

Learn How to do Reverse Rows Using Power Query

Sometimes you need to show the data in a reverse form for some of the other reasons. It’s not easy to reverse rows without Power Query in Power BI. Power Query can do it in a fraction of second without losing any valuable information.   Table of Contents Reverse Rows By Power QueryStep1: To reverse...
Read More

Read How to Group Rows And Get Counts Using Power Query

Power Query allows you to group rows and get the counts of each group very easily. Table of Contents Group Rows And Get Counts By Power QueryStep 1: Select the column in Power QueryStep 2: Grouping the RowsStep 3: Click Close &Apply from the Home tab Group Rows And Get Counts By Power Query Let’s...
Read More

Learn How to Create Pivot Columns Using Power Query

To simplify your data and aggregate them together we can Pivot the huge data table using Power Query Editor in Power BI. This amazing feature of Power Query has hundreds of benefits. We can use it for a data source that has too many numbers of columns and rows. Table of Contents Create Pivot Columns...
Read More

Read How to Remove Duplicates Using Power Query

Power Query cannot only keep duplicate records but also can remove the duplicate data. The advantage of this feature is that it removes the human error whenever you try to delete your duplicate data manually. Table of Contents Remove Duplicates by Power QueryStep 1: Load the data in Power Query and note the duplicate dataStep...
Read More