1065 Logic courses in Liverpool delivered Online

Embark on an exhilarating journey into game development with our cutting-edge course: 'Coroutines in Unity 3D Masterclass.' Delve into the intricate world of Unity 3D as we unravel the mysteries behind coroutines, a powerful tool in game development. We'll guide you through each section through a fusion of theoretical understanding and hands-on practice, transforming you from a novice into a proficient game developer. In the opening chapters, we lay the groundwork with a comprehensive introduction, setting the stage for your immersive learning experience. From there, we seamlessly transition into mastering the basics, ensuring you have a solid foundation to build upon. As you progress, you'll witness the magic of coroutines come to life, from creating captivating UI animations to constructing an enthralling idle clicker game. We don't stop there; our bonus section provides a tantalising glimpse into state machine examples, further enhancing your expertise. Learning Outcomes: Acquire a deep understanding of coroutines in Unity 3D. Master the basics of game development within the Unity environment. Build dynamic UI animations and enhance game menus with finesse. Construct a fully functional idle clicker game showcasing your newfound skills. Expand your knowledge with bonus state machine examples, elevating your game development prowess. Why buy this Coroutines in Unity 3D Masterclass? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Coroutines in Unity 3D Masterclass there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? Aspiring game developers eager to enhance their Unity skills. Students with a passion for immersive, interactive experiences. Professionals seeking to augment their game development toolkit. Enthusiasts interested in exploring the intricacies of coroutines in Unity 3D. Individuals keen on mastering UI animation and game menu design. Prerequisites This Coroutines in Unity 3D Masterclass does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Coroutines in Unity 3D Masterclass was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Game Developer: £25,000 - £45,000 Per Annum Unity Developer: £30,000 - £50,000 Per Annum UI/UX Designer (with Unity proficiency): £25,000 - £40,000 Per Annum Indie Game Developer: £20,000 - £60,000 Per Annum Game Programmer: £25,000 - £50,000 Per Annum Software Engineer (specialising in gaming): £30,000 - £55,000 Per Annum Course Curriculum Section 01: Introduction Lecture 01: Course Trailer 00:01:00 Lecture 02: Course Overview 00:03:00 Lecture 03: Useful Visual Studio Extension 00:02:00 Section 02: Basics Lecture 04: Coroutines Introduction 00:09:00 Lecture 05: Yield Instructions 00:03:00 Lecture 06: How To Start And Stop Coroutines 00:07:00 Section 03: Building UI Animator Lecture 07: Driver Introduction 00:04:00 Lecture 08: Driver Playback Direction 00:03:00 Lecture 09: Driver Progress 00:04:00 Lecture 10: Driver Looping 00:05:00 Lecture 11: Driver Callbacks 00:03:00 Lecture 12: Driver Custom Wait Time 00:03:00 Lecture 13: Driver Autostart, Pre-Start and Post-Reset 00:06:00 Lecture 14: Driver Refactoring 00:04:00 Lecture 15: Transform Controller Introduction 00:06:00 Lecture 16: Controller Auto Connect To Driver 00:03:00 Lecture 17: Controller Animate From Value To Value 00:03:00 Lecture 18: Controller Animate In Specific Axes 00:04:00 Lecture 19: Controller Animation Curve Easing 00:06:00 Lecture 20: Controller Refactoring To Abstract Class 00:05:00 Lecture 21: Image Controller 00:04:00 Lecture 22: Canvas Group Controller 00:02:00 Lecture 23: Controller Preview Animation In Editor 00:11:00 Lecture 24: Controller Remote Driver Access 00:11:00 Lecture 25: List Player Part 01 00:14:00 Lecture 26: List Player Part 02 00:11:00 Lecture 27: UI Animator Refactoring And Export 00:04:00 Section 04: Animating Game Menu With UI Animator Lecture 28: Animating Game Menu Part 01 00:12:00 Lecture 29: Animating Game Menu Part 02 00:09:00 Section 05: Building Idle Clicker Game Lecture 30: Game Manager Part 01 00:06:00 Lecture 31: Game Manager Part 02 00:05:00 Lecture 32: Creating Item Data And Item Manager 00:12:00 Lecture 33: On Click Process 00:07:00 Lecture 34: Creating Item Animations 00:05:00 Lecture 35: Item Available Logic 00:06:00 Lecture 36: Item Can Buy Logic 00:08:00 Lecture 37: Item Can Buy Manager Logic 00:07:00 Lecture 38: Finishing Item Prefabs 00:09:00 Lecture 39: Robot Animations 00:10:00 Lecture 40: Cook Progress Manager Part 01 00:08:00 Lecture 41: Cook Progress Manager Part 02 00:05:00 Lecture 42: Start Game Animation 00:06:00 Section 06: Bonus State Machine Example Lecture 43: Project Overview 00:06:00 Lecture 44: Basic State Machine Part 01 00:10:00 Lecture 45: Basic State Machine Part 02 00:07:00 Lecture 46: Adding Animations With Variations 00:10:00 Lecture 47: Optimizing Slow Methods 00:04:00 Resources Resources - Coroutines in Unity 3D Masterclass 00:00:00

Unreal Engine 4: The Complete Beginner's Course teaches you the fundamentals of video game development using Unreal Engine 4. Whether you have prior programming knowledge or not, this course will help you leverage the cutting-edge 3D game design software in developing the video games you always wanted.

You will learn everything you need to know about JavaScript in this course.

From installation and project creation to writing tests with JUnit, Mockito, and Hamcrest, this course will cover all the important concepts that you need to get up and running with unit testing.

Picture yourself as a real-life crime-solving hero, armed not with a cape but with knowledge. This Criminology, Profiling and Forensic Psychology Training course turns you into a detective, solving mysteries and bringing justice where it's needed most. The main issue it tackles? The confusion of unsolved cases. The benefit? You become the solution, with the power to unravel puzzles that leave others puzzled.   Think of crime scenes as puzzles waiting to be solved. This course gives you skills like a secret agent on a mission for truth. It's not just about finding a job; it's about making a difference, bringing closure to families, and being a hero who brings relief to those in need.   This course brings justice closer to you in a world where justice can seem far away. Imagine being the one who makes sense of chaos, using science and psychology to unravel mysteries. The benefit isn't just a certificate; it's the ability to be a force for good, making communities safer. This course turns you into a real-life problem solver and a hero in the fight for justice.   Learning Outcomes Analyse and classify diverse crimes, understanding their societal implications. Demonstrate proficiency in evaluating crime scenes and forensic evidence. Comprehend the psychological factors influencing criminal behaviour and profiling. Apply forensic science principles to investigate and solve criminal cases. Develop a comprehensive understanding of the criminal justice system in England and Wales. Master the phases of criminal profiling, employing scientific methodologies. Assess and provide pragmatic solutions based on offender profiling and investigative advice. Acquire knowledge in victimology, recognising the impact on criminal investigations. Demonstrate metacognitive skills in criminal profiling, enhancing logical and scientific approaches. Apply theoretical concepts to real-world scenarios, honing practical skills in crime resolution.   Who Is This Course For Aspiring Criminal Profilers Law Enforcement Professionals Forensic Science Enthusiasts Psychology Graduates Individuals Pursuing Careers in Criminal Justice   Why Choose This Course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success.   Career Path Forensic Psychologist: £30,000 - £60,000 per year Criminal Profiler: £35,000 - £70,000 per year Crime Scene Investigator: £25,000 - £45,000 per year Victim Support Officer: £20,000 - £35,000 per year Police Officer (with Specialisation): £23,000 - £50,000 per year   Prerequisites This training is crafted by professionals and compatible with PCs, Macs, tablets, and smartphones. Accessible anytime, anywhere with a stable internet connection.   Certification Upon completion, you can demonstrate your knowledge through an MCQ test. After successfully passing, claim your PDF certificate for £4.99. For an original hard copy, additional costs of £8 apply. Course Curriculum Module 01: Introduction to Criminology and Profiling Introduction to Criminology and Profiling 00:23:00 Module 02: Classification of Crime Classification of Crime 00:18:00 Module 03: Violent Crimes Violent Crimes 00:29:00 Module 04: The Crime Scene The Crime Scene 00:30:00 Module 05: Dealing with Crime Dealing with Crime 00:41:00 Module 06: Understanding Criminal Psychology Understanding Criminal Psychology 00:31:00 Module 07: Forensic Science Forensic Science 00:35:00 Module 08: Phases of Profiling Phases of Profiling 00:33:00 Module 09: Criminal Profiling: Science, Logic and Metacognition Criminal Profiling: Science, Logic and Metacognition 00:28:00 Module 10: Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice Module 10: Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice 00:22:00 Module 11: Victimology Module 11: Victimology 00:25:00 Module 12: The Criminal Justice System in England and Wales Module 12: The Criminal Justice System in England and Wales 00:19:00 Recommended Readings Recommended Readings - Criminology, Profiling and Forensic Psychology Training 00:00:00

Duration 4 Days 24 CPD hours This course is intended for The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications. This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases. Prerequisites In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses: AZ-900T00 Microsoft Azure Fundamentals DP-900T00 Microsoft Azure Data Fundamentals 1 - Prepare to maintain SQL databases on Azure Describe Microsoft Intelligent Data Platform roles Understand SQL Server in an Azure virtual machine Design Azure SQL Database for cloud-native applications Explore Azure SQL Database Managed Instance 2 - Deploy IaaS solutions with Azure SQL Explain IaaS options to deploy SQL Server in Azure Understand hybrid scenarios Explore performance and security Explain high availability and disaster recovery options 3 - Deploy PaaS solutions with Azure SQL Explain PaaS options for deploying SQL Server in Azure Explore single SQL database Deploy SQL database elastic pool Understand SQL database hyperscale Examine SQL managed instance Describe SQL Edge 4 - Evaluate strategies for migrating to Azure SQL Understand compatibility level Understand Azure preview features Describe Azure database migration options 5 - Migrate SQL workloads to Azure SQL databases Choose the right SQL Server Instance option in Azure Migrate SQL Server to Azure SQL Database offline Migrate SQL Server to Azure SQL Database online Load and move data to Azure SQL Database 6 - Migrate SQL workloads to Azure Managed Instances Evaluate migration scenarios to SQL Database Managed Instance Migrate to SQL Database Managed Instance Load and Move data to SQL Database Managed Instance 7 - Configure database authentication and authorization Describe Active Directory and Azure Active Directory Describe authentication and identities Describe Security Principals Describe database and object permissions Identify authentication and authorization failures 8 - Protect data in-transit and at rest Explore Transparent Data Encryption Configure server and database firewall rules Explain object encryption and secure enclaves Enable encrypted connections Describe SQL injection Understand Azure Key Vault 9 - Implement compliance controls for sensitive data Explore data classification Explore server and database audit Implement Dynamic Data Masking Implement Row Level security Understand Microsoft Defender for SQL Explore Azure SQL Database Ledger Implement Azure Purview 10 - Describe performance monitoring Describe performance monitoring tools Describe critical performance metrics Establish baseline metrics Explore extended events Describe Azure SQL Insights Explore Query Performance Insight 11 - Configure SQL Server resources for optimal performance Explain how to optimize Azure storage for SQL Server virtual machines Describe virtual machine resizing Optimize database storage Control SQL Server resources 12 - Configure databases for optimal performance Explore database maintenance checks Describe database scoped configuration options Describe automatic tuning Describe intelligent query processing 13 - Explore query performance optimization Understand query plans Explain estimated and actual query plans Describe dynamic management views and functions Explore Query Store Identify problematic query plans Describe blocking and locking 14 - Evaluate performance improvements Describe wait statistics Tune and maintain indexes Understand query hints 15 - Explore performance-based design Describe normalization Choose appropriate data types Design indexes 16 - Automate deployment of database resources Describe deployment models in Azure Automate deployment by using Azure Resource Manager templates and Bicep Automate deployment by using PowerShell Automate deployment by using Azure CLI 17 - Create and manage SQL Agent jobs Create a SQL Server maintenance plan Describe task status notifications 18 - Manage Azure PaaS tasks using automation Explore Elastic jobs Understand Azure Automation Build an automation runbook Automate database workflows by using Logic Apps Monitor automated tasks 19 - Describe high availability and disaster recovery strategies Describe recovery time objective and recovery point objective Explore high availability and disaster recovery options Describe Azure high availability and disaster recovery features for Azure Virtual Machines Describe high availability and disaster recovery options for PaaS deployments Explore an IaaS high availability and disaster recovery solution Describe hybrid solutions 20 - Explore IaaS and PaaS solutions for high availability and disaster recovery Describe failover clusters in Windows Server Configure Always-on availability groups Describe temporal tables in Azure SQL Database Describe active geo-replication for Azure SQL Database Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance 21 - Back up and restore databases Back up and restore SQL Server running on Azure virtual machines Back up a SQL Server virtual machine Back up and restore a database using Azure SQL Database Additional course details: Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-300T00: Administering Microsoft Azure SQL Solutions course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Learning Objectives Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion   Pre-Requisites Intermediate Microsoft Excel training or equivalent experience is recommended.   Description This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code. Course Introduction Introduction 00:03:00 Section 01 Lesson 1-Adding the Developer Toolbar 00:05:00 Lesson 2-Understanding the VBA Editor 00:11:00 Lesson 3-Recording a Macro in Personal 00:10:00 Lesson 4-Understanding the Elements of the VBA Language 00:07:00 Lesson 5-Understanding Methods 00:05:00 Lesson 6-Understanding Comments 00:06:00 Lesson 7-Working with the Range Property and Worksheet Object 00:07:00 Lesson 8-Adding a Macro Button to a Spreadsheet 00:03:00 Lesson 9-Working with the ActiveCell Object 00:02:00 Lesson 10-Working with the Offset Property 00:08:00 Section 02 Lesson 1-Understanding Variables 00:07:00 Lesson 2-Working with Integer Variables 00:03:00 Lesson 3-Understanding Option Explicit 00:05:00 Lesson 4-Working with Other Variable Types 00:07:00 Section 03 Lesson 1-Working with IF Statements 00:04:00 Lesson 2-Working with ELSE 00:03:00 Lesson 3-Working with ELSEIF 00:03:00 Lesson 4-Understanding Conditional Operators 00:06:00 Lesson 5-Working with NOT, AND, and OR 00:07:00 Lesson 6-Working with Nested IF 00:04:00 Lesson 7-Working with Select Case 00:06:00 Lesson 8-Working with WITH and END WITH 00:05:00 Section 04 Lesson 1-Working with Text Strings 00:05:00 Lesson 2-Working with LCASE and UCASE Functions 00:05:00 Lesson 3-Working with LEN and TRIM Functions 00:07:00 Lesson 4-Working with LEFT, RIGHT, and MID Functions 00:07:00 Section 05 Lesson 1-Understanding Loops 00:02:00 Lesson 2-Working with For Next Loops 00:07:00 Lesson 3-Working with For Each Loops 00:06:00 Lesson 4-Working with Cells Property 00:08:00 Lesson 5-Working with Do Until Loops 00:09:00 Lesson 6-Working with Do While Loops 00:05:00 Section 06 Lesson 1-Calling Sub Procedures 00:05:00 Lesson 2-Working with Exit Sub 00:04:00 Lesson 3-Working with Message Boxes 00:08:00 Lesson 4-Working with Input Boxes 00:08:00 Lesson 5-Working with VBA Functions 00:12:00 Lesson 6-Working with Object Variable and Set 00:06:00 Section 07 Lesson 1-Understanding and Creating a User Form 00:08:00 Lesson 2-Adding Controls to a User Form 00:16:00 Lesson 3-Adding Code for a User Form 00:10:00 Lesson 4-Launching a User Form from Excel 00:05:00 Section 08 Lesson 1-Getting Started with Debugging 00:10:00 Lesson 2-Stepping Through Your Code 00:06:00 Lesson 3-Working with Breakpoints 00:03:00 Lesson 4-Working with the Immediate Window 00:05:00 Lesson 5-Working with the Locals Window 00:05:00 Lesson 6-Working with the Err Object 00:06:00 Lesson 7-Getting Help-v2 00:07:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 VBA Expert 00:00:00 Final Exam Final Exam - Excel 365 VBA Expert 00:20:00

Develop an Endless Runner game to get familiar with the interface and game development process while learning how to use Unreal Engine 5. Even if an endless runner game isn't your interest, this course provides the steps necessary to create a video game from start to finish. Explore fundamental concepts about game-making and utilize that knowledge in your future projects.

Level 3 & 5 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Overview Learn how to become an exemplary Receptionist and positively represent your company when interacting with all clients and customers. Every business needs an efficient administrator to manage the Front-Office, along with providing support and assistance to their boss. We can coach you to become an excellent Receptionist and gain all the required business skills that you'll need to succeed, and the confidence with which to use them. Description The course has been compiled by industry experts and provides an overview of the responsibilities of a valued Receptionist. You will be tutored in a wide range of administrative practises, so that you can immediately start to use them in the office. It also includes training in customer-facing etiquette and suggestions on how to positively improve your company's reputation with clients. Various other crucial office aptitudes will be covered, such as; Time Management, Travel Arrangement, Record Keeping, and Business Writing. Make sure you present the efficiency of your company by enrolling now. Learning outcomes:  Understand the basic requirements needed to run receptions areas efficiently Gain the all-round skills to be a first-class Receptionist Learn how to represent your boss and company in reception Be skilled in organising travel and arranging executive meetings for others Attain the ability to file and retrieve essential company records Acquire the skills to apply excellent communicate practises at work Display great customer service for clients and colleagues Be trusted to handle internal finances and petty cash funding Why People Love And Enrol In The Receptionist Skills From Studyhub: Instantly accessible CPD-accredited certificate on successful completion of this Receptionist Skills 24/7 access to the course for 12 months Study at your own pace No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) Efficient assessment and instant results Method of Assessment To assess your learning, you have to participate in an automated multiple-choice question exam. You have to score at least 60% to pass the exam and to qualify for CPD accredited certificates. After passing the exam, you will be able to apply for a certificate. To enhance your knowledge regarding the course and to further assess your learning, you are advised to complete the assignment questions provided at the end of the course, which you can complete anytime you wish.  After submitting the assignment, our expert tutor will assess your assignment and will give you feedback on your performance. Certification After completing the MCQ assessment, you will qualify for the CPD Certificate from Studyhub, as proof of your continued professional development. Certification is available in PDF format, for £9, or a hard copy can be sent to you via post, for just £15. Who is This course for? This course is primarily designed to provide coaching and training for those individuals who aspire to work as Receptionists or a similar role such as a Secretary or PA. Requirements There are no specific prerequisites to enrol in this Receptionist Skills. Anyone and everyone can take this course. The Receptionist Skills is fully accessible from any internet-enabled smart device. So, you can study from the comfort of your home! All you need is a passion for learning, literacy, and to be over the age of 16. Career Path This course provides training and a comprehensive overview of all the skills and knowledge that are needed by a Receptionist or a similar administrative role. As such, it will cover the following roles and careers:  Receptionist Administrative Manager Personal Assistant Private Secretary Human Resources staff Course Curriculum Office Admin and Reception Module 1: Introduction to Reception and Receptionist 00:11:00 Module 2: Business Telephone Skills 00:19:00 Module 3: Representing Your Boss and Company 00:34:00 Module 4: Mail Services and Shipping 00:25:00 Module 5: Travel Arrangements 00:24:00 Module 6: Organising Meeting and Conferences 00:25:00 Module 7: Time Management 00:35:00 Module 8: Record Keeping and Filing Systems 00:28:00 Module 9: Business Writing Skills 00:40:00 Module 10: Organisational Skills 00:25:00 Module 11: Communication Skills 00:25:00 Module 12: Customer Service 00:16:00 Module 13: Effective Planning and Scheduling 00:46:00 Module 14: Invoicing/Petty Cash 00:27:00 Module 15: Business Environment 00:19:00 Advanced MS Excel How to Get the most of the course 00:01:00 Text formulas in Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise (answers) 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise (answers) 00:01:00 Date and Time Formulas In Excel 00:06:00 Date and Time Formulas Exercise 00:01:00 Date and Time Exercise Formulas (answers) 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formula Exercise 00:01:00 Logic Formula Exercise (answers) 00:01:00 Financial Formula In Excel 00:06:00 Financial Formula Exercise 00:01:00 Financial Formula Exercise (answers) 00:02:00 Informational Formula In Excel 00:04:00 Informational Formula Exercise 00:01:00 Informational Formula Exercise (answers) 00:01:00 Getting Traffic To Your Site 01:00:00 Menu Example with Excel Vlookup 00:08:00 Wildcard Search with Excel Vlookup 00:09:00 Looking to the Left with Excel Vlookup 00:17:00 2-Way Lookup 00:14:00 Comparing Lists with Excel Vlookup 00:03:00 Microsoft Excel Vlookup Tips and Tricks 00:14:00 Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Enabling M in Power Query 00:02:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Simple Expressions 00:08:00 Simple Expressions - Nested Expressions 00:03:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Variables 00:08:00 Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Mock Exam Mock Exam - Office Admin and Reception 00:20:00 Final Exam Final Exam - Office Admin and Reception 00:20:00