Microsoft Excel for Mac 2011 - Beginning & Intermediate

Launch Excel for Mac 2011 by using Spotlight search or opening it from Applications, then start a new workbook and explore templates or create your own.

Add Microsoft Excel to your Mac dock using Spotlight, or remove and re-add it, then drag the app icon to the dock for quick access.

Explore the Mac 2011 Excel window, ribbons, and command groups across the home, layout, data, and review tabs, identify the active cell, and navigate to addresses and sheets.

Contextual tabs appear on the ribbon when you select an object, such as an image, providing picture formatting options that appear and disappear with the selection.

Master navigating a Mac Excel worksheet using arrow keys, tab and shift-tab, function-key paging, and command-key jumps to the top, bottom, first column, and last column XFD.

Distinguish a workbook as the Excel file and identify sheets inside it. Note that people often call the file a spreadsheet and that workbook and sheet names can be renamed.

Create, open, and close workbooks in Excel for Mac 2011 using command-n and the Quick Access Toolbar. Open recent workbooks from the File menu or via the open option.

Master entering and editing labels and values in Excel for Mac 2011. Learn to navigate with tab and arrow keys, edit by double-clicking, and correct data with delete.

Learn how to speed data entry in Excel for Mac 2011 using autofill to create months, days, times, and serial numbers by dragging the fill handle with patterns.

Learn to save and save as in excel for mac 2011 by naming the workbook, choosing a location, and showing extensions like xlsx with command-s.

Select a cell range and enter data with keyboard shortcuts. Use return or tab to move within the range, cycling by row or column for efficient entry.

Master keyboard navigation for entering data in an Excel Mac 2011 range, using tab to move forward, shift-tab to move backward, and enter or shift-enter to move down or up.

Differentiate labels and values in Excel; learn to force text with an apostrophe, spot left vs right alignment cues, and recognize dates, times, and currencies as values.

Enter and manage dates in Excel for Mac 2011 by applying a date format from the Home tab, exploring standard versus custom formats, and selecting month day year options.

Learn how to use Excel's sum function to automatically calculate totals from ranges, starting with an equals sign, using the quick access toolbar, and distinguishing labels from values.

Learn the sum function in Microsoft Excel for Mac 2011 by editing the range with typing or dragging handles, and understand the function’s syntax and arguments for accurate totals.

Copy the sum function across cells using the auto fill handle, letting Excel adjust relative references. The lesson introduces relative and absolute references and how to verify copied results.

Learn to build Excel formulas using cell references and the four basic operators—addition, subtraction, multiplication, and division—highlighting the equals sign, formula bar, and dynamic results.

Explore absolute vs relative cell references in Excel for Mac 2011, learn how copying formulas adjusts references, and how to fix with absolute references using dollar signs.

Explore the formulas tab in Excel for Mac 2011 to access functions, audit tools, switch between absolute and relative references, and trace precedence while checking for errors.

Learn to calculate the average and max functions in Excel for Mac 2011, select ranges like B7:B10, and extend results across months to reveal expense trends.

Move and copy cells in Excel using cut, copy, paste, or drag-and-drop. Adjust column width to fit data, and use undo or escape to manage selections.

Copy data to a new sheet in Excel for Mac 2011 to reuse a template for next year, paste, clear contents while keeping formulas, and rename sheets for automatic calculations.

Explore the various paste options in Excel for Mac 2011, including paste, paste special, formulas, values, formatting, borders, and links, and how view scaling affects commands.

Learn to use formatting options to make your spreadsheet look nice, bold titles, center alignment, color, fill, and quickly apply formatting to noncontiguous ranges with the command key.

Master formatting and merging in Excel for Mac 2011, including bold, underline, fill color, font styles and sizes, and center across selections with merge and center.

Learn how ribbon options change with window size and screen resolution, and how adjusting these settings reveals more formatting options like edit, fill, clear, and alignment.

Explore Excel's number formatting and apply currency, accounting, date, time, percentage, and custom formats. Convert text to numbers and adjust decimals, with auto fit for column widths.

Learn to format numbers as currency in Mac Excel: choose accounting or currency, adjust decimals, remove dollar signs, and access format options via right-click when needed.

Learn how to clear formatting or clear contents in Microsoft Excel for Mac 2011, using the Home tab or Edit menu to clear formats, contents, or all.

Adjust column widths in Microsoft Excel for Mac 2011 by manual resizing or auto fit, and apply changes to multiple columns via drag, double-click, and noncontiguous selections.

Learn to adjust row height in Excel for Mac 2011 using drag to resize, auto fit by double-clicking, select noncontiguous rows, and apply formatting such as wrapping text.

Adjust row height and apply top, middle, and bottom alignment in Excel for Mac 2011. Wrap text and rotate headers, then shrink text to fit for cleaner, professional spreadsheets.

Insert rows, cells, and columns in Microsoft Excel for Mac 2011 using the ribbon or right-click, including shifting options and automatic formula adjustments.

Select the row header to delete a row using the ribbon or right-click delete. Undo with command z or the Quick Access Toolbar, and note how deleting cells shifts data.

Insert and delete columns in Excel for Mac 2011 by selecting the column header and using right-click insert or delete. Ensure formatting matches adjacent columns and use undo if needed.

Select the range and apply borders via the Home tab or format cells border. Use outside, all, and diagonal borders, and top and bottom borders for accounting totals; save workbook.

Use the format painter to copy formatting from a formatted cell to others in Excel for Mac 2011. Apply font, alignment, and number formats quickly to save time.

Learn to preview and print Excel data on Mac, setting print areas, scaling to one page, choosing portrait or landscape, and centering the output for professional reports.

Create and customize charts in Microsoft Excel for Mac 2011, including selecting noncontiguous data ranges, choosing chart types, formatting styles, and printing alongside your data.

Set up and preview your Excel charts for printing by adjusting chart size, positioning, and the print area, then print or save the final report.

Update the chart by editing underlying sales data in Excel for Mac 2011, and watch the live chart and formulas refresh automatically as values change.

Copy and move charts to a separate sheet, using paste or paste special for static images, then set print area and orientation to produce a clean, linked report.

Copy charts to a separate sheet, paste normally or as a static image with paste special, and set print area and orientation to print standalone charts.

Learn how to extend an Excel chart by adding new data to the right, adjusting the data range, and dragging handles to include June without redesigning the chart.

Analyze trends and sort data in the P.B. travel sales report training file using Excel for Mac 2011. Sort by last name, region, or sales to reveal strengths and weaknesses.

Learn how Excel for Mac 2011 automatically guesses the data range during sorting, watch the pink flash to see the range, and adjust to include breaks or new rows.

Learn how sorting behaves when the selected range excludes adjacent data, and how breaks and empty rows limit sorting to the closest range, with examples from expenses.

Sort a selected range in Mac Excel 2011 by using the data tab. Apply custom sort options to order by a column, including ascending or descending.

Master sorting by multiple criteria in Excel for Mac 2011 by using custom sort to order regions alphabetically and total annual sales from largest to smallest.

Learn how to use filtering in Excel for Mac 2011 to quickly view regional data by cell values, hide nonmatching rows, and clear filters to return to all data.

Filter by a number in Excel for Mac 2011 to reveal top and bottom sales. Use greater than 250000 or less than 100000 to view filtered sales reps.

Learn how tables differ from filtering in Excel for Mac 2011, convert a data range to a table, apply styles, and use built-in filters for fast data analysis.

Explore table features in Excel for Mac 2011, including header options, banded rows and columns, first and last column formatting, and inserting new columns within a table.