Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-06-2022, 06:38 AM
zaerth zaerth is offline Why and how are spreadsheets useful for a programmer, and should I learn to use Excel? Windows 11 Why and how are spreadsheets useful for a programmer, and should I learn to use Excel? Office 2019
Banned
Why and how are spreadsheets useful for a programmer, and should I learn to use Excel?
 
Join Date: May 2022
Posts: 1
zaerth is on a distinguished road
Default Why and how are spreadsheets useful for a programmer, and should I learn to use Excel?

I've never had a programming job as I'm still pretty noob and still learning, but it looks like, from what I've read online, a lot of programmers use spreadsheets everyday while working. Why? How do they use them? Should I learn how to use Excel? I only tried them a couple of times for some stupid and trivial things, like creating some tables and stuff like that.



My guess is that they are used to store some data or keep track of various progress and achievements in a project, but I really have no clue. Sorry if it's a stupid question but I can't understand why are spreadsheets so popular in programming jobs.
Reply With Quote
  #2  
Old 05-06-2022, 01:41 PM
BobBridges's Avatar
BobBridges BobBridges is offline Why and how are spreadsheets useful for a programmer, and should I learn to use Excel? Windows 7 64bit Why and how are spreadsheets useful for a programmer, and should I learn to use Excel? Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

LOL. My degree is in Accounting, and when I got that degree there were big computers but no desktops; spreadsheet software was still in the future, and to me "spreadsheet" meant a big piece of paper on which I calculated sums. So I get the question.

Yes, spreadsheet apps like Excel were invented to do calculations, but people quickly began using them for all-text tables as well. At my current client, I work pretty often with a set of Audit findings in an Excel workbook; each finding is on a row, and in each column are values such as the date it was first submitted to management, a short title, a short description, a long description, the department responsible for addressing it, the person assigned to fix it, the target date for its resolution, the current status and no doubt other values I've currently mislaid. As progress is made on the task, folks update the descriptions and dates and the details listed in the Status column. Excel has lots of font controls, so the text can be not only in your chosen font but made larger, bold, certain parts underlined, colored or set in special borders and so on. You can set a date in one column automatically to be (say) 60 days after a date in another column, so if you update one date the others that depend on it follow it automatically. You can set up a table in another sheet of (say) employees, with their departments, phone numbers and email addresses, so that when you assign a person to a task Excel can automatically look up the phone and address for that person and add it to the same cell.

Excel also does business graphs; feed it a table of numbers and it can more or less automatically create a bar graph, a pie chart or whatever your boss wants. (I say "more or less" because you still have to set up the legend and define the axis labels, details like that.) It does a ton of other stuff that I never use, as well; Excel is a pretty big world to itself. And whatever you think of it, you will discover that your coworkers use it and will be surprised you don't. I'll add, though, that the rudiments are not difficult to learn, and most of your coworkers progress no further than the rudiments.

Since you're asking this on the Excel programming forum, though, maybe you're really asking whether you should learn to program in Excel. People pay me to do that, so I consider it worthwhile—and I confess that I love programming, so I'm biased. But it's pretty handy for a client to be able to push a button and get two hundred workbooks which Excel then emails automatically each to its proper recipient. Of course that takes time. But consider how much more time would be needed to do it manually.

I have a time sheet I use to track the hours I charge to my clients. Using Excel programming I've taught it to respond to certain "events": When I double-click on a cell in one column and a new row it automatically copies the client code from the previous row and fills in today's date and the current time to start working. Click on another cell and it fills in a stop time for the previous task and the start time for the next task. Saves me some typing, and (more importantly) typos that might lead to my over- or undercharging a client. Another worksheet sums up the hours I worked for one particular client on a daily basis; another sheet helps me keep track of that client's invoices.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how long do you think it normally takes to learn Excel, from begginer to advanced? kyojim Excel 3 04-25-2022 12:54 PM
Excel stuttering and lagging when scrolling through spreadsheets zi3943 Excel 0 11-19-2018 08:37 PM
HELP - comparing spreadsheets in excel 2010 ali212006 Excel 1 04-03-2014 04:04 AM
Why and how are spreadsheets useful for a programmer, and should I learn to use Excel? Odd Excel problem when 2010 spreadsheets uchacker11 Excel 1 08-01-2011 04:24 AM
Why and how are spreadsheets useful for a programmer, and should I learn to use Excel? Easy questions for VBA programmer regarding Word Templates gurp99 Word VBA 1 06-24-2011 06:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft