Browse

Learn how to use Apple iWork Numbers with Apple iWork Numbers tutorial for beginners.

157 students enrolled

- 2 hours on-demand video
- 17 Articles
- Full lifetime access
- Access on mobile and TV

- Certificate of Completion

Have a coupon?

What Will I Learn?

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

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

Expand All 65 Lectures
Collapse All 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.# Sorting

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.

From Wikipedia, the free encyclopedia

Sorting information or data

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 the**secondary 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

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.

Saving Spreadsheets

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.

Adding new columns

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!

Adding new rows

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.

Relative addressing

01:34

Absolute addressing

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.

From Wikipedia, the free encyclopedia

## The standard order of operations

**exponents** and **roots****multiplication** and **division****addition** and **subtraction**

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 + 5^{2} = 28 and 3 × 5^{2} = 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 order of operations used throughout mathematics, science, technology and many computer programming languages is expressed here:^{[2]}

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.

See http://www.ithacalibrary.com/sp/subjects/boolean for more information on boolean 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.

From Wikipedia, the free encyclopedia

In computer science and computer programming, **system 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 time*1000000000* 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 timezones, daylight 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

About the Instructor

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.

- About Us
- Udemy for Business
- Become an Instructor
- Affiliates
- Blog
- Topics
- Mobile Apps
- Support
- Careers
- Resources

- Copyright © 2017 Udemy, Inc.
- Terms
- Privacy Policy
- Intellectual Property