Quick Analysis Feature in Excel

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. 

Using the Mac OS X Dock

Documentation

Using the Dock
Starting Applications Without Using the Dock
Adding Items to the Dock
Removing items from the Dock
Changing the Dock Appearance
Stacks

Using the Dock

To access any of these files or applications, click one of the icons in the Dock. When an application launches a small white orb will appear under the application icon to signify that the application has launched. If a file or application isn't in the dock, its icon appears there once you open it.



To open a document using one of the applications in the dock, simply drag the document to the applications icon in the dock, and the document opens.


Starting Applications Without Using the Dock

1. Open the Hard Drive icon.
   

2. Click the Applications label. All of the applicatons are displayed in the window. You will need to double-click the application to launch it, whereas in the dock only a single-click is needed.
    
 

Adding items to the Dock

Dragging an applications icon to a space between other icons on the dock will a new entry. This same process can be used to add frequently accessed documents or other items as well.
When an application is open, you can hold control and click it, expand "Options" and click "Keep in Dock." 


 

Removing items from the Dock

Just as dragging a file/folder onto the Trash icon will delete the file/folder, dragging a dock item onto the Trash icon in the dock will remove the entry from the dock. You can also drag it into a blank section on your desktop. It will disappear in a puff of smoke. Additionally, control-click, expand "Options," and click "Keep in Dock" to uncheck it. 


 



Changing the Dock Appearance and Order

Click on the System Preferences item in the dock and then the dock preferences item to view or change the dock settings. You can reposition items by clicking and dragging them to a new location on the dock. 

Stacks

A stack is a dock item that gives you fast, convenient access to a folder of files. When you click a stack, the files within spring from the Dock in a fan or a grid, depending on the number of items (or the preference you set). You can create as many stacks as you wish simply by dragging folders to the right side of your Dock.

Flash Fill Feature in Excel

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. 
    

Subscribe to training