MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 39 lectures (2 hour, 57 mins) | Size: 1.16 GB

Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today.

What you'll learn

Understand and Identify the principles of data analysis

Build presentation ready dashboards in Excel

Apply analysis techniques to datasets in Excel

Become adept at using Excel functions and techniques for analysis

Learn how to use Pivot Tables and Pivot Charts to streamline your workflow in Excel

Use effective design principles when creating and presenting data

Learn about Excel's Ubiquity And Strat Importance as a BI Tool

Learn about the Excel Data Model

GeoFLow

Working with External Databases

Integration with Sharepoint

Requirements

Basic experience with Excel functionality

Description

Having a deep practical knowledge of Excel will greatly increase your productivity. You will be seen as a very skilled business data analyst in the organization. And will lead to a much greater opportunities for you.

Excel is the number-one spreadsheet application, with a plethora of capabilities. If you're only using the basic features, you're missing out on a host of features that can benefit your business by uncovering important information hidden within raw data. This Excel Data Analysis course allows you to harness the full power of Excel to do all the heavy lifting for you.

The course, comprised of 3+ hours of video training, guides you through the basic and advanced features of Excel to help you discover the gems hidden inside. From data analysis, to visualization, the course walks you through the steps required to become a superior data analyst.

Who this course is for:

Anyone who wants to learn to apply data analysis techniques using Excel

Anyone who wants to become good at using Excel for data analysis

Anyone who wants to learn the core concepts of data analysis in Excel

Anyone who wants to learn about PowerPivot, Pivot Charts etc..



DOWNLOAD
uploadgig