Overview Master the use of the world's most popular data analysis and office tool, with absolutely no previous experience or training needed.This course will help you quickly become an expert in the use of Microsoft's best-selling Excel, allowing you to be a valuable asset to any business or organisation.The Microsoft Excel Level 3course will teach you how to manage finances, produce spreadsheets, and file invoices in no time. Our innovative training method will have you visualising and presenting company data efficiently. Learn to impress your peers and managers with your intuitive use of Excel and make sure that your administration skills are faultless. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel Level 3. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel Level 3 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 21 sections • 73 lectures • 10:39:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Excel Templates: 00:00:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Microsoft Excel Level 3: 00:00:00
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 Give a compliment to your career and take it to the next level. This Know Your Customer (KYC) will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Know Your Customer (KYC) will help you keep ahead of the pack. The Know Your Customer (KYC) incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and essential knowledge, reaching out to the level of expertise required for your position. Further, this coursewill add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Know Your Customer (KYC), you can equip yourself with the essentials to keep you afloat into the competition. Along with this Know Your Customer (KYC) course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. What other courses are included with this Know Your Customer (KYC)? Course 01: Know Your Customer (KYC) Course 02: Sales: Psychology of Customers Course 03: Customer Relationship Management Course 04: Phone-Based Customer Service Course 05: Retail Management - Level 5 Course 06: GCSE English Course 07: Public Speaking and Presentation Skill Course Course 08: The Formula to Talk with Strangers Course 09: Level 2 Microsoft Office Essentials Course 10: Time Management Course 11: Stress Management Training So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Know Your Customer (KYC): One payment, but lifetime access to 11 CPD courses Certificate, 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 and in-demand skills without leaving your home. 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. Curriculum of Know Your Customer (KYC) Bundle Course 01: Know Your Customer (KYC) Module 01: Introduction to KYC Module 02: Customer Due Diligence Module 03: AML (Anti-Money Laundering) Module 04: KYC, AML, and Data Privacy Regulations for Businesses Operations in the United Kingdom Module 05: Regulations to be Complied by Industries Module 06: Methods for carrying out KYC and AML and the Future of KYC Compliance Course 02: Sales: Psychology of Customers Introduction Introducing A.S.K - concentrating on 'A' for ATTRACT. Section 3 The 'S' of A.S.K. - SERVING Section 4 The K of A.S.K Section 5 ...And lastly... Course 03: 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 04: Phone-Based Customer Service Module 1: Introduction to Customer Service Module 2: What's Different about Good Customer Service? Module 3: Customer Relationship Management Module 4: Customer Service Communication Strategies Module 5: Aspects of Phone Etiquette Module 6: Building Rapport Over the Phone Module 7: Inbound and Outbound Calls Module 8: Active Listening and Managing Tough Callers Module 9: Managing Interoffice Calls and Voicemail Module 10: Problem Solving over the Phone Module 11: Intra Organisation Dealings Module 12: Measuring Customer Service Course 05: Retail Customer Service Training Module 01: Who We Are and What We Do Module 02: The Sales Process and Dealing with Customers at the Checkout Module 03: Importance of Consumer Behaviour Module 04: Taking Trends and Targeting Customers Effectively Module 05: The Importance of Communicating with Customers Module 06: Identifying and Addressing Customer Needs Module 07: Generating Return Business Module 08: In-Person Customer Service Module 09: Giving Customer Service over the Phone Module 10: Providing Electronic Customer Service Module 11: Recovering Difficult Customers Module 12: Understanding When to Escalate Course 06: GCSE English Module 01: Introduction to GCSE English Module 02: Edexcel English Section A Part 01 Module 03: Edexcel English Section A Part 02 Module 04: Edexcel English Section B Module 05: Edexcel English Section C and many more... Course 07: Public Speaking and Presentation Skill Course Introduction QUICK UNLEARNING Before Starting this "SKILL" IS THIS HAPPENED WITH YOU???? Impressive Methods of Hooking Audience, even before your Speech or Presentation 6 Highly Impressive Methods of Starting any Speech or Presentation!! Body Language: 6 Methods for Impressive Body Language for Speech or Presentation Vocal Variety: 3 Methods (VST) for POWERFUL Vocal Variety Effective Methods of Ending Any Speech or Presentation Bonus Course 08: The Formula to Talk with Strangers Section 01: Course Overview Section 02: The Formula Section 03: Summary Section 04: End Course 09: Level 2 Microsoft Office Essentials ***Excel 2016*** Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks ***Word 2016*** Getting Started with Word Formatting Text and Paragraphs Working More Efficiently Managing Lists Adding Tables Inserting Graphic Objects Controlling Page Appearance Preparing to Publish a Document Workbooks - Microsoft Word 2016 (Beginner) ***PowerPoint 2016*** PowerPoint Interface Presentation Basics Formatting Inserting Options Working with Objects Table Charts Review and Presentatin ***Access 2016*** Introduction to Access Modify Data Working with Queries Access Forms Working with Reports Course 10: Time Management Identifying Goals Effective Energy Distribution Working with Your Personal Style Building Your Toolbox Establishing Your Action Plan Course 11: Stress Management Training Beginning Concepts Specific Stress Management Techniques MORE Stress Reduction Strategies Still MORE Stress Reduction Techniques - Part 1 Still MORE Stress Reduction Techniques - Part 2 Still MORE Stress Reduction Techniques - Part 3 BONUS Video & Wrap Up! Special LIVE Bonus Video! CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Know Your Customer (KYC) bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Know Your Customer (KYC) is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various CPD certificate will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included
This Data Analyst Mini Bundle serves up a tight, targeted mix of data-driven subjects designed to help you understand the numbers—without needing a maths degree or a spreadsheet obsession. From handling large data sets to making sense of Google Analytics, each course adds a distinct layer of technical capability with a straight-talking approach. Whether you're fine-tuning pivot tables in Excel or learning to visualise data with Tableau, this bundle connects the dots between raw figures and business insights. With added focus on data entry accuracy and analysis structure, it’s designed to keep things sharp, clean, and relevant to the platforms that matter most. ✅ Learning Outcomes Understand the fundamentals of data input and error-free entry. Organise, filter and interpret data using Excel tools efficiently. Track digital behaviour with confidence using Google Analytics. Create visual dashboards in Tableau for clear business reporting. Break down datasets to identify patterns and data trends. Apply essential data analysis methods across common platforms. ✅ Who is this Course For Those entering data analysis or digital tracking industries. Professionals needing to polish up Excel and Google Analytics. Jobseekers aiming to shift into data-centric office roles. Admins and assistants handling regular data reporting duties. Marketers tracking campaign results and site behaviour. Freelancers offering reporting and data-related services. Junior analysts seeking foundational digital tools knowledge. Learners exploring analytical roles with entry-level tools. ✅ Career Path Junior Data Analyst – £28,000 average UK salary Data Entry Clerk – £23,000 average UK salary Marketing Analyst – £32,000 average UK salary Reporting Assistant – £26,000 average UK salary Analytics Support Executive – £30,000 average UK salary Excel Specialist – £29,500 average UK salary
Start your productivity potential! Master Microsoft Office with our comprehensive Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Conquer Excel formulas (VLOOKUP, HLOOKUP, XLOOKUP!), design impactful presentations in PowerPoint, and craft professional documents in Word. Take your skills to the next level and unlock a world of opportunity. Enrol now and become a Microsoft Office pro!
Course Overview This comprehensive Data Analytics course provides an in-depth exploration of data analysis, covering the essential principles and techniques used to extract valuable insights from data. Learners will engage with core concepts, such as data mining, statistical analysis, and visualisation, enabling them to make informed decisions and drive business outcomes. By the end of the course, participants will have the skills to analyse and interpret data, apply analytical tools effectively, and present their findings clearly. This course equips learners with the necessary tools to understand and leverage data in various professional settings, adding significant value to their career prospects. Course Description The Data Analytics course covers a wide range of topics, including the fundamentals of data analysis, statistical methods, and various data visualisation techniques. Learners will explore essential tools such as Excel and specialised software, while gaining a deep understanding of how to collect, store, and process data effectively. Emphasis is placed on developing the analytical mindset required to interpret data accurately and draw actionable insights. This course is designed to ensure learners can confidently navigate the world of data analytics and apply their knowledge in diverse industries, enhancing their problem-solving and decision-making abilities. Course Modules Module 01: Introduction to the World of Data Module 02: Basics of Data Analytics Module 03: Statistics for Data Analytics Module 04: Actions Taken in the Data Analysis Process Module 05: Gathering the Right Information Module 06: Storing Data Module 07: Data Mining Module 08: Excel for Data Analytics Module 09: Tools for Data Analytics Module 10: Data-Analytic Thinking Module 11: Data Visualisation That Clearly Describes Insights Module 12: Data Visualisation Tools (See full curriculum) Who is this course for? Individuals seeking to enhance their analytical skills for data-driven decision-making. Professionals aiming to transition into data analytics or enhance their data-related roles. Beginners with an interest in understanding data and its applications across industries. Business professionals seeking to leverage data for strategic growth. Career Path Data Analyst Business Intelligence Analyst Data Scientist Market Research Analyst Operations Analyst Financial Analyst Business Analyst Data Visualisation Specialist
Course Overview The "Microsoft Excel Complete Course" is designed to equip learners with the essential skills to master Microsoft Excel, one of the most widely used tools in data analysis and business operations. This course covers a comprehensive range of topics, including Excel's new features, formula creation, data visualisation, and workbook management. It offers practical knowledge that will help learners work more efficiently, whether they are managing large datasets, analysing trends, or presenting information. By the end of this course, learners will be confident in using Excel for various business tasks, gaining a strong foundation for further professional development. Course Description This course covers all key aspects of Microsoft Excel, from the basics to advanced techniques. Learners will explore Excel’s new features in the 2019 version, as well as how to perform calculations, modify worksheets, and apply formatting. The course delves into functions, lists, and data analysis tools, including PivotTables and charts. Learners will also learn how to work with multiple worksheets and workbooks, use lookup functions, and automate workbook functionality. With a focus on essential Excel tools and techniques, learners will gain the ability to efficiently manage and analyse data for business or personal use. Course Modules Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Office Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Working with Functions Module 09: Working with Lists Module 10: Analyzing Data Module 11: Visualizing Data with Charts Module 12: Using PivotTables and PivotCharts Module 13: Working with Multiple Worksheets and Workbooks Module 14: Using Lookup Functions and Formula Auditing Module 15: Sharing and Protecting Workbooks Module 16: Automating Workbook Functionality Module 17: Creating Sparklines and Mapping Data Module 18: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to improve their data management and analysis skills. Professionals aiming to enhance their productivity in Excel for business applications. Beginners with an interest in data analysis or office administration. Anyone looking to build a strong foundation in Excel for career advancement. Career Path Data Analyst Financial Analyst Office Administrator Project Manager Business Analyst Operations Manager Administrative Assistant HR Specialist
Duration 5 Days 30 CPD hours This course is intended for This course is designed for students who want to learn the R programming language, particularly students who want to leverage R for data analysis and data science tasks in their organization. The course is also designed for students with an interest in applying statistics to real-world problems. A typical student in this course should have several years of experience with computing technology, along with a proficiency in at least one other programming language. Overview In this course, you will use R to perform common data science tasks.You will: Set up an R development environment and execute simple code. Perform operations on atomic data types in R, including characters, numbers, and logicals. Perform operations on data structures in R, including vectors, lists, and data frames. Write conditional statements and loops. Structure code for reuse with functions and packages. Manage data by loading and saving datasets, manipulating data frames, and more. Analyze data through exploratory analysis, statistical analysis, and more. Create and format data visualizations using base R and ggplot2. Create simple statistical models from data. In our data-driven world, organizations need the right tools to extract valuable insights from that data. The R programming language is one of the tools at the forefront of data science. Its robust set of packages and statistical functions makes it a powerful choice for analyzing data, manipulating data, performing statistical tests on data, and creating predictive models from data. Likewise, R is notable for its strong data visualization tools, enabling you to create high-quality graphs and plots that are incredibly customizable. This course will teach you the fundamentals of programming in R to get you started. It will also teach you how to use R to perform common data science tasks and achieve data-driven results for the business. Lesson 1: Setting Up R and Executing Simple Code Topic A: Set Up the R Development Environment Topic B: Write R Statements Lesson 2: Processing Atomic Data Types Topic A: Process Characters Topic B: Process Numbers Topic C: Process Logicals Lesson 3: Processing Data Structures Topic A: Process Vectors Topic B: Process Factors Topic C: Process Data Frames Topic D: Subset Data Structures Lesson 4: Writing Conditional Statements and Loops Topic A: Write Conditional Statements Topic B: Write Loops Lesson 5: Structuring Code for Reuse Topic A: Define and Call Functions Topic B: Apply Loop Functions Topic C: Manage R Packages Lesson 6: Managing Data in R Topic A: Load Data Topic B: Save Data Topic C: Manipulate Data Frames Using Base R Topic D: Manipulate Data Frames Using dplyr Topic E: Handle Dates and Times Lesson 7: Analyzing Data in R Topic A: Examine Data Topic B: Explore the Underlying Distribution of Data Topic C: Identify Missing Values Lesson 8: Visualizing Data in R Topic A: Plot Data Using Base R Functions Topic B: Plot Data Using ggplot2 Topic C: Format Plots in ggplot2 Topic D: Create Combination Plots Lesson 9: Modeling Data in R Topic A: Create Statistical Models in R Topic B: Create Machine Learning Models in R
Duration 3 Days 18 CPD hours This course is intended for This course is intended for: Database architects Database administrators Database developers Data analysts and scientists Overview This course is designed to teach you how to: Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution Architect the data warehouse Identify performance issues, optimize queries, and tune the database for better performance Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data Module 1: Introduction to Data Warehousing Relational databases Data warehousing concepts The intersection of data warehousing and big data Overview of data management in AWS Hands-on lab 1: Introduction to Amazon Redshift Module 2: Introduction to Amazon Redshift Conceptual overview Real-world use cases Hands-on lab 2: Launching an Amazon Redshift cluster Module 3: Launching clusters Building the cluster Connecting to the cluster Controlling access Database security Load data Hands-on lab 3: Optimizing database schemas Module 4: Designing the database schema Schemas and data types Columnar compression Data distribution styles Data sorting methods Module 5: Identifying data sources Data sources overview Amazon S3 Amazon DynamoDB Amazon EMR Amazon Kinesis Data Firehose AWS Lambda Database Loader for Amazon Redshift Hands-on lab 4: Loading real-time data into an Amazon Redshift database Module 6: Loading data Preparing Data Loading data using COPY Data Warehousing on AWS AWS Classroom Training Concurrent write operations Troubleshooting load issues Hands-on lab 5: Loading data with the COPY command Module 7: Writing queries and tuning for performance Amazon Redshift SQL User-Defined Functions (UDFs) Factors that affect query performance The EXPLAIN command and query plans Workload Management (WLM) Hands-on lab 6: Configuring workload management Module 8: Amazon Redshift Spectrum Amazon Redshift Spectrum Configuring data for Amazon Redshift Spectrum Amazon Redshift Spectrum Queries Hands-on lab 7: Using Amazon Redshift Spectrum Module 9: Maintaining clusters Audit logging Performance monitoring Events and notifications Lab 8: Auditing and monitoring clusters Resizing clusters Backing up and restoring clusters Resource tagging and limits and constraints Hands-on lab 9: Backing up, restoring and resizing clusters Module 10: Analyzing and visualizing data Power of visualizations Building dashboards Amazon QuickSight editions and feature
With a single payment you will gain access to Event Planner including 10 additional premium courses, original hardcopy certificate, 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 with this Event Planner Complete Bundle: Course 01: Event Planner Course 02: Event Management Course 03: Catering Management Course 04: Business Analysis Level 3 Course 05: Interior Design Professional Diploma Course 06: Effective Communication Skills Course 07: Basic Adobe Photoshop Course 08: Professional Photography Diploma Course 09: Customer Relationship Management Course 10: Baking and Cake Decorating Level 2 Course 11: Health and Safety at Workplace If you want to gain a solid understanding of Event Planner and fast track your dream career, then take a step in the right direction with this industry-standard, comprehensive Event Planner course designed by expert instructors. The Event Planner will cover a comprehensive range of 12, you'll have 24/7 online access to the study materials, introductory videos, assessment tests, study resources and tutor support for a lifetime. The Event Planner will help you to develop your skills, confidence and knowledge of this sector, helping to add real value to your CV and personal development. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Event Planner has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Event Planner is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Whether you are looking to brighten up your CV, just starting out in the industry, looking for a career change or just fancy learning something new, this online Event Planner course is perfect! Benefits you'll get choosing Apex Learning for this Event Planner: 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 Course 01: Event Planner Module 01: Introduction to Event Management Module 02: Role of an Event Planner Module 03: Event Classification Module 04: Events and Clients Module 05: Steps to Plan an Event Module 06: Invitation to the Event Module 07: Event Marketing Module 08: Catering at Events Module 09: Event Decorations Module 10: Cleaning and Waste Disposal Module 11: Event Security Module 12: Developing an Event Planning Business Course 02: Event Management Event Planning Steps for Planning an Event Invitations, Greetings, and Dress Code Table Manners and Table Settings The Event What is Event Management Types of Events Course 03: 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 04: Business Analysis Level 3 Module 01: Introduction to Business Analysis Module 02: Business Processes Module 03: Business Analysis Planning and Monitoring Module 04: Strategic Analysis and Product Scope Module 05: Solution Evaluation Module 06: Investigation Techniques Module 07: Ratio Analysis Module 08: Stakeholder Analysis and Management Module 09: Process Improvement with Gap Analysis Module 10: Documenting and Managing Requirements Module 11: Career Prospect as a Business Analyst in the UK Course 05: 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 06: Effective Communication Skills Introduction To Communication - Goals & Benefits Key Principles Of Communication We are Always Communicating Fundamentals Of Communication - Part 1 Fundamentals Of Communication - Part 2 Great Communication Tips - Part 1 Great Communication Tips - Part 2 Self-Talk & Powerful Language Miscommunication Still MORE Great Tips! Part 1 Still MORE Great Tips! Part 2 Still MORE Great Tips! Part 3 Final Thoughts and Suggestions PROMO Communication (BEST) Course 07: Basic Adobe Photoshop Section 01: Shortcuts & the Brush Section 02: Layers Section 03: Modify Your Portrait Section 04: Watermark & Figures Section 05: Modify Your Text Course 08: Professional Photography Diploma Introduction Exposure Digital Photography Masterclass Focus and Depth of Field Camera Anatomy White Balance and Color Lighting Mobile Photography Equipment - Cameras Equipment - Lenses Equipment - Accessories Photo Scenario - Portrait Photo Scenario - Long Exposure Photo Scenario - Landscape Photo Scenario - Product Photo Scenario - Low Light Photo Scenario - Sports & Action Photo Scenario - Macro Photo Scenario - Street & Architecture Photo Scenario - Events Photo Scenario - Aerial Photo Scenario - Night Intro to Photo Editing Photoshop CC Lightroom Classic CC Lightroom CC Mac Photos Google Photos Photoshop Express Snapseed Sharing Your Photos Starting a Photo Business Selling Stock Photos Printing Wildlife Conclusion Course 09: 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 10: Baking and Cake Decorating Level 2 Module 01: Sophisticated Baking & Cake Design Module 02: Icing Module 03: Fondant Making Module 04: Decorating with Fondant Module 05: Everything in Brief 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 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous certifications required for enrolment on this bundle. It is available to all students, of all academic backgrounds. Requirements Our bundle 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 Having these various CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Certificates Certificate of completion Digital certificate - Included
Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Save Up To £4,169 and get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now 'If eyes are the windows to the soul, then shop windows are just as revealing. They reveal the soul of the shop.' - Debra Templar, the founder and owner of the Templar Group. Wondering why all the time you love the dresses or shops that display lovely mannequins? It happens as they choose the best outfit for the dummy. If you want to learn the tips for increasing your sales through practical ways, the Visual Merchandising Diploma course is designed for you. Merchandising refers to the activities of promoting sales or goods. Then what is Visual Merchandising? Simply, it means the visual presentation for boosting your sales. Visual Merchandising is the technique when products or services are highlighted for attracting, engaging, and motivating the customers. One of the best ways of Visual Merchandising is the use of dummy or mannequins. The course provides a masterclass in interior and exterior design work, utilising displays, products, and logos to target a paying audience. You will be taught how to use mannequins and fixtures to draw attention, and then subliminally direct people to the stock and products that you want to highlight. Learn the secrets to shopping success by enrolling now Become a 'secret weapon' in the dynamic retail industry and use your artistic skills to attract customers and make sales. This engaging and comprehensive course presents all the techniques that an accomplished Visual Merchandiser will use to catch the consumer's eye. If you work with retail displays or are thinking about opening your own store, this specialist course is for you. From Visual Merchandising to Window Display Skills, learn the tools to plan, design and create innovative retail environments and enhance the customer experience. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Along with this course, you will get 10 premium courses, an original hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Bundle Consists of the following Premium courses: Course 01: Visual Merchandising Course 02: Mastering Colour - Architectural Design & Interior Decoration Course 03: Basic Product Management Course 04: Retail Management - Level 5 Course 05: Warehouse Course 06: Strategic Planning and Analysis for Marketing Course 07: Business Branding Course 08: Customer Relationship Management Course 09: Sales: Psychology of Customers Course 10: Effective Communication Skills Diploma Course 11: Product Photography So, enrol now to advance your career! Benefits you'll get choosing Apex Learning: Pay once and get lifetime access to 11 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed 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 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 £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Curriculum Course 01: Visual Merchandising Module 01: Introduction Module 02: Store Layouts Introduction to Store Layouts Role of a Store Planner Techniques for Creating Effective Store Layouts Aims and Purposes of Store Layouts Putting Together the Layouts Module 03: Exterior Design Exterior Signs Marquees and Banners Walks and Entries Landscaping Window Displays Module 04: In-Store Design Creating an Appealing Store Atmosphere Lighting Colour Music and Scent How Exciting Should a Store Be? Module 05: Mannequins in Visual Merchandising Dressing A Mannequin Securing A Mannequin Grouping Mannequins Maintenance Importance of Mannequins Module 06: Display Fixtures Different Types of Display Fixtures Horizontal Fixtures Vertical Fixtures Shop Fits, Vendor and Specialist Fixtures Wall Fixtures Module 07: The Role of a Visual Merchandiser The Day-To-Day Role of a Visual Merchandiser Visual Merchandising for Department Stores Visual Merchandising for Multiple Chain Stores Small Stores Visual Merchandising Measuring Success Visual Merchandising Module 08: Challenges of Modern Visual Merchandising Deficiency of New Technologies Limited Display Space Budget Constraints Lack of Flexibility Traditional Blueprints Course 02: Mastering Colour - Architectural Design & Interior Decoration Introduction The Impact of Fashion and Colour Trends Colour Terminology Colour Basics and Neutral Colours Warm vs. Cool Colours Colour Schemes Colour Ratios and Applications Using Colour to Trick the Eye Conclusion Course 03: Basic Product Management Module 01: Course Introduction - Product Module 02: Definition of Product Module 03: Classification of Product Module 04: Consumer Goods Module 05: Business Goods Module 06: Levels of a Product Module 07: Product Quality Module 08: Product Mix Module 09: Product Life Cycle Module 10: Branding Module 11: Branding Strategies Module 12: Brand Equity Course 04: Retail Management - Level 5 Introduction to Retail Management Retail Strategy Retail Buying and Merchandising Retail Pricing Supply Chain Management in Retailing The Sales Process and Dealing with Customers at the Checkout Importance of Consumer Behaviour Taking Trends and Targeting Customers Effectively The Importance of Communicating with Customers Choosing a Retail Location Retail Psychology Negotiate the Right Deal with Suppliers Develop Store Security Procedures Management Skills for Leading Your Team Selling in Multiple Channels Retail Brand Management Health & Safety for Retail Stores Consumer Rights Act Course 05: Warehouse Fundamentals of Warehouse Management Warehousing: Function, Benefits and Types of Warehousing Core Functions Of A Warehouse Management System Challenges Of Warehouse Management Technology In The Warehouse Supply Chain Management Concepts Warehouse Management Technologies to Adopt Order Picking in the Warehouse Managing Warehouse Inventory Organize the Storage of Inventory in a Warehouse Inventory Management Techniques Inventory Control Flow of Processing Logistics and Supply Chain In A Warehouse Inventory Classification In The Warehouse The Role Of Human Resource management In A Warehouse Warehouse Safety Warehouse Cost Management Improve Warehouse Efficiency and Reduce Costs Course 06: Strategic Planning and Analysis for Marketing An Introduction to Strategic Planning Development of a Strategic Plan Strategic Planning for Marketing Strategic and Marketing Analysis Internal Analysis External Analysis Market Segmentation, Targeting and Positioning Course 07: Business Branding Business Course Promo Video Chapter1 Chapter2 Chapter3 Chapter4 Chapter5 Chapter6 Chapter7 Chapter8 Chapter9 Course 08: 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 09: Sales: Psychology of Customers Introduction Introducing A.S.K - concentrating on 'A' for ATTRACT. Section 3 The 'S' of A.S.K. - SERVING Section 4 The K of A.S.K Section 5 ...And lastly... Course 10: Effective Communication Skills Diploma Business Communication Verbal and Non-verbal Communication Written Communication Electronic Communication Communicating with Graphic Effectively Working for Your Boss Course 11: Product Photography Photography 101 -Your Simple Outline! Learning to shoot in Manual Mode The 'Pre-Production' Phase The Background Lighting & Love The Actual Photoshoot! Post-Production Phase The Final Word CPD 110 CPD hours / points Accredited by CPD Quality Standards Requirements There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Visual Merchandising) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.