The biggest thing that I see people struggle with when they learn Excel is the spreadsheets, charts, and data workbooks. It can be a little overwhelming to see what all it can do for you. If you really want to improve your Excel skills, you must put some effort into learning the spreadsheets.
Think about this, how many people can actually say they know how to do something without trying? That’s because there are people who know everything there is to know about something and think they are experts. Then there are people who know everything there is to know about something but they don’t know how to do it. So, if you really want to learn Excel, you need to learn the spreadsheets. It’s the most important part of Excel.
So, if you want to know Excel spreadsheet skills, you need to learn them by using them. Use them as you learn them. For example, in your first few weeks of using Excel, you will have to spend a lot of time on learning how to make a chart. This is where you will get a lot of your initial skills. And you need to learn how to do it quickly and efficiently.
You have a couple of choices here. You can use a workbook in Excel to get the chart up and running or you can use a charting library to do it. I think using a workbook to create the chart is the best way to learn because you have the chart right there in your hands in real time.
Or, you can use a charting library to make the charting workbook from scratch. It’s easier to do this than it sounds because you can get many free charting libraries online. Make sure you have enough memory space though, because the charting library you use must be stored on a separate data sheet.
You will be able to see if you are making the right chart design decision, just by looking at the chart. So, keep a pencil and paper handy. Write down the date you made the chart and what you were doing while you were creating it. That’s the only way you can get a feel for what the chart looks like when finished.
Now that you have the chart in your hands, how will you take care of it? This is another big key to mastering Excel spreadsheet skills. In fact, this is the basis of mastering Excel skills, how to work with a charting library. You need to understand how to change the chart, how to add and delete data, and how to adjust the chart. Charting libraries make these tasks so easy and so convenient.
You need to understand the basics of how to make charts in Excel. Excel is a tool and tools have many uses. When you want to learn Excel spreadsheet skills, start by learning the spreadsheets.