553 Courses in Liverpool delivered On Demand

Functional Skills English Level 2 | Functional Skills Maths Level 2 | Functional Skills IT Level 2 with PDF Certificates Are you tired of feeling held back by those frustrating math equations or the words that seem to elude you in English? Our comprehensive Functional Skills bundle can help you as it comprises three individual courses - Functional Skills Maths, Functional Skills English, and Functional Skills IT. Each one is tailored to empower you with vital Functional Skills that are essential for the modern workplace. This course bundle provides a solid foundation of Functional Skills in English, Maths, and IT, essential for both personal development and professional success. The English course focuses on improving Reading, Writing, Speaking, and Listening skills, while the Maths course offers Practical Applications and Problem-solving Techniques. IT training covers essential Digital Skills, and the Fitness course introduces Health and Well-being into the mix. Additional courses on English Grammar and Math Tricks offer unique strategies to further enhance your proficiency and confidence in these core areas. Additionally, we are offering 2 more courses related to Functional Skills absolutely FREE. Courses Included In this Functional Skills Package Are: Course 01: Functional Skills English Level 2 Course 02: Functional Skills Maths Level 2 Course 03: Functional Skills IT Level 2 Course 04: Functional Skills Fitness Level 2 Course 05: English Spelling, Punctuation, and Grammar Training Course 06: Math Tricks & Tips- Best Techniques to Speed up Your Math Learning Outcomes of the Functional Skills Bundle: Develop strong written and verbal communication skills in English. Demonstrate proficiency in asking and answering questions. Improve spelling accuracy and employ correct spelling strategies. Acquire essential mathematical skills. Apply mathematical rules and formulas to solve real-life problems. Demonstrate proficiency in using computer hardware and software. Understand and mitigate IT security threats while troubleshooting computer issues. Why Choose Us? Opportunity to get a Free CPD Accredited / QLS Endorsed Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Curriculum Breakdown Course 01: Functional Skills English Level 2 Module 01: Introduction to the Course Module 02: Basics of Grammar Module 03: The Basics of Sentence Module 04: Structure of Sentence Module 05: Questions Module 06: Punctuation and Capitalisation Module 07: Spelling Module 08: Common Mistakes and Ways to Improve Course 02: Functional Skills Maths Level 2 Module 01: Numbers and Negative Numbers Module 02: Multiple Factors Module 03: Fractions and Power Module 04: Percentages Module 05: Expressions Module 06: Decimals Module 07: Ratio and Proportion Module 08: Exponents and Radicals Module 09: Graphs Module 10: The Profit and Loss Module 11: Perimeter and Area Module 12: Averages Module 13: Probability Course 03: Functional Skills IT Level 2 Section 01: How People Use Computers Section 02: System Hardware Section 03: Device Ports And Peripherals Section 04: Data Storage And Sharing Section 05: Understanding Operating Systems Section 06: Setting Up And Configuring A PC Section 07: Setting Up And Configuring A Mobile Device Section 08: Managing Files Section 09: Using And Managing Application Software Section 10: Configuring Network And Internet Connectivity Section 11: IT Security Threat Mitigation Section 12: Computer Maintenance And Management Section 13: IT Troubleshooting Section 14: Understanding Databases Section 15: Developing And Implementing Software Course 04: Functional Skills Fitness Level 2 Module 01: Introduction To Functional Fitness Training Module 02: What Is Functional Fitness Module 03: Benefits Of Functional Fitness Module 04: Functional Fitness & Other Exercises Module 05: Common Mistakes With Functional Fitness Module 06: Functional Fitness & Power Module 07: Functional Fitness & Strength Module 08: Functional Fitness & Range Of Motion Module 09: Functional Fitness & Balance & Endurance Assessment Process After completing this online course, you will be given immediate access to a specially designed MCQ test. The results will be analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Functional Skills exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 360 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is ideal for: Students seeking mastery in this field Professionals seeking to enhance their skills Anyone who is passionate about this topic Our Course is Knowledge-based not a regulated course. To get Qualified, you may choose the following options: IGCSE Maths A-Level Maths Functional Skills Qualification in Maths at Level 2 Functional Skills Qualification in Mathematics at Level 2 - GCSE Equivalent for Maths A-level Mathematics Functional Skills Qualification in Mathematics at Entry 1 Functional Skills Qualification in Mathematics at Level 1 Functional Skills Qualification in English at Entry 1 Functional Skills Qualification in English at Entry 2 Functional Skills Qualification in English at Level 1 Functional Skills Qualification in ICT at Level 2 Functional Skills Qualification in Information & Communication Technology (ICT) at Level 1 Requirements You will not need any prior background or expertise to enrol in this Bundle. Career path Enrolling on our Bundle can lead you to the following career path: Teacher Teacher Assistant Private Tutor Customer Service Fire service Police Certificates CPDQS Accredited Certificate Digital certificate - £12.99 Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. Certificate in Functional Skills English at QLS Level 2 Hard copy certificate - £79 Show off Your New Skills with a Certification of Completion After successfully completing the Certificate in Functional Skills English at QLS Level 2course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 79 GBP inside the UK 89 GBP (including postal fees) for international delivery CPDQS Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

Introduction Introduction 00:02:00 Geometry Lines and Angles (Basics) 00:07:00 Parallel lines (Basics) 00:06:00 Practice Problems 1 (Lines and Angles) 00:06:00 Triangles (Basics) 00:11:00 Practice Problems 2 (angle sum and exterior angle Property) 00:10:00 Pythagoras Theorem 00:13:00 Inequalities in Triangles 00:06:00 Sine and Cosine Rule 00:12:00 Median, Altitude, Angle bisector 00:06:00 Practice Problems 3 00:11:00 Properties of Medians 00:09:00 Practice Problems 4 00:07:00 Properties of Equilateral Triangles 00:04:00 Some special Quadrilaterals 00:08:00 Polygons-interior angles, diagonals etc. 00:08:00 Angle Bisector Theorem 00:07:00 Congruent Triangles 00:06:00 Similar Triangles 00:14:00 Practice Problems 5 00:10:00 Circle 00:10:00 Cyclic Quadrilateral _ Tangent to circle 00:07:00 Areas Areas of Parallelogram & Triangle 1 00:10:00 Areas of Parallelogram _ Triangle 2 00:10:00 Practice Problems based on Areas 1 00:05:00 Practice Problems based on Areas 2 00:12:00 Mensuration of 2 dimensional figures Mensuration Formulae 00:07:00 Practice problems on 2-d figures 00:11:00 Assignment (Video) on 2 - d figure 00:02:00 Areas related to the circle 00:05:00 Practice questions on areas related to circle 00:10:00 Practice Test (Check your knowledge of Geometry) Practice Test (Geometry) 00:02:00 Concept of Unit Digit Lecture 32 What is Unit Digit? 00:40:00 How to find unit digit of numbers with exponents 00:10:00 Practice Problems based on Unit Digit 00:08:00 Simplification Problems-1 Simplifications based on Percentages 00:11:00 Simplification based on Exponents 00:12:00 Fastest method of finding square roots 00:12:00 Fastest method of finding cube roots 00:03:00 Simplification based on square and cube roots 00:16:00 Lecture 40 Simplification Problems 00:50:00 Crack Simplification problems-2 Lecture 41 Simplification problems Type 1 00:10:00 Simplification problems Type 1 00:08:00 Simplification problems Type 2 00:08:00 Simplification problems Type 3 00:08:00 Simplification problems Type 4 00:07:00 Finding smallest and greatest from difficult exponents 00:08:00 Simplification using Digital sum What is Digital sum 00:05:00 Lecture 44 What is Digital sum? 00:10:00 How to apply Digital sum technique in different operations 00:14:00 Simplification problems using Digital sum -1 00:07:00 Simplification problems using Digital sum -2 00:06:00 Time and Work Lecture 49 Simplification problems using Digital sum -2 00:06:00 Lecture 50 Resources download 1 00:55:00 Problems based on persons, days, work and hours 00:12:00 Short cut formulas for most common problems 00:11:00 Problems based on Two Persons 00:06:00 Problems based on three Persons 00:10:00 Based on Efficiency 00:13:00 Complex problems on Efficiency 00:10:00 Fraction of work 00:07:00 Leaving and Joining - 1 00:06:00 Men, women and boys 00:05:00 Work and wages 00:11:00 Pipes and Cisterns Lecture 62 Resources download 1 00:25:00 Basics of pipes and cisterns 00:06:00 Pipes and cisterns - Type 1 00:07:00 Pipes and cisterns - Type 2 00:04:00 Pipes and cisterns - Type 3 00:07:00 Pipes and cisterns - Type 4 00:06:00 Pipes and cisterns - Type5 00:05:00 Speed , Distance and Time Lecture 69 Speed, Distance and Time Resources download 00:40:00 Basic Concepts and simple problems 00:10:00 Problems based on average speed 00:07:00 Problems of finding Distance 00:13:00 Practice Problems 1 00:10:00 Practice Problems 2 00:08:00 Practice Problems 3 00:07:00 Boats and Streams Lecture 76 Boats and Streams 00:30:00 Basics of Boats and streams 00:10:00 Finding speed of boat or stream 00:13:00 Problems based on finding Distance 00:06:00 Latest Problems on Boat and cisterns 00:11:00 Percentage Percentage Basics 1 00:10:00 Percentage Basics 2 00:04:00 Fractional Values of Percentages 00:09:00 Lecture 84 Simplification using fractional values of Percentages-1 00:06:00 Simplification problems of Percentage 2 00:05:00 Lecture 86 Article for Resources 00:30:00 Word Problems Lecture 87 Problems based on Marks in examination 00:15:00 Problems based on Price and Quantity 1 00:08:00 Problems based on Price and Quantity 2 00:08:00 Lecture 90 Word problems based on Income 00:08:00 Lecture 91 Resources for the section 'Word Problems' 00:35:00

Overview With our intensive Diploma in Business Administration course, you can improve your professional skills. We create complete leaders with strong financial assessment, operational flexibility, and smooth communication by going beyond software expertise.Learn the fundamentals of handling money, creating budgets, writing reports, making presentations, and acting wisely. This investment advances your professional growth by expanding your skill set and opening up possibilities for opportunity.Join us now in exploring your abilities as a leader. Key Features of the Course: FREE Diploma in Business Administration CPD-accredited certificate Get a free student ID card with Diploma in Business Administration training (£10 applicable for international delivery) Lifetime access to the Diploma in Business Administration course materials The Diploma in Business Administration program comes with 24/7 tutor support Get instant access to this Diploma in Business Administration course Learn Diploma in Business Administration training from anywhere in the world The Diploma in Business Administration training is affordable and simple to understand The Diploma in Business Administration training is an entirely online How will I get my certificate? Upon successful completion of the Diploma in Business Administration course, obtaining your certificate is a straightforward process. Here's how it works: Course Completion: Once you've successfully finished the course, you'll be eligible to receive your certificate. Order Your Certificate: You can conveniently order your certificate directly through our platform. Who is this course for? Anyone, anywhere, can jumpstart their business journey with the Diploma in Business Administration! No experience? No problem! This open-door program welcomes all, from any background, to dive into the exciting world of business. Requirements Our Diploma in Business Administration course is designed for maximum flexibility and accessibility: It is optimised for use on PCs, Macs, laptops, tablets, and smartphones. Study easily on your tablet or smartphone, accessible with any Wi-Fi connection. No time limit for completion; study at your own pace and on your own schedule. Basic English proficiency is required to ensure effective learning. This course structure allows for a convenient and adaptable learning experience. Career path Having these various qualifications will increase the value of your CV and open you up to multiple sectors, such as: Marketing Assistant: £20-30k HR Assistant: £22-32k Sales Representative: £25-40k Customer Service Advisor: £20-28k Administrative Assistant: £18-25k Remember: Salary ranges vary (based on experience, location, and company). Advance with further qualifications! Course Curriculum 10 sections • 91 lectures •What is Business Administration? •Business and Organisations •Management of Business •Business Organization Perspectives •Decision Making •Approaches to Leadership •Communication Basics •Know Thyself and The Message •Learn To Use Terms of Business Communication That Invoke Emotions •Pay Attention To Body Language •Learn To Use Terms That Spark Interest •The Benefits Of Presenting Your Message In 1 Minute •Financing Basics •Record Your Income •Make a List of Expenses First and Put Them in Categories •Countdown & Adjust •Review Regularly •Module One - Getting Started •Module Two - Human Resources Today •Module Three - Recruiting and Interviewing •Module Four - Retention and Orientation •Module Five - Following Up With New Employees •Module Six - Workplace Health & Safety •Module Seven - Workplace Bullying, Harassment, and Violence •Module Eight - Workplace Wellness •Module Nine - Providing Feedback to Employees •Module Ten - Disciplining Employees •Module Eleven - Terminating Employees •Module Twelve - Wrapping Up •Activites-Diploma in Human Resource Management •Module One - Getting Started •Module Two - Working with Words •Module Three - Constructing Sentences 2017 •Module Four - Creating Paragraphs •Module Five - Writing Meeting Agendas •Module Six - Writing E-mails •Module Seven - Writing Business Letters •Module Eight - Writing Proposals •Module Nine - Writing Reports •Module Ten - Other Types of Documents •Module Eleven - Proofreading and Finishing •Module Twelve - Wrapping Up •Module One - Getting Started •Module Two - Opening •Module Three - Working with the Interface •Module Four - Your First Document •Module Five - Basic Editing Task •Module Six - Basic Formatting Tasks •Module Seven - Formatting Paragraphs •Module Eight - Advanced Formatting Tasks •Module Nine - Working with Styles •Module Ten - Formatting the Page •Module Eleven - Sharing Your Document •Module Twelve - Wrapping Up •Module One - Getting Started •Module Two - Opening PowerPoint •Module Three - Working with the Interface •Module Four - Your First Presentation •Module Five - Working with Text •Module Six - Formatting Text and Paragraphs •Module Seven - Adding Pictures •Module Eight - Advanced Formatting Tasks •Module Nine - Working with Transitions and Animations •Module Ten - Setting Up Your Slide Show •Module Eleven - Showtime! •Module Twelve - Wrapping Up •Module One - Getting Started •Module Two - Opening Excel •Module Three - Working with the Interface •Module Four - Your First Worksheet •Module Five - Viewing Excel Data •Module Six - Building Formulas •Module Seven - Using Excel Functions •Module Eight - Using Quick Analysis •Module Nine - Formatting Your Data •Module Ten - Using Styles, Themes, and Effects •Module Eleven - Printing and Sharing Your Workbook •Module Twelve - Wrapping Up •Module One - Getting Started •Module Two - Opening and Closing Access •Module Three - An Introduction to Databases •Module Four - Sharing Data Using Apps •Module Five - Working in Your App •Module Six - An Introduction to Desktop Databases •Module Seven - Performing Basic Table Tasks •Module Eight - Working with Fields •Module Nine - Working with Table Relationships •Module Ten - An Introduction to Queries, Forms, and Reports •Module Eleven - Protecting Your Data •Module Twelve - Wrapping Up •Assignment - Diploma in Business Administration

Description:  Microsoft Office products are considered as the gold standard for businesses across the globe. It has been proclaimed by people as the best program especially for working. Learning about the functionality of this program will help you survive the professional world. Through this course, you will learn all the essential skills, knowledge, and information about Microsoft Office 2010. You will learn how to make use of all the programs and features of Microsoft Office. Then you will learn how important Microsoft suites of the program can have an impact on its user. You will gain necessary skills, knowledge and information of Microsoft Word, Excel, Access, PowerPoint and Outlook. Who is the course for? New staff or workers who want to learn about the Microsoft Office Programs People who have an interest in all the features of the Microsoft Office Applications Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a 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 recognised 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 Microsoft Office 2010 Essentials course is a useful qualification to possess and would be beneficial for any type of professions or career from any type of industry you are in, such as: Account Officer Administrative Assistant businessman Executive Assistant Office Administrator Office Manager Personal Assistant Secretary Senior Manager. Microsoft Word Module One - Getting Started 00:30:00 Module Two - Opening and Closing Word 01:00:00 Module Three - Working with Documents 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 - Advanced Formatting Tasks 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Adding the Finishing Touches 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Word 2010 for Beginners 00:00:00 Microsoft Excel Module One - Getting Started 00:30:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2010 for Beginners 00:00:00 Microsoft PowerPoint Module One - Getting Started 01:00:00 Module Two - Opening and Closing PowerPoint 00:30:00 Module Three - Working with Presentations 00:30:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 00:30:00 Module Six - Formatting Text 00:30:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 00:30:00 Module Nine - Customizing Slide Elements 01:00:00 Module Ten - Setting Up Your Slide Show 00:30:00 Module Eleven - Showtime 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities-Microsoft PowerPoint 2010 for Beginners 00:00:00 Microsoft Access Module One - Getting Started 00:30:00 Module Two - Getting Started With Access 01:00:00 Module Three - Using the Access Interface 01:00:00 Module Four - Working with Database Objects 01:00:00 Module Five - Creating Tables 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Creating Forms 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Creating Reports 01:00:00 Module Ten - Creating Queries 02:00:00 Module Eleven - Managing Your Database 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access 2010 for Beginners 00:00:00 Microsoft Outlook Module One - Getting Started 00:30:00 Module Two - Opening and Closing Outlook 01:00:00 Module Three - Working with E-mail 01:00:00 Module Four - Creating a New E-mail 01:00:00 Module Five - Managing E-mail 01:00:00 Module Six - Managing Junk Mail 01:00:00 Module Seven - Outlook's Organization Tools 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contacts 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities-Microsoft Outlook 2010 for Beginners 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! According to recent statistics, the IT sector is one of the fastest-growing industries in the UK, and it shows no signs of slowing down. As technology continues to transform the way we live and work, there is an ever-increasing demand for skilled IT professionals who can keep up with the pace of change. If you're looking to enter this exciting field or advance your existing IT skills, our Essential IT Training course is the perfect starting point. Our comprehensive Essential IT Training course covers everything from the basics of information technology (IT) to more advanced topics such as project management and database storage. You'll learn how to use word processing, presentation, and spreadsheet software, and gain valuable insights into communication and network technologies. In addition, you'll develop future skills that are essential for success in the fast-paced world of IT. By the end of this Essential IT Training, you'll have a solid foundation in IT and be able to navigate the latest software with ease. You'll also have the skills to manage IT projects, work with databases, and communicate effectively in a technology-driven environment. Whether you're just starting out or looking to advance your career, our Essential IT Training course will provide you with the skills you need to succeed. After this Essential IT Training, you will be able to learn: Understand the importance of IT in today's world. Develop essential skills in word processing, presentation, and spreadsheet software. Learn how to store and manage data effectively using databases. Develop communication and network skills essential for working in the IT industry. Learn about project management in an IT context. Gain future skills that are essential for success in the fast-paced world of IT. Why Prefer this Course? Opportunity to earn a certificate accredited by CPD after completing this IT Training Course Student ID card with amazing discounts - completely for FREE! (£10 postal charge will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Each of our students gets full 24/7 tutor support *** Course Curriculum *** Module 01: Introduction: A Transforming Technology Toward A Brave New World Attitudes And Phobias Technology As Progress Critical Approaches To Technology What Is Information? What Is Information Technology? Characteristics Of Information Technology Module 02: Importance Of Information Technology The Use Of Information Technology Business Information Technology Use In Organisations Benefits Of The Use Of Information Technology In Business Information Technology Use In Education Information Technology In Health Module 03: Communication And Network Types Of Communication Communication Systems Communication Channels Wireless Connections Connection Devices Data Transmission Mobile Internet Networks Network Types Module 04: Future Skills Required In Information Technology Future Trends Drivers Impact On Employment And Skills Short /Immediate Issues And The Impact On Skills Medium Term Issues And The Impact On Skills Long Term Issues And The Impact On Skills Module 05: Technology As A Foundation Skill Area The Development And Impact Of Technology Culture Schooling A New Learning Environment Using Information Technology An Integrated Approach Information Technology Literacy Outcomes Enhancing Classrooms With Information Technology Module 06: Word Processing Software History Of Word Processing Standard Features Of Word Processors Full-Featured Word Processors Introduction To Microsoft Office Scrolling A Document Moving The Insertion Pointer Moving In Small Increments (Basic Arrow Keys) Getting Lost And Going Back Editing Text Deleting Stuff Splitting And Joining Mistakes? Mistakes? Undo Them With Haste Module 07: Presentation Software Starting And Exiting PowerPoint Understanding The Screen Elements Working With The Ribbon Working With Collapsible Tab Groups Working With Backstage View Changing The View Normal View Notes Page View Zooming In And Out Enabling Optional Display Elements Gridlines Opening A New Display Window Using The Help System Using PowerPoint Support Resources Understanding Product Activation Adjusting Privacy Settings Module 08: Creating And Editing Spreadsheet (Part 1: The Basics Of Spreadsheets) Typing Data Into A Single Cell Typing Data In Multiple Cells Typing In Sequences With Autofill Formatting Numbers And Labels Formatting Numbers Displaying Negative Numbers Formatting Decimal Numbers Formatting Cells Formatting Fonts And Text Styles Formatting With Colour Adding Borders Module 09: Creating And Editing Spreadsheet (Part 2: Navigation And Edit) Navigating A Spreadsheet Using The Keyboard To Move Around A Spreadsheet Naming Cells Searching A Spreadsheet Searching For Formulas Editing A Spreadsheet Changing The Size Of Rows And Columns With The Mouse Typing The Size Of Rows And Columns Adding And Deleting Rows And Columns Adding Sheets Renaming Sheets Rearranging Sheets Clearing Data Printing Workbooks Adding A Header Or Footer Printing Gridlines Defining A Print Area Inserting And Removing Page Breaks Printing Row And Column Headings Defining Printing Margins Defining Paper Orientation And Size Printing In Excel Module 10: Storing Database Database Basics Designing A Database Editing And Modifying A Database Adding And Deleting A Field Defining The Type And Size Of A Field Typing Data Into A Database Using Datasheet View Using Form View Creating A Form Editing A Form Adding A Field Closing And Saving A Database Exiting Access Module 11: Information Technology Project Management Introduction To Project Management What Is Project? What Is Project Management? Project Stakeholders Project Management Tools And Techniques Project Scope Management Project Time Management Project Cost Management Assessment Process Once you have completed all the course modules, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Essential IT Training is ideal for: Students who are interested in pursuing a career in IT. Professionals who want to upskill and stay up-to-date with the latest IT technologies and trends. Anyone who wants to learn how to use common software tools used in the workplace. Career path After completing this Essential IT Training, you are to start your career or begin the next phase of your career in following fields: IT Support Specialist: £25,000 - £35,000 Database Administrator: £35,000 - £50,000 Network Administrator: £30,000 - £45,000 IT Project Manager: £45,000 - £60,000 Software Developer: £30,000 - £60,000 Business Analyst: £30,000 - £50,000 Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Discover the art and science of Talent Management, a strategic approach to attract, develop, and retain top-performing employees. Dive into core concepts, employee needs, and effective talent management planning. Explore talent acquisition, employee development, performance evaluation, and innovative retention strategies to foster organizational success. Learning Outcomes: Gain an understanding of Talent Management's significance in fostering a skilled and engaged workforce. Explore the core concepts and principles of effective Talent Management strategies. Identify key reasons behind employee turnover and ways to address them. Develop insights into employee needs and mindset to enhance talent retention and growth. Master the creation of comprehensive Talent Management plans tailored to organizational goals. Acquire strategies for talent acquisition, including sourcing, screening, and hiring. Learn techniques to identify and nurture high-potential employees for leadership and growth. Implement performance evaluation, feedback mechanisms, and employee retention formulas. Why buy this Talent Management? 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 Talent Management 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Talent Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.  HR Professionals and Talent Managers Seeking Comprehensive Skill Enhancement. Managers and Leaders Involved in Employee Development and Talent Acquisition. Entrepreneurs and Business Owners Looking to Optimize Their Workforce Strategy. Individuals Interested in HR and Talent Management as a Career Path. Prerequisites This Talent Management 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 Talent Manager - $60,000 to $100,000/year. Human Resources Manager - $60,000 to $110,000/year. Organizational Development Specialist - $50,000 to $90,000/year. Training and Development Manager - $60,000 to $100,000/year. HR Consultant - $50,000 to $80,000/year. Course Curriculum Section 1: Introduction Unit 1: Welcome to the Course 00:05:00 Unit 2: Highlights of this Course 00:02:00 Unit 3: Little Activity Before We Begin 00:01:00 Section 2: Core Concepts of Talent Management Unit 1: What is Talent Management 00:03:00 Unit 2: Responsibilities of Talent Management Manager & Professionals 00:02:00 Unit 3: Talent Management - The Pillar of Successful Business 00:03:00 Unit 4: Benefits of Talent Management: How Your Business Can Benefit From it 00:02:00 Section 3: Top Reasons Why Employees Leave an Organisation Unit 1: Top 5 Reasons Why Employees Leave an Organisation 00:04:00 Unit 2: Reasons of Employee Resignation 00:03:00 Section 4: Understanding the Needs and Mindset of Employee Unit 1: The Most Useful Technique to Understand Employee's Needs 00:04:00 Unit 2: Practical, Real Life Example of Retaining Top Employees & Keeping Them Engaged 00:06:00 Section 5: Steps to Create an Effective Talent Management Plan Unit 1: Steps in Talent Management Process 00:02:00 Section 6: Talent Acquisition Unit 1: What is Talent Acquisition and How it is Different from Recruitment 00:02:00 Unit 2: Steps for Talent Acquisition 00:05:00 Unit 3: Top Selection Tests to Check Candidate's Potential 00:04:00 Unit 4: Manpower Estimation Template 00:01:00 Section 7: How to Develop High Potential Employees Unit 1: Creating a High Performance Workforce 00:05:00 Unit 2: Understanding the Difference Between Training & Development 00:02:00 Unit 3: Why Talent Development Process is Important for Employees 00:02:00 Unit 4: How Talent Development Helps in Running the Business Smoothly 00:03:00 Unit 5: Steps in Developing the Talent 00:02:00 Section 8: Evaluating Performance Unit 1: Performance Management 00:02:00 Unit 2: Performance Appraisal 00:01:00 Unit 3: Tools for Performance Appraisal 00:06:00 Section 9: "SMR" - How You Can Retain the Employees Using This Formula Unit 1: 'SMR' - How You Can Retain the Employees Using This Formula 00:04:00 Section 10: How to Retain High Potential Employees Unit 1: Employee Retention Programs 00:02:00 Unit 2: Onboarding Correctly 00:06:00 Unit 3: Career Planning & Development 00:04:00 Unit 4: Job Promotions 00:05:00 Unit 5: Using Motivators (Financial & Non- Financial Incentives) 00:05:00 Unit 6: Maintaining Work-Life Balance 00:02:00 Section 11: Bonus Section: Achieving Business Goals with Talent Management Strategy Unit 1: Return on Investment (ROI) on Talent Management 00:03:00 Unit 2: Achieving Business Goals with The Help of Talented Workforce 00:04:00 Unit 3: Little Activity Before We Began - Here's What You Learnt 00:02:00 Section 12: Conclusion Unit 1: Conclusion 00:01:00 Assignment Assignment - Talent Management 00:00:00

This course will help you master the essential math skills required to excel in the exam and in your real estate career. You will gain a deep understanding of key mathematical concepts, such as property valuation, mortgage calculations, commission calculations, and more. This Course At A Glance Accredited by CPD UK Endorsed by Quality Licence Scheme Learn the mathematical fundamentals of real estate Recognise the tools for investment analysis Get a better understanding of fractions, percentages and decimals Understand list price, sale price, and net price Learn about appreciation and depreciation Understand the mathematics of real estate finance Get to learn about compensation by solving the practice problem set Develop an understanding of the property transfer taxes Learn about the procrastination-related myths Be able to understand legal descriptions. Real Estate License Exam - Math Course Overview This comprehensive Real Estate License Exam - Math Course Online will help you understand the necessary concepts of mathematics required to qualify for the real estate license exam. You will also get to acquire an understanding of the basic and advanced real estate math concepts to develop the knowledge required in the real estate domain. This popular real estate license exam - math course is specially designed for the students preparing themselves for the real estate licensing exam. During this course, you will learn about fractions, decimals, percentages, list price, sale price, net price, appreciation, depreciation, taxes and much more. By the end of the course, you will develop an understanding of the mathematical concepts and formulas required to appear and successfully qualify for the real estate license exam. This course will also develop the mathematical skills necessary to become a confident real estate agent. Who should take this course? This online Real Estate License Exam - Math Course Online is perfect for those who want to understand to gain an understanding of the mathematical concepts involved in real estate and aspire to prepare for the real estate licensing exam. Those who are willing to kickstart their career as successful real estate agents should opt for this extensive online course. Entry Requirements There are no academic entry requirements for this real estate license exam - math course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Real Estate License Exam - Math Course Online 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 can grasp from each section. In the assessment pass mark is 60%. Course Curriculum Chapter 1 Real Estate Math Fundamentals Fractions,Decimals,and Percentages Percentage Problems Percent Practice Problem Set 2 Percent of Change Chapter 1 Review Chapter 1 Test Chapter 2 List Price, Sale Price, and Net Price List Price Versus Sale Price Chapter 2 Review Chapter 2 Test Chapter 3 Appreciation and Depreciation Appreciation Versus Depreciation Chapter 3 Review Chapter 4 Compensation Compensation Practice Problem Set Chapter 4 Review Chapter 4 Test Chapter 5 Ad Valorem Taxes Assessed Value Practice Problem Set Chapter 5 Review Chapter 5 Test Chapter 6 Property Transfer Taxes Property Transfer Taxes Practice Problem Set Chapter 6 Review Chapter 6 Test Chapter 7 Legal Descriptions Linear (Perimeter) Practice Problem Set Legal Description Practice Problem Set Chapter 7 Review Chapter 7 Test Chapter 8 Area and volume Area Practice problem set Volume Practice Problem Set Chapter 8 Review Chapter 8 Test Chapter 9 Interest Simple Interest Compound Interest Chapter 9 Review Chapter 9 Test Chapter 10 The Mathematics of Real Estate Finance Qualifying for a Loan Practice Problem Set Amortization Practice Problem Set Chapter 10 Notes Chapter 10 Practice Problem Set Chapter 10 Review Chapter 10 Test Chapter 11 Appraisal Methods Chapter 11 Practice Problem Set Chapter 11 Review Chapter 11 Test Chapter 12 Tools of Investment Analysis Chapter 12 Practice Problem Set Chapter 12 Review Chapter 12 Test Chapter 13 Prorations Prorating Taxes Prorating Insurance Prorating Interest Prorating Maintenance Fees Chapter 13 Review Chapter 13 Test Chapter 14 Lease Calculations Rent Per Square Foot Percentage Lease Index (Variable) Lease Calculation Chapter 14 Review Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed 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. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

If spreadsheets give you a headache, this course aims to offer aspirin—metaphorically, of course. The Microsoft Excel Mini Bundle brings clarity to cells, formulas, and functions while adding the human touch of communication and the logic of mathematics. Whether you’re new to data handling or trying to stop formatting rage-quits, this bundle helps you organise, calculate, and interpret with greater ease. From raw entry to meaningful analysis, you’ll gain the structured insight needed to keep rows aligned and heads cool. Learning Outcomes: Learn to use Microsoft Excel for tables, formulas and formatting. Understand data entry principles for structured and clean records. Apply mathematical reasoning to spreadsheets and data calculations. Explore data analysis basics using Excel tools and techniques. Improve communication around data sharing and reporting tasks. Recognise how Excel supports reporting, tracking, and scheduling duties. Who is this Course For: Admins needing Excel structure and clean spreadsheet management. Beginners seeking basic Excel, maths, and data entry knowledge. Office workers handling daily tasks involving spreadsheets. Team members preparing visual reports or internal data logs. Freelancers managing schedules, budgets, and lists via Excel. Analysts looking for a refresher in data visualisation tools. Project coordinators involved in record keeping and communication. Learners improving technical communication in business settings. Career Path: Data Entry Clerk – £22,000/year Junior Data Analyst – £26,000/year Excel Support Administrator – £24,000/year Reporting Assistant – £25,500/year Office Administrator (Excel Focus) – £23,500/year Communication and Data Coordinator – £27,000/year

Copywriting Course Level 4 Overview Do you dream of crafting words that captivate audiences, drive action, and boost sales? The Copywriting Course Level 4 equips you with the skills to become a powerful copywriting force. Imagine turning website visitors into paying customers, crafting social media posts that go viral, and developing persuasive marketing messages that resonate with your target audience. This comprehensive program dives deep into the core principles of copywriting, empowers you to apply effective marketing tactics, and guides you through the proven processes used by successful copywriters. By the end, you'll be equipped to write compelling copy across diverse platforms and unlock a rewarding career in the exciting world of copywriting. Learning Outcomes: Understand the core concepts of copywriting and how to apply them effectively in various contexts. Learn advanced marketing tactics to write copy that sells and resonates with target audiences. Explore the copywriting process, including practical tips and strategies to streamline your workflow. Master the art of crafting irresistible headlines that grab readers' attention and compel them to take action. Enhance your copywriting skills through hands-on practice exercises and real-world examples. Why You Should Choose Copywriting Course Level 4 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? Copywriting Course Level 4 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 Copywriting Course Level 4 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. Copywriting Course Level 4 Section 1: Introduction Unit 1: Welcome to the Copywriting Course 00:05:00 Unit 2: Course Overview 00:04:00 Section 2: Introduction to Copywriting Unit 1: What is Copywriting 00:05:00 Unit 2: Elements of Great Copy 00:11:00 Unit 3: Traditional vs Modern Copywriting 00:04:00 Unit 4: Career Options for Copywriters 00:12:00 Unit 5: Job Description and Responsibilities of a Copywriter 00:06:00 Unit 6: Copywriting vs Content Writing: The Difference 00:04:00 Section 3: Core Concepts of Copywriting Unit 1: What is a Short Form Copy 00:03:00 Unit 2: What is a Long Form Copy 00:02:00 Unit 3: Types of Tones Used for Writing Copy 00:06:00 Unit 4: Which Types of Tone You Should Use 00:07:00 Unit 5: Identifying the Target Audience 00:06:00 Unit 6: Qualities That Will Make You a Successful Copywriter 00:06:00 Section 4: Marketing Tactics to Write Copy That Sells Unit 1: The Secret to Understand Buyer's Mindset 00:04:00 Unit 2: Never Make Your Copy Look Like an Ad 00:06:00 Unit 3: 2 Second Hack to Become a Successful Copywriter 00:05:00 Unit 4: Features vs Benefits 00:04:00 Unit 5: The Shocking Truth about Buyers & Customers 00:04:00 Unit 6: So What Test 00:05:00 Unit 7: FOMO: How to Use This Most Powerful Marketing Tool 00:08:00 Unit 8: What's in It for Me 00:04:00 Unit 9: The Secret to Sell Instantly 00:05:00 Unit 10: Leveraging the Power of Emotions 00:04:00 Section 5: The Copywriting Process: 9 Steps to Make It Easier For You Unit 1: Steps in the Copywriting Process 00:08:00 Unit 2: Understand the Product 00:06:00 Unit 3: Performing Competitor Analysis 00:12:00 Unit 4: Create a Buyer Persona / Customer Avatar 00:06:00 Unit 5: Writing the copy 00:01:00 Unit 6: Editing the Copy 00:02:00 Unit 7: Adding Design Elements + Media 00:07:00 Unit 8: Publish the Copy + Promotion 00:02:00 Unit 9: Checking the Conversion from Copy - Measuring Results 00:03:00 Section 6: Copywriting Formulas Unit 1: AIDA: The 4 Step Formula 00:05:00 Unit 2: Storytelling: Best Tool for Converting Readers into Buyers 00:05:00 Unit 3: 3 STEP Formula: PAS 00:06:00 Section 7: Headlines Unit 1: Section Introduction 00:01:00 Unit 2: Intro to Headlines 00:07:00 Unit 3: Importance of Headlines 00:03:00 Unit 4: Formula to Write Amazing Headlines (Everytime) 00:09:00 Unit 5: How to Use This Formula (With Examples) 00:02:00 Unit 6: Free Tool to Create Attractive Headlines 00:03:00 Unit 7: Practice Exercise 00:01:00 Section 8: 6 Hacks to Write Headlines That Readers Cannot Resist Unit 1: Section Intro 00:02:00 Unit 2: Headline Hack # 1 00:01:00 Unit 3: Headline Hack # 2 00:02:00 Unit 4: Headline Hack # 3 00:02:00 Unit 5: Headline Hack # 4 00:04:00 Unit 6: Headline Hack # 5 00:02:00 Unit 7: Headline Hack # 6 00:03:00 Unit 8: Quick Recap 00:01:00 Section 9: Creating the Copy Unit 1: Creating Call to Actions (CTA) That Reader's Cannot Resist 00:04:00 Unit 2: Focus on the Customer 00:06:00 Unit 3: How to Write a Conversational Copy 00:03:00 Section 10: Hacks & Tips Unit 1: Collect Winning Pieces 00:04:00 Unit 2: 3 Extremely Powerful Words That You Must Use in a Copy 00:02:00 Unit 3: Using Customer's Words 00:05:00 Section 11: Practice Exercises Unit 1: Recreate Ads 00:01:00 Unit 2: Record Your Copy 00:02:00 Section 12: Conclusion Unit 1: Conclusion 00:01:00

Course Overview Microsoft Excel has brought a revolutionary change in the field of data management. It is one of the key skills that every employer looks for in a potential employee. The 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is designed to equip you with adequate expertise in Excel. This course is a golden opportunity to add a highly beneficial skill to your resume and impress your employers. In this 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course, you will receive a wide range of valuable tips to elevate your MS Excel skills. The course will show you the process of adding a link in the formula bar and adding multiple columns and rows within a blink. You will become skilled in quick calculations in the status bar. From the informative modules, you will identify the shortcut keys and learn to navigate between worksheets. The lessons will introduce you to the method of ZIP code format. You will understand how to move cell directions and convert numbers to text.  This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is packed with valuable information about MS Excel. So enroll in the course and become a proficient MS Excel user. Learning Outcomes Learn how to navigate between worksheets using shortcut keys Understand the process of creating a custom autofill list and importing data from webpages Build the skills to hide workbook elements Enrich your understanding of advanced transpose Grasp the techniques of moving cell directions and deleting data Know how to convert text to numbers Who is this course for? This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is for those who want to improve their Excel skills. 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. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path  The 50 MS Excel Tips to Upgrade your Excel Skill to next Level course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Administrative Assistant Data Analyst Accountants Financial Analyst Retail Store Manager Project Manager Business Analyst Unit 01: Introduction Welcome 00:02:00 Unit 02: Excel Productivity Tips -Part 1 Camera Tool 00:05:00 Add Line Break in Formula Bar 00:03:00 Advanced Copy-Paste using Office Clipboard 00:03:00 Navigation between Worksheets using Shortcut Keys 00:01:00 Flash Fill 00:02:00 Add Multiple Rows and Columns Quickly 00:02:00 Delete Blank Rows 00:03:00 Multi Level Row and Column Sorting 00:04:00 Add Sparklines 00:03:00 Paste Special - Transpose 00:03:00 Unit 03: Excel Productivity Tips - Part 2 Snap to Grid 00:03:00 Create Custom Auto fill List 00:06:00 Absolute Cell Reference 00:03:00 Import Data from Web page 00:04:00 Move Cell Direction 00:03:00 Delete Data using Mouse 00:02:00 Status Bar Quick Calculations 00:03:00 Link Text Boxes to Cell 00:04:00 Phone Number and ZIP Code Format 00:04:00 Speaking Cell 00:05:00 Unit 04: Excel Productivity Tips - Part 3 Invisible Text 00:03:00 Worksheet Grouping 00:04:00 Advanced Transpose 00:04:00 XLStart Folder 00:03:00 Use Slicers 00:05:00 Convert Text to Numbers 00:03:00 Hiding Workbook Elements 00:02:00 Useful Shortcut Keys 00:03:00 Sort data from Left to Right 00:03:00 Advanced Filter (Complex) 00:11:00 Unit 05: Excel Productivity Tips - Part 4 Email as PDF 00:02:00 Synchronous Scrolling 00:03:00 Quick Analysis of data within Excel 00:02:00 Fill blank cells with Value 00:03:00 Hidden Chart Source Data 00:03:00 Two more Shortcuts 00:03:00 Add Blank Rows 00:03:00 Custom views in Excel 00:06:00 EMBED Feature 00:04:00 Adding Country code in Mobile Numbers 00:04:00 Unit 05: Excel Productivity Tips - Part 5 Plot an Average Line to a Chart 00:04:00 3D Referencing 00:04:00 Extract Unique Values 00:03:00 Excel Array Formula 00:04:00 Forecast Sheet 00:04:00 Add Spin Controls in Excel 00:05:00 Move Data using Mouse 00:01:00 Add new entry in Auto Correct to use across Office Applications 00:05:00 Find Differences between Two Lists 00:02:00 Find formulas Quickly 00:02:00 Unit: 06 Wrap Up Thank You 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00