The course will get yo up and running and using Power Query / Get & Transform with CONFIDENCE!
This must have introductory course covers all of Excel´s must-know features for cleaning up, transforming, consolidating and automating your Excel data and reports.
You will learn Excel features such as the Functions & Formulas, Text to Columns, Find & Remove Duplicates, Go to Special, Excel Tables, Flash Fill and obviously Power Query (Excel 2010 & 2013) and Get & Transform (Excel 2016) and many more Excel tips & keyboard shortcuts!
No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single data cleansing & consolidation tool that is available in Microsoft Excel.
The course is designed for Excel 2010, 2013 or 2016. There are 4 different modules so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies.
In no time you will be able to clean lots of data and report it in a quick and interactive way, learn how to work with various transformation Formulas, create consolidated monthly reports with the press of a button, WOW your boss with stunning Excel visuals and get noticed by top management & prospective employers!
The course is just over 2 hours long so you can become an awesome analyst and advanced Excel user within 1 day!
In this course there are FREE downloadable Excel workbooks for each tutorials so you can follow along & practice what you learn.
We have collectively been helping over 25,000 Udemy students further their professional careers by teaching them Excel the easiest and most comfortable way.
These tutorials will give you career-building skills that you can use to become better and more efficient at your job.
If you really want to stand out from your colleagues and improve your professional development to achieve greater opportunities like promotions, a higher salary, knowledge that you can take to another job, etc....then this course is for YOU!
You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions - and we will answer them personally within the day!
We are so confident that you will get lots of value from this course that you can take it for the full 30 days, download all the workbooks, watch all the videos and apply it to your work to see the results. If you're not 100% satisfied, we will be more than happy to refund the full purchase amount!
So go ahead and learn from the following in depth Excel subjects and click the TAKE THIS COURSE button, top right, NOW... every hour you delay is delaying your professional progress ...
The following Office versions for Windows are supported:
Both 32-bit and 64-bit are supported. Power Query is not compatible with any Mac versions of Excel.
PARSING TEXT (Excel 2010, 2013 & 2016): Splitting data apart when the name, age and email addresses are all in the same cell.
INNER JOIN (Excel 2010, 2013 & 2016): Comparing lists to extract entries that appear on both lists.
UNPIVOT (Excel 2010, 2013 & 2016): Converting a report into raw data so that it's useful for analysis.
CONSOLIDATE MULTIPLE WORKSHEETS (Excel 2010, 2013 & 2016): An easy way to compile data from multiple worksheets.
DATA MODELS (Excel 2013 & 2016): Analyzing multiple data sets as if they're a single data set.
Learn the following Excel Formulas & Functions:
Learn the following Excel analytical tools:
Hello fellow Excel lovers/beginners/experts/users! My name is John and I am a long time lover of Excel.
I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish (and Excel!)
My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials!
My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & more efficient, create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve!
I have taught over 25,000 students on Udemy alone plus more on my website MyExcelOnline. I have an active blog where I post free Excel tutorials as well as an Excel podcast where I interview fellow Excel experts & share their insights!
I am currently living in the North of Spain (Basque Country) and I´m married and have one cheeky boy & a newly born baby girl! You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer.
Join one of my courses and get ready to change your life!
Excel and data have been my life for the past 15 years, and I'm driven by the impact that data has on peoples' lives. I've seen where crap data has resulted in termination warning letters going to the wrong people, a business' marketing efforts completely stopped, a nonprofit's inability to apply for grants for their literacy program, a small manufacturing company guessing about inventory levels.
After tracking down a lot of issues, I eventually realized that the people in the processes weren't incompetent. Instead, the problem was the many ways that data gets corrupt. Thus, I've been on a crusade to bring focus to the importance of data cleansing as a skill.
It's not glamorous. In fact, data cleansing can be thankless and brutal when you have to deal with 9 different misspelling of Albuquerque in your source data or 3 different codes for the same product.
But nothing happens reliably without clean data--no dashboards, no data visualizations, no reports, no paychecks ... no peace, just misery and confusion. People who cleanse data are the stealth warriors for peace from sea to shining sea.
Today, I make fun YouTube tutorials, host workshops and do presentations whenever there's an opportunity to share the knowledge and sound the alarm about cleaning data and ending misery.
Microsoft Excel Most Valuable Professional: 2015, 2016
Author of Guerrilla Data Analysis, 2nd Ed
Former Co-Host on ExcelTV
Resident of Portland, OR after 19 years in Chicago, IL
US Navy Veteran
BA in Philosophy from University of IL-Chicago
Kennedy School of Government at Harvard University
Second City Training Center, Chicago