Business Data Analysis with Microsoft Excel

S$30.00
Take This Course
Business Data Analysis with Microsoft Excel

Course Description
Microsoft Excel is the world’s most used and versatile business analysis, reporting and strategy software. Having a deep practical knowledge of Excel will turn you almost superhuman at work and increase your productivity. You will be seen as a very efficient, highly competent and indispensable partner in the organization’s progress. And, hopefully, it will lead to a much greater career role and opportunity for you.

This training is going to focus on making you highly proficient in the use of Excel for business data analysis and reporting the professional way. And most of this would be achieved through lots of samples that will be similar to what you’ll need at work.

What are the requirements?
The training is constantly being updated with new interesting content. The goal is to have the most comprehensive and up-to-date business data analysis with Excel course.
The training requires having Excel 2010 and above. Excel 2007 will also work but you won’t be able to practice the PowerPivot example.
You also must be ready to practice every topic covered as there are companion practice along Excel files for every topic.
What am I going to get from this course?
Constantly being updated with new content and covering more areas of business data analysis.
Be more productive and creative in their use of Microsoft Excel for business and reporting
Become proficient in using PivotTables for analyzing a large data
Become proficient in the use of VLOOKUP, HLOOK, LOOKUP to get last item, INDEX and MATCH to make automated dynamic dashboarts/reports.
Learn how to use Sorting in more advanced ways: multi-level sorting, sorting left to right.
Learn how to create professional and great looking charts in Excel and understand when to use a particular chart type.
Learn creative uses of Excel and a lot of keyboard shortcuts that saves analysis time
Be introduced to Excel VBA, shown how to create a macro by clicking a particular button twice.
Make a sample Excel VBA userform that gets data from user and input into a table in Excel
Learn Power BI and other new interesting business data analysis tools by Microsoft
What is the target audience?
This course is designed mainly for business professionals who use Excel a lot at work. It is built entirely out of my experience teaching over 500 business professionals over the course of two years on Excel, business data analysis and VBA. It focuses on giving you business productivity improving Excel skill and tips using practice files I built to mirror Excel consulting jobs I have done for companies. The course is best suited for people who currently used Excel at work and will benefit from improved Excel skills for reporting, presentation and analysis.
However, if you seldom use Excel and just want a certificate in Excel for CV purpose, you will find it hard to put in the commitment required to finish this training. You should consider the Microsoft MOS training as it is more ideal for CV building.
This course is also not for people who want to learn business data analysis but not with Excel. The entire course is Excel based.

Curriculum

Section 1: Introduction
Introducing the trainer and the course
06:49
Section 2: Data Manipulation in Excel and setting the foundation.
How Excel handles different data types
02:38
Data consistency, starting with the end in view
05:02
Building Datasheets that can scale
04:02
Sorting
04:45
Filtering
02:30
Data Cleaning
07:37
Data Formatting
14:27
Section 3: Charts
Charts
12:58
Section 4: Creative Excel Use and Tips
Creative Excel Features part 1
12:40
Creative Excel Features part 2
11:55
Specials — Creative Excel Use part 1
13:00
Specials — Creative Excel Use part 2
11:18
Special Video — Excel Keyboard Shortcuts part 1
13:15
Special Video — Excel Keyboard Shortcuts part 2
12:55
Section 5: Business Data Analysis
Pivot Table, Pivot Chart and PowerPivot
14:23
Mail Merge
13:25
Business Data Analysis, part 1
11:40
Business Data Analysis, part 2
10:25
Business Data Analysis, part 3
11:05
Business Data Analysis, part 4
11:40
Forecasting using Excel 2016 Forecast tool
04:21
Data Visualization – part 1
11:05
Data Visualization – part 2
10:00
Excel Reports And Presentation
11:11
NamedRange, Goal Seek, Scenario Manager – part 1
19:15
NamedRange, Goal Seek, Scenario Manager – part 2
18:25
Protecting_Workbook_Worksheet_Printing
16:33
Excel Web Query
20:11
Power Excel Functions – part 1
19:10
Power Excel Functions – part 2
14:30
Power Excel Functions – part 3
14:00
Power Excel Function – SUMPRODUCT
10:16
Section 6: Live Session on Advanced Filtering, Custom List, Data Validation, Charts…
Live Session – Part 1 Covering Advanced Filtering in-depth
16:20
Live Session – Part 2 Covering Custom Lists and Data Validation
10:00
Live Session – Part 3 Covering Dynamic Charts
13:30
Live Session – Part 4 Covering Conditional Formating and New Excel Formulas
19:30
Live Session – Part 5 Covering New Excel Charts and Intro to Infographics
14:50
Live Session – Part 6 Covering Questions and Answers
07:25
Section 7: Power BI
Power BI part 1
09:00
Power BI part 2
10:15
Power BI part 3
08:30
Section 8: Excel VBA
Excel Macros
06:48
Userform and more Macros – part 1
18:10
Userform and more Macros – part 2
16:35
Section 9: Difference Between Data Analysis, Business Analysis, BI and Big Data
Data Analysis vs Business Analysis vs Business Intelligence vs Big Data part_1
13:44
Data Analysis vs Business Analysis vs Business Intelligence vs Big Data part_2
08:43
Data Analysis vs Business Analysis vs Business Intelligence vs Big Data part_3
07:38
Data Analysis vs Business Analysis vs Business Intelligence vs Big Data part_4
13:20

Instructor Biography
Michael Olafusi, Microsoft Excel MVP & Business Data Analysis Consultant
Michael is the founder and lead consultant for UrBizEdge, a Microsoft Excel and business data analysis consulting firm. He began his professional career as a Radio Access (RA) Engineer for Nokia Siemens Networks, then as a Business Analyst and MIS Analyst for Comviva — Airtel Africa CRBT operations in 10 countries, and finally as a Service Delivery Lead and Performance Analyst for 21st Century Technologies before resigning to build his own company.

He is addicted to Microsoft Excel, VBA programming and web app development. He loves blogging daily and loves helping people with their Microsoft Excel issues.

Course Features

  • Lectures
    Fatal error: Uncaught Error: Call to undefined method LP_Course::get_lessons() in /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/inc/learnpress-v2-functions.php:624 Stack trace: #0 /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/learnpress-v2/single-course/content-landing.php(64): thim_course_info() #1 /home2/waf6oo0adwwo/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(2492): include('/home2/waf6oo0a...') #2 /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/learnpress-v2/content-single-course.php(65): learn_press_get_template('single-course/c...', Array) #3 /home2/waf6oo0adwwo/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(2492): include('/home2/waf6oo0a...') #4 /home2/waf6oo0adwwo/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(1563): learn_press_get_template('content-single-...') #5 /home2/waf6oo0adwwo/public_html/wp-includes/class-wp-hook.php(286): learn_press_content_single_course('') #6 /home2/waf6oo0adwwo/public_html/wp-i in /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/inc/learnpress-v2-functions.php on line 624