Gain a thorough understanding of Microsoft Excel, data collection and data management techniques. Learn to enter data and create formulas to analyze and present complex information. These skills are essential in data analysis, business intelligence, management and engineering. Using actual mobility data, this course will cover concepts from Excel and the Excel course certification exam. Additional topics show the relationship of XML with Microsoft Excel, including importing, mapping schema and exporting content. Finally, visualization of the data is taught using Power BI, where you will learn how to query data, transform dates and text, create and publish reports.
