855 Microsoft Excel courses delivered Online

In the digital age, the demand for data entry roles has skyrocketed, offering opportunities for individuals to embark on a flexible career path. Whether you're in the heart of London or nestled in the serene countryside, data entry jobs from home in the UK have become a sought-after option for many. Our 'Data Entry Administrator at QLS Level 3' course is designed to equip you with the skills needed to excel in remote data entry jobs. Dive deep into the world of Microsoft Office Excel 2016, from the basics of worksheet modifications to mastering workbook management. By the end of this course, you'll be well-versed in making tasks a breeze, ensuring you stand out in the competitive job market. So, what are you waiting for enroll into our course now and prepare yourself for data entry jobs now! Learning Outcomes: Understand the nuances of data entry and the tools that simplify the process. Acquire proficiency in using Microsoft Office Excel 2016, from its foundational aspects to advanced features. Develop the ability to perform accurate calculations and modify worksheets effectively. Master the art of formatting worksheets to present data in a clear and professional manner. Gain expertise in printing and managing workbooks efficiently. Why buy this Data Entry Administrator at QLS Level 3 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Data Entry Administrator at QLS Level 3 Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this Data Entry Administrator at QLS Level 3 course for? Individuals keen on pursuing data entry jobs from home in the UK. Those looking to transition into remote data entry roles. Professionals aiming to enhance their proficiency in Microsoft Excel 2016. Job seekers wanting to add a valuable skill to their CV. Anyone interested in mastering the art of efficient data management. Career path Data Entry Clerk: Average salary range: £18,000 - £22,000 Annually Excel Specialist: Average salary range: £25,000 - £30,000 Annually Worksheet Formatter: Average salary range: £21,000 - £26,000 Annually Data Analyst: Average salary range: £30,000 - £40,000 Annually Workbook Manager: Average salary range: £28,000 - £34,000 Annually Office Administrator: Average salary range: £20,000 - £25,000 Annually Prerequisites This Data Entry Administrator at QLS Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Entry Administrator at QLS Level 3 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. 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 £85 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 Making Data Entry Jobs Easier Introduction to Data Entry 00:20:00 Using the Computer for Data Entry 00:15:00 Common Rules and Guidelines for Data Entry 00:30:00 Using Excel for Efficient Data Entry 00:30:00 Using Excel's Flash Fill and Autofill to Automate Data Entry 00:30:00 How to Create a Data Entry Form in Excel? 00:45:00 Using Statistics Packages in Data Entry 00:45:00 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: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 Assignment Assignment - Data Entry Administrator at QLS Level 3 00:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Microsoft Office 2016 Essentials is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Office 2016 Essentials and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 17 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. 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: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 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:05: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

Highlights of the Course Course Type: Online Learning Duration: 4 Hours 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 Microsoft PowerPont Understand the core competencies and principles of Microsoft PowerPont Explore the various areas of Microsoft PowerPont Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft PowerPoint 2016/2019/365 - Foundations for Beginners Course Master the skills you need to propel your career forward in Microsoft PowerPoint. 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 Microsoft PowerPoint course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft PowerPoint 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 PowerPoint practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft PowerPoint industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft PowerPoint. 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 specialise in Microsoft PowerPoint. Enrol in this Microsoft PowerPoint course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft PowerPoint 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 PowerPoint 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 Microsoft PowerPoint 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 Microsoft PowerPoint 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 Microsoft PowerPoint 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. Course Curriculum Getting Started With PowerPoint Navigate the PowerPoint Environment - Introduction 00:01:00 Navigate the PowerPoint Environment 00:11:00 View and Navigate a Presentation - Introduction 00:01:00 View and Navigate a Presentation 00:09:00 Create and Save a PowerPoint Presentation - Introduction 00:01:00 Create and Save a PowerPoint Presentation 00:07:00 Use PowerPoint Help - Introduction 00:01:00 Use PowerPoint Help 00:06:00 Developing a PowerPoint Presentation Select a Presentation Type - Introduction 00:01:00 Select a Presentation Type 00:06:00 Edit Text 00:10:00 Add, Delete and Modify Slides 00:09:00 Work with Themes - Introduction 00:01:00 Work With Themes 00:05:00 Performing Advanced Text Editing Operations Format Characters - Introduction 00:01:00 Format Characters 00:08:00 Format Paragraphs - Introduction 00:01:00 Text Alignment Options 00:08:00 Text Alignment Options 00:08:00 Format Text Boxes 00:10:00 Adding Graphical Elements to Your Presentation Add Graphical Elements to Your Presentation - Introduction 00:01:00 Insert Images 00:08:00 Insert Shapes 00:08:00 Modifying Objects in Your Presentation Modify Objects In Your Presentation - Introduction 00:01:00 Edit Objects 00:09:00 Format Objects 00:08:00 Animate Objects 00:06:00 Adding Tables to Your Presentation Add A Table - Introduction 00:01:00 Create a Table 00:05:00 Format a Table 00:07:00 Insert A Table From Others Office Applictions 00:08:00 Adding Charts to Your Presentation Add A Chart - Introduction 00:01:00 Create a Chart 00:07:00 Format a Chart 00:08:00 Insert a Chart from Microsoft Excel 00:03:00 Preparing to Deliver Your Presentation Prepare Your Presentation - Introduction 00:02:00 Review Your Presentation - Part 1 00:06:00 Review Your Presentation - Part 2 00:06:00 Apply Transitions 00:06:00 Print Your Presentation 00:06:00 Present a Slide Show 00:07:00 Export a Presentation to a PDF File 00:03:00 Bonus Lecture 00:01:00 What's New In PowerPoint 2019/365? Highlight Text 00:03:00 How to Adjust the Link Color 00:02:00 Draw and Write Digitally 00:04:00 Animate Freehand Drawings 00:04:00 Create Professional Slide Layouts With PowerPoint Designer 00:04:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Duration 3 Days 18 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients. This course is also designed for professionals who want to pursue the Microsoft Power BI Data Analyst (Exam PL-300) certification. Overview In this course, you will analyze data with Microsoft Power BI. You will: Analyze data with self-service BI. Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Enhance data analysis by adding and customizing visual elements. Model data with calculations. Create interactive visualizations. Use advanced analysis techniques. Enhance reports and dashboards. Publish and share reports and dashboards. Extend Power BI beyond the desktop. As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of 'big data' is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft© Power BI© software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Analyzing Data with Self-Service BI Topic A: Data Analysis and Visualization for Business Intelligence Topic B: Self-Service BI with Microsoft Power BI Connecting to Data Sources Topic A: Create Data Connections Topic B: Configure and Manage Data Relationships Topic C: Save Files in Power BI Performing Data Cleaning, Profiling, and Shaping Topic A: Clean, Transform, and Load Data with the Query Editor Topic B: Profile Data with the Query Editor Topic C: Shape Data with the Query Editor Topic D: Combine and Manage Data Rows Visualizing Data with Power BI Topic A: Create Visualizations in Power BI Topic B: Chart Data in Power BI Enhancing Data Analysis Topic A: Customize Visuals and Pages Topic B: Incorporate Tooltips Modeling Data with Calculations Topic A: Create Calculations with Data Analysis Expressions (DAX) Topic B: Create Calculated Measures and Conditional Columns Creating Interactive Visualizations Topic A: Create and Manage Data Hierarchies Topic B: Filter and Slice Reports Topic C: Create Dashboards Using Advanced Analysis Techniques Topic A: Create Calculated Tables, Variables, and Parameters Topic B: Enhance Visuals with Statistical Analysis Topic C: Perform Advanced Analysis Enhancing Reports and Dashboards Topic A: Enhance Reports Topic B: Enhance Dashboards Publishing and Sharing Reports and Dashboards Topic A: Publish Reports Topic B: Create and Manage Workspaces Topic C: Share Reports and Dashboards Extending Power BI Beyond the Desktop Topic A: Use Power BI Mobile Topic B: Extend Access with the Power BI API Additional course details: Nexus Humans Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Unlock the power of data with our comprehensive course on Business and Data Analysis with SQL. Learn essential SQL skills to extract meaningful insights, make data-driven decisions, and drive business success. Whether you're a beginner or looking to enhance your expertise, our course empowers you with the tools and knowledge needed to excel in the dynamic world of data analysis. Enroll now to master SQL for business intelligence and elevate your analytical skills to new heights.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Legal Secretary and Office Skills Diploma Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Legal Secretary and Office Skills Diploma Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Legal Secretary and Office Skills Diploma Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Legal Secretary and Office Skills Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Legal Secretary and Office Skills Diploma? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Legal Secretary and Office Skills Diploma there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Legal Secretary and Office Skills Diploma course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Legal Secretary and Office Skills Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Legal Secretary and Office Skills Diploma was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Legal Secretary and Office Skills Diploma is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Legal Secretary Module 01: Introduction to Legal Secretary 00:25:00 Module 02: English Law & Legal Systems 00:35:00 Module 03: The Legal Workplace & Professionals 00:47:00 Module 04: Law of Contract & Law of Tort 00:31:00 Module 05: Wills, Probate and Estate Law Practice 00:17:00 Module 06: Property Law & Conveyancing Practice 00:21:00 Module 07: Family Law and Insurance Practice 00:26:00 Module 08: Professional Writings and Documents 00:30:00 Module 09: Document Proofreading and Editing 00:07:00 Module 10: Meeting Management & Minute Taking 01:09:00 Module 11: Customer Service and Telephone Handling Skills 00:23:00 Module 12: Data Management and Record-Keeping 00:16:00 Module 14: Other Essential Skills for Secretarial Role 00:22:00 Module 15: Professional Conduct and Ethics 00:24:00 Microsoft Word Essentials New Word Document and Templates 00:02:00 Tabs, Ribbons and Groups 00:03:00 Zoom and Rulers in Word 00:02:00 Editing the Word Document 00:03:00 Insert Pictures with Word 00:05:00 Insert Shape and Text Box in Word 00:02:00 Review Tab in Word 00:03:00 Layout in Word 00:02:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft PowerPoint Essentials New PowerPoint Presentation and Templates 00:02:00 Tabs Ribbons and Groups in PowerPoint 00:03:00 First Slide and Designing the Slide 00:02:00 Home Tab and Updates in PowerPoint 00:02:00 Buttons in PowerPoint 00:01:00 Inserting Pictures in PowerPoint 00:04:00 Presentation Mode 00:01:00 Animations Tab 00:05:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft Outlook Essentials Setting Up Outlook with Accounts 00:03:00 Tabs, Ribbons and Groups in Outlook 00:03:00 Navigation Bar in Outlook 00:01:00 Organizing Outlook with Favorites and Folders 00:03:00 Additional Options inside Outlook Tabs 00:01:00 Reading, Writing and Receiving Emails 00:08:00 Attaching Items in Outlook Mails 00:03:00 The View Tab in Outlook 00:02:00 Create a Rule to move emails to a folder 00:04:00 Insert a screen shot from Excel 00:02:00 Microsoft Excel - Top 50 Keyboard Shortcuts Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Assignment Assignment - Legal Secretary and Office Skills Diploma 01:00:00

Description: A professional receptionist is someone who is assigned as one of the front liners in the business. As a receptionist, it is your task to be knowledgeable on the operations and the overall state of the business. Since you are assigned to communicate first with the clients, it is important for you to have the skills in office management. This course is comprised of training in (1) organizational skills; (2) office management techniques; and (3) advanced Microsoft Office skills. These three pieces of training will help you become a professional receptionist and help in the success of your organization. Who is the course for? Current executive and personal assistants who want to improve their administrative skills. People who have an interest in becoming an executive or personal assistant. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in 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 Professional Receptionist Diploma course is a useful qualification to possess, and would be beneficial for the following careers: Assistant Manager Entrepreneur Assistant Executive Assistant Legal Secretary Personal Assistant Receptionist Secretary. Receptionist Receptionist 00:30:00 Importance of Receptionist 00:15:00 Different Types of Receptionist & Roles 01:00:00 Communication Skills for Receptionist 01:00:00 Telephone Skills 01:00:00 Listening Skills 01:00:00 Taking Messages 00:30:00 Presenting & Appearance 00:30:00 Reservation Procedure 00:15:00 Confidentiality Checklist 00:15:00 Being Organized as Receptionist 00:15:00 Becoming a Successful Receptionist 00:15:00 Being an 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 Answering Telephones Module One - Getting Started 00:30:00 Module Two - Core Skills Required 01:00:00 Module Three - Self-Management (I) 01:00:00 Module Four - Self-Management (II) 01:00:00 Module Five - Time Management (I) 01:00:00 Module Six - Time Management (II) 01:00:00 Module Seven - Organizing and Planning (I) 01:00:00 Module Eight - Organizing and Planning (II) 01:00:00 Module Nine - Communication (I) 01:00:00 Module Ten - Communication (II) 01:00:00 Module Eleven - Additional Challenges 01:00:00 Module Twelve - Wrapping Up 00:30:00 Professional Telephone Receptionist Course - Activities 00:00:00 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 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 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 Mock Exam Mock Exam- Professional Receptionist Diploma 00:30:00 Final Exam Final Exam- Professional Receptionist Diploma 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector.

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 Getting Data Ready for Regression Model Transportation Problem in Excel using Goal Seek 00:12:00 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 Creating 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 What-if analysis Excel: Running Linear Regression using Solver 00:08:00 Assessment Assessment - Linear Regression Analysis In MS 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

Good leadership and management are essential for creating a productive work team. This Leadership and Management course will teach you all the skills and knowledge you need to develop your leadership style and abilities. Whether you're a line manager, coach, or entrepreneur, you will learn valuable strategies and techniques that will help you to create an unbeatable workforce, manage conflict, motivate teams, and ensure that each member is working to their full potential.  This course includes case studies and practical exercises that can be applied to a wide range of professions, covering different leadership models and theories. It covers a number of topics in relation to management, from talent acquisition to providing feedback. You'll also develop your proficiency in key Microsoft Office packages. By the end of this course, you'll not only be equipped with the skills to take your management to the next level, but will also have an excellent understanding of corporate responsibility and ethics, which will every senior member of staff must know. Learning Outcomes: Understand the fundamental differences between leadership and management Familiarise with different leadership theories and leadership models Learn techniques for motivating employees and providing constructive feedback Deepen your understanding of the talent management process Know how to deal with office politics effectively and manage workplace conflict Build your proficiency in Microsoft Office's leading packages Develop your understanding of corporate responsibility and ethics Gain valuable team-building skills to create an unbeatable workforce 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 from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. 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 To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this Course for? This course is ideal for anyone in a management or leadership role who wants to develop their skill set and leadership style to manage teams more effectively. There are no specific entry requirements for this course, which can be studied on a part-time or full-time basis. Career Path On successful completion, learners will have a range of skills required to lead teams and individuals effectively, which apply to any management role. These skills are ideal for anyone pursuing any of the following professions: Business Owner Entrepreneur Line Manager Head of Department Project Manager Teacher Tutor Coach Mentor Course Content Leadership & Management Module 1: Understanding Management and Leadership 00:40:00 Module 2: Leadership Theories 00:25:00 Module 3: Improving Management and Leadership Performance 00:15:00 Module 4: High Performance Teams 00:32:00 Module 5: Motivating Employees 00:26:00 Module 6: Organisational Skills 00:26:00 Module 7: Talent Management 00:37:00 Module 8: Succession Planning 00:24:00 Module 9: Business Process Management 00:29:00 Module 10: Communication Skills 00:28:00 Module 11: Negotiation Techniques 00:15:00 Module 12: Managing Meetings and Giving Feedback 00:22:00 Module 13: Managing Change 00:22:00 Module 14: Time Management 00:37:00 Module 15: Stress Management 00:15:00 Module 16: Emotional Intelligence in Leadership 00:32:00 Module 17: Managing Conflict 00:14:00 Module 18: Dealing with Office Politics 00:34:00 Module 19: Risk Management 00:35:00 Module 20: Corporate Responsibility and Ethics 00:14:00 Module 21:Microsoft Word, Excel, PowerPoint Microsoft Word 08:06:00 Microsoft Excel 03:59:00 Microsoft PowerPoint 08:24:00 Mock Exam Mock Exam- Leadership & Management 00:20:00 Final Exam Final Exam- Leadership & Management 00:20:00 Recommended Materials Workbook - Leadership & Management Unlimited Assignment Assignment - Leadership & Management Unlimited 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.