excel - Technology Support Services

Documentation

Excel offers many tools for you to organize your data. The Quick Analysis tool will quickly analyze and visualize data for you.
Below is a step-by-step instruction on how to use it:
 

1. With your data selected, open the Quick Analysis tool by pressing Ctrl + "Q."
    

2. Select the tab you would like to use (sparklines, formatting, tables, etc.) and hover over the options to see a preview. Note that these methods will be different depending on the nature of the data you've selected. 
    

3. Click on your choice to create a visualization in a new worksheet. 

Documentation

Occasionally some numbers in Excel don't format correctly in Word when using the mail merge feature under the Mailings tab. Follow these steps to resolve this issue before your merge. 

1. First, make sure your ZIP or postal codes don't lose any zeros in the mail merge process by formatting them in your Excel file as text. 
    
2. In Word, click the "File Tab" then click "Options." 
    

3. Choose "Advanced" from the left pane and select "Confirm file format conversion on open." Click "OK." 
    

4. In the mail merge document, click the "Mailings" tab, "Select Recipients," then "Use an Existing List." 
    

5.  Browse to your spreadsheet and double-click it. 

6. Click the "Show all" button in the "Confirm Data Source" window, select "MS Excel Woorkseets via DDE (*xls)" and select "OK." 
    

7. Click "Entire Spreadsheet" then click "OK." 
    

8. Now you can continue with your mail merge. 

Documentation

Excel offers many tools for you to organize your data.The Flash Fill option will help you format your data quickly.
Below is a step-by-steb guide on how to setup and use Flash Fill.
 

1. Type in the first selection of data the way you would like it to be formatted. In this case, we're concatenating two strings of text.
    

2. Once you start typing the second selection, Excel will detect what you're trying to do and will provide a preview for the rest of the data formattted this way. 
    

3. Press Enter and the rest of the data will auto-fill using the Flash Fill feature. 
    

4. To Accept or Undo Flash Fill actions, click on the small box that appears next to the area that was filled.