beyond teck

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Tuesday, 13 December 2005

Excel, the program that loves doing math

Posted on 17:39 by Unknown
Excel is one of the most used software for accounting around the world (or atleast that's what I think). Usually spreadsheet applications are very helpful when it comes to math (even though you need to do some thinking) because it does all the math for you! However, using it sometimes can be a little intimidating if you don't know what does what. That's why I've put together some Excel tips (more coming soon), and hopefully it might to help you out.

1. The box like thing between a row (the lines that are going horizontal corresponding to the numbers) and a column (the lines that are going vertical corresponding to the letters) is called a cell
2. The location of the cell is identified by the column and the row it is in. For example if a cell is in the A column and the 1st row its cell address is A1
3. Whenever you are writing a formula remember to keep in mind the BEDMAS rule and include brackets
4. Instead of typing in the cell address you can just click on the cell and the cell address will automatically be recorded in the formula
5. Always begin a formula with and equal sign
6. If you are working on a large spreadsheet don't forget to "split" it (Window > Split)
7. You don't need to use just the spreadsheet that you are working on you can also click on other sheets at the bottom of the window and do your work in that
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in | No comments
Newer Post Older Post Home
View mobile version

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • WeTransfer Job Ad
    I like using WeTransfer to transfer things that don't fit in emails, mainly because the site is fast, has a large upload limit (2GB!) an...
  • Contact Me!
    Okay so you want to contact me for something? No Problem! E-Mail You can send all your questions , comments , tips (I need a lot of those)...
  • The Beyond-Teck Search Plugin
    I realize that it is hard to come to the site all the time to search for something. Especially when you are studying for tests, using the bl...
  • Adium Update
    Looks like Adium (or Adium X) was updated. Now of course Adium isn't the messenger I use most (I use Trillian + Windows Live Messenger...
  • What is Bootsec.Bak? Can I delete it?
    Today when I was browsing through my C: folder, which I don’t always do, I noticed that I had a lot of junk on there. Most of it seemed to b...
  • Fixing Windows or Linux With Knoppix
    Extreme Tech had published a few articles a few days ago on how to use Knoppix to rescue Windows , and now they've published an article...
  • Review of ActualMultipleMonitors from Actual Tools in Windows 8
    I was recently contacted by Actual Tools and they asked me to try out their newest version of Actual Multiple Monitors . It is a tool that p...
  • Another cool resource...
    When I was surfing around the new I just found another cool resource which is called Tech-Recepies. This place has all cool tutorials and tw...
  • Num Lock and Caps Lock on a Blackberry
    While it feels amazing to type away on a blackberry keyboard (even for a person with big fingers like me), one thing that I have recently di...
  • Mac Tip: Extended Menubar Replacement for Dual Monitors
    Sometimes, having dual monitors is a great thing (see: 21 killer tips to increase your productivity on your computer ). Having dual computer...

Categories

  • addons
  • adobe
  • ads
  • adsense
  • apple
  • audio
  • blackberry
  • blog
  • blogger
  • blogging
  • cars
  • cellphones
  • clean
  • code
  • comments
  • cricket
  • downloads
  • ebooks
  • email
  • error
  • file sharing
  • firefox
  • fixes
  • free
  • games
  • gas
  • Gmail
  • google
  • hack
  • hotmail
  • installs
  • instant messaging
  • internet
  • internet explorer
  • ipod
  • laptop
  • Linux
  • Live Writer
  • lol
  • Mac
  • mac. mail
  • mail
  • messenger
  • microsoft
  • Microsoft Word
  • money
  • msn
  • music
  • Musings
  • network
  • news
  • online
  • Outlook
  • page
  • peripherals
  • phones
  • photo
  • photoshop
  • php
  • plagiarism
  • problems
  • productivity
  • programming
  • projects
  • rant
  • Registry
  • Review
  • school
  • Screenshots
  • search
  • security
  • software
  • spam
  • speech
  • speed up windows
  • spyware
  • sysfader
  • technology
  • tip
  • tricks
  • tutorials
  • ubuntu
  • updates
  • video
  • virus
  • voip
  • web
  • wi-fi
  • Windows
  • Windows 7
  • Windows Vista
  • Windows XP
  • wireless
  • work
  • wtf
  • youtube

Blog Archive

  • ►  2013 (5)
    • ►  October (2)
    • ►  August (2)
    • ►  March (1)
  • ►  2012 (6)
    • ►  December (1)
    • ►  October (1)
    • ►  June (1)
    • ►  May (1)
    • ►  January (2)
  • ►  2011 (19)
    • ►  October (1)
    • ►  August (1)
    • ►  July (8)
    • ►  June (1)
    • ►  February (4)
    • ►  January (4)
  • ►  2010 (41)
    • ►  November (1)
    • ►  October (3)
    • ►  September (3)
    • ►  August (2)
    • ►  July (12)
    • ►  June (2)
    • ►  May (5)
    • ►  April (3)
    • ►  March (4)
    • ►  February (4)
    • ►  January (2)
  • ►  2009 (59)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  September (3)
    • ►  August (4)
    • ►  July (4)
    • ►  June (14)
    • ►  May (1)
    • ►  April (3)
    • ►  March (3)
    • ►  February (4)
    • ►  January (20)
  • ►  2008 (108)
    • ►  December (22)
    • ►  November (10)
    • ►  October (14)
    • ►  August (13)
    • ►  July (13)
    • ►  June (6)
    • ►  May (13)
    • ►  April (10)
    • ►  March (5)
    • ►  January (2)
  • ►  2007 (33)
    • ►  December (8)
    • ►  November (1)
    • ►  October (4)
    • ►  September (10)
    • ►  August (1)
    • ►  July (2)
    • ►  June (1)
    • ►  May (2)
    • ►  April (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2006 (137)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  August (1)
    • ►  July (3)
    • ►  June (9)
    • ►  May (20)
    • ►  April (22)
    • ►  March (33)
    • ►  February (20)
    • ►  January (26)
  • ▼  2005 (55)
    • ▼  December (12)
      • A picture is worth 1000 dollars
      • The power of Openoffice
      • Its truly RIMarkable
      • If I ever had 100,000 dollars
      • Another computer video...
      • The Share Market?
      • Excel, the program that loves doing math
      • A few useful Blogger keyboard shortcuts
      • What's up with the Plagiarism?
      • Oh I just realised!
      • What's up with the Gangster talk?
      • How to use iTunes and iPod
    • ►  November (19)
    • ►  October (9)
    • ►  September (15)
  • ►  2001 (1)
    • ►  January (1)
Powered by Blogger.

About Me

Unknown
View my complete profile