Subtotal:
£36.49
EXTENDED OFFER ENDS IN
Excel Analytics 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 Analytics 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 02 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:
- This is a dedicated website for teaching
- 24/7 tutor support
- Interactive Content
- Affordable price
- Courses accredited by the UK's top awarding bodies
- 100% online
- Flexible deadline
Entry Requirements
No formal entry requirements. You need to have:
- Passion for learning
- A good understanding of the English language
- Be motivated and hard-working
- Over the age of 16.
Certification
CPD Certification from The Teachers Training
Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.
- You can get your digital certificate (PDF) for £4.99 only
- Hard copy certificates are also available, and you can get one for only £10.99
- You can get both PDF and Hard copy certificates for just £12.99!
The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.
Course Curriculum
| Excel Analytics | |||
| Module 01: Introduction | 00:05:00 | ||
| Module 02: How to Benefit from the Course | 00:02:00 | ||
| Module 03: Download Project Files | 00:07:00 | ||
| Module 04: Exploring Project Data | 00:05:00 | ||
| Module 05: Data Cleaning and Customization | 00:03:00 | ||
| Module 06: Understanding Data Values | 00:04:00 | ||
| Module 07: Date and Time Categorized | 00:00:00 | ||
| Module 08: Combine Date and Time Field | 00:05:00 | ||
| Module 09: Categorize Weather Conditions by Logical Operation | 00:09:00 | ||
| Module 10: Advanced Percentile Calculation | 00:11:00 | ||
| Module 11: Joining Data from Multiple Sources | 00:08:00 | ||
| Module 12: Joining Data by VLOOKUP and MATCH Function | 00:09:00 | ||
| Module 13: Analyzing Trends by COUNTIF Function | 00:09:00 | ||
| Module 14: Create Real Time Data Feed by Free API | 00:06:00 | ||
| Module 15: Extract Realtime Data by Filter XML Function | 00:11:00 | ||
| Module 16: Categorize Realtime Data by VLOOKUP & Conditional Formatting Part 01 | 00:06:00 | ||
| Module 17: Categorize Realtime Data by VLOOKUP & Conditional Formatting Part 02 | 00:06:00 | ||
| Module 18: Generate Dynamic Source Data by INDEX and MATCH Function | 00:06:00 | ||
| Module 19: Build Chart Visualization by TRIGONMETRY Function | 00:07:00 | ||
| Module 20: Formatting Combo Chart Visualization | 00:05:00 | ||
| Module 21: Formatting and Customization Technique Part 1 | 00:07:00 | ||
| Module 22: Formatting and Customization Technique Part 2 | 00:06:00 | ||
| Module 23: Advanced Formatting and Dashboard Design | 00:06:00 | ||
| Module 24: Course Wrap up | 00:06:00 | ||
Review
COURSE REVIEWS
Related Courses
Construction Cost Estimation
£27.99
Recruitment Consultant
£27.99
