Excel can be a powerful tool for your business, but it can also be daunting with its many formulas, charts, and formatting. Here we’ll take a look at two simple but very useful Excel formulas, and how to make them work for you. Follow these tips to add up numbers or average them!

Adding Up Numbers

You have multiple columns or rows of numbers. You don’t want to have to add them all up on your calculator, and you don’t want to have to re-add them if the numbers change. The simplest solution? Use AutoSum!

To add up a row or column of numbers, highlight all of the cells you want to add up (either vertically down a column or horizontally in a row). Then click AutoSum on the Ribbon in the Editing group. This will quickly add the sum of your selected cells in a cell below or to the right of your selection.

AutoSum in Excel

If you want to type the SUM formula, click in any empty cell and type =SUM(CELL:CELL). CELL:CELL are the first and last cells in your range. Therefore, a finished formula would look like =SUM(A1:A12). Press Enter on your keyboard and your sum should appear!

Excel Formulas: SUM

Averaging Numbers

The AVERAGE formula works the same as the SUM formula. To use it, select a range of numbers. Then click the down arrow next to AutoSum on the Ribbon. From the drop-down list, select Average.

Average from AutoSum in Excel

If you want to type the AVERAGE formula, it works the same way as the SUM formula as well. In a blank cell, type =AVERAGE(CELL:CELL). Again, CELL:CELL are the first and last cells in the range you want to average. Then hit Enter on your keyboard and your average number will appear.

Excel Formulas: AVERAGE

Now you can use two of the easiest, most common Excel formulas!


Protecting Against Former Employees

How to Protect Your Business Against Former Employees

| Security | No Comments
We’ve said this frequently, and we’ll say it again. One of the biggest security weaknesses that businesses face are their own employees. This isn’t pleasant, but it’s a truth that we have to face. Humans are a weak link in our cybersecurity defenses. When we make mistakes – forgetting to change a default password or clicking on a link we shouldn’t – we open the door for attackers. But there’s another way that your people can threaten your organization. It's from within: disgruntled or dissatisfied former employees. These are people who are no longer with your business but may still…
Voting Options in Outlook Email

How to Add Voting Options to an Outlook Email

| Tech Tip | No Comments
Need to take a quick poll? Maybe you need to find out how many people in the office are coming to lunch – and this quick tip will show you how the voting options work in Outlook! To making voting options available in an email you are composing: Click on the Options tab on the Ribbon. In the middle of the ribbon, click on Use Voting Options, and select which answers you want to make available. After clicking, you should see an information message that says “You added voting buttons to this message”. Send your email! Recipients will receive your message with…
2019 State of the IT Industry Landscape by OXEN Technology

2019 State of the IT Industry Landscape, Part 5: The Internet of Things and Wireless

| Infrastructure, Leadership | No Comments
In the fifth and final installment of our 2019 update on the state of the IT landscape, we look at two more industry trends: the Internet of Things (IoT) and wireless and wi-fi technologies. What are they, and why is demand increasing? Why is cybersecurity still of constant importance in these areas? Industry Trends: The Internet of Things (IOT) What is the Internet of Things? The IoT is a global network of objects that collect and communicate data via the internet. It extends Internet connectivity beyond laptops, phones, and tablets to an extremely diverse range of “things”. IoT devices include…