Microsoft Excel for Mac 2011 - Beginning

Learn how to confidently create worksheets, use formatting, calculations, functions, analyze, filter, charts & tables.
4.7 (15 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.
225 students enrolled
$25
Take This Course
  • Lectures 62
  • Contents Video: 4 hours
    Other: 1 min
  • Skill Level Beginner Level
  • 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 4/2014 English

Course Description

This course is taught by a professional corporate trainer in a friendly, step by step method so that you can follow along and do the steps with the instructor. If you prefer to watch and listen, that works great too!

This course is designed to give you complete confidence in your knowledge of Excel. You will learn core features that you will use and build on throughout the course as we increase our knowledge of key features.

We start with a blank workbook and will build out multiple sheets from entering values to calculations and functions, all the way to building charts and updating data series.

This course is titled Beginning Excel but actually covers intermediate topics, too!

Can you answer these questions?

1. What is the difference between workbooks, spreadsheets, templates, sheets, file?

2. What is the difference between labels and values and why is that important?

3. Can you confidently use and modify calculations and average, sum, min and max formulas?

5. When should you convert your data to a table range and what are the pro's and con's?

6. How do I sort and filter my data by multiple criteria?

7. How do I add a series to a data range and have a chart automatically update?

If you answered "no" to any of these questions, then this course is for you!

We will answer all of these questions and much more!

Come on in and join us! We look forward to having you!

What are the requirements?

  • Basic Computer Skills - scrolling, clicking, pointing
  • This course is based on Excel for Mac 2011. However all of these features exist in Windows based versions of Excel, too. The commands may be in slightly different locations.
  • It is best if you have Excel installed on your computer if you desire to follow along step by step but this is not required. Many people like to just watch.

What am I going to get from this course?

  • By the end of the course, you will be a confident Excel user.
  • You will have the skills to say "I know how to use Excel" to any employer.
  • Not only will you will be able to create and modify worksheets. You will be able to analyze and filter your data and create charts and graphs.
  • Although this course is titled as a beginning level course, it really covers many intermediate level topics.
  • This vs. That. We cover several features that are commonly confused because they have similar functionality (and names). We will distinguish the features and learn when you should use one feature instead of the other.
  • This course will give a solid understanding of key concepts in Excel.
  • Lean Tips & Tricks all Along the Way!
  • Build Worksheets from Scratch
  • Edit and Modify Worksheets
  • Format worksheets
  • Understand Print Options
  • Work with Data Ranges
  • Sort, Filter, Analyze Data
  • Build & Edit Chart Data

What is the target audience?

  • This course is excellent for someone brand new to Excel, newer to Excel or someone who has used Excel for a while but is not confident with the many program features.
  • Users new to Excel
  • Users newer to Excel
  • Excel users that have used a limited number of features
  • Excel users that have used Excel but are not confident with the many program features
  • Haven't used Excel in a while and need a refresher course
  • Have used Excel for Windows and want to have a solid understanding of Excel for Mac
  • Anyone who wants to confirm their knowledge of Excel before jumping into additional features such as pivot tables & extensive formulas

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: Course Introduction
Course Certificate
00:55
Section 2: Excel Fundamentals
Launching Excel for Mac 2011
01:03
Adding Excel Icon to your Dock
01:41
Overview of the Excel Program Screen
05:00
Contextual Tabs
02:17
Navigating a Worksheet & Keyboard Tips
03:54
A Bit of Excel Terminology: Workbook vs Worksheet vs Spreadsheet vs File
02:00
Create, Open & Close a Workbook
02:39
Section 3: Getting Started with Worksheets
Entering & Editing Labels and Values
05:20
Entering Data Automatically - Tip
04:01
Saving Your Workbook, Save vs Save as...
Preview
05:18
Selecting a Cell Range and Entering Data - Tip
03:03
Entering Data in a Cell Range - Tip 2
01:38
Entering Data: Labels vs Values (convert a number to text)
01:53
Entering and Formatting Dates
02:46
Section 4: Getting Started with Formulas & Functions
Functions & Formulas Introduction. Sum Function.
Preview
04:13
Sum Function. Editing the Formula.
03:11
Sum Function. Copying the Formula.
04:08
Math Operators: Additions, Subtraction, Multiplication, Division
04:35
Formulas: Absolute vs. Relative Reference
08:12
Formula Ribbon
02:06
Formulas: Average, Min, Max
04:23
Section 5: Editing a Worksheet
Moving and Copying Cell Contents
04:36
Copying Cell Contents to a New Sheet
03:33
Paste Menu Options
01:41
Section 6: Formatting a Worksheet
Formatting Options
04:38
Format and Merge Cells
04:51
Why Format Options on Ribbon are Different
00:58
Number Formatting Overview
05:57
Number Formatting: Currency
04:35
Clear Formatting vs Clear Contents
03:20
Adjusting Column Widths
06:10
Adjusting Row Height
03:42
Alignment: Top, Bottom, Wrap Text
05:27
Insert Rows
05:07
Delete Rows
02:38
Inserting and Deleting Columns
04:41
Adding Cell Borders
05:19
Copy Formatting using Format Painter
Preview
02:17
Print & Print Preview
09:12
Section 7: Working with Charts
Creating Charts
11:02
Printing Charts
02:36
Updating Data in Charts
01:11
Copying and Moving Charts
05:20
Copying Charts
05:20
37Adding A Chart Series
03:16
Section 8: Sorting Data
Download PB Travel Sales Report Training.xlsx File
Preview
Article
Sorting Your Data
03:58
Sorting a Selected Range vs Automated Sorting
03:56
Sorting Outside of a Range
01:41
Sorting a selected Range
04:15
Sort by Multiple Criteria
03:17
Section 9: Filtering Data
Filtering Data
03:53
Filter by Number
05:15
Section 10: Introduction to Tables
Introduction To Tables (Tables vs Filtering)
03:58
Table Features
02:15
Section 11: Working with Multiple Worksheets
Creating, Copying and Naming Worksheets
03:22
Moving and Navigating between Worksheets
02:17
Deleting Worksheets and Changing Tab Color
01:22
Printing Multiple Worksheets
02:16
Section 12: Working with Images
Inserting and Formatting Images
06:12
Section 13: Course Certificate
Course Certificate & Feedback
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Francie Black, eWisdomToGo, Technology Consulting, Writing & Training

Francie has a twenty year progression through technology, training, project management, software development, and IT management.

You can see Francie on ABC TV News' weekly "App Chat" segment as the featured tech expert.

Francie helped start the computer training department for a Fortune 100 company and has written and taught computer training courses for beginning - advanced levels of Microsoft Word, Microsoft Excel, PowerPoint, FileMaker Pro, HTML Programming, UNIX, iPad, iOS7 and many other topics including custom applications.

Her written materials have been used by thousands of corporate employees and she has taught thousands of students worldwide in instructor led and online webinar training sessions.

As a technology consultant, some of the largest companies in America have contracted with Francie to present and train employees on a wide variety of technical topics.

Francie is bringing her training experience to a larger audience as a new instructor with Udemy. She has started her Udemy courses with beginning Excel and will be offering many more topics.

Here friendly, step by step, instruction will give you the solid knowledge you need!

Francie has a business degree from UNC Charlotte and an MBA from Pepperdine University in Malibu, CA.

Come on in and join the course! We're so happy to have you!

Ready to start learning?
Take This Course