No products in the cart.
EXTENDED OFFER ENDS INMicrosoft Excel Advanced Training 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 Microsoft Excel Advanced Training 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 9 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:
- 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
- numeracy and IT
- Desire for entrepreneurship
- over the age of 16.
Assessment
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.
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
| Welcome To The Course | |||
| Welcome | 00:02:00 | ||
| Project 1 - Creating A Data Entry Screen To populate Multiple Template | |||
| Proof Of Concept | 00:05:00 | ||
| Planning Ahead | 00:02:00 | ||
| Creating Our Data Entry Screen | 00:04:00 | ||
| (Custom) Formatting Dates And Time | 00:06:00 | ||
| Simple Calculations With Time | 00:03:00 | ||
| More (Useful) Calculations With Time | 00:08:00 | ||
| It’s About Time (And Dates) | 00:08:00 | ||
| Adding With Time | 00:04:00 | ||
| Creating A Template From An Image | 00:12:00 | ||
| Importing A Template From An Existing Excel File | 00:02:00 | ||
| Converting Time To A Decimal | 00:06:00 | ||
| A Little Bit Of Simple Data Entry | 00:03:00 | ||
| Simple Conditional Formatting For A Cleaner View | 00:05:00 | ||
| Calculating Time Out Of House Using Travel Time | 00:05:00 | ||
| Simple Logical Testing And Nested Logical Testing | 00:08:00 | ||
| Building Text Strings With A Formula | 00:12:00 | ||
| Before We Move OnAccessing The Developer Ribbon | 00:01:00 | ||
| A Tick Box Exercise (Of Sorts) | 00:07:00 | ||
| Auto-populating Check Boxes | 00:12:00 | ||
| PRACTICE EXERCISE 1 – Time To Add A New Entry | 00:02:00 | ||
| Defining A Working Area, And Protecting Your Work | 00:05:00 | ||
| PRACTICE EXERCISE 2 – Set Up A Working Area, And Limit User Entry | 00:01:00 | ||
| Project 2 - Building A Database With Excel | |||
| Simple VLOOKUPs | 00:04:00 | ||
| Step 1 – Get Some Data In, And Split It | 00:04:00 | ||
| Using Data Validation To Get The Right Input | 00:04:00 | ||
| Let’s Build Our Database! | 00:06:00 | ||
| Importing Data From A Text File | 00:02:00 | ||
| Importing Data From A Word File | 00:03:00 | ||
| Pulling Data From Multiple Sources | 00:03:00 | ||
| Using OTHER Look-Ups To Look Up! | 00:05:00 | ||
| LOOKUP From A LOOKUP With No Intermediary Step | 00:02:00 | ||
| Data Arrays Don’t Have To Start At A1 | 00:03:00 | ||
| Some Common Reasons VLook-Ups Fail | 00:06:00 | ||
| One Inherent Flaw In Vlook Up | 00:01:00 | ||
| POWER USER – A Breakdown Of Looking Up Backwards | 00:07:00 | ||
| POWER USER – The Other Way Of Looking Up Backwards | 00:07:00 | ||
| Backwards Look-Ups In Action | 00:04:00 | ||
| POWER USER – Dealing With Inconsistencies In User Entry | 00:08:00 | ||
| POWER USER – Fuzzy VLOOKUPs | 00:04:00 | ||
| Power User – VLOOKUPs With Multiple Inputs | 00:10:00 | ||
| Power User – Looking Up Multiple Inputs Using An Array Formula | 00:05:00 | ||
| VLOOKUP’s BrotherHLOOKUP | 00:05:00 | ||
| POWER USER – The Holy Grail – How To Return Multiple Values From A Single Look Up | 00:14:00 | ||
| What To Look For When THAT Formula Didn’t Work | 00:04:00 | ||
| The Fastest Way To Modify Your Column Numbers | 00:07:00 | ||
| POWER USER – Vlook-Ups With Moving Columns | 00:03:00 | ||
| Putting It All Together | 00:10:00 | ||
| The Finishing Touch – How Many Records Did I Find | 00:04:00 | ||
| Project 3 - Named Ranges | |||
| A Simple Static Named Range Using A Single Cell | 00:04:00 | ||
| Creating A Named Range Using A Range Of Cells | 00:03:00 | ||
| Using Row Labels To Name Multiple Ranges | 00:03:00 | ||
| POWER USER – A Magic Trick Using Row And Column Labels | 00:05:00 | ||
| POWER USER – Dynamic Named Ranges | 00:08:00 | ||
| POWER USER – What To Do With Dynamic Names Ranges With Titles | 00:05:00 | ||
| 3035 – POWER USER – Dynamic Charts | 00:10:00 | ||
| 3040 – Horizontal Dynamic Named Ranges For Charts | 00:11:00 | ||
| Project 4 - What Can I have For Dinner? | |||
| What This Project is ACTUALLY Used For! | 00:01:00 | ||
| Hyperlinking To A Different Sheet In The Same Workbook | 00:04:00 | ||
| Creating Our First Macro | 00:06:00 | ||
| Assigning A Macro To A Button | 00:04:00 | ||
| Creating A List For Our Dropdown Using A Dynamic Named Range | 00:02:00 | ||
| Using A Conditional Format To Know When A Value Is Missing | 00:05:00 | ||
| Copying Conditional Formats And Creating Our Drop-Downs | 00:03:00 | ||
| Building Our FormulaINDIRECT Function | 00:03:00 | ||
| Building Strings For Indirect Sheet And Cell References | 00:07:00 | ||
| It’s A One Or A Zero | 00:03:00 | ||
| Working The Percentages And Adding Traffic Lights | 00:04:00 | ||
| POWER USER – The HYPERLINK Function (And Problem) | 00:03:00 | ||
| PRACTICE EXERCISE 1 – Fill In The Blanks | 00:01:00 | ||
| PRACTICE EXERCISE 2 – Pretty It Up (With A Macro) | 00:02:00 | ||
| PRACTICE EXERCISE 3 – Create A VLOOKUP Using A Built String With INDIRECT | 00:02:00 | ||
| Project 5 - Using Excel For Gantt Charts....Timelines And Project Plans! | |||
| Creating A Gantt Chart Using A Worksheet | 00:08:00 | ||
| Building The First Part Of Our Logical Test | 00:04:00 | ||
| Multiple Logical Tests At Once Using AND | 00:08:00 | ||
| Conditional FormattingWhere The Magic Happens | 00:06:00 | ||
| Gantt Charts Using The Built In Charting Tools | 00:05:00 | ||
| Gantt Charts With Different Colors For Different Criteria | 00:08:00 | ||
| Bonus Section - Just For Fun | |||
| How I Created Randomly Generated License Plate Numbers! | 00:07:00 | ||
| Student Questions Answered! | |||
| Calls Text Data – Or How To Return a Column Title If Value is 1 | 00:07:00 | ||
| Calls Text Data 2 – This Time Using Text! | 00:09:00 | ||
| Extracting Phone Numbers From A Cell | 00:03:00 | ||
| What Is The CHOOSE Function Really Used For | 00:15:00 | ||
| Casing And Text Functions | 00:07:00 | ||
| Dynamic Charting From A Drop Down | 00:10:00 | ||
| SUMIF With Dynamic Sum Range | 00:06:00 | ||
| VLOOKUPs With Pictures! | 00:05:00 | ||
| Data Validation With Dependent Dropdowns (Dynamic Named Range Workaround) | 00:09:00 | ||
| Kinda A Vlookup From 2 Drop-down Lists | 00:07:00 | ||
| Tiered Pricing | 00:09:00 | ||
| Worksheet Protection | 00:05:00 | ||
| The Middle Name Problemand Solution! | 00:09:00 | ||
| Finding Matches, And Counting Entries | 00:08:00 | ||
| Fee Calculator, or LOOKUPs That Are True, Not False | 00:06:00 | ||
| Resources | |||
| Resources – Microsoft Excel Advanced Training for Teachers | 00:00:00 | ||
Review
COURSE REVIEWS
Related Courses
An Introduction to Risk Assessment
Original price was: £279.£27.99Current price is: £27.99.
Key Principles of DPA
Original price was: £279.£27.99Current price is: £27.99.
School Administrator Certificate Training
Original price was: £279.£27.99Current price is: £27.99.