fbpx
[email protected] +1 203-349-9909 / +91-8080042523

Tutorials

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

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

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 paining task for organizations. Thanks to tools like Alteryx...
Read More

Alteryx Analytics Gallery Questions and Answers | Alteryx Gallery – Public Gallery

Whether you are a fresher or an experienced professional, you need Alteryx Gallery questions and answers to have a better understanding of Alteryx. Our real-time experts prepare these Top Alteryx Questions and Answers, and this tutorial will help you to crack your next Alteryx job interview very quickly. With the help of these Alteryx Interview...
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. Alteryx vs KNIME Comparison – Which is Better? KNIME analytics platform is simple and easy...
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

Alteryx Data Types | Alteryx Data Analytics

Alteryx is a Self-service data analytics tool. Top 5 Alteryx Data Types. 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. Check out Alteryx Download & Installation for windows & Mac Step-by-Step. Data can be brought in Alteryx by...
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

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

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

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

Business Analyst Interview Questions & Answer (Q&A)

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

Data Analyst Interview Questions and Answers [Q&A]

Data Analyst Interview Questions and Answers To crack the interview, it is very important to know what are the possible Data Analyst Interview Questions. It gives you the 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...
Read More

Power BI Dashboard vs. Power BI Report | 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. The visualizations on the dashboard are referred to as tiles and are pinned to the dashboard by...
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

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

Power BI Templates | Download Power BI Template

Download Power BI Templates – Power BI 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 to upload...
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

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

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

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? Display A Monospaced Font With Power Query Power Query has a solution for this also. If you want to use another font other than Unicode font then follow...
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 ‘*/’. Adding Comments In M With Power Query Let’s take an example to see how it works. Step 1: Load Data in Power Query Load the data in Power Query first to apply comments in...
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-bu-Step. Power Query can create a query parameter and link 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 list query explained above. Manage...
Read More

Learn How to Rename A Column Using Power Query

One of the important and most needed features of Power Query is Renaming Column Headers. You can rename a column in Power Query very easily. Rename A Column With Power Query Let’s observe the below steps to rename column headers- Step 1: Load Data in Power Query When you load the data in Power Query,...
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 year 2015 and 2016. We want to combine these two data tables together....
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

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. Steps to Extract Age Using Date With Power Query Here, we have a data table containing employee information...
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- Create A Sequential List With Power Query Let us take an example to understand this feature. Step 1: Add Custom Column...
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

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 power query, Excel will try to find and build relationships between the new data and other tables in the present in the data model....
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

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? Advanced Editor With Power Query Let’s go through the steps in detail to understand the magic of Power Query. Step 1: Load the...
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 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 it is not supported in M. Use Excel’s Right Function With ‘M’ To Extract Left Side Data But there is an alternate way for using the LEFT Function in...
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

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

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

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 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. Add Column From Examples By Power Query Step 1- Select the column on which you want to apply changes Suppose you have a...
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

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? Import Data From XML Using Power Query It’s very usual nowadays to get data from a company’s accounting or sales system in the XML format. If the data is inside an...
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. Unpivot Data With Excel Power Query One of the best features of the Power Query is to Unpivot Columns. Unpivot Columns feature transforms columns with similar characteristics...
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. Consolidate Multiple Excel Sheets By Power Query Let us understand this step by...
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

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. Power Query Helps In Replacing Values To understand this feature in detail, let’s take an example. We have a data set...
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

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 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 below picture there is some revenue that has invalid values....
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. How to Split Queries In Power Query The user will be able to mark a set of consequent steps, starting at the...
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

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

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

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

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 tutorial, you’ll learn about the various things you can do...
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

Text To Column in Excel | Split Cells

Excel Text to Columns or Split Cells in Excel is used in data cleaning and data re-arrangement. Excel text to columns formula technique is used for following: How to Apply Text to Column to Split Cells Split the text as last name and first name in two different columns. If a cell has got more than just a...
Read More

Pivot Table in Excel (Complete Guidelines)

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

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

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

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

How to create sparklines in Excel

Sparklines in Excel Imagine you have 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 data...
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

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

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

What is an INDIRECT Function? The INDIRECT Function in Excel helps you to return a reference to a range. Even when you insert Rows or Columns in a Worksheet the reference you created won’t change. This will help you to create a reference from letters and numbers in other cells. How INDIRECT Function Works with an...
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 Wrap Text in Excel Automatically and Manually

Wrap Text is 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 will...
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

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

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

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

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

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

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

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

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

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

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

Turn ON or Turn OFF scroll lock in Excel

Turn ON/ 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,...
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 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 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

Chrome and Excel Shortcuts

Chrome and Excel Shortcuts 1. #YodaHacks – 7 Killer Chrome Tricks: Ready to exercise your killer Chrome skills? Learn how to open your last link, pin your tab, toggle between tabs and more! a. Unable to connect to the Internet? Play the dinosaur game. b. Ctrl + W: closes the window c. Ctrl + Shift...
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

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. Merge cells Note: This document only covers how to merge cells in excel, not how to merge value of more than one cell. Open Excel Highlight two or more adjacent...
Read More

Extract values from cell using LEFT, RIGHT, MID

Imagine that you wanted to create a new column on a spreadsheet. But part of the information is already in another column? For example: You wanted to distribute the first, middle and last names from a cell into three separate cells. Do you bristle when you see someone wasting precious time for this? Case study...
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

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

Conditional Formatting with Formulas

Let’s begin by defining the term Conditional Formatting? Conditional formatting is also expressed as conditional automatic formatting. It is triggered under certain defined conditions by the user. Say we use conditional formatting to make characters bold and italic at the start of each line. And it worked. Then, conditional formatting is an effective way to...
Read More

How to password protect an Excel file?

When you share one Excel spreadsheet with multiple users, you may don’t want the spreadsheet to be modified arbitrarily by unauthorized persons. If you wish to restrict access to an Excel workbook or if you wish to deny editing privileges to other users, consider adding a password to the workbook as a security measure. Excel...
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

How to Create Formulas in Excel?

One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide. This tutorial explains how to write formulas in Excel, beginning with very simple ones. We will learn how to create a formula in Excel using three ways, Constants, Cell references and...
Read More

How to count text in Excel?

Imagine your team members have entered all their project hours in a worksheet and you need to count it. In other words, you also need to count the cells that have data. To complicate matters, the data may not be numeric. Some of your team members may have entered placeholder values such as “TBD”. So...
Read More

How to copy formulas in Excel?

  Before you start reading this blog, Checkout our top Selling Comics: Think: Sometimes we need to do same formulas in another cell or column, but can’t copy easily based on our requirements. There are many ways to copy formulas and its value from one cell to another or one sheet to another. Let’s see some...
Read More

Complete Guide on SQL and it’s Application

SQL which stands for Structured Query Language.  Well, SQL is the Primitive terminology solely responsible for handling the data. It does the styling and supervision of Data and data structures. These Data Structures are compiled together in the Relational database management system (RDBMS). Since SQL got introduced, it has been Celebrated as the language that...
Read More

How to sort in Pivot Table | Custom Sorting

Sorting data in alphabetical order is helpful when you have large amounts of data in a Pivot Table. Sorting lets you organize the data so it’s easier to find the items you want to analyze. You can sort Pivot Table in Excel horizontally or vertically. This allows you to see, at a glance, the rows or...
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. So, Let’s Show Formulas in Excel Instead of the Values with those...
Read More

How to Search in Excel?

In this blog, you will learn how to search in excel? When working with a lot of data in Excel, it can be difficult and time-consuming to locate specific information. You can easily search your workbook using the Find feature, which also allows you to modify content using the Replace feature. There are many types of search option...
Read More

How to Create Calendar in Excel

This example describes how to create 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 couple different options...
Read More

How to use Roundup Function in Excel

Roundup Function in Excel can use as a variety of formulas to round numbers in Excel depending on the situation. We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and a few more. Here, we will learn how to Round up numbers in Excel. Before we start, we must know about...
Read More

What is Excel VBA? Excel VBA Macros

In this article, you will know what is Excel VBA? What is Excel VBA? Excel VBA Macros VBA which stands for Visual Basic for Applications is the programming language of Excel. You can create a Macro with Excel VBA Macros. Computers and technical devices have their own language to understand the data processing. Although it...
Read More

How to make Data Table in Excel: One-variable data table and Two-variable data table

Before start learning how to make a Data Table, it is essential to learn the basic about Data Table and when we can use Data Table. What is a Data Table? A range of cells in where values can be changed in some of the cells and use of the formula to get different answers...
Read More

How to Create a Line Chart in Excel?

Before we learn how to create a well designed line chart in Excel, we must know what is line chart and when we need this. What is a Line Chart? A linear graph which shows a series of data points connected by straight lines. Line chart is a graphical object used to represent the data...
Read More

How to use sparklines in Excel: Creating a Miniature Chart in a Cell

How to use Sparklines in Excel ? Imagine you have result sheet for your students over the last 5 years and instead of creating a chart in Excel, which takes time. In that case, you are thinking if some small mini-charts in a single cell would be better. Ever had a worksheet of data in...
Read More

Create Pivot Table in Excel | Pivot Table Tutorial

Before we start learning How to create a Pivot table in Excel, We must learn What is a Pivot Table. Pivot Table tutorials What is Pivot Table in Excel? A pivot table is for sorting information. It’s great for calculating and summarizing information that you can use to break down large tables into just 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

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 Calculate Profit margin in Excel | Profit Margin formula

Struggling with profit and loss? Or still figuring out how to calculate profit margin in excel? Here is your answer, 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 the spreadsheet...
Read More

How to Calculate a Percentage Increase in Excel

Percentage increase calculator 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 a total and total cost after the discount. Let see how excel can help us to find...
Read More

How to add Error Bars in Excel: Standard Deviation

How to add Error Bars in Excel: Standard Deviation? Imagine that if all data was perfect, absolute and complete. Although actually, it isn’t, Excel gives us some useful tools to convey margins of error and standard deviations.  If you work in a field that needs to reflect an accurate range of data error, you can...
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

Converting trailing minus sign into negative numbers. (Text to Column)

Converting numbers with trailing minus sign into negative numbers. There are series of numbers, wherein some of the numbers are ending with minus sign (-). Now, if you want to apply sum, min, max or average functions, it will not work correctly as Excel cannot read 3789- as a negative. Now Splitting name into two...
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

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

Top 10 keyboard shortcuts that will help you master Microsoft Excel

Top 10 keyboard shortcuts that will help you master Microsoft Excel Top 10 keyboard shortcuts that will help you master Microsoft Excel. Print and Pin it on your board. Stay speedy with these keyboard shortcuts all the time. It’s a good source of revision of shortcuts at once glance. If you found this post helpful,...
Read More

How to freeze rows in Excel | Freeze Column in Excel

How to Freeze row and column in Microsoft Excel? is one of the most used and useful while working on large data as well as while making a dashboard. To freeze panes, freeze rows, freeze columns and freeze cells you can follow the tutorial below. How to freeze rows in Excel? Select a cell for which every row or column preceding...
Read More

Copy Text from Image Using Microsoft OneNote

Tired of typing text from the image. Then stop this time-consuming task. Learn awesome techniques to copy text from image in three simple Copy+Pasting steps using Microsoft OneNote. Try this step by step technique to copy text from images – No more re-typing pages after pages: Copy & Paste the image on Microsoft OneNote Right-click on...
Read More

How to Attach File in Excel or Object in Excel Spreadsheet

In this blog, we will learn how to attach a file in Excel.? Attach an Existing File 1. Click on the cell on which you want to insert the object. 2. Select the “Insert” tab. Then, Click “Object” in the Text group and then the Object dialog box will appear. 3. Select the “Create From...
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

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

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

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

How to Find circular reference in Excel

In Excel, 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 which is...
Read More

Remove Gridlines In Excel – Turn ON/OFF

How to Remove Gridlines in Excel? Or How to add gridlines in excel? It’s a task in itself when we want to print content in Excel. So we tried to hack this task and made it easy for you. [Don’t forget to check the video at the end of the post] Now when I look at this...
Read More

7 formula error in Excel that make you look dumb

In this blog, I will try to help you to debug your Excel Formula. As soon as you will use excel formula, you will likely need to know how to correct the error in excel formula. First of all, we need to know how many types of error, we can get we are applying excel formula...
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

Create Drop Down List in Excel using Conditional Formatting in Excel

Introduction Let’s say you have a worksheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw information. Similar to charts and sparklines, conditional formatting provides another way to visualize data and make worksheets easier to understand. Best features of conditional formatting in excel which if coupled...
Read More

Learn how to customized Header & Footer in printing excel sheet

This time under printing setting we will talk about headers and footers. Specially customized header and footer. Let me go to page layout. Under which let me click on the small icon which will lead me to page setup. Let me now access the tab of header & footer. Now there are some predefined templates of header. So one of them says page 1 of 10. The question mark stands for...
Read More

How to print titles and columns on the left in Excel? | Printing in Excel

One of the ignored areas in Excel is how to print a workbook or a worksheet. In this blog, I’ll talk about some of the tips and tricks like how can you make the printing in Excel look easy, better and more functional. Starting with above case study with a raw data which spans over multiple rows. So I have...
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

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

Don’t do these 10 things while preparing a financial model

A financial model is basically an abstract presentation on a real life financial problem. Making and referring to this can be really helpful in terms of economics and business management. Many of students in my Excel Training session ask about financial modeling and its do’s and don’t. As there are certain mistakes people tend to...
Read More

Copy Text from PDF without Line Breaks & More Word Tricks

How to copy text from pdf without broken lines? We have been working on Excel, VBA & Powerpoint tutorial and felt the need for exploring Word Tricks to enhance the productivity and save a ton of time of professionals who use MS Word for multiple purposes like writing an idea, designing template, making a professional report...
Read More

Learn Clipboard and 2 more special Table tricks in Microsoft Word

This tutorial helps you to uncover the hidden importance of Clipboard and how you can use various instances of copy + paste. We also work around table (one of the most hated areas in word) Checkout our Microsoft Word Online Tutorial Course. Click Here (In this Course, you will learn Basic To Advanced MS Word...
Read More

Email To-Do list to Team members in One Click using Excel VBA

In this blog, we will discuss how to email To-Do list from your outlook mail to respective team members. You would have sent email from outlook but probably not using Excel VBA Code. For example, you have a To-Do list in your excel file with tasks assigned to each team member and you need to send...
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.   Here are some excel charts hack to be used in your Excel Dashboard to make your charts stand out from...
Read More

Macro to convert Excel to PDF file

Which of these tasks is part of your daily work life? To Convert Excel to PDF Sending PDF attachments via email Mostly every one of us has to do these tasks daily. You may recall that sometimes you have to convert data in Excel to PDF and then attach it to Outlook mail. It doesn’t...
Read More

VBA Code to password protect excel for a shared Excel file

In this blog, we will try to cover how to 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...
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

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
Power BI Interview Questions
101 Power BI Interview Questions and Answers[Q&A]
November 11, 2019
Alteryx Shortcuts and Alteryx Hotkeys
Alteryx Hotkeys – Alteryx Keyboard Shortcuts
November 1, 2019
Alteryx vs Tableau
Alteryx vs Tableau – Choose the right Data Analytics Tools
October 25, 2019
Alteryx Gallery Questions and Answers
Alteryx Analytics Gallery Questions and Answers | Alteryx Gallery – Public Gallery
October 24, 2019
Difference between Business Analyst and Financial Analyst - Business Analyst vs Financial Analyst
Difference between Business Analyst and Financial Analyst | Business Analyst vs Financial Analyst
October 24, 2019
What is Alteryx - Introduction to Alteryx Designer
What is Alteryx? | Introduction to Alteryx Designer
October 22, 2019
Comparison between Alteryx vs KNIME
Alteryx vs KNIME Comparison | Data Analytics tools
October 18, 2019
Financial Analyst Interview Questions and Answers
Financial Analyst Interview Questions & Answers [Q&A]
October 16, 2019
Alteryx Data Types
Alteryx Data Types | Alteryx Data Analytics
October 15, 2019
Alteryx Download and Installation Guide for Windows and Mac
Alteryx Download and Install for Windows and Mac | Alteryx Designer
October 14, 2019
Data Science Interview Questions with Answers
Data Science Interview Questions and Answers [Q&A]
September 26, 2019
Power bi vs SSRS
Power BI vs. SSRS | Difference between Power BI and SSRS
September 20, 2019
Tableau Interview Questions
Tableau Interview Questions and Answers [Q&A]
September 18, 2019
Power BI Data Sources
Power BI Data Sources and Power BI Services
September 16, 2019
What is Power BI_ _ Introduction to Microsoft Power BI
What is Power BI? | Introduction to Microsoft Power BI
September 13, 2019
POWER BI COMPONENTS
Power BI Components and Building Blocks of Power BI
September 13, 2019
Basics of Power BI DAX Function
Basics of Power BI DAX | List of Power BI DAX Function with Example
September 9, 2019
Power BI vs. Tableau
Power BI vs Tableau – Comparing Functionality, Pricing and Support
September 3, 2019
Business Analyst Interview Questions
Business Analyst Interview Questions & Answer (Q&A)
July 25, 2019
Data Analyst Interview Questions and Answers
Data Analyst Interview Questions and Answers [Q&A]
July 25, 2019