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

Learn Microsoft Excel 2011 for Mac at your own pace. Comes with Certificate of Completion
4.3 (69 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
24,784 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 60
  • Length 5.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2012 English

Course Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

This hands-on Microsoft Excel 2011 For Mac course shows you how to effectively use the many features and functions of MS Excel. You will learn to leverage the power of the most important features Excel 2011 has to offer the Apple user, whether you're working in an all-Mac office or needing to coordinate with PC counterparts. Beginning your training with the creation of a sheet to record and monitor sales data, you'll learn the basics of what you can do with spreadsheets. The course then moves on to creating a Profit and Loss report, building a solid understanding of formulas along the way. Moving to score sheets for a sports day, you will discover conditional formatting, lookups, and more. You then create a functional expense claim form and a sales contact management sheet, exploring how you can easily manipulate text, and even create mail merges from within Excel. Whether wanting to beef up your existing Excel skills or learn the program from the ground up this InfiniteSkills Excel course is a tremendous resource with over 50 lessons.


What You Will Learn

- How to create professional quality spreadsheets, workbooks and presentation-ready charts with one of the world's leading office productivity tools.
- How to manipulate and implement data across a wide range of projects.
- How to create fully compatible documents and projects that can be accessed by users working with Office for Mac products as well as Windows counterparts.


Who Should Take This Course

- Anyone who has used Microsoft Excel in the past but wanted a better understanding of its full range of features.
- Anyone who needs an understanding of Microsoft Office software as it applies to a professional work or academic environment.
- Anyone Mac user new to MS Excel wanting a user-friendly guide that introduces the program from the ground up.


What People Are Saying

"I swear I thought excel was the most confusing program ever created...until I started following the simple examples in YOUR course. THANKS."
-Jake Swearengen

"Exactly what I needed. Very direct training on each major part of the program. Guy's presentation style is straightforward and effective."
-Alan Greenberg

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started
Working Files - Download These First
Preview
Article
How Time Saving Are These Excel Projects?
Preview
07:49
Making Use Of The Project Working Files
01:51
An Introduction To Math In Excel
09:30
Section 2: Recording And Monitoring Sales Data
Creating A New Excel File To Record Data
05:33
Saving Your Workbook In The Correct Format
02:23
Improve Your Worksheet With Some Formatting
03:46
Adding Formulas To Total Rows And Columns
05:19
Adding Formulas The Quick Way
02:13
Working Out Our Average Consumption
03:40
Conditional Formatting To Improve Presentation
04:03
Renaming Sheets And Printing
05:26
Section 3: Using Excel For A Profit And Loss
Creating The Data Collection Sheet
03:27
Setting Up A List Using A Named Range
06:00
Adding Formula To Create January Profit And Loss
09:13
Changing The Data Entry To A Single Sheet
08:10
Creating The Other Eleven Months
05:15
Using 3D Referencing To Generate The Whole Years Profit And Loss
07:29
Exporting To PDF And Emailing To The Accountant
02:31
Section 4: Score Sheets For School Sports Day
Setting Up The Scoresheet Structure
06:49
Looking Up The Competitor Name
07:51
A Near Match Lookup For The Event Scores
06:30
Using Sheet Replication To Create The Other Event Sheets
09:12
Adding Protection To Protect Your Formula
08:22
Data Entering The Actual Results
02:28
Completing The Competitor Summary
09:05
Creating An Error Check For Events Competed
04:11
Adding Up The Scores And Ranking For Position
04:26
Section 5: Expenses Claim Form
Expenses Claim Document Setup And Header Page
05:54
Adding The First Month
04:31
Displaying The Month Name Instead Of The Number
03:03
Creating Destination Lookups For January
11:22
Protecting January And Setting Print Options
04:26
Creating The Other Eleven Months
06:10
Adding A Summary Sheet
05:20
Using And Submitting Your Expenses Claim
03:02
Section 6: Sales Contacts Management
Setting Up Excel To Store Data And Entering That Data
06:17
Creating A Unique ID And Freezing Titles
06:38
Calculating New Values Using String Manipulation
07:41
Sorting Your Excel Database
05:18
Filtering Your Dataset
05:55
Removing Duplicate Records From Your Dataset
03:03
Mail Merge Using Your Dataset
07:28
Form View In Excel
06:05
Summarizing The Dataset With Pie Charts
11:28
Section 7: Stock Sales Summaries
Starting The Sales Data Record Sheet
06:08
Adding A Sales Chart To The Data
06:19
Replicate Sheets To Create Other Sales Regions
03:49
Summarizing The Sales Data
11:09
Importing CSV Format Sales Data
04:17
Adding Some Calculations To The Imported Data
01:53
Interrogating The Sales Data With A Pivot Table
09:32
Formatting The Pivot Table
05:56
Sorting And Filtering The Pivot Table
05:57
Section 8: Next Steps
Reviewing Absolute And Relative Formulas
09:30
What Is The SkyDrive?
05:46
Saving An Excel File To SkyDrive
03:39
Informing Others That The SkyDrive Document Is There
02:18
Excel 2011 Summary
01:52
What Is Next?
04:49

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course