Microsoft Excel - Chuyên gia Phân tích Dữ liệu Excel (Chứng nhận)

Microsoft Excel 2024 - Microsoft Excel Data Analysis Expert

Thanks for considering our Microsoft Excel course. There are at least 100 Microsoft Excel courses out there. Why choose our Microsoft Excel course? Because of the following reasons:

• This course does not require any previous knowledge about Microsoft Excel or data analysis.

• This course is designed to be accessibele, regardless of your educational background.   

• We keep this Microsoft Excel course practical. You learn what is required in the job market in the AI driven world.

• We present the Microsoft Excel course based on story telling. 

STRUCTURE

We kickstart this This Microsoft Excel course by a very brief introduction to the inner working of Excel, so if you have never touched Excel, do not worry, we will teach you in a few minutes how the basics work. We immediately continue to the actual meat of this course, which is of course the data analysis skills and statistics. In concrete terms, you will learn:

• Microsoft Excel Essentials: Absolute and relative referencing

• Microsoft Excel Essentials: Freeze panes

• Microsoft Excel Essentials: Graphs

• Microsoft Excel Essentials: Keyboard shortcuts

• Microsoft Excel Essentials: Securing a sheet

• Microsoft Excel Essentials: VLOOKUP

• Microsoft Excel Essentials: Filter Function

• Microsoft Excel Essentials: AND Function

• Microsoft Excel Essentials: (Nested) IF Function

• Microsoft Excel Essentials: Pivot Charts

• Microsoft Excel Essentials: Pivot Tables

• Microsoft Excel Essentials: Dashboard function

• Microsoft Excel Essentials: Dashboard variable choice

• Microsoft Excel Essentials: Dashboard functionality

• Microsoft Excel Essentials: Drop Down Menu

• Microsoft Excel Essentials: Conditional Formatting 

• Microsoft Excel Essentials: Pattern Recognition

• Microsoft Excel Data Analysis: Scenario analysis

• Microsoft Excel Data Analysis: Goal Seek

• Microsoft Excel Data Analysis: Solver

• Microsoft Excel Data Analysis: Standard Deviation

• Microsoft Excel Data Analysis: Normal Distribution

• Microsoft Excel Data Analysis: (Geometric) Mean

• Microsoft Excel Data Analysis: Median And Mode

• Microsoft Excel Data Analysis: Descriptive statistics

• Microsoft Excel Data Analysis: Correlation

• Microsoft Excel Data Analysis: Single OLS Regression

• Microsoft Excel Data Analysis: Non-linear Regression

• Microsoft Excel Data Analysis: Multiple OLS Regression

EXTRAS

*Certificate of completion

*30 day money back guarantee

*Accredited course taught by qualified university lecturers

Note: We have tested this course on a test audience and they had little to no problems keeping up with various versions of Microsoft Excel, such as Microsoft Excel 2016, Microsoft Excel 2019 and the MS Office 365 version.