The whole purpose of Excel is to make your life easier. This tutorial will help you build foundational skills for working with them. Formulas are at the heart of Excel.
Wednesday, February 22, 2017
How to Manage Your Excel Formulas: Copy, Paste and Autofill
The whole purpose of Excel is to make your life easier. This tutorial will help you build foundational skills for working with them. Formulas are at the heart of Excel.
Subscribe to:
Post Comments (Atom)
2 comments:
Agh yes! I love Excel. I am a bit of a spreadsheet formula nerd, and will go out of my way to create interconnected tabs just to see the information all change because of one cell. I do agree with the article in the fact that Excel should be for anyone, not just accountants. I originally was drawn to it for the ease formatting, then grew to love its calculating capabilities. However, I will say Google Sheets is starting to take more control over these job, not only for its auto-save and sharing abilities, but it has more advanced/comprehensive formulas. Google Sheets' API Query ability is incredible and can allow you to link information in a very complex way with only one formula as opposed to multiple. In addition, Sheets also has a much better "Help" response and can normally have a real person assist you within 24 hours. However, Sheets is still lacking in formatting and display, in my opinion, as compared to Excel. If that were to improve, I think it would be a true landslide. Overall, whether Sheets or Excel, formulas and calculation can be applied to anyone, not just math heavy careers.
Excel is kind of like the galaxy. Just a never ending black hole. Every time you think you know it all find you find out there are 3 million other things that you could have done to finish the job in half the time. I guess the only problem that I have with the program is the fact that they seem to change it every 2 years. Even in my Excel based class we run into problems with the various versions that are in circulation. But like every program there is going to be a problem that arises. As for the article itself I really enjoyed reading about the topic of copy and pasting formulas within the program. If there is one thing that I have learned from taking this class it is that some of your formulas can get really long and having a way to easily move them from one cell to the next as efficiently as possible can be really helpful.
Post a Comment