Work with Excel time intelligence and text functions to extract HOUR of DAY, DAY of WEEK etc Students will work on two different datasets - Twitter data and fuel prices data - to design dashboards and extract insights using Pivot tables and beautiful heat maps.Įxplore Microsoft Excel from a data science, data visualisation and data analysis perspectiveĭesign three dashboard systems in Excel - Twitter Activity Heatmap, Advanced Currency Converter, Business Invoicing Dashboard This course is a hack to develop advanced power-user skills in Microsoft Excel on Office 365 in a very short period of time. Supercharge your Microsoft Excel skills rapidly in this Crash Course!Īs a Business Intelligence consultant, I designed the curriculum based on some of the skills needed to get you powering through your daily business needs, and I’ve designed the courses to achieve specific objectives. By working with modern Excel tables and learning how to extract insights from data, you'll achieve a leap in your Excel skills in 3 hours. Maximizing office productivity is a key skill to learn.
This is a 100% project-based Microsoft Excel crash course with a special focus on data analysis, designing simple dashboards and creating heatmap visuals and other charts.
0 kommentar(er)
