fbpx

Tutorials

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 Filter Pane: 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. The application is productive not only online but also in offline mode. It is embedded...
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 Data Model: 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). This tool operates with the help of...
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 insert...
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.  Introduction to Financial Analyst While Financial Analysts have to face some challenges, it’s also a domain full of career opportunities,...
Read More

Download & Install KNIME for Windows & Mac

Introduction to KNIME KNIME is free and open-source software and it can be downloaded easily from the KNIME website. You need to select your operating system weather Windows, Linux, or Mac along with a 32-bit or 64-bit installation. KNIME is supported by several operating systems on 32-bit and 64-bit x86 Intel-architecture-based platforms. KNIME also supports...
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 course is just for you. Free Excel Course is for all the learners with basic...
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. Data & Information Data is a technical term. A layman would not understand...
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. Tips and Tricks of KNIME 1. How to Enable...
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

Importance of KNIME Analytics Platform

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 to derive insights. Users can perform functions ranging from basic I/O...
Read More

How to Build First KNIME Workflow?

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

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.  Useful Features of Tableau Tableau has many amazing features, some Main Key...
Read More

Basics of Nodes and Workflow in KNIME

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. Remove Rows With Errors By Power Query Let’s take an example. As shown in the below picture there is some revenue that has invalid...
Read More

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. Use First Row As Headers By Power Query Here, the headers are not meaningful as it is showing the headers as Column1,...
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. How to Split Column in Power Query This is helpful when you have columns that you want to split by an equal number of characters, for...
Read More

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

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

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

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

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

What is the Power BI Templates? Power BI Online Tutorial 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...
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

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? What is Flash Fill? Let’s say there is a pattern evident in the cells. Flash fill...
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 Waterfall charts have few advantages: A: It can depict sequence in which an activity must be construed. Watch this chart as used in one of the presentations (publicly available)...
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

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. Keep Duplicate Records In Power Query We generally take out duplicate lines but if we need to keep and check what the duplicates are, Power Query allows...
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. How to search data in Google using Excel VBA: For example: Write “Apple” in Google search box Press Enter↵ It will show you the statistics that how many records it has populated and also how...
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

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

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

How to lock or unlock cells in Excel? In Microsoft Excel 2007 or later versions like Excel 2019, we want to protect few cells only in a worksheet, then how to do it? Solution: There are two situations to lock cells in excel depending on these reasons. If You Want the Majority of Cells Locked...
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

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

To activate the special character, you need to use an Alt keyboard sequence: Num Lock key must be pressed, to activate the numeric key section of the keyboard (you can find on right top corner side). Press Alt key, and hold. While the Alt key is pressed, type the sequence of numbers (on the numeric keypad) from the Alt...
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 latest...
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

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. Let’s Start how to merge data in VBA Worksheets. Now If I...
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. Power Query Helps To Create Index Column Let’s go through the steps in detail with an example. Our sample data consists of Months and revenue data as shown in the...
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. Duplicate Columns Using The Power Query Editor Suppose you...
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

Create Magnifier Glass Effect in Powerpoint Picture

I frequently visit “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 picture...
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: 1. MS Excel Shortcut for Copying and Moving: Excel has a unique feature hidden somewhere in the “Paste Special” column which many people don’t know about. Values can be added, subtracted,...
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 a few shortcuts to use when you just begin working with Microsoft Excel....
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

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

How to Match Names in Excel Where Spelling Differ or Vary

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 functions, like vLookup. This works when entries in both columns in the tables are completely identical. Sometimes that may not be the case. There may be spelling...
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

50 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

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

How to remove password from Excel or Unprotect an 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

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? Here’s a list of top 9 mistakes that one makes while entering an Excel formula + tips on how to avoid them: 1. Excel Error –...
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 create excel scatter plots 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 little deeper...
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. Turn-ON/Turn...
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. What are Hyperlinks? A Hyperlink is a reference to a document, a location or an action that the reader can directly follow by selecting the link. Hyperlinks are used extensively on the Internet and are generally...
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. Merge cells in Excel Note: This...
Read More

How to Wrap Text in Excel Automatically and Manually

Wrap Text is a 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. HOW TO FREEZE ROW IN EXCEL? You...
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. Creating A List Query From A Table Column Here, we have a data table containing...
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. Merge Columns in Power Query Step 1: Select the Columns in Power Query for Merging If you have a data table as shown below and you want to merge...
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. Create Grouped Serial Numbers In Power Query But we want to keep...
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). Example sometimes, while creating a document we don’t need a few text 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. But...
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

TEXT TO COLUMNS To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’. For example, when you want to separate a list of full names into last and first names. How to splits cells in multiple columns To use text to column in excel, please follow below steps:...
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

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. Get Text Length Using ‘M’ Power Query Step 1:...
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. Power Query Concatenate Data/Text using...
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. Import Data From XML Using Power Query...
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. Split First & Last Name With Power Query This is a common task, but most people may use complex formulas to perform this...
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. Transposing Data By Power Query Let’s go through the steps in detail for transposing data. Step 1: Open the data in Power Query Open the data...
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

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

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

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

Tableau Interview Questions and Answers [Q&A]

Tableau Interview Questions and Answers 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. Using Tableau software, any non-technical user can easily create and modify the dashboards....
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 modelling and preparing reports from a wide range of data acquired from the data source. Need to know, find out What is Power BI. Building Blocks of Power BI The building block of Power BI include...
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

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. Format Columns By Power Query Step 1: Select...
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? Navigate Query Editor Using Power Query The code generated by this step is = Source{[Item=”Sheet1″,Kind=”Sheet”]}[Data] This is one of the ways...
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. Editing A Query By Power Query This is an employee data and you have to create the post for each employee based on their experience given in the...
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. Delete Steps Until End By Power Query Let us understand this feature with the help of an example. Step 1: Load...
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. Data Type Conversion With ‘M’ Using Power Query One of the unique functionality of M is that it takes data types very...
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! Use Excel’s Right Function With M To Extract...
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. Replicating Excel’s Find Function With ‘M’ Using Power Query For instance, if we want to use Excel’s FIND function to find a specific character in the text,...
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. Import Data From Text...
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 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 from CSV...
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. Import Web Data Using Power Query One of the way is to get data from the internet by using the importing web data feature.  Let us see how we can parse a webpage and use it for Power Query....
Read More

Learn How to Filter Records Using Power Query

Filter records is 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. Filter Records By Power Query Step 1: Load Data in Power Query Sometimes the data table is too huge and you do not want...
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. Unpivot...
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. Consolidate Multiple Excel Workbooks By Power Query Step 1: Open Excel Workbook from Folder Suppose you have an Excel...
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. Reverse Rows By Power Query Let’s take an example where you...
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. Group Rows And Get Counts By Power Query Let’s go through the steps in detail. Step 1: Select the column in Power Query To group rows, we first need to select the column from which we want to group...
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. Create Pivot Columns Using Power Query...
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. Remove Duplicates by Power Query Suppose you have this set of data. As you can see the marked ones are...
Read More

Acquire Knowledge to Fill Down Values Using Power Query

Power Query helps you to perform a series of steps to transform your data. Among which there is a step that allows you to fill data down easily. This feature is specially used to fill the missing data where predictions are available for the missing data. Power Query Helps To Fill Down Values Let’s suppose...
Read More

Steps to Remove Columns Using Power Query

Another feature of Power Query is Remove Columns. This feature allows you to remove the unwanted columns easily. Learn Steps to Remove Columns By Power Query This is helpful when you have columns that you want to eradicate and do not need in your final report – but do want to keep in your source...
Read More

How to use Excel? Excel basics for beginners

In this blog, we will learn Excel basics guide for beginners, Learning Excel basics are just a start to what’s in store to solve a lot of our daily problem and save time. Microsoft Office is very useful for a wide range of applications. It features calculation, graphing tools, pivot tables, and a macro programming...
Read More

Connect to Data in Power Query

Power Query is the Microsoft Data Connectivity and Data Preparation technology that allows the users to flawlessly access data stored in hundreds of data sources and reshape it to fit their needs. What is Power Query Editor in Power BI? Power Query can replace, merge, clean and transform all the messy data and display it in...
Read More

How to use Text to Column in Excel with 4 Difference Example

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 online excel training, you’ll learn about the various things you...
Read More

Things you should learn in Excel

The essential skills that a competent business Excel user should be aware of are Formatting & basic formulas, Excel shortcuts, VLOOKUPS & conditional statements, Data analysis like filtering, sorting, and analyzing data, Data visualization like tables, charts, and dual axis charts, What-if-analysis and Pivot tables. The complete Excel course is bifurcated into three major parts viz. Beginner Excel Course,...
Read More

How to use Clean Function in Excel

The CLEAN Function in Excel takes a text string and returns a text that has been “cleaned” of line breaks and other non-printable characters. What is a CLEAN Function? What is the syntax for CLEAN Function? How to use CLEAN Function? And finally, What are the applications of CLEAN Function? ➡ What is Clean Function in...
Read More

How to use the Excel Choose Function

The CHOOSE Function in Excel returns a value from a list using a given position or index. The values provided to CHOOSE can include references. Let’s have a look below to get more details about CHOOSE Function. ➡ What is Excel Choose Function? CHOOSE Function is a function in Excel that helps you to get...
Read More

How to use the Excel Code Function

The CODE Function in Excel returns a numeric code for a given character. The CODE Function can be used to understand numeric codes given to the CHAR Function as it is the reverse process of CHAR Function. ➡ What is Code Function in Excel? The Function that accepts one argument, for the text for which you...
Read More

How to use the Excel Column Function

The COLUMN function in Excel returns the column number for a reference. In other words, Column Function too will return the column number of the cell which contains formula when reference is not provided. ➡ What is Column Function in Excel? The function which will returns column number for a reference is called Excel COLUMN Function....
Read More

How to use Ceiling Function in Excel

The CEILING Function in Excel returns a given number rounded up to a specified multiple. CEILING Function is always used for rounding up. Its purpose is to Round a number up to nearest multiple. It returns a rounded number. What is a CEILING Function in Excel? What is the syntax for CEILING Function? Where can...
Read More

How to use Char Function in Excel

The CHAR Function in Excel returns a character when given a valid Character Code. CHAR Function is used to specify the characters that are difficult to enter in a formula in Excel. Now, let us study in detail the CHAR Function as given below. What is a CHAR Function in Excel? What is the formula...
Read More

How to use AVERAGEIFS FUNCTION in Excel

The AVERAGEIFS Function of Excel computes the average of the figures in a range that meet one or more delivered conditions. The criteria of the AVERAGEIFS Function also supports the logical operators and wildcard operators in Excel. What Is The Averageifs Function In Excel? AVERAGEIFS Function averages cells in a range that is equivalent to...
Read More

How to use AVERAGEIF FUNCTION

The AVERAGEIF Function of Excel calculates the average of the numbers in a range that meet the supplied conditions. The measures for AVERAGEIF Function supports logical operators and wildcards for partial matching. What is an AVERAGEIF Function in Excel? What is the formula for AVERAGEIF Function? What is the example of AVERAGEIF Function? How is...
Read More

How to use ABS Function in Excel

An Excel Function is a predefined formula that executes the actions like calculating values in a precise order. The common functions of Excel are AGGREGATE, AVERAGE, COUNT, INDEX, ROUND, SUM etc. In this blog, we are going to see all the Excel Functions one by one in depth. Also, you will learn the different parts of a function and how to...
Read More

How to use AND Function in Excel

An Excel Function is a predefined formula that executes the actions like calculating values in a precise order. The common functions of Excel are AGGREGATE, AVERAGE, COUNT, INDEX, ROUND, SUM etc. In this blog, we are going to see all the Excel Functions one by one in depth. Also, you will learn the different parts of a function and how to...
Read More

Delete Duplicate in Excel or Remove Duplicate in Excel

How to Delete Duplicate in Excel or find and remove duplicate? Find duplicates for one or more fields, such as a Name or City field, with the same data and want to limit the records to unique data for some fields. When you remove duplicate values, only the values in the range of cells or...
Read More

How To Lock Cells in Excel | Unprotect Excel

Most of the times 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 lets you lock cells in MS Excel. You can lock Cells in Excel or Lock Specified Cells in...
Read More

Separate Content of One Excel Cells into Separate Columns

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

How to Transpose Excel Columns to Rows | Paste Special Method

‘Paste Special Transpose’ option can be used to switch between Rows to Columns or Vice Versa. In case, if you don’t wish to Paste Special then you can even use the Transpose Function. While you make the selection of the Data, you select the range of the Data that you wish to re-arrange. This includes...
Read More

AutoSum in Excel with Shortcut

AutoSum in Excel will help you to SUM a Column or the Row which has Numbers. AutoSum in Excel is a Perfect example which shows how Excel loves doing Math. To AutoSum, make a selection of the Cell next to the Number that you wish to SUM. In the Home Tab, go to AutoSum, in...
Read More

OFFSET Function in Excel

OFFSET Function in Excel: Most Useful Built-in-Functions in Excel. It returns a range given to the no. of Rows and Columns. The User gives the Row, Column and Reference to a range and wherever the Row and Columns meet, the Offset Formula in Excel will give the Output based on that. What is an OFFSET...
Read More

Pivot Table Slicers In Excel

Slicers in Excel are often termed as Visual Filters. With Pivot table Slicers in Excel, you can filter Pivot Tables. Besides, Report Filter can also be used to do the same task. Slicers were first introduced in Pivot Tables in Excel 2010 for Windows. And it came in Excel for Mac in 2016. Slicers in Excel...
Read More

How to Hide/Unhide Column in Excel

In this blog, you can learn about Hide & Unhide columns in Excel There are Columns in Excel where you perform Data Analysis or Calculations. Ideally, you’ll hide these Columns before showing your sheet to anyone. The Complication comes when you can’t unhide Columns in Excel. Or maybe when you forget how to Unhide Columns...
Read More

Highlight row based on cell value

Imagine that when you are looking at a large list of numerical data, it’s useful to find largest and smallest value. Sometimes you need to find if a value is larger than a specific number. At times, the cell will be another color if the expected value is higher than a specific number. In a...
Read More

Learn how to remove blank cells in Excel

How to remove blank cells in Excel? confused? Data doesn’t always import or paste into Excel as nicely as you want. Sometimes, all the information is there, but extra blanks and spaces are carried along with the data cells. Think that if you work with a large data set in an Excel Workbook or Excel...
Read More

Insert a Picture into a Cell in Excel

Learn how to 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...
Read More

What is ISFORMULA Function and FORMULATEXT Function

In our tutorial today, we will be looking at some new functions in Excel 2013, these are ISFORMULA and FORMULATEXT Functions. Let’s take them one after the other. The ISFORMULA Function Gone are the days when it is difficult to identify cells that contain formulas. Some time ago, we have to create a user-defined function...
Read More

How to Use SUBSTITUTE Function

Let’s first grasp what a Substitute Function is and when to use it. Before we figure out how to use the SUBSTITUTE function. What is a Substitute function? A Substitute is a person or a thing acting or serving in place of another. Substitute function replaces/swaps a set of characters with another in a text string. For...
Read More

How to use the Excel PERCENTILE function

Excel PERCENTILE Function: Summary  The Percentile Function in Excel will return the k-th percentile of values in a range. This implies that the value below the k% of the data values fall, while using the Percentile Function. This is for a Supplied range of values also for the supplied k. The Percentile Function in Excel...
Read More

Insert or Type degree symbol in Excel with Autocorrect Feature

How to use the Autocorrect Feature to Insert or Type degree symbol in Excel?  Well, this one is Enthralling and my all-time favorite. Using autocorrect Feature in Excel to type degree symbol. This enables you in assigning a Code to the Degree Symbol. Well, let’s consider ABEFIJ. If ever you’ll insert or type ABEFIJ in...
Read More

Insert Symbol Dialog Box to Insert or Type degree symbol in Excel

How to use the Insert Symbol Dialog Box to Insert or Type degree symbol in Excel? Another vital step which can be used to get the degree symbol in a cell in Excel is to use the Insert Symbol Dialog Box. Let’s consider the following steps to insert the degree symbol in Excel with the...
Read More

CHAR Formula to Insert or Type degree symbol in Excel

How to use the CHAR Formula to Insert or Type degree symbol in Excel? You can even call this one as learning, how to type degree symbol on a laptop without the number pad. By using =CHAR(176) to obtain the Degree symbol in a cell in Excel. For doing this, you must: Input or Enter...
Read More

Reference Styles | How to Use R1C1 Reference Styles

Every Excel Spreadsheet contains rows and columns. Most of the time, columns are known and represented by letters (A, B, C), and rows are known by numbers (1, 2, 3). While you’re in Excel, this is often called the A1 reference vogue. However, some are in favor to use a unique methodology where the columns are known by numbers. “This is termed as the R1C1 reference style.” Considering the case below, the image on the...
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. Using the Histogram in Excel: If you’re planning to use the Histogram tool, then there are certain things that you need to...
Read More

Track Changes in Word

In our study today, we will be learning how to TRACK CHANGES in Word. What is track changes in Word and why it is important? Most of the time, after typing a word document, we go over it to edit, format or proofread it. We some of the time send this document to other experts...
Read More

How To Remove Blank Rows – The COUNTBLANK Function

How To Remove Blank Rows – The COUNTBLANK Function BEFORE – AFTER Before diving into the topic of the day, let’s understand some of the basic terms we will come across. Blanks are empty spaces. In the excel worksheets, they are cells that no parameter had been entered into. What are Blank Rows? Blank Rows...
Read More

How to use TEXTJOIN, IFS, SWITCH, MAXIFS and MINIFS Functions?

I am pleased to introduce you to some of the New Excel Functions in Excel 2016. These functions are ‘wow!!’. The functions I will be introducing in this tutorial are TEXTJOIN, IFS, SWITCH, MAXIFS and MINIFS. Let’s take them one after the other. The TEXTJOIN Function As the name implies, this function is used to...
Read More

How To Make Table of Contents (TOC) in Word

In today’s tutorial, we will be looking at how to make a Table of Contents (TOC). A Table of Contents that can be updated at any time. With MS Word Heading Styles, this can be done. To achieve this, the document is first formatted using MS Word Heading Styles. In this heading style, Heading 1...
Read More

How to Count Blank Cells in Excel

Before we proceed into the topic of the day, let’s understand the terms: Blank cells and Non-blank cells. Blank cells are empty cells in an Excel spreadsheet. They contain no parameter or data. Non-blank cells, on the other hand, contain parameters. They are not empty. Having blank cells in a spreadsheet is not inevitable. Sometimes,...
Read More

How to Compare Documents

  Spotting the differences in two similar documents is not easy. It is not only taking, it is also tiring and time taking. we have to go through both documents line after line. Otherwise, have the review document underlined, italic, bold font to help spot differences. Comparing documents much easier with MS Word! MS Word...
Read More