Excel 2011 for Mac

Free Demo Movies
Creating A New Excel File To Record Data
Renaming Sheets And Printing
Creating The Other Eleven Months
Exporting To PDF And Emailing To The Accountant
A Near Match Lookup For The Event Scores
Data Entering The Actual Results
Adding Up The Scores And Ranking For Position
Adding The First Month
Adding A Summary Sheet

Getting Started
How Time Saving Are These Excel Projects?
Making Use Of The Project Working Files
About The Excel Tutor
An Introduction To Math In Excel

Recording And Monitoring Sales Data
Creating A New Excel File To Record Data
Saving Your Workbook In The Correct Format
Improve Your Worksheet With Some Formatting
Adding Formulas To Total Rows And Columns
Adding Formulas The Quick Way
Working Out Our Average Consumption
Conditional Formatting To Improve Presentation
Renaming Sheets And Printing

Using Excel For A Profit And Loss
Creating The Data Collection Sheet
Setting Up A List Using A Named Range
Adding Formula To Create January Profit And Loss
Changing The Data Entry To A Single Sheet
Creating The Other Eleven Months
Using D Referencing To Generate The Whole Years Profit And Loss
Exporting To PDF And Emailing To The Accountant

Score Sheets For School Sports Day
Setting Up The Scoresheet Structure
Looking Up The Competitor Name
A Near Match Lookup For The Event Scores
Using Sheet Replication To Create The Other Event Sheets
Adding Protection To Protect Your Formula
Data Entering The Actual Results
Completing The Competitor Summary
Creating An Error Check For Events Competed
Adding Up The Scores And Ranking For Position

Expenses Claim Form
Expenses Claim Document Setup And Header Page
Adding The First Month
Displaying The Month Name Instead Of The Number
Creating Destination Lookups For January
Protecting January And Setting Print Options
Creating The Other Eleven Months
Adding A Summary Sheet
Using And Submitting Your Expenses Claim

Sales Contacts Management
Setting Up Excel To Store Data And Entering That Data
Creating A Unique ID And Freezing Titles
Calculating New Values Using String Manipulation
Sorting Your Excel Database
Filtering Your Dataset
Removing Duplicate Records From Your Dataset
Mail Merge Using Your Dataset
Form View In Excel
Summarizing The Dataset With Pie Charts

Stock Sales Summaries
Starting The Sales Data Record Sheet
Adding A Sales Chart To The Data
Replicate Sheets To Create Other Sales Regions
Summarizing The Sales Data
Importing CSV Format Sales Data
Adding Some Calculations To The Imported Data
Interrogating The Sales Data With A Pivot Table
Formatting The Pivot Table
Sorting And Filtering The Pivot Table

Next Steps
Reviewing Absolute And Relative Formulas
What Is The SkyDrive?
Saving An Excel File To SkyDrive
Informing Others That The SkyDrive Document Is There
MS Excel 2011 Summary
What Is Next?