Not only can Excel 2011 for Mac figure out number and date series on its own, but you also can teach Excel to figure out just about any series. You have two easy ways to make a new series with Custom Lists: Type a custom list from scratch, making entries in Excel Preferences. Start with an existing series of cells in a workbook. Microsoft Excel 2011 for Mac is the latest version of the most popular spreadsheet application in the world, now with the added bonus of much better OS X integration. Microsoft Excel 2011 is part of Microsoft Office 2011 and has been given a through revamp since Office 2008 including a slicker OS X style interface, lots of new templates and new.
The Custom Lists feature is about making lists that Excel for Mac 2011 can refer to when filling in a series by dragging a selected cell’s fill handle (the solid crosshair cursor), which results in an automatic series fill.
Not only can Excel 2011 for Mac figure out number and date series on its own, but you also can teach Excel to figure out just about any series.
You have two easy ways to make a new series with Custom Lists:
Type a custom list from scratch, making entries in Excel Preferences.
Start with an existing series of cells in a workbook.
For example, say you frequently make reports that have a series of reoccurring days. The following sections provide examples of how to create a custom list in Excel Preferences and from a series of cells.
Making a custom list in Excel for Mac 2011 Preferences
Microsoft Excel 2011 For Mac Tutorial
To make a custom list to use in fills, follow these steps:
Choose Excel→Preferences from the menu bar.
In the Formulas and Lists section, click Custom Lists.
The Custom Lists preferences pane displays. You see a handful of built-in series. You can’t change these.
Select New List in the Custom Lists list.
In the List Entries list, type the series entries in order.
If you have both Return and Enter keys, press Return (not Enter) after each entry. If you have just one Return key that says Enter as well, press this key.
Click the Add button when the list is complete.
Your series is added to the Custom Lists list.
When you’re done adding lists, click OK.
Making a custom list from a series of cells in Excel for Mac 2011
If you have a worksheet with a series in a range of cells that you want to add, follow these steps to add the series to Custom Lists:
In the Custom Lists window, click the small grid button next to the Import List from Cells pop-up menu.
The small grid button is to the immediate left of the big Import button.
Custom Lists preferences pane shrinks so you can see your worksheet. The cursor changes to a plus (+) sign.
Select the cell range that contains the list.
To do so, drag over the cells that contain the series you want to add to the Custom Lists preferences. A dotted line indicates the selected cell range, and Excel automatically types the selected range into Custom Lists preferences pane. Each cell’s contents becomes a list entry.
Press Escape or Return when you’re done selecting.
Preferences displays. The Import List from Cells pop-up menu displays the range you selected.
Click the Import button.
The selected series appears under List Entries.
Click the Add button.
The selected series is added to Custom Lists list.
Manage, analyze, organize.
Excel for Mac 2011 helps you analyze, organize, and manage all your data and lists. Then save, edit, and share online.
Microsoft Excel For Mac 2011
Display your data visually.
Create rich, visually compelling datasheets and tables with icons, data bars, and color scales. See enhancements like borders, solid colors, and negative values, as well as pre-packaged choices for formatting and filtering, including “Top 10,” “Bottom 10%,” “Text That Contains,” and more.
See trends within your data—and the big picture.
Sparklines are thumbnail‐sized charts that permit users to view large volumes of data at a glance, enabling the easy spotting of trends in time‐series data, or trendlines. Data can be expressed in bar, line, or column form. Sparklines are based on the OfficeArt engine, so they are rendered with very high quality and fidelity. They may also be “themed” to adopt specific color sets.
Manage your data.
Organize, filter, and format related data with Excel tables. Make managing and analyzing a group of related data easier, you can turn a range of cells into an easily viewed and manipulated Excel table. You can even insert more than one table into a single worksheet.
Summarize your data.
Spend less time sifting through data, and more time analyzing with automatic PivotTables. The popular PivotTable feature distills large sets of data into crisp summaries, and easily shows the cross‐tabular relationships between variables in the data. And in Excel 2011, PivotTables are more compatible with Windows Excel and have been redesigned for ease of use.
Program easily across platforms.
In enterprise situations where there is a mix of PCs and Macs, the Visual Basic feature works easily across all platforms. Visual Basic offers new features including IntelliSense and watch windows, as well as the Visual Basic debugging toolbar and new debugging tools.
2011 Microsoft Excel For Mac
Access your files anywhere.
Create actors from any photo or illustration and CrazyTalk Animator's innovative Actor Creator wizard. Reallusion crazytalk animator for mac download.
Post, access, edit, and share your files from virtually anywhere. Excel Online combines commonly used Office features and real-time co-authoring capabilities so you can collaborate for free with friends and family on shared spreadsheets.
2011 Microsoft Excel For Mac Versions
Excel 2011 Windows
Enhance tables with icons, data bars, and color scales.
See trends in your data—and the big picture.
Organize, filter, and manage your data.
Summarize and display your data in different ways.
Program easily across both Macs and PCs.
Access your Excel files from virtually anywhere.