fbpx

Tutorials

249+ 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

Tableau Aggregate Functions

Tableau is a top-rated Data Visualization tool. Tableau is a self-service BI and analytics tool, capable of building compelling visualizations. Being a BI and analytics tool, it is sometimes necessary to perform some actions on data to bring it in an accessible format. Tableau has a specific set of functions to change the data in...
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 cells,...
Read More

Tableau Data Sources

A Data Source is a connection to a database or a place where the data is generally stored. Users are able to create workbooks that point to a data source. The data source can be extracted or shared on Tableau Server generally. Let us first lean into understanding different connection types of Tableau data sources...
Read More

KNIME Interview Questions & Answers for Beginners

While facing the KNIME interview, the following interview questions and answers will help you to revise the basics but important facts about KNIME. Do not forget to revise the following KNIME interview questions and answers before facing one. Table of Contents KNIME Interview Questions & Answers for Beginners1) Why is KNIME used?2) How to install...
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

7 BEST Business Analytics Tools You Must Learn

Data Analytics is the heart of any modern business today, and therefore the tools are too essential. The market is flush with the wide variety of Business analytics tools. Business Analytics tools are the ones that help you to perform data analytics with ease. Some might give you impeccable visuals building capability, or some might...
Read More

Copy Text from PDF without Line Breaks & More Word Tricks

Table of Contents How to copy text from pdf without broken lines?Steps to copy text from pdf without broken lines are as follows:Copy Text from PDF to Word without Line Breaks How to copy text from pdf without broken lines? We have been working on Excel, VBA & Powerpoint tutorial and felt the need for...
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...
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

How to protect cells and hide formula in excel ?

Investment banker protects the excel file by password and hide formula also hide formula in google spreadsheet, but anyone having access to the file can easily access the formulas used in the cell by having a cursor on the cell. As part of our continued Excel Training series,  you will learn how to protect cells...
Read More

Error in excel when you Insert Column or Row in Excel (Solved)

Are you fed up with the Errors in Excel while entering a row or column? Then you have come to the right place. Table of Contents Error in excel when you Insert Column or Row in Excel (Solved)Let’s Fix Error in Excel while inserting rows or columnHow to Fix Error While Inserting Row & Column...
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

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 split spreadsheet into separate workbooks using Excel VBA?

Earlier we have split our data into separate excel sheet but this time, we will split spreadsheet records into a new workbook. It’s useful and reduces our effort in making different workbooks with the same data.. I hope you have enjoyed our earlier blogs, revisit “How to split excel data into separate spreadsheets using VBA“....
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. Table...
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 create...
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

5 Easy 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 Query...
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

Best Tableau Training & Certification Courses

Data Scientists and Analysts always struggled for making reports of the voluminous data generated and the most dangerous thing was to analyze this huge data. Even a minute mistake could cause severe damage to the well-being of the organization. All these worries came to an end as Tableau emerged in the market. Here is the...
Read More

Working with Excel Sumif Formula

When I ask professionals in my workshops – “Which is the ONE formula you’ll pick if you were asked to choose JUST ONE?” Most of the answers hover around INDEX, VLOOKUP and IF. But they tend to forget Excel Sumif. You know what MY answer is – Excel SUMIFS()! And I will tell you why. Excel Sumif...
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

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

Data Science Certification Courses That Will Pay Off

The greatest career trends of this era involve the career as a Data Scientist. To become a Data Scientist and to get hired by top MNCs, a professional Data Science certification is a must. Professional Data Science Certification involves to get certified from a known institute and provide rich knowledge that does justice with the...
Read More

Python for Finance Course

Python is gaining its popularity over all the other programming languages. The aspiring learners are gradually seen to incline towards learning Python. The reason for this change is that Python has the best quality of readability. It resembles the known language of English and that is why easy to catch up, unlike other languages that...
Read More

How to Update and Delete Using Excel VBA Userform ? | VBA Userform

Learn How to Update and Delete Using Excel VBA Userform? It’s useful for making a task easy in business areas like Banking records, Personal Finance, Stock Reporting, Recordkeeping, Automate Training room booking, Hotel Room booking, Car Booking, booking IT resources and approval of business expenses such as refreshments, conveyance, stationery, etc. Download Sample FilesThis technique...
Read More

How to Lock Formulas in Excel?

How to Lock Formulas in Excel? Protect 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

INDEX Formula in Excel

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

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

PowerPoint Picture Tools to Create Magnifier Glass Effects

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

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

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

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

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

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

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

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

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

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

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.   But very few...
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...
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...
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

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

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

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

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

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

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 data...
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 ADVANCED EXCEL NINJA COURSE • Course Certificate • Lifetime Access & Free Updates •...
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

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

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

How to Calculate a Percentage Increase in Excel

How to Calculate a Percentage Increase in Excel Sometimes percentages can be frustrating because it’s not always easy to remember what we learned about them in school. Let Excel do the work for you – simple formulas can help you find the percentage of total and total cost after the discount. Let see how excel...
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

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

Excel VBA Tutorial | What is VBA Macros in Microsoft Excel ?

Excel VBA Tutorial provides an integrated toolset that is appealing to a huge number of application areas. To make this tool, even more powerful, came to the rescue Excel VBA Macros, VBA Course or VBA Excel Functions Examples. VBA stands for Visual Basic for Applications, and it is a fully fledged programming language developed by...
Read More

Improve Office Productivity with Online Courses

One of the most favourite games in corporate drawing rooms is the Blame Game- “My employees are less productive!”, “She has got enough time to learn, I am too busy with this and that” and so on. Stop playing the blame game and accept the fact that your employees are what you have. If you...
Read More

Add APA Page number in MS Word with 3 Easy Steps

How to add APA Page numbers in MS Word? While writing documents or preparing a project report, it becomes mandatory to serialize all pages. MS Word has the option to give a serial number to the pages. The page numbers can be in the header or footer of the page with alignment options and style....
Read More

4 Super Productive Google Calendar Hacks

If you are using a Calendar app to simply check out dates, set holiday reminders or add events to it, you are probably using your Smartphone simply to make and receive calls. In other words, you are missing out on a huge potential that these Calendar apps have to offer. Here we offer you some...
Read More

All About Access Office 2016 & Skype for Business

Microsoft Access Office 2016 Microsoft has launched Office 2016. Kirk Koenigsbauer, corporate vice president for the Office 365 Client Apps and Services team said, “We’ve been in private preview with Access Office 2016 for several months. To be clear, this early build doesn’t yet contain all the features we’re planning to ship in the final product”....
Read More

Skills and Tools Required to Train the Trainer in Excel

Author: Rishabh Pugalia I started my entrepreneurial journey by becoming an MS Excel Trainer. And this was after I spent years working with KPMG (Assurance), Futures First (Interest Rate Futures – Proprietary Trading) and J.P. Morgan (Debt Capital Markets). In the last five years as an Excel Trainer, many of my workshop participants have asked...
Read More

Create Financial Models For Business

Create Financial Models in Excel I recently met a couple of professionals who are fresh graduates and working in the financial services sector. Since I was part of an investment team with a private equity fund where I have experience in creating investment memos and building the financial model from scratch. These guys asked me...
Read More

Microsoft Excel Go To Data Cleaning Trick

Data Cleaning Trick It is so easy to work on your own spreadsheet rather than working with Excel files made by someone else. Significant time is wasted in (1) cleaning or “sanitising” the data, and (2) establishing inter-sheet and intra-sheet formula connections. This process of Data Cleaning becomes super important if you are working in...
Read More

Realign your data by sorting in Excel

Realigning 100s of columns without manually Cut/insert columns. Thereby, reducing the task time by minimum 90%. Thus sorting in excel is an important weapon in your hand. Realign your data by sorting in Excel Watch this video for a hassle-free column realignment and sorting in excel: I hope you have liked our tip on Realign your...
Read More