Numbers

Learn how to use Apple iWork Numbers with Apple iWork Numbers tutorial for beginners.
3.5 (4 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
151 students enrolled
$30
Take This Course
  • Lectures 65
  • Contents Video: 2 hours
    Other: 11 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2012 English

Course Description

Learn how to create powerful spreadsheets using Apple iWork Numbers with this apple numbers tutorial!

iWorks is one of the best and most economical office productivity suites on the market. Learn to use it on your iPhone, iPad, and Mac after completing this apple numbers tutorial. Store files locally or on iCloud and they are synched automatically on all of your devices. You can easily import and export to Microsoft Excel too.

Now you can learn how to use iWork Numbers online with this iWork tutorial!

This iWork tutorial teaches the fundamentals with a special emphasis on working with conditional statements. Lessons build on completing a practical project so you can easily understand how each feature can be used.

Dr. Winegar has been teaching people how to use spreadsheet software since 1978 and brings that experience to this new series on Numbers. Beginners and experts alike can learn how to use this software with this easy to follow apple numbers tutorial.

What are the requirements?

  • Numbers

What am I going to get from this course?

  • Access templates
  • Work with numbers
  • Work with strings
  • Create & copy labels
  • Sorting data
  • Saving spreadsheets locally
  • Saving spreadsheets on the iCloud
  • Exporting PDFs
  • Work with descriptive statistical functions
  • Use the AVERAGE function
  • Use the MEAN function
  • Use the Standard Deviation function
  • Use the MIN function
  • Use the MAX function
  • Use the MEDIAN function
  • Use the MODE function
  • Use the SUM function
  • Perform a block copy
  • Add & delete columns
  • Add & delete rows
  • Use relative addressing
  • Use absolute addressing
  • Understand & use the algebraic order of operations
  • Create formulae
  • Understand & use boolean logic
  • Ise the IF function
  • Create nested IF functions
  • Use the COUNT function
  • Use the COUNTIF function
  • Create pie charts

What is the target audience?

  • Office workers
  • Teachers
  • Students
  • Professionals
  • Everyone

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started - A first spreadsheet
Article
This class is still in the building process. That's good for you because it means you have more to look forward to. In fact, none of these courses is ever really finished. No worries! You will be notified whenever your instructor adds a lesson to his/her course. This means you will have the latest i…
Introduction
Article
02:42
This video is a brief introduction to Numbers templates. It's brief because I am not a fan of templates. Sometimes you will find one useful but usually the designer didn't have your needs in mind when s/he built it. You are almost always better off creating your own spreadsheets to do what you need done. That's why I'm building this course.
01:25
We enter data into cells. A cell is the intersection of a column and a row. Columns are identified by letters (A. B, C, ...) while rows are differentiated by numbers (1, 2, 3, ...). Cells are referred to using both the column and row coordinates so the cell in the first column and first row is A1

The raw data we enter as text or numbers. Text (AKA strings) have no numeric value. They are just text. Sometimes a digit is included within a string (e.e.' Boeing 747). When this happens the digits have no numeric value. They are just the image of the number. No worries. Its just one of those odd things about computers.

01:58
This video demonstrates how to copy the contents of one cell to another. You will want to try this on your own before continuing. Don't be surprised when Numbers automatically counts and you copy. Try this! Enter "January" into cell A1 and copy it across a few columns.
02:40
Sorting is a power and dangerous capability. Be sure to select all of the data you want sorted rather then just the fields you want to sort on.

What's the difference? We might want to sort the rows of a grade book spreadsheet so there are in alphabetical order by name. The correct way is to highlight all of the data in those rows when you start the sort and pick the field(s) you want to sort on later.

Oops! It's a mistake we all make from time to time and there is a way to recover. It's called UNDO. You'll find it in the Edit Menu or you can use the [command]-[z] key sequence.

If you want to use the command key sequence hold the [command] key down and then press [z]. Go ahead and try. It's quicker than using the menus and becomes very natural after a short while.  

Sorting

From Wikipedia, the free encyclopedia


Sorting information or data

For sorting we can either specify a weak order "should not come after" or a strict weak order "should come before" (specifying one defines also the other, the two are the complement of the inverse of each other, see operations on binary relations). For the sorting to be unique, these two are restricted to a total order and a strict total order, respectively.

Sorting n-tuples (depending on context also called e.g. records consisting of fields) can be done based on one or more of its components. More generally objects can be sorted based on a property. Such a component or property is called a sort key.

For example, the items are books, the sort key is the title, subject or author, and the order is alphabetical.

A new sort key can be created from two or more sort keys by lexicographical order. The first is then called the primary sort key, the second thesecondary sort key, etc.

For example, addresses could be sorted using the city as primary sort key, and the street as secondary sort key.

If the sort key values are totally ordered, the sort key defines a weak order of the items: items with the same sort key are equivalent with respect to sorting. See also stable sorting. If different items have different sort key values then this defines a unique order of the items.

A standard order is often called ascending (corresponding to the fact that the standard order of numbers is ascending, i.e. A to Z, 0 to 9), the reverse order descending (Z to A, 9 to 0). For dates/times ascending means that earlier values precede later ones e.g. 1/1/2000 will sort ahead of 1/1/2001.

In computer science, sorting is one of the most extensively researched subjects because of the need to speed up the operation on thousands or millions of records during a search operation; see sorting algorithm.

The main purpose of sorting information is to optimise its usefulness for specific tasks. In general, there are two ways of grouping information: by category e.g. a shopping catalogue where items are compiled together under headings such as 'home', 'sport & leisure', 'women's clothes' etc. (nominal scale) and by the intensity of some property, such as price, e.g. from the cheapest to most expensive (ordinal scale). Richard Saul Wurman, in his book Information Anxiety, proposes that the most common sorting purposes are Name, by Location and by Time (these are actually special cases of category and hierarchy). Together these give the acronym LATCH (Location, Alphabetical, Time, Category, Hierarchy) and can be used to describe just about every type of ordered information.

Often information is sorted using different methods at different levels of abstraction: e.g. the UK telephone directories which are sorted by location, by category (business or residential) and then alphabetically. New media still subscribe to these basic sorting methods: e.g. a Google search returns a list of web pages in a hierarchical list based on its own scoring system for how closely they match the search criteria (from closest match downwards).

00:58
Save your work often!

I suggest you always have a copy of your work stored locally on your computer. In fact, important files should be saved in two separate locations so you have a backup copy just in case the original is lost, erroneously deleted, or damaged. 

You can store your files on your computer and on the iCloud for a backup.

01:48
The cloud is a great place to store your files because you can access anywhere you have Internet access. This means you don't have to carry your computer or media with you as you travel.

Another tip for packing light is to buy an iPad or MacBook with solid state memory. These are much lighter than "normal" laptops and they run a lot cooler. They also provide faster access to your data because they have no moving parts such as disk drives.

01:42
Sharing your work as a PDF is a great way to protect it from alteration. PDFs can also be read by PCs.
01:50
Yes. You can use Numbers on your iPhone and iPad. This video is an overview of Numbers on an iPhone. My advice is to but a stylus if you plan to do this often. It will help you select smaller cells.
Article
This is mostly a reminder to try the things you see in the videos. 
Article
An overview of Descriptive Statistics from wikipedia.
01:51
Generating an average or mean is demonstrated.

The average or mean is computed by summing the values within a range and then dividing the sum by the number of values within the range.

03:20
Anyone can compute a standard deviation with Numbers. Watch as see how easy it is!
02:20
Find the lowest and highest values within a range.
01:48
The median is a method of finding the man, or number, in the middle.
02:55
Mode finds the most common value in a range.
The SUM function
01:34
Block copy
01:14
Exercise #2
Article
02:53
Sometimes you will want to insert a new column to accomodate a new or forgotten factor in your model. It's a simple thing to do and this video shows you how.
03:22
Last time we saw how to add or insert new columns. This video shows you how to delete them.
02:15
Sometimes you will want to insert a new row. The video shows you how.

BTW, whenever you add or delete rows and columns your cell reference within ranges are automatically updated to reflect the change. That is a nice feature!

01:29
The video shows you how to delete a row.
01:34
An address refers to a specific cell or point in a range of cells.
Relative addresses automatically change as we copy the across columns and down rows. Numbers defaults to relative addressing which is why you can normally copy formulas and functions without having to update them.
Absolute addressing
01:23
04:08
A key to mastering spreadsheet software is understanding the algebraic order of operations. We learned it in school but... we either used it or lost it along the way. So here it a short review with a classic mnemonic to help us remember.

Order of operations

From Wikipedia, the free encyclopedia

In mathematics and computer programming, the order of operations (sometimes called operator precedence) is a rule used to clarify which procedures should be performed first in a given mathematical expression.

For example, in mathematics and most computer languages multiplication is done before addition; in the expression 2 + 3 × 4, the answer is 14. Brackets, "( and ), { and }, or [ and ]", which have their own rules, may be used to avoid confusion, thus the preceding expression may also be rendered 2 + (3 × 4), but the brackets are unnecessary as multiplication still has precedence without them.

Since the introduction of modern algebraic notation, multiplication has taken precedence over addition.[1] Thus 3 + 4 × 5 = 4 × 5 + 3 = 23. When exponents were first introduced in the 16th and 17th centuries, exponents took precedence over both addition and multiplication and could be placed only as a superscript to the right of their base. Thus 3 + 52 = 28 and 3 × 52 = 75. To change the order of operations, originally a vinculum (an overline or underline) was used. Today, parentheses or brackets are used to explicitly denote precedence by grouping parts of an expression that should be evaluated first. Thus, to force addition to precede multiplication, we write (2 + 3) × 4 = 20, and to force addition to precede exponentiation, we write (3 + 5)2 = 64.


The standard order of operations

The order of operations used throughout mathematics, science, technology and many computer programming languages is expressed here:[2]

exponents and rootsmultiplication and divisionaddition and subtraction

This means that if a mathematical expression is preceded by one operator and followed by another, the operator higher on the list should be applied first. The commutative and associative laws of addition and multiplication allow terms to be added in any order and factors to be multiplied in any order, but mixed operations must obey the standard order of operations.

It is helpful to treat division as multiplication by the reciprocal (multiplicative inverse) and subtraction as addition of the opposite (additive inverse). Thus 3/4 = 3 ÷ 4 = 3 • ¼; in other words the quotient of 3 and 4 equals the product of 3 and  ¼. Also 3 − 4 = 3 + (−4); in other words the difference of 3 and 4 equals the sum of positive three and negative four. With this understanding, we can think of 1 − 3 + 7 as the sum of 1, negative 3, and 7, and add in any order: (1 − 3) + 7 = −2 + 7 = 5 and in reverse order (7 − 3) + 1 = 4 + 1 = 5. The important thing is to keep the negative sign with the 3.

The root symbol, √, requires a symbol of grouping around the radicand. The usual symbol of grouping is a bar (called vinculum) over the radicand. Other functions use parentheses around the input to avoid ambiguity. The parentheses are sometimes omitted if the input is a monomial. Thus, sin x = sin(x), but sin x + y = sin(x) + y, because x + y is not a monomial. Calculators usually require parentheses around all function inputs.

Stacked exponents are applied from the top down.

Symbols of grouping can be used to override the usual order of operations. Grouped symbols can be treated as a single expression. Symbols of grouping can be removed using the associative and distributive laws, also they can be removed if the expression inside the symbol of grouping is sufficiently simplified so no ambiguity results from their removal.

02:58
This  video puts the MIN to another use, finding a students lowest quiz score.
03:52
Sometimes we use the term "average" to refer to performance against a standard. This video demonstrates how to do this.
05:13
This video introduces the basic concepts of Boolen logic.

See http://www.ithacalibrary.com/sp/subjects/boolean for more information on boolean logic.

IF
04:54
07:19
Get ready! This is the If function on steroids. You might want to watch it a few times to make sure you understand.
05:22
Since we cannot graph letter grades directly we'll use COUNTIF to tallying our students into groups. We'll use these tallies in our next video to generate a pie chart.
02:50
Creating graphs is a breeze! In this video we'll create a bar and a pie chart.
Practice
Article
Section 2: Date & Time Functions
01:45
Use the NOW function to access your computer's system time. The date and time are displayed.

System time

From Wikipedia, the free encyclopedia

In computer science and computer programmingsystem time represents a computer system's notion of the passing of time. In this sense, time also includes the passing of days on the calendar.

System time is measured by a system clock, which is typically implemented as a simple count of the number of ticks that have transpired since some arbitrary starting date, called the epoch. For example, Unix and POSIX-compliant systems encode system time ("Unix time") as the number of seconds elapsed since the start of the Unix epoch at 1 January 1970 00:00:00 UT, with exceptions for leap seconds. Systems that implement the 32-bit and 64-bit versions of the Windows API, such as Windows 9x and Windows NT, provide the system time as both SYSTEMTIME, represented as a year/month/day/hour/minute/second/milliseconds value, and FILETIME, represented as a count of the number of 100-nanosecond ticks since 1 January 1601 00:00:00 UT as reckoned in the proleptic Gregorian calendar, but returns the current time to the nearest millisecond[citation needed].

System time can be converted into calendar time, which is a form more suitable for human comprehension. For example, the Unix system time1000000000 seconds since the beginning of the epoch translates into the calendar time 9 September 2001 01:46:40 UT. Library subroutines that handle such conversions may also deal with adjustments for timezonesdaylight saving time (DST), leap seconds, and the user's locale settings. Library routines are also generally provided that convert calendar times into system times.

00:45
This function, like NOW, accesses your computer's system time to display the current date.
Teaser
Article
01:52
The DATE function constructs a date/time value from three integers; one each for the year, month, and day. This may be useful in some spreadsheet models but it's far from being one of the top 10 most used functions.
01:56
DATEVALUE takes a character string representation of a date and returns a date/time representation. At first glance this may not seem to be a very useful function but it crucial when you need it. When is that?

Whenever you import files, either ASCII data files or a file exported from other spreadsheet software, dates can be represented as strings which may be problematic. This function allows you to make the values useful without loss of data. 

01:05
The DAY function is useful in extracting the day of the month from a date/time value.
01:31
The WEEKDAY function is useful in extracting the day of the week from a date/time value. It returns an integer within the range 1 - 7. Since Sunday is officially the first day of the week it is represented by the number 1. Monday is 2 and so on.
01:27
DAYNAME takes an integer (1-7) and returns the name of the corresponding day of the week.
Just for giggles
Article
01:03
This function extracts the month number (1-12) from a date/time value.
01:03
MONTHNAME takes an integer (1-12) and returns the name of the corresponding month.
01:46
EOMONTH is useful for finding the end of the month of a given period of time. It has the capability of moving backward and forward in time.
Just for giggles
Article
02:03
This function returns a date's position within the weeks of the year.
01:22
EDATE is useful in finding a date months ahead or behind a certain date.
Just for giggles
Article
01:48
Find the difference between two dates.
Just for giggles
Article
01:17
Find the number of days between two dates.
01:59
Find the number of work days between two dates. You can even excluded specific dates like holidays.
01:02
This function extract the year from a date/time value.
01:40
YEARFRAC determines what portion of the year is represented by a date range.
01:00
This function extracts the hour from a date/time value.
00:53
MINUTES extracts the minutes from a date/time value.
SECOND
00:54
01:05
This function constructs a date/time value from three integers.
00:59
A function to determine how much of the day is past.
01:43
Displays the date so many workdays ahead or behind.
Just for giggles
Article
Brain teaster
Article
Section 3: Duration Functions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dr. Mark Winegar, Learn from an experienced software engneer and educator.

I first looked at learning online in 1998 while working on my doctoral dissertation. To be honest I was a skeptic but my findings persuaded me of the web's vast potential as a learning tool. It doesn't replace teachers. It empowers them.

I have been teaching people how to use and program computers since the dawn of microcomputers. My first faculty inservice was an introduction to spreadsheeting at Michigan State University, my alma mater. Since then I have taught in major corporations, universities, colleges, and K-12 districts nationwide. 

But I am not just a teacher.

I'm a software engineer too! And I've developed mission critical applications like the multilingual software installation application for Microsoft, the System Trouble Report database application for Zenith Data Systems, medical scheduling & records applications for Southwetern Michigan Megnetic Resonance Imaging Systems, and manufacturing automation for Gateway 2000. 

Today I live near the campus of the University of South Datkota in Vermillion, SD, USA with my wife Bonnie. We have two cats and a cavalier king charles spaniel and enjoy riding our bicycles on the prairie.

Ready to start learning?
Take This Course