607 Courses delivered Online

Description: The administrative office is the department assigned to craft and ensure that the rules and procedures are well implemented in a business or organization. This would help in the operations and functions of each department work well. To learn about administrative functions, this bundle course will provide you six fundamental courses: (1) admin support; (2) personal assistant; (3) business writing; (4) customer service; (5) time management; and (6) organizational skills. All of which are fundamental functions of the administrative department that will be a great contribution to the success of any business. Who is the course for? Professionals, employees or businessmen who want to improve the administration department of their company. People who want to know how administrative management works. 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. Certificates can be obtained either in hard copy 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: The Administration Bundle course is a useful qualification to possess, and would be beneficial for the following careers: Accounting Technician Admin Assistant Bookkeeper Civil Service Administrative Officer Data Entry Clerk Finance Officer Hotel Receptionist Legal Secretary Payroll Administrator Liaison Officer Supervisor Typist. Administrative Management Module One - Getting Started 00:30:00 Module Two - Why Your Office Needs Administrative Procedures 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 00:30:00 Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30:00 Personal Assistant Module One - Getting Started 00:30:00 Module Two - Working with Your Manager 01:00:00 Module Three - Administrative Soft Skills 01:00:00 Module Four - Effective Time Management 01:00:00 Module Five - Meeting Management 01:00:00 Module Six - Tools of the Trade (I) 01:00:00 Module Seven - Tools of the Trade (II) 01:00:00 Module Eight - Being an Effective Gatekeeper 01:00:00 Module Nine - Organizational Skills 01:00:00 Module Ten - Confidentiality Guidelines 01:00:00 Module Eleven - Special Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Executive and Personal Assistant Training Course- Activities 00:00:00 Business Writing Module One - Getting Started 00:30:00 Module Two - Working with Words 01:00:00 Module Three - Constructing Sentences 01:00:00 Module Four - Creating Paragraphs 01:00:00 Module Five - Writing Meeting Agendas 01:00:00 Module Six - Writing E-mails 01:00:00 Module Seven - Writing Business Letters 01:00:00 Module Eight - Writing Proposals 01:00:00 Module Nine - Writing Reports 01:00:00 Module Ten - Other Types of Documents 01:00:00 Module Eleven - Proofreading and Finishing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Customer Service Introduction To Customer Service 00:15:00 The Power of Positive Thinking in Customer Service 00:30:00 Types of Difficult Customers and How to Help them 01:00:00 How to Deal with Difficult Customers 00:30:00 Conclusion 00:15:00 Time Management Where Do You Spend Your Time 01:00:00 Managing Tasks 01:00:00 Planning 01:00:00 Goals 01:00:00 Tips From The Gurus 01:00:00 Wrapping Up 00:15:00 Organisational Skills Module One - Getting Started 00:30:00 Module Two - Remove the Clutter 01:00:00 Module Three - Prioritize 01:00:00 Module Four - Scheduling Your Time 01:00:00 Module Five - To Do Lists 01:00:00 Module Six - Paper and Paperless Storage 01:00:00 Module Seven - Organization in Your Work Area 01:00:00 Module Eight - Tools to Fight Procrastination 01:00:00 Module Nine - Organizing Your Inbox 01:00:00 Module Ten - Avoid the Causes of Disorganization 01:00:00 Module Eleven - Discipline is the Key to Stay Organized 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Course for Administrator- Activities 00:00:00 Self Esteem & Confidence Building Module One - Getting Started 01:00:00 Module Two - What Does Self-Confidence Mean To You 01:00:00 Module Three - Obstacles to Our Goals 01:00:00 Module Four - Communication Skills 01:00:00 Module Five - The Importance of Goal Setting 01:00:00 Module Six - Feeling the Part 01:00:00 Module Seven - Looking the Part 01:00:00 Module Eight - Sounding the Part 01:00:00 Module Nine - Powerful Presentations 00:30:00 Module Ten - Coping Techniques 01:00:00 Module Eleven - Dealing with Difficult Behavior 00:30:00 Module Twelve - Wrapping Up 00:15:00 Microsoft Word Module One - Getting Started 00:30:00 Module Two - Opening 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft PowerPoint Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel Module One - Getting Started 00:30:00 Module Two - Opening 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 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Administration Bundle Course 00:30:00 Final Exam Final Exam- Administration Bundle Course 00:30:00

Uncover Excel 2019's potential through our comprehensive Microsoft Excel course. It empowers you to master features, calculations, data analysis, and automation. Whether you're new to spreadsheets or aiming for data expertise, this course is tailored for you. Our Microsoft Excel course simplifies Excel's complexities, making it beginner-friendly. It equips you with skills vital in today's data-driven landscape. Beyond personal growth, this Microsoft Excel course boosts career prospects. Excel proficiency is valuable in a competitive job market, opening doors to diverse opportunities. Our course is a transformative journey into Excel 2019, unlocking potential, enhancing skills, and advancing careers. Whether you're a novice or aspiring data pro, it's your key to Excel's power and your potential. Learning Outcomes of our Microsoft Excel course: Master Microsoft Excel 2019's latest features. Perform complex calculations with ease. Create visually appealing and well-formatted worksheets. Analyze and visualize data effectively using charts and PivotTables. Automate workbook tasks with Excel VBA. Why buy this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Who is this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 for? Individuals new to Microsoft Excel looking to build a strong foundation. Students and job seekers aiming to enhance their employability. Business professionals wanting to improve data management and analysis skills. Entrepreneurs seeking to streamline their business processes. Anyone interested in harnessing the power of Excel for personal or professional growth. Prerequisites This Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £40,000 per year Financial Analyst: £30,000 - £50,000 per year Business Intelligence Analyst: £30,000 - £55,000 per year Operations Manager: £35,000 - £70,000 per year Project Manager: £40,000 - £70,000 per year Excel VBA Developer: £35,000 - £60,000 per year Certification After studying the course materials of the Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 you will be able to take the MCQ test that will assess your knowledge. 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. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Microsoft Excel 2019 New Features 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 Getting Started with Microsoft Office Excel 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 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet 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 Formatting a Worksheet 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 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions 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 Working with Lists 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 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts 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 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data 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 VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Excel Templates Excel Templates 00:00:00 Resources Resources - Microsoft Excel - Beginner Course - Cpd Accredited 00:00:00 Mock Exam Mock Exam - Microsoft Excel Complete Course 2019 00:20:00 Final Exam Final Exam - Microsoft Excel Complete Course 2019 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Get to know how the Business works Do you think with your skills you should be having a career in a company as a Business Administrator? Can you be the corporate man that every company want? Well, you can! This course will teach all you need to know about Business Administration. Business administration is a wide field that incorporates many types of management positions. From major corporations to independent businesses, every operation needs skilled administrators in order to succeed. A career in business touches on information technology, leadership dynamics and increasingly on ethics and international relationships. As a career path You'll have the option to work across industries as a business analyst, human resources generalist, operations manager or marketing specialist. Kickstart your career in Business Administration with this course which will provide everything you need to know in details. Upon completion of this course inExtended Diploma in Business Administration you will find yourself to be easily suited for the corporate job. Business Administration Course Highlights Extended Diploma in Business Administration is an award winning and the best selling course that has been given the CPD Certification & CiQ accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Extended Diploma in Business Administration into 102 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 3 days, 14 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Extended Diploma in Business Administration Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Extended Diploma in Business Administration is CPD certified and CiQ accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Extended Diploma in Business Administration is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and CiQ accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Extended Diploma in Business Administration - Updated Version Representing Your Boss and Company 00:36:00 Skills of an Effective Administrator 00:17:00 Business Writing Skills 00:41:00 Communication Skills 00:27:00 Business Telephone Skills 00:20:00 Mail Services and Shipping 00:28:00 Travel Arrangements 00:25:00 Organising Meeting and Conferences 00:28:00 Time Management 00:35:00 Record Keeping and Filing Systems 00:28:00 Effective Planning and Scheduling 00:52:00 Extended Diploma in Business Administration - Old Version Business Administration What is Business Administration? FREE 01:00:00 Business and Organisations FREE 00:30:00 Management of Business 01:00:00 Business Organization Perspectives 01:00:00 Decision Making 01:00:00 Approaches to Leadership 01:00:00 Business Communication Communication Basics FREE 00:30:00 Know Thyself and The Message FREE 00:30:00 Learn To Use Terms of Business Communication That Invoke Emotions 00:30:00 Pay Attention To Body Language 00:30:00 Learn To Use Terms That Spark Interest 00:30:00 The Benefits Of Presenting Your Message In 1 Minute 00:30:00 Wrapping Up 00:15:00 Finance Management Financing Basics 01:00:00 Record Your Income 01:00:00 Make a List of Expenses First and Put Them in Categories 01:00:00 Countdown & Adjust 01:00:00 Review Regularly 01:00:00 Human Resource Management Module One - Getting Started FREE 00:30:00 Module Two - Human Resources Today FREE 01:00:00 Module Three - Recruiting and Interviewing 01:00:00 Module Four - Retention and Orientation 01:00:00 Module Five - Following Up With New Employees 01:00:00 Module Six - Workplace Health & Safety 01:00:00 Module Seven - Workplace Bullying, Harassment, and Violence 01:00:00 Module Eight - Workplace Wellness 01:00:00 Module Nine - Providing Feedback to Employees 01:00:00 Module Ten - Disciplining Employees 01:00:00 Module Eleven - Terminating Employees 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activites-Professional Diploma in Human Resource Management 00:00:00 Business Writing Module One - Getting Started FREE 00:30:00 Module Two - Working with Words FREE 01:00:00 Module Three - Constructing Sentences 01:00:00 Module Four - Creating Paragraphs 01:00:00 Module Five - Writing Meeting Agendas 01:00:00 Module Six - Writing E-mails 01:00:00 Module Seven - Writing Business Letters 01:00:00 Module Eight - Writing Proposals 01:00:00 Module Nine - Writing Reports 01:00:00 Module Ten - Other Types of Documents 01:00:00 Module Eleven - Proofreading and Finishing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Word Module One - Getting Started FREE 00:30:00 Module Two - Opening Word FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft PowerPoint Module One - Getting Started FREE 00:30:00 Module Two - Opening PowerPoint FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 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 Microsoft Access Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access FREE 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Extended Diploma in Business Administration 00:30:00 Final Exam Final Exam- Extended Diploma in Business Administration 00:30:00

Highlights of the Course Course Type: Online Learning Duration: 11 Hours 11 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 retail analytics and management Understand the core competencies and principles of retail analytics and management Explore the various areas of retail analytics and management Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert retail manager Retail Analytics In Microsoft Excel Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive retail analytics in Microsoft excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this retail analytics in Microsoft excel 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 Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. 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 office admin or for people who are aspiring to specialize in Microsoft excel. Enroll in this retail analytics in Microsoft excel course today and take the next step towards your personal and professional goals. Earn industry-recognized 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 retail analytics in Microsoft excel 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 Microsoft excel 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 retail analytics in Microsoft excel 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 retail analytics in Microsoft excel 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 retail analytics in Microsoft excel 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 Course Introduction Introduction 00:03:00 Part 1: Forecasting Basics of Forecasting 00:05:00 Creating Linear Model with Trendlines 00:08:00 1.1 Getting Data Ready For Regression Model Gathering Business Knowledge 00:03:00 Data Exploration 00:03:00 The Data and the Data Dictionary 00:07:00 Univariate analysis and EDD 00:03:00 Discriptive Data Analytics in Excel 00:10:00 Outlier Treatment 00:04:00 Identifying and Treating Outliers in Excel 00:04:00 Missing Value Imputation 00:03:00 Identifying and Treating missing values in Excel 00:04:00 Variable Transformation in Excel 00:03:00 Dummy variable creation: Handling qualitative data 00:04:00 Dummy Variable Creation in Excel 00:07:00 Correlation Analysis 00:09:00 Creating Correlation Matrix in Excel 00:08:00 1.2 Forecasting Using Regression Model The Problem Statement 00:01:00 Basic Equations and Ordinary Least Squares (OLS) method 00:08:00 Assessing accuracy of predicted coefficients 00:14:00 Assessing Model Accuracy: RSE and R squared 00:07:00 Creating Simple Linear Regression model 00:02:00 Multiple Linear Regression 00:05:00 The F - statistic 00:08:00 Interpreting results of Categorical variables 00:05:00 Creating Multiple Linear Regression model 00:07:00 1.3 Handling Special Events Like Holiday Sales Forecasting in presence of special events 00:02:00 Excel: Running Linear Regression using Solver 00:08:00 Excel: Including the impact of Special Events 00:22:00 1.4 Identifying Seasonality & Trend for Forecasting Models to identify Trend & Seasonality 00:06:00 Excel: Additive model to identify Trend & Seasonality 00:09:00 Excel: Multiplicative model to identify Trend & Seasonality 00:06:00 Market Basket Analysis Market Basket and Lift - Introduction 00:08:00 Named Ranges - Excel 00:10:00 Indirect Function - Excel 00:05:00 2-way lift calculation in Excel 00:11:00 2-way lift calculation - Dynamic 00:07:00 2-way lift data table creation 00:07:00 3-way lift calculation 00:19:00 Store Layout optimization using Lift values 00:15:00 RFM (Recency, Frequency, Monetary) Analysis RFM (recency, frequency, monetary) Analysis 00:08:00 RFM Analysis in Excel- Part 1 00:16:00 RFM Analysis in Excel- Part 2 00:12:00 Part 2: Pricing Part 2: Pricing Steps of setting a Pricing policy 00:03:00 Different Pricing Objectives 00:07:00 2.1 Estimating Demand Estimating Demand 00:07:00 Forms of Demand Curve 00:02:00 Excel: Estimating Linear Demand Curve 00:08:00 Excel: Estimating Power Demand curve with Elasticity 00:05:00 Excel: Estimating Power Demand Curve with points 00:03:00 Subjective Demand curve 00:01:00 Excel: Estimating Subjective Demand Curve 00:02:00 2.3 Evaluating Pricing Strategies Price Bundling 00:07:00 Types of Bundling 00:08:00 The Bundling Problem 00:04:00 Excel: Solving Bundling problem Part 1 00:14:00 Excel: Solving Bundling problem Part 2 00:08:00 Non-Linear Pricing Strategies 00:03:00 Excel: Solving Bundling problem (Price Reversal) 00:08:00 3.1 Lifetime Customer Value Lifetime Customer Value - Key concepts 00:09:00 Lifetime Customer Value - Excel model 00:11:00 3.2 Variations And Sensitivity Analysis Sensitivity Analysis in Excel 00:07:00 Variations in finding customer value 00:07:00 Appendix 1: Excel Crash Course Basics 00:08:00 Worksheet Basics 00:16:00 Entering values and Formulas 00:07:00 Data Handling Basics - Cut, Copy and Paste 00:14:00 Saving and Printing - Basics 00:09:00 Basic Formula Operations 00:13:00 Mathematical Formulas 00:19:00 Textual Formulas 00:17:00 Logical Formulas 00:11:00 Date-Time Formulas 00:07:00 Lookup Formulas ( V Lookup, Hlookup, Index-Match ) 00:08:00 Data Tools 00:19:00 Formatting data and tables 00:18:00 Pivot Tables 00:08:00 Advance Excel- Solver, Data tables 00:15:00 Assessment Assessment - Retail Analytics In Microsoft Excel 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

Overview The Ultimate Microsoft Office 4 Courses Bundle Course will provide you with everything you need to master the skills for confidently using Microsoft Office in the workplace. You will develop the essential knowledge and abilities employers expect in Word, Excel, PowerPoint and Access. This is a unique bundle course that will teach you the essential shortcuts and time-saving tools, including how to modify the programs according to your needs. You will also be tutored in a wide range of topics in an extremely expert manner that will make your life easier, no matter what your work requires. After the completion of this online Microsoft Office training program, you will receive a valid acknowledgement in Microsoft Office, and be able to accomplish office tasks quickly, with greater efficiency. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course 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 Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Requirements There is no specific requirements for our Ultimate Microsoft Office 4 Courses Bundle course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. The course requires a moderate Internet connection so it is possible to start learning with any type of Internet from anywhere at anytime without any limitations.  Course Content Microsoft Excel 2019 Microsoft Excel 2019 New Features 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 Getting Started with Microsoft Excel 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 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet 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 Formatting a Worksheet Apply Text Formats 00:17: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:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Microsoft Word 2019 Microsoft Word 2019 New Features Introduction to Microsoft Word 2019 New Features 00:14:00 Inking Tools 00:03:00 Inking Tools 1 00:07:00 Learning Tools 00:07:00 Microsoft Translate 00:03:00 LaTeX 00:05:00 Smart Lookup 00:04:00 Side to Side Scrolling 00:02:00 Scalable Vector Graphics 00:03:00 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2019 00:00:00 Microsoft PowerPoint 2019 Microsoft PowerPoint 2019 New Features Introduction to Microsoft PowerPoint 2019 New Features 00:06:00 Highlighting 00:02:00 Morph Transition 00:03:00 Zoom 00:03:00 Vector Graphics 00:03:00 SVG Icons to Shapes 00:04:00 3D Modeling 00:04:00 Background Removal 00:03:00 4K 00:03:00 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentatin Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Microsoft Access 2019 Microsoft Access 2019 New Features Introduction to Microsoft Access 2019 New Features 00:05:00 Window Resize 00:01:00 Charts 00:02:00 dbf 00:01:00 Large Number 00:01:00 Property Sorting 00:01:00 Introduction to Access Orientation to Microsoft Access 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00 Assignment Assignment - Ultimate Microsoft Office 4 Courses Bundle 3 weeks, 3 days Order Your Certificate Order your Certificate QLS 00:00:00

Why choose SketchUp Basic to Intermediate Training Course? Click for more info SketchUp offers a user-friendly experience with its intuitive interface, enabling beginners to start smoothly and professionals to work efficiently. The software provides straightforward tools and shortcuts, ensuring precise and speedy creation of 3D models. Duration: 5 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm SketchUp is a popular and robust CAD solution designed for engineers, designers, architects, and more. Its powerful suite of tools includes customizable palettes, lighting effects, animations, textures, and access to the Trimble 3D warehouse. SketchUp Basic Training Course. 1 on 1 Training. 5 hours Understanding the Basics of SketchUpIntroduction to SketchUpNavigating the SketchUp EnvironmentExploring Zoom, Pan, and Rotate FunctionsFamiliarizing Yourself with the XYZ Axis Mastering SketchUp ToolsEfficient Toolbar SelectionsUtilizing Templates for ProjectsDrawing with Precision Using the Pencil ToolWorking with Fundamental Geometric ShapesTaking Accurate Measurements Advanced SketchUp TechniquesCreating Circles and ArcsHarnessing Sticky Geometry SolutionsUnveiling the Power of Tags (Formerly Layers)Streamlining Workflow with Keyboard ShortcutsAccurate Object Measurement within SketchUpInformation Management and Database UsageMoving and Copying ObjectsSimple Array TechniquesMastering Rotational ManipulationsEffortless Rotational CopyingFractional and Relative Scaling Component and Group CreationConstructing Components for ReusabilityCreating Efficient GroupsComparing the Advantages of Components and GroupsSaving and Reusing ComponentsImporting Components from Digital Repositories Advanced Modeling and GeometryLeveraging Push-Pull OperationsCreating Complex Shapes with the Follow Me ToolExploring Geometry IntersectionsDuplicating and Offsetting Faces, Edges, and PolygonsIncorporating 2D Polygons into Your DrawingsSkillful Use of the Paint Bucket Tool Materials and TexturesProficiency with the Materials EditorApplying High-Quality TexturesSourcing and Positioning TexturesGraphics and Bitmap ConsiderationsCrafting Scenes and StylesGenerating and Customizing ScenesManaging Scenes and Styles Introduction to Animation and PresentationAnimation ConceptsAdding Dimensions to Your SketchUp ModelsAnnotating Designs for ClarityPreparing Models for PrintingExporting Images and PDFs in 2D Formats

Microsoft Office 2016 Essentials is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in Microsoft Office and looks at skills needed to improve in relevant industry or Microsoft Office. By taking this course you will gain the necessary skills to perform effectively in this field. The Microsoft Office 2016 Essentials is organised into 97 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 16 hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course 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 Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Course Content Excel 2016 Getting Started with Microsoft Office Excel 2016 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 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet 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 Formatting a Worksheet Apply Text Formats 00:17: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:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Word 2016 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2019 00:00:00 PowerPoint 2016 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentatin Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Access 2016 Introduction to Access Orientation to Microsoft Access 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00 Assignment Assignment - Microsoft Office 2016 Essentials 3 weeks, 3 days Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

The Office Admin and Customer Service Diploma is designed to prepare you for an exciting career in office administration by increasing your skill level in computer applications, public speaking, interpersonal relations, and information management. In addition to skill development, employment preparation is also covered, including resume and cover letter writing, mock interviews, and job shadowing. You will also be able to learn the structures and objectives involved in conducting of admin assistant and customer service. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course 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 Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? Office Admin and Customer Service Diploma is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject. Career path Training offered by the Office Admin and Customer Service Diploma could potentially benefit a range of roles, but would particularly enhance careers in Office Administration Sales Customer Service Receptionist and Secretarial Work Business Management Marketing Other professional admin roles Course Content Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30:00 Administrative Management Module One - Getting Started 00:30:00 Module Two - Why Your Office Needs Administrative Procedures 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Module One - Getting Started 00:30:00 Module Two - Remove the Clutter 01:00:00 Module Three - Prioritize 01:00:00 Module Four - Scheduling Your Time 01:00:00 Module Five - To Do Lists 01:00:00 Module Six - Paper and Paperless Storage 01:00:00 Module Seven - Organization in Your Work Area 01:00:00 Module Eight - Tools to Fight Procrastination 01:00:00 Module Nine - Organizing Your Inbox 01:00:00 Module Ten - Avoid the Causes of Disorganization 01:00:00 Module Eleven - Discipline is the Key to Stay Organized 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Course for Administrator- Activities 00:00:00 Customer Relations and Dealings Module One - Getting Started 00:15:00 Module Two - The Right Attitude Starts with You 00:20:00 Module Three - Stress Management (Internal Stressors) 00:30:00 Module Four - Stress Management (External Stressors) 00:15:00 Module Five - Transactional Analysis 00:25:00 Module Six - Why are Some Customers Difficult 00:20:00 Module Seven - Dealing with the Customer Over the Phone 00:30:00 Module Eight - Dealing with the Customer In Person 00:25:00 Module Nine - Sensitivity in Dealing with Customers 00:20:00 Module Ten - Scenarios of Dealing with a Difficult Customer 00:20:00 Module Eleven - Following up With a Customer Once You Have Addressed Their Issue 00:20:00 Module Twelve - Wrapping Up 00:15:00 Customer Service: Telephone Etiquette Module One - Getting Started 00:05:00 Module Two - Aspects of Phone Etiquette 00:10:00 Module Three - Using Proper Phone Language 00:10:00 Module Four - Eliminate Phone Distractions 00:05:00 Module Five - Inbound Calls 00:05:00 Module Six - Outbound Calls 00:05:00 Module Seven - Handling Rude or Angry Callers 00:10:00 Module Eight - Handling Interoffice Calls 00:05:00 Module Nine - Handling Voicemail Messages 00:05:00 Module Ten - Methods of Training Employees 00:05:00 Module Eleven - Correcting Poor Telephone Etiquette 00:05:00 Module Twelve - Wrapping Up 00:05:00 Customer Relationship Management Customer Relationship Management 00:10:00 What CRM Is and Who It Serves 00:15:00 Checklist for Success 00:15:00 Requirement Driven Product Selection 00:15:00 Considerations in Tool Selection 00:15:00 Strategies for Customer Retention 00:15:00 Building the Future 00:15:00 Homegrown vs. Application Service Provider 00:15:00 Evaluating and Reviewing Your Program 00:15:00 The Development Team 00:15:00 Microsoft Office Word Module One - Getting Started 00:30:00 Module Two - Opening 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Office Powerpoint Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Office Excel Module One - Getting Started 00:30:00 Module Two - Opening 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 Recommended Reading Recommended Reading: Office Admin and Customer Service Diploma 00:00:00 Mock Exam Mock Exam- Office Admin and Customer Service Course 00:30:00 Final Exam Final Exam- Office Admin and Customer Service Course 00:30:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Interact with people to earn good reputation as a Receptionist Do you feel you can have a career as an Office admin or a receptionist? Then what are you waiting for! This course was made for you. The Professional Receptionist Skills Diploma will teach you how to serve visitors by greeting, welcoming, and directing them appropriately; notifies company personnel of visitor arrival; maintains security and telecommunications system. For any company, you need a person to greet clients or customers. A good receptionist helps make a good impression about the company and can enhance the reputation of the company. The business duties of a receptionist may include answering visitors' enquiries about a company and its products or services, directing visitors to their destinations, sorting and handing out mail, answering incoming calls and setting appointments. Professional Receptionist Skills Diploma comprises of units designed to improve your social skills and help you interact better with customers or clients. So what are you waiting for, get the course now! Course Highlights Professional Receptionist Skills Diploma is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Professional Receptionist Skills Diploma into several modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Professional Receptionist Skills Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Professional Receptionist Skills Diploma is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Professional Receptionist Skills Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume.   Professional Receptionist Skills Diploma - Updated Version Introduction to Reception and Receptionist 00:26:00 Business Telephone Skills 00:20:00 Representing Your Boss and Company 00:36:00 Mail Services and Shipping 00:28:00 Travel Arrangements 00:25:00 Organising Meeting and Conferences 00:28:00 Time Management 00:35:00 Record Keeping and Filing Systems 00:28:00 Business Writing Skills 00:41:00 Organisational Skills 00:26:00 Communication Skills 00:27:00 Customer Service 00:17:00 Effective Planning and Scheduling 00:52:00 Invoicing/Petty Cash 00:28:00 Business Environment 00:16:00 Microsoft Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:28: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 Professional Receptionist Skills Diploma - Old Version Module 1: Receptionist Receptionist FREE 00:30:00 Importance of Receptionist FREE 00:15:00 Different Types of Receptionist & Roles 01:00:00 Communication Skills for Receptionist 01:00:00 Telephone Skills 01:00:00 Listening Skills 01:00:00 Taking Messages 00:30:00 Presenting & Appearance 00:30:00 Reservation Procedure 00:15:00 Confidentiality Checklist 00:15:00 Being Organized as Receptionist 00:15:00 Becoming a Successful Receptionist 00:15:00 Module 2: Communication Skills Techniques To Be A Spontaneous Speaker 01:00:00 Knowledge Is Power - So Enrich Your Knowledge 01:00:00 Remarkable Tips To Introduce Yourself 01:00:00 Simple Strategies That Promote Conversations 01:00:00 Speaking From The Heart 01:00:00 Learn To Be A Good Listener First 00:30:00 Stop Bragging About Yourself 01:00:00 Easy Way To Start A Conversation 01:00:00 Handle Criticism Smartly 01:00:00 Asking For What You Want 00:30:00 Module 3: Interpersonal Skills Module One - Getting Started 00:30:00 Module Two - Verbal Communication Skills 01:00:00 Module Three - Non-Verbal Communication Skills 01:00:00 Module Four - Making Small Talk and Moving Beyond 01:00:00 Module Five - Moving the Conversation Along 01:00:00 Module Six - Remembering Names 01:00:00 Module Seven - Influencing Skills 01:00:00 Module Eight - Bringing People to Your Side 01:00:00 Module Nine - Sharing Your Opinion 01:00:00 Module Ten - Negotiation Basics 01:00:00 Module Eleven - Making an Impact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Interpersonal Skills Development Course- Activities 00:00:00 Module 4: Office Management Skills Building Your Management Team 01:00:00 Building A Successful Brand 01:00:00 Achieving Quality Through Teamwork 00:30:00 Keys To Staying Motivated 00:30:00 Improve Your Marketing 01:00:00 Provide Top Customer Service 00:30:00 Wrapping Up 00:30:00 Module 5: Microsoft Word Module One - Getting Started FREE 00:30:00 Module Two - Opening Word FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities- Microsoft Word 00:00:00 Module 6: Microsoft Excel Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 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 Activities - Microsoft Excel 00:00:00 Module 7: Microsoft PowerPoint Module One - Getting Started FREE 00:30:00 Module Two - Opening PowerPoint FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Certified Microsoft PowerPoint for Beginners - Activities 00:00:00 Mock Exam Mock Exam- Professional Receptionist Skills Diploma 00:30:00 Final Exam Final Exam- Professional Receptionist Skills Diploma 00:30:00

The world is comprised of many different people, with many different cultures, who speak many different languages. Even though English is considered the staple international language, not everyone understands or speaks in English. That is why there is a huge need for people in the world to help others learn this language in order to eliminate the language barrier we have. You could be one of these people with the help of this Teaching English as Foreign Language (TEFL) course. This is a very elaborate course but helps you to become the perfect English teacher to those who don't know it so well. It starts with helping you to teach in different situations - as per needs and constraints - and work with many different approaches for different students. Following that there are specific chapters dedicated to help you teach speaking, listening, reading, writing and grammar in English. You will also learn about creating lesson plans and testing as well. The course is filled with exercises and examples to help you in your way to become a great English as a foreign language teacher. Course Highlights Ultimate PHP & MySQL Web Development & OOP Coding is an award winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Ultimate PHP & MySQL Web Development & OOP Coding into 133 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 10 hours, 6 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Ultimate PHP & MySQL Web Development & OOP Coding Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Ultimate PHP & MySQL Web Development & OOP Coding is CPD Qualification Standards and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Ultimate PHP & MySQL Web Development & OOP Coding is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Section 01: Introduction & Setup Introduction 00:02:00 Setup On Windows 00:15:00 Setup On Mac 00:11:00 Setup On Linux 00:12:00 Online Code Editor 00:03:00 Section 02: Basics Basic File Syntax 00:05:00 Printing (echo) 00:06:00 Comments 00:05:00 Variables 00:06:00 Variable Data Types 00:07:00 Variable Naming 00:03:00 Constants 00:02:00 Arrays 00:05:00 Associative Arrays 00:06:00 Multidimensional Arrays 00:04:00 Section 03: Control Structures if Statement 00:06:00 if...else Statement 00:02:00 if...elseif...else Statement 00:05:00 Switch Statement 00:06:00 while Loop 00:06:00 do...While Loop 00:03:00 for Loop 00:03:00 foreach Loop 00:05:00 Break Statement 00:02:00 Continue Statement 00:02:00 Section 04: Functions Basic Function 00:03:00 Passing Function Arguments 00:03:00 Passing Function Arguments By Reference 00:04:00 Default Argument Value 00:02:00 Function Returning Values 00:05:00 Dynamic Function Calls 00:03:00 Variable Scope 00:04:00 Section 05: Forms Simple HTML Form 00:07:00 GET vs POST 00:05:00 $_SERVER ['PHP_SELF'] 00:07:00 Validating Form Data With PHP 00:07:00 Required Fields 00:05:00 Display Error Messages 00:05:00 Validate Name 00:03:00 Validate Email 00:03:00 Validate URL 00:07:00 Keep The Values In The Form 00:04:00 Section 06: File Handling Read File (readfile()) 00:02:00 Open, Read & Close A File (fopen(), fread(), fclose()) 00:04:00 Read Single Line (fgets()) 00:03:00 Check End-Of-File (feof()) 00:02:00 Read Single Character (fgetc()) 00:02:00 Write To File (fwrite()) 00:03:00 Configure php.ini File For File Uploading 00:02:00 Front End HTML Upload Form 00:04:00 PHP Upload Script 00:15:00 Check If File Exists 00:03:00 Limit File Size 00:05:00 Limit File Type 00:04:00 Section 07: MySQL MySQL vs MySQLi vs PDO 00:05:00 Creating A Database & Table (phpMyAdmin) 00:06:00 Connecting To A Database 00:06:00 Get Data Using SELECT Query 00:10:00 WHERE Property For Filtering 00:03:00 LIKE Property For Pattern Search 00:02:00 Sorting Results Using ORDER BY Property 00:01:00 Using JOINS 00:08:00 Insert Data Using INSERT Query 00:04:00 Get ID Of The Last Inserted Row 00:02:00 Insert Multiple Rows 00:05:00 Update Data Using UPDATE Query 00:03:00 Delete Data Using DELETE Query 00:02:00 Delete All Rows In A Table Using TRUNCATE Query 00:02:00 Delete Table Using DROP Query 00:02:00 Limit Data Selections Using LIMIT, ROWNUM 00:04:00 Create Table Using CREATE Query 00:03:00 Clone/Duplicate Table 00:03:00 Alter Table 00:05:00 Create Database 00:02:00 Drop Database 00:02:00 SQL Injection & Prepared Statements 00:09:00 Section 08: XML What Is XML? 00:02:00 What Is SimpleXML? 00:02:00 Parse XML String 00:08:00 Parse XML File 00:02:00 Get Node Values 00:02:00 Get Node Values of Specific Elements 00:03:00 Get Node Values - Loop 00:03:00 Get Attribute Values 00:02:00 What Is The XML Expat Parser? 00:02:00 Initializing The XML Expat Parser 00:10:00 Load and Output XML Using DOM Parser 00:02:00 Looping Through XML Using DOM Parser 00:03:00 Section 09: AJAX What Is AJAX? 00:02:00 Load Simple Data Using AJAX Front End 00:08:00 Load Simple Data Using AJAX Back End 00:05:00 Load Data From A Database Using AJAX 00:08:00 Section 10: Emails Send A Plain Text Email 00:04:00 Send A HTML Email 00:06:00 Email Attachments 00:17:00 PHPMailer Setup 00:03:00 Send Email Using PHPMailer 00:04:00 Send HTML Email Using PHPMailer 00:04:00 Email Attachments Using PHPMailer 00:02:00 Section 11: Object Oriented Programming What Is Object Oriented Programming (OOP)? 00:03:00 Basic Class With Variables 00:04:00 Functions 00:05:00 Constructor 00:04:00 Destructor 00:02:00 Inheritance 00:06:00 Multi Class Inheritance 00:03:00 Function Overriding 00:03:00 Public vs Private vs Protected 00:05:00 Interfaces 00:04:00 Constants 00:03:00 Abstract Class 00:06:00 Static Keyword 00:03:00 Final Keyword 00:02:00 Initiating Parent Constructor 00:02:00 Section 12: Error Handling die() Function 00:02:00 Custom Error Handler 00:04:00 Triggering An Exception 00:03:00 Exception Handling 00:05:00 Create Database & Table 00:04:00 User Class & Database Connection 00:15:00 Register User Form 00:09:00 Inserting User Data Into Database 00:10:00 Registration Form Field Validation 00:12:00 Securing User Password 00:03:00 Check If Username or Email Already Exists 00:11:00 Retain Data After Failed Registration 00:03:00 Section 13: Advanced Validate an Integer Within a Range 00:04:00 Validate IPv6 Address 00:03:00 Validate URL - Must Contain QueryString 00:03:00 Remove Characters With ASCII Value > 127 00:04:00 Including & Requiring External PHP Files 00:05:00 Section 14 : Resource Resource 00:00:00 Assignment Assignment - Ultimate PHP & MySQL Web Development & OOP Coding 00:00:00