课程详情

What you will learn
Use Excel tools and functions to clean and prepare data for analysis.
Use Named Ranges and Tables to automate your analysis.
Understand the different types of data in Excel and use appropriate functions to work with them.
Use logical and lookup functions to transform, link and categorise data.
Skills you will gain
Data Analysis
Microsoft Excel
Data Visualization (DataViz)
Data Cleansing
Big Data
power bi
About this Specialization
55,071
recent views
As data becomes the modern currency, so the ability to quickly and accurately analyse data has become of paramount importance. Therefore, data analytics and visualization are two of the most sought after skills for high paying jobs with strong future growth prospects. According to an IBM report, the Excel tools for data analytics and visualization are among the top 10 competencies projected to show double-digit growth in their demand. This course will help you develop your analytical and visualization skills so that you not only improve your current work performance but also expand your future job prospects. For those in business and data analysis who want to master advanced Excel and beginner Power BI , that will add an asset to your employability portfolio. Upon completing this specialization, you will be able to bring data to life using advanced Excel functions, creative visualizations, and powerful automation features. These courses will equip you with a comprehensive set of tools for transforming, linking, and analysing data. You will master a broad range of charts and create stunning interactive dashboards. Finally, you will explore a new dimension in Excel with PowerPivot, Get and Transform, and DAX. Harnessing the power of an underlying database engine, we will remove the 1,048,576 row limitation, completely automate data transformation, create data models to effectively link data, and open the gateway to Power Business Intelligence.
Applied Learning Project
Working with datasets similar to those typically found in a business, you will use powerful Excel tools to wrangle the data into shape, create useful visualizations, and prepare dashboards and report to share your results. You will learn to create a data workflow to automate your analysis and make the results flexible and reproducible.
Shareable Certificate
Shareable Certificate
Earn a Certificate upon completion
100% online courses
100% online courses
Start instantly and learn at your own schedule.
Flexible Schedule
Flexible Schedule
Set and maintain flexible deadlines.
Intermediate Level
Intermediate Level
You should have familiarity with the Excel user interface, moving around an Excel workbook, and creating basic formulas.
Hours to complete
Approximately 4 months to complete
Suggested pace of 3 hours/week
Available languages
English
Subtitles: English, Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, Spanish
Shareable Certificate
Shareable Certificate
Earn a Certificate upon completion
100% online courses
100% online courses
Start instantly and learn at your own schedule.
Flexible Schedule
Flexible Schedule
Set and maintain flexible deadlines.
Intermediate Level
Intermediate Level
You should have familiarity with the Excel user interface, moving around an Excel workbook, and creating basic formulas.
Hours to complete
Approximately 4 months to complete
Suggested pace of 3 hours/week
Available languages
English
Subtitles: English, Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, Spanish

课程标签

0人关注该课程

主题相关的课程