Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Apple Numbers: Complete Basic to Pro Guide For Mac Numbers

person icon Being Commerce

4.6

Apple Numbers: Complete Basic to Pro Guide For Mac Numbers

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

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Being Commerce

English [CC]

category icon Numbers for Mac,Apple,Office Productivity

Lectures -46

Resources -1

Duration -3 hours

4.6

price-loader

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 got used an application like Excel within the past, you'll also use this course to quickly learn the ins-and-outs of Numbers.

“Mac Numbers - A Journey from Beginners to Advance level” may be a comprehensive course designed to require you from beginners to advance level when it involves working with spreadsheets application like Numbers in Mac.

This video series will start right from the basics like Numbers interface, creating new document using template, entering data, Worksheets, Tables, Cells and gradually move towards advance feature like working with 2D and 3D charts, interactive spreadsheet, 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 yon got to perform repeatedly. I even have also added some neat tricks and tips which can enhance your productivity also .

The course is split into section and every section covers one broad area which can gradually build up your skills overtime. I even have recorded short video 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 which you'll find helpful. 

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

Enroll Now inside this course, Apple Numbers: Complete Basic to Pro Guide For Mac Numbers.

Enroll Now!!!

Goals

What will you learn in this course:

  • Basic to Advance everything about Apple Numbers or Mac Numbers

  • Use formulas to perform calculations

  • Building interactive sheets using pop-up menu,checkboxes, star rating 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 function 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 advance 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

What are the prerequisites for this course?

  • 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.

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

e


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

e

It's a nice course for beginners. I have one important thing to tell. The teacher is telling us as much as possible in a very short time. If he slows down a little bit the presentation is much clearer and more relaxed.

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