[Udemy #BlackFriday] Business #Data_Analysis with Microsoft Excel

About This Course

 Published 6/2015  English

Course Description

**** Important Notice *********************************

This course took me months to build and I used to charge as high as $250 for it. I am making it free for now because of issue with receiving my Udemy revenue (Paypal and bank issue). 

Ironically, the people who paid for the course gave higher rating than those who didn't pay. Unfortunately, Udemy penalises courses (makes them no longer show up in search results) that are free but rated below 4.1. This will deny people who will benefit from the course from accessing it. Please don't enroll for it if you don't need it and if you feel it's not for you or have suggestions, contact me rather than leaving damaging rating. You can also skip around to aspects that are of interest/value to you. Thanks.

*************************************************************

Microsoft Excel is the world's most used and versatile business analysis, reporting and strategy software. Having a deep practical knowledge of Excel will turn you almost superhuman at work and increase your productivity. You will be seen as a very efficient, highly competent and indispensable partner in the organization's progress. And, hopefully, it will lead to a much greater career role and opportunity for you.

This training is going to focus on making you highly proficient in the use of Excel for business data analysis and reporting the professional way. And most of this would be achieved through lots of samples that will be similar to what you'll need at work.

What are the requirements?

• The training is constantly being updated with new interesting content. The goal is to have the most comprehensive and up-to-date business data analysis with Excel course.
• The training requires having Excel 2010 and above. Excel 2007 will also work but you won't be able to practice the PowerPivot example.
• You also must be ready to practice every topic covered as there are companion practice along Excel files for every topic.

What am I going to get from this course?

• Constantly being updated with new content and covering more areas of business data analysis.
• Be more productive and creative in their use of Microsoft Excel for business and reporting
• Become proficient in using PivotTables for analyzing a large data
• Become proficient in the use of VLOOKUP, HLOOK, LOOKUP to get last item, INDEX and MATCH to make automated dynamic dashboarts/reports.
• Learn how to use Sorting in more advanced ways: multi-level sorting, sorting left to right.
• Learn how to create professional and great looking charts in Excel and understand when to use a particular chart type.
• Learn creative uses of Excel and a lot of keyboard shortcuts that saves analysis time
• Be introduced to Excel VBA, shown how to create a macro by clicking a particular button twice.
• Make a sample Excel VBA userform that gets data from user and input into a table in Excel
• Learn Power BI and other new interesting business data analysis tools by Microsoft

What is the target audience?

• This course is designed mainly for business professionals who use Excel a lot at work. It is built entirely out of my experience teaching over 500 business professionals over the course of two years on Excel, business data analysis and VBA. It focuses on giving you business productivity improving Excel skill and tips using practice files I built to mirror Excel consulting jobs I have done for companies. The course is best suited for people who currently used Excel at work and will benefit from improved Excel skills for reporting, presentation and analysis.
• However, if you seldom use Excel and just want a certificate in Excel for CV purpose, you will find it hard to put in the commitment required to finish this training. You should consider the Microsoft MOS training as it is more ideal for CV building.
• This course is also not for people who want to learn business data analysis but not with Excel. The entire course is Excel based.

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.

Related Post