2019 Courses

Duration 4 Days 24 CPD hours This course is intended for This is an introductory-level C++ programming course designed for developers with experience programming in C or other languages. Practical hands-on prior programming experience and knowledge is required. Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in basic coding with C++, coupling the most current, effective techniques with the soundest industry practices. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will learn: Writing procedural programs using C++ Using private, public and protected keywords to control access to class members Defining a class in C++ Writing constructors and destructors Writing classes with const and static class members Overloading operators Implementing polymorphic methods in programs Writing programs using file I/O and string streams Using manipulators and stream flags to format output Using the keyword template to write generic functions and classes Writing programs that use generic classes and functions Writing programs that use algorithms and containers of the Standard Library Apply object-oriented design techniques to real-world programming problems Using algorithms and containers of the Standard Library to manipulate string data Understand how C++ protects the programmer from implementation changes in other modules of an application Using try() blocks to trap exceptions Using catch() blocks to handle exceptions Defining exceptions and using throw to trigger them Introduction to C++ Programming / C++ Essentials is a skills-focused, hands-on C++ training course geared for experienced programmers who need to learn C++ coupled with sounds coding skills and best practices for OO development. Students will leave this course armed with the required skills to put foundation-level C++ programming skills right to work in a practical environment. The central concepts of C++ syntax and style are taught in the context of using object-oriented methods to achieve reusability, adaptability and reliability. Emphasis is placed on the features of C++ that support abstract data types, inheritance, and polymorphism. Students will learn to apply the process of data abstraction and class design. Practical aspects of C++ programming including efficiency, performance, testing, and reliability considerations are stressed throughout. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency Moving from C to C++ (Optional) New Compiler Directives Stream Console I/O Explicit Operators Standard Libraries Data Control Capabilities Handling Data New Declaration Features Initialization and Assignment Enumerated Types The bool Type Constant Storage Pointers to Constant Storage Constant Pointers References Constant Reference Arguments Volatile Data Global Data Functions Function Prototypes and Type Checking Default Function Data Types Function Overloading Problems with Function Overloading Name Resolution Promotions and Conversions Call by Value Reference Declarations Call-by-Reference and Reference Types References in Function Return Constant Argument Types Conversion of Parameters Using Default Initializers Providing Default Arguments Inline Functions Operator Overloading Advantages and Pitfalls of Overloading Member Operator Syntax and Examples Class Assignment Operators Class Equality Operators Non-Member Operator Overloading Member and Non-Member Operator Functions Operator Precedence This Pointer Overloading the Assignment Operator Overloading Caveats Creating and Using Objects Creating Automatic Objects Creating Dynamic Objects Calling Object Methods Constructors Initializing Member consts Initializer List Syntax Allocating Resources in Constructor Destructors Block and Function Scope File and Global Scope Class Scope Scope Resolution Operator :: Using Objects as Arguments Objects as Function Return Values Constant Methods Containment Relationships Dynamic Memory Management Advantages of Dynamic Memory Allocation Static, Automatic, and Heap Memory Free Store Allocation with new and delete Handling Memory Allocation Errors Controlling Object Creation Object Copying and Copy Constructor Automatic Copy Constructor Conversion Constructor Streaming I/O Streams and the iostream Library Built-in Stream Objects Stream Manipulators Stream Methods Input/Output Operators Character Input String Streams Formatted I/O File Stream I/O Overloading Stream Operators Persistent Objects Introduction to Object Concepts The Object Programming Paradigm Object-Orientated Programming Definitions Information Hiding and Encapsulation Separating Interface and Implementation Classes and Instances of Objects Overloaded Objects and Polymorphism Declaring and Defining Classes Components of a Class Class Structure Class Declaration Syntax Member Data Built-in Operations Constructors and Initialization Initialization vs. Assignment Class Type Members Member Functions and Member Accessibility Inline Member Functions Friend Functions Static Members Modifying Access with a Friend Class Templates Purpose of Template Classes Constants in Templates Templates and Inheritance Container Classes Use of Libraries Strings in C++ Character Strings The String Class Operators on Strings Member Functions of the String Class Inheritance Inheritance and Reuse Composition vs. Inheritance Inheritance: Centralized Code Inheritance: Maintenance and Revision Public, Private and Protected Members Redefining Behavior in Derived Classes Designing Extensible Software Systems Syntax for Public Inheritance Use of Common Pointers Constructors and Initialization Inherited Copy Constructors Destructors and Inheritance Public, Protected, Private Inheritance Exceptions Types of Exceptions Trapping and Handling Exceptions Triggering Exceptions Handling Memory Allocation Errors C++ Program Structure Organizing C++ Source Files Integrating C and C++ Projects Using C in C++ Reliability Considerations in C++ Projects Function Prototypes Strong Type Checking Constant Types C++ Access Control Techniques Polymorphism in C++ Definition of Polymorphism Calling Overridden Methods Upcasting Accessing Overridden Methods Virtual Methods and Dynamic Binding Virtual Destructors Abstract Base Classes and Pure Virtual Methods Multiple Inheritance Derivation from Multiple Base Classes Base Class Ambiguities Virtual Inheritance Virtual Base Classes Virtual Base Class Information The Standard Template Library STL Containers Parameters Used in Container Classes The Vector Class STL Algorithms Use of Libraries

Overview This comprehensive course on Internet of Things will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Internet of Things comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Internet of Things. It is available to all students, of all academic backgrounds. Requirements Our Internet of Things is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 15 sections • 65 lectures • 08:53:00 total length •Module 01: Introduction: 00:02:00 •Module 02: Course Agenda: 00:03:00 •Module 01: Introduction to Internet of Things: 00:13:00 •Module 02: Choosing Cloud Services for IoT: 00:05:00 •Module 03: What is Raspberry Pi Part 1?: 00:09:00 •Module 04: What is Raspberry Pi Part 2?: 00:06:00 •Module 01: Downloading OS for Raspberry Pi Noobs-Raspbian: 00:07:00 •Module 02: Install OS using NOOBS: 00:11:00 •Module 03: Remote Control of Raspberry Pi Using VNC Viewer: 00:10:00 •Module 04: Install OS using Raspbian Image part 1: 00:06:00 •Module 05: Install OS using Raspbian Image part 2: 00:02:00 •Module 01: Getting Around Raspbian Operating System part 1: 00:10:00 •Module 02: Getting around Raspbian Operating System part 2: 00:08:00 •Module 03: Getting around Raspbian Operating System part 3: 00:06:00 •Module 04: How To Run Python program On Raspberry Pi: 00:09:00 •Module 01: Raspberry PI GPIO Concepts: 00:07:00 •Module 02: Raspberry Pi GPIO Interfacing Single LED: 00:17:00 •Module 03: Raspberry Pi GPIO Interfacing Multiple LED's: 00:09:00 •Module 04: Rapberry Pi GPIO Interfacing Buzzer: 00:03:00 •Module 01: Raspberry Pi and Transistorized Switching: 00:09:00 •Module 02: Raspberry Pi and Relay part 1: 00:13:00 •Module 03: Raspberry Pi and Relay part 2: 00:08:00 •Module 01: Accepting Digital Input on Raspberry Pi Part 1: 00:13:00 •Module 02: Accepting Digital Inputs on Raspberry Pi Part 2: 00:07:00 •Module 01: Sensor Interfacing With Raspberry Pi LDR1: 00:05:00 •Module 02: Sensor Interfacing With Raspberry Pi LDR 2: 00:10:00 •Module 03: Sensor Interfacing With Raspberry Pi LDR 3: 00:07:00 •Module 04: Sensor Interfacing with Rapberry Pi DHTT11 part 1: 00:10:00 •Module 05: Sensor Interfacing with Rapberry Pi DHTT11 part 2: 00:10:00 •Module 06: Sensor Interfacing with Raspberry pi Using SenseHAT: 00:11:00 •Module 07: Ultrasonic Sensor Interfacing with Raspberry Pi: 00:14:00 •Module 01: BMP180 with Raspberry Pi: 00:07:00 •Module 02: Enabling I2C on Raspberry Pi: 00:05:00 •Module 03: BMP180 Python Code: 00:06:00 •Module 01: Getting Started With IoT: 00:11:00 •Module 02: Getting Started with Microsoft Azure IoT Hub Part 1: 00:04:00 •Module 03: Getting Started with Microsoft Azure IoT Hub Part 2: 00:05:00 •Module 04: Getting Started with Microsoft Azure IoT Hub Part 3: 00:09:00 •Module 05: Create Device inside Azure IoT Hub: 00:06:00 •Module 06: Enable Azure Cloud Shell and enable IoT Extension: 00:08:00 •Module 07: Send Data to Azure IoT Hub Using Python Program: 00:09:00 •Module 08: Send Actual Temperature and Humidity Values to Azure IoT hub: 00:03:00 •Module 09: Storing the Data on Microsoft Azure Using Custom Gateway: 00:13:00 •Module 10: Save data to blob storage using Stream Analytics Job: 00:12:00 •Module 11: Data Visualization with Power BI Part 1: 00:07:00 •Module 12: Data Visualization with Power BI Part 2: 00:12:00 •Module 13: Creating Custom web app with azure for data visualization Part 1: 00:10:00 •Module 14: Creating Custom web app with azure for data visualization Part 2: 00:14:00 •Module 15: Creating Custom web app with azure for data visualization Part 3: 00:12:00 •Module 16: Dealing with password error while pushing your webapp to azure: 00:01:00 •Module 17: Cleaning up Azure Resources: 00:02:00 •Module 18: Remote Monitoring using Azure Logic App Part 1: 00:12:00 •Module 19: Remote Monitoring using Azure Logic App Part 2: 00:10:00 •Module 01: Introduction to Thingspeak: 00:06:00 •Module 02: Create an account and send data to Thingspeak: 00:08:00 •Module 01: Getting started with SaaS IoT Platform io.adafruit.com: 00:08:00 •Module 02: What is MQTT?: 00:10:00 •Module 03: Sending Data to Adafruit Io Using MQTT Part 1: 00:17:00 •Module 04: Sending Data to Adafruit io Using MQTT part 2: 00:14:00 •Module 05: Home automation project with adafruit IO Part 1: 00:15:00 •Module 06: Home Automation Project with Adafruit IO Part 2: 00:02:00 •Module 01: IoT Security: 00:14:00 •Module 02: Conclusion: 00:01:00 •Resources - Internet of Things: 00:00:00 •Assignment - Internet of Things: 00:00:00

Embark on a transformative Python web development journey with this course and dive deep into creating a dynamic book rental system from scratch. Master Django's import-export capabilities, design elegant UI with Tailwind CSS, implement advanced features, and more. Elevate your skills and build real-world applications effortlessly!

Safeguarding Prevent: Safeguarding Prevent Anyone who wants to work in local authorities, schools, colleges, uniformed services, or health and social care must understand safeguarding and the prevention duty, as well as how to incorporate these principles into their daily work practices. This Level 2 Certificate in Understanding Safeguarding and Prevent course will increase your understanding of safeguarding and the Prevent duty, the responsibilities and procedures involved, and how to effectively raise concerns. The Level 2 Certificate in Understanding Safeguarding and Prevent: Safeguarding and Prevent course covers extremism, British values, cyberbullying, and online grooming. Through this Level 2 Certificate in Understanding Safeguarding and Prevent: Safeguarding and Prevent course, you will also learn the meanings of the terms "radicalization," "extremism," and "terrorism," as well as how to effectively comply with the Prevent duty. Why choose this course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the course. Special Offers of this Safeguarding Prevent: Safeguarding Prevent Course: This Safeguarding Prevent: Safeguarding Prevent Course includes a FREE PDF Certificate. Lifetime access to this Safeguarding Prevent: Safeguarding Prevent Course Instant access to this Safeguarding Prevent: Safeguarding Prevent Course 24/7 Support Available to this Safeguarding Prevent: Safeguarding Prevent Course [ Note: Free PDF certificate as soon as completing the Level 2 Certificate in Understanding Safeguarding and Prevent: Safeguarding and Prevent Course] Safeguarding Prevent: Safeguarding Prevent Boost your career with our Level 2 Certificate in Understanding Safeguarding and Prevent: Safeguarding and Prevent. This comprehensive course is designed for those working in local authorities, schools, colleges, uniformed services, or health and social care. Gain in-depth knowledge of safeguarding and the Prevent duty, learning how to integrate these crucial principles into your daily work practices. The curriculum covers extremism, British values, cyberbullying, and online grooming. Master the definitions of radicalization, extremism, and terrorism, and learn how to effectively comply with the Prevent duty. Enhance your ability to raise concerns and fulfill your responsibilities with confidence and expertise. Learning Outcomes Safeguarding Prevent: Safeguarding Prevent After completing this Level 2 Certificate in Understanding Safeguarding and Prevent: Safeguarding and Prevent course, the learner will be able to: Understand the prevent duty. Understand the terms ‘radicalisation, ‘extremism’, and ‘terrorism.’ Understand the term ‘safeguarding.’ Know how to recognise signs of abuse or potential harm. Understand the potential consequences of inappropriate or illegal online activity. Certificate of Completion Safeguarding Prevent: Safeguarding Prevent You will receive a course completion certificate for free as soon as you complete the Level 2 Certificate in Understanding Safeguarding and Prevent: Safeguarding and Prevent course. Who is this course for? Safeguarding Prevent: Safeguarding Prevent This Level 2 Certificate in Understanding Safeguarding and Prevent: Safeguarding and Prevent course is suitable for those who want to better understand safeguarding and the Prevent duty, the responsibilities and procedures involved, and how to raise concerns effectively. Requirements Safeguarding Prevent: Safeguarding Prevent To enrol in this Safeguarding Prevent: Safeguarding Prevent Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Safeguarding Prevent: Safeguarding Prevent Course. Be energetic and self-motivated to complete our Safeguarding Prevent: Safeguarding Prevent Course. Basic computer Skill is required to complete our Safeguarding Prevent: Safeguarding Prevent Course. If you want to enrol in our Safeguarding Prevent: Safeguarding Prevent Course, you must be at least 15 years old. Career path Safeguarding Prevent: Safeguarding Prevent After completing this Level 2 Certificate in Understanding Safeguarding and Prevent: Safeguarding and Prevent course, candidates may pursue a career in: Local Government Administrative Assistant (£17,500 to £24,500) Higher Education Lecturer (£33,000 to £54,000) Social Worker (£24,000 to £40,000)

Equality,Diversity : Equality, Diversity Do you always try to learn new things in order to increase your knowledge and skills? so, you can try out this course on Equality,Diversity : Equality, Diversity. In order to explain the Equality & Diversity component, this specialised Equality,Diversity : Equality,Diversity course has decorated in total 7 different modules. You will be familiar with the objectives of equality & diversity as well as relevant legal framework. This Equality,Diversity : Equality, Diversity training will make your understanding of discrimination and diversity promotion apparent. Establishing connections between values, attitudes, and beliefs is the goal of this equality & diversity course. You will gain a thorough understanding of stereotypes and prejudices by taking t his course on Equality,Diversity : Equality,Diversity. You will learn about institutional and individual discrimination in the final module of the equality & diversity course. If you want to see yourself in productive work, enrol in this Equality,Diversity : Equality & Diversity course right away! Learning Outcome of Equality,Diversity You will know a brief about Equality,Diversity : Equality,Diversity. Gain a brief knowledge about Equality,Diversity : Equality,Diversity Legislation. Equality,Diversity : Equality,Diversity course will give you an idea about Discrimination. You will learn about the connections between values, attitudes, and beliefs in the equality & diversity course. Equality,Diversity : Equality,Diversity course will clear your idea about Stereotypes and Prejudices.. Main Course: Equality and Diversity Free Courses are including with this Equality & Diversity: Equality & Diversity Course Along with The Equality and Diversity: Equality & Diversity Course, We Offer a free Care Certificate Course Along with The Equality and Diversity: Equality & Diversity Course, We Offer a free Health & Social care Course Along with The Equality and Diversity: Equality & Diversity Course, We Offer a free Youth Work Certificate Course Along with The Equality and Diversity: Equality & Diversity Course, We Offer a free Adult Nursing Course Special Offers of this Equality,Diversity Course This Equality,Diversity : Equality,Diversity Course includes a FREE PDF Certificate. Lifetime access to this Equality,Diversity : Equality,Diversity Course Instant access to this Equality,Diversity : Equality,Diversity Course Get FREE Tutor Support to this Equality & Diversity: Equality & Diversity Course Equality & Diversity: Equality & Diversity The Equality, Diversity: Equality, Diversity Course covers discrimination in all of its forms. You will learn about the four primary forms of prejudice in this course on equality and diversity, along with instances. In addition to the Equality Act of 2010, the nine protected features are included in this Equality and Diversity. We will be discussing case studies from the real world of harassment, bullying, and discrimination as our Equality & Diversity course comes to an end. Who is this course for? Equality,Diversity : Equality, Diversity Students, new graduates, and job seekers alike can enrol in this Equality,Diversity : Equality & Diversity course to advance their knowledge and abilities. Requirements Equality,Diversity : Equality, Diversity To enrol in this Equality & Diversity Course, students must fulfil the following requirements. To join in our Equality,Diversity : Equality & Diversity Course, you must have a strong command of the English language. To successfully complete our Equality,Diversity : Equality & Diversity Training Course, you must be self driven. To complete our Equality,Diversity : Equality & Diversity Training Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Equality,Diversity : Equality & Diversity Training Course. Career path Equality,Diversity : Equality, Diversity Courses on Equality,Diversity : Equality & Diversity will enable you to pursue a variety of occupations, including those as an HR professional, a business owner, or in a related field.

Learn how to use this powerful tool to import and clean data and create some amazing visuals. Course overview Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. Objectives  By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Create reports Create different visualisations Create data models Build data relationships Use the drill down features Create measures Use the Power BI Service Build dashboards Use the mobile app Content Essentials Importing Data Power BI Overview Data sources Importing data Transforming Your Data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Creating Reports Creating and saving reports Adding pages Renaming pages Interactivity Refreshing your data Adding Columns Columns from example Custom columns Conditional columns Append Queries Importing folders Setting up and using append queries Creating Chart Visualisations Adding chart elements Choosing chart types Setting properties Setting values, axis and legends Using tooltips Visual filters Setting page and report filters Creating Tables, Cards, Gauges and Maps Adding table elements Adding maps Working with cards Working with matrices KPIs and Gauges Conditional Formatting Setting rules Removing conditional formatting   Working with Data Models Merge Queries Setting up and using merge queries Merging in columns of data Creating a Data Model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Unpivoting Data Working with summary data Unpivoting data Using Hierarchies Using built in hierarchies Drill down Drill up See next level Expand a hierarchy Create a new hierarchy Grouping Grouping text fields Grouping date and number fields Creating Measures DAX functions DAX syntax Creating a new measure Using quick measures Using the PowerBI Service Shared workspaces My workspace Dashboards Reports Datasets Drill down in dashboards Focus mode Using Q&A Refreshing data Using Quick Insights Power BI Mobile App Using the Power BI Mobile App

A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Excel VBA/Macros Foundations 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Excel VBA/Macros Foundations course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00

From planning to executing the whole project, it is a highly stressful and challenging task. Not everyone can fill up this role; however, people who have the ability will find lucrative opportunities in their career journey. Train yourself through the Business and Project Management Diploma course if you want to be in the winning team. This course is designed to provide you with the fundamental skills to thrive in the field of business and project management. The Business and Project Management Diploma course will guide you through the whole process of business and project management. In this engaging course, you will learn about organisational structure design, business process management, business planning, business analysis and more. The easy-to-follow modules will help you attain the essential skills for strategic planning and branding. You will receive training on the fundamentals of project management and grasp the essential skills required for handling projects. This is not the end; this course will also introduce you to the ins and outs of the Six Sigma and Lean. This Business and Project Management Diploma course will be a blessing for your career. It will give you adequate skills and a valuable certificate to boost your career. So enrol now and get a step closer to a brilliant career. Learning Outcomes  Learn how to design the organisational structure Familiarise yourself with the fundamentals of business process management Gain the essential knowledge for business planning and analysis Develop the key skills for strategic planning Understand the techniques of branding Build adequate expertise to manage projects Learn the essentials of Six Sigma and Lean process Enrich your knowledge of project communication and quality management Who is this Course for? Business and Project Management Diploma is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Business and Project Management Diploma is fully compatible with any kind of device. Whether you are using Windows computers, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Assessment At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. Why Choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet, or desktop from anywhere, anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this Business and Project Management Diploma course, you will be able to build up accurate knowledge and skills to pursue a career in the following professions. Project Manager Project coordinator Project consultant Human Resource Manager Office Manager Business Administrator Business Consultant Assistant Manager Business Analyst Introduction to Business Management Designing Your Organizational Structure 00:30:00 Introduction to Operations Management 00:15:00 Understanding Financial Terms 00:30:00 Getting the Right People in Place 00:15:00 Getting Your Product Together 00:15:00 Building a Corporate Brand 00:30:00 Marketing Your Product 01:00:00 Selling Your Product 00:15:00 Planning for the Future 00:15:00 Goal Setting and Goal Getting 00:30:00 Succession Planning 101 00:15:00 Managing Your Money 00:15:00 Ethics 101 00:15:00 Building a Strong Customer Care Team 00:15:00 Training Employees for Success 00:15:00 Leadership Essentials 00:15:00 Business Process Management The Fundamentals of Business Process Management 00:30:00 Defining Business Process Management 00:30:00 The Business Process Life Cycle 00:15:00 Making the Change 00:15:00 The Vision Phase 00:15:00 The Design Phase 01:00:00 How Does It Look? 00:15:00 The Modeling Phase 00:30:00 Execution Phase 00:07:00 The Monitoring Phase 00:30:00 The Optimizing Phase 01:00:00 Business Planning and Analysis Business Planning Basics 01:00:00 Market Evaluation 01:00:00 Analyze Competition 01:00:00 Determine A Marketing Strategy 01:00:00 Decide What Extras You May Need Like Staff etc 00:30:00 The Dangers In Not Making A Business Plan 00:15:00 Strategic Planning Understanding Strategic Planning 00:15:00 Designing Our Vision 00:15:00 On a Mission 00:15:00 Performing a SWOT Analysis 00:15:00 Setting Goals 00:30:00 Assigning Roles, Responsibilities, and Accountabilities 00:30:00 The Full Picture 00:15:00 Gathering Support 00:15:00 Getting There 00:15:00 Lean Process Understanding Lean 00:30:00 The Toyota Production System 00:30:00 The Toyota Production System House 00:15:00 The Five Critical Improvement Concepts 00:15:00 Understanding Value with the Kano Model 00:15:00 Types of Waste 00:15:00 Creating a Lean Enterprise 00:15:00 The Plan, Do, Study, Act (PDSA) Cycle 00:15:00 Using the R-DMAIC-S Model 00:15:00 Lean Thinking Tools 00:15:00 Kaizen Events 00:00:00 Data Gathering and Mapping 00:30:00 A Plan to Take Home 00:15:00 Business Branding Defining Branding 00:15:00 What Are You All About? 00:30:00 Creating a Mission 00:15:00 Creating a Vision of the Future 00:15:00 Positioning Your Brand 00:15:00 Developing Your Style 00:15:00 Developing a Brand Name and Slogan 00:15:00 Creating a Visual Identity 00:30:00 Living Your Brand 00:05:00 Connecting with Customers 00:15:00 Launching Your Brand 00:15:00 Taking Your Brand's Pulse 00:15:00 Performing a SWOT Analysis 00:15:00 Measuring Brand Health with a Balanced Scorecard 00:15:00 Middleton's Brand Matrix 00:15:00 Interpreting Evaluation Results 00:15:00 Keeping the Brand Alive 00:15:00 Going Beyond the Brand 00:15:00 Branding Strategy Defining the Terms 00:30:00 Building Your Social Media Branding Strategy 00:15:00 Identifying Your Social Media Audience 00:15:00 The Key Social Media Platforms 00:30:00 Creating Brand-Focused Messages 00:30:00 Project Management Introduction 01:00:00 Creating a Project Management Methodology 01:00:00 Where Does The Buck Stop? 01:00:00 Can You Manage Yourself Out Of A Paper Bag? 00:30:00 Setting the Stage for a Successful Project 01:00:00 The Importance of Developing and Maintaining A Budget 01:00:00 Taking Action - Execution of the Plan 01:00:00 Your Personality and Project Management Style 01:00:00 The Cycle of Decision Making 01:00:00 Getting Your Project Back On Track 01:00:00 Keep It Moving 01:00:00 Problems and Solutions 01:00:00 Professional Project Management Module One - Getting Started 00:30:00 Module Two - Key Concepts (I) 01:00:00 Module Three - Key Concepts (II) 01:00:00 Module Five - Initiation (II) 01:00:00 Module Six - Planning (I) 01:00:00 Module Seven - Planning (II) 01:00:00 Module Eight - Planning Tools 01:00:00 Module Nine - Executing the Project 01:00:00 Module Ten - Maintaining and Controlling the Project 01:00:00 Module Eleven - Closing Out 01:00:00 Module Twelve - Wrapping Up 00:30:00 Planning the Project Define the Project Requirements 00:28:00 Create Your Project Plan 00:38:00 Execute the Project Plan 00:13:00 Monitor the Progress of the Project 00:20:00 Negotiate for Success 00:16:00 Evaluate the Process 00:19:00 Teams & Leadership 00:35:00 Teams 00:33:00 Conflict 00:34:00 Project Communication Project Communication 00:25:00 Didactic Communications 00:22:00 Basic Meeting Rules 00:21:00 Introducing Scope Management 00:07:00 Defining Scope and WBS 00:10:00 WBS and Control 00:07:00 Working with Time Management 00:21:00 Scheduling and the Critical Path Method 00:20:00 The Critical Chain Method 00:18:00 Introduction to Cost Management 00:15:00 Deprecation and Control Costs 00:14:00 Forecasting 00:24:00 Project Quality Management A Theoretical Perspective 00:18:00 Planning Quality 00:15:00 Finalizing Quality Management 00:12:00 What is Risk Management 00:13:00 Risk Analysis 00:08:00 Risk Responses 00:14:00 Project Performance 00:25:00 The Keys to Success 00:22:00 Project Performance Key Values 00:24:00 Developmental Methodologies 00:25:00 Methodology Types 00:26:00 Selecting a Methodology 00:22:00 Effective Budgets & Schedules 00:25:00 Resource Estimating 00:26:00 Estimating Techniques 00:26:00 Six Sigma & Lean Process Module One - Getting Started 00:30:00 Module Two - Understanding Lean 01:00:00 Module Three - Liker's Toyota Way 01:00:00 Module Four - The TPS House 01:00:00 Module Five - The Five Principles of Lean Business 01:00:00 Module Six - The First Improvement Concept (Value) 01:00:00 Module Seven - The Second Improvement Concept (Waste) 01:00:00 Module Eight - The Third Improvement Concept (Variation) 01:00:00 Module Nine - The Fourth Improvement Concept (Complexity) 01:00:00 Module Ten - The Fifth Improvement Concept (Continuous Improvement) 01:00:00 Module Eleven - The Improvement Toolkit 00:30:00 Module Twelve - Wrapping Up 01:30:00 Mock Exam Mock Exam- Business and Project Management Diploma 00:30:00 Final Exam Final Exam- Business and Project Management Diploma 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced DBAs who will be working with MongoDB. In order to gain the most from this course you should have: Prior practical experience in Database Administration Experience working with Linux and be comfortable working with command line Overview This skills-focused course is approximately 50% hands-on. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will explore: The MongoDB Basic Architecture and Installation MongoDB administration User Management MongoDB security Indexes Backup & Recovery High Availability / Replication Diagnostics & Troubleshooting MongoDB is fast becoming the database of choice for big data applications, being one of the most popular and widely implemented NoSQL databases. Its scalability, robustness, and flexibility have made it extremely popular among business enterprises who use it to implement a variety of activities including social communications, analytics, content management, archiving and other activities. This has led to an increased demand for MongoDB administrators who have the skills to handle cross functional duties. Geared for experienced DBAs, MongoDB for DBAs is a three-day hands-on course that explores the concepts, architecture and pitfalls of managing a MongoDB installation. This course is targeted to the DBA who is familiar with the concepts and tasks of working with a Relational database and is not responsible for a NoSQL MongoDB database. You will learn the critical aspects of MongoDB and use it to solve data management challenges. You will learn to manage MongoDB effectively by gaining expertise in MongoDB administration tools, syntax, MongoDB installations, configurations, security, troubleshooting, backup, scaling and many other features. The focus of this course is on practical skills and applying the DBA existing database knowledge to a MongoDB installation. Introduction to MongoDB Basic Architecture and Installation Differentiate database categories Learn MongoDB design goals List MongoDB tools Describe JSON and BSON Understanding the basic concepts of a Database Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property CAP Theorem, implementing NoSQL and what is MongoDB? Graph Database Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB tools Understanding the following: Collection, Documents and Key/Values, etc., Introduction to JSON and BSON documents Environment setup (live Handson) and using various MongoDB tools available in the MongoDB Package MongoDB Administration Take database backup and restore MongoDB© Export and import data from/ to a MongoDB© instance Check server status and DB status Monitor various resource utilization of a mongod instance Understand various optimization strategies Administration concepts in MongoDB Monitoring issues related to Database Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB Database Profiling, Locks, Memory Usage, No of connections, page fault etc., Backup and Recovery Methods for MongoDB Export and Import of Data to and from MongoDB Run time configuration of MongoDB Production notes/ best practices Data Managements in MongoDB (Capped Collections/ Expired data from TTL), TTL Collection Features GridFS Memory-Mapped Files Journaling Mechanics Storage Engines Power of 2-Sized Allocations No Padding Allocation Strategy Diagnosing Performance Issues Optimization Strategies for MongoDB Configure Tag Sets for Replica Set. Optimize Query Performance Monitoring Strategies for MongoDB . MongoDB Utilities MongoDB Commands MongoDB Management Service (MMS) Data Backup Strategies in MongoDB Copying Underlying Data Files Backup with MongoDump Fsync and Lock MongoDB Ops Manager Backup Software Security Strategies in MongoDB Authentication Implementation in MongoDB . Authentication in a Replica set Authentication on Sharded Clusters Authorization End-to-End Auditing for Compliance User Management Create a User Administrator. Add a User to a Database. Create/Assign User a Role. Verify/Modify a User Access/Privileges. Change a User?s Password MongoDB Security Knowing security concepts in MongoDB Understand how Authentication and Authorisation works Security Introduction Security Concepts Indexes Index Introduction, Index Concepts, Index Types Index Properties Index Creation and Indexing Reference Introduction to Aggregation Aggregation Approach to Aggregation sort Order Pipeline Operators and Indexes Text Indexes Aggregate Pipeline Stages Text Search MapReduce Index Creation Aggregation Operations Index Creation on Replica Set Remove, Modify, and Rebuild Indexes Listing Indexes Measure Index Use Control Index Use Index Use Reporting Geospatial Indexes MongoDB?s Geospatial Query Operators GeoWith Operator Backup & Recovery Import and Export MongoDB Data Restore and recovery of MongoDB(Including point in time Recovery) Restore a Replica Set from MongoDB Backups Recover Data after an Unexpected Shutdown Backup and Restore with Filesystem Snapshots Back Up and Restore with MongoDB Tools Backup and Restore Sharded Clusters High Availability (Replication ) Understand the concept of Replication in MongoDB© ? Create a production like Replica Set Introduction to Replication (High Availability), Concepts around Replication What is Replica Set and Master Slave Replication? Type of Replication in MongoDB How to setup a replicated cluster & managing replica sets etc., Master-Slave Replication Replica Set in MongoDB Automatic Failover Replica Set Members Write Concern Write Concern Levels Write Concern for a Replica Set Modify Default Write Concern Read Preference Read Preference Modes Blocking for Replication Tag Set Configure Tag Sets for Replica set. Replica Set Deployment Strategies . Replica Set Deployment Patterns Oplog File Replication State and Local Database, Replication Administration Diagnostics & Troubleshooting Troubleshoot slow queries Diagnose connectivity problems Understand diagnostic tools Learn common production issues Learn fixes and solutions. Additional course details: Nexus Humans Introduction to MongoDB for DBAs (TTDB4680) 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 Introduction to MongoDB for DBAs (TTDB4680) 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.

Office Admin and Receptionist Course Overview: The Office Admin and Receptionist Course, an essential part of the evolving industry, caters to the increasing demand for skilled professionals in office administration. In today's dynamic business environment, efficient office management and exceptional receptionist skills are crucial for organisational success. This course equips individuals with the necessary knowledge and skills to excel in administrative roles, addressing emerging opportunities and challenges in the field. No matter the type or the size of an organisation, every office needs a receptionist and someone to take care of the administrative tasks. Therefore, if you can train yourself in administrative and receptionist work, you will have a lot of job opportunities knocking at your door. The Office Admin and Receptionist Course will provide you with quality training. It will equip you with the essential skills and confidence to carry out the responsibilities.  The Office Admin and Receptionist Course help you acquire the essential skills to become a proficient receptionist or an office admin. In this course, you will learn how to represent your company in the best possible manner. The easy-to-follow modules will help you in developing your telephone skills. Furthermore, you will become competent in record keeping and filing. In addition, this valuable course will teach you organisation skills, communication skills, time management skills, and more. Most importantly, this course will provide you with quality training in MS Excel. At the end of this Office Admin and Receptionist Course, you will receive a valuable certificate. This certificate will elevate your resume and increase your employability. So enrol now and get ready for a brilliant career. Learning Outcomes Understand the roles and responsibilities of a receptionist and an office administration Learn how to represent your boss and your company properly Develop the essential skills to handle the business telephones Enrich your knowledge of record keeping and filing system Build your organisation skills, communication skills and business writing skills Gain expertise on managing petty cash Become competent in MS Excel Who is the Office Admin and Receptionist Course for? This Office Admin and Receptionist Course is the perfect training ground for future office admins and receptionists. It will provide a clear understanding of their roles and responsibilities and also support in fulfilling these office administration responsibilities.  Why Choose this Office Admin and Receptionist Course? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result UK & internationally recognised accredited qualification Access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities 24/7 student support via email. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the English language, numeracy, and ICT are required to attend this course. Assessment At the end of the course, you will be required to sit for an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99.  Career Path The Office Admin and Receptionist Course is a useful qualification to possess, especially to people with careers in: Administrative Assistant Secretary Administrator Office Manager Receptionist Office Administrator Office Admin and Receptionist Course - Updated Version Introduction to Reception and Receptionist 00:29:00 Business Telephone Skills 00:19:00 Representing Your Boss and Company 00:34:00 Mail Services and Shipping 00:25:00 Travel Arrangements 00:24:00 Organising Meeting and Conferences 00:25:00 Time Management 00:35:00 Record Keeping and Filing Systems 00:28:00 Business Writing Skills 00:40:00 Organisational Skills 00:25:00 Communication Skills 00:25:00 Customer Service 00:16:00 Effective Planning and Scheduling 00:39:00 Invoicing/Petty Cash 00:27:00 Business Environment 00:16: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 Office Admin and Receptionist Course - Old Version Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30:00 Administrative Management Module One - Getting Started 00:30:00 Module Two - Why Your Office Needs Administrative Procedures 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Module One - Getting Started 00:30:00 Module Two - Remove the Clutter 01:00:00 Module Three - Prioritize 01:00:00 Module Four - Scheduling Your Time 01:00:00 Module Five - To Do Lists 01:00:00 Module Six - Paper and Paperless Storage 01:00:00 Module Seven - Organization in Your Work Area 01:00:00 Module Eight - Tools to Fight Procrastination 01:00:00 Module Nine - Organizing Your Inbox 01:00:00 Module Ten - Avoid the Causes of Disorganization 01:00:00 Module Eleven - Discipline is the Key to Stay Organized 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Course for Administrator- Activities 00:00:00 Receptionist Receptionist 00:30:00 Importance of Receptionist 00:15:00 Different Types of Receptionist & Roles 01:00:00 Communication Skills for Receptionist 01:00:00 Telephone Skills 01:00:00 Listening Skills 01:00:00 Taking Messages 00:30:00 Presenting & Appearance 00:30:00 Reservation Procedure 00:15:00 Confidentiality Checklist 00:15:00 Being Organized as Receptionist 00:15:00 Becoming a Successful Receptionist 00:15:00 Customer Relations & Dealings Module One - Getting Started 00:30:00 Module Two - The Right Attitude Starts with You 01:00:00 Module Three - Stress Management (Internal Stressors) 01:00:00 Module Four - Stress Management (External Stressors) 00:30:00 Module Five - Transactional Analysis 01:00:00 Module Six - Why are Some Customers Difficult 01:00:00 Module Seven - Dealing with the Customer Over the Phone 01:00:00 Module Eight - Dealing with the Customer In Person 01:00:00 Module Nine - Sensitivity in Dealing with Customers 01:00:00 Module Ten - Scenarios of Dealing with a Difficult Customer 01:00:00 Module Eleven - Following up With a Customer Once You Have Addressed Their Issue 01:00:00 Module Twelve - Wrapping Up 00:30:00 Professional Telephone Receptionist Skills Module One - Getting Started 00:30:00 Module Two - Core Skills Required 01:00:00 Module Three - Self-Management (I) 01:00:00 Module Four - Self-Management (II) 01:00:00 Module Five - Time Management (I) 01:00:00 Module Six - Time Management (II) 01:00:00 Module Seven - Organizing and Planning (I) 01:00:00 Module Eight - Organizing and Planning (II) 01:00:00 Module Nine - Communication (I) 01:00:00 Module Ten - Communication (II) 01:00:00 Module Eleven - Additional Challenges 01:00:00 Module Twelve - Wrapping Up 00:30:00 Professional Telephone Receptionist Course - Activities 00:00:00 Recommended Reading Recommended Reading : Office Admin and Receptionist Course 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Office Admin and Receptionist Course 00:30:00 Final Exam Final Exam- Office Admin and Receptionist Course 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00