In this video tutorial for Microsoft Excel 2011 For Mac, expert author Guy Vaccaro teaches you to effectively utilize the features and functions of Excel through project based learning. You will complete various projects, and along they way learn to leverage the power of the most important features Excel 2011 has to offer the Mac user. Microsoft Excel for Mac 2011 - Beginning & Intermediate Udemy. Microsoft Excel for Mac 2011 - Beginning & Intermediate. Go to Course $13.00. Go to Course Pricing Per Course Course Details en. Free certificate. Download microsoft excel 2011 for free. Productivity downloads - Microsoft Excel by Microsoft and many more programs are available for instant and free download. Microsoft excel 2011 free download - Microsoft Office 2011, Solver for Excel 2011, Microsoft Excel, and many more programs. Enter to Search. My Profile Logout.
Manage, analyze, organize.
Excel for Mac 2011 helps you analyze, organize, and manage all your data and lists. Then save, edit, and share online.
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.
Access your files anywhere.
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.
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.
Office 2011 for Mac is full of useful features, including the autorecovery tool in Excel. Although crashes in Excel for Mac 2011 are extremely rare, it doesn’t hurt to make sure Excel 2011 is backing up your changes as you work. The following sections show you what to do to ensure Excel is making backups and how to retrieve the backup if you need to.
Setting up AutoRecover in Excel for Mac 2011
Take a moment to make sure your preferences automatically save an emergency backup file of your work. Before you do that, remember that AutoRecover is not a substitute for saving your files often! To set up AutoRecover, follow these steps:
Choose Excel→Preferences from the menu bar.
In the Sharing and Privacy section, select Save.
Select the Save AutoRecover Information After This Number of Minutes check box.
Enter the number of minutes that you want between AutoRecover file saves, or use the increase/decrease control.
After you turn on AutoRecover, Excel saves your work at the specified interval so that you can recover in the event that the system or Excel crashes.
Retrieving an AutoRecover file in Excel for Mac 2011
2011 Microsoft Excel For Mac Pro 2017
If your computer or Excel crashes, you can recover your work up to the most recent AutoRecover save, but only if you turned on AutoRecover saves. Take these steps to restore any workbooks that were open at the time of the crash:
Click the Excel Dock icon.
Excel presents any documents that you’re working on that have been saved at least once. Recovered documents have (Recovered) in the title bar.
To keep the recovered version, choose File→Save As.
The Save As dialog appears. Take one of the following actions:
To replace the existing file with the recovered version:Navigate to the file or use Spotlight to locate the existing file. Then, click the filename to change the recovered file’s name to the existing filename. Click Save to overwrite the existing file.
To save the recovered file without overwriting the original: Select a location to save the recovered file and enter a name for the file in the text box. Then click Save.
To discard a recovered workbook, click the red Close button to close the workbook. When prompted, don’t save changes.
Microsoft Excel For Mac 2011
To permanently remove AutoRecover files from your computer, follow these steps:
Quit all open Office applications.
In Finder, press Command-F.
Enter AutoRecover in the text box.
Select all AutoRecover files.
Drag the files to the Trash.
Empty the Trash.