You’ve probably used Excel as a spreadsheet for your research, and that’s good, because it’s great at what it does.
But it’s also great at being a tool for the sake of it.
That’s what the Centre of Excellence of Excellence for Excel (CAPe) is, and it’s got its detractors.
But if you’re looking for a spreadsheet that will make your research more interesting and more productive, then CAPe may be the spreadsheet for you.
CAPe has a lot of neat tools to help you keep your data up-to-date, like ‘multi-row’ filtering to keep your files neatly organised, ‘column-wise’ sorting to sort your files by column, and ‘multi column’ grouping to sort files by sub-columns.
CAPE is also a pretty simple spreadsheet, so you don’t need to understand the complicated formulas behind the scenes to make a great spreadsheet.
Here are a few things you can do to make your spreadsheets a little more enjoyable to work with.
1.
Use ‘multi’ filters to help make your files more readable 2.
‘Column-wise sort’ allows you to sort rows based on column width, with an option to sort by date or by column name (for example, ‘Date sorted by Year’) 3.
‘Single column’ allows for easy grouping of files in one column or by one column name, and allows you with a simple mouse click to sort the files alphabetically or by date, which is useful for making quick, one-time research trips.
CAPes formulas are also useful for finding trends, as the formulas are pretty straightforward.
For example, if you know that you’ve got a large number of Excel files, you can sort them alphabetically by year and find trends in a way that makes sense.
CAPEs formulas are designed to be used with a few clicks, so the formulas won’t take up too much space in your spreadsheet or get too cluttered.
It’s important to understand what they do to help with sorting, and how to use them in a logical way.
CAPES formulas have an icon in the lower right hand corner, which you can click to open up a full-screen preview of their formulas.
You can click on the icon to see more details, such as how many columns are involved in the calculation.
1 of 5 Next Previous Next The formula that I’m about to show you will give you a simple way to sort all of your Excel files alphabetously by year, by date (or by date range), and by column.
This formula uses two formulas that are commonly used in Excel: ‘Sort by Date’, which sort your Excel data by the date they were created, and the ‘Sort By Column’, which sorts by the columns of data in the spreadsheet.
When you’re working with Excel, ‘SortBy Date’ works like this: This formula, however, uses ‘Columns’ to sort Excel data.
When working with ‘ColumnSets’ in Excel, the formula works like so: The ‘sort by’ and ‘sort columns’ functions can also be used to sort tables of data by date.
Here’s how: 1.
Enter the date range of your data into the column of data column of your spreadsheet.
You’ll need to enter the year range into each column in order to get a range of years.
The date range will be displayed as a red bar, and you’ll also see the date ranges as a blue bar.
The red bar indicates the range that Excel gives you for that date.
2.
Click the ‘sort rows’ button at the bottom right hand side of the spreadsheet window.
This will bring up a column-by-column sort of function, which sorts the rows of the column by the number of rows of data.
The ‘column’ will be a number.
3.
Enter your date range in the ‘date range’ column of the formula.
The function will sort the rows by the length of the range in days, or by the amount of days.
You won’t be able to click on rows to sort, but you can use the ‘column range’ to group the rows into a single range.
4.
If you want to sort each row by date of creation, then use the function ‘sort dates’ to find the first day of each row of the first column of each data file, or, if that’s not possible, ‘sort days’ to return to the date you entered for the date in the first row.
5.
If, however that’s a date range that doesn’t have columns, then you can add columns to that date range by using the ‘group by’ function.
Enter a range to sort based on the date and number of columns that make up the range.
If the range contains no rows, then it will sort by the same date range, and if