Need Help? Chat with us

Category

Excel

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

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 a Pivot Table in Excel horizontally or vertically. This allows you to see, at a glance, the rows...
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 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

Export data from SQL to Excel spreadsheet using VBA

In this blog, we will Import data from SQL to Excel spreadsheets using VBA. Assuming that you have a little bit of knowledge on the SQL server. Now if you are preparing reports in Excel and the data is on your SQL server then you don’t need to copy the data first from SQL server...
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

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

Selecting Multiple Options in Dependent Drop Down List Box using VBA

In our earlier blog we have already discussed how to create a dependent drop down list box in Excel and as well as in VBA when we are using the list box in VBA. Now in this blog, we will discuss how to select multiple options from the dependent drop down list Box as it...
Read More

Quarterwise Sales Comparison Dashboard with Charts in excel using VBA

Thanks for your feedback on our earlier blogs. We have already covered how to create a summary report quickly via Excel VBA. In this blog, we will cover the charts in excel. If you have not gone through the earlier blog, then please go through this link: Create Summary Reports Quickly via Excel VBA. In this...
Read More

What can you do on a date… err… with a date in excel ?

Dates are one category of information that is found in ALMOST ALL Excel reports. You can maneuver with them like a Maverick (Read: Tom Cruise’s starrer movie – Top Gun) These are the things you can do with a date in excel: You can find which day of the week it is (e.g. Sunday, Monday…)...
Read More

Excel VLOOKUP Function

Before we learn how to use Excel VLOOKUP function, we must learn when do we use Excel VLOOKUP function? Task: Imagine if you have to find when does train no. 6948 departs in the schedule chart above? Your approach: You will scan the first column top to bottom. When you find the same train no.,...
Read More
1 5 6 7