Overview: Diploma in Paraplanning Unlock Your Future in Financial Services with the Comprehensive 'Diploma in Paraplanning' Are you passionate about finance and aspire to play a crucial role in shaping people's financial futures? Look no further than our 'Diploma in Paraplanning,' a meticulously crafted program designed to empower you with the knowledge and skills necessary to excel in the dynamic field of financial services. Key Features: Module 1: Introduction to ParaplanningLay the foundation for your paraplanning journey by understanding the core concepts and responsibilities.Explore the role of a paraplanner in supporting financial advisors and enhancing client experiences. Module 2: Financial Planning PrinciplesDive into the principles of effective financial planning.Develop a comprehensive understanding of goal setting, risk assessment, and client communication. Module 3: Financial Statements and AnalysisMaster the art of dissecting financial statements for meaningful insights.Equip yourself with the skills to analyze financial data and make informed recommendations. Module 4: Investment PrinciplesExplore the diverse landscape of investment options and strategies.Learn how to create well-structured investment portfolios tailored to individual client needs. Module 5: TaxationDelve into the complexities of taxation in the financial planning process.Gain expertise in optimizing tax strategies for individuals and businesses. Module 6: InsuranceUnderstand the critical role insurance plays in comprehensive financial planning.Explore different insurance products and learn how to tailor solutions to meet diverse client needs. Why Choose Our Diploma in Paraplanning? Industry-Relevant Curriculum: Stay ahead of the curve with a curriculum crafted by industry experts, ensuring you acquire the most up-to-date knowledge. Practical Application: Bridge the gap between theory and practice through real-world case studies and simulations, preparing you for the challenges of the financial services sector. Expert Instructors: Learn from seasoned professionals who bring a wealth of industry experience, providing valuable insights and mentorship throughout your journey. Career Advancement: Position yourself for success in the financial industry with a recognized diploma that opens doors to a range of career opportunities. Flexibility: Study at your own pace with our flexible online learning platform, allowing you to balance your education with other commitments. Invest in Your Future Today! Embark on a rewarding career path in financial services by enrolling in our 'Diploma in Paraplanning.' Equip yourself with the knowledge, skills, and confidence to make a significant impact in the lives of individuals and businesses alike. Secure your spot now and take the first step toward a successful and fulfilling career in paraplanning! Course Curriculum Module 1_ Introduction to Paraplanning Introduction to Paraplanning 00:00 Module 2_ Financial Planning Principles Financial Planning Principles 00:00 Module 3_ Financial Statements and Analysis Module 3_ Financial Statements and Analysis 00:00 Module 4_ Investment Principles Investment Principles 00:00 Module 5_ Taxation Taxation 00:00 Module 6_ Insurance Insurance 00:00
Are You Prepared to Save a Life? Discover the Power of First Aid At Work & BLS Training! Imagine a workplace where every employee is ready to act in emergencies. With 142,000 workplace injuries reported in the UK last year, the need for comprehensive training is clear. This First Aid At Work & BLS Training can be the difference between life and death. Gain essential knowledge that impacts your career and ensures you can respond effectively in critical situations. This First Aid At Work course is a quick and easy way to learn the essentials of first aid at work. With its step by step lessons and no fluff method of content delivery, First Aid At Work course saves you time and money as it's available at a discounted price at the moment. Get 3 CPD Accredited Courses- Course 01: Emergency First Aid at Work Certificate: Learn essential first aid skills to respond to workplace emergencies effectively. Course 02: Oxygen First Aid Training - Online Course: Understand the critical role of oxygen in first aid and how to administer it safely. Course 03: Anaphylaxis & BLS: Gain knowledge on recognizing and responding to anaphylactic emergencies and basic life support techniques. Key Highlights for First Aid At Work Course: Lifetime access to the First Aid At Work course materials Full tutor support is available from Monday to Friday with the First Aid At Work course Gain a complete understanding of the First Aid At Work course Accessible, informative First Aid At Work learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the First Aid At Work course Study First Aid At Work in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your First Aid At Work course Emergency First Aid at Work Course Curriculum: Module 01: Introduction to First Aid At Work Module 02: Legal Framework for First Aid At Work Module 03: Incident Management at Work Module 04: Primary Survey Module 05: Secondary Survey Module 06: Basic First-Aid Techniques Module 07: Dealing with Minor Injuries at Workplace Module 08: Secondary Illness: Loss of Responsiveness and CPR Module 09: Secondary Illness: Breathing Problems Module 10: Secondary Illnesses and Injuries Module 11: Dealing With Fractures and Dislocations Module 12: Call for an Emergency in First Aid At Work First Aid At Work Learning Outcomes: Upon successful completion of this highly appreciated First Aid At Work course, you'll be a skilled professional, besides- The learner will acquire the theoretical knowledge necessary to provide First Aid At Work. Identifying the First Aider's duties and doing an emergency scenario assessment First aid for an unconscious victim who is breathing properly (recovery position) First aid for an unconscious and inbreathing victim (CPR & the use of AED) Treatment for a victim experiencing a seizure Initial treatment for breathing issues Treatment for fractures and dislocations using first aid First aid for a victim with minor wounds Certificates: CPD Quality Standard Certificate Digital certificate - CPD Accredited Certificate - Free Hardcopy Certificate (FREE UK Delivery) CPD Hard copy certificate - £9.99 CPD Hardcopy Transcript: £9.99 CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this course. Besides, First Aid At Work course is particularly recommended for - Students related to First Aid At Work Recent graduates Job Seekers in related fields. Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Requirements Learners seeking to enrol for the First Aid At Work Course should meet the following requirements; Basic knowledge of English Language, which already you have Be age 16 years or above Basic Knowledge of Information & Communication Technologies for studying online or digital platform. Stable Internet or Data connection in your learning devices. Career path After completing this First Aid At Work course, you can explore trendy and in-demand jobs related to this course, such as - First Aider Child Care Providers Coaches and Athletes Trainers Construction Workers Electricians Firefighters Flight Attendants Explore each of the roles available and how you can start your career in First Aid At Work course. Certificates CPD Certificate Digital certificate - Included After successfully completing this course, you can get CPD accredited digital PDF certificate for free.
48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! Are you aware that English is spoken by 20% of the world's population? English is the native language of about 360 million people and the global business language. Millions of people worldwide speak English, and billions more want to enhance their English abilities. As a result, the globe is always in need of teachers who can teach English as a foreign language. If you are interested in teaching language, this 120 Hours TEFL (TESOL) course can give you a kickstart. This Advanced Diploma in TEFL (TESOL) at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 180 CPD points) to make your skill development & career progression more accessible than ever! This TEFL / TESOL Advanced Diploma course will introduce you to English language teaching and learning. You will learn how to use educational games and activities to teach students important listening, reading, writing, and speaking skills while strengthening their linguistic ability. You will also learn how to prepare, arrange, and deliver interesting foreign language lesson planning and creating materials. This industry-recognised course takes only 120 hours to complete and is specifically intended to give you the ability to teach English at a basic level. It also covers crucial skills that can help you advance in your profession. Enrol in this comprehensively designed 120 Hours TEFL (TESOL) course today to get the expertise to teach! Learning Outcomes Understand the significance of English language teaching and learning. Learn about several linguistic techniques. Get a firm grasp of English pronunciation. Learn enough about the fundamentals of grammar and vocabulary. Improve your skills in reading, writing, listening and speaking. Increase your understanding of TEFL lesson frameworks and become acquainted with the steps and structure of an English lesson. Learn to use games and activities. Recognise the technology in second language teaching and learning. Investigate many situational approaches. Explore the link between professional development and employment. Why Prefer This TEFL / TESOL Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS after completing the TEFL / TESOL course Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Experts created the TEFL / TESOL Training course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the course: Module 01: Introduction to English Language Teaching & Learning Nature of Language How Do We Learn Language? How Do We Teach Language? Module 02: Linguistics Phonology Lexicology Morphology Module 03: English Pronunciation Teaching Pronunciation Useful Tips Word Stress Module 04: Teaching Grammar and Vocabulary Subjects, Verbs and Objects The Subjects The Verbs Recognising Regular and Irregular Verbs Shortening Verbs with Contractions The Object Proposing Prepositions Module 05: Language Teaching Methodologies Teaching Models that Have Influenced Current Teaching Practice Grammar Translation Method (GTM) Direct Method Audio lingual Method (ALM) Module 06: Teaching Receptive Skills: Reading Introduction Factors That Influence the Reading in a Foreign or Second Language Cognitive Development and Style Orientation Forming Associations Metacognitive Knowledge Developing Reading skills & Second Language Proficiency Degree of Difference between the First Language and the Second Language or Foreign Language Cultural Orientation Module 07: Teaching Productive Skills: Writing Sentence Structure Second Language Writing Creating New Knowledge Writing Competence Writing Process Writing Tasks Informative and Explanatory Writing Module 08: Teaching Receptive Skills: Listening Introduction Historical Perspective What Makes a Good Listening Text? Structuring Your Lessons Authentic Versus Non-Authentic Listening Materials Listening Sources Module 09: Teaching Productive Skills: Speaking Introduction to Speaking English Reasons for Teaching Speaking What Is "Teaching Speaking"? The Roles of Students in Learning Speaking Speaking Strategies and Teaching Techniques Module 10: Lesson Planning and Creating Materials Introduction Deciding What to Teach? Keeping Things Relevant Setting Lesson Aims & Objectives Stage Aims Lesson Structure Presentation, Practice, and Production Some Tips What are classroom Materials? Important Uses of Materials Listing Popular Course Books and Published Resources Adapting Your Course Book Making Use of Authentic Materials Module 11: Use of Games and Activities Games for Language Learning Roleplay Usage of Songs Using the News Module 12: Technology in Second Language Teaching & Learning Technologies for Teaching and Learning L2 Grammar Technologies for Teaching and Learning L2 Vocabulary CALL Tools for Reading and Writing CALL Tools for Listening and Speaking Distance Language Teaching with Technology Telecollaboration Module 13: Classroom Management and Student Motivation Running Your Classes Effectively Organising Your Classroom Establishing Classroom Rules Keeping Order Students Keep Using Their Language What If Students Don't Want to Talk Students Bored and/or Unmotivated Strong Student Dominance Time Management Lateness Module 14: Teaching English: Situational Approach Teaching English to Young Learners Teaching English to Adults Cooperative Teaching and Learning Teaching Business English Module 15: Professional Development and Employment TEFL Marketplace Getting Out There Thinking About a Stint or a Life in TEFL Teaching the Teacher Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam.Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the Advanced Diploma in TEFL (TESOL) at QLS Level 7 course exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is appropriate for anybody interested in teaching the English language. If you want to succeed in this sector, this course can be the right start. Requirements The TEFL / TESOL Training program does not require any prior knowledge; everyone may participate! This TEFL / TESOL Training course is open to anyone interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This TEFL / TESOL Training course allows you to study at your speed and grow a quality skillset. Career path This course creates a new door for you to access the relevant job market and allows you to gather in-depth information and the necessary abilities to thrive in the following career options. TEFL Teacher IELTS Instructor English Teacher TEFL teachers in the United Kingdom generally make between £26,600 and £33,000 per year. Certificates Certificate of completion Digital certificate - £10 Advanced Diploma in TEFL (TESOL) at QLS Level 7 Hard copy certificate - £139 Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Diploma in TEFL (TESOL) at QLS Level 7, 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 - 139 GBP inside the UK 149 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)
Interact with people to earn good reputation as a Receptionist Do you feel you can have a career as an Office admin or a receptionist? Then what are you waiting for! This course was made for you. The Professional Receptionist Skills Diploma will teach you how to serve visitors by greeting, welcoming, and directing them appropriately; notifies company personnel of visitor arrival; maintains security and telecommunications system. For any company, you need a person to greet clients or customers. A good receptionist helps make a good impression about the company and can enhance the reputation of the company. The business duties of a receptionist may include answering visitors' enquiries about a company and its products or services, directing visitors to their destinations, sorting and handing out mail, answering incoming calls and setting appointments. Professional Receptionist Skills Diploma comprises of units designed to improve your social skills and help you interact better with customers or clients. So what are you waiting for, get the course now! Course Highlights Professional Receptionist Skills Diploma is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Professional Receptionist Skills Diploma into several modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Professional Receptionist Skills Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Professional Receptionist Skills Diploma is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Professional Receptionist Skills Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Professional Receptionist Skills Diploma - Updated Version Introduction to Reception and Receptionist 00:26:00 Business Telephone Skills 00:20:00 Representing Your Boss and Company 00:36:00 Mail Services and Shipping 00:28:00 Travel Arrangements 00:25:00 Organising Meeting and Conferences 00:28:00 Time Management 00:35:00 Record Keeping and Filing Systems 00:28:00 Business Writing Skills 00:41:00 Organisational Skills 00:26:00 Communication Skills 00:27:00 Customer Service 00:17:00 Effective Planning and Scheduling 00:52:00 Invoicing/Petty Cash 00:28:00 Business Environment 00:16:00 Microsoft Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:28:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Professional Receptionist Skills Diploma - Old Version Module 1: Receptionist Receptionist FREE 00:30:00 Importance of Receptionist FREE 00:15:00 Different Types of Receptionist & Roles 01:00:00 Communication Skills for Receptionist 01:00:00 Telephone Skills 01:00:00 Listening Skills 01:00:00 Taking Messages 00:30:00 Presenting & Appearance 00:30:00 Reservation Procedure 00:15:00 Confidentiality Checklist 00:15:00 Being Organized as Receptionist 00:15:00 Becoming a Successful Receptionist 00:15:00 Module 2: Communication Skills Techniques To Be A Spontaneous Speaker 01:00:00 Knowledge Is Power - So Enrich Your Knowledge 01:00:00 Remarkable Tips To Introduce Yourself 01:00:00 Simple Strategies That Promote Conversations 01:00:00 Speaking From The Heart 01:00:00 Learn To Be A Good Listener First 00:30:00 Stop Bragging About Yourself 01:00:00 Easy Way To Start A Conversation 01:00:00 Handle Criticism Smartly 01:00:00 Asking For What You Want 00:30:00 Module 3: Interpersonal Skills Module One - Getting Started 00:30:00 Module Two - Verbal Communication Skills 01:00:00 Module Three - Non-Verbal Communication Skills 01:00:00 Module Four - Making Small Talk and Moving Beyond 01:00:00 Module Five - Moving the Conversation Along 01:00:00 Module Six - Remembering Names 01:00:00 Module Seven - Influencing Skills 01:00:00 Module Eight - Bringing People to Your Side 01:00:00 Module Nine - Sharing Your Opinion 01:00:00 Module Ten - Negotiation Basics 01:00:00 Module Eleven - Making an Impact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Interpersonal Skills Development Course- Activities 00:00:00 Module 4: Office Management Skills Building Your Management Team 01:00:00 Building A Successful Brand 01:00:00 Achieving Quality Through Teamwork 00:30:00 Keys To Staying Motivated 00:30:00 Improve Your Marketing 01:00:00 Provide Top Customer Service 00:30:00 Wrapping Up 00:30:00 Module 5: Microsoft Word Module One - Getting Started FREE 00:30:00 Module Two - Opening Word FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities- Microsoft Word 00:00:00 Module 6: Microsoft Excel Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities - Microsoft Excel 00:00:00 Module 7: Microsoft PowerPoint Module One - Getting Started FREE 00:30:00 Module Two - Opening PowerPoint FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Certified Microsoft PowerPoint for Beginners - Activities 00:00:00 Mock Exam Mock Exam- Professional Receptionist Skills Diploma 00:30:00 Final Exam Final Exam- Professional Receptionist Skills Diploma 00:30:00
Description MS Excel introduces multi-dimensional activities through its various feature. Do you want to be the first to look at the MS Excel 2016 Introduction course to learn its vivid use? Don't be late. Look at the MS Excel 2016 Introduction course and justify its authentic knowing its various fields. The course designs in such a way that helps you to know the basic functions of MS Excel and various use of Excel for making calculation, producing charts, and recording data of all kind of business. It teaches you how to create Excel data, simple PivotTable and charts, vivid use of IF, SUM, TOTAL, and AVERAGE. It enables the students to understand how Excel is used in business to analyze the existing data. It also teaches the functions of range, and cell to do different types of activities. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Excel 2016 Introduction is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our MS Excel 2016 Introduction 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 Getting Started with Excel What is Excel 00:02:00 Opening Excel 00:04:00 Navigating the Excel User Interface 00:07:00 Using the Excel Ribbon 00:03:00 Understanding Excel Work Components 00:04:00 Using the Backstage View 00:03:00 Creating Workbooks and Using Templates Creating a New Workbook 00:03:00 Creating Workbooks Using Templates 00:03:00 Saving an Excel Workbook 00:05:00 Using Convert and Checking Compatiblity 00:02:00 Entering Data Navigating a Worksheet by Mouse or Keyboard 00:05:00 Excel Data Types 00:03:00 Cell and Range Addressing 00:02:00 Data Selection Techniques 00:05:00 Common Excel Commands 00:07:00 Using the Autofill Handle 00:03:00 Excel Formula Basics Data What are Formulas and Functions 00:02:00 Components of a Formula 00:06:00 Calculation Hierarchy Using the Order of Operations_Revise 00:02:00 Creating Basic Formulas 00:08:00 Working with Basic Functions and Autosum 00:04:00 Using Cell References 00:04:00 Using the Quick Analysis Tool 00:01:00 Adjusting a Worksheet Modifying Columns and Rows 00:06:00 Hiding and Unhiding Columns and Rows 00:03:00 Formatting and Aligning Worksheet Data Formatting and Aligning Data 00:06:00 Merging Data 00:03:00 Wrapping Text Orientation 00:02:00 Formatting Numbers 00:03:00 Using Borders and Shading 00:03:00 Using the Format Painter 00:01:00 Removing Formatting Quickly 00:01:00 Using Cell Styles and Themes Understanding Cell Styles 00:02:00 Applying Cell Styles 00:04:00 Applying Themes 00:03:00 Inserting Objects and Graphics Inserting and Formatting Images 00:03:00 Inserting and Formatting Shapes 00:04:00 Inserting and Formatting Smart Art 00:04:00 Inserting Screenshots 00:02:00 Inserting Hyperlinks 00:03:00 Inserting Symbols and Equations 00:03:00 Inserting Word Art Or Text Boxes 00:04:00 Inserting Other Excel Objects 00:04:00 Arranging Objects 00:04:00 Proofing a Workbook Using Find and Replace 00:04:00 Finding and Replacing Formatting 00:01:00 Using Got to and Go to Special 00:02:00 Using the Spell Checker 00:03:00 Using the Theasaurus and Translation Feature 00:03:00 Printing an Excel File Printing and Previewing Excel Files 00:03:00 Creating Custom Margins and Scaling 00:05:00 Adding Headers and Footers 00:04:00 Formatting a Page with the Page Layout Tab 00:03:00 Printing Titles and Specific Worksheet Areas 00:05:00 Exporting to PDF and XPs 00:02:00 Managing Worksheets Renaming and Coloring Worksheet Tabs 00:03:00 Adding, Deleting, and Navigating Worksheets 00:03:00 Moving and Copying Worksheets 00:04:00 Hiding and Unhiding Worksheets 00:02:00 Navigating and Viewing Excel Files Viewing Workbooks 00:03:00 Using Zoom Tools 00:02:00 Configure Sheet Options 00:02:00 Using Freeze Panes and Split Commands 00:05:00 Working with Window Commands 00:04:00 Adjusting Workbook Properties 00:03:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: This particular course has multiple functions including working with templates, generating the baseline plans, monitoring and renovating projects, analysing the project statistics, coping with delays and conflicts, and overall, learning to customise projects. In fact, through executing the project server 2010, you will gain knowledge of communicating the project information as well as combining the project data with the other relevant office applications in general. Moreover, the learners who are basically the information workers and those who want to learn the elementary level of the Access 2010 skills properly match with the very design of the course. Apart from that,the Microsoft Office 2010 Access Intermediate- Complete Video Course is basically based on the skills and ideas learned from the Access 2010.This particular course helps you learn the items such as: the relational databases, related tables,complex queries, reports and printing, charts and pivot tables and also pivot charts. The fundamental topics that have been discussed in the particular course include: learning about querying with SQL, the advanced queries, Macros, the Advanced Macros and so on. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Level 3 Diploma in Microsoft Access 2010 is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Level 3 Diploma in Microsoft Access 2010 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 01: Beginner Getting Started Database Concepts FREE 00:04:00 Exploring the Access Environment 00:11:00 Getting Help 00:02:00 Databases and Tables Planning and Designing Databases 00:12:00 Exploring Tables 00:11:00 Creating Tables 00:33:00 Fields and Records Changing the Design of a Table 00:15:00 Finding and Editing Records 00:06:00 Organizing Records 00:16:00 Data Entry Rules Setting Field Properties 00:14:00 Working with Input Masks 00:07:00 Setting Validation Rules 00:06:00 Basic Queries Creating and Using Queries 00:13:00 Modifying Query Results and Queries 00:05:00 Performing Operations in Queries 00:17:00 Using Forms Creating Forms 00:11:00 Using Design View 00:14:00 Sorting and Filtering Records 00:04:00 Working with Reports Creating Reports 00:10:00 Modifying and Printing Reports 00:16:00 Module 02: Intermediate Relational Databases Database Normalization 00:14:00 Table Relationships 00:13:00 Referential Integrity 00:12:00 Related Tables Creating Lookup Fields 00:11:00 Modifying Lookup Fields 00:06:00 Using Subdatasheets 00:04:00 Complex Queries Joining Tables in Queries 00:26:00 Using Calculated Fields 00:09:00 Summarizing and Grouping Values 00:08:00 Advanced Form Design Adding Unbound Controls 00:08:00 Adding Graphics 00:04:00 Adding Calculated Values 00:06:00 Adding Combo Boxes 00:04:00 Advanced Form Types 00:10:00 Reports and Printing Customized Headers and Footers 00:17:00 Calculated Values 00:08:00 Calculated Values 00:08:00 Printing 00:03:00 Labels 00:05:00 Charts Charts in Forms 00:08:00 Charts in Reports 00:06:00 PivotTables and PivotCharts PivotTables 00:05:00 Modifying PivotTables 00:07:00 PivotCharts 00:04:00 PivotTable Forms 00:01:00 Module 03: Advanced Querying with SQL SQL and Access FREE 00:06:00 Writing SQL Statements 00:18:00 Attaching SQL Queries to Controls 00:06:00 Advanced Queries Creating Crosstab Queries 00:05:00 Creating Parameter Queries 00:11:00 Using Action Queries 00:17:00 Macros Creating, Running, and Modifying Macros 00:08:00 Attaching Macros to the Events of Database Objects 00:05:00 Advanced Macros Creating Macros to Provide User Interaction 00:20:00 Creating Macros that Require User Input 00:04:00 Creating AutoKeys and AutoExec Macros 00:07:00 Creating Macros for Data Transfer 00:07:00 Importing, Exporting, and Linking Importing Objects 00:14:00 Exporting Objects 00:06:00 Working with XML Documents 00:13:00 Linking Access Objects 00:13:00 Using Hyperlink Fields 00:06:00 Database Management Optimizing Resources 00:16:00 Protecting Databases 00:05:00 Setting Options and Properties 00:06:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: Accountancy refers to the profession or studies of an accountant who keeps the record of financial work and taxes. Without proper accounting, business is meaningless. The Diploma in Accountancy course provides extensive lessons about accounting to make you prepare for the business world. The course covers the basics of accounting along with the concepts of the balance sheet, how to prepare the balance sheet, taxation, etc. You will learn the skills that you need to know for managing and operating the accounting of an organisation. Apart from these, the course includes investment management, auditing, marketing, retail and many more. In short, upon completion, you will be efficient enough to manage the accounting department. Therefore, the course is suitable for the managers and the people who want to obtain a career in accounting. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Diploma in Accountancy is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Diploma in Accountancy 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 01 Getting the Facts Straight 00:30:00 The Accounting Cycle 00:30:00 The Key Reports 00:30:00 A Review of Financial Terms 00:30:00 Understanding Debits and Credits 00:15:00 Your Financial Analysis Toolbox 00:30:00 Identifying High and Low Risk Companies 00:30:00 The Basics of Budgeting 00:15:00 Working Smarter 00:10:00 Module 02 Professional Bookkeeper FREE 00:09:00 Defining a Business 00:07:00 Ethics in Accounting 00:05:00 Generally Accepted Accounting Principles (GAAP) 00:10:00 The Accounting Equation 00:07:00 Transactions 00:11:00 Financial Statements 00:13:00 The Accounting Equation and Transactions 00:16:00 Double-Entry System 00:11:00 Transactions - Journalizing 00:17:00 Journal Entries 00:38:00 Posting Entries 00:10:00 The Trial Balance 00:10:00 Finding Errors Using Horizontal Analysis 00:09:00 Horizontal Trend : Balance Sheet 00:21:00 Horizontal Trend: Income Statement 00:36:00 The Purpose of the Adjusting Process 00:15:00 Adjusting Entries - Prepaid Expenses 00:13:00 Adjusting Entries - Accrued Revenues 00:10:00 Adjusting Entries - Depreciation Expense 00:09:00 Adjustment Summary - Review 00:13:00 Vertical Analysis 00:33:00 Preparing a Worksheet 00:06:00 The Income Statement 00:11:00 Financial Statements - Definitions 00:12:00 Temporary vs. Permanent Accounts 00:19:00 Accounting Cycle Illustrated - Steps 1-5 00:11:00 Accounting Cycle Illustrated - Steps 6-10 00:12:00 Fiscal Year 00:09:00 Spreadsheet Exercise - Steps 1-4 00:11:00 Spreadsheet Exercise - Steps 5-7 00:37:00 Module 3 Module One - Introduction 00:30:00 Module Two - Basic Terminology 01:00:00 Module Three - Basic Terminology (II) 01:00:00 Module Four - Accounting Methods 01:00:00 Module Five - Keeping Track of Your Business 01:00:00 Module Six - Understanding the Balance Sheet 01:00:00 Module Seven - Other Financial Statements 01:00:00 Module Eight - Payroll Accounting Terminology 01:00:00 Module Nine - End of Period Procedures 01:00:00 Module Ten - Financial Planning, Budgeting and Control 01:00:00 Module Eleven - Auditing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Module 4 Tax System in the UK 01:00:00 What Is Payroll? 00:30:00 Principles Of Payroll Systems 01:00:00 Confidentiality And Security Of Information 00:30:00 Effective Payroll Processing 01:00:00 Increasing Payroll Efficiency 01:00:00 Risk Management in Payroll 00:30:00 Time Management 00:30:00 Personnel Filing 00:30:00 When Workers Leave Employment 01:00:00 Hiring Employees 00:30:00 Paye and Payroll for Employers 01:00:00 Tell HMRC about a New Employee 01:00:00 Net And Gross Pay 00:30:00 Statutory Sick Pay 00:30:00 Minimum Wage for Different types of Work 01:00:00 Mock Exam Mock Exam- Diploma in Accountancy 00:30:00 Final Exam Final Exam- Diploma in Accountancy 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00
Overview: Phlebotomy is the process of taking our blood sample from the body. The blood sample is usually taken from the arm vein. It is also known as Venipuncture. Blood samples are required to detect and diagnose many health-related issues. Phlebotomy skills are fundamental for healthcare workers. Our Phlebotomy online course will help you understand the basics of phlebotomy step by step. The phlebotomy course aims to thoroughly explain the venipuncture process, including supplies and equipment, safety and infection control, and specimen handling and processing. You will learn the anatomy and physiology of veins and the methods to complete a venipuncture safely and correctly to take a blood sample. So, enroll now! Learning Outcomes of the Phlebotomy Training Course: Gain the knowledge, skills and guidelines to work as a healthcare technician specialising in phlebotomy. Get the primary job responsibilities of a phlebotomist. Accumulate knowledge of Medical Terminology that involves drawing and preparing blood for lab testing. Learn to use blood collection equipment and perform hand hygiene. Discover infection control and safety standards of working as a phlebotomist and how to prevent hematomas and nerve damage. Be updated about modern diagnostic methods and the latest lab technology. Understand more about the precautions required for patients with special needs and appropriate ways to communicate with patients. Key Features of the Phlebotomy Training Course: FREE Phlebotomy Training CPD-accredited certificate Get a free student ID card with Phlebotomy Training training (£10 applicable for international delivery) Lifetime access to the Phlebotomy Training course materials The Phlebotomy Training program comes with 24/7 tutor support Get instant access to this Phlebotomy Training course Learn Phlebotomy Training training from anywhere in the world The Phlebotomy Training training is affordable and simple to understand The Phlebotomy Training training is an entirely online Who is This Course For? This Phlebotomy Training course is perfect for individuals passionate about healthcare and aspiring to embark on a career combining scientific knowledge with patient care. Whether you are a medical student or a healthcare professional looking to expand your skill set, this Phlebotomy Training course will provide you with a solid foundation in phlebotomy and open doors to exciting opportunities in the field. What You Will Learn: Throughout this comprehensive Phlebotomy Training course, you will delve into various topics and modules vital to your understanding of phlebotomy. In the first module, you will explore infection control and risk management, gaining insights into maintaining a safe and hygienic environment for patients and practitioners. In subsequent modules, you will delve into the intricacies of venipuncture techniques, blood collection equipment, patient interaction, and laboratory processes. With a focus on theoretical knowledge and relevant skills, this Phlebotomy Training course will empower you to confidently perform venipuncture procedures and contribute to the accurate diagnosis and treatment of various medical conditions. Why Enroll in This Course: This course is regularly updated to align with industry standards and practices, ensuring you receive the most relevant and up-to-date knowledge. Don't just take our word for it. This Phlebotomy Training course has received top reviews from our learners, who have praised its comprehensive content and ability to provide a solid foundation for a successful career in phlebotomy. Requirements: No prior experience or specific qualifications are required to enroll in this Phlebotomy Training course. However, a passion for healthcare and a genuine desire to positively impact people's lives will serve as your guiding light throughout this journey. Career Path: Upon completing this Phlebotomy Training course, you will be equipped with the necessary skills for various career paths in phlebotomy. Here are seven course-related professions, along with their corresponding average salaries in the UK: Phlebotomist: £22,000 - £26,000 per year Medical Laboratory Assistant: £16,000 - £20,000 per year Blood Donor Technician: £18,000 - £22,000 per year Clinical Research Assistant: £20,000 - £24,000 per year Healthcare Assistant: £17,000 - £22,000 per year Laboratory Technician: £18,000 - £24,000 per year Pathology Collector: £18,000 - £22,000 per year Certification: Upon completing our Phlebotomy Training course, you will receive a CPD certificate, recognized and valued by employers in the healthcare industry. Enroll today and unlock a world of endless possibilities as you become a vital part of the healthcare system and touch lives through the art of blood collection. Course Curriculum 11 sections • 11 lectures • 03:37:00 hours total •Introduction to Phlebotomy •Blood Circulation, Function, and Composition •Phlebotomy Equipment •Routine Venipuncture •Venipuncture Complications and Pre-Examination Variables •Dermal Puncture •Quality Assessment and Management in Phlebotomy •Special Blood Collection Procedure •Infection Control and Risk Management •Mock Exam - Phlebotomy •Final Exam - Phlebotomy
Description Being a second language learner, do you want to be an expert in the German language? Are you interested to increase your fluency in this language to get much more opportunities in educational sectors, job markets, and office? If so, take a look at our well-designed German language learning course. Its precise contents help you to be better in using the German language in vivid ways. The Complete German Course - Beginner course deals with the basic German language, grammar, vocabulary, and use of German tense. The outlines of the course incorporate a different form of the pronoun, and effective words so that you can use these properly to improve your communicational and conversational skills. It introduces you to the key use of the verb, and greeting sentences. The purpose of the course is to enrich your fluency so that you can respond in asking a question of your surrounded people. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Complete German Course - Beginner is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Complete German Course - Beginner 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 1 Learn German - Find out all about this course in less than two min 00:02:00 Learn German - The Alphabet 00:14:00 Learn German - Pronouncing certain combinations of letters 00:09:00 Learn German - Introduce yourself and others 00:07:00 Learn German - Greet someone - say good-bye to someone 00:09:00 Learn German - The Gender - the Articles 00:08:00 Learn German - Where do you come from- 00:07:00 Learn German - What languages do you speak- 00:06:00 Learn German - The numbers until 20 00:11:00 Learn German - The numbers until 100 00:08:00 Module 2 The personal pronouns and conjugation of the verbs 'to be' and 't 00:11:00 Learn German - The conjugation in the present part 1 00:10:00 Learn German - The conjugation in the present part 2 00:18:00 Learn German - The conjugation in the present part 3 00:15:00 Learn German - Recap dictation 00:22:00 Learn German - The possessive pronoun 00:19:00 Learn German - The Family 00:16:00 Learn German - More detailed information about the person- pers 00:17:00 Learn German - The food-Going shopping 00:20:00 Learn German - The price- How much does it cost- 00:12:00 Module 3 Learn German - The question words with W-The Yes- No questions 00:16:00 Learn German - The times of the day-The days of the week 00:15:00 Learn German - The daily routine 00:23:00 Learn German - The apartment 00:19:00 Learn German - The real estate announce 00:21:00 Learn German - The furniture- The interior equipment 00:18:00 Learn German - The plural 00:18:00 Learn German - The gender-the grammatical gender 00:18:00 Learn German - Country information 00:19:00 Learn German - The negation with 'nicht' and 'kein' 00:17:00 Module 4 Learn German - Separable and non-separable verbs 00:20:00 Learn German - The colors 00:12:00 Learn German - Hobbies 00:17:00 Learn German - Let's cook 00:17:00 Learn German - Repeat Dictation 00:17:00 Learn German - Test 00:14:00 Learn German - Test - Part 2 00:19:00 Learn German - The syntax 00:18:00 Learn German - Introduction to the cases 00:02:00 Learn German - The Perfect 00:20:00 Module 5 Learn German - The Participle II 00:17:00 Learn German - Exercises for Participle II and Perfect 00:19:00 Learn German - Occupations and work environment 00:24:00 Learn German - Understanding a job advertisement 00:19:00 Learn German - Introduction to the prepositions 00:13:00 Learn German - When traveling 00:20:00 Learn German - Fill out a form 00:25:00 Learn German - The body parts 00:21:00 Learn German - Health and sickness 00:18:00 Learn German - At the doctor's 00:22:00 Module 6 Learn German - The comparative 00:20:00 Learn German - The superlative 00:18:00 Learn German - What is a healthy diet 00:20:00 Learn German - To be in a city 00:20:00 Learn German - Local prepositions 00:15:00 Learn German - The polite speech-The subjunctive 2 00:21:00 Learn German - The clothing 00:27:00 Learn German - The ordinal numbers 00:17:00 Learn German - Important holidays in Germany 00:20:00 Learn German - The big Germany quiz 00:21:00 Course Certification Order your Certificate 00:00: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