How To

Excel Tips

ChannelAdvisor uses text files and comma-separated value files in multiple areas of the program in order to work with and display data in bulk. One of the most common tools to modify and view these files is Microsoft Excel. This set of articles is designed to provide you with some useful tips using Excel with ChannelAdvisor applications. Below are some of the more common formulas and tips we use to get our data to display properly and prepare our spreadsheets more efficiently. Click on the links in the table to get more details about each tip. If you would like additional information on the use of these functions, view the Help function in Excel.

 

Formulas What it does
The Concatenate function allows you to merge values from multiple cells into a single cell.
The Length function will count the number of characters from a cell and return the value
The Clean function removes all non-printable characters from a string.
Similar to Concatenate. Take data from 2 columns and merge them together into one cell. You can also use a separator in between the merged data.
  
Tips What it does
Find and Replace allows you to search for data in the spreadsheet and replace it with other data without having to search for it one by one.
Autofilter will allow you to sort your data by a specified range via a dropdown.
Highlight duplicate values in a list
Allows you to shade every other row to make your spreadsheet easier to read.
Separate delimited or fixed width text into separate columns.
Paste data into our Bulk Upload / Update spreadsheet as text-only (without the formulas). Transpose data from rows to columns or columns to rows.
Use to create a comma-separated list for use in our Advanced Filters without leaving the Excel document you’re in.
A simple formula to insert data on blank rows based on data in the row above
  
Tools What it does?
Returns the value from one set of data for another set based on a shared data point
  
Keyboard and other shortcuts What it does
Copies contents of your selection to the clipboard / Pastes the contents of your selection from the clipboard
Select all of the data in a column until it reaches a blank cell.

ChannelAdvisor uses text files and comma-separated value files in multiple areas of the program in order to work with and display data in bulk. One of the most common tools to modify and view these files is Microsoft Excel. This set of articles is designed to provide you with some useful tips using Excel with ChannelAdvisor applications. Below are some of the more common formulas and tips we use to get our data to display properly and prepare our spreadsheets more efficiently. Click on the links in the table to get more details about each tip. If you would like additional information on the use of these functions, view the Help function in Excel.

 

Formulas What it does
The Concatenate function allows you to merge values from multiple cells into a single cell.
The Length function will count the number of characters from a cell and return the value
The Clean function removes all non-printable characters from a string.
Similar to Concatenate. Take data from 2 columns and merge them together into one cell. You can also use a separator in between the merged data.
  
Tips What it does
Find and Replace allows you to search for data in the spreadsheet and replace it with other data without having to search for it one by one.
Autofilter will allow you to sort your data by a specified range via a dropdown.
Highlight duplicate values in a list
Allows you to shade every other row to make your spreadsheet easier to read.
Separate delimited or fixed width text into separate columns.
Paste data into our Bulk Upload / Update spreadsheet as text-only (without the formulas). Transpose data from rows to columns or columns to rows.
Use to create a comma-separated list for use in our Advanced Filters without leaving the Excel document you’re in.
A simple formula to insert data on blank rows based on data in the row above
  
Tools What it does?
Returns the value from one set of data for another set based on a shared data point
  
Keyboard and other shortcuts What it does
Copies contents of your selection to the clipboard / Pastes the contents of your selection from the clipboard
Select all of the data in a column until it reaches a blank cell.

0
Your rating: None Average: 4.5 (2 votes)
0
Your rating: None Average: 4.5 (2 votes)