Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Numbers For Mac: Be Like Pro in Apple Numbers or Mac Numbers
Rating: 4.2 out of 5(81 ratings)
254 students

Numbers For Mac: Be Like Pro in Apple Numbers or Mac Numbers

Build spreadsheets, perform calculations, create charts and design forms with practical examples with Apple Mac Numbers.
Last updated 1/2026
English
English [Auto],

What you'll learn

  • Create professional spreadsheets using Apple Numbers from scratch
  • Use tables, rows, headers, cell formatting, and sheet organization
  • Apply formulas and functions for automated calculations
  • Use relative and absolute references
  • Perform sorting, filtering, and analysis on large data sets
  • Build charts: pie, bar, line, and multi-column charts
  • Use conditional highlighting for data visualization
  • Design sheets with text boxes, images, and layout customization
  • Apply advanced formulas like IF, AND, OR, LOOKUP, TEXT, and Date functions
  • Build real-world projects: expense reports, sales dashboards, mortgage trackers, product sheets, and more
  • Working with spreadsheets,tables,cells etc.
  • Data manipulation, presentation and formatting.
  • Numbers interface and important terminologies regarding spreadsheets.
  • Creating Multi-sheets projects and linking different sheets in your file.
  • Performing basic and advance calculations using simple and complex formulas like IF ,COUNT & COUNTA,COUNTIF & COUNTIFS, SUM, SUMIF & SUMIFS etc.
  • Export, share, and collaborate using Numbers
  • Use new and latest features like collaboration, advanced charts, and updated functions
  • Much more.

Course content

3 sections24 lectures5h 13m total length
  • Numbers For Mac: Be Like Pro in Apple Numbers or Mac Numbers2:54

    Learn Numbers for Mac from scratch to advanced, building spreadsheets, reports, and charts. Master tables, 3D forms, calculations, and features like checkboxes and mortgage math with practical, step-by-step guidance.

  • Watch This Before Learning Course1:32

    Adjust the lecture speed with the player settings to slow down or speed up the video for easier learning. Use the Q&A to ask questions and get answers.

  • Download Premium Resources1:48

    Download the Mac numbers zip file, unzip it, and access all materials and assignments for practical learning.

  • Introduction to Apple Numbers Basics30:11

    Learn how to open Apple Numbers, choose templates, create documents and sheets, work with tables and cells, use cell addresses in basic formulas, and format currency and dates.

  • Practical Examples 1: Expenses Report8:32

    Create a practical numbers spreadsheet for an expenses report, entering dates, names, and costs, formatting currency, and calculating totals with multiple sum methods.

  • Formulas Using: Tips & Trick13:32

    Master how to use formulas in Numbers for Mac, from relative and absolute references to copy-pasting formulas, and apply sum and average functions for dynamic, auto-updating results.

  • Practical Examples 2: Checkbook Report9:46

    Learn to build a practical checkbook in Numbers using a basic template with deposits, expenses, and a dynamic balance. Explore date and currency formatting, and copying formulas for automatic updates.

  • Sorting, Filtering & Multiple Tables12:44

    Master sorting and filtering in Mac Numbers, learn to sort by column and entire tables in ascending or descending order, and apply filters with rules across multiple tables and sheets.

  • Practical Examples 3: Mortgage Report9:15

    Learn to use a mortgage calculator template to compute monthly payments, total cost, and interest on a $20,000 loan over 10 years at 5%, using Numbers' PMT function.

  • Practical Examples 4: Personal Review11:36

    Apply practical techniques in a sample spreadsheet to format text as numbers, adjust dates, use pop up menus, apply filters and sorts, and create basic counts with formulas.

  • Cell Orders & Colour Background11:28

    Master cell formatting in Numbers for Mac by adjusting borders, fill colors and gradients, creating templates, and using conditional highlights with rules like greater than, between, and less than.

  • Creating Charts in Numbers13:32

    Learn to create and customize charts in Numbers, using quick data selection, choose 2D or 3D styles, adjust colors, labels, axes, and interactive options to visualize sales data.

  • Designing Spreadsheets13:08

    design spreadsheets in numbers for mac using shapes, text formatting, gradients, borders, shadows, reflections, and images; add bullets or numbers and insert links.

  • Practical Examples 5: Product Sheet6:55

    Create a copper water product sheet in mac numbers, adding an image, specifications, and pricing with discounts and total-calculation formulas, then preview the print layout.

  • Complex Formula A7:32

    Learn to use the if function and logical operators in numbers, exploring true/false results, and apply duration and date difference calculations with different formats.

  • Practical Examples 6: Due Date7:06

    Manage due dates in Numbers by creating a to-do list, marking overdue tasks, filtering based on due dates, and using formulas to compute days past or remaining.

  • Complex Formula B7:46

    Apply the lookup function in Numbers to pull item prices from another table, calculate totals with quantity, format currency, and explore text and concatenation functions.

  • Exporting & Advanced Topics7:32

    Merge and center text, wrap lines, and apply formatting to present data clearly; export to PDF, Excel, or video, then share via mail or AirDrop.

  • Practical Examples 7: Sale Sheet16:17

    Learn to build a sale sheet in Numbers for Mac by analyzing monthly sales of products ABCD using field charts, and compare performance with multiple charts and formatting options.

  • Updates in Numbers8:20

    Explore updated stock and currency functions in numbers, including symbol handling, market cap, and current price, plus chart enhancements and iCloud collaboration features.

  • Watch Free Courses From Here9:36

    Discover free and paid courses on Kuku courses, access plenty of tutorials via direct URL, start learning instantly with no signup, and explore paid membership options and regional payment support.

Requirements

  • They should have Numbers version 3.6 or newer installed on their Mac from the Mac App Store.
  • Nothing required, everything taught inside this course from scratch to advance

Description

Apple Numbers is one of the most powerful yet underrated spreadsheet applications available for Mac users. Whether you're a student, business owner, freelancer, or professional, mastering Apple Numbers can help you analyze data, build beautiful reports, automate calculations, and make smarter decisions—all without switching to complex tools.

This complete guide takes you from beginner to advanced, step-by-step. You’ll start with the basics: navigating the Numbers interface, creating sheets, formatting tables, understanding cells, rows, and columns. As you build confidence, we’ll progress into formulas, functions, calculations, sorting, filtering, chart creation, designing spreadsheets, and advanced automation features. You will also work on real-world practical examples like expense reports, mortgage trackers, sales sheets, project timelines, checkbook reports, and more.

You won’t just learn how Numbers works — you’ll learn how to use it like a professional. You’ll learn how to organize information, build dashboards, apply conditional formatting, create interactive charts, perform complex calculations, and export your work professionally for presentations, business use, or sharing.

By the end of the course, you'll be able to confidently build any spreadsheet you need — from financial models to school projects, from sales trackers to beautiful visual reports. You’ll also learn the latest features like collaboration tools, chart upgrades, and new functions recently added to Numbers.

Imagine being able to:

  • Build professionally designed sheets for clients, teams, or business use.

  • Automate repetitive calculations using formulas and functions.

  • Track budgets, manage expenses, and analyze finances visually.

  • Create elegant charts to present performance reports and trends.

  • Share well-designed spreadsheets that impress your manager, clients, or peers.

  • Use Apple Numbers as more than just a basic spreadsheet—it becomes your data assistant.

Many learners struggle with spreadsheet tools because they seem complicated or time-consuming. But Numbers is built for simplicity and visual clarity—when you know what to do. That’s what this course solves. You’ll gain hands-on skills with practical examples so you can immediately apply what you learn.

If you skip this course, you may continue wasting time manually tracking numbers, making formatting mistakes, or depending on others for spreadsheet work. You’ll miss the opportunity to leverage Numbers' full potential for productivity, reporting, and automation.

But if you join this course, you’ll gain real confidence, practical skills, and the ability to build, analyze, and present data beautifully—using Apple’s own powerful spreadsheet platform.

Who this course is for:

  • Mac users wanting to master Apple Numbers
  • Students, teachers, freelancers, and professionals needing spreadsheet skills
  • Small business owners tracking finances, sales, or inventory
  • Anyone using Numbers for personal or professional data management
  • Beginners wanting a step-by-step practical learning approach