• LOGIN
  • No products in the cart.

Excel Crash Course is yet another “Teacher’s Choice” course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Excel Crash Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills.

Consisting of several modules, the course teaches you everything you need to succeed in this profession.

The course can be studied part-time. You can become accredited within 03 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website.

Why Choose Teachers Training

Some of our website features are:

Entry Requirements

No formal entry requirements. You need to have:

Certification

CPD Certification from The Teachers Training

After you have successfully completed your assignment, you will be qualified to apply for a CPD Certification from The Teachers Training. The PDF certificate can be downloaded instantly right after you have completed your course.

  • PDF certificate is completely FREE
  • Hard copy certificates are also available, and you can get one for only £8.99

The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

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
Review

COURSE REVIEWS

Course Reviews

N.A

0
0 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

COPYRIGHT TEACHERS TRAINING