Excel is a powerhouse spreadsheet software used by companies small and large. Master this popular platform by completing the Excel 2016 - Part 3 course from New Horizons. This advanced Excel course builds off learnings from Excel 2016 - Parts 1 & 2 and prepares you to complete difficult Excel tasks such as LOOKUPS, macros and more. The course also covers Microsoft Office Specialist exam objectives to help you prep for the certification exam.
The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.
Power Query is used for ETL(Extract, Transform, Load). That means, data can be extracted from different sources, and after transforming, it can be loaded into the worksheet. It can be said that POWER QUERY is a data cleansing mechanism as it has all the possible options to transform the data. It performs real-time tasks and records all the steps which are performed.
In this course, you will visualize data with Tableau. You will: Identify and configure basic functions of Tableau. Connect to data sources, import data into Tableau, and save Tableau files. Create views and customize data in visualizations. Manage, sort, and group data.
Save and share data sources and workbooks.
Filter data in views.
Customize visualizations with annotations, highlights, and advanced features.
Create and enhance dashboards in Tableau.
Create and enhance stories in Tableau.
This course guides students through the fundamentals of using SPSS Statistics for typical data analysis. Students will learn the basics of reading data, data definition, data modification, data .. analysis, and presentation of analytical results. In addition to the fundamentals, Students will gain an understanding of when and why to use these various techniques and how to apply them with confidence, interpret their output, and graphically display the results.