In excel 2010, there are two ways to hide or unhide rows in excel. You can use the keyboard or the mouse for these actions. Both the processes are given below and these steps will make it easier for you to understand do your work faster. This course features tons of tips to make Excel for Mac 2011 users more proficient and productive with the popular spreadsheet program. Learn the top shortcuts, find out how to most efficiently navigate and control the display, and discover the best ways to select, enter, and format data.
A lot of Mac users knock Excel for not being as pretty as Numbers on the Mac, but at the end of the day the hardcore Excel users care about one thing and that is functionality. If you’re looking for strong analytics tool that can easily calculate regressions, ANOVA, and other tools used by statisticians, then Excel with the StatPlus add-in is the solution for you.
However if you’re coming from a Windows environment you will find that there is no add-in dialog that allows you to install the StatPlus normally found in Excel for Windows. That’s because Excel 2011 doesn’t ship with StatPlus, it requires a separate download and install from the makers of StatPlus. Check out the guide below to get you started with StatPlus for Excel 2011 on your Mac.
Software/Hardware used: Excel 2011 and StatPlus:Mac LE running on Mac OS X.
Download and Setup StatPlus
1. Head on over to AnslystSoft.com to download a free copy of StatsPlus:Mac LE. Open the Zip file and extract the DMG file.
2. When you run the DMG file drag the application icon to the Applications folder.
3. To begin using StatPlus with Excel 2011, open the spreadsheet you wish to run the analysis on. Then open the StatPlus application and click Spreadsheet > Microsoft Excel.
Run Your First Analysis
To make sure everything is working as it should let’s give StatPlus a try.
1. Using the spreadsheet you opened in the previous section click Statistics > Basic Statistics then Descriptive Statistics.
2. Select the cell range you wish to use and click OK.
In a couple of seconds you will see a separate spreadsheet with the details of the analysis, that’s it. Play with the other tools to become familiar with the StatPlus application on your Mac.
Check back in the next couple of weeks because we will be covering some of the analytical tools in detail. If you have any comments or questions please use the comments form below.
When sorting your Excel tables and worksheets in Office 2011 for Mac, you’re likely to use ascending and descending sort orders most often. The quick way to sort a table or data range is to select a cell in the column you want to sort. Then go to the Ribbon’s Data tab, find the Sort and Filter group, and click Sort. The first time you click this button, the sort is lowest to highest or alphabetical. Click the button again to sort highest to lowest or reverse alphabetically.
Don’t click the column letter before sorting. If you do, the sort will be applied only to the contents of the column, not the entire table or data range.
After 27 years, Microsoft changed the name of this feature from AutoFilter to just Filter? R.I.P., AutoFilter. The Filter feature places a button to the right of each cell in the header row of a table or data range. Filter is turned on by default when you make a table, and you can see these buttons in the header row of a table. You can toggle Filter on or off by pressing Command-Shift-F. When you click the Filter button in a column header, the Filter dialog displays. The column header label is the title of the dialog. Filter lets you sort and filter.
Sorting data in Excel tables
The upper portion of the Filter dialog is for sorting:
- Ascending: Click this button to sort the column from lowest to highest or alphabetically.
- Descending: Click this button to sort the column from highest to lowest, or reverse alphabetically.
- By Color: If you have applied color formats to a table, you can use this pop-up menu to sort by cell color or font color.
Filtering data in Excel tables
Beneath the Sort functionality is the Filter section of the Filter dialog. Usually, you know what you’re looking for in a column, so the first thing to do is either type what you want in the search filter or choose it from the Choose One pop-up menu and form field. Starting at the top of the Filter options you can choose:
- By Color: Show records in your column that match the cell color, font color, or cell icon. If you haven’t applied colors or conditional formatting, this pop-up menu is inactive.
- Choose One: Select a criterion from this pop-up menu. Then, in the pop-up menu to the right, you can select a record from the column that matches the set of conditions.
- Check boxes: You can select and deselect these boxes to display only rows that match the selected items.
- Clear Filter button: Removes all criteria from the entire Filter dialog so that no filter or sorting is performed.