What will I learn?
- Use Text, Lookup & Logical Formulas & Functions to pull data out & reorganize it to your desired outcome
- Learn the various Data Analytical tools within Excel to easily find & clean your data such as: Text to Columns, Remove Duplicates, Find & Replace, Go to Special, Text to Columns, Sort & Filter plus much more
- Use Conditional Formatting to find hidden and hard to find data
- Discover the power of Excel Tables to give color and analytical power to your boring lists
- Learn the various techniques within Power Query/Get & Transform to shape your data & consolidate reports without the need to use Formulas or Macros
- Understand in what situations you need to use Excel Formulas v Excel Analytical Tools
Who is this for?
- New users, beginners, intermediates and advanced Excel users
- Professionals working in the corporate world or government sectors who want to leverage Excel for increased productivity, accurate data management and more
- People who want to change career and apply for a new job
- People who work with large volumes of data and want to quickly sift through, analyze, and chart the data in a professional way
- People who prepare reports that require constant updating with new data on a daily/weekly/monthly basis
- Import data into Excel from an external source e.g. ERP System like Oracle, SAP, PeopleSoft, company database, Access, Web etc...and need to quickly & accurately analyze that data and extract valuable information
What are the requirements?
- Compatible with Microsoft Excel 2007, 2010, 2013 or 2016
- Compatible with Excel 2011 & 2016 for Mac
- This course was recorded using Excel 2013 & 2016, so you will get every new feature covered
Course description
This is the ultimate Microsoft Excel Data Cleansing course which has over 70 short and precise tutorials. This course was created by the No1 ranked Excel course author (John Michaloudis) and an Excel MVP & Author (Oz du Soleil)!
The course covers all of Excel´s must-know features for cleaning up and transforming messy data that gets downloaded from an external source. You will learn Excel features such as the Text, Logical and Lookup Functions & Formulas, Text to Columns, Find & Remove Duplicates, Paste Special, Conditional Formatting, Find & Replace, Go to Special, Sort & Filter, Excel Tables, Power Query (get & Transform in 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 analytical tool that is available in Microsoft Excel.
The course is designed for Excel 2007, 2010, 2013 or 2016. There are 23 different chapters 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 lifebusiness 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 4 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 in ther Start & Finished state so you can follow along & practice what you learn. There is also aSPECIAL BONUS video section which shares special Excel techniques taught by an Excel MVP!
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 ...
About Mustapha
I am online instructor at Udemy. My passions are: Mobile and Web Development, Entrepreneurship and Management. You can read my full biography on My Udemy Page. Feel free to follow me social media to know more about me and the topics and courses I'm teaching.
