Published May 19, 2015
Have you always wanted to learn more about MS Excel, but didn’t know where to start? UBIT is pleased to share five of the niftiest tips and tricks to minimize your time and maximize your Excel knowledge base. All of these features are available in MS Excel 2010/2013.
It’s easy to find yourself switching between two workbooks in order to compare data, but now it’s that much easier.
View multiple worksheets at once or flawlessly shift between different workbooks by using Ctrl + Tab.
You can arrange your windows in order to view all open files at the same time. (As seen in the screenshot)
View --> Arrange All --> Horizontal
Do you find yourself copying and pasting one column 20 times? Save your time and add 20 rows instantly.
1. Select the number of rows you want to add (20)
2. Right Click the highlighted rows and choose insert from the drop down menu
Working with a large spreadsheet? Navigate your spreadsheet easier with Ctrl + any arrow key to jump to the edge of the spreadsheet in different directions. If you want to jump to the bottom line of data, click Ctrl + down.
MS Word pulls names, addresses and other information directly from your Excel spreadhsheet into email meessages, labels, envelopes, or documents being created.
1. In MS Word, open a new document
2. Select Mailings > Start Mail Merge, click the kind of merge you want to run.
3. Click Select Recipients > Use Existing List
PivotTables are great at collapsing data into useful categories and giving you information about those categories. They're highly customizable, so try clicking 'Insert' and then 'Recommended PivotTables' to get started with some examples.
For examples, if you need to analyze data from a survey where you asked people what TV show they watch; instead of looking through a hundred different responses, a PivotTable will create a new spreadhseet that organizes your data by type of responses instead, so 'Batman' will be one line, 'House of Cards' will be another, and so on, each with a total or whatever other information you want to know. The point is PivotTables take your large, messy data set and turn it into easily accessible information.
Step 1: Enter Data into Excel
Step 2: Select the 'Insert' tab to insert 'PivotTable'
Step 3: Select fields you want to include in the PivotTable
Step 4: PivotTable Complete