Have You Already Joined IOMH ?

Fueling your journey to inspire, overcome, and motivate towards a brighter future. Join us today

Don’t have an account yet? Sign Up

Already have an account? Sign In

By signing up, I accept IOMH (Terms & Conditions)

Home
Course
Excel Crash Course

Excel Crash Course

Overview Data analysis is a powerful skill that helps you make better decisions any In business. Excel is a powerful …

Enrolled Students: 0

★ ★ ★ ★ ★

(0 Reviews)

Overview

Data analysis is a powerful skill that helps you make better decisions any In business. Excel is a powerful tool that has become instrumental in business processes worldwide regardless of the industry. It has made analyzing stocks or issuers, budgeting, or organizing much easier with.

The Excel Crash Course is designed to teach learners to make meaningful reports such as Heatmaps, Business invoice reports, and create and manipulate pivot tables. You will be able to make very useful sets of data that are going to help make better managerial decisions for your organizations. Such skills are highly sought after by employers. It can give you the extra edge you need to land yourself your dream job.

The course has been designed from the point of view of a Business Intelligence consultant. The curriculum is based on the skills needed to power through your daily business needs and achieves specific objectives. This course is a hack to develop advanced power-user skills in Microsoft Excel on Office 365 in a very short period of time.

Highlights of the Excel Crash Course

Explore the use of Microsoft Excel from a data science, data visualisation and data analysis perspective
Learn to design three dashboard systems in Excel such as Activity Heatmap, Advanced Currency Converter, Business Invoicing Dashboard
Figure out how to work with Excel time intelligence and text functions to extract hour of the day, day of week etc
Find out how to Manipulate pivot tables to design effective and beautiful charts and heatmap visuals
Create your own custom design pivot charts by adding custom images
Learn the use of Power Query tool to manipulate and mashup data
Use certain tips and tricks to fine-tune your Excel dashboards and visuals to supercharge your data visualisation skills
Expand your data analysis skills by working on data retrieved from Twitter API
Explore to maximize office productivity and increase your salary with automation skills

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

Video lessons
Online study materials

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Why study this course

Whether you’re new to the market or looking to enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The Excel Crash Course is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

Course Curriculum

Analysis of Twitter Dataset and Designing Heatmaps
	Introduction to the Excel crash course	00:06:00
	Understanding the Twitter Dataset	00:05:00
	Extracting Other Details for Analysis	00:09:00
	Creating Pivot Tables	00:08:00
	Applying Conditional Formatting using Color Scales	00:03:00
	Adding Slicers to Dashboard	00:02:00
	Applying Custom Number Formats	00:03:00
	Adding Custom Images to Charts	00:11:00
	Interlude – Data Manipulation Challenge	00:02:00
	Adding Heatmap Legend	00:02:00
	Wrapping Up – Introduction to Open Analytics	00:02:00
Advanced Currency Converter using Dynamic Arrays
	Introduction to Modern Excel Tables and Dynamic Arrays	00:11:00
	Using Power Query for Data Manipulation	00:08:00
	Applying Power Query Data Transformations	00:06:00
	Structured Table Referencing	00:12:00
	XLOOKUP Function and Pivot Table Calculations	00:05:00
Laundry Service Model and Invoicing Dashboard
	Introduction to the Project	00:01:00
	Overview of the Laundry Model Project	00:04:00
	Understanding the Inputs	00:03:00
	Formatting the Input Tables	00:04:00
	Duplicate and Combine Tables with Power Query	00:09:00
	Rounding Digits in Power Query	00:02:00
	Load Specific Tables from Power Query	00:02:00
	Feature Extraction and Named Ranges	00:10:00
	Combining Elements – Data Validation with Named Ranges	00:08:00
	Combining Elements – Understanding the INDIRECT Function	00:02:00
	Combining Elements – Dynamic Drop-down Menu with Data Validation	00:04:00
	Combining Elements – INDEX and MATCH with Multiple Criteria	00:12:00
	Understanding the MATCH Formula with Multiple Criteria	00:06:00
	Business Invoice Dashboard Design	00:06:00