About This Course
Course Curriculum
-
Module 01: Introduction to Reception and Receptionist00:29:00
-
Module 02: Business Telephone Skills00:21:00
-
Module 03: Representing Your Boss and Company00:25:00
-
Module 04: Mail Services and Shipping00:26:00
-
Module 05: Travel Arrangements00:22:00
-
Module 06: Organising Meeting and Conferences00:19:00
-
Module 07: Time Management00:25:00
-
Module 08: Record Keeping and Filing Systems00:24:00
-
Module 09: Business Writing Skills00:25:00
-
Module 10 :Organisational Skills00:19:00
-
Module 11: Communication Skills00:19:00
-
Module 12: Customer Service00:22:00
-
Module 13: Effective Planning and Scheduling00:39:00
-
Module 14: Invoicing/Petty Cash00:20:00
-
Module 15: Business Environment00:19:00
-
How to Get the most of the course00:01:00
-
Text formulas in Excel00:08:00
-
Text Formulas Exercise00:01:00
-
Text Formulas Exercise (answers)00:01:00
-
Mathematical Formulas In Excel00:04:00
-
Mathematical Formulas Exercise00:01:00
-
Mathematical Formulas Exercise (answers)00:01:00
-
Date and Time Formulas In Excel00:06:00
-
Date and Time Formulas Exercise00:01:00
-
Date and Time Exercise Formulas (answers)00:01:00
-
Logic Formulas In Excel00:12:00
-
Logic Formula Exercise00:01:00
-
Logic Formula Exercise (answers)00:01:00
-
Financial Formula In Excel00:06:00
-
Financial Formula Exercise00:01:00
-
Financial Formula Exercise (answers)00:02:00
-
Informational Formula In Excel00:04:00
-
Informational Formula Exercise00:01:00
-
Informational Formula Exercise (answers)00:01:00
-
Getting Traffic To Your Site01:00:00
-
Menu Example with Excel Vlookup00:08:00
-
Wildcard Search with Excel Vlookup00:09:00
-
Looking to the Left with Excel Vlookup00:17:00
-
2-Way Lookup00:14:00
-
Comparing Lists with Excel Vlookup00:03:00
-
Microsoft Excel Vlookup Tips and Tricks00:14:00
-
Power Query Intro and Excel version00:03:00
-
Excel Power Query – Introduction00:03:00
-
Enabling M in Power Query00:02:00
-
Transform Data – Trim in Excel Power Query00:05:00
-
Transform Data – Format Dates and Values in Excel Power Query00:02:00
-
Simple Expressions00:08:00
-
Simple Expressions – Nested Expressions00:03:00
-
Transform Data – Parsing URLs in Excel Power Query00:05:00
-
Variables00:08:00
-
Formatting Excel Keyboard Shortcuts00:02:00
-
Table Excel Keyboard Shortcuts00:02:00
-
Editing Excel Keyboard Shortcuts00:05:00
-
Formula Excel Keyboard Shortcuts00:03:00
-
Workbook Excel Keyboard Shortcuts00:02:00
-
Handy Excel Shortcuts Keyboard Shortcuts00:05:00
-
Mock Exam – Office Admin & Receptionist – Level 700:20:00
-
Final Exam – Office Admin & Receptionist – Level 700:20:00
-
Assignment – Office Admin & Receptionist – Level 710:24:00