5519 Productivity courses delivered Online

Master Angular and Dart (AngularDart) and build high-performance, flexible, and dynamic web apps

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle will help you build a solid foundation to become a proficient worker in the sector. This The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 : MS Word Diploma Course 02 : Proofreading & Copyediting Course 03 : PowerPoint Diploma Course 04 : Microsoft Excel Level 3 Course 05 : New Functions in Microsoft Excel 2021 Course 06 : Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07 : Microsoft Excel: Excel Sheet Comparison with VBA Course 08 : Microsoft Excel: Master Power Query in 120 Minutes! Course 09 : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10 : Excel Pivot Tables Course 11 : Data Analysis in Microsoft Excel Complete Training Course 12 : Excel Must know Formulas and Functions Course 13 : Excel spreadsheet for Beginner Course 14 : Excel Data Analysis Course 15 : Excel Vlookup, Xlookup, Match and Index Course 16 : Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 17 : PowerBI Formulas Course 18 : Outlook Tips and tricks Course 19 : Excel PowerQuery and PowerPivot Course 20 : Complete Microsoft Power BI 2021 Course 21 : The Complete Microsoft Outlook Masterclass Course 22 : Microsoft Access Complete Course (Beginner, Intermediate, Advanced) Course 23 : Microsoft Access Tables and Queries Course 24 : Microsoft Access Databases Forms and Reports Course 25: Microsoft Teams Course 26: Planning & Control Using Microsoft Project 2013, 2016 & 2019 Course 27: Data Protection and Data Security Level 2 Course 28: Office Skills and Administration Management Diploma Course 29: Touch Typing Essentials Course 30: Document Control 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Highlights of the Course Course Type: Online Learning Duration: 2 hours 30 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about team management Understand the core competencies and principles of team management Explore the various areas of team management Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert leader Team Building Masterclass Course Master the skills you need to propel your career forward in team management. This course will equip you with the essential knowledge and skillset that will make you a confident leader and take your career to the next level. This comprehensive team building course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this team building course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective team management practice and equip you with the essential skills, confidence and competence to assist you in the team management industry. You'll gain a solid understanding of the core competencies required to drive a successful career in team management. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed forleader or for people who are aspiring to specialise in team management. Enrol in this team building course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive team building course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this team management can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This team building course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This team building course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:04:00 Qualities of a Successful Team 00:04:00 Goals & Objectives for Working As a Team 00:05:00 5 Reasons Why Your Entire Team Should Contribute to Your Content Efforts 00:05:00 How Team Members can Support One Another's Well-Being 00:03:00 The Five Business Benefits of a Diverse Team 00:04:00 Effective Leadership: Why It's Important And How It's Achieved 00:05:00 Communicating Effectively as a Team 00:05:00 7 Ways to Improve Team Communication 00:04:00 Advantages & Disadvantages of Group Cohesiveness & Productivity 00:04:00 3 Crucial Steps to Create Role Clarity Within Your Team 00:05:00 Why Consistency Matters in Leadership 00:04:00 Importance of Courtesy in Business Communication 00:04:00 Team Building Models 00:04:00 Traditional Team Building Model 00:03:00 Team Spirit Built from the Top 00:04:00 The Cutting Edge Team 00:05:00 What Are the Characteristics of a Task Force Group in Business 00:03:00 The Cyber Team Model 00:03:00 The Cyber Team Model 00:03:00 The Forming Stage 00:04:00 The Storming Stage 00:04:00 The Norming Stage 00:04:00 The Performing Stage 00:04:00 The Adjourning Stage 00:05:00 Challenges of Managing a Virtual Team 00:05:00 How to Communicate With Remote Teams 00:03:00 How to Manage Remote Project Teams Effectively 00:04:00 10 Ways to Build Positive And Effective Work Relationships 00:04:00 7 Ways to Recover Your Team from Focus Loss 00:04:00 6 Ways Managers can Increase Team Accountability 00:04:00 Team Building Exercises 00:03:00 Magic Cane (Helium Stick) 00:03:00 Barter Puzzle 00:02:00 Bridge Build 00:03:00 What's My Name 00:03:00 Grab Bag Skits 00:02:00 Review 00:03:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Electrical Engineering - Electrical Machines Complete Training Overview Are you looking to begin your electrical machines career or want to develop more advanced skills in electrical machines? Then this electrical engineering - electrical machines complete online training course will set you up with a solid foundation to become a confident electrical engineer and help you to develop your expertise in electrical machines. This electrical engineering - electrical machines complete online training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this electrical engineering - electrical machines complete online training course will set you up with a solid foundation to become a confident electrical engineer and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a electrical engineer. The electrical engineering - electrical machines complete online training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a electrical engineer. This comprehensive electrical engineering - electrical machines complete online training course is the perfect way to kickstart your career in the field of electrical machines. This electrical engineering - electrical machines complete online training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a electrical engineer or want to learn more skills on electrical machines but unsure of where to start, then this electrical engineering - electrical machines complete online training course will set you up with a solid foundation to become a confident electrical engineer and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This electrical engineering - electrical machines complete online training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive electrical engineering - electrical machines complete online training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of electrical machines. Entry Requirements There are no academic entry requirements for this electrical engineering - electrical machines complete online training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Career path This electrical engineering - electrical machines complete online training course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Course Content Introduction to Electric Machines Types of Electric Machines and Principle of Electricity Generation DC Machines Importance and Construction of DC Machines Armature Winding and EMF Equation Solved Example 1 Solved Example 2 Solved Example 3 Solved Example 4 Shunt and Series DC Machines Solved Example 1 on Separately Excited DC Machine Solved Example 2 on Separately Excited DC Machine Solved Example 3 on Shunt Generator Solved Example 4 on Shunt Generator Solved Example 5 on Series DC Generator Types and Applications of Compound DC Motors Torque-Speed Characteristics and Speed Control of Separately Excited DC Motor Torque-Speed Characteristics of Series DC Motor Solved Example 1 on Speed Control Solved Example 2 on Speed Control Starting of DC Machine Armature Reaction in DC Machines Losses in DC Machines Construction of Transformer Magnetic Circuit Inside Transformer Windings of Transformer Why are Windings Made of Copper Why are Windings Made of Copper Insulating Material and Transformer Oil Conservator of Transformer Breather of Transformer Bushings of Transformer Tap Changer of Transformer Cooling Tubes of Transformer Buchholz Relay of Transformer Explosion Vent Methods of Cooling Types of Transformers Power Transformer and Distribution Transformer Single Phase Core Type Transformer Single Phase Shell Type Transformer Three Phase Core Type Transformer Three Phase Shell Type Transformer Comparison between Shell and Core CSA Comparison between Shell and Core Type Notes Video Explaining The Components in 3D and Real Life Fundamentals of Magnetic Circuits for Electrical Engineering Magnetic Circuit and Important Definitions Linear and Non Linear Materials Flux Linkage and Reluctance Analogy between Electric and Magnetic Circuits Fringing Effect Example 1 Magnetic Circuits Example 2 Example 3 Application on Magnetic Circuit - Transformers Theoretical Part on Transformers Introduction to Transformers Construction of Transformer Theory of Operation Ideal Transformer Non Ideal Transformer Effect of Loading on Transformer Transformer Regulation Transformer Losses Transformer Efficiency Transformer Rating Question 1 Question 2 Question 3 Example 1 Voltage Relation of Transformer Transformer Exact Equivalent Circuit Concept of Refereeing Approximate Equivalent Circuit Synchronous Machines Construction and Principle of Operation of Synchronous Generator rinciple of Operation of Synchronous Motor Equivalent Circuit and Phasor Diagram of Non Salient Synchronous Machine Solved Example 1 on Non Salient Machine Solved Example 2 on Non Salient Machine Solved Example 3 on Non Salient Machine Solved Example 4 on Non Salient Machine lved Example 5 on Non Salient Machine Solved Example 6 on Non Salient Machine Equivalent Circuit and Phasor Diagram of Salient Synchronous Machine Solved Example 1 on Salient Machine Solved Example 2 on Salient Machine Solved Example 3 on Salient Machine Parallel Operation of Two Generators Synchronization of Machine with Grid Induction Machines Construction and Theory of Operation of Induction Machines Equivalent Circuit and Power Flow in Induction Motor Torque-Speed Characteristics of Induction Motor Solved Example 1 on Induction Motor Solved Example 2 on Induction Motor Solved Example 3 on Induction Motor Solved Example 4 on Induction Motor Solved Example 5 on Induction Motor Methods of Speed Control of Induction Motor Methods of Starting of Induction Motor Solved Example on Motor Starter Self Excited Induction Generator Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.  

24 Hour Flash Deal **25-in-1 Executive Assistant Advanced Diploma Mega Bundle** Executive Assistant Advanced Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Executive Assistant Advanced Diploma package online with Studyhub through our online learning platform. The Executive Assistant Advanced Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Executive Assistant Advanced Diploma course provides complete 360-degree training on Executive Assistant Advanced Diploma. You'll get not one, not two, not three, but twenty-five Executive Assistant Advanced Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Executive Assistant Advanced Diploma courses are yours for as long as you want them once you enrol in this course This Executive Assistant Advanced Diploma Bundle consists the following career oriented courses: Course 01: Executive Assistant Course 02: Contract Management Certification Course 03: Medical Secretary Certification Course 04: Legal Secretary Skills Diploma Course 05: Diploma in Minute Taking Training Course 06: Diary Management Course 07: Office Admin and Reception Course 08: Report Writing Skills: Crafting Effective Business Reports Course 09: Equality, Diversity and Discrimination Course 10: HR Management Course 11: UK Employment Law Course 12: Employee Hiring and Termination Training Course 13: Safer Recruitment Training Course 14: Performance Management Course 15: Employee Engagement and Retention Strategies Course 16: Governance and Risk Management: Navigating Corporate Strategies Course 17: Managing Online Meetings Course 18: Facilities Management Course 19: Motivation - Motivating Yourself & Others Course 20: Workplace Confidentiality Course 21: Data Protection and Data Security (GDPR) Training Certification Course 22: Organisation & People Management Course 23: Change Management Course 24: Team Management Course 25: Stakeholder Management The Executive Assistant Advanced Diploma course has been prepared by focusing largely on Executive Assistant Advanced Diploma career readiness. It has been designed by our Executive Assistant Advanced Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Executive Assistant Advanced Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Executive Assistant Advanced Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Executive Assistant Advanced Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Executive Assistant Advanced Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Executive Assistant Advanced Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Executive Assistant Advanced Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Executive Assistant Advanced Diploma lessons One to one assistance from Executive Assistant Advanced Diplomaprofessionals if you need it Innovative exams to test your knowledge after the Executive Assistant Advanced Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Executive Assistant Advanced Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Executive Assistant Advanced Diploma certificate and transcript on the next working day Easily learn the Executive Assistant Advanced Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Executive Assistant Advanced Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Executive Assistant Advanced Diploma Requirements To participate in this Executive Assistant Advanced Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Executive Assistant Advanced Diploma Career path You will be able to kickstart your Executive Assistant Advanced Diploma career because this course includes various courses as a bonus. This Executive Assistant Advanced Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Executive Assistant Advanced Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

QA Level 2 Award In Principles Of Risk Assessment (RQF) Face to Face: One-day course Virtual Classroom: Spread over 3 sessions of 2½ hr duration Don't run risks with the safety of your people - it will cost you a lot more when things start to go wrong... Risk Assessments are vital for Health and Safety, and vital for the whole process Course Contents: Main causes of Work-related Fatalities, Injuries and ill health Moral, Legal and Economic Reasons for Preventing Accidents and ill health at Work Key Terms associated with Risk Assessments in Health and Safety at Work:AccidentNear MissAccident TriangleHazardRiskRisk AssessmentSuitable and SufficientCompetence The Role of Risk Assessments in Accident and ill Health Prevention Legal Requirements for Risk Assessments Importance of Personal hygiene Basic Process for Undertaking a Risk Assessment The Five Steps of a Risk Assessment Benefits of this course: In 2020/21, a whopping 1.7 million people suffered from a work-related illness 441,000 of those sustained an injury 142 People, plus 60 members of the public, lost their lives... The estimated cost of injuries and ill health was £15 billion 28.2 million working days, or 108,045 working years, were lost due to work-related illnesses and injuries It is an employer's duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk Our QA Level 2 Award in Principles of Risk Assessment (RQF) course is ideal for all employees, helping them to create a better understanding of health and safety issues and risk assessments Accredited, Ofqual regulated qualification: QA Level 2 Award in Principles of Risk Assessment (RQF) training course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Principles of Risk Assessment certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained appropriately.The Ofqual Register number for this course is 603/0857/9

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS Introduction to Data Science Create and Modify Tables Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL Visualize Data with Charts Modify and Format Charts Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS Analyze Data with Formulas and Named Ranges Analyze Data with Functions Implement Data Validation, Forms, and Controls Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES Create a PivotTable Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL Visualize Data with PivotCharts Filter Data Using Slicers and Timelines Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL Create Map Charts in Excel Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS Visualize Trendlines and Sparklines with Excel Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA Connect to Data with Queries Clean and Combine Data Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT Install Power Pivot in Excel Create Data Models with Power Pivot Create Power Pivots Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) Plan a Report Create a Report