Home
What's new
Latest activity
Authors
Store
Latest reviews
Search products
Forums
New posts
Search forums
What's new
New posts
New listings
New products
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
Cart
Cart
Loading…
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Change style
Contact us
Close Menu
Forums
SVTPerformance's Chain of Restaurants
Road Side Pub
Learning Excel
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Voltwings" data-source="post: 15586201" data-attributes="member: 155561"><p>I work with a lot of old people who use Excel as a data entry tool, and not a data "manipulation," or "calculation" tool. I have cut HOURS out of my co workers days by teaching them to automate simple tasks. </p><p></p><p>My biggest advice:</p><p></p><p>1. Automate everything you can. This not only helps with speed, be precision. Every single point of human interaction, is a point of failure. For example, don't type things if they can be copied or referenced to prevent typing in a wrong number. </p><p></p><p>2. Don't hard code anything. If you leave your spreadsheet as mostly formulas, it is an organic sheet that can be changed very easily. If you calculate a number by hand and then just type that number into a cell, you are stuck with exactly that number. If you let excel do the calculations and keep them in your sheet, you have the ability to quickly and easily change things. </p><p></p><p>3. Save templates / color code / leave yourself notes. I build templates as often as possible, what took my co workers 2 hours takes me 10 minutes. I had to put 3-4 hours into building the template the first time, but now i am much more proficient than they are. Color code!!! I always color code my template cells; Cells that are inputs get one color, cells that are outputs (calculated via a formula) get another... And lastly, make notes on all your sheet. If you, or anyone else, needs to come back and use that template after a week, a month, a year... will you remember how to use it? Will they know how to use it? Notes help. </p><p></p><p>4. Lastly, excel lists all available formulas in one of the tabs. Google those formulas and see not only how they work individually, but how they can be stacked. I have been working in excel for about 8 years, and even today i am learning new things and new ways to stack formulas to get what i need done. Just know that damn near anything is possible in excel.</p></blockquote><p></p>
[QUOTE="Voltwings, post: 15586201, member: 155561"] I work with a lot of old people who use Excel as a data entry tool, and not a data "manipulation," or "calculation" tool. I have cut HOURS out of my co workers days by teaching them to automate simple tasks. My biggest advice: 1. Automate everything you can. This not only helps with speed, be precision. Every single point of human interaction, is a point of failure. For example, don't type things if they can be copied or referenced to prevent typing in a wrong number. 2. Don't hard code anything. If you leave your spreadsheet as mostly formulas, it is an organic sheet that can be changed very easily. If you calculate a number by hand and then just type that number into a cell, you are stuck with exactly that number. If you let excel do the calculations and keep them in your sheet, you have the ability to quickly and easily change things. 3. Save templates / color code / leave yourself notes. I build templates as often as possible, what took my co workers 2 hours takes me 10 minutes. I had to put 3-4 hours into building the template the first time, but now i am much more proficient than they are. Color code!!! I always color code my template cells; Cells that are inputs get one color, cells that are outputs (calculated via a formula) get another... And lastly, make notes on all your sheet. If you, or anyone else, needs to come back and use that template after a week, a month, a year... will you remember how to use it? Will they know how to use it? Notes help. 4. Lastly, excel lists all available formulas in one of the tabs. Google those formulas and see not only how they work individually, but how they can be stacked. I have been working in excel for about 8 years, and even today i am learning new things and new ways to stack formulas to get what i need done. Just know that damn near anything is possible in excel. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
SVTPerformance's Chain of Restaurants
Road Side Pub
Learning Excel
Top