By Stream Skill | in Online Courses
Microsoft Excel remains one of the best tools for Data Analysis. In this course, you'll learn the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. You'll take a look at raw data, tools, functions, and advanced techniques. This course also includes practice exercises so you can immediately put into practice the new data analysis techniques that you learn.
Important Details
Requirements
By Stream Skill | in Online Courses
This advanced Excel course will look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. You'll first learn how to bring your data together, merge, and clean it using Power Query. You'll then perform calculations on your data model using DAX, and finally, look at displaying your analysis using PivotTables and PivotCharts. This course also includes practice exercises and follow-along files so you can build your data models as you learn.
Important Details
Requirements
By Stream Skill | in Online Courses
In this Advanced PivotTables in Excel course, you'll learn how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel. You'll get a PivotTable refresher and move onto some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting. This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function.
Important Details
Requirements
By Stream Skill | in Online Courses
There is no getting away from it. We now live in a world where data dominates. Decisions in business, government, the economy, which music to listen to or new shows to watch, it's all about data. Happily, there is a growing number of tools to help make sense of the volume of raw data now available. Alteryx is one of those. In this course, you'll get started with the Alteryx Designer and set you on a path to becoming an Alteryx developer. You don't need any previous knowledge of Alteryx to take this course. An intermediate to advanced Excel understanding is useful.
Important Details
Requirements