Data analysis is a powerful skill that helps you make better decisions any In business. Excel is a powerful tool that has become instrumental in business processes worldwide regardless of the industry. It has made analyzing stocks or issuers, budgeting, or organizing much easier with.
The Excel Crash Course is designed to teach learners to make meaningful reports such as Heatmaps, Business invoice reports, and create and manipulate pivot tables. You will be able to make very useful sets of data that are going to help make better managerial decisions for your organizations. Such skills are highly sought after by employers. It can give you the extra edge you need to land yourself your dream job.
The course has been designed from the point of view of a Business Intelligence consultant. The curriculum is based on the skills needed to power through your daily business needs and achieves specific objectives. This course is a hack to develop advanced power-user skills in Microsoft Excel on Office 365 in a very short period of time.
Highlights of the Excel Crash Course
- Explore the use of Microsoft Excel from a data science, data visualisation and data analysis perspective
- Learn to design three dashboard systems in Excel such as Activity Heatmap, Advanced Currency Converter, Business Invoicing Dashboard
- Figure out how to work with Excel time intelligence and text functions to extract hour of the day, day of week etc
- Find out how to Manipulate pivot tables to design effective and beautiful charts and heatmap visuals
- Create your own custom design pivot charts by adding custom images
- Learn the use of Power Query tool to manipulate and mashup data
- Use certain tips and tricks to fine-tune your Excel dashboards and visuals to supercharge your data visualisation skills
- Expand your data analysis skills by working on data retrieved from Twitter API
- Explore to maximize office productivity and increase your salary with automation skills