Data Analysis In Excel for Teachers 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 Data Analysis In Excel for Teachers 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 5 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 features are:
No formal entry requirements. You need to have:
The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.
After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate.
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
You can get both PDF and Hard copy certificate for just £8.99!
The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.
|Modifying a Worksheet|
|Insert, Delete, and Adjust Cells, Columns, and Rows||00:10:00|
|Search for and Replace Data||00:08:00|
|Use Proofing and Research Tools||00:07:00|
|Working with Lists|
|Query Data with Database Functions||00:09:00|
|Outline and Subtotal Data||00:09:00|
|Apply Intermediate Conditional Formatting||00:07:00|
|Apply Advanced Conditional Formatting||00:06:00|
|Visualizing Data with Charts|
|Modify and Format Charts||00:12:00|
|Use Advanced Chart Features||00:13:00|
|Using PivotTables and PivotCharts|
|Create a PivotTable||00:13:00|
|Analyze PivotTable Data||00:12:00|
|Present Data with PivotCharts||00:08:00|
|Filter Data by Using Timelines and Slicers||00:11:00|
|Working with Multiple Worksheets and Workbooks|
|Use Links and External References||00:12:00|
|Use 3-D References||00:06:00|
|Using Lookup Functions and Formula Auditing|
|Use Lookup Functions||00:13:00|
|Watch and Evaluate Formulas||00:09:00|
|Automating Workbook Functionality|
|Apply Data Validation||00:13:00|
|Search for Invalid Data and Formulas with Errors||00:04:00|
|Work with Macros||00:18:00|
|Creating Sparklines and Mapping Data|
|Determine Potential Outcomes Using Data Tables||00:09:00|
|Determine Potential Outcomes Using Scenarios||00:09:00|
|Use the Goal Seek Feature||00:04:00|
|Forecasting Data Trends||00:06:00|
No Reviews found for this course.