• Word for Mac 2011 and Excel for Mac 2011. On the Filter Records tab, click the Field pop-up menu, and then click Discount_. In the Compare to box, type 25, and then click OK. Microsoft Office for Mac 2011 tutorial: Use Mail Merge to create a form letter 15 Hints. Just click individual cells to sum Excel 2011 had the possibility to sum individual cells by typing '=', and then just clicking on individual cells across the workbook that you want to sum, and 'return' when done.

Paint programs even though work like bitmap programs, in general sense they are software that is supposed to give traditional painting medium feel and effects. On the right is an example of what an artist can do with a paint program. Discover seven of the best Mac and PC applications for digital painting, including Corel Painter, ArtRage, Rebelle's new version and more. It's very basic, very simple, and very easy to learn. Paintbrush is an open source application, and a number of derivations are available in the Mac App Store, where some more modern-looking Microsoft Paint-like apps, such as one called Patina, can also be found. Recommended for professional image editors, Pixelmator is priced at $29.99 which is quite steep compare to other programs like Paint for Mac. The most recent version of this software requires Mac OS X 10.9.1 or later as well as 64 bit processor. Created by Mark Pazolli, Seashore is a simple Paint equivalent for Mac. Apple's OS X 10.10 Yosemite software introduced so many new features that users will still be trying to learn them several months after installing the update. Best paint programs for mac.

By The official name of a pop-up menu in Excel 2011 for Mac is c ombo b ox. Don’t you just hate it when you have to use a pop-up menu that’s so big it doesn’t even fit on the screen? Pop-up menus work best when there are at least three but no more than 20 items to choose from. When you have fewer than three or more than 20 items to choose from in a list, use one of the other form control types. Here’s how to make a pop-up menu button: • While your form is unprotected, click the Combo Box control on the Developer tab of the Ribbon.

• Drag diagonally and then let go of the mouse. An empty pop-up menu button appears as selected on your worksheet. • Right-click the new menu button and choose Format Control from the pop-up menu.

Which mac is best for college. Question: In Microsoft Excel 2011 for Mac, how do I get the Developer tab to display in the toolbar at the top of the screen? The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form/ActiveX Controls like buttons, checkboxes, etc.

The Format Control dialog displays. • On the Control tab of the Format Control dialog, choose a range in a column that has the values you want to use to populate the control. Don’t include the header; include only cells that contain data.

Blanks don’t look right in a control; so make sure your data is contiguous. • On the Control tab of the Format Control dialog, set a cell link by clicking into the empty Cell Link field and then clicking a cell on any worksheet. The linked cell is indicated in the Cell Link field in the dialog.

This is where the results of the form user’s selection will display. • Click OK to close the Format Control dialog. Click away from the control to deselect it and then click the pop-up menu button to see the list from which to choose.

Make a selection, and the linked cell displays a number showing the count of how many places from the top of the list the selected item is. After a choice is made in the pop-up menu, the choice made displays within the control.

By In Excel 2011 for mac, a PivotTable is a special kind of table that summarizes data from a table, data range, or database external to the workbook. If you’re PivotTable aficionado, you will be in seventh heaven with the new PivotTable capabilities in Office 2011 for Mac. Here’s how to make a PivotTable: • (Optional) Select a cell in your data range or table. • Choose Data→PivotTable. Alternatively, on the Ribbon’s Tables tab, go to the Tools group and click Summarize with PivotTable. • Choose the data to analyze: Make choices from the following options: • Location: If you performed Step 1, your table or range is already filled in for you. If you didn’t start with a table or range, you can select a data range or table using the mouse.

• Use an E xternal D ata S ource: Displays the Mac OS X ODBC dialog. • Choose where to put the PivotTable: • New Worksheet: If selected, adds a new sheet to the workbook and places your PivotTable in Cell A1 of the new worksheet. • Existing Worksheet: Choose a cell on your worksheet. The cell will be the upper-leftmost corner of your PivotTable. Make sure there’s enough room so your PivotTable doesn’t overlap existing cell ranges. • Drag field names from the Field Name section at the top to the panes below.