How to improve my Excel skills for work
A lack of Excel knowledge becomes obvious when a job requires heavy spreadsheet use. Looking things up as they arise eventually stops working, leaving people stuck needing to build a stronger foundation in areas like pivot tables.
What people tried
Every workaround mentioned in the threads below. We haven’t tested any of them — and nobody here is claiming they worked.
Found another way around this?
Share your steps and trade-offs so fellow engineers don't have to reinvent the wheel. No account required.
- 1Asking AI tools to write, explain, or troubleshoot formulasDid this help you?
- 2Watching specialized YouTube tutorial channelsDid this help you?
- 3Focusing on mastering a handful of the most common functions like lookups and pivot tablesDid this help you?
- 4Taking formal community college classes for structured learningDid this help you?
- 5looking things up as they ariseDid this help you?
In their words
Unedited, grouped by where they were said, most upvoted first within each place, each linked to the thread it came from.
“My job needs me to use so much excel and my lack of knowledge really shows.”source ↗
“I am looking to build a better Excel foundation and grow my skills and proficiency, especially with pivot tables.”source ↗
“my Excel skills are not as strong as I'd like them to be.”source ↗
“I've been looking things up as they arise, but I think I have exhausted this.”source ↗
Where this came up
People with this problem also raised
- 7How to deal with coworkers who don't know basic computer skills
- 2Why can't I copy and paste from QuickBooks Excel exports?
- 30Why is accounting software like QuickBooks so bad?
- 7How to learn accounting software without any training
- 11Why built-in software AI features don't fit real work
- 7Why don't students know how files and folders work?