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

6481 Finance courses

Excel 2016 Introduction

By Course Cloud

This course will introduce you to the basics of Excel 2016. By completing this Excel 2016 Introduction course, you will have skills to stand out from the crowd. You will learn how to create and manage spreadsheets in Excel. You will learn how to use cells and themes in Excel. In this Excel 2016 Introduction course, you will be able to confidently add columns and rows to spreadsheets. This course will teach you how to use specific features such as calculation hierarchy. Learn how to easily modify worksheets, insert objects and enter data easily by taking this course. You can also practice what you learn throughout the course. Excel 2016 Introduction is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector.  This course is accredited by CPD, so you will get a career boost upon completing this course. Our Excel 2016 Introduction is packed with 68 modules and 3 hours, 46 minutes of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website. It doesn't matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.  Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

Excel 2016 Introduction
Delivered Online On Demand
£25

Excel 365 Beginner

By Course Cloud

. Certification After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

Excel 365 Beginner
Delivered Online On Demand
£25

Letting Agent and Functional Skills (Maths) Training Course

5.0(1)

By Course Gate

This bundle course has been specially designed to equip our learners with a more in-depth understanding of lettings negotiating by providing them with essential functional maths skills required for this role. By combining these related courses, learners will be able to apply their practical knowledge in the real world, to take their professionalism to the next level. Take steps to become a certified lettings negotiator and be equipped with the skills and practical knowledge to advise clients and support landlords in renting their properties with the Lettings negotiator Diploma. This beginners training program is designed to provide an insight into lettings management, exploring the role of a lettings negotiator and lettings agent in detail. You will learn about the different types of agents, how to carry out a property valuation, build a relationship with clients and much more. Possessing excellent maths skills is essential for anyone who wishes to work in the property market. The Functional Maths Training Course is designed to provide aspiring lettings negotiators with the necessary skills to master everyday maths problems related to lettings management. You will learn how to calculate overall profit and loss, develop crucial problem-solving skills and gain confidence in working with decimals, fractions and percentages. This training program includes practical exercises that can be applied in real-world scenarios and is an opportunity to learn valuable transferable skills. Learning Outcomes: Learn the fundamental principles and practices of lettings management Familiarise with the lettings agency agreements guideline Understand the differences between a lettings agent and estate agent Explore the day-to-day role and responsibilities of a lettings agent Develop a solid understanding of the property valuation process Gain advanced knowledge of functional maths and apply your new skills to everyday situations Develop your skills in logical thinking and problem-solving Learn how to work with decimals, percentages, fractions and much more Gain a solid understanding of ratios and proportion through practical exercises Understand how to calculate overall profit and loss Who is This Course for? This bundle course is ideal for aspiring lettings negotiators, or lettings agents who are new to the field and wish to gain the relevant skills and knowledge to take their career to the next level. This course is also ideal for anyone who works in the real estate industry and wishes to develop their skills in everyday maths. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career Path This bundle course is the ultimate package training certification for those who are interested in a career in property. On successful completion, you will have the opportunity to work in a wide range of related industries, in roles such as: Lettings Negotiator Lettings Agent Manager Estate Agent or Lettings Manager Course Curriculum **Letting Agent** Lettings Management Introduction to Lettings Management 00:20:00 Necessary Documents for Lettings Management 01:30:00 Lettings Agency Agreements Guideline 00:15:00 Types of Agents 00:15:00 Knowing Your Clients 00:30:00 Lettings Management Agent Services 00:20:00 Property Valuation 00:30:00 Property Negotiation 00:30:00 Property Management 00:30:00 Lettings Management Laws 00:30:00 Letting Agent Code of Practice Introduction to Letting Agent Code of Practice 00:20:00 Overarching Standards of Practice 00:30:00 Lettings 00:30:00 Management and Maintenance 00:20:00 Ending the Tenancy and Communications & Resolving Complaints 00:15:00 Arrangements 00:15:00 Being a Lettings Negotiator Home Loans 00:15:00 Knowing When You're Ready To Buy 00:15:00 Is Your Lake Home For Sale? 01:00:00 Legal System & Lettings Management UK An Introduction to the UK legal system 00:15:00 Different Types of Investment Structures 00:15:00 Title & Registration 00:15:00 Finance in Lettings Management 00:15:00 Investment Purchase Procedure 00:15:00 Acquisition Costs 00:15:00 Land Usage 00:15:00 Planning & Environment 00:15:00 Investment Structure & Key Legislations 00:15:00 **Functional Skills (Maths)** Integers ( Directed Numbers) Lecture 1 Introduction 00:02:00 Lecture 2 Multiplying any digit number by 11, 22, and 33 00:09:00 Lecture 3 Integers and ordering of integers 00:06:00 Lecture 4 Addition and Subtractions of Integers 00:07:00 Lecture 5 Operations on Integers 00:04:00 Lecture 6 Multiplication and Division of Integers 00:04:00 Lecture 7 Powers of Integers (Exponents) 00:04:00 Factors and Multiples Lecture 8 Complete knowledge about factors and multiples 00:06:00 Lecture 9 Divisibility tests for 2,3,4,5,6 00:07:00 Lecture 10 Divisibility rules 7,8,9,10,11 00:06:00 Lecture 11 Prime Factorization 00:06:00 Lecture 12 Highest Common Factor HCF 00:10:00 Lecture 13 Least Common Multiple LCM 00:16:00 Lecture 14 Relation between LCM and HCF 00:04:00 Fractions Lecture 15 Classification of Fractions 00:04:00 Lecture 16 Convert mixed to improper and improper to mixed fractions 00:03:00 Lecture 17 Equivalent Fraction 00:04:00 Lecture 18 Comparing Fractions after converting to like fractions 00:09:00 Lecture 19 Reducing a fraction to lowest term 00:04:00 Lecture 20 Addition and subtraction OF fractions 00:08:00 Lecture 21 Multiplication and division of fractions 00:11:00 Lecture 22 Word problems on fractions 00:16:00 Simplification Rule : BODMAS Lecture 23 BODMAS and rules to remove brackets 00:03:00 Lecture 24 Simplify expressions using BODMAS rules 00:05:00 Lecture 25 Simplify expressions involving fractions using BODMAS 00:07:00 Decimal numbers Lecture 26 Decimal numbers in relation to fractions 00:08:00 Lecture 27 Like and unlike Decimals 00:05:00 Lecture 28 Ordering of Decimal numbers 00:10:00 Lecture 29 Addition and subtraction of Decimal 00:07:00 Lecture 30 Multiplication of Decimal 00:03:00 Lecture 31 Division of Decimal 00:05:00 Rational Numbers Lecture 32 Rational number 00:02:00 Lecture 33 Representation of Rational Numbers on Number line 00:04:00 Lecture 34 Determining which fraction is terminating or non terminating 00:05:00 Lecture 35 shortcut method of writing decimal expansion of fraction to decimal 00:08:00 Approximation Lecture 36 Rounding to whole number 00:06:00 Lecture 37 Rounding to required number of decimals (1 d.p. ) 00:05:00 Lecture 38 rounding to significant digits 00:07:00 Lecture 39 Practice question on three methods of approximation 00:05:00 Estimation and Scientific Notation or Standard form Lecture 40 Estimation 00:05:00 Lecture 41 Scientific Notation 00:07:00 Lecture 42 Operation on numbers when they are in scientific notation 00:06:00 Percentage Lecture 43 Percentage to fraction and fraction to percentage 00:06:00 Lecture 44 Percentage of a quantity and conversation to decimal 00:06:00 Lecture 45 Expressing one quantity as percentage of another quantity 00:06:00 Lecture 46 Finding increase decrease percent 00:05:00 Lecture 47 Uses of percentages-Word Problems 00:09:00 Ratio and Proportion Lecture 48 Ratio- How to express as simple ratio 00:09:00 Lecture 49 How to compare Ratios 00:04:00 Lecture 50 Word problems on finding ratios 00:07:00 Lecture 51 To divide a given quantity into a given Ratio 00:11:00 Lecture 52 Proportion 00:04:00 Lecture 53 Practice problems on Proportion 00:06:00 Lecture 54 Continued proportion 00:06:00 Unitary Method and its Applications Lecture 55 Direct Variation ( or proportion) 00:04:00 Lecture 56 Problems based on Direct proportion 00:10:00 Lecture 57 Inverse Variation ( or proportion) 00:10:00 Lecture 58 Multiple Ratios 00:10:00 Profit , Loss, discount and Tax Lecture 59 Basics - Profit and Loss 00:04:00 Lecture 60 More practice problems on Profit & Loss 00:06:00 Lecture 61 Selling price formula and Problems 00:04:00 Lecture 62 Cost price formula and Problems 00:03:00 Lecture 63 Higher problems on Profit and Loss 00:08:00 Lecture 64 Basics - Discount 00:05:00 Lecture 65 Practice problems on Discount 00:04:00 Lecture 66 Tax 00:06:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Letting Agent and Functional Skills (Maths) Training Course
Delivered Online On Demand18 hours 1 minutes
£11.99

Bitcoin and Cryptocurrency Course

4.3(43)

By John Academy

Description Over the last couple of years, cryptocurrency has rapidly gained ground and perception of its use and value in the public sight. Cryptocurrencies based on a skilful and impressive modern technology called Blockchain. Bitcoin was the first cryptocurrency, and hundreds of cryptocurrency are available on the market now. Funding in cryptocurrency can make you a lot of money, but it also appears with high risk to deal. In this Bitcoin and Cryptocurrency Course, you will discover when and why your investment in Bitcoin and Cryptocurrencies can be a dangerous investment. With the help of this course, you will learn how to invest safely and responsibly for making money without taking any extreme risk. 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 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. 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 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 : Bitcoin and Cryptocurrency: Don't Believe the Bitcoin Hype 00:07:00 The Greatest Investor in the World on Cryptocurrency 00:06:00 The Problem with Bitcoin 00:05:00 The Risk of Hacking 00:04:00 Speculating (i.e. Gambling) vs Investing Why It Cannot Be Valued 00:08:00 Why It Violates Fundamental Investing Principles 00:07:00 What Supply and Demand Have to Say 00:05:00 Value Investing Made Simple Safety of Principal and an Adequate Return 00:14:00 Introducing 'Mr. Market' 00:09:00 Holistic Investment Analysis 00:16:00 The Margin of Safety Principle 00:13:00 Benefits of the Technology How to benefit from Blockchain Technology 00:07:00 What Does History Tell Us? 00:08:00 Where Do We Go From Here? 00:05:00 Conclusion Conclusion : Bitcoin and Cryptocurrency: Don't Believe the Bitcoin Hype 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Bitcoin and Cryptocurrency Course
Delivered Online On Demand1 hour 58 minutes
£12

Cryptocurrency Trading and ICO Investment Diploma

4.3(43)

By John Academy

Description Are you looking for Cryptocurrency trading? Do you want to learn how to deal with bitcoin? You can see our Cryptocurrency Trading and ICO Investment Diploma course for getting an elaborate description. Cryptocurrency is a virtual medium of exchange that uses cryptography to validate transaction besides to control the production of new units. The course teaches you the process of bitcoin and its activities. It gives you an approximate idea about the rise, function, and near future of it and clears your quest in terms of how they are considered as business capital. The course enables you to draw back a picture to distinguish between the ICO and the bitcoin and their contact in regulation toward virtual currency. It also gives you a clear notion of how it works as an influential virtual exchange medium. 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? Cryptocurrency Trading and ICO Investment Diploma 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 Cryptocurrency Trading and ICO Investment 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 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 Promo FREE 00:01:00 About Jonny Fry & Team Blockchain 00:04:00 What you will learn on this course 00:02:00 Initial Coin Offerings (ICOs) What is an ICO? 00:02:00 Evolution of ICOs & Recent History 00:04:00 Growth of ICOs in 2017 00:03:00 What Alternatives Are There There to Raise Money? 00:03:00 Start The Difference between ICOs and Traditional Fundraising 00:03:00 How you might launch your own cryptocurrency 00:06:00 Where Is the tangible value in Cryptocurrency? 00:04:00 The Process of Doing an ICO Quoted Companies Looking at ICOs 00:04:00 What Makes a Successful ICO? 00:04:00 Other Watch-Outs 00:07:00 Regulation 00:07:00 Alternative Uses for ICOs 00:06:00 Investing in ICOs How Do You Invest? 00:10:00 Next Steps The Future of ICOs 00:06:00 5.B 00:04:00 Further Steps 00:04:00 Extra Resources 00:02:00 5.C (opensesame) 00:01:00 Conclusion 00:02:00 Assessment Assignment - Cryptocurrency Trading and ICO Investment Diploma 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Cryptocurrency Trading and ICO Investment Diploma
Delivered Online On Demand1 hour 29 minutes
£11.99

Xero Accounting and Bookkeeping

By Course Cloud

Xero Accounting and Bookkeeping Course Overview For maintaining bookkeeping accuracy, Xero is one of the most reliable software. Businesses pay a substantial amount to employees who are well equipped with Xero bookkeeping skills. This comprehensive Xero Accounting and Bookkeeping course is designed to help you master essential financial skills and simplify business operations. Whether you’re a business owner, freelancer, or aspiring bookkeeper, this course will equip you with practical knowledge of Xero software to handle accounting tasks efficiently. Each lesson is crafted to provide actionable knowledge, with real-world examples and step-by-step demonstrations ensuring you grasp the concepts with ease. By the end of the course, you’ll not only understand Xero inside out but also earn an industry-recognized certification that highlights your expertise. Take control of your financial future today—master Xero and transform your accounting game! Learning Outcome Set up and customize Xero for your business needs. Manage bank accounts, invoices, bills, and financial transactions efficiently. Generate insightful financial reports and interpret them. Automate recurring invoices and bills to save time. Understand VAT settings and complete both manual and digital filings. Handle payroll tasks, including employee setup and salary payments. Track fixed assets and manage depreciation seamlessly. Why Choose Xero Accounting and Bookkeeping Course Affordable Package Expert Guidance Comprehensive Curriculum Practical Learning 24/7 Flexible Access CPD Accredited Certification Who is this Xero Accounting and Bookkeeping Course for? This course is ideal for small business owners who want to take control of their finances without relying on external help. It also suits accounting professionals aiming to enhance their skills and stay updated with modern tools. Beginners interested in starting a career in accounting or bookkeeping will find the course easy to follow and highly practical. Additionally, freelancers looking to expand their services and offer bookkeeping support to clients can greatly benefit from the knowledge and techniques covered. Career Path Completing this Xero Accounting and Bookkeeping​ course opens up several exciting career opportunities in the accounting and finance sector. You can pursue roles such as: Bookkeeper: £18,000 to £35,000 per year Accounts Assistant: £21,000 to £28,000 per year Payroll Administrator: £22,000 to £50,000 per year Accounting Technician: £17,000 to £34,000 per year Management Accountant: £24,000 to £60,000 per year

Xero Accounting and Bookkeeping
Delivered Online On Demand1 hour
£5.99

Sage 50 Accounts Training

4.5(3)

By Studyhub UK

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Sage 50 Accounts Training Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Sage 50 Accounts Training Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Sage 50 Accounts Training Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Sage 50 Accounts Training Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Sage 50 Accounts Training? 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 Sage 50 Accounts Training 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 Sage 50 Accounts Training course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Sage 50 Accounts Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Sage 50 Accounts Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Sage 50 Accounts Training is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Sage 50 Accounts Training Sage 50 Bookkeeper - Coursebook 00:00:00 Introduction and TASK 1 00:17:00 TASK 2 Setting up the System 00:23:00 TASK 3 a Setting up Customers and Suppliers 00:17:00 TASK 3 b Creating Projects 00:05:00 TASK 3 c Supplier Invoice and Credit Note 00:13:00 TASK 3 d Customer Invoice and Credit Note 00:11:00 TASK 4 Fixed Assets 00:08:00 TASK 5 a and b Bank Payment and Transfer 00:31:00 TASK 5 c and d Supplier and Customer Payments and DD STO 00:18:00 TASK 6 Petty Cash 00:11:00 TASK 7 a Bank Reconnciliation Current Account 00:17:00 TASK 7 b Bank Reconciliation Petty Cash 00:09:00 TASK 7 c Reconciliation of Credit Card Account 00:16:00 TASK 8 Aged Reports 00:14:00 TASK 9 a Payroll 00:07:00 TASK 9 b Payroll 00:10:00 TASK 10 Value Added Tax - Vat Return 00:12:00 Task 11 Entering opening balances on Sage 50 00:13:00 TASK 12 a Year end journals - Depre journal 00:05:00 TASK 12 b Prepayment and Deferred Income Journals 00:08:00 TASK 13 a Budget 00:05:00 TASK 13 b Intro to Cash flow and Sage Report Design 00:08:00 TASK 13 c Preparation of Accountants Report & correcting Errors (1) 00:10:00

Sage 50 Accounts Training
Delivered Online On Demand4 hours 48 minutes
£10.99

Microsoft Excel 2019 - Advanced Level Training

By Compete High

🌟 Unlock the Full Power of Microsoft Excel 2019! 🌟 Ready to take your Excel skills to the next level? Dive into our comprehensive online course - 'Microsoft Excel 2019 - Advanced Level Training' - designed to transform you into an Excel maestro! 🚀 Here's What You'll Master: 📊 Section 1: Excel - Advanced - Get hands-on with advanced techniques and shortcuts to streamline your workflow. 📂 Section 2: Working with Multiple Workbooks - Seamlessly manage multiple workbooks and boost your productivity effortlessly. 🔒 Section 3: Protecting Worksheets and Workbooks - Learn how to safeguard your data with robust protection strategies. 📝 Section 4: Conditional Formulas - Unravel the power of conditional logic and unleash the true potential of formulas. 🧮 Section 5: Advanced Functions - Elevate your Excel expertise by mastering complex functions for data analysis. 📚 Section 6: Text Based Functions - Manipulate text effortlessly and efficiently with advanced text-based functions. 🔍 Section 7: What IF Tools - Explore the 'What If' analysis tools to make informed decisions and predictions. 🏁 Section 8: Excel Advanced - Conclusion - Wrap up with a comprehensive understanding and practical application of advanced Excel features. 🎁 Section 9: Bonus #1 - Advanced Pivot Tables - Delve into bonus content covering advanced techniques for Pivot Tables, a must-have skill for data analysis pros. 🌟 Why Choose Our Course? 🔐 Expert Guidance: Led by seasoned Excel professionals, ensuring clarity and depth in learning. 🔄 Practical Assignments: Apply your newfound skills through real-world exercises. 📈 Career Growth: Elevate your career prospects by mastering sought-after Excel abilities. 🌐 Accessible Learning: Study at your own pace from anywhere, anytime with our user-friendly online platform. 🤝 Join our vibrant community of learners dedicated to mastering Excel's advanced functionalities. 💡 Enroll now and revolutionize your Excel prowess with 'Microsoft Excel 2019 - Advanced Level Training'! Don't miss this chance to become an Excel wizard! 💡   Course Curriculum Section 1 - Excel - Advanced Excel Advanced Introduction 01:39 Advanced Shortcut Keys 02:58 Section 2 - Working with Multiple Workbooks Tracing Precedents 00:00 Tracing Dependants 00:00 Watch Window 00:00 Show Formulas 00:00 Section 3 - Protecting Worksheets and Workbooks Protecting Cells in a Worksheet 00:00 Protecting the Workbook Structure 00:00 Encryption with Passwords 00:00 Section 4 - Conditional Formulas Name Ranges 00:00 Simple IF Function 00:00 IF, AND 00:00 IF, OR 00:00 Nested Formulas 00:00 CountIF and CountIFs 00:00 SumIF and SumIFs 00:00 Section 5 - Advanced Functions Advanced VLookUp 00:00 IF and IS Error - Part 1 00:00 IF and IS Error - Part 2 00:00 Advanced Index Match 00:00 Dates - Part 1 00:00 Dates - Part 2 00:00 Replace and Substitute - Part 1 00:00 Replace and Substitute - Part 2 00:00 Section 6 - Text Based Functions Left, Right and Mid Function 00:00 Search Function 00:00 Concatenate and Search 00:00 Indirect - Static 00:00 Indirect - Dynamic 00:00 Section 7 - What IF Tools Goal Seek 00:00 Data Tables 00:00 Scenarios 00:00 Solver 00:00 Section 8 - Excel Advanced - Conclusion Excel Advanced - Conclusion 00:00 Section 9 - Bonus # 1 - Advanced Pivot Tables Building a Mini Dashboard 00:00

Microsoft Excel 2019 - Advanced Level Training
Delivered Online On Demand2 hours 34 minutes
£25

Microsoft Excel Beginner to Intermediate

By Compete High

Overview   With the ever-increasing demand for MS Excel in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in MS Excel may be.   Learning about MS Excel or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in MS Excel. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on MS Excel is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by compete high in this Microsoft Excel Beginner to Intermediate course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Microsoft Excel Beginner to Intermediate course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Microsoft Excel Beginner to Intermediate course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of MS Excel, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in MS Excel, Anyone looking for a certificate of completion on doing an online training on this topic, Students of MS Excel, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Microsoft Excel Beginner to Intermediate course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Module 01-Excel Interface Module 01-Excel Interface 00:00 Module-02-Basic Functions Module-02-Basic Functions 00:00 Module-03-Working With Worksheet Module 03-Working With Worksheet 00:00 Module-04-Work with Data and Excel tables Module-04-Work with Data and Excel tables 00:00 Module-05-Basic Calculations Module-05-Basic Calculations 00:00 Module-06-Shortcuts in Excels Module-06-Shortcuts in Excels 00:00

Microsoft Excel Beginner to Intermediate
Delivered Online On Demand6 hours
£25

Microsoft Excel 2019 - Beginner Level Training

By Compete High

🌟 Unlock the Power of Excel 2019! 🌟 Are you ready to master Microsoft Excel 2019 and elevate your skills to new heights? Introducing our comprehensive online course: 'Microsoft Excel 2019 - Beginner Level Training.' 🚀 Dive into Excel's World-Class Features 🚀 📚 Section 1 - Excel Beginner Get started with a solid foundation. Learn the interface, navigation, and essential tools to kickstart your Excel journey. 📊 Section 2 - Excel Fundamentals Discover the core functionalities of Excel 2019, from cells and formulas to tables and more. Lay the groundwork for proficient data manipulation. ️ Section 3 - Entering and Editing Text Master the art of inputting and refining text within Excel. Gain efficiency and accuracy in handling textual data. Section 4 - Basic Excel Functions Explore the fundamental functions that make Excel a powerhouse. From basic calculations to data analysis, unlock Excel's potential. 🔄 Section 5 - Modifying an Excel Worksheet Learn techniques to manage, organize, and customize worksheets effectively. Boost productivity and streamline your workflow. 🎨 Section 6 - Formatting Data Transform raw data into visually appealing, easy-to-read formats. Elevate your reports and presentations with polished data formatting skills. 🖼️ Section 7 - Images, Shapes, and Smart Art Enhance your spreadsheets with visuals! Master the incorporation of images, shapes, and smart art for impactful data representation. 🖨️ Section 8 - Printing in Excel Navigate the intricacies of printing in Excel. Optimize layouts and settings to produce professional-looking documents. 📑 Section 9 - Templates Harness the power of pre-designed templates. Learn how to utilize and customize templates for various Excel projects efficiently. 🎓 Section 10 - Excel Beginner - Conclusion Wrap up your journey with a comprehensive understanding of Excel's beginner level. Recap key takeaways and prepare to advance your skills further. 🔥 Join Now and Excel in Excel 2019! 🔥 👩‍💻 Whether you're a student, professional, or an Excel enthusiast, this course is your gateway to proficiency in Microsoft Excel 2019. Enroll today and unlock a world of possibilities with data manipulation, analysis, and presentation! 🌟 Don't miss this opportunity! Enroll now and empower yourself with Excel mastery! 🌟 Course Curriculum Section 1 - Excel Beginner Introduction 01:02 Section 2 - Excel Fundamentals Launching Excel 01:59 Start Up Screen 02:54 The Excel Interface 06:46 The Quick Access Toolbar 02:13 The Ribbon 04:43 Creating New Excel Workbooks 01:27 Saving Excel Files 02:22 Opening Excel Files 01:38 Beginner Shortcut Keys 01:37 Section 3 - Entering and Editing Text Entering Text 06:41 Working with Numbers 06:55 An Introduction to Dates 01:15 Find and Replace 04:10 Sorting Data 04:13 Working with Cell References 06:05 Relative Versus Absolute Cell Reference in Formulas 06:24 Understanding the Order of Operation 02:41 Section 4 - Basic Excel Functions The structure of an Excel Function 00:00 Working with the Sum Function 00:00 Working with Min and Max 00:00 Working with Averages 00:00 Working with Count and CountA 00:00 Section 5 - Modifying an Excel Worksheet Moving and Copying Data 00:00 Inserting and Deleting Rows and Columns 00:00 Changing the Width and Height of Cells 00:00 Hiding and Unhiding Rows, Columns and Sheets 00:00 Renaming Worksheets 00:00 Deleting Worksheets 00:00 Moving and Copying Worksheets 00:00 Section 6 - Formatting Data Adding Borders to Cells 00:00 Formatting Percentages 00:00 Merging and Centering Cells 00:00 A Quick look at Styles 00:00 Basic Conditional Formatting 00:00 Section 7 - Images, Shapes and Smart Art Inserting Images and Shapes 00:00 Working with SmartArt 00:00 Section 8 - Printing in Excel Print Preview 00:00 Margins, Scaling and Orientation 00:00 Printing 00:00 Section 9 - Templates Intro to Excel Templates 00:00 Opening an Existing Template 00:00 Creating a Custom Template 00:00 Section 10 - Excel Beginner - Conclusion Conclusion 00:00

Microsoft Excel 2019 - Beginner Level Training
Delivered Online On Demand2 hours 33 minutes
£25