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:
No formal entry requirements. You need to have:
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.
|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|
No Reviews found for this course.