MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Numbers

Course Summary

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

• +

Course Syllabus

• Getting Started - A first spreadsheet
• Thank you!
• Introduction
• Templates Overview
• Strings & Numbers
• Copying labels
• Sorting Data
• Saving on iCloud
• Exporting a PDF
• Tour iWork Numbers on an iPhone
• Exercise #1
• Descriptive Statistics
• Mean
• Standard Deviation
• Minimum & Maximum
• Median
• Mode
• The SUM function
• Block copy
• Exercise #2
• Adding new columns
• Deleting columns
• Adding new rows
• Deleting rows
• Algebraic Order of Operations
• MIN: finding the lowest score
• Computing an average score
• Boolean Logic
• IF
• Nested IFs
• COUNT & COUNTIF
• Pie & Bar Charts
• Practice
• Date & Time Functions
• NOW
• TODAY
• Teaser
• DATE
• DATEVALUE
• DAY
• WEEKDAY
• DAYNAME
• Just for giggles
• MONTH
• MONTHNAME
• EOMONTH
• Just for giggles
• WEEKNUM
• EDATE
• Just for giggles
• DATEDIF
• Just for giggles
• DAYS360
• NETWORKDAYS
• YEAR
• YEARFRAC
• HOUR
• MINUTE
• SECOND
• TIME
• TIMEVALUE
• WORKDAY
• Just for giggles
• Brain teaster
• Duration Functions
• DUR2DAYS
• DUR2HOURS
• DUR2MILLISECONDS
• DUR2MINUTES
• DUR2SECONDS
• DUR2WEEKS
• DURATION
• STRIPDURATION

Course Fee:
USD 29

Self-Study

Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

Microsoft Excel

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software