Tag

Excel Archives | OXEN Technology

Tech Tip

Basic math in Excel: Addition, subtraction, multiplication, and division

Are you new to Excel, and not sure where to start with formulas and operations? Many spreadsheets use basic math: adding and subtracting numbers or multiplying and dividing. Understanding these math formulas will help you graduate to more complex equations to manipulate your Excel data. How does basic math work in Excel? Excel uses formulas or functions to manipulate data. A function takes an input, which is the content of cells plus some operating symbols that say what to do with the data. You can input a single cell into a function or a range of multiple cells. For addition,…
OXEN Technology
January 13, 2020
Tech Tip

Transposing Rows and Columns in Excel

What's transposing in Excel? “To transpose” means to make items change places with each other, or to flip a grid or table such that columns become rows and rows become columns. This may be a little hard to grasp, but it’s something that you may frequently want to do in Excel: How do you take values in a row and flip them so that those values are stacked in a column? (Or vice versa.) The answer is transposing them. This is how. Transposing in Excel Say you have data in rows, like this, and you want these names to be moved…
OXEN Technology
June 3, 2019
Tech Tip

Counting in Excel with COUNTIF

Maybe you have a list in Excel and you want to know the number of times repeating items appear. Say you have a list of contacts with their company names, and you want to know how many times a company appears (which is the number of contacts from that company on your list). There's an Excel formula for that, called COUNTIF! Create a Legend First, you need a list of unique company names only to create a "legend". You can get this by copying the Company column and pasting it into another column. Then select the new column and go…
OXEN Technology
May 29, 2017