Numbers
3.6 (5 ratings)
162 students enrolled
Wishlisted Wishlist

Numbers

Learn how to use Apple iWork Numbers with Apple iWork Numbers tutorial for beginners.
3.6 (5 ratings)
162 students enrolled
Created by Dr. Mark Winegar
Last updated 1/2013
English
Current price: \$10 Original price: \$30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
• 2 hours on-demand video
• 17 Articles
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• Access templates
• Work with numbers
• Work with strings
• Create & copy labels
• Sorting data
• 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
• 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
View Curriculum
Requirements
• Numbers
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.

Who is the target audience?
• Office workers
• Teachers
• Students
• Professionals
• Everyone
Students Who Viewed This Course Also Viewed
Curriculum For This Course
65 Lectures
02:02:41
+
Getting Started - A first spreadsheet
35 Lectures 01:25:22
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…
Preview 00:36

Introduction
02:22

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.
Preview 02:42

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.

Strings & Numbers
01:25

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.
Preview 01:58

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

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

Sorting Data
02:40

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.

00:58

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.

Saving on iCloud
01:48

Sharing your work as a PDF is a great way to protect it from alteration. PDFs can also be read by PCs.
Exporting a PDF
01:42

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.
Tour iWork Numbers on an iPhone
01:50

This is mostly a reminder to try the things you see in the videos.
Exercise #1
00:18

An overview of Descriptive Statistics from wikipedia.
Descriptive Statistics
02:09

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.

Mean
01:51

Anyone can compute a standard deviation with Numbers. Watch as see how easy it is!
Standard Deviation
03:20

Find the lowest and highest values within a range.
Minimum & Maximum
02:20

The median is a method of finding the man, or number, in the middle.
Median
01:48

Mode finds the most common value in a range.
Mode
02:55

The SUM function
01:34

Block copy
01:14

Exercise #2
00:07

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.
02:53

Last time we saw how to add or insert new columns. This video shows you how to delete them.
Deleting columns
03:22

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!

02:15

The video shows you how to delete a row.
Deleting rows
01:29

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.
01:34

01:23

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

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.

Algebraic Order of Operations
04:08

This  video puts the MIN to another use, finding a students lowest quiz score.
MIN: finding the lowest score
02:58

Sometimes we use the term "average" to refer to performance against a standard. This video demonstrates how to do this.
Computing an average score
03:52

This video introduces the basic concepts of Boolen logic.

Boolean Logic
05:13

IF
04:54

Get ready! This is the If function on steroids. You might want to watch it a few times to make sure you understand.
Nested IFs
07:19

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.
COUNT & COUNTIF
05:22

Creating graphs is a breeze! In this video we'll create a bar and a pie chart.
Pie & Bar Charts
02:50

Practice
00:11
+
Date & Time Functions
30 Lectures 32:38
Use the NOW function to access your computer's system time. The date and time are displayed.

System time

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.

NOW
01:45

This function, like NOW, accesses your computer's system time to display the current date.
TODAY
00:45

Teaser
00:02

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.
DATE
01:52

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.

DATEVALUE
01:56

The DAY function is useful in extracting the day of the month from a date/time value.
DAY
01:05

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.
WEEKDAY
01:31

DAYNAME takes an integer (1-7) and returns the name of the corresponding day of the week.
DAYNAME
01:27

Just for giggles
00:06

This function extracts the month number (1-12) from a date/time value.
MONTH
01:03

MONTHNAME takes an integer (1-12) and returns the name of the corresponding month.
MONTHNAME
01:03

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.
Preview 01:46

Just for giggles
00:07

This function returns a date's position within the weeks of the year.
WEEKNUM
02:03

EDATE is useful in finding a date months ahead or behind a certain date.
EDATE
01:22

Just for giggles
00:04

Find the difference between two dates.
DATEDIF
01:48

Just for giggles
00:04

Find the number of days between two dates.
DAYS360
01:17

Find the number of work days between two dates. You can even excluded specific dates like holidays.
Preview 01:59

This function extract the year from a date/time value.
YEAR
01:02

YEARFRAC determines what portion of the year is represented by a date range.
YEARFRAC
01:40

This function extracts the hour from a date/time value.
HOUR
01:00

MINUTES extracts the minutes from a date/time value.
MINUTE
00:53

SECOND
00:54

This function constructs a date/time value from three integers.
TIME
01:05

A function to determine how much of the day is past.
TIMEVALUE
00:59

Displays the date so many workdays ahead or behind.
WORKDAY
01:43

Just for giggles
00:07

Brain teaster
00:08
+
Duration Functions
0 Lectures 00:00