UDEMY 2021 - Microsoft Excel – Become an Excel Guru
- 1. UDEMY 2021 - Microsoft Excel – Advanced Excel Formulas & Functions
- 2. UDEMY 2021 - Microsoft Excel – Excel from Beginner to Advanced
- 3. UDEMY 2021 - Microsoft Excel – Getting Started With The Basics
- 4. UDEMY 2021 - Inside Excel – Learn 23 Essential Excel Skills the Pros Know
Learn Pivot Tables, Formulas, Charts, Data Analysis, Dashboards, VBA, Macros & More for Excel 2010, 2013 or Excel 2016
What you’ll learn
Learn to analyse large data sets with Pivot Tables
Learn to wow your boss with great looking management dashboards
Here is what students said about this Excel course:
“Love the tips. Best practices quite relevant and to be kept in mind. Also, there are quizzes to test your understanding of the previous lessons as well as links to the lectures for the answers that you missed. I love this course. Highly recommended!”
– Mary J. de Guzman
“This is a really great course. He started at what I would definitely consider an intermediate level–and I even learned some things during that part–and then took us well into the advanced usage of Excel, as promised. Martyn was also very responsive, answering in-depth questions I had, even when they were beyond the scope of the course.”
– Randy Crane
“Thoroughly enjoyed the course as it was very well paced. Bite-sized yet providing clear concise detailed instructions that I could follow the activities in a separate local spreadsheet and learn by doing. Good clarity in speech and good examples help. Martyn also reverts back quickly if you have a question or suggestion.”- Kaushal Vyas
I’ve split course into 4 modules and here is what they cover:
The first module covers working with data in Excel, where you’ll learn all about how to structure your data, clean it and enrich it using Excel formulas and how to get the best out of the Excel tools such as adding styles and dropdown options to cells. It’s the first step on your way of working faster and more effectively!
The second module is all about data analysis in Microsoft Excel. In this module we take a deep dive onExcel pivot tables – a powerful way to slice and dice your data and really uncover the key trends and insights.
Module three covers presenting your data analysis, with the key focus on learning how to create great looking management reports and Excel dashboards. Being able to present data analysis in a succinct Excel dashboard is a skill that can really take your career to another level.
In the final module, we’ll cover Excel VBA, automation in Excel using Microsoft’s coding language sometimes called Excel Macros. One of the easiest coding languages you can possibly learn can help you automate away repetitive and boring tasks you do in Excel.
Are you ready to take your Microsoft Excel skills to the next level?
Course access includes comprehensive workbook with examples, 1-on-1 tutor support, lifetime access and a 100% money-back guarantee!
Who this course is for:
Created by Martyn BlythinLast updated 12/2018EnglishEnglish
Size: 395.81 MB