• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

5663 Courses

MS Excel: 50 Tips to Upgrade your Excel Skills

5.0(1)

By Course Gate

Enhance your Excel skills with our comprehensive course covering 50 essential tips and techniques. Perfect for beginners and professionals alike, this course offers CPD accreditation and practical insights to boost your career prospects.

MS Excel: 50 Tips to Upgrade your Excel Skills
Delivered Online On Demand3 hours
£11.99

M.D.D OCCUPATIONAL THERAPY PACKAGE (SELF IMPROVEMENT)

4.9(27)

By Miss Date Doctor Dating Coach London, Couples Therapy

Introducing the Occupational Therapy Package: Empowering Independence and Enhancing Daily Living Are you seeking specialized support to enhance your daily living skills and regain independence in your life? Miss Date Doctor’s Occupational Therapy Package offers you expert guidance and personalized interventions to overcome challenges and achieve your goals. Occupational therapy is a client-centered approach that focuses on improving functional abilities and promoting independence in various aspects of life. Our experienced occupational therapists are committed to empowering you to participate fully in meaningful activities and overcome obstacles that may be affecting your daily functioning. Here’s how the Occupational Therapy Package can support you: Comprehensive Assessment: Our occupational therapists will conduct a thorough assessment of your physical, cognitive, and emotional abilities to understand your unique needs and challenges. Personalized Goals: Based on the assessment, we’ll work with you to set personalized goals that align with your aspirations and desired outcomes. Functional Interventions: Through a range of evidence-based interventions, we’ll address challenges related to self-care, productivity, and leisure activities, helping you regain independence in your daily life. Adaptive Techniques: Our therapists will introduce you to adaptive techniques and assistive devices that can support your engagement in various activities and promote greater autonomy. Workplace Support: For individuals seeking occupational therapy for work-related challenges, we’ll provide support and recommendations to improve workplace ergonomics, time management, and productivity. Cognitive Strategies: If cognitive challenges are affecting your daily functioning, our occupational therapists will introduce cognitive strategies to enhance memory, attention, and executive functions. Sensory Integration: For individuals experiencing sensory processing difficulties, our therapists will employ sensory integration techniques to help you better process sensory information and improve daily functioning. Lifestyle Modification: Occupational therapy goes beyond managing symptoms; it aims to improve overall well-being. We’ll work with you to make lifestyle modifications that promote health and balance. The Occupational Therapy Package at Miss Date Doctor is tailored to meet your unique needs and goals. Our compassionate occupational therapists will collaborate with you every step of the way to ensure that your therapy experience is positive, empowering, and transformative. Experience the benefits of occupational therapy and embrace a more independent and fulfilling life. Invest in your well-being and unlock your potential to thrive in everyday activities. Take the first step towards empowerment and enhanced daily living with the Occupational Therapy Package. Let our expert therapists guide you towards a life filled with greater independence, productivity, and satisfaction. 4 X 1 hour https://relationshipsmdd.com/product/occupational-therapy-package/

M.D.D OCCUPATIONAL THERAPY PACKAGE (SELF IMPROVEMENT)
Delivered in London or UK Wide or OnlineFlexible Dates
£500

PA, Minute Taking & Document Control -Endorsed Training

4.7(26)

By Academy for Health and Fitness

Unlock your potential with our all-inclusive "PA, Minute Taking & Document Control - Endorsed Training" bundle. This unique collection comprises three QLS-endorsed courses: Admin, Secretarial and PA Diploma Level 7, Minute Taking Executive Training Level 5, and Document Control. Strengthen your administrative acumen and document control capabilities with these comprehensive courses and receive a hardcopy certificate as proof of your new skills. Our bundle doesn't stop there. We offer five additional CPD QS-accredited courses that complement the QLS-endorsed material. Our selection of courses ensures a 360-degree coverage of administrative training. With our theoretical focus, you'll develop a solid foundation in both the principles and best practices of administrative work. Our courses are designed to engage and challenge, propelling you forward in your career path. Don't miss this opportunity to elevate your professional profile with our eight-course bundle. Key Features of the PA, Minute Taking & Document Control -Endorsed Training Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our PA, Minute Taking & Document Control -Endorsed Training bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Admin, Secretarial and PA Diploma Level 7 QLS Course 02: Minute Taking Executive Training Level 5 QLS Course 03: Document Control 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Data Entry Administrator Training Course 02: Chairing Effective Meetings Course 03: Communication Building Masterclass Course 04: Effective Communication with Better Email Course 05: Organising and Decluttering Course In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our PA, Minute Taking & Document Control -Endorsed Training courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the role and responsibilities of a PA, secretary, and admin staff. Master the art of taking effective minutes during meetings. Learn the principles and practices of document control. Develop proficiency in data entry and administration tasks. Learn how to chair meetings effectively for maximum productivity. Enhance communication skills for better collaboration and email communication. Gain skills in organising and decluttering for efficient workflow. The "PA, Minute Taking & Document Control - Endorsed Training" bundle is a powerhouse of theoretical knowledge, designed to cater to the needs of professionals and aspiring individuals in the administrative field. With three QLS-endorsed courses and five CPD QS-accredited courses, this bundle covers a wide range of relevant topics from effective minute-taking to decluttering workspaces. As part of our commitment to comprehensive education, each course is tailored to provide deep theoretical insights into the chosen topic, priming you for a successful administrative career. Embrace this opportunity to enhance your skills and make a significant impact on your professional journey. CPD 260 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring PA, secretarial, and admin staff seeking to broaden their knowledge base. Current professionals in the administrative field looking for advanced theoretical training. Individuals aiming for a career change into the administrative sector. Anyone interested in improving their minute-taking, document control, and overall organisational skills. Career path PA/Secretary: Annual salary range in the UK - £20,000 - £35,000 Document Control Specialist: Annual salary range in the UK - £25,000 - £40,000 Executive Assistant: Annual salary range in the UK - £25,000 - £50,000 Administrative Officer: Annual salary range in the UK - £18,000 - £30,000 Office Manager: Annual salary range in the UK - £24,000 - £45,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

PA, Minute Taking & Document Control -Endorsed Training
Delivered Online On Demand3 days
£309

Supervising Others

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is intended for individuals who desire to supervise others more effectively. Overview Upon successful completion of this course, students will be equipped to supervise others more effectively and efficiently, contributing to job satisfaction and productivity. In this course, students will develop the skills required to be more efficient and proficient supervisors. 1 - GETTING STARTED Icebreaker Housekeeping Items The Parking Lot Workshop Objectives 2 - SETTING EXPECTATIONS Defining the Requirements Identifying Opportunities for Improvement and Growth Setting Verbal Expectations Putting Expectations in Writing 3 - SETTING GOALS Understanding Cascading Goals The SMART Way Helping Others Set Goals 4 - ASSIGNING WORK General Principles The Dictatorial Approach The Apple-Picking Approach The Collaborative Approach 5 - DEGREES OF DELEGATION Level One: Complete Supervision Level Two: Partial Supervision Level Three: Complete Independence 6 - IMPLEMENT DELEGATION Deciding to Delegate To Whom Should You Delegate? Providing Instructions Monitoring the Results Troubleshooting Delegation 7 - PROVIDING FEEDBACK Characteristics of Good Feedback Feedback Delivery Tools Informal Feedback Formal Feedback 8 - MANAGING YOUR TIME The 80/20 Rule Prioritizing with the Urgent-Important Matrix Using a Productivity Journal Using Routines and Rituals to Simplify Your Workday 9 - RESOLVING CONFLICT Using a conflict Resolution Process Maintaining Fairness Seeking help from Within the Team Seeking Help for Outside the Team 10 - TIPS FOR SPECIAL SITUATIONS What to Do If You?ve Been Promoted from within the Team What to Do If You're Leading a Brand New Team What to Do if You're Taking on an Established Team 11 - A SURVIVAL GUIDE FOR THE NEW SUPERVISOR Ask the Right Questions of the Right People Go to Gemba Keep Learning 12 - WRAPPING UP Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations

Supervising Others
Delivered OnlineFlexible Dates
£395

Powerful Discipline Guide

By iStudy UK

Are you fighting to beat your bad habit? Do you need help controlling your urges? In Powerful Discipline Guide, you will learn how to train your brain for self-discipline mastery. You will learn why self-discipline is so important to achieving your life goals, and why having poor discipline can destroy you. Broke down into four detailed modules, this personal development course introduces seven effective strategies for building unbreakable self-discipline. You will learn how to eliminate temptations to create an environment free of distractions to improve your productivity and boost your willpower. This course will also teach you how to make effective lifestyle changes to gain complete mastery over your mind. Learning Outcomes: Learn the art of discipline and control to overcome challenging timesTrain your brain to beat your bad habits and stay strong to control your urgesUnderstand the benefits of self-discipline and how having poor discipline can destroy youDiscover 7 effective strategies for building unbreakable self-disciplineKnow the differences between discipline and motivationIncrease your productivity and boost your willpower through effective mind exercisesEliminate temptations and create an environment free of distractions Career Path This discipline training course will train your brain to master self control and build unshakable self confidence. On successful completion, learners will have the skills to stay in control of their urges and build incredible willpower. This course is ideal for: Life CoachesSports ProfessionalsStudentsAnyone looking to lose weightAnyone looking to beat their bad habits Unit 01: Introduction 1 - Introduction 00:02:00 Unit 02: Art of Discipline & Benefits The Art of Discipline 00:08:00 Benefits of Self-Discipline 00:10:00 Unit 03: KEY Discipline Skills, Tools & Insights Why Poor Discipline Can Destroy You 00:10:00 7 Strategies to Build Unbreakable Self-Discipline 00:10:00 How to Develop Powerful Self Discipline 00:11:00 Superiority of Discipline over Motivation 00:07:00 Unit 04: Conclusion Final Thoughts & Tips 00:01:00

Powerful Discipline Guide
Delivered Online On Demand59 minutes
£25

The Office Layout

By OnlineCoursesLearning.com

Introduction: Employees work better and more efficiently when their workspaces are well laid out. On the other hand, offices that are cluttered or chaotic tend to promote similar working environments. This principle extends beyond the workstation into how the office itself is organized. A well planned office leads to greater productivity with fewer interruptions and less time wasted each day. As a result, it is well worth your time to learn more about how to plan for the perfect office for your company's needs. This course gives you detailed information about how to properly plan your office layout. We begin by talking about the layout of an office in general terms. Next, we move on to talk about the individual considerations you need to remember when planning your next office layout. We also review the principles of office layout, giving you more information you can use to properly plan your own. Finally, we talk about factors that may affect your own office layout plan.   What You Will Learn: The objectives you should keep in mind when thinking about your office's floor plan The benefits of paying attention to office layout The individual factors that go into creating a well-organised office What the principles of office layout are The factors that go into how you should lay out your office Benefits of Taking This Course: Learning how to create a workspace that is functional as well as attractive Understanding how an office layout can have such an impact on employees Understanding why you should think about the physical location of the building as well as how it is laid out inside Learning how to create a workspace that is comfortable as well as efficient for each one of your employees Learning how to consider your company's needs in light of the available space when planning out an office Course Modules: Module 01: The Office Layout Module 02: The Principles and Importance of an Office Layout Module 03: Factors Affecting Office Layout Module 04: The Most Popular Types of Office Layout

The Office Layout
Delivered Online On Demand
£50

University of Cambridge & Bayfield Training - Real Estate Financial Modelling Certificate (Online Self-Study)

4.3(5)

By Bayfield Training

Bayfield Training and the University of Cambridge Department of Land Economy This prestigious eight-week online Real Estate course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleagues reassurance of your expertise. If you want to enhance your financial modelling skills over an extended period, the Real Estate Financial Modelling Certificate is the course for you. This online real estate course has been put together exclusively for the Real Estate Financial Modelling certificate, using state of the art digital resources such as animations, video-steps, digital whiteboard and video-interactions as well as the spreadsheets, text based resources and tutor contact you would expect from any of Bayfield Training’s classroom based courses.  Assessment is in the form of a guided model build exercise and written model appraisal. Participants benefit from an additional months access to the course platform after submission of the assessment. On this course you will: Become a competent model builder, building Real Estate Financial Models from scratch Learn tricks and concepts from financial modelling experts with decades of experience in practice and academia Learn how to use Real Estate Financial Models to make informed investment decisions Learn at a consistent pace over 8 weeks allowing you to take the time to fully grasp this important skill This course is suitable for: Chartered Surveyors Asset Managers Financial Controllers Financial Analysts Investment Managers Property Managers Real Estate Students/Recent Graduates Course Outline: Module 1 - Economic Context Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models. Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models. Why Real Estate Asset Modelling is important Understanding the occupier, asset and development markets and the relevant modelling approaches for each Real Estate Sub-Sector Key Performance Indicators Introduction to conventional valuations and financial mathematics Understanding and minimising errors in Financial Models Module 2 - Cash Flow Fundamentals Constructing a financial model from first principles. Understanding all the components of a basic cash flow model Understand why Corporate Finance Models and Real Estate Models are different Financial Model Design Making the link between valuations, income mathematics and discounted cash flows Internal Rate of Return, Net Present Value,Worth and other metrics Features and techniques to aid fast model building Module 3 - Developing the Cash Flow Adapting financial models for different periodicities and building rent functions for different rent behaviour. Understanding how leases vary with respect to rent over time: Rent Reviews, Break Clauses, Rent Free Periods, Lease Expiries etc. Developing the concept of a Rent Function in Excel Logic mathematics and Logic functions Projecting rent to adapt to different lease contracts and growth patterns Alternative solutions to Logic functions Comparative analysis of lease structures in different jurisdictions and adapting financial models Module 4 - Real Estate Data Understanding the different sources of data, constructing basic time series models and recognising basic patterns. Key Property market indicators Characteristics and application of key input metrics for Real Estate Appraisals Understanding the eight components of Real Estate Price Dynamics Awareness of the different sources of data Reading and using general property market reports Constructing basic time series models and recognising basic patterns Module 5 - Development Appraisals Constructing a development appraisal from first principles and understanding development return metrics. Understanding the key components of a development project Understanding the difference between development and investment appraisals Residual Appraisals and Profit Calculations Cost orientated cash flows and phased sales Cumulative construction cost patterns: incidental, fixed, loaded and S-curve Development return metrics and Modified IRRs Module 6 - Multi-let Cash Flows Constructing an advanced multi-let cash flow model and learn different techniques to build flexible rent functions. Multi-let and portfolio model design principles Building complex date functions and date series The three multi-let rent projection techniques Perpendicular Rent Functions Incorporate advanced rent adjustments into the Rent Function Incorporate sector and period varying rental growth rates Simplifying OPEX and CAPEX projections Discounting techniques on complex and volatile cash flows Module 7 - Project Finance Constructing a flexible Real Estate Debt Finance model. Revision of the Mathematics of amortisation and debt finance Basic senior debt models and geared net cash flow LTV, IRR and Interest Rate Dynamics Flexible term, repayment options and deferred interest Loan covenant tests Understanding different tranches of debt Understanding how complex debt structures impact the returns to different parties Module 8 - Model Interpretation and Risk Analysis Learn how to read, analyse and report on real estate financial models. Understand how to read models and develop an investment narrative Visualise model outputs using graph functions, conditional formatting, dynamic symbols and dashboards Learn how to use built-in Sensitivity, Scenario Analysis tools and third-party add-ins Learn how to construct varied project scenarios in a systematic way Introduction to Monte Carlo Analysis and VBA Optimising sale dates and other parameters Create well written, attractive and persuasive reports Included in the Course Bayfield Training and University of Cambridge Accredited Certificate & LinkedIn Proficiency Badge 64 CPD Hours 1 Month Post-Course Access to the Digital Platform - 12 Months Post-Course Access to the Platform can be purchased for an additional fee Course Files Q&A Webinars and Guest Speaker Webinars Further Learning Resources (Reading, Files and Videos) Post Course Support - Two Months of Questions & Answers 2024 Cohort Dates Include: 3rd June to 29th July 5th August to 25th September 2024 30th September to 25th November For more information, please contact Sam on the Bayfield Training Sales team: E - s.musgrave@bayfieldtraining.com T - 01223 517851 W - www.bayfieldtraining.com

University of Cambridge & Bayfield Training - Real Estate Financial Modelling Certificate (Online Self-Study)
Delivered Online & In-Person + more
£2,500

Mental Health "First Aid" Course (£695 total for this 1-day course for a group of up to 12 people)

By Buon Consultancy

Mental Health "First Aid" Training

Mental Health "First Aid" Course (£695 total for this 1-day course for a group of up to 12 people)
Delivered In-Person in Edinburgh or UK WideFlexible Dates
£695

Data Entry: Techniques and Best Practices

4.7(26)

By Academy for Health and Fitness

Get a Free 1 QLS Endorsed Certificate Course with 10 Additional CPDQS Accredited Bundle Courses In A Single Payment. Unlock the doors to a fulfilling career in data entry with our comprehensive Diploma in Data Entry. This online course is designed to equip you with the fundamental skills and knowledge needed to excel in the field of data entry. With 10 comprehensive courses, you'll develop proficiency in a wide range of areas, including office administration, data protection and security, Microsoft Excel, and touch typing. Our Diploma in Data Entry is ideal for anyone seeking to start a career in data entry, or for those already in the field looking to advance their skills. Our flexible online learning model allows you to study at your own pace and at a time and place that suits you best, giving you the freedom to balance your studies alongside your work or personal life. This Bundle Package includes: Course 01: Diploma in Data Entry Administrator at QLS Level 3 10 Additional CPDQS Accredited Premium Courses - Course 01: Office Administration & Skills Diploma Course 02: Document Control Course 03: Understanding Data Protection and Data Security Course 04: Complete Microsoft Word Course 05: Microsoft Excel - Beginner, Intermediate & Advanced Course 06: Craft Excel Pivot Tables for Data Reporting Course 07: Email Etiquette Course 08: Touch Typing Masterclass - Updated Version Course 09: Transcription Level 3 Course 10: Workplace Confidentiality Data entry may be an excellent job to explore if you want to use your keyboarding expertise and ability to work under pressure. In addition, a career in data entry may take you into a wide range of businesses, as firms from many industries hire for these roles. So, what is your trouble? Participate in our course and gain the rewards afterwards in your career. Learning Outcomes: Develop data entry skills to excel in the modern workplace. Learn the principles of data protection and confidentiality to ensure workplace compliance. Gain proficiency in Microsoft Word and Excel to create professional documents and spreadsheets. Craft pivot tables for data reporting to facilitate effective decision-making. Learn transcription and touch typing to increase productivity and efficiency. Develop email etiquette skills to improve communication and collaboration. Upon completion of the Data Entry course, you will be able to, Improve your grasp of the data entry business. Be able to utilise Microsoft Excel to make your job more efficient. Create and change worksheet formulae. You will learn how to categorise data. You will learn how to safeguard data. You'll discover how to handle workbooks and their attributes. Acquire the information and abilities required to operate expertly in the IT business. Be able to leverage statistics packages. The Diploma in Data Entry is a comprehensive program designed to provide students with the essential skills required for a successful career in data entry. This diploma consists of ten courses, including office administration, document control, data protection, Microsoft Word, Microsoft Excel, pivot tables for data reporting, email etiquette, touch typing, transcription, and workplace confidentiality. The program begins with an introduction to office administration and essential skills required to succeed in today's modern workplace. The course then moves on to cover data protection and confidentiality, providing students with an understanding of legal obligations and best practices for data management. Students then learn Microsoft Word and Excel, including pivot tables for data reporting, to enable the creation of professional documents and effective data analysis. Additionally, the program offers courses on email etiquette, touch typing, and transcription to increase productivity and efficiency in the workplace. Finally, students learn about workplace confidentiality, providing them with an understanding of the legal requirements of confidentiality in the workplace. The Diploma in Data Entry is an excellent investment for anyone seeking to improve their data entry skills and advance their career prospects. *** Course Curriculum: *** Course 01: Diploma in Data Entry Administrator at QLS Level 3 Module 1: Introduction Module 2: Using the Computer Module 3: Common Rules and Guidelines Module 4: Using Excel for Efficient Data Entry Module 5: Using Excel's Flash Fill and Autofill to Automate Data Entry Module 6: How to Create Form in Excel? Module 7: Using Statistics Packages CPD 220 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals looking to develop data entry skills for the modern workplace. Office administrators seeking to improve their skills and knowledge. Professionals seeking to learn data protection and confidentiality best practices. Students looking to improve their employability prospects. Anyone interested in developing their Microsoft Word and Excel skills. Requirements You will not need any prior background or expertise. All you need to take this course is - A smart device. A secure internet connection. Being over the age of 16. And a strong drive for learning and literacy. Career path Data Entry Clerk: £18,000 - £22,000 per year Office Administrator: £18,000 - £24,000 per year Administrative Assistant: £16,000 - £24,000 per year Data Analyst: £21,000 - £38,000 per year Executive Assistant: £22,000 - £40,000 per year Transcriptionist: £17,000 - £25,000 per year Certificates Diploma in Data Entry Administrator at QLS Level 3 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Data Entry Administrator at QLS Level 3, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with completely free of charge in this package. For Additional the Quality Licence Scheme Endorsed Certificate, you have to pay the price based on the Level of these Courses: Level 1 - £59 Level 2 - £79 Level 3 - £89 Level 4 - £99 Level 5 - £119 Level 6 - £129 Level 7 - £139 Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery) Certificate Accredited by CPDQS Digital certificate - £10

Data Entry: Techniques and Best Practices
Delivered Online On Demand3 weeks
£119

Top 50 MS Excel Advanced Tips to Upgrade Skill to next Level

4.3(43)

By John Academy

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

Top 50 MS Excel Advanced Tips to Upgrade Skill to next Level
Delivered Online On Demand2 hours 57 minutes
£18