Tag

Microsoft 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,…
OTWAdmin
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…
OTWAdmin
June 3, 2019