Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Apple Numbers: Complete Basic to Pro Guide For Mac Numbers

Name: Apple Numbers: Complete Basic to Pro Guide For Mac Numbers
Rating: 4.2 (179 reviews)

With Apple Mac Numbers build spreadsheets, perform calculations, create charts and design forms with practical examples.

Created byBeing Commerce, Being Commerce

Last updated 1/2026

English

English [Auto],

What you'll learn

Create and manage documents, sheets, and tables
Understand cells, rows, columns, and headers properly
Apply basic to advanced formulas
Use relative and absolute formulas
Implement functions (IF, COUNTIF, LOOKUP, AND/OR, TEXT, etc.)
Use footers and structured calculations
Create sorting and filtering systems
Work with multiple tables efficiently
Design clean spreadsheets with layout and formatting
Add shapes, text boxes, and images for clarity
Apply cell background, borders, and conditional highlights
Build charts (Pie, Column, Multi-column)
Create professional reports & practical templates
Export Excel and share files professionally
Creating Multi-sheets projects and linking different sheets in your file.
Working with Shapes and Media.
Work with new Numbers features & updates
and much more.

Course content

11 sections • 51 lectures • 5h 13m total length

Apple Numbers: Complete Basic to Pro Guide For Mac Numbers2:54
Discover how to use Apple Numbers on Mac from scratch to pro, building spreadsheets, creating charts and tables, applying functions, calculating mortgage payments, and mastering checkboxes and 3D visuals.
Watch This Before Learning Course1:32
Adjust your learning pace by changing the video playback speed in the player settings, slowing down or speeding up as needed, and use the Q&A for questions.
Download Premium Resources1:48
Download the provided zip file containing all course materials, then unzip it on Windows or Mac to access the materials and assignments for practical learning and in‑course practice.
Introduction to Apple Numbers2:25
Open the Numbers spreadsheet app from Launchpad or App Store, choose a template or start from scratch, and save your work. Browse templates by category and open files.
Documents, Sheet & Tables2:43
Numbers uses documents, sheets, and tables to organize data, enabling unlimited sheets and multiple tables per sheet. Create, rename, delete, and arrange tables and a chart to visualize information.
Everything About Cell4:42
Explore how cells form tables, with columns and rows, each cell has a unique address like c7, and navigate and edit using keyboard arrows, tab, and enter.
Tables in More In-depth3:35
Master adding, deleting, and resizing rows and columns in tables, including dragging to move, using arrows to adjust width, and editing data in Numbers.
Column & Rows2:10
Shows how to insert and add rows and columns in Apple Numbers, using arrows to place before or after and fill data to extend the table.
Titles & Headers2:12
Learn to work with Apple Numbers by renaming labels and sheets for January and February, adjusting headers and footers, adding photos, and entering name and amount to generate totals.
Special Cell Formats7:57
Learn how to apply special cell formats in Apple Numbers, including date and time, currency, popup menu data formats, stepper controls, star ratings, and minimum and maximum values.
Basic Formulas in Numbers4:24
Learn to use basic formulas in Numbers to add, subtract, and multiply with cell references, using the equals sign and auto cell addresses for quick calculations.
Practical Examples 1: Expenses Report8:32
Create and format an expenses report in Apple Numbers by building a salary ledger, configuring dates, names, and costs, applying currencies, and summing totals with multiple formula methods.

Relative Formula Implementation3:05
Master relative formulas in Apple Numbers by copying and pasting formulas across cells, letting references like B3+C3 adjust automatically to new locations and simplify complex calculations.
Absolute Formula Implementation3:48
Learn how to implement absolute cell references in Numbers formulas, fix a cell with dollar signs, and copy formulas across columns while preserving a chosen value for reliable calculations.
Using Formula Fuctions4:11
Learn how to use formula functions in Apple Numbers to sum ranges, compute averages, and apply a variety of functions to manage and update your spreadsheets.
Calculations Using Footers2:27
Learn to create and distinguish footers and headers in tables, write formulas that sum across a range, and have totals update automatically as you edit the amount column.
Practical Examples 2: Checkbook Report9:46
Create a practical checkbook in Apple Numbers using a basic template to track deposits, expenses, and balance with a simple formula. Format dates and currency, columns, and copy the formula.

Sorting rows4:00
learn how to sort rows in apple numbers, using ascending and descending orders, choosing columns like column c, and sorting the entire table or selected rows.
Filtering rows2:55
Use filters in Apple Numbers to filter rows by text rules, show only Apple data, and toggle filters off to reveal all data.
Count IF function2:34
Explore how to use the countif function in Apple Numbers to count how many times a specific text, like Apple, appears within a data range, including range and criteria examples.
Multiples tables3:14
Master cross-table calculations in Apple Numbers by creating and rearranging multiple tables, summing across sheets with equals and plus, and referencing cells like B2 and B3.
Practical Examples 3: Mortgage Report9:15
Demonstrate mortgage reporting with a Numbers calculator template. Calculate a $20,000 loan over 10 years at 5% rate to derive monthly payments and total interest using the BMB function.
Practical Examples 4: Personal Review11:36
Apply the Numbers basics to a car review spreadsheet: set column formats, convert text to numbers, choose dates, and use pop-up menus, filters, sorts, and hides.

Borders3:08
Learn to work with borders in Numbers, adjusting horizontal and vertical grid lines, applying outlines and inside borders, and changing color, style, and size to customize cell edges.
Cell Background4:18
Learn to color and style cells in Apple Numbers: set cell background, apply gradients and text colors, and build templates to design attractive, organized spreadsheets.
Conditional Highlights4:01
Learn to set up conditional highlights in Numbers by creating rules like greater than five, between one and four, and less than five, applying colors automatically to visualize data.

Creating Charts2:38
Create a chart in Numbers by selecting your data and a chart type, then watch the chart automatically reflect the table values.
Chart Settings4:46
Explore chart settings in Numbers, adjusting size, colors, fonts, borders, and gradients, while configuring axis labels, legends, major rail lines, minor rail lines, and live updates.
Multi Column Charts3:10
Learn to create and customize multi column charts in Apple Numbers, including switching between 2D and 3D interactive views, deleting unused columns, and adjusting colors and data to compare sales.
Pie charts2:57
Learn to create and customize a pie chart in Apple Numbers, including data entry, choosing chart styles, 3-D options, label positioning, data display, and rotating the chart.

Adding Shapes5:23
Learn how to add and customize shapes in Apple Numbers, using fill, gradients, borders, shadows, reflections, and text with bullets or numbering inside shapes to enhance spreadsheets and presentations.
Text Boxes2:42
Learn to create and customize text boxes in Apple Numbers, apply fills and borders, adjust text color and size, and add links to websites or emails.
Adding Images2:53
Explore how to insert and edit images in Numbers, using media options, logos, resizing, borders, reflections, exposure, and placing images inside spreadsheets for attractive presentations.
Layout & Design2:09
Explore layout and design features in Apple Numbers, including printing options, page setup, adding page numbers, adjusting spacing, inserting charts and tables, and exporting as PDF.
Practical Examples 5: Product Sheet6:55
Design a copper water product sheet in Apple Numbers by adding an image, renaming the sheet, and detailing purity 100 percent copper, health benefits, pricing, discounts, and print-ready layout templates.

IF Statement Function2:07
AND / OR Function2:33
Explore and, or, and if functions in Apple Numbers, building logical expressions that compare column values to determine true results and generate conditional outcomes.
Duration Sheet2:51
Learn to compute duration between dates in a spreadsheet, measure day differences, and format results in units like days, weeks, hours, and minutes in Apple Numbers.
Practical Examples 6: Due Date7:06
Master practical date management in Apple Numbers by calculating due dates, highlighting overdue tasks, filtering by today and upcoming dates, and using formulas to hide or reveal data.
Lookup Function3:05
Learn how to use the lookup function in Apple Numbers to fetch item prices from another table and calculate totals by linking item, quantity, and currency.
Text Function4:40
Master text functions in Apple Numbers to combine words, insert spaces, and use substitute and other functions to manipulate strings across cells.

Merge Cell & Word Wrap4:17
Learn how to merge cells, wrap text, center align, and format text in Numbers, including applying color, italics, underline, and adjusting row height and headers.
Exporting Excel3:15
Export your Numbers spreadsheets to PDF, Excel, or Numbers, choose advanced format options, and share a copy via mail or AirDrop.
Practical Examples 7: Sale Sheet16:17
Explore building a sales sheet in Numbers by mapping monthly product ABCD data to charts, comparing performance, and customizing 2D/3D line and pie charts with labels, axes, and formatting.

New Feature - Functions6:47
Explore the advanced stock and currency functions in Apple Numbers, including retrieving stock prices, market cap, and currency conversions, and build dynamic portfolios with symbols and charts.
New Feature - Collobrate0:34
Learn how to use the collaborate feature to share a Numbers sheet via iCloud.com, inviting team members to access and edit in real time.
New Feature - Charts0:59
Explore the new charts feature in Apple Numbers 6.1 (2018), including customizing chart titles by centering or aligning to the top right and adjusting title position within charts.
Watch Free Courses From Here9:36
Discover free and paid courses on Kuku courses, filter free courses, and enroll to access lectures without signup, with flexible payment options and ongoing updates.

Clean, Optimize and Secure your Mac36:46
Learn to clean, optimize, and secure your Mac with CleanMyMac: scan for junk, caches, and malware, reclaim space, manage apps, remove duplicates, and explore cloud cleanup options.
Run Microsoft Windows on MacOS1:05:43
Learn to run Windows on Mac with Parallels Desktop, install and activate Windows 11, and switch between coherence view, window, and full-screen views for gaming and productivity.

Requirements

Nothing required, everything taught inside this course from scratch to advance
They should have Numbers version 3.6 or newer installed on their Mac from the Mac App Store.
A Mac with Apple Numbers installed
Willingness to learn and practice with examples

Description

Apple Numbers is far more powerful than most people realize — yet many Mac users only scratch the surface. If you’ve struggled to create professional spreadsheets, organize data, build reports, automate formulas, or present visually appealing sheets, this course was built for you.

This Complete Basic to Pro Guide for Apple Numbers transforms you from a casual user into a confident spreadsheet creator who can solve real problems — budget tracking, sales reports, invoices, personal planning, financial analysis, checklists, and more. You’ll master everything from the fundamentals to advanced formulas, charts, formatting, multi-table setup, spreadsheet design, collaboration, and exporting.

Each concept is taught with real practical examples — expense reports, mortgage sheets, checkbook tracking, sales sheets, due date tracking, personal review sheets, and much more. You won’t just learn Numbers; you’ll learn how to think like a spreadsheet professional and use Numbers as a productivity tool for work, studies, and everyday life.

By the end of the course, you’ll be able to:
• Build professional spreadsheets from scratch
• Use both basic and advanced formulas with confidence
• Organize data with sorting, filtering, and multi-table setups
• Create visually clean and professional designs
• Use conditional formatting and highlight key insights
• Build clear dashboards with charts and summaries
• Export and share files efficiently for clients, teams, or managers

If you avoid Apple Numbers because it feels complex — or have been doing things manually for too long — this course will unlock a completely new workflow for you. You will save time, work smarter, and build spreadsheets that look professional and function smoothly.

What you’ll miss if you don’t join:
– A complete structured system from basic to pro-level
– Real-world case studies you can use instantly
– Skills that can improve your personal finances and professional reputation
– Smart tricks that make work easier but are rarely known
– The confidence to handle Apple Numbers in any situation

This course was designed carefully to be beginner-friendly yet professional enough for SMB owners, freelancers, office workers, students, and business professionals. All lessons are clear, to the point, and actionable. Once you complete it — you’ll never look at Apple Numbers the same way again.

Who this course is for:

Mac users who want to master Apple Numbers
Students & professionals needing spreadsheets for work
Business owners or freelancers managing finances
Anyone tracking budget, sales, or planning data

Apple Numbers: Complete Basic to Pro Guide For Mac Numbers

What you'll learn

Explore related topics

Course content

Introduction to Apple Numbers Basics12 lectures • 45min

Formulas Using: Tips & Trick5 lectures • 23min

Sorting, Filtering & Multiple Tables6 lectures • 34min

Cell Orders & Colour Background3 lectures • 11min

Creating Charts in Numbers4 lectures • 14min

Designing Spreadsheets5 lectures • 20min

Complex Formula6 lectures • 22min

Exporting & Advanced Topics3 lectures • 24min

Updates in Numbers4 lectures • 18min

Must for Every Apple Users2 lectures • 1hr 42min

Requirements

Description

Who this course is for: