fbpx

Category

Excel

Excel Security | How to lock cells in excel

How to Keep my excel secured? Excel Security To lock cells How to lock cells in excel? while Maintaining the integrity of an excel file that has to be shared with peers is a challenging job? Earlier versions of MS excel had a password feature but they were widely criticized because they were pretty easy...
Read More

How to Use Excel VLOOKUP Formula

What is Excel VLOOKUP & How to Use? Excel VLOOKUP is an Excel function to lookup and retrieves data from a specific column in the table. VLOOKUP supports approximate and exact matching. The “V” stands for “vertical”. Lookup values must appear in the first column of the table, with lookup columns to the right. you...
Read More

Drag and Drop: 5 Simple MS Excel Shortcuts that really Work

Working on your Excel spreadsheets can be much faster than you think if you use this 5 Simple drag and drop MS Excel Shortcuts: 1. MS Excel Shortcut for Copying and Moving: Excel has a unique feature hidden somewhere in the “Paste Special” column which many people don’t know about. Values can be added, subtracted,...
Read More

Create Report in Excel Using Pivot Table Techniques

Create a report in excel using a pivot table for sales data analysis is an important aspect of any business. Unless you are able to measure and analyze data, how can you improve your performance? It’s true that improving performance is a whole new story, but unless your data measurement isn’t accurate, you can never...
Read More

How to Match Names in Excel Where Spelling Differ or Vary

How to use Fuzzy Lookup in Excel to Match Names Think: Sometimes, we need to find a match in-between tables. In such cases we find the data using functions, like vLookup. This works when entries in both columns in the tables are completely identical. Sometimes that may not be the case. There may be spelling...
Read More

Learn how to compare values in Excel

Comparing values in Excel is something that we all do once in a while. Microsoft Excel offers a number of options to compare and match data, but most of them focus on searching in one column. When using Excel for data analysis, accuracy is the most vital concern. Incorrect information may lead to missed deadlines,...
Read More

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

Remove Password from Excel or Unprotected Excel

How to remove password from excel spreadsheet or Unprotect Excel Spreadsheet without using any software or Password Remover. So what it includes? This includes changing the file extension and manipulating its constituents to get an unprotected excel file or unlock an excel file. Almost ALL Excel users wish at some point or the other felt the...
Read More

9 Excel Error in Formula and How to correct it

Do you feel agitated when you are engrossed in setting up formulas in your EXCEL and suddenly you see jargon of excel error like #NAME, #REF appearing in your excel spreadsheet? Here’s a list of top 9 mistakes that one makes while entering an Excel formula + tips on how to avoid them: 1. Excel Error –...
Read More

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

Password protect excel using VBA for a shared Excel file

Password protect Excel Sheet based on the User as part of excel vba tutorial. For Example, you have a master excel sheet in your centralized location. Now everyone can access the same file and if someone changes something on that it is very difficult or hard to track who has modified the same. Want to become an...
Read More

Learn how to use SUMIF Excel Function

The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet. You can try the SUMIF function to add...
Read More

Learn How to Create or Make Excel Scatter Plots

In this blog, learn how to make a scatter plot in excel and you will able to make excel scatter plots at the end of the blog. Choosing the right type of chart or graph can be key to convey the most important insights into your data—on sight. When do you want to dig a...
Read More

How to Merge Excel Files in to one Or into a Spreadsheet using Excel Macro

How to merge excel files or combine excel files into a single sheet from a different workbook using excel macro is the topic of this blog. But in the earlier blog, we have covered how to merge data in a single sheet when the data are coming from the same sheet. We are trying to cover...
Read More

Excel Advanced filter technique using the Subtotal excel function

Subtotal Excel formula of excel advanced filter is a definite hit, both for beginners and experienced users who haven’t seen this feature in action before. If you work with large data set and often arrange your data for analysis, It’s practically impossible for someone to make a conclusion by sampling looking at this massive data....
Read More

Merge excel files into a single excel spreadsheet

In a continuation Excel VBA tutorial series of data manipulation using Macros; Today, we will try to merge excel files in a single excel spreadsheet. The source of the data may be from the same worksheet or from the closed workbook. We will merge excel files into a single sheet. For example, individual states data...
Read More

Working with Excel Date Functions {Cool Tricks}

What is Excel Date Functions? How is a date stored in Excel (Hint: Every valid date is a number) A data in Excel is not stored in Excel the way we see it. If you know how it is stored and read by Excel, it will help you write complex logical Excel date functions. It...
Read More

How to Compare Two Columns in Excel?

How to Compare two Columns in Excel Step-By-Step. Find difficulty in finding the same text in Excel, you can have a look for comparing two columns for matches or differences in the same row Like a two-dimensional database. Excel is capable of storing many different types of data from small business contacts to personal income...
Read More

Excel Advanced Filters to split data into separate sheets using VBA

Excel Advanced filters technique are useful when you deal with a large dataset. In this blog, we will try to cover one of Excel Advanced filter techniques to understand how to split data into a separate sheet through VBA code (it’s a part of our Excel VBA tutorial program). For instance, we have a huge list of U.S....
Read More

Tricks to create Hyperlink in Excel | ‘How to’

Before We learn How to create Hyperlink, let’s Learn what is Hyperlink and in where we can use it. What are Hyperlinks? A Hyperlink is a reference to a document, a location or an action that the reader can directly follow by selecting the link. Hyperlinks are used extensively on the Internet and are generally...
Read More
1 2 3 4 5 7