In this article, I will show you how to remove duplicates in Excel. While having duplicate data can be useful sometimes, it can also make it more difficult to understand your data. I’ll use conditional formatting to find and highlight duplicate portions of data within Microsoft Excel. Review your duplicate content and decide if you want to remove them.
Remember that when you delete duplicate values, the duplicate data is permanently deleted from your records. Before you go forward with deleting the duplicate content, I highly recommend that you copy the original data over to another worksheet. This ensures that … Read the rest
Use Excel’s rounding feature to round decimals or large numbers in a spreadsheet. Round with functions, round up, round down, or round numbers to a certain decimal place in Excel. In this article, we’ll show you how to round numbers in excel. If you use Excel a lot, you have probably noticed that it is frequently used to organize data in numerical form. While this is very helpful, sometimes you don’t really want to work with numbers like decimals. In certain cases, rounding your data up best suits your needs. In this guide, we are going to learn how to … Read the rest
One of the main functions of a Microsoft Excel spreadsheet is that it organizes any data set into manageable rows and columns which can be easily viewed, searched, and arranged. Here we will show you how to delete duplicates in excel the easy way.
Because of the way Excel organizes this data, it should be easy to manipulate, whether this means changing your ordering principles (alphabetical, according to date, according to amount), searching for particular entries, and adding or deleting information.
This tutorial will focus on how to identify and delete duplicate entries which might exist within an … Read the rest
Excel has proven itself to be very useful in various situations over and over again. The list of Excel’s benefits seems to be never-ending.
It even has a tool for answering questions and forecasting information. The Goal Seek function in Excel is a great tool for those asking “What if” type questions.
Use this guide to learn how to use goal seek in excel as well as how to put it into action.
Why Use Goal Seek?
The Goal Seek feature in Excel is basically used to create formulas. It provides information on cause and effect situations.
It … Read the rest
Learn to how to freeze a row in excel (or even more than 2 rows) using this practical how-to guide.
When you are working with lots of data on your laptop or monitor, it is helpful to know how to freeze a row in Excel. After all, it is often difficult to compare one or more rows with others that you are working on at the bottom of the document. Excel’s freeze pane feature solves this problem. How? You can lock specific rows of data so that they are always visible to you as you scroll through the Excel sheet. … Read the rest
Organize data by learning how to make a line graph in Excel. Present information over time with this simple guide to creating a line graph.
As you may have seen throughout your various uses of Excel, the program is a great way to store and organize information. Your worksheet is meant to lay out all the information you have in a way that is easy to follow.
But did you know that Excel has ways to organize this information even further? With Excel, you can organize your information into line graphs, or line charts, as they are sometimes referred to. … Read the rest
Excel may not always be the most exciting program to utilize at home or at the office, but it’s an essential one that keeps over millions of users organized and able to do their tasks with relative ease.
Whether you are relatively new to the world of Excel or you’ve been using it on a daily basis for over a decade, learning how to be creative and have a little fun will keep things a little more exciting and even improve your skills.
While many fun and creative projects in Excel are designed for school-aged users, who says that kids … Read the rest
Learning the shortcuts on any program can cut the time it takes to produce a document. With a program like Excel that has so many uses, knowing some of its shortcuts can make navigating, entering formulas, and setting up worksheets quicker to do.
Reasons to Use Shortcuts
Excel has many uses, although creating spreadsheets is probably its most common one. Within a spreadsheet, both written and numerical data is often used, so learning some of the shortcuts for both types of data can help save time when trying to organize information.
Using shortcuts takes less time because you won’t … Read the rest
When working with Excel spreadsheets, it can be difficult to extract the information you need from large sets of data. Pivot Tables (pv table) offer a great way to quickly condense and analyze, and present your data, allowing you to make informed decisions in both your professional and personal life.
Pivot Tables allow you to effortlessly summarize large amounts of data into a simple format that’s easy to read and analyze. You can subtotal numeric data, sort information into subcategories, or create custom calculations and formulas to focus your results.
Here, we’re going to discuss everything that you need to … Read the rest
Learn how to hide and unhide columns in Excel using keyboard shortcuts or the Home Menu methods.
Today’s post will illustrate how unhide columns in Excel, as well as hide them.
How to Hide and Unhide Data in an Individual Cell
While Excel does not allow you to Hide and Unhide individual cells using the Hide/Unhide command, here’s a trick showing how to hide just one cell:
- Choose the cell or cells you want to hide
- Select Cells from the Format menu and the Format Cells dialog box will appear
- Select the Number tab
- From the list of format categories,
… Read the rest
This article shows you how to make a drop down list in excel.
It provides two ways for you to quickly and easily make drop down lists in an Excel spreadsheet.
You can follow the instructions to create a new drop down list that will help streamline efficiency when collecting information in your spreadsheet.
A dropdown list can be a useful thing in your spreadsheet. Especially if you want to make it easier for others to enter information on your sheet quickly.
With a dropdown list, you can give other users a quick set of options instead of having to … Read the rest
I wrote a post stating that I could not find the Windows Ctrl+Home keyboard shortcut equivalent on a Mac. Well I’m here to tell you that I found the keyboard shortcut combination that does the same thing on a Mac. The Excel Gods are with me. Hallelujah!
Finding My Way Home
The key to finding this elusive keyboard shortcut is in the Keyboard Viewer. On your Mac select the Apple icon () and click System Preferences… Select Keyboard, and then make sure to click the Keyboard tab. Check the box for: Show Keyboard & Character Viewers in menu bar.… Read the rest
One of my all-time favorite keyboard shortcuts in Excel is CTRL+Home, but on a Mac there is no Home button. Hence a constant source of frustration these last two years.
I finally decided to do something about that and recently figured out a solution using VBA and the Personal Macro Workbook. But before I go straight to the answer, let me tell you how I got there.
I knew that VBA was going to enter into the equation, so I started to record a macro on a Windows PC while using the Control+Home keyboard shortcut. What I … Read the rest