I would prefer to use Excel as well but my employer switched to the Google suite a few years ago and only those with really good reasons were allowed to retain Microsoft Office applications. (It’s a bigger issue for those who used Microsoft Project and Visio, since there are limited alternatives.)
Maybe not even that. In summing a column did he use the number themselves or the cell functions? Did he use the + sign or the =SUM( ) function? Or did he add them on a calculator and put that number in the cell?
I hope the OP finds some guides, mild coursework or some appropriate tutelage. I remember spending six hours learning some Excel with a screenshotted tutorial book. It’s proven useful even for me.
I’ve got to give one of the free versions a try soon. I love Excel, maybe because I’m so comfortable with it after so many years, but I’m not sure the fairly basic things I use it for justifies the annual fee.
I hear you. Pretty much anything you might want to do, there’s already an answer out there on the Internet. I am googling stuff constantly. But knowing what to ask is often the hard part.
Don’t be afraid to ask here. No guarantees, obviously, but people get bored and like puzzles. You can post directly from excel here (nothing propriety though) and it’ll format as a table.
Give Google Sheets a go.
Excel light basically. And free.
Excel is much more capable but (made-up number) Google Sheets does about 80% of what Excel does which is plenty for most people.
I much prefer Excel but I gotta say I’ve gotten a lot more mileage out of Google Sheets than I thought possible.
Google sheets does 30% of what Excel does, but 90% of users only ever use a subset of that 30%.
(More made up numbers, I suspect the real numbers are more like 10% and 99%)
I’ve been using Excel for 30+ years, Lotus 1-2-3 for ten years before that and VisiCalc and Supercalc before that.
I like your made-up numbers better. I think they might be closer to reality. (really)
I must warn you, as a software engineer, Excel is my absolute least favourite software (followed by MS Word)
Google sheets, as mentioned above is less nasty, but as I mostly work with SQL, fortunately I rarely need to use it.
OTOH, some people have taken to Excel as an art form! (Link to a fairly ad-heavy site, Mashable)
Why? (really asking)
Personally, I think Excel is one of the best pieces of software out there. It does what it says on the tin and is probably the absolute best spreadsheet software in existence. Not least because it has been in existence longer than almost anything else so the bugs have (largely) been ironed out.
It’s long existence is part of its charm. There are many years of people using it that provide help making support for it about as easy as can be.
I wonder how much of a generation gap there might be here. I’m 40, also a software dev, and grew up learning Excel in middle & high school, then went to college late with younger students. Nobody I know uses Excel anymore, except one older GIS teacher who was generally old fashioned in everything. All of my age peers (like 98%+) have a strong preference for Google Sheets as well. (And the kids younger than that, well, I don’t think they really use desktop computing much at at all; it’s all on their phones and tablets.)
Part of it is that Google Sheets makes collaboration and version tracking much, MUCH easier, which was traditionally a huge pain point with desktop Excel. Having one single spreadsheet that everyone can work on together and is always up to date is a much saner experience than trying to send 10 versions back and forth across 3+ people. That’s super important in team environments, both in school and in the workplace. The Excel 365 online version somewhat alleviates that particular issue, but… I dunno, the Office collaboration experience in general still just feels really clunky and outdated compared to Google Workspace, especially in a workplace environment where stuff is always schizophrenically divided between SharePoint, OneDrive, email, Teams, and Windows network shares. You can never find the same file twice. Google Drive, being cloud-native, does not have this problem… everything is just there, neatly organized by team and folder.
And Google Sheets is totally free and available on every web browser. Excel still requires both a purchase and a download, has only limited functionality on a Mac (it’s a watered down version compared to the Windows one), and isn’t available at all on Linux. The web version is also watered down, both compared to desktop Windows Excel and Google Sheets.
I’ve learned and use both and am probably considered a power user compared to the average user, and I think the feature difference between the two is exaggerated here somewhat. Certainly Excel still has strengths, like certain chart variants and better sparklines and analysis tools and formula tracing and integrations with Access and other Microsoft things. But Sheets also has some of its own strengths, like easier web-based table and data lookup, a SQL like query() function, fantastic regular expression support, a rich scripting system and ecosystem of plug-ins and snippets, etc. Excel offers a lot of that by way of add-ins and tagalongs like Power Query, but for a long long time that wasn’t available on the Mac or Web. Again, a huge hindrance in collaborative team environments, when you can’t guarantee that your recipient/teammate can use all the spreadsheet functions you’ve incorporated.
And in any case, most casual users will never use the advanced features of either one anyway. In my experience, the spreadsheet fluency of the average home or office user never even gets near pivot tables, much less anything more powerful. It’s a glorious day when I see someone even use cross-sheet formulas and named references, and I cry in joy when I see an actual lookup or index/match.
For many database-like use cases, I think software like Airtable.com is a better fit anyway, combining Excel and Access into a simpler to ease (and beautiful) experience.
People try to shoehorn a lot into Excel inappropriately and end up with nested IF()s ten levels deep that’s really hard to read and reason about, when a dead simple database would’ve been better. It’s often just powerful enough for people to shoot themselves in the foot. I say Excel in particular, because that more commonly happens in Microsoft environments when your tools are limited by your IT department’s contracts with Microsoft. Web-based teams generally don’t have that issue and freely mix and match the best tools across vendors to support their needs.
In the end both are more then enough for the typical home user, but Google Sheets is a lot less of a hassle since it doesn’t require a purchase or download. Kinda wins by default there for casual use. And for advanced users, there are legitimate reasons to prefer one over the other. I don’t think there is an automatic winner there. Totally depends on the use case, licensing, integration needs, and of course personal preferences.
Sorry for the tangent, lol. I don’t get to talk about this stuff very much anymore, but I think it’s interesting…
Probably mentioned already, but ChatGPT can be a good source if you have specific technical questions.
LinkedIn has some good courses, too.
Thanks for this response. If Google Sheets will do a few basic functions like Sumif and Large, then it will be good enough for me.
I assume it has sheets within a workbook that can be linked and macros for repetitive calculations?
I honestly don’t think I ever used even 5% of what Excel was capable of doing but it’s a comfortable old friend by now.
Thanks for the modern insight on all this. I’ve been an Office power user since about v1.0. As I ease past newly-retired into “just don’t give a shit about administration”, I find my full-suite Office365 gets less and less use for anything, much less everything.
I’m still kinda locked into Outlook, but have considered how I’d break that too. One of my huge constraints historically was the need to be able to do everything while offline. That is not nearly the actual constraint it used to be, but in my semi-subconscious vetting of options, it’s still checkbox #1 to be checked. I ought to re-evaluate that.
Gmail and Gcal do have offline capabilities (see Use Gmail offline and Use GCal offline), but they’re meant for temporary lack of connectivity, like a few hours’ plane ride or maybe a few days away from the internet at most. It’s not a truly permanent desktop app like the traditional Office and Outlook are. Eventually the browser will evict them from its cache, and some features are outright unavailable unless/until you’re online.
Thunderbird is still around too, which is a real (and free) app that can sync with Gmail & GCal (and Outlook, for that matter).
But, you know… who cares what the kids think? 
You worked hard your whole life, and the least you can do for yourself in retirement is use whatever goddamned office app you want, on Windows XP if you prefer!!
If I were to rank various spreadsheet programs, I’d put Excel January 1, 1900.