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