I am a long time excel user but I haven’t used it a lot in recent years and I never was the best. For example, I can create only the most basic of pivot tables, not to mention formulas (which I know many but have to relearn all the good ones whenever I need them). I saw this big pivot table that was put together by my job the other day and thought if they ever asked me to do one of these things I’ll be screwed lol. I consider myself to be an above average user of computer software in general, just need to upgrade my excel skills significantly.

I want to find a straight forward excel training that isn’t too long but can keep me fresh, or even a longer one that will really help me be an advanced user, or both.

Any suggestions are greatly appreciated!!!

Suggestions for other software or skill sets that would be beneficial in the accounting arena are also welcome! I work in accounting consulting, primarily in the tech industry. I have some quick books online and Microsoft dynamics 365 experience, but have no practical experience in net suite/sage intacct/sap.

Hi guys, i've been wandering in this sub for free online courses that could help me with my problem but have not yet found a full solution. I am a Vice-president at the finance club in my university and we are looking for courses that cover these topics:

- Absolute beginner (Fundamentals, formatting, basic formulas, visualization);
- Intermediate/Advanced (Conditional formatting, tables, advanced formulas, text functions, array formulas);
- Power Queries;
- Introductory VBA.

We need this because we have students with varying backgrounds, from freshman to senior students, students from social studies, engineering, mathematics etc. As we do not have any pre-requirements we need to train these students and be sure that they are above a certain threshold level, this level requires finance knowledge (we already solved this) and the excel knowledge listed above (hoping to solve this here). Things we need to consider:

- We need to have a way to confirm that the students completed the courses;
- We have no money (Brazilian public college);
- The track needs to be auto-sufficient (with no pre-requisites as stated).

So far i have looked at:

- Absolute beginner:

https://www.udemy.com/course/useful-excel-for-beginners/

- Power Query

https://www.edx.org/course/introduction-to-data-analysis-using-excel-3

https://www.edx.org/course/analyzing-and-visualizing-data-with-excel-3

- VBA
https://openeducation.blackboard.com/mooc-catalog/courseDetails/view?course_id=_219_1

But i have only done the edx ones (long time ago) , which i like. So i want to know:
- Recommendations for the advanced excel part (or for any other one).
- Any inputs on the track?;
- Any feedback on the individual courses?.

Reddit and english noob here so sorry for any mistakes in that matter and Thanks in advance guys!