Microsoft Excel 2011 for Mac Tutorial - Learn The Easy Way.

Learn to start a new Excel workbook, create and manage sheets, enter and fill data across days of the week using the fill handle, and save in various formats.

Save your workbook in a compatible format by choosing between xlsx for current Excel or an older format for broader access, and name the file meaningfully.

Learn how to format cells in Microsoft Excel 2011 for Mac to make headings stand out with font size, color, alignment, and borders, and apply theme colors across ranges.

Create formulas to total daily fruit consumption and per-fruit totals in Excel 2011 for Mac. Copy formulas across rows and columns, handle empty cells, and format for clear totals.

Learn to speed up summing in Excel for Mac by using the autosum button (sigma symbol) to automatically insert the correct sum formulas for selected cells.

Learn to compute average fruit consumption per day in Excel 2011 for Mac using the average function, by selecting a range of fruit cells, copying formulas, and adjusting decimal places.

Learn to apply conditional formatting in Excel using data bars and color scales to highlight relative values, with steps to apply and clear rules.

Rename sheets in Excel 2011 for Mac and adjust print options with print preview, page setup, landscape or portrait orientation, and scaling to fit selected areas or the entire workbook.

Create a data collection sheet in Excel to track daily income and expenditures, logging date, amount, income or expenditure, category, and description for monthly and yearly profit and loss.

Create a named range for categories, then use it to power a drop list for income and expenditure entries; hide the source sheet and update the range as needed.

Learn to build a January profit and loss using excel 2011 for mac, creating a summary sheet, using sumif to total income and expenditures, and calculating profit and percentage profit.

Learn how to consolidate monthly financial data in a single data-entry sheet, using formulas like sumproduct and sumifs to allocate income and expenses by month for a streamlined PNL.

Learn to manage multi-month data in Excel 2011 for Mac by freezing headers, duplicating monthly sheets, renaming months, and using sumproduct formulas to build an annual PNL.

Learn to generate a full-year profit and loss by using a 3-D reference to sum across January through December sheets in Excel 2011 for Mac.

Export the current sheet as a pdf and email it to your accountant, while using 3d referencing to assemble the 2011 monthly pnl summary from the year's data.

Learn to set up a Mac Excel 2011 scoresheet for a school sports day, creating a competitors sheet, seven event sheets, formulas and lookups, formatting, freezing panes, and saving options.

Learn to build a named range for competitors and use a vertical lookup to return names from IDs, with exact match and error handling to keep the score sheet tidy.

Create a named score lookup table mapping jump heights in inches to scores, and use a vlookup with approximate match to compute event scores.

Use sheet replication in Excel to create and rename multiple event sheets for high jump, long jump, 100m, and 200m, invert lookup tables and handle errors.

Learn how to protect Excel 2011 for Mac workbooks by locking sheets, unlocking specific cells for data entry, and using optional passwords to prevent accidentally breaking formulas.

Enter actual event results through data entry into a protected multi-sheet workbook, using lookups and formulas to calculate times, distances, points, and final rankings.

Build a cross-sheet competitor summary in Excel 2011 for Mac using indirect to reference event sheets and lookup to fetch scores from a fixed range, with absolute references.

Insert a column and use count if to tally non-hyphen cells, then apply conditional formatting to flag competitors who haven't completed three events.

Learn how to score competition in Excel 2011 for Mac by using sum and rank formulas, fill handle, and sorting to create a league table.

Create an expenses claim form in Excel 2011 for Mac by designing a front sheet, input fields, and mileage allowance, then format borders and adjust print settings.

Create the January expenses claim form, set up headers and dates, and use formulas to auto-fill days and pull the claimant name from the front sheet.

Learn to display the month name instead of the number in Excel by creating a 1–12 lookup table, naming the range, and using a lookup formula with an exact match.

Create a destination lookup file in a new sheet to drive January expenses, calculating mileage, parking, lunch, and sundries through named ranges and lookups.

Protect January expenses by unlocking only the first day, location, and sundry cells, then protect the sheet to prevent changes, and adjust print settings to fit one portrait page.

Learn to create the other eleven months in Excel 2011 for Mac by duplicating and renaming monthly sheets, updating start dates, and validating formulas and lookups.

Add an annual summary sheet and use the indirect function to pull each month’s total miles from cell C38, replicating across months to calculate grand totals for miles and dollars.

Finalize your expenses claim form, choose an easy send format like pdf, and submit monthly expenses to your area manager by email or by sharing full or single-month Excel file.

Create a data file with top-row headings to form a sales contact mini-database, enter data across rows with tab, wrap text or widen columns, and save.

Learn how to assign unique ID numbers to each employee, use autofill to create a sequential series, and keep headers visible by freezing panes for on-screen and printed pages.

Combine first and last names with concatenation to form a name and salutations, extract initials with the left function, then calculate ages using date diff from birth dates to today.

Learn to sort your Excel database with quicksort and custom sort, using age and month as secondary criteria while keeping headers and data synchronized.

Activate auto filters to add dropdowns at each column and apply multi-criteria filters by gender, age, or department to narrow the dataset.

Learn to remove duplicate records in Excel 2011 for Mac using the data ribbon, choosing whole rows, single columns, or multiple fields like email addresses to identify and delete duplicates.

Merge excel data into a Word mail merge to personalize pension letters, using placeholders for name, address, salutation, date, and a calculated time to retire (65 minus age).

Explore form view in Excel to access and edit data like a database, add and delete records, and search with criteria, all while navigating one record at a time.

Learn to summarize a dataset in Excel by naming ranges for gender, status, and department, count with countif, and create pie charts to visualize distributions.

Build a regional sales data sheet in Excel for Mac, enter monthly fruit sales, use fill handle to replicate figures, import data, auto-sum totals, and create pivot tables and charts.

Add a sales chart to visualize monthly data with column or line charts, then switch plot types to compare fruits across months.

Replicate sheets to create other sales regions, keeping charts linked to the data. Prepare the initial sheet with formulas and graphs before replication.

Create a company-wide summary sheet by summing the same cell across five region sheets using 3D referencing, then visualize with a pie chart and labeled data.

Import csv and delimited text sales data into Excel 2011 for Mac by selecting text file, choosing comma or tab delimiter, then prepare data for a pivot table.

Add calculated columns to imported data to compute line totals (quantity times price) and derive month and year from the date, then fill the formulas down for pivot table preparation.

Explore pivot tables to summarize sales data by year and month, using rows, columns, values, and a report filter, with options to average, count, and format numbers.

Explore formatting pivot tables in Excel 2011 for Mac, using quick styles, color schemes, and banded rows, plus labeling rows and columns for clarity.

Master sorting and filtering pivot tables in Excel 2011 for Mac, control default sort order for months and years, apply value or label filters, and drill down to extract data.

Learn to use absolute and relative references in Excel formulas, copy formulas with the fill handle, and fix columns, rows, and Vlookup tables with dollar signs.

Discover how sky drive provides 25 gigabytes of free storage accessible via sky drive dot com with Windows Live ID, where you can share folders and edit or view files.

save an excel file directly to SkyDrive by saving to SkyDrive, signing in with Windows Live ID, and selecting a destination folder, enabling access from any device.

Learn to share Sky Drive files by copying the web address, emailing it via Outlook, and enforcing permissions so only authorized users can view or edit.

Master Excel 2011 for Mac by building sales data models, using conditional formatting, lookups, pivot tables, and charts to summarize across sheets and create a profit and loss account.

Explore built-in templates in Excel using file > new from template to start ready-made work. Experiment with macros, sparklines, formulas, and pivot tables to extend your analysis.