Udemy - Become an Excel Guru
MP4 | Video: 1280x720 | 53 kbps | 48 KHz | Duration: 6 Hours | 820 MB
Genre: eLearning | Language: English | Instructor: Martyn Blythin

Course Description

Everything you need to up-skill yourself or your team in Excel.

Welcome to Become an Excel Guru, where you are going to learn everything you need to know to become an Excel expert. For the last ten years I've been using Excel to build advanced tools and applications in the investment banking and financial services industries.

So, you probably already know the basics of Excel and you use it in your job on a daily basis, and you're looking to learn more about Excel - but how much more?

Excel has a huge variety of tools and functionality, from the simple - like sum and average formulas - to more advanced tools like pivot tables and automation. But the scope of stuff to learn if you want to know EVERYTHING is enormous - for example, there are over 400 different functions you can use. Do you want to learn them all? Didn't think so!

You've probably been looking at 'intermediate' or 'advanced' level courses - but who decides what constitutes those skill levels? Is it just a case of knowing what all the buttons do or is there something deeper?

From over a decade of using, developing and training Excel I've learned that actually, you don't need to know it all to be an expert.

I've split the course into four key modules, which follow a logical progression from raw data to end results:

Module 1: 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 formulas and how to use some fundamental Excel tools like adding styles and dropdown options to cells.

Module 2: The second module is about analysing your data, and most of this module is a deep dive on pivot tables - Excel's easy to use drag and drop data summary tool. We'll cover all kinds of ways to slice and dice your data and really uncover the key trends and insights.

Module 3: This module covers presenting your analysis, with the key focus being on learning how to create great looking management reports and dashboards. You don't have to be a data analyst to reap the benefits of this type of knowledge. Being able to present great analysis in a succinct and informative dashboard is a skill that can really take your career to another level.

Module 4: Finally we'll cover automation in Excel using Microsoft's coding language, VBA. It’s not as techy as you might think, and it's one of the easiest coding languages you can possibly learn. This module will set you on the road to being able to automate away repetitive and boring tasks you do in Excel, and can even help you create totally customized buttons and tools in your spreadsheets for your job or your clients.

I think you'll get a huge amount of value from this course and you will come away with a deep understanding of how to use Excel correctly and with ease.

About this course:

Full, free lifetime access to course materials
All future extra lectures and upgrades are always included for free
Unconditional Udemy 30 day money-back guarantee
Regular free bonuses to improve your skills even more
Now includes 2 comprehensive cheat sheets for your desk or drawer covering all Excel keyboard shortcuts and functions

What are the requirements?

Access to Excel 2013. If you don't have this, Excel 2010 or 2007 for PC will work great with this course, as will Excel 2011 for Mac. Excel 2003 for PC and 2008 for Mac are not suitable for this course.
At least a basic working knowledge of Excel, including things like SUM formulas, entering data, adding sheets etc. If you're not yet at this level, check out my free 'Getting Started with Excel 2013' course.

What am I going to get from this course?

Over 42 lectures and 5.5 hours of content!
1 - Work with data. You will be able to organise, cleanse and enrich data using some of the most useful functions in Excel (such as VLOOKUP, IF, SUMIF and COUNTIF), and you'll be able to apple best practice principles to make the analysis and presentation of your data easy and quick.
2 - Analyse your data. You will be able to use pivot tables and conditional formatting to summarise and interrogate your data. You'll learn advanced pivot table techniques such as summarising using percentages and creating running totals & top ten lists.
3 - Present your data. You will be able to use pivot tables and pivot charts to create great looking and easy to maintain management dashboards. You'll be able to develop new dashboards over and over again using an easy to use template.
4 - Automation. You will be able to automate away some boring or mundane parts of your job using Excel's coding language, VBA. You will be able to run actions on large sets of data in seconds and control how others interact with your spreadsheet.

What is the target audience?

If you have a basic working knowledge of Excel and you're looking to take your skills to the next level, this course will give you everything you need to become an excel guru.

Seed, Share, Gain knowledge || Don't forget to give thumbs up


Any problem with my uploads, or if they need re-seeding, please PM me. Thanks.