ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

iWork: Numbers Tutorial for Slackers

Updated on April 28, 2011

iTunes, check. iLife, check. iWork...

Yeah, right. iWork. heh heh.

My New Year’s resolution is to grow up a little. Do things that other grown-ups do. Like, learn how to use a spreadsheet and stuff.

So, I went ahead and opened up the disc that came with my Snow Leopard upgrade. You know, the one that usually gets tossed aside and forgotten. The one that says iWork (shudder).

The installer disc served up three applications. One, called Keynote, is a Mac version of PowerPoint. I’ll pretend to create a business presentation later. Looks like fun, kinda.

The second app is called Pages. It looks like a pretty cool word processor. I’m a fan of Bean myself, but I’ll soon be converting my .bean files into Pages. The other grown-ups seem to be doing that.

Numbers, the third app, is the one I was looking for. It’s icon is a cool looking bar graph that is springing up from a square chart. It reminds me of playing bingo a little bit.

Once I had it launched, I started to noodle around. Freestyle clicking is the preferred method of self-taught geniuses, you know. It’s the best way to tailor the lessons to your own personal (short) attention span.


Here is what I learned.

Spreadsheets have lots and lots of little boxes. You can put numbers in the boxes, or you can type words. It seems like a good way to make a list of stuff because the list can go left to right, and up and down too.

At first, a spreadsheet looks like a Battleship grid, but you can’t put numbers in random spots like you’re trying to bomb a carrier. That messes up your list.

My favorite part of the spreadsheet is the "charts" button at the top of the menu. It takes all those little boxes, and makes them into a sweet graph.

iScrewAround

My boss tells me sometimes that I should quit screwing around. How does he know? He is a Math Guy, so I think he maybe has a chart or something.

In honor of my 2010 resolution, I decided to make a graph of my home studio productivity.

Based on the statistical analysis, there is a high probability that I’m just totally screwing around.

The most interesting result of my experiment is that I found both “hub” and “pages” on the same Boggle board. It was during Round 3.


iSee...

It turns out that you can use a spreadsheet to actually do math for you. The boxes can do calculations to the numbers you put in. It’s algebra-ish.

I clicked around for awhile and decided that it’s easier to do my own calculations. With a calculator. Then type in the numbers.

But, I still used the spreadsheet to put all the numbers in a neat list. Then I clicked my new favorite button: charts.

iAyeAye

Analyzing armies is surprisingly complex.

Since I had to take basic algebra twice in high school, I thought I’d try the Spreadsheet Calculator Thingy a second time too. A simpler equation made all the difference in the world.

iStats

Fantasy football stats are something that I can understand fairly easily. If I do screw them up a little, I can usually skate by using my “Only Girl in the League” excuse.

My motto is, If a girl owns a truck, she damn well better know how to drive it. Still, I’d rather pull out my Girl Card than to admit how very bad I am at math.

What makes football stats easier to understand than stats that are actually important? My only conclusion: beer.

I cracked one open, then did a spreadsheet with meaningful data.

iRock

I’m a Michigan girl. Mitten full of fishermen. America’s High Five state.

As a resident of Wayne County, I’ve noticed a disturbing trend first hand. The social implications are yet to be understood.

Adapt or Die, they say. I’m not going to let this one go, though. Sorry.

Watergate DOES bother me.

Wrap it up already, slacker

Admittedly, my freestyle self-training of iWork has left me with a few knowledge gaps. That is bound to happen. When my attention span recovers, I’ll go ahead and figure out the finer, more subtle points.

Maybe I’ll list them in a spreadsheet...




© 2010 wyanjen at HubPages

iWork Tutorial for Slackers


Comments

Submit a Comment

  • Dale Mazurek profile image

    Dale Mazurek 

    8 years ago from Canada

    What a great hub.

    Its not only informative but funny as well.

    This hub is now on my hub

  • wyanjen profile imageAUTHOR

    Jen King 

    8 years ago from Wyandotte Michigan

    You type numbers in the little boxes, and it turns them into completely awesome graphs.

    It's so easy, a slacker can do it.

    Good to see you fishtiger, thanks for stopping over.

    Jen

  • fishtiger58 profile image

    fishtiger58 

    8 years ago from Momence, Illinois

    Outstanding hub. I laughed all the way through. Nice graphs, spreadsheet, errrr whatever you call em.

  • wyanjen profile imageAUTHOR

    Jen King 

    8 years ago from Wyandotte Michigan

    I'm glad you got a kick out of it, although I did gloss over the Tutorial Portion just a tad.

  • Dao Hoa profile image

    Dao Hoa 

    8 years ago

    Very good and very funny. I am glad that you find an easy way to explain spreadsheet :)

  • wyanjen profile imageAUTHOR

    Jen King 

    8 years ago from Wyandotte Michigan

    They say that your first impressions are always right.

    :D

  • marcofratelli profile image

    marcofratelli 

    8 years ago from Australia

    Bahaha, I should read more of your hubs. "Spreadsheets have lots and lots of little boxes" - now I know! Thanks!

  • wyanjen profile imageAUTHOR

    Jen King 

    8 years ago from Wyandotte Michigan

    Good morning CC. We both live in Wayne Counties? JINX!

    Secretly, I'm self-teaching spreadsheets so that I can use the csv export from the Hub Statistics page.

    How's that working out, you ask?

    So far, I can make a pretty picture out of it. heh heh.

  • profile image

    ralwus 

    8 years ago

    Who cares, you did a great job of making me laugh this morning. LOL I live in Wayne County as well. Ohio. Mad Anthony was a popular guy it seems. I really enjoyed this, thanks.

  • wyanjen profile imageAUTHOR

    Jen King 

    8 years ago from Wyandotte Michigan

    Ugh.

    That sounds like so much work.

    :D

  • Quilligrapher profile image

    Quilligrapher 

    8 years ago from New York

    A thumbs up hub, Jen. Having read almost everything written for "Dummies", I'm now looking to move on to subjects that appeal to "Slackers." Thanks for helping me out.

    Q.

working

This website uses cookies

As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

Show Details
Necessary
HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
LoginThis is necessary to sign in to the HubPages Service.
Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
AkismetThis is used to detect comment spam. (Privacy Policy)
HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
Features
Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
MavenThis supports the Maven widget and search functionality. (Privacy Policy)
Marketing
Google AdSenseThis is an ad network. (Privacy Policy)
Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
Index ExchangeThis is an ad network. (Privacy Policy)
SovrnThis is an ad network. (Privacy Policy)
Facebook AdsThis is an ad network. (Privacy Policy)
Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
AppNexusThis is an ad network. (Privacy Policy)
OpenxThis is an ad network. (Privacy Policy)
Rubicon ProjectThis is an ad network. (Privacy Policy)
TripleLiftThis is an ad network. (Privacy Policy)
Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
Statistics
Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)