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
Excel makes it easy to figure out the average of a group of numbers, no matter how large or small. It makes it easier for you to analyze important data. You will learn how to use Excel’s “average” function right here.
Most of us are familiar with average values. They offer a great way, to sum up information in a single number. Which gives us an immediate picture of any dataset.
If you have a large set of data, Excel can help you to find statistical values such as the average.
Not only can this help to enhance your understanding … Read the rest
Ready to hone your skills in working with Excel spreadsheets for a more organized workflow? Start with learning how to move columns in Excel. This especially helps with columns containing large swaths of data.
Columns, rows, and cells are perhaps the three most recognizable features of Excel. They provide the window in which to view, calculate, and organize your information. Further, they make moving your info around very easy. We will show you two ways to work with columns in your Excel spreadsheet. You’ll also learn how you can move columns in Excel without losing large swaths of data.
… Read the rest
Excel’s great for displaying data and even better at crunching numbers. Here’s how to add cells in Excel to sum up totals automatically… Even when you change the numbers.
A great feature that Excel has to offer is its use of formulas. Since Excel is often used to organize numerical data for a variety of operations, it can be beneficial to have an ‘addition’ function. In this guide, we are going to discuss the various ways we can add cells in Excel.
Why is the Addition Function Useful When You Need to Add Cells in Excel?
As we already … Read the rest
Knowing how to merge cells in Excel is a crucial skill. Although it may not seem like necessary information, it can be more useful than you might think.
Get the most out of your Excel user experience by reading on and learning more about merging and splitting your document’s cells.
Why Split or Merge Cells?
When you are organizing an excel document, the format in which you set up your sheet can be crucial to the information you are trying to lay out or present. A simple step like merging and splitting cells can give your document a cleaner look … Read the rest
Being a long standing Excel user and an avid Apple products consumer, I downloaded the new Microsoft Excel iPad app in April 2014 and quickly found out that you can’t do anything of substance until you pay a subscription fee. After looking at the available options I decided to purchase the Office 365 Personal yearly subscription, which is $69 + tax USD. It comes with full access to all Office iPad apps, OneDrive document storage in the cloud, and allows me to install the latest Office applications on a PC or Mac, which I haven’t done as of yet.
Here … Read the rest
A long time ago I was doing some reading on how you write and publish blog posts. One suggestion that helps me is the 24-hour rule. And that is to finish your post and then wait 24 hours before reading it one-last-time. After all, a blog post is going to be public, out there on the internet with your name on it, for a very long time.
The problem with this 24-hour rule is that I usually find one or more things that need to be changed. And then I have to wait another 24-hours.
When you are on a … 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
Sometimes you need to extract the integer portion of a number. Sometimes the fractional part. Sometimes both. Excel makes it easy to get the integer and somewhat harder to get the fraction. If you just want the answer, skip to the technical details.
The Integer Part: Excel INT Function
What could be easier than the Excel INT function? I mean INT almost screams INTEGER. So the name is intuitive. You almost “know” what it’s going to do, even if you haven’t used it before.
With only one argument, it’s execution is even simpler. Just feed it a number and … Read the rest
I sold my 15″ MacBook Pro yesterday and am waiting on a 21.5″ iMac to arrive in 2-3 weeks. So no more adventures with Excel 2011 for a bit.
Time to dust off the Dell desktop and reacquaint myself with the “real” Excel. That of the Windows variety. I’m putting Excel 2003 in my rear view mirror (finally) and will focus on Excel 2007 and 2010.
I would love to get Excel 2013 and test it out, but the Dell will need to be replaced this year so I’ll wait until I have a new PC. I would like it … Read the rest