Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice realworld skills and achieve your goals.
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.
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.
Section 1: Getting Started  A first spreadsheet  

Lecture 1  00:36  
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…  
Lecture 2 
Introduction

02:22  
Lecture 3  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.  
Lecture 4  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. 

Lecture 5  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. 

Lecture 6  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. SortingFrom Wikipedia, the free encyclopedia


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

Lecture 8  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. 

Lecture 9  01:42  
Sharing your work as a PDF is a great way to protect it from alteration. PDFs can also be read by PCs.  
Lecture 10  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.  
Lecture 11  00:18  
This is mostly a reminder to try the things you see in the videos.  
Lecture 12  02:09  
An overview of Descriptive Statistics from wikipedia.  
Lecture 13  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. 

Lecture 14  03:20  
Anyone can compute a standard deviation with Numbers. Watch as see how easy it is!  
Lecture 15  02:20  
Find the lowest and highest values within a range.  
Lecture 16  01:48  
The median is a method of finding the man, or number, in the middle.  
Lecture 17  02:55  
Mode finds the most common value in a range.  
Lecture 18 
The SUM function

01:34  
Lecture 19 
Block copy

01:14  
Lecture 20 
Exercise #2

00:07  
Lecture 21  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.  
Lecture 22  03:22  
Last time we saw how to add or insert new columns. This video shows you how to delete them.  
Lecture 23  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! 

Lecture 24  01:29  
The video shows you how to delete a row.  
Lecture 25  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. 

Lecture 26 
Absolute addressing

01:23  
Lecture 27  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 operationsFrom 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 + 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 standard order of operationsThe order of operations used throughout mathematics, science, technology and many computer programming languages is expressed here:^{[2]} exponents and rootsmultiplication and divisionaddition and subtractionThis 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. 

Lecture 28  02:58  
This video puts the MIN to another use, finding a students lowest quiz score.  
Lecture 29  03:52  
Sometimes we use the term "average" to refer to performance against a standard. This video demonstrates how to do this. 

Lecture 30  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. 

Lecture 31 
IF

04:54  
Lecture 32  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.  
Lecture 33  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.  
Lecture 34  02:50  
Creating graphs is a breeze! In this video we'll create a bar and a pie chart.  
Lecture 35 
Practice

00:11  
Section 2: Date & Time Functions  
Lecture 36  01:45  
Use the NOW function to access your computer's system time. The date and time are displayed. System timeFrom 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 POSIXcompliant 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 32bit and 64bit 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 100nanosecond 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 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. 

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

00:02  
Lecture 39  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.  
Lecture 40  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. 

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

Lecture 42  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. 

Lecture 43  01:27  
DAYNAME takes an integer (17) and returns the name of the corresponding day of the week.  
Lecture 44 
Just for giggles

00:06  
Lecture 45  01:03  
This function extracts the month number (112) from a date/time value.  
Lecture 46  01:03  
MONTHNAME takes an integer (112) and returns the name of the corresponding month.  
Lecture 47  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.  
Lecture 48 
Just for giggles

00:07  
Lecture 49  02:03  
This function returns a date's position within the weeks of the year.  
Lecture 50  01:22  
EDATE is useful in finding a date months ahead or behind a certain date.  
Lecture 51 
Just for giggles

00:04  
Lecture 52  01:48  
Find the difference between two dates.  
Lecture 53 
Just for giggles

00:04  
Lecture 54  01:17  
Find the number of days between two dates.  
Lecture 55  01:59  
Find the number of work days between two dates. You can even excluded specific dates like holidays.  
Lecture 56  01:02  
This function extract the year from a date/time value.  
Lecture 57  01:40  
YEARFRAC determines what portion of the year is represented by a date range.  
Lecture 58  01:00  
This function extracts the hour from a date/time value.  
Lecture 59  00:53  
MINUTES extracts the minutes from a date/time value.  
Lecture 60 
SECOND

00:54  
Lecture 61  01:05  
This function constructs a date/time value from three integers.  
Lecture 62  00:59  
A function to determine how much of the day is past.  
Lecture 63  01:43  
Displays the date so many workdays ahead or behind.  
Lecture 64 
Just for giggles

00:07  
Lecture 65 
Brain teaster

00:08  
Section 3: Duration Functions 
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 K12 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.