771 Microsoft Excel courses in Glasgow delivered On Demand

Description Do you want to know the fundamental concepts of bonds including notes payable, bond payable, and liabilities along with its record procedure? Are you looking for any course regarding this topic? If so, look at our Accounting Bonds and Liabilities Training course. It will assist you in understanding all you need to know about this field. The course introduces you to different types of bond and their features and how to issue bonds according to par value, premium, and discount for the journal entry. It teaches you how to calculate different confusing present value in various effective ways using value table, Microsoft Excel functions, and algebra and formula. The course will enable you to identify the reasons of fluctuation of price value, know amortization tables for accurate transactions on a note payable bond. It also teaches you how to create a liability section of the balance sheet, differentiates between capital lease and operating lease, and solve the problems stepping back and thinking about the whole accounting phases. 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? Accounting Bonds and Liabilities Training 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 Accounting Bonds and Liabilities Training 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 00:08:00 PDF - 10 Bond & Note Payable Introduction 00:01:00 10 Bonds & Notes Payable Introduction 00:10:00 Accounting Comic Break 00:01:00 Bonds - Market Rate vs Contract Rate 2 Bonds Market Rate vs Contract Rate 00:01:00 PDF - 20 Bonds Issued at Par 00:01:00 20 Bond Issued at Par 00:06:00 PDF - 25 Bond Market Price vs Contract Rate 00:01:00 Excel Download 00:01:00 Worksheet - 20 Bond Issued at Par 00:06:00 Excel Download 00:01:00 Bonds Issued at Premium 3 Bonds Issued at Premium 00:01:00 PDF - 50 Bond Issued at Premium 00:08:00 50 Bond Issued at Premium 00:07:00 Excel Download 00:01:00 Worksheet - 50 Bond Issue at Premium 00:09:00 PDF - 60 Amortization Premium & Recording Interest 00:01:00 60 Premium Amortization & Interest 00:13:00 Excel Download 00:01:00 Worksheet - 55 Bond Premium and Interest Journal Entry 00:16:00 10 Multiple Choice Question - Long Term Liabilities 00:07:00 Accounting Comic Break 00:01:00 Bonds Issued at Discount 4 Bonds Issued at Discount 00:01:00 PDF - 30 Bonds Issued at Discount 00:01:00 PDF - 40 Amortizing Discount & Recording Interest 00:01:00 40 Issue bond at a discount%2C calculate%2C and record interest 00:26:00 Excel Download 00:01:00 Worksheet - 30 Bond Issued at Discount 00:09:00 Excel Download 00:01:00 Worksheet - 35 Bond Discount & Interest 00:18:00 Excel Download 00:01:00 Worksheet - 1400.10 Record issuance of bond at a discount amortiz 00:16:00 Worksheet - 1400.20 Record issuance of bond at a discount amortiz 00:16:00 Worksheet - 1400.40 Record issuance of bond at a premium amortize 00:16:00 Worksheet - 1400.50 Record issuance of bond at a premium amort. 00:14:00 20 Multiple Choice Question - Long Term Liabilities 00:04:00 Accounting Comic Break 00:01:00 Present Value - Bond Price 5 Present Value Bond Price 00:03:00 PDF - 70 Bond Present Value Formula 00:14:00 Excel Download 00:01:00 Worksheet - 70 Bond Present Value Formula 00:15:00 PDF - 80 Bond Present Value Tables 00:01:00 80 Bond Present Value Tablesy 00:14:00 Excel Download 00:01:00 Worksheet - 80 Bond Present Value Tables 00:11:00 Excel Download 00:01:00 Worksheet - 90 Bond Present Value Excel 00:20:00 30 Multiple Choice Question - Long Term Liabilities 00:07:00 Accounting Comic Break 00:01:00 Bond Retirement 6 Bond Retirement 00:01:00 PDF - 100 Bond Retirement 00:01:00 100 Bond Retirement 00:09:00 Excel Download 00:01:00 Worksheet - 100 Bond Retirement 00:12:00 40 Multiple Choice Question - Long Term Liabilities 00:07:00 Accounting Comic Break 00:01:00 Notes Payable Introduction 7 Notes Payable Introduction 00:01:00 PDF - 110 Notes Payable Introduction 00:01:00 110 Notes Payable Introduction 00:05:00 PDF - 120 Installment Note Journal Entry 00:01:00 Excel Download 00:01:00 50 Multiple Choice Question - Long Term Liabilities 00:05:00 Accounting Comic Break 00:01:00 Amortization Schedule - Notes Payable 8 Amortization Schedule Notes Payable 00:01:00 PDF - 130 Notes Payable Amortization 00:01:00 130 Amortization Schedule 00:12:00 PDF - 140 Notes Payable Interest Payments 00:01:00 140 Notes Payable Payments Journal Entry 00:07:00 Excel Download 00:01:00 Worksheet - 130 Note Payable Amortization 00:15:00 Excel Download 00:01:00 Worksheet - 140 Note payable interest payments 00:10:00 60 Multiple Choice Question - Long Term Liabilities 00:06:00 Accounting Comic Break 00:01:00 Notes Payable Adjusting Entries 9 Notes Payable Adjusting Entries 00:01:00 PDF - 150 Adjusting Entry - Notes Payable 00:01:00 150 Notes Payable Adjusting Entry 00:10:00 Excel Download 00:01:00 Worksheet - 150 Note Payable Adjusting Entry 1 00:07:00 Excel Download 00:01:00 Worksheet - 160 Note Payable Adjusting Entry 2 00:06:00 70 Multiple Choice Question - Long Term Liabilities 00:07:00 Accounting Comic Break 00:01:00 Financial Statements - Long Term Liabilities 10 Financial Statements Long Term Liabilities 00:01:00 PDF - 170 Liabilities - Current vs Non Current 00:01:00 170 Notes Payable Current vs. Non Current 00:18:00 Excel Download 00:01:00 Worksheet - 170 FS St LT One Loan 1 TB Account 00:09:00 Excel Download 00:01:00 Worksheet - 180 FS St LT Loan 1 loan 2 TB Accounts 00:08:00 Excel Download 00:01:00 Worksheet - 190 FS ST LT 2 loans 1 TB account 00:08:00 Excel Download 00:01:00 Worksheet - 200 FS ST LT 2 Loans 1 ST 1 LT TB account 00:09:00 Excel Download 00:01:00 Worksheet - 210 FS ST LT 2 Loans 2 Loan Account TB 00:08:00 Excel Download 00:01:00 Worksheet - 220 FS 2 Loans 4 Accounts TB 00:11:00 80 Multiple Choice Question - Long Term Liabilities 00:07:00 Accounting Comic Break 00:01:00 Bond Characteristics and Types 11 Bond Characteristics and Types 00:01:00 PDF - 230 Bond types 00:01:00 230 Bond Characteristics 00:02:00 90 Multiple Choice Question - Long Term Liabilities 00:05:00 Short Calculation 00:08:00 Accounting Comic Break 00:01:00 Effective Method - Amortization Bond Discount & Premium 12 Effective Method Amortization Bond Discount & Premium 00:01:00 PDF - 230 Effective Interest Discount Amortization 00:01:00 235 Discount Amortization Effective Method 00:13:00 Excel Download 00:01:00 Worksheet - 230 Effective Interest Discount Amortization 00:17:00 Excel Download 00:01:00 Worksheet - 240 Effective Interest Premium Amortization 00:13:00 100 Multiple Choice Question - Long Term Liabilities 00:10:00 Leases - Operating vs. Capital 13 Leases Operating vs. Capital 00:01:00 PDF - 250 Leases 00:01:00 250 Leases Capital vs. Operating 00:12:00 Accounting Comic Break 00:01:00 Comprehensive Problem 14 Comprehensive Problem 00:01:00 Excel Download 00:01:00 1 Accounting%2C Financial - Comp Prob Service Co 1 Part 1 00:15:00 2 Accounting%2C Financial - Comp Prob Service Co 1 Part 2 00:15:00 3 Accounting%2C Financial - Comp Prob Service Co 1 Part 3 00:15:00 4 Accounting%2C Financial - Comp Prob Service Co 1 Part 4_2 00:22:00 6 Comp Prob Service Co 1 Adjusting Entries part 6 00:20:00 Definitions & Key Terms 15 Definitions & Key Terms 00:01:00 Annuity Definition - What is Annuity 00:05:00 Bond Definition - What is Bond 00:06:00 Book Value of Bonds - What is Book Value of Bonds 00:06:00 Carrying Value of Bonds Definition - What is Carrying Value 00:05:00 Lease Definition - What is a Lease 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Practical Excel training that will turn you into a certified Excel master About course Become a master of Excel Learn how to use the crucial Excel functions and tools. Learn from the experts The course is conducted by an Excel specialist with many years of experience. Test your knowledge In the course, you will find tests and practical tasks to consolidate your knowledge and skills. Do you want to master Excel quickly and efficiently? We offer you a unique opportunity to learn all the features of Excel in just a couple of days. The course is purely practical and will teach you the most useful tools included in the app. Whether you do data modeling, work on databases or analysis and reporting, this practical course will show you how to speed up and improve the quality of your work in each of these areas. Through the course, you will have few knowledge repetitions, practical tasks and tests that will help you remember all the information and put into practice the skills you have learned. The training offers access to the training videos and reference materials for an unlimited period. You’ll learn from our Excel expert with many years of experience in the field who will explain every issue step by step and will teach you how to perform your tasks with confidence. This course is available through a multimedia Kemp Center platform. You will learn from the comfort of your own home and at your own pace. You can always stop, return or return to any topic. On top of everything, after completion of the course, you will receive certificate confirming your skills. Join the Excel course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Lewis Hardin Excel expert The Excel course is conducted by an MS Excel expert and trainer. He specializes in financial modeling and data analysis. He can’t imagine life without Excel and till now, he created and implemented dozens of business tools based on this program. Participants of his trainings appreciate him for his pragmatic approach, lightness of message, and an offbeat sense of humor. He is able to convey any issue in an accessible and understandable way. Overview of the course: The Excel course program: I. Module 1 – Editing Basic issues Excel applications; navigating in the program; naming; toolbar; formula behavior; special paste; moving and copying without disturbing file consistency; areas; relative and absolute references; keyboard shortcuts. Editing and formatting Fonts; borders; text layout; wrapping; merging; formats (text, number, currency, accounting, dates and times, percentage, scientific, special); conditional formatting; table formatting; width and height, auto-fit. Graphic and special elements Pictures; shapes; icons; 3D models; SmartArt; text boxes; equations; symbols; headings; comments. II. Module 2 – Analysis and modeling Create charts and tables Charts: column (bar); line; area; statistical; pie; doughnut; scatter; bubble; combination charts. Special charts: cascade; funnel; stock; surface; radar; maps; spark lines; PivotCharts. Filters (Slicer and Timeline): PivotTables and Plain Tables. Use formulas Rules for working on formulas. Review and application of formulas. Formulas: financial; temporal; mathematical and statistical; search; database; text; logical; IT; compliance; networking. Working on data (databases) Sort; filter; retrieve and transform data; import and export data; queries and connections; text as columns; instant fill; remove duplicates; data validation; consolidation; what-if analysis; forecast worksheet; outline (grouping and what-if analysis). III. Module 3 – Review, view and print Review and data protection Checking: spelling; thesaurus; workbook statistics. Accessibility settings; smart search; translator; comments and notes; protect worksheet; ink. View, printing and formats View: sheet views; page break preview; page layout and custom views; show grid view; formula bar and headings; zoom; arrange windows; freeze panes; enter macros. Printing: print area; page settings; margin settings; sheet adjustment. File formats and saving. IV. Module 4 – Advanced issues Advanced features Work with other apps Tools and plugins for professionals V. Tests Tests and repetitions of acquired knowledge The acquired knowledge will be consolidated and checked through tests after each training module. Tests improve the acquisition of knowledge and improve the attention and engagement throughout the training. Final test After completing the final test at the end of the Excel course, you will get certified. VI. Tasks Practical tasks and exercises Each participant of the Excel course will practice the acquired skills. In this way, the participant will assimilate skills for longer and adapt them to his/her style of operation. After completing the tasks and receiving feedback from our experts, the new skills will be fully acquired not only on an intellectual level but also on a practical level. VII. Bonus materials for the course Additional materials for use in everyday workAfter logging in, you will receive additional materials for use in everyday work. You will receive: short keyboards; a list of the best Excel plugins and tricks to improve work and many more. Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor: If you want to become an Excel master, don’t waste your time on boring and ineffective training courses that will teach you only the theory. We have a better solution for you: We are pleased to invite you to the most practical course that will teach you how to use Excel in practice. And guess what? You will master all the features of Excel program within just a couple of days.You will learn how to work dynamically and flawlessly. Data analysis, database manipulation, creating statements and reports won’t be a problem for you anymore. You will learn everything in the shortest possible time and you’ll master the use of the most important and useful functions. You will work on sheets taken from the real life and perform activities independently. In this way you will acquire the ability to use the program at an expert level.Join us today! Learn with us and surprise everyone with your knowledge of Excel! Learning Excel with us is so interesting and never boring. Learn from the best and become one of themLewis HardinExcel course expert 

Enrol in this Nonprofit Training Courses for Staff, Boards, and Volunteers bundle and earn free certificates in 21 subjects, including Grant Writing, Fundraising, Charity Accounting, Bid Writing, Digital Marketing, Ethical Leadership, Team Management Skills, and many more!

. 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).

  The innovative Excel Data Analysis for Beginner has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector.  This popular Excel Data Analysis for Beginner has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique Excel Data Analysis for Beginner course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The Excel Data Analysis for Beginner is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the Excel Data Analysis for Beginner consists of a range of educational modules that allow study sessions to be organised at any time and any place When the final assessment of the Excel Data Analysis for Beginner has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the Excel Data Analysis for Beginner course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the Excel Data Analysis for Beginner has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at. Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.

The comprehensive Excel Sheet Comparison with VBA has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Excel Sheet Comparison with VBA today, and learn from the very best the industry has to offer! This best selling Excel Sheet Comparison with VBA has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Excel Sheet Comparison with VBA is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Excel Sheet Comparison with VBA is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Excel Sheet Comparison with VBA is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Excel Sheet Comparison with VBA, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Excel Sheet Comparison with VBA will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Excel Sheet Comparison with VBA to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The innovative Excel spreadsheet Level 3 has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector. This popular Excel spreadsheet Level 3 has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique Excel spreadsheet Level 3 course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The Excel spreadsheet Level 3 is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the Excel spreadsheet Level 3 consists of a range of educational modules that allow study sessions to be organised at any time and any place When the final assessment of the Excel spreadsheet Level 3 has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the Excel spreadsheet Level 3 course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the Excel spreadsheet Level 3 has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at. Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.

Course Overview Use Microsoft's benchmark business application to its full potential by taking this Advanced Excel Analytics by Real World Projects course. Using expert guidance, the contents will familiarise you with the broad range of functionalities on Excel, empowering you to deliver enhanced information analysis and accurate conclusions more effectively across an organisation. This progressive Excel learning experience will teach you how to download and manipulate complex data patterns and any collection of figures or statistics. You will become intuitively aware of how to arrange this for visual and investigative purposes. The coaching delivers a masterclass for core competencies that will take you from being a regular analyst to a sought-after Excel expert in all forms of data presentations. Make your mark in Microsoft skills and take your office abilities to the next level. This best selling Advanced Excel Analytics by Real World Projects has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced Excel Analytics by Real World Projects is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Advanced Excel Analytics by Real World Projects is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Advanced Excel Analytics by Real World Projects is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Advanced Excel Analytics by Real World Projects, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Advanced Excel Analytics by Real World Projects will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Advanced Excel Analytics by Real World Projects to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The innovative Diploma in Excel Vlookup Xlookup Match and Index has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector.  This popular Diploma in Excel Vlookup Xlookup Match and Index has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique Diploma in Excel Vlookup Xlookup Match and Index course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The Diploma in Excel Vlookup Xlookup Match and Index is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the Diploma in Excel Vlookup Xlookup Match and Index consists of a range of educational modules that allow study sessions to be organised at any time and any place When the final assessment of the Diploma in Excel Vlookup Xlookup Match and Index has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the Diploma in Excel Vlookup Xlookup Match and Index course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the Diploma in Excel Vlookup Xlookup Match and Index has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at. Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.

This Microsoft Power BI course will help you become a Power BI expert. It'll enhance your skills by offering you comprehensive knowledge on Power BI Desktop and Power BI Online, and unleash the capabilities of Power BI to perform a comprehensive analysis of data from multiple sources and present the data using the perfect visualization.