We do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life!
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.
Power BI is Microsoft's business intelligence and dashboarding tool that enables organizations to have a wholesome understanding of what is happening at all operational levels of the company. With it you can create reports with drill down features, access-level restrictions, auto-refresh, alerts/triggers and interactivity.
This training is going to focus on making you highly proficient in the use of Excel and Power BI for business data analysis, dashboard creation 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.
This first lecture is an introduction to the course and also introduces me, the trainer.
I will introduce you to sorting in Excel. Talk about the recommended way to sort. Do examples that cover the usual top to bottom sorting, then the left to right sorting, and cascaded sorting.
I will show via a relevant example how to do filtering and the benefits.
- 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 and Power BI 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 will also need Power BI Desktop installed, it is free from Microsoft.
- You also must be ready to practice every topic covered as there are companion practice along files for every topic.