Viruses Explained What are Trojans? What are Worms? What are Rootkits? Free AntiVirus Latest Virus Threats Top 10 Anti Virus Malware Tutorials
Spyware Explained Malware Tutorials Free Anti Spyware Manual Tips
FREE Anti Virus FREE Anti Spyware FREE Online Scanners Definition Updates Manual Updates BootUp Anti Virus Portable Protection Rootkit Removal Top Security Tips
HTML Tutorial WORD Tutorial EXCEL Tutorial Computer Beginners Windows Registry Top Security Tips Malware Tutorials
Web Templates Word Templates Word Processing

Home Page
Free Anti Virus
Free Anti Spyware
Free Online Scanners
Free USB Anti Virus
Bootable Anti Virus
Rootkit Removal
Latest Virus Threats
Viruses Explained
Spyware Explained
Windows Registry
Top 10 Antivirus
Manual Updates
Definition Updates
Malware Tutorials

Computer Basics
HTML Tutorials
Free Web Templates
Word Tutorials
Excel Tutorials

CV Creation
Free CV Templates
Free CV Examples

   IP: 54.145.51.250

Excel Basics   AutoSum   Formulas   AutoFill  

Excel Formulas:

One of the key issues is that formulas use cell references to do a calculation. As you can see below we used the AutoSum to calculate the numbers in A1,A2,A3 and A4 in the Calculations lesson.

Now this is a very powerful and easy way to do calculations but by writing the formula yourself you can do infinite calculations in infinite ways using columns and rows.



Double click the cell that you want the calculation to appear in (below is A6). Then by typing in the formula you see below into this cell and hitting the Enter key you will be adding the numbers in A1,A2,A3,A4 and the result will appear in A6.

Below you can see that you can also type the formula into the Formula Bar (fx). The formula will appear in both no matter which one you pick. You will notice when you hit the Enter key the figure will appear. To get the formula back you just double click that cell again.




Lets now use the same figures and get 1% of the total of all the numbers. Remember to double click the cell you want to work in. As you can see this is standard Maths to get 1%.

You could do =sum(A1+A2+A3+A4)/100 but using (A1:A4) is a short cut.



Below there are some headings that you can type in normally to give names to a column. Also notice you use a formula on any cells.



Below shows that you can use multiple formulas through out a spreadsheet. Use the AutoSum for the monthly totals.