Udemy

Interactive Data Analysis Report Using Microsoft Excel

Interactive Data Analysis Report Using Microsoft Excel
Free tutorial
Rating: 4.1 out of 5 (120 ratings)
5,538 students
1hr 58min of on-demand video
English
English [Auto]

Apply data analysis TECHNIQUES to database in Microsoft Excel Base on BUSINESS STATEMENT.
Insert formulas to find out the HIDDEN data from the raw database in Microsoft Excel.
Turn real world database into BUSINESS INSIGHTS in Microsoft Excel.
Build INTERACTIVE report presentation in Microsoft Excel.
VBA macro as to prepare you to AUTOMATE the entire Data Analysis process.

Requirements

  • There is no requirement necessary to enrol the course.
  • I will walk thru with you the entire process step by step.

Description

Interactive Data Analysis Report Using Microsoft Excel


Basic Computer Requirements:

1. Microsoft Excel 2010-2019 or Office 365 (ideally for PC/Windows).

2. Basic experience with Excel functionality (formulas, pivot table, pivot chart, power point and outlook will be a plus point).


We'll explore and analysis text and PDF datasets from a number of real-world case studies as follow:

1. Data Analysis Tools Database Analysis (Beginner)

2. Financial Database text Analysis (Intermediate)

3. Construction Database Analysis (Intermediate)

4. Financial Database PDF Analysis (Advanced)

5. Recall Fund Database Analysis (Advanced)


We'll prepare you in 2 VBA Macro training as follow:

1. RPA VBA Macro Auto Task Schedule (Intermediate)

2. Prevent Screen Lock (Intermediate)


We'll share will the future direction upon course completed as follow:

1. Next Step Direction


Who this course is for:

1. ANYONE who works with Microsoft Excel on a regular basis in the work place.

2. Microsoft Excel users who have basic data analysis skills but would like to become more proficient in data exploration and analysis.

3. Students looking for a step by step demonstration for data analysis training approach.

4. Anyone looking to pursue a career in data analysis or business intelligence.


This course compatible with Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Microsoft Excel 2019 or Microsoft Office 365.

Who this course is for:

  • Beginner or existing data analyst that wants to expand their current skills.
  • Anyone who wish to learn with open mind and ready top learn.

Instructor

Management Information Services & Robotic Process Automation
Poon Huangkai Levin
  • 4.1 Instructor Rating
  • 120 Reviews
  • 5,538 Students
  • 1 Course

Hi everyone, my name is Levin and I've taught data analysis (Management Information Services) to countless students and also teach local weekend classes over years.

I'm very fortunate to enjoy the MIS and RPA work that I do, my passion is helping people to learn and apply data analysis in their working environment.

Top companies trust Udemy

Get your team access to Udemy's top 25,000+ courses