fbpx

Search Results

conditional formatting

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

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

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

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

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

Learn How to Create a Horizontal Bar Chart in Excel

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

What-if Analysis using Excel Dashboard, Indirect Function

In this topic, I will try to cover the features of what-if Analysis. It is a tool that allows you to try to different formulas. If you apply what-if analysis you will notice changing the values in cells and how those changes will affect the outcome of the formulas in your spreadsheet. Before we start...
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

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

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

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

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

249+ MS Excel Shortcuts Keys in PDF | Excel Keyboard Shortcuts

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

Qlik Sense Interview Questions & Answers (Q&A)

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

Power Query Training Course Outline

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

5 Powerful Tricks to Format cells in Excel

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