Category Archives: General Update

Person in front of laptop with excel display

Google Sheets vs Excel: How Do They Differ?

When it comes to creating a spreadsheet on your computer, the program most professionals have routinely turned to is Microsoft Excel. As part of the Microsoft Office suite of programs, this title has been around for decades and has built a level of trust few other programs can replicate. For years this was the only true option available when it came to creating reliable spreadsheets on the computer: at least until Google Sheets came out. Here is what you need to consider regarding Google Sheets vs Excel.

Read the rest
man wearing white top using MacBook

What to Do When Excel Keeps Crashing

Microsoft Excel is one of the most-used programs on any PC. For accountants and anyone else who does bookwork on their computer, Excel is a must-have piece of software. However, if Microsoft Excel has crashed, it means there is some kind of issue going on behind the scenes. Excel doesn't take up much in the way of processing power. In fact, of all the programs you run it is probably on the lower end of the processing power use spectrum. Due to this you likely don't have any RAM or processor issues when Excel crashes. Instead, you'll need to look

Read the rest
Microsoft office icons including excel

How to Find Outliers in Excel in # Easy Steps

Microsoft Excel is generally considered the industry standard in spreadsheet software, specifically because it can adapt to multiple functions and because it is easy to use. Once you know how to use Excel, you know how to use Excel for life. Excel has a variety of uses, from preparing simple order sheets to calculating to creating complex graphic statistical analyses. In this article, we will give you a walk-through on how to find outliers in Excel and why finding outliers is an essential piece of data analytics in statistics.

Read the rest
Excel Spreadsheet Icon

How to Convert Excel to Google Sheets

For years, the only real spreadsheet software you had access to came in the form of Microsoft Excel. Now, Excel remains king of spreadsheet software. It comes packaged within the Microsoft Office Suite package of applications. However, it no longer is the only kid on the block. Google offers a number of great applications for free. While the applications are not as powerful as what you receive with the Microsoft options, when you don't want to spend money on the program and only need basic features Google is the way to go. Google Sheets gives you several excellent features, but

Read the rest
Woman is using microsoft excel to calculate something

How to Calculate Z Score in Excel: What You Need to Know

We get it. Statistics can be intimidating. All those numbers and all those graphs and all of the rules on how to interpret everything - it's enough to make your head spin. Which is why we're happy to tell you that some things can be less stressful with the use of modern technology. Specifically, the little helper we're talking about is - no surprise - Microsoft Excel. Keep scrolling to learn everything you need to know about how to calculate z score in Excel. You'll be glad you did. It's easier than you think to learn how to calculate

Read the rest
Excel Table icon

How to Find Variance in Excel? Follow These Tips

Microsoft Excel is a ubiquitous product, and one that gets used for many organizational tasks. Most people are familiar with the program's basic format even if they don't own it themselves. In addition, simple operations such as adding or deleting columns or populating individual cells with data are easy to figure out with little instruction. There's a lot more to Excel than the basics, though: the program contains many logical and mathematical operations that are useful when dealing with large amounts of data, and these operations require more knowledge to use effectively. One of the most useful among these is

Read the rest
A person is using a laptop and editing something to a excel file and beside the laptop is a cup of coffee and a sunglasses

How to Print Labels from Excel: Ultimate Guide

There are times where you will want to print from any number of applications on your computer. This includes Microsoft Excel. The software allows you to not only create spreadsheets but also labels. If you have several labels you need to produce, whether for mailing or for personal identification, you will want to generate the labels in Excel and then go about printing the information. Here is what you need to know regarding how to print labels from Excel.

Read the rest
creating graphs and charts using excel basics shown on the laptop

Sort Your Life into Neat Little Boxes with These Excel Basics

I've Heard of Excel, But I Don't Know What It Is

Excel is like that one coworker whose name you never learned until it was too late to ask. You've seen Excel around. Maybe you've seen it on a job description or you know it as the little green icon on your computer you never click.

Excel icon with question marks around

Image via Pixabay (altered)

What does it actually do though?

Excel is part of the Microsoft Office collection of applications designed to for the workplace. You may be familiar with some other apps in the collection like Word or Powerpoint.

These other apps are

Read the rest
How to Delete Duplicates in Excel

How to Delete Duplicates in Excel: An Easy Guide

How to Delete Duplicates in Excel

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 SUM Formula: What Is It And When Do I Use It?

If you have a large database of information, it can be difficult to make sense of all those names numbers. The Excel SUM formula lets you focus on specific categories within an Excel worksheet and come up with subtotals that can help you to spot trends and patterns in your data.

Read on to find out more about:

  • How the SUM function works
  • Using the Excel SUM function
  • Different applications for SUM formulas

About the SUM Function

The SUM function is one of the simplest functions in Excel, but it’s also one of the most useful. It’s one of several … Read the rest

average function in excel

How to Use the Average Function in Excel

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

Photo of spreadsheet on laptop with column selected for "how to move columns in Excel" article.

How to Move Columns in Excel While Keeping Your Data Intact

How to move columns in Excel

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.

How

Read the rest

The 24-Hour Rule

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

Excel without a Mac

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

Brain

Blog Comments and Inspiration

I’d like to thank everyone who has left a comment on this blog within the past year. It’s been a privilege to interact with some of you.

When I started this blog a couple of years ago, I was partially employed. Consequently I had lots of time to spend learning how to write blog posts about a topic that I am relatively good at, and a desire to share my knowledge.

Brain

My big problem is that I am a perfectionist. I want to express myself clearly, about topics that can be quite complicated.

About a year ago I started a … Read the rest