hey i want to learn excel in order to analyze data
i do not know anything about Excel,i just began
where should i start?
post some vids or books recommendations a beginner
hey i want to learn excel in order to analyze data
i do not know anything about Excel,i just began
where should i start?
post some vids or books recommendations a beginner
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Start with any one and when completed move to the next. Each will have their own intricacies. You will never know everything about Excel. We/I am always learning new things. You need to just jump in -- no one here is going to spoon feed you. You have to make the effort. This site is all about helping with specific issues. It is not a site designed as a tutorial.
You might find it useful to make a little project to analyze some data,
You can put all the information you think you need in the sheet somewhere in an orderly way and then come on here and ask us how to do specific steps, or explain specific things about excel, while demonstrating that you are making an effort.
Depends on the person, but I find learning while doing something relevant to you is good.
Give one of the videos a watch anyway - they wont be that long.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
My learning curve was to take a problem, and see what I could do in excel to solve it - then see if there was a better way to do that - then look/ask around forums like this 1 to see how else it could be solved.
There is no substitute for practice and experience.
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
There are numbers and strings. Do not mix them them in one cell.
NB Dates are numbers.
Content of a cell and its format are different things.
Print layout and display (working) layout are different things.
Use links to a cell with a parameter, not a parameter itself
Always build all of your workbooks in a way you can recall on the spot even through years.
There are links to a whole bunch of Excel resources here: https://www.excelforum.com/excel-new...additions.html
So go and find some that is more up-to-date.
We cannot answer your question. Excel does so many things in so many different ways: without a clue as to how you are expecting to be able to use it, we can't begin to advise you about where to start.
As someone already said, the best way is to set yourself a task - a little project. Work through it by attempting things yourself (there's a lot of context-sensitive help in the program itself) and by Googling or asking here when you get stuck. That's the best advice I can give. Learn by doing.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
i just saw there is a section on these forums for New Users/Basics
why modarator moved this thread here instead of New Users/Basics?
nivi7,
Please see the following link, replies #25 and #26
https://www.excelforum.com/excel-pro...terials-2.html
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
@stanleydgromjr - Per post #1, Nivi7 was, I think, looking for Beginner Excel resources, not specifically for VBA.
The OP hasn't yet told us how he hopes to use Excel. If he did, it would be MUCH easier to advise him and to suggest suitable sources.
Here's something that I hope will help: https://lmgtfy.com/?q=learn+excel+2019
See https://www.excelguru.ca/forums/show...1432#post41432
Last edited by Pepe Le Mokko; 06-21-2019 at 08:28 AM.
But did you follow the link I provided and click where it said 'click here'? There are hundreds of resources for beginners available either online or as books, and for the latest version of Excel that you have. That was my point.
Here on the forum we can help you with specific requests. Generic issues such as yours are really better tackled using Google, as you know what you want to do with Excel. And, no, you still havebn't told us this. Asking us where you should start will only prompt the question, "Well, what do you want to do?". How do we know where you should start in this vast topic unless you give us some idea of what you wish to use Excel and to what end. If you don't have any idea at all why you would use Excel, then you probably don't need it.
Most of that material is still useful, of course.
You don't need to know every new function of your a beginner, just the general stuff and stuff from old versions is almost entirely present in newer versions.
I have removed your offensive post.
What I am trying to find out so that we can give you better guidance is what you intend to do with Excel. What is your motivation for learning it? What sort of data do you want to analyse and in what way? How do you intend to use the information? If you answer theses questions, then we’ll be able to answer yours about where you should start. Please answer my questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks