Tag

Excel

Learn how to create Scatter Plots in Excel

Choosing the right type of chart or graph can be key to convey the most important insights of your data—on sight. When you want to dig a little deeper into some data, but not quite sure how – or if – different pieces of information relate? Scatter plots are an effective way to give you...
Read More

How to delete rows in excel based on a condition?

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

How to split spreadsheet into separate workbooks using Excel VBA?

Earlier we have split our data into separate excel sheet but this time, we will split spreadsheet records into a new workbook. It’s useful and reduces our effort in making different workbook with same data. Hope you have enjoyed our earlier blogs, revisit “How to split excel data into separate spreadsheets using VBA“. Here’s how...
Read More

Subtotal Excel Formula – Excel Advanced Filter Trick

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

How to use Pivot Table in Excel For Tutorial on grouping numbers, dates and texts

How to use a pivot table in excel. In this Excel Training, I will show you the importance of 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,...
Read More

How to use Roundup Function in Excel

We can use 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 the Roundup function. What...
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 formatting cells techniques in excel will make your worksheet or spreadsheets look attractive and easy to read. Almost all Microsoft Excel users know how to change date format, numbers and text formats using rows and columns. But...
Read More

Advanced Excel Formula Auditing

Microsoft Excel has a lot of features. It has a variety of powerful tools that allow checking what is happening in your spreadsheet. Today we will discuss on Advanced Excel formula. It helps you to get the relations between formula and your cells. Which cells are using the information in the cell and from which...
Read More

Learn how to enable or disable scroll lock in Excel

Tricks to Enable / Disable Scroll Lock in Excel Think: 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...
Read More

Calculate Ratios in Excel | Excel Formula

Calculate ratios, first we must learn what is a ratio? Ratio: In simple mathematics, relationship or comparison between two more numbers is known as ratios. Ratios are normally written as “:” to show the connection between two numbers, for instance. If there are 2 red balls and 3 blue balls on the table you could...
Read More

Working with Excel Date Functions

In this article, let us learn more about Excel date functions and Excel date format. It will help you in areas of calculations such as due dates, project deadline & warranty expiry date. Here is a summary of what we will explain: 1 – How is a date stored in Excel (Hint: Every valid date...
Read More

Create sales dashboard in excel using VBA Codes

You may have heard about (or seen) sales dashboard in excel a lot of time. When I was a beginner, I used to wonder how to create a sales dashboard in excel using your actual data. I recently helped one of the students of Excel VBA tutorial on how to build one. This can be...
Read More

Learn how to compare two columns in Excel

How to compare two columns in Excel? Like a two-dimensional database, Excel is capable of storing many different types of data from small business contacts to personal income tax records. In both of these examples, accuracy is essential to make sure you have the information you need when you need it. In any data entry...
Read More

Working with Excel Formula Shortcuts | Excel tips & tricks

Learn Excel Shortcuts Formulas to make your life 4x faster 4 Excel shortcuts that can save tons of your time and make you look cool. 1. How to activate the “Function Argument” dialog box after writing a function in Excel? E.g. After writing “=VLOOKUP(” – ensure bracket is open, press Ctrl + A Before:   After:...
Read More
1 2 3 4