1069 Courses delivered Online

This course has been specifically designed to assist professionals applying for Real Estate positions where a Real Estate Financial Modelling test is a requisite part of the interview process.

Embark on a transformative journey into the realm of data mastery with our comprehensive course, 'Advanced SAS Programming Using MacrosSQL.' From demystifying the intricacies of SAS Studio to unlocking the potential of Proc SQL, this course is a gateway to proficiency in SAS programming and macro scripting. The curriculum, thoughtfully designed to accommodate learners of all levels, takes you through the essential foundations of SAS, the nuances of macro variables, and the power-packed functionalities of Proc SQL. Dive into the world of nested macro variables, conditional logic, and data manipulation, all while honing your skills through practical examples. This course isn't just about learning syntax; it's a hands-on exploration that empowers you to seamlessly connect the dots between SAS Studio and Proc SQL, bringing your data analytics capabilities to new heights. Learning Outcomes Master the fundamentals of SAS Studio and navigate through its interface effortlessly. Develop a deep understanding of macro variables, exploring their applications and delving into nested variations. Acquire proficiency in SAS Macros, from basic examples to advanced keyword usage and conditional logic. Unlock the potential of Proc SQL, gaining expertise in data copying, filtering, sorting, and removing duplicates. Harness the power of data merging using Joins, creating macro variables dynamically in the process. Why choose this Advanced SAS Programming Using MacrosSQL course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Advanced SAS Programming Using MacrosSQL course for? Data enthusiasts seeking to enhance their SAS programming skills. Business analysts aiming to leverage SAS for more effective data analysis. IT professionals aspiring to streamline data management through SAS. Career path SAS Programmer: £35,000 - £55,000 Data Analyst: £30,000 - £50,000 Business Intelligence Developer: £40,000 - £60,000 Database Administrator: £35,000 - £60,000 Data Scientist: £45,000 - £70,000 Analytics Manager: £50,000 - £80,000 Prerequisites This Advanced SAS Programming Using MacrosSQL does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Advanced SAS Programming Using MacrosSQL 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Advanced SAS Programming Using MacrosSQL Unit - 1 Section 0-00- Why SAS 00:01:00 Unit - 2 Section 2-02- SAS Studio through SAS OnDemand- Registration 00:04:00 Section 2-03- Logging-in to SAS after installation 00:01:00 Section 2-04- SAS Interface and windows 00:06:00 Unit - 3 Section 3-00- Section Overview - Macros 00:01:00 Section 3-01-Macro Variables - introduction 00:14:00 Section 3-02-Application of macro variables 00:13:00 Section 3-03-01-Nested macro vars 00:11:00 Section 3-03-02-More on Ampersand resolutions using a cool example 00:09:00 Section 3-04-00-SAS Macros - introduction 00:10:00 Section 3-04-01-SAS Macros - Examples 00:07:00 Section 3-04-02-Keyword positional and mixed params 00:06:00 Section 3-04-03-Conditional Logic in Macros 00:11:00 Section 3-05-Macro Functions 00:12:00 Section 3-05-Options Statement- mprint-mlogic-symbolgen 00:13:00 Section 3-07-Connecting the two worlds - Call Symput - Symget 00:14:00 Section 3-09-01-02- Bringing data into SAS using Import Wizard 00:04:00 Section 3-09-02- Bringing data into SAS using LIBNAME statement 00:05:00 Section 3-09-03- Bringing data into SAS using FILENAME 00:05:00 Unit - 4 Section 4-00- Section Overview - Proc SQL 00:01:00 Section 4-01-01-Proc SQL - copying data 00:13:00 Section 4-01-02-Proc SQL - filtering data 00:07:00 Section 4-01-03-Proc SQL - sorting data 00:08:00 Section 4-01-04-Proc SQL - removing duplicates 00:05:00 Section 4-02-01-Proc SQL - Union 00:09:00 Section 4-02-02-Proc SQL - Except 00:04:00 Section 4-02-03-Proc SQL - Intersect 00:02:00 Section 4-03-00-Merging data using Joins-Introduction 00:08:00 Section 4-03-01-Proc SQL - inner join 00:14:00 Section 4-03-02-Proc SQL - full join 00:08:00 Section 4-03-03-Proc SQL - left and right joins 00:07:00 Section 4-04-01-Proc SQL - creating macro vars 00:07:00 Unit - 5 Section 5-00- Bonus lecture 00:02:00

24-Hour Flash Sale! Prices Reduced Like Never Before!! Limited Time Offer: Virtual Assistant Training | Data Entry Administrator | Touch Typing | Personal Assistant Training From planning the meetings to business writing, a PA or a Virtual Assistant has to carry out various roles and responsibilities. Therefore, recruiters look for individuals who possess the skills and expertise to carry out these wide ranges of duties of PA or a Virtual Assistant. The Virtual Assistant & PA with Data Entry, Touch Typing & Microsoft Office Skills Course is designed to assist you in acquiring the essential skills to impress recruiters. It will enlighten you on all the core elements of a secretarial job within only a few steps. This comprehensive Virtual Assistant bundle offers everything you need to launch a successful career as a VA or PA. You'll gain proficiency in high-speed, accurate Data Entry, master Touch Typing for efficient task completion, and develop advanced Microsoft Excel skills for data analysis and presentation. Additionally, you'll learn the fundamentals of Virtual Assistance and Personal Assistant duties, providing you with a well-rounded skillset to impress potential clients. Courses are Included in this Virtual Assistant & PA with Data Entry, Touch Typing & Microsoft Excel Training Bundle: Course 01: Virtual Assistant at QLS Level 2 Course 02: PA - Personal Assistant Course Course 03: Data Entry Administrator at QLS Level 3 Course 04: Certificate in Touch Typing Course 05: Microsoft Excel - Beginner, Intermediate & Advanced Step into a career that offers flexibility, variety, and the opportunity to work with diverse clients around the globe. By completing this Virtual Assistant course, you'll boost your employability and gain the confidence to manage business operations smoothly and effectively. So, enrol now! Learning Outcomes of Virtual Assistant & PA with Data Entry, Touch Typing & Microsoft Excel Training: Master data entry techniques for efficient and error-free information processing Achieve proficiency in touch typing to boost your typing speed and accuracy Develop comprehensive Microsoft Excel skills for data organisation, analysis, and presentation Gain a thorough understanding of virtual assistant and personal assistant duties Learn effective communication and organisational skills to excel in a client-facing role Why Choose Us? Get a Free CPD Accredited Certificate upon completion of this course Get a free student ID card with this Training program (£10 postal charge will be applicable for international delivery) This course is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to this course materials This course comes with 24/7 tutor support Start your learning journey straight away! Moreover, this diploma offers learners the opportunity to acquire skills that are highly valued in the field of Virtual Assistant. With this Certification, graduates are better positioned to pursue career advancement and higher responsibilities within the Virtual Assistant setting. The skills and knowledge gained from this course will enable learners to make meaningful contributions to Virtual Assistant-related fields, impacting their Virtual Assistant experiences and long-term development. Course Curriculum Course 01: Virtual Assistant at QLS Level 2 Module 01: Introduction Module 02: Different Types of Virtual Assistants Module 03: Be a Virtual Assistant Module 04: Must-Have Skills for Virtual Assistants Module 05:Essential Tools Module 06: Finding Your Niche Module 07: Get Hired for VA Jobs Module 08: How to Set VA Business Module 09: Admin Support- a Vital Part of VA Module 10: How to Manage Clients Module 11: Working with a Virtual Team Module 12: Data Security Measures Course 02: PA - Personal Assistant Course Module 01: Introduction to Personal Assistant Module 02: Business Telephone Skills Module 03: Representing Your Boss and Company Module 04: Mail Services and Shipping Module 05: Travel Arrangements Module 06: Organising Meeting and Conferences Module 07: Time Management Module 08: Record Keeping and Filing Systems Module 09: Business Writing Skills Module 10:Organisational Skills Course 03: Data Entry Administrator at QLS Level 3 Module 01: Making Data Entry Jobs Easier Module 02: Getting Started With Microsoft Office Excel 2016 Module 03: Performing Calculations Module 04: Modifying A Worksheet Module 05: Formatting A Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Course 04: Certificate in Touch Typing Module 01: Introduction Module 02: How To Set Up Your Computer Module 03: How To Type The Letters F And J Module 04: How To Type The Letters D And K Module 05: How To Type The Letters S And L Module 06: How To Type The Letter A And ; (Semicolon) Module 07: How To Type The Letters E And I Module 08: How To Type The Letters R And U Module 09: How To Type The Letters T And O Module 10: How To Type CAPITAL Letters Module 11: How To Type The Letter C And , (Comma) Module 12: How To Type The Letters G And H Module 13: How To Type The Letters N And V Module 14: How To Type The Letters W And M Module 15: How To Type The Letters Q And P Module 16: How To Type The Letters B And Y Module 17: How To Type The Letters Z And X Module 18: How To Type Colon And Semicolon Module 19: How To Type Full Stop And Comma Module 20: How To Type Question Mark And Exclamation Mark Module 21: How To Type Dash, Parentheses And Quotation Marks Course 05: Microsoft Excel - Beginner, Intermediate & Advanced Unit 01: Excel From A-Z Course Introduction Unit 02: Getting Started With Excel Unit 03: Values, Referencing And Formulas Unit 04: Intro To Excel Functions Unit 05: Adjusting Excel Worksheets Unit 06: Visually Pleasing Cell Formatting Unit 07: How To Insert Images And Shapes! Unit 08: Visualize Data With Charts Unit 09: Excel's Printing Options Unit 10: Benefits Of Using Excel Templates Unit 11: Working With Excel Datasets Unit 12: Excel Database Functions Unit 13: Excel Data Validation Unit 14: Excel PivotTables Unit 15: Excel's PowerPivot Add-In Unit 16: Excel's Conditional Functions Unit 17: Excel's Lookup Function Unit 18: Text Based Functions In Excel Unit 19: Auditing Formulas And Views In Excel Unit 20: Excel's 'What If?' Tools Unit 21: Welcome To Excel VBA Unit 22: The VBA Language Unit 23: Writing VBA Code Unit 24: Important VBA Tools And Logic Unit 25: Excel VBA Lopps Unit 26: Triggering Macros Unit 27: Excel User Forms Unit 28: Starting A Career In Excel How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously, it was £12.99*5 = £65) CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring virtual assistants Remote work enthusiasts Administrative professionals Career changers Freelancers Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Virtual Assistant: £18,000 - £30,000 Data Entry Administrator: £16,000 - £25,000 Personal Assistant: £25,000 - £40,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee. Award in Virtual Assistant at QLS Level 2 Hard copy certificate - £79 Please note that International students have to pay an additional £10 as a shipment fee.

Duration 3 Days 18 CPD hours This course is intended for This course is aimed at anyone who wants to harness the power of data analytics in their organization including: Business Analysts, Data Analysts, Reporting and BI professionals Analytics professionals and Data Scientists who would like to learn Python Overview This course teaches delegates with no prior programming or data analytics experience how to perform data manipulation, data analysis and data visualization in Python. Mastery of these techniques and how to apply them to business problems will allow delegates to immediately add value in their workplace by extracting valuable insight from company data to allow better, data-driven decisions. Outcome: After attending this course, delegates will: Be able to write effective Python code Know how to access their data from a variety of sources using Python Know how to identify and fix data quality using Python Know how to manipulate data to create analysis ready data Know how to analyze and visualize data to drive data driven decisioning across your organization Becoming a world class data analytics practitioner requires mastery of the most sophisticated data analytics tools. These programming languages are some of the most powerful and flexible tools in the data analytics toolkit. From business questions to data analytics, and beyond For data analytics tasks to affect business decisions they must be driven by a business question. This section will formally outline how to move an analytics project through key phases of development from business question to business solution. Delegates will be able: to describe and understand the general analytics process. to describe and understand the different types of analytics can be used to derive data driven solutions to business to apply that knowledge to their business context Basic Python Programming Conventions This section will cover the basics of writing R programs. Topics covered will include: What is Python? Using Anaconda Writing Python programs Expressions and objects Functions and arguments Basic Python programming conventions Data Structures in Python This section will look at the basic data structures that Python uses and accessing data in Python. Topics covered will include: Vectors Arrays and matrices Factors Lists Data frames Loading .csv files into Python Connecting to External Data This section will look at loading data from other sources into Python. Topics covered will include: Loading .csv files into a pandas data frame Connecting to and loading data from a database into a panda data frame Data Manipulation in Python This section will look at how Python can be used to perform data manipulation operations to prepare datasets for analytics projects. Topics covered will include: Filtering data Deriving new fields Aggregating data Joining data sources Connecting to external data sources Descriptive Analytics and Basic Reporting in Python This section will explain how Python can be used to perform basic descriptive. Topics covered will include: Summary statistics Grouped summary statistics Using descriptive analytics to assess data quality Using descriptive analytics to created business report Using descriptive analytics to conduct exploratory analysis Statistical Analysis in Python This section will explain how Python can be used to created more interesting statistical analysis. Topics covered will include: Significance tests Correlation Linear regressions Using statistical output to create better business decisions. Data Visualisation in Python This section will explain how Python can be used to create effective charts and visualizations. Topics covered will include: Creating different chart types such as bar charts, box plots, histograms and line plots Formatting charts Best Practices Hints and Tips This section will go through some best practice considerations that should be adopted of you are applying Python in a business context.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for the following participants:Cloud professionals interested in taking the Data Engineer certification exam.Data engineering professionals interested in taking the Data Engineer certification exam. Overview This course teaches participants the following skills: Position the Professional Data Engineer Certification Provide information, tips, and advice on taking the exam Review the sample case studies Review each section of the exam covering highest-level concepts sufficient to build confidence in what is known by the candidate and indicate skill gaps/areas of study if not known by the candidate Connect candidates to appropriate target learning This course will help prospective candidates plan their preparation for the Professional Data Engineer exam. The session will cover the structure and format of the examination, as well as its relationship to other Google Cloud certifications. Through lectures, quizzes, and discussions, candidates will familiarize themselves with the domain covered by the examination, to help them devise a preparation strategy. Rehearse useful skills including exam question reasoning and case comprehension. Tips and review of topics from the Data Engineering curriculum. Understanding the Professional Data Engineer Certification Position the Professional Data Engineer certification among the offerings Distinguish between Associate and Professional Provide guidance between Professional Data Engineer and Associate Cloud Engineer Describe how the exam is administered and the exam rules Provide general advice about taking the exam Sample Case Studies for the Professional Data Engineer Exam Flowlogistic MJTelco Designing and Building (Review and preparation tips) Designing data processing systems Designing flexible data representations Designing data pipelines Designing data processing infrastructure Build and maintain data structures and databases Building and maintaining flexible data representations Building and maintaining pipelines Building and maintaining processing infrastructure Analyzing and Modeling (Review and preparation tips) Analyze data and enable machine learning Analyzing data Machine learning Machine learning model deployment Model business processes for analysis and optimization Mapping business requirements to data representations Optimizing data representations, data infrastructure performance and cost Reliability, Policy, and Security (Review and preparation tips) Design for reliability Performing quality control Assessing, troubleshooting, and improving data representation and data processing infrastructure Recovering data Visualize data and advocate policy Building (or selecting) data visualization and reporting tools Advocating policies and publishing data and reports Design for security and compliance Designing secure data infrastructure and processes Designing for legal compliance Resources and next steps Resources for learning more about designing data processing systems, data structures, and databases Resources for learning more about data analysis, machine learning, business process analysis, and optimization Resources for learning more about data visualization and policy Resources for learning more about reliability design Resources for learning more about business process analysis and optimization Resources for learning more about reliability, policies, security, and compliance Additional course details: Nexus Humans Preparing for the Professional Data Engineer Examination 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 Preparing for the Professional Data Engineer Examination 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.

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Are you planning for your special day? Have you an interest in working in the events and planning industry? Take steps to become a certified wedding planner with this Professional Wedding Planner course and learn how to plan the perfect event for you or your clients. The wedding is a milestone event for anyone, symbolising the start of a new phase of life. However, planning for a wedding takes a lot of time and preparation, which is why couples request the help of an industry professional who knows the planning process inside and out. In this course, you will be guided step-by-step on key areas of planning, such as choosing the right venue and negotiating with suppliers. You will explore the role of a professional wedding planner in detail, with tips on how to plan your or your client's dream wedding on a budget. This online wedding planning course is ideal for those who are pursuing a career in the event sector and would benefit anyone who wants to become an event planner or bridal consultant. What's more, you will learn how to get clients and launch your own wedding planning business from scratch. Along with this Professional Wedding Planner, you will get 10 Premium courses specially designed for Event/ Wedding Planners. Also, you will get an original hardcopy certificate, a transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Courses are included in this Professional Wedding Planner Bundle Course 01: Wedding Planner Course 02: Wedding Photography Course 03: Catering Management Course 04: Event Planning Course 05: Bridal and Occasional Makeup Artist Masterclass Course 06: Customer Relationship Management Course 07: Interior Design Professional Diploma Course 08: Effective Communication Skills Course 09: Leisure Management Course 10: Time Management Course 11: Health and Safety at Workplace Make every wedding magical and become a sought after wedding planner, by joining the Professional Wedding Planner course. Learning Outcomes: Understand the role and responsibilities Know how to plan weddings of all types, budgets and sizes Get tips on how to market your wedding planning business Develop your understanding of wedding etiquette and dress code Gain excellent client management and communication skills Deepen your knowledge of the different types of weddings Know how to choose the right venue and location for your clients Learn bridal makeup techniques from professional makeup artists and much more... Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home As a professional wedding planner, you will require both creativity and management skills. In this innovative course, you will gain the expertise and fundamental skills to plan themed and traditional wedding programs on a minimal budget. Course design The Professional Wedding Planner is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Written assignment Course Curriculum of Professional Wedding Planner Bundle: Course 1: Wedding Planner Module 01: An Overview of Wedding Industry Module 02: Profession of a Wedding Planner Module 03: Wedding Timelines Module 04: Wedding Budgets Module 05: The Vision, Venue, and Theme Determining Module 06: Food and Beverage and the Wedding Cake Module 07: Music, Photography and Floral Décor Module 08: Wedding Attire Module 09: Setting the Stage: Choosing, Equipping and Decorating Venue Module 10: Wedding Day Details Module 11: Post Wedding Activity and Evaluation Module 12: Starting your Own Wedding Planning Business Course 2: Bridal and Occasional Makeup Artist Module 01: The Base Module 02: Eye Makeup Module 03: Lips, Cheeks and Brows Module 04: Special Considerations for Weddings and Events Module 05: Bridal & Special Occasion Makeup as a Business Course 3: Wedding Photography Unit 1- Introduction Unit 2- The Bride Getting Ready Module 1- Applying Makeup Module 2- Dress and Shoes Module 3- Doing Up the Dress Module 4- Doing Up Other Things Module 5- Bouquet in Foreground Module 6- Bride on Sofa Module 7- Bride Formals Module 8- Bride by Window Part 1 Module 9- Bride by Window Part 2 Module 10- Bride Walking Down Stairs Unit 3- The Ceremony Module 1- Arriving at Church Module 2- Cake in the Background Module 3- Parents Seeing the Bride Module 4- Walking the Aisle Module 5- Ceremony Moments Part 1 Module 6- Ceremony Moments Part 2 Module 7- Groom's First Sight of Bride Module 8- Signing the Register Module 9- The Rings Unit 4- After the Ceremony Module 1- Bride and Groom Relaxed Module 2- Details Module 3- Congratulations Module 4- The Speeches Module 5- Through a Door Module 6- Going Over the Speeches Module 7- Groom Groom on His Own Module 8- Groom Against the Church Wall Module 9- Groom and Best Man Module 10- Groomsmen and Bridesmaids Module 11- Drinks in Foreground Module 12- First Dance Module 13- Group Formals Module 14- Kissing with Friends Module 15- Leaving by Church Doorway Module 16- Confetti Throwing Module 17- Leaving in Car Unit 5- Conclusion Course 4: Catering Management Module 1: An Overview of Catering Business Module 2: Laws and Legislations Regarding food Safety and Hygiene Module 3: Food Safety and Hygiene Module 4: Food Safety in Catering Module 5: Management of Food and Beverage Operations Module 6: Marketing and Human Resource Course 5: Event Planning Module 1: Introduction to Event Management Module 2: Role of an Event Planner Module 3: Event Classification Module 4: Events and Clients Module 5: Steps to Plan an Event Module 6: Invitation to the Event Module 7: Event Marketing Module 8: Catering at Events Module 9: Event Decorations Module 10: Cleaning and Waste Disposal Module 11: Event Security Module 12: Developing an Event Planning Business Course 6: Interior Design Professional Diploma Module 1: Introduction to Interior Design Module 2: Design Principles Module 3: Project Overview Module 4: Design Elements Module 5: Design Elements Practical Components Module 6: Room by Room Design Module 7: Popular Interior Designs Module 8: Sustainable Design Module 9: Presenting Your Ideas Module 10: Managing Interior Design Business Course 7: Customer Relationship Management Module 01: Introduction to Customer Relationship Management (CRM) Module 02: CRM Fundamentals Module 03: CRM Strategies CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM Course 8: Performance Management Performance Management Section 01: Introduction Section 02: Performance Section 03: Key Performance Indicators Section 04: Reporting Section 05: Rewarding Section 06: Conclusion Course 9: Leisure Management Module 01: Introduction to Leisure Management Module 02: Managing and Maintaining a Leisure Facility Module 03: Travel, Tourism and Leisure Module 04: Managing Hotel and Lodging Module 05: Planning for Leisure Services Module 06: Leadership in Leisure Industry Module 07: Human Resource Management in Leisure Industry Module 08: Marketing of Leisure and Recreation Module 09: Health, Safety and Welfare Course 10: Effective Communication Skills Module 01: Business Communication Module 02: Verbal and Non-verbal Communication Module 03: Written Communication Module 04: Electronic Communication Module 05: Communicating with Graphic Module 06: Effectively Working for Your Boss Course 11: Health and Safety at Workplace Module 01: Health and Safety at Work and the Laws Module 02: Managing for Health and Safety Module 03: Risk Assessment and Common Risks Module 04: Workplace Health, Safety and Welfare Module 05: Accidents and Ill Health at Work Module 06: Electrical, Fire and Gas Safety Module 07: Safety in Different Work Settings Module 08: Work Equipment Hazards and Risk Control Module 09: Other Health and Safety Hazards at Work How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds. Requirements Our course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 These skills can be used to add value to your CV when exploring career opportunities in events planning. It will equip learners with the core skills required to work in the following professions: Wedding Planner Special Events Coordinator Events Manager Events & Party Planner Certificates Certificate of completion Digital certificate - Included

[vc_row][vc_column][vc_column_text] Description: Improve your competency in Microsoft Office with this Microsoft Excel Complete Course - Beginners, Intermediate, Advanced. Microsoft Excel is the most widely used spreadsheet program in the world. It allows businesses to conduct data analysis, record expenditures and carry out simple to complex maths calculations. Want to master Excel? This complete training course will help you gain the practical skills and knowledge you need to perform everyday data-based tasks faster and more efficiently. This course is designed to help you familiarise with the major functionalities of Excel, with step-by-step guidance. You will start with simple tasks like viewing excel data, working with the interface, using quick analysis and more. At an intermediate skill level, you will learn about macros, forms, slicers, timelines etc. Finally, at an advanced level, you will learn how to create charts, pivot tables, solve formula errors and manage your data more effectively. This online course is the ultimate online guide for learning MS Excel. Certify your skills in this leading office software and gain maximum career progression! Who is the course for? Professionals who want to learn how to use Microsoft Office Excel. People who have a need to analyze and organise large amounts of data. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit 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. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. 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 recognized 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: Microsoft Excel Complete Course - Beginners, Intermediate, Advanced is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Accounting Management consultant Investment Banking Analyst Marketing Engineering Researchering [/vc_column_text][/vc_column][/vc_row] Microsoft Excel - Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Excel for Newbies - Activities 00:00:00 Microsoft Excel - Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 00:30:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 00:30:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working With Macros 00:30:00 Module Seven - Working With Forms 00:30:00 Module Eight - Applying Advanced Chart Features 01:00:00 Module Nine - Working With Slicers and Timelines 00:30:00 Module Ten - Working With Multiple Tables, Relationships and External Data 00:30:00 Module Eleven - Working With PowerView 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities- Microsoft Excel - Intermediate Level 00:00:00 Microsoft Excel - Advanced Level Module One - Getting Started 01:00:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel - Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel Complete Course - Beginners, Intermediate, Advanced 00:30:00 Final Exam Final Exam- Microsoft Excel Complete Course - Beginners, Intermediate, Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Mechanical Engineering: Mechanical Engineering Would you like to work in the field of mechanical engineering? Our mechanical engineering course will help you understand engineering mathematics, fundamental physics, and an introduction to mechanical engineering. This mechanical engineering course explains heat transport, thermodynamics, and materials science. This mechanical engineering course discusses aerodynamics and fluid mechanics. Moreover, the mechanical engineering course covers kinematics, structural analysis, machine design, and the mechanics of solids. Through the mechanical engineering course, you will comprehend dynamics, control systems, and capstone design projects. Additionally, the mechanical engineering course describes technology, sustainability, and renewable energy techniques. If you are interested in learning about experimental techniques, appropriate data analysis, professional growth, and engineering ethics, enrol our mechanical engineering course soon! Special Offers of this Mechanical Engineering: Mechanical Engineering Course: This Mechanical Engineering: Mechanical Engineering Course includes a FREE PDF Certificate. Lifetime access to this Mechanical Engineering: Mechanical Engineering Course Instant access to this Mechanical Engineering: Mechanical Engineering Course 24/7 Support Available to this Mechanical Engineering: Mechanical Engineering Course Mechanical Engineering: Mechanical Engineering Elevate your career with our in-depth Mechanical Engineering Course! This program covers essential engineering mathematics, fundamental physics, and an introduction to core mechanical engineering concepts. You will delve into heat transport, thermodynamics, and materials science. Advanced topics include aerodynamics, fluid mechanics, kinematics, structural analysis, and machine design. Our curriculum also includes the mechanics of solids, dynamics, control systems, and engaging capstone design projects. Additionally, you'll learn about cutting-edge technology, sustainability, and renewable energy techniques. Develop practical skills with hands-on experimental methods, accurate data analysis, and a strong emphasis on professional growth and engineering ethics. Enroll today to become a proficient and innovative mechanical engineer! Who is this course for? Mechanical Engineering: Mechanical Engineering Anyone interested in mechanical engineering should pursue the mechanical engineering course. Requirements Mechanical Engineering: Mechanical Engineering To enrol in this Mechanical Engineering: Mechanical Engineering Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Mechanical Engineering: Mechanical Engineering Course Be energetic and self-motivated to complete our Mechanical Engineering: Mechanical Engineering Course Basic computer Skill is required to complete our Mechanical Engineering: Mechanical Engineering Course If you want to enrol in our Mechanical Engineering: Mechanical Engineering Course, you must be at least 15 years old. Career path Mechanical Engineering: Mechanical Engineering Successful completion of the mechanical engineering course can lead to a variety of rewarding career options in mechanical engineering-related industries.

Add another skill to your existing skillsets with the most demanding course for freelance marketplaces such as - Upwork and Fiverr. Data entry needs a variety of competencies, including typing, transcription, computer proficiency, time management and organisation skills, administrative skills, and more. You have landed at the right place if you're looking forward to enhancing your skills in any of these topics. This Data Entry Administrator Training course is suited for both novice and experienced Data Entry Administrators who need to comprehend how data and data patterns work in a database and conduct data analysis based on their understanding. This accredited training curriculum comprises beginning, intermediate, and expert-level lessons that will increase your proficiency with Microsoft Excel for statistical analysis. After completing this programme, you will be productive enough to shine in your profession. Furthermore, the Data Entry Administrator course covers all the most recent information to keep you updated with the job market and prepare you for your profession. You'll be able to differentiate yourself from the competition in the professional world by keeping an awareness of the tasks and responsibilities of a Data Entry Administrator and how Data Entry operates in different sectors from this course. The course is set up so that it can be accessed through our online learning platform from any device with an internet connection. Because there are no predetermined due dates or class times, you can complete the course at your own time. So start this course today and take your Excel skills to a new level. Enrol right now! Key Learning Objectives of the Data Entry Administrator Training: Gain a thorough introduction to Data Entry, including the common rules and guidelines for Data Entry. Learn more about using Excel for efficient Data Entry. Harness the full power of Microsoft Excel. Gain knowledge of the statistical program and how to apply it for data entry. Get a deeper understanding of formatting a worksheet. Gain adequate knowledge and skills to work professionally within the IT industry. What will make you stand out? On completion of this online course, you will gain: CPD QS Accredited Lifetime access to the whole collection of learning materials. The online test with immediate results You can study and complete the course at your own pace. Study for the course using any internet-connected device, such as a computer, tablet, or mobile device. Data Entry Administrator This course begins with a brief introduction to data entry by showing you how to get set up in tools, how to personalise the tools to your needs and how to create, open and save workbooks. Then it moves on to the common rules and guidelines for data entry. The course then walks you through basic features, including fill, flash fill, autosave, and the various workbook views. It teaches you about the formulae and functions you'll need to know after you've learned these fundamentals. Finally, you'll learn about statistical packages that will enable you to visualise your data. Therefore, reinforce your knowledge and furnish your skills by enrolling in our course. Take one step closer to achieving your goal. CPD 10 CPD hours / points Accredited by CPD Quality Standards Module 01: Introduction to Data Entry 05:06 1: Introduction to Data Entry Preview 05:06 Module 02: Using the Computer for Data Entry 02:56 2: Using the Computer for Data Entry 02:56 Module 03: Common Rules and Guidelines for Data Entry 11:12 3: Common Rules and Guidelines for Data Entry 11:12 Module 04: Using Excel for Efficient Data Entry 04:43 4: Using Excel for Efficient Data Entry 04:43 Module 05: Using Excel's Flash Fill and Autofill to Automate Data Entry 05:50 5: Using Excel's Flash Fill and Autofill to Automate Data Entry 05:50 Module 06: How to Create a Data Entry Form in Excel? 12:38 6: How to Create a Data Entry Form in Excel 12:38 Module 07: Using Statistics Packages in Data Entry 11:31 7: Using Statistics Packages in Data Entry 11:31 Who is this course for? This course is recommended for Anyone who is interested in learning more about Data Entry Administration. Specially, Requirements Without any formal requirements, you can delightfully enrol in this course. Career path Typist Data Keyer Information processor Data entry clerk Data capture specialist These professions pay between £30,000 and £85,000 per year in the UK.

Highlights of the Course Course Type: Online Learning Duration: 3 Hours 54 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 psychology Understand the core competencies and principles of psychology Explore the various areas of psychology Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert psychologist Psychology Online Training Course  Master the skills you need to propel your career forward in psychology. This course will equip you with the essential knowledge and skillset that will make you a confident psychologist and take your career to the next level. This comprehensive psychology online training course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this psychology online training 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 psychology practice and equip you with the essential skills, confidence and competence to assist you in the psychology industry. You'll gain a solid understanding of the core competencies required to drive a successful career in psychology. 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 for psychologist or for people who are aspiring to specialise in psychology. Enrol in this psychology online training 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 psychology online training 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 psychology 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 psychology online training 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 psychology online training 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%. Advance Your Career This psychology online training course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. 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 Perspectives in Psychology What Is Psychology 00:07:00 The Biological Approach 00:10:00 Behaviourist And Cognitive Approaches 00:09:00 Person-Centred Approaches 00:08:00 Debates In Psychology 00:12:00 Social Psychology Social Influence: Compliance, Obedience and Conformity 00:10:00 Social Cognition 00:08:00 Applied Social Psychology 00:09:00 Cognitive Psychology and Its Applications Perception 00:09:00 Attention 00:07:00 Remembering (Memory) 00:09:00 Research Methods In Psychology 00:12:00 Forgetting (Memory) 00:07:00 Language 00:10:00 Thinking (Cognition) 00:07:00 Attitudes 00:09:00 Problem-Solving And Artificial Intelligence 00:09:00 Child Development Issues In Child Development 00:05:00 Cognitive Development 00:06:00 The Development Of Language And Communication 00:06:00 Social Perception (Interpersonal Perception) 00:05:00 Moral Development 00:09:00 The Psychology of Atypical (Abnormal) Behaviour The Definition And Diagnosis Of Atypical (Abnormal) Behaviour 00:06:00 Treatments Of Atypical (Abnormal) Behaviour 00:07:00 Emotional Disorders 00:05:00 Research Methods Research Methods 00:06:00 Research Issues 00:06:00 Data Analysis 00:06:00 Thank You and Good Bye! 00:02:00 Assessment Assessment - Psychology 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00