• No products in the basket.

  • LOGIN

Login

  • 0 Students

  • Certified

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

Training 10 or more people?

Get your team access to 3,000+ top courses anytime, anywhere.

Try One Education Business

 width=

 

Certifications

Get accredited certificates

New skills

Add skills to your CV

Exams

Test your skills

Dedicated Support

For any questions

Set your own speed

Self-paced learning

Save your money

Monthly subscription

COPYRIGHT © 2022 One Education

0
Your Cart
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]