Tag

Excel Archives | OXEN Technology

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
Tech Tip

How to group rows and columns in Excel

Grouping rows or columns in Excel can be very useful if you want to visually group items under a heading, or if you want to be able to hide or show data for better display. Grouping can be very useful in accounting spreadsheets. This is how you do it! Grouping rows or columns In your Excel spreadsheet, select the cells that you want to collapse. Do not select any cells that you want to remain visible – such as headings or labels or totals. With your cells selected, go to Data on the Ribbon toolbar. On the far right side,…
OTWAdmin
July 24, 2017
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…
OTWAdmin
May 29, 2017
Business ProductivityTech Tip

Delete an Excel Table without Losing Data or Formatting

Let's say you've created a table in Microsoft Excel. You don't want the Excel table, but you do want to keep the data or formatting. The solution is simple: convert the table back to a data range. Note: For this to work, you need to have an already completed table. Click anywhere on the table. This displays the Design tab under Table Tools on the Ribbon. A cell in the table must be selected for the Design tab to be visible. Then, on the Design tab, in the Tools group, click Convert to Range. Click Yes. Now you have a data range without table options. And that’s it!
OTWAdmin
August 10, 2016
Business ProductivityTech Tip

Simple Excel Formulas: SUM and AVERAGE

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…
OTWAdmin
July 25, 2016