Master Excel 2011 for the Mac

Course details

Learn the basics of Microsoft Excel for the Mac with these step-by-step video tutorials!

If you're already an expert, this tutorial probably isn't for you. But if you're having trouble or are a beginner to Excel for the Mac, this video course gives you the step-by-step instructions you need. Four hours of course instruction is divided into 25 videos that show you the essential tasks you need to know in order to use Microsoft Excel productively on the Mac.

Video topics included: 
- Creating your first spreadsheet using Excel 
- Visualizing data with Pie Charts 
- Using Formulas 
- Basic Spreadsheets and totals 
- Importing text files and comma delimited files 
- Pivot Tables 
- Doing statistics like standard deviation 
- IF and IF ELSE statements 
- Adding line/bar charts to your spreadsheet 
- VLookup function 
- Creating popup lists 
- Creating Tables 
- Making headers look nice with color and formatting 
- Using Formulas 
- Copying rows and columns 
- Sorting horizontally 
- HLookUp 
- The Count Function 
- Date/Time data 
- Locking cells 
- Conditional formatting 
- Named formulas 
- Math formulas 
- Cell Ranges