Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Blender
30-Day Money-Back Guarantee

This course includes:

  • 4.5 hours on-demand video
  • 1 article
  • 11 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Apple Numbers For Mac

Mac Numbers: Creating and Using Spreadsheets On Your Mac

Build spreadsheets, perform calculations, create charts and design forms with practical examples.
Bestseller
Rating: 4.5 out of 54.5 (1,077 ratings)
3,939 students
Created by MacMost & Gary Rosenzweig
Last updated 9/2018
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Create single and multi-table spreadsheets in Numbers
  • Use formulas to perform calculations
  • Create simple lists of records as spreadsheets
  • Create charts from spreadsheet data
  • Manipulate spreadsheet elements to create forms and data sheets
  • Use logical function in spreadsheets
  • Export and share spreadsheets
Curated for the Udemy for Business collection

Requirements

  • Students should have a basic familiarity with using Macs, including the mouse, keyboard, drag-and-drop, and managing files. They should have Numbers 3.6 or newer installed on their Mac from the Mac App Store.

Description

Mac Numbers is a complete course with 36 lessons and 11 practical examples taking you from beginner to advanced level. It includes three and a half hours of video tutorials and 11 example files.

This course starts at the beginning, teaching you the basics such as creating a new document, starting with the blank template, entering numbers and performing basic calculations. You’ll then move on to create multi-table spreadsheets, perform advanced calculations, sort and filter data, create charts and more.

Whether you need to use Numbers for work, school, or a project at home, this course can get you up to speed fast. It does not assume that you have previous spreadsheet experience. However, if you have used an application like Excel in the past, you can also use this course to quickly learn the ins-and-outs of Numbers.

Who this course is for:

  • This course will teach you the basics and many advanced techniques for creating and using spreadsheets with Numbers on your Mac. If you want to use Numbers at home or work but have no previous spreadsheet experience, this course starts at the beginning. If you have used other spreadsheet apps like Excel, this could can help you switch to Numbers.

Featured review

John Van Uitregt
John Van Uitregt
36 courses
5 reviews
Rating: 5.0 out of 512 months ago
Exceptionally well done. Gary's style fits my brain, and he reveals all the little time-saving tricks inherent with the apple way of doing things. My spreadsheet game has seen a big improvement - just from this course. So I signed up for more.

Course content

9 sections • 54 lectures • 4h 20m total length

  • Preview00:52
  • Preview02:55
  • Preview01:23
  • Documents, Sheets, Tables, and Cells
    01:39
  • Cells
    02:11
  • Tables
    02:31
  • Preview01:34
  • Titles and Headers
    01:43
  • Special Cell Formats
    04:38
  • Preview02:25
  • Example 1: Business Trip Expenses
    09:32

  • Relative Formula References
    02:12
  • Absolute Formula References
    02:41
  • Formula Functions
    03:49
  • Footers
    02:53
  • Example 2: Simple Checkbook
    12:27

  • Sorting Rows
    03:47
  • Filtering Rows
    02:35
  • Using the COUNTIF Function
    01:47
  • Multiple Tables
    02:36
  • Example 3: Mortgage Extra Payment Calculator
    15:38
  • Example 4: Personal Book Inventory
    14:04

  • Borders
    04:13
  • Cell Backgrounds
    02:29
  • Conditional Highlighting
    02:38
  • Example 5: Student Grade Tracker
    18:43

  • Creating Charts
    01:46
  • Chart Settings
    03:11
  • Multi-Column Charts
    02:11
  • Pie Charts
    02:27
  • Example 6: Sales Charts
    07:38

  • Adding Shapes
    04:00
  • Text Boxes
    02:03
  • Adding Images
    02:47
  • Layout and Design
    03:25
  • Example 7: Product Sheets
    09:47
  • Example 8: Football Squares
    09:14

  • IF Statements
    01:47
  • AND, OR, NOT
    01:58
  • Durations
    01:58
  • Example 9: Due Dates
    07:35
  • The LOOKUP Function
    02:49
  • The INDIRECT Function
    04:35
  • Text Functions
    03:05
  • Example 10: Chore Chart
    10:15

  • Merging Cells and Wrapping
    03:52
  • Exporting
    02:34
  • Using iCloud to Share Numbers Documents
    03:32
  • Example 11: Physics Experiment
    13:39
  • Another Look at AND, OR, NOT
    08:24

  • New Features in Numbers 4.1
    07:24
  • Collaboration
    03:49
  • New Features in Numbers 5.0
    04:58
  • Smart Categories (Pivot Tables) in Numbers 5.2
    05:56

Instructor

MacMost & Gary Rosenzweig
MacMost, WP Tips and Hacks, Computer book author, Developer
MacMost & Gary Rosenzweig
  • 4.5 Instructor Rating
  • 7,238 Reviews
  • 41,769 Students
  • 18 Courses

Gary Rosenzweig is an Internet entrepreneur, software developer, and technology writer. He runs CleverMedia, Inc., which produces websites, computer games, apps, and podcasts.

Gary is the host and producer of MacMost, a site that features more than 1,000 video tutorials for Apple enthusiasts. It includes many videos on using Macs, iPhones, and iPads. Gary has written more than 30 mass-market computer books, including the best-selling book My iPad, The MacMost Guide to Switching to the Mac, My Pages, ActionScript 3.0 Game Programming University, and Special Edition Using Director MX. He also has self-published titles such as 101 Mac Tips and The Practical Guide to Mac Security.

Gary is also the creator and producer behind WP Tips And Hacks, a site with video tutorials and code examples to help WordPress users customize and modify their WordPress sites.

Gary has a computer science degree from Drexel University and a master’s degree in journalism from the University of North Carolina at Chapel Hill.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.