|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Any recommendations for an "Excel function a week" type of list or learning module?
I'd love to be able to not only help get others started on a continuous learning pattern, but learn some things myself that I've not had the opportunity to pick up. Especially the newer functions in Excel 365.
Is there any online resource that kind of breaks down one function at a time, from the seemingly simple (SUM and SUBTOTAL with all their variations - I personally like SUBTOTAL(109,) because coworkers have a tendency to hide rows) to things like LET and FILTER which are newer? |
#2
|
||||
|
||||
While being a good idea, there are tons of sites with these examples on the Net.
If you type e.g. "Subtotal function Excel" in a search engine you will find lots of info. This being said, have a look at the AGGREGATE function instead of SUBTOTAL
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Quote:
I'm at the stage where typically I'm looking for help on one specific function or skill at a time, where I kind of know what I'm trying to do but need context. I was looking for something for someone who only knows how to do the very basics in Excel, and probably won't bite off a whole course. Quote:
|
#4
|
||||
|
||||
Quote:
I would recommend dabbling around in XL forums and have a look around. There are very good ones, not affiliated to MS like excelforum or MrExcel ( they have their pros and contras but are great sources for XL knowledge). Try to solve some simple problems and look at answers from people over there
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
Quote:
Kevin Stratvert's Excel Formulas and Functions has some basics split into chapters (https://www.youtube.com/watch?v=Y8xhrUa3KH4). I may see whether they'll be filling to scroll through the chapters for starters. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro | Matt C | Excel Programming | 2 | 01-08-2022 06:03 AM |
Conditional function to operate a formula based on "Yes" or "No" Condition | Des ONeill | Excel | 1 | 07-03-2021 12:17 AM |
Condtional function to operate a formula based on "Yes" or "No" | Des ONeill | Excel | 3 | 07-03-2021 12:16 AM |
Google "=Filter()" function excel equivalent. | Sadodare | Excel | 0 | 08-01-2016 11:15 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |