I am just starting excel in school. I cannot figure out how to put together a formula. I need like a list of them and how theyt can be put together. Anything to help me grasp this concept.
I am just starting excel in school. I cannot figure out how to put together a formula. I need like a list of them and how theyt can be put together. Anything to help me grasp this concept.
Hi and welcome to the forum
If we were to give you a "list" of formulas, it would be a mile long. The best way to understand how the basic formulas work is to consider that a worksheet (tab) is a collection if rows and columns, and the intersection of a row and column is a cell.
The cell is where it all happens - you cant refer to other cells.
For instance in B1 you could have =A1 to give you the contents of A1
or if you have a value (10) in A1 and another (20) in A2, you can add them using =A1+A2
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I would suggest to go to YouTube. There are plenty videos for all levels.
Here is a link for you to start.
https://www.youtube.com/results?sear...be.0O1ykI9M7LM
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
You can learn a lot in forums like this one.
If you can "invest" several hours every day reading and studying the solutions and doing lots of experimentation in 4 or 5 years you'll be an Excel Guru.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Here is a great youtube channel.. he teaches begginer to advanced. and has downloadable books to follow along..
http://www.youtube.com/user/ExcelIsFun
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks