Microsoft Excel - Excel from Beginner to Advanced

Udemy has a course with Kyle Pew. That's how I got my start. Here's a link.

I did this one on Udemy and highly recommend it - https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/

It covers excel and VBA

I'd second this! I've just taken this course: https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/

Kyle Pew explains everything so clearly and you can find lots of discounts for it/a lot of courses are on sale! Would highly recommend!

I just took the udemy excel beginner to advanced course with Kyle Pew https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/learn/lecture/4754512?start=0#overview

It's an 18h course for ~$15 on sale and it's pretty good. it gets in to VBA towards the end but if you want to get serious about macros specifically, I recommend a lot of practice on your own supplemented with a macro course. There are also a lot of forums discussing macros.

https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/ Says $22 now, guess code expired

Sovina škola srijedom.

Ako je netko zainteresiran za Excel - preporučujem ovaj tečaj.

Ako o excelu znaš samo da ima zelenu tipku - Kyle je genijalan učitelj.

Već sam nekoliko ljudi na njega navukla, jedino treba puno strpljenja. Nema ćupa koji će utjerati sve u tikvu.

It goes down to $10 all the time but I enjoyed and learned a lot from this video series

I'd recommend this course by Kyle Pew

Areas of focus for Data Analysis in Excel are Pivot Tables, Pivot Chart(or just regular charts), Power Query/Power Pivot.

​

For the specific topics mentioned, Kyle Pew's course covers them. Chris Dutton (Maven Analytics) also has courses that cover those topics specifically.

Hi friend! First of all, echoing everyone's sentiment here that you should not feel ashamed/embarrassed whatsoever. Everyone's journey is unique and special, and no matter what you are still capable of great things.

I saw a lot of people give excellent advice on becoming a bookkeeper, receptionist, etc. and that you are relatively unfamiliar with Microsoft Office products - I was just looking around at some places you can learn excel online and saw that Udemy has a highly rated excel course that's been taken by hundreds of thousands of people. It's usually $150, but they're having a crazy sale where the entire course is $24 only for the next 5 hours. Here is the link. I'll send you a PM too to make sure you see this on time. I work in Finance, specifically in data analysis, so if you have any questions during the course I'm happy to help.

You have a whole family of Redditors in your corner supporting you! You got this!

I literally took one just a few months ago. My job uses Excel a lot and I had no idea what a Macro was.

I did this one and I would highly recommend it. The instructor is bearable, which I think is rare.

https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/

It can be kinda slow at times, especially in the beginning, when it's stuff that everyone knows how to do. Most of the time, I just had it up on one screen and I'd do the stuff while watching on another screen. And I played it at 1.25x or 1.5x speed most of the time.

https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/?gbraid=0AAAAADROdO0SaYE3IqFQ11cPVn2rNRvMd&gclid=CjwKCAiAlrSPBhBaEiwAuLSDUFsG3pNkhZO4gJxS0JiywAHkgPPEehpOAkfc8cbzWdYgq3TR4aCzLhoCHqwQAvD_BwE&matchtype=b&utm_campaign=Excel_v.PROF_la.EN_cc.US_ti.6730&utm_content=deal4584&utm_medium=udemyads&utm_source=adwords&utm_term=._ag_83365030761.ad_532069958139.kw%2Bexcel+%2Bclasses_.de_m.dm__._pl__._ti_kwd-317569860363.li_9028613.pd__.

To learn, it has to be real to you. If the point of Excel seems irrelevant and unrelated to what you need to know, you won't retain anything. It has to matter to you in some practical, useful way where you can see the value in it.

That said, courses can be tremendously helpful is structured well. 3 years ago my Excel skills were very poor. I missed a promotion and lack of ability at Excel/Sheets was in my feedback. I normally filter Udemy only to show the free courses, but I did actually pay (about 9 euros at the time) for this Excel Beginner To Advanced by Kyle Pew. It's the best money I've ever spent. The same promotion came up again 5 months later and I got it, where I was told how they were impressed that I took their last feedback and really worked on it. Since then I've changed to better job roles twice and both needed the skills I learned here - I'd have been nowhere without that course.

That was just my upward learning curve as it's a course that does not assume any prior knowledge where you can start from any point and you have access to the videos to repeat anything you like. The structure was key though, for me. I know there is great free tuition you can find on YouTube but I needed a logical structure and order of learning which I got here. I suppose you could look at that course order then learn the points by looking up free videos on each subject. I just wanted the consistency of the same tutor and for not too much money it's been so valuable.

Once you get the basics then you learn other Excel stuff by Google searches and keeping up with the occasional update. I would recommend Leila Gharani who's already been mentioned, her YouTube channel is great for updated learning and solving common problems.

https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/

This is the one I used to refresh my memory after being away from it for 10+ years. It starts from zero. Open a browser in private mode before visiting the link and you'll get the course cheaper.

I found this course to be useful for an Excel beginner, and this course for more advanced usage.

Best of luck to you!

To add to this, Udemy is a good site to locate training material. I purchased an Excel Beginner to Expert course on sale for $20 once (standard is $140) and it heavily improved my skill set.

udemy.com offers courses, never pay full price cause the run sales constantly but you can find a course for under $20 usually.

​

Edit: This is the one I am taking currently https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/

The field is reporting and analytics. The position can be Data Analyst, Business Intelligence (BI) developer. Research those terms. PowerBI has a free version that can be used to learn.

If you're completely new to all of this. Start with Excel. Learn what can excel be used for. After that move onto PowerBI. You'll learn how to import data, setting up relationships between datasets and then visualize them. After you've done all of this, you should be able to build some basic reports. Keep studying these two to pick up more advanced skills.

https://www.udemy.com/course/microsoft-power-bi-up-running-with-power-bi-desktop/

https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/

Udemy course: https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/?gclid=Cj0KCQiA4L2BBhCvARIsAO0SBdZIO_KmwhNTfQ7xL7o6Ti9pIYBkZ1NfrVkKdsO7wUu5451_I9TLCaoaAgdQEALw_wcB&matchtype=e&utm_campaign=Excel_v.PROF_la.EN_cc.US_ti.6730&utm_content=deal4584&utm_medium=udemyads&utm_source=adwords&utm_term=._ag_83365032161.ad_463021107049.kw_microsoft+excel+certification.de_m.dm__._pl__._ti_kwd-301241003.li_9026835.pd__.

You can also get certified in Excel if you want:

https://docs.microsoft.com/en-us/learn/certifications/mos-excel-2019/

I'm doing an excel course on Udemy from this guy Kyle Pew who is a microsoft certified teacher (whatever that means), it's basically Excel 101, 102, 103, and then VBA and Macros. I took a few free courses, but this one blew the other ones away, for me at least. I got in on sale for 9.99, I think right now it's less than $20.

I have the Microsoft Word paid for and lined up next from the same guy. If you have a question, like I did already, he literally emails you back within a day. You do get a certificate when you finish, I don't know how useful it actually is, but I really am learning a lot.

All of this is because I enrolled in my local state college, which has an Associates degree in Accounting program totally online, 2 years full time, which will cost me nothing according to my FAFSA. So I'm just trying to prepare myself for that. I'm in my late 40's and am sick of working retail my whole life.

I was a fresh graduated last year so I understand you completely

Here are the tips that helped me:

1. Basic design skills, e.g. Photoshop or PowerPoint design. For me presentation's design was the most useful because it's literally the language of business now. I watched Visme YouTube channel first https://www.youtube.com/channel/UC2isRzoZisjBS6PaGWTDV0Q and then took online course PowerPoint101 by Visiotale https://www.visiotale.com/. Definitely recommend it.

2. Google Analytics and data analytics in general. I signed up for the free Google Academy course https://analytics.google.com/analytics/academy/course/ – very nice and easy

3. Excel and PowerBI. These two are still complicated for me but they are essential hard skills nowadays. I took mine on Udemy https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/

I was a fresh graduated last year so I understand you completely

Here are the tips that helped me:

1. Basic design skills, e.g. Photoshop or PowerPoint design. For me presentation's design was the most useful because it's literally the language of business now. I watched Visme YouTube channel first https://www.youtube.com/channel/UC2isRzoZisjBS6PaGWTDV0Q and then took online course PowerPoint101 by Visiotale https://www.visiotale.com/. Definitely recommend it.

2. Google Analytics and data analytics in general. I signed up for the free Google Academy course https://analytics.google.com/analytics/academy/course/ – very nice and easy

3. Excel and PowerBI. These two are still complicated for me but they are essential hard skills nowadays. I took mine on Udemy https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/