Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Apple Numbers: Complete Basic to Pro Guide For Mac Numbers

person icon Being Commerce

4.7

Apple Numbers: Complete Basic to Pro Guide For Mac Numbers

Build spreadsheets, perform calculations, create charts and design forms with practical examples

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Being Commerce

English [CC]

category icon Office Productivity,Apple,Numbers of Mac

Lectures -46

Resources -1

Duration -3 hours

Lifetime Access

4.7

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Welcome to this course, Apple Numbers: Complete Basic to Pro Guide For Mac Numbers

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

This course starts at the start, teaching you the fundamentals like creating a replacement document, starting with the blank template, entering numbers and performing basic calculations. You’ll then advance to make multi-table spreadsheets, perform advanced calculations, sort and filter data, create charts and more.

Whether you would like to use Numbers for work, school, or a project reception, this course can get you up to hurry fast. It doesn't assume that you simply have previous spreadsheet experience. However, if you've used an application like Excel in the past, you'll also use this course to quickly learn the ins and outs of Numbers.

“Mac Numbers - A Journey from Beginners to Advanced Level” may be a comprehensive course designed to require you from beginners to advanced level when it involves working with spreadsheet applications like Numbers in Mac.

This video series will start right from the basics like the Numbers interface, creating new documents using templates, entering data, Worksheets, Tables, and Cells and gradually moving towards advanced features like working with 2D and 3D charts, interactive spreadsheets, simple, complex and custom formulas. Linking spreadsheets etc.

you will also learn skills for Data analysis and custom filtering which can greatly set you aside from other users of numbers. 

Throughout the course, you'll learn shortcuts for the foremost common task that you have to perform repeatedly. I even have also added some neat tricks and tips that can enhance your productivity.

The course is split into sections and every section covers one broad area which can gradually build up your skills over time. I even have recorded short videos which can cover one, or at max two, concepts, to facilitate focused learning during this series

I have used small examples throughout the course to show the concepts that you'll find helpful. 

This course is ideal for all those who want to find out about spreadsheet applications for his or her work, school or home projects. No prior knowledge about any spreadsheet application is required on your part. the sole thing required is the desire and willingness to find out Numbers.

Goals

  • Basic to Advance everything about Apple Numbers or Mac Numbers

  • Use formulas to perform calculations

  • Building interactive sheets using pop-up menu, checkboxes, star ratings etc.

  • Create simple lists of records as spreadsheets

  • Create single and multi-table spreadsheets in Numbers

  • Create charts from spreadsheet data

  • Working with 2D,3D and interactive charts to present data.

  • Use logical functions in spreadsheets

  • Manipulate spreadsheet elements to create forms and data sheets

  • Working with spreadsheets, tables, cells etc.

  • Export and share spreadsheets

  • Numbers interface and important terminologies regarding spreadsheets.

  • Data manipulation, presentation and formatting.

  • Performing basic and advanced calculations using simple and complex formulas like IF, COUNT & COUNTA, COUNTIF & COUNTIFS, SUM, SUMIF & SUMIFS etc.

  • Creating Multi-sheets projects and linking different sheets in your file.

  • Working with Shapes and Media.

  • Much more.

Prerequisites

  • Nothing is required, everything taught in this course is from scratch to advance.

  • They should have Numbers version 3.6 or newer installed on their Mac from the Mac App Store.

Apple Numbers: Complete Basic to Pro Guide For Mac Numbers

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

1 Lectures
  • play icon Introduction 02:54 02:54

Introduction to Apple Numbers Basics

10 Lectures
Tutorialspoint

Formulas Using: Tips & Trick

5 Lectures
Tutorialspoint

Sorting, Filtering & Multiple Tables

6 Lectures
Tutorialspoint

Cell Orders & Colour Background

3 Lectures
Tutorialspoint

Creating Charts in Numbers

4 Lectures
Tutorialspoint

Designing Spreadsheets

5 Lectures
Tutorialspoint

Complex Formula

6 Lectures
Tutorialspoint

Exporting & Advanced Topics

3 Lectures
Tutorialspoint

Updates in Numbers

3 Lectures
Tutorialspoint

Instructor Details

Being Commerce

Being Commerce

This is the official channel of being commerce. In Tutorialspoint we provide all the valuable content that helps our students to be financially free.

In our Tutorialspoint courses, we will provide students with all digital marketing courses, Operating systems and money-making courses that will help them to grow their business with 24/7 support as well.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Feedbacks

P

Peter Boonen

It's a nice course for beginners.

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515