856 Courses delivered Online

Description: Corel Quattro Pro X3 is a spreadsheet program; it is practically designed for storing, calculating and analyzing massive amount of data in an efficient way. In this {course_title] you will learn the basic concepts that revolves around this program. Spreadsheet applications are essential for running any office work. In this course, you will start off with an introduction in the basic functions and interactions with the program. After learning the basics, you will categorically move up through the hierarchy to advanced levels. This course will sharpen your skills and help you in the professional field. Learning Outcomes: Review common spreadsheet applications, opening and closing the spreadsheet application Creating a blank spreadsheet, entering, editing and deleting data Creating a spreadsheet from a template, saving it multiple times, changing default directory, opening and closing the program, and switching between open spreadsheets Utilizing the editing tools like select, undo, cut, copy, changing cell dimensions, sort and other related options Using zoom, showing and hiding toolbars, locking and unlocking rows and columns, changing basic options Inserting, naming, deleing, moving and copying worksheets Creating basic formulas, identifying errors, using cell referencing, advanced formulas and IF functions Formatting cells to include decimals, commas, date, currency, percentage; while also changing font size, type and adding effects More formatting options through quick format, text wrapping, aligning cell contents, centring titles, modifying cell orientation and applying borders and shading Creating a chart and changing its titles, background colour, and colour of other chart elements; also find out how to edit charts through the cut, copy, paste, resize, move and delete options Setting up worksheet by modifying margins, orientation, paper size and fitting the worksheet into a page How to prepare to print and carry out the printing job by creating header and footers and using print preview respectively, and explore many other related options Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Corel Quattro Pro X3 Application 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 Corel Quattro Pro X3 Application 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. Spreadsheet Basics Getting Started 01:00:00 Creating a Spreadsheet 00:15:00 Working with Files 01:00:00 Editing Tools Part 1 00:15:00 Editing Tools, Part 2 01:00:00 Viewing Tools 00:30:00 Working With Spreadsheets Working with Worksheets 00:15:00 Working With Formulas 00:30:00 Formatting Cells 00:15:00 Advanced Formatting 00:30:00 Advanced Spreadsheet Tasks Creating a Basic Chart 01:00:00 Editing Charts 00:15:00 Setting up the Worksheet 00:15:00 Preparing to Print 00:30:00 Printing the Worksheet 00:15:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on 50 Tips to Upgrade your Excel Skill will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This 50 Tips to Upgrade your Excel Skill comes with accredited certification which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this 50 Tips to Upgrade your Excel Skill. It is available to all students, of all academic backgrounds. Requirements Our 50 Tips to Upgrade your Excel Skill is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 7 sections • 52 lectures • 02:57:00 total length •Welcome: 00:02:00 •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 •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 •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 •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 •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 •Thank You: 00:01:00

Overview This comprehensive course on Excel Must know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Must know Formulas and Functions comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Must know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Excel Must know Formulas and Functions is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 13 lectures • 01:53:00 total length •Building basic math formulas: 00:08:00 •Autosum and Relative references: 00:09:00 •Absolute references: 00:06:00 •Named Ranges: 00:06:00 •Linking sheets and workbooks: 00:06:00 •If, And, Or, and the nested If functions: 00:16:00 •Countif, Sumif, Averageif, Sumifs, and Countifs functions: 00:09:00 •Vlookup and Hlookup functions: 00:15:00 •Match and Index functions: 00:07:00 •Date and time formulas and functions: 00:12:00 •Text functions: 00:11:00 •Tracing formulas: 00:08:00 •Assignment - Excel Must know Formulas and Functions: 00:00:00

Overview This comprehensive course on Excel spreadsheet for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel spreadsheet for Beginner comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel spreadsheet for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel spreadsheet for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 14 lectures • 01:29:00 total length •Tour of the Excel screen: 00:10:00 •Entering Data: 00:13:00 •Autofill Speedfill: 00:09:00 •Saving the file: 00:02:00 •Autosum: 00:04:00 •Formula Basics: 00:11:00 •Copying formulas - Relative Formulas: 00:04:00 •Totals and Averages: 00:04:00 •Formatting the Spreadsheet: 00:07:00 •Managing the Sheets: 00:06:00 •Copying formulas - absolute formulas: 00:08:00 •Linking the Sheets together: 00:06:00 •Introduction to Functions: 00:05:00 •Assignment - Excel spreadsheet for Beginner: 00:00:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Overview This Excel spreadsheet for Beginner course will unlock your full potential and will show you how to excel in a career in Excel spreadsheet for Beginner. So upskill now and reach your full potential. Everything you need to get started in Excel spreadsheet for Beginner is available in this course. Learning and progressing are the hallmarks of personal development. This Excel spreadsheet for Beginner will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Mental Health skills to help you advance your career. Acquire a comprehensive understanding of various Mental Health topics and tips from industry experts. Learn in-demand Mental Health skills that are in high demand among UK employers, which will help you to kickstart your career. This Excel spreadsheet for Beginner course covers everything you must know to stand against the tough competition in the Excel spreadsheet for Beginner field.  The future is truly yours to seize with this Excel spreadsheet for Beginner. Enrol today and complete the course to achieve a Excel spreadsheet for Beginner certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Excel spreadsheet for Beginner course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Excel spreadsheet for Beginner course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Excel spreadsheet for Beginner course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Excel spreadsheet for Beginner is suitable for anyone aspiring to start a career in Excel spreadsheet for Beginner; even if you are new to this and have no prior knowledge on Excel spreadsheet for Beginner, this course is going to be very easy for you to understand.  And if you are already working in the Excel spreadsheet for Beginner field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Excel spreadsheet for Beginner course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Excel spreadsheet for Beginner course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Excel spreadsheet for Beginner course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Excel spreadsheet for Beginner course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Excel spreadsheet for Beginner Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00 Assignment Assignment - Excel spreadsheet for Beginner 00:00:00

Course overview Take your data analysis skills to the next level with this Excel Data Analysis Diploma course. This course ensures you're practiced in the data analysis tools to analyze data effortlessly and effectively.  Data analysis is imperative to get meaningful information from data. It helps businesses and organizations make informed decisions. This Excel Data Analysis Diploma course will introduce you to the built-in tools in Excel through which you can analyze data and get your desired results to make better business decisions. It will give you real insights into tracing formulas, Excel scenario manager and data tables. You will learn how to use the forecast sheet to better forecast and identify the advantages of Excel solver and goal seek. You will also discover the most used Excel formulas, such as SUMIF, COUNTIF and Nested IF.  Learning outcomes Familiarize yourself with the data analysis tools Learn about tracing formulas in Excel Deepen your understanding of Excel goal seek Learn how to use the scenario manager in Excel Understand solver add-in and how to use it Have a better grasp of the most used Excel formulas Who is this course for? The comprehensive Excel Data Analysis Diploma course is incredibly beneficial for aspiring professionals who want to learn how to use the built-in tools in Excel for effective data analysis. The program will provide learners with in-demand knowledge and skills, allowing them to take advantage of outstanding employment opportunities. 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 Excel Data Analysis Diploma course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst Accountants Financial Analyst Excel Data Analysis Diploma Excel data analysis - 1 00:04:00 Excel data analysis - 2 00:07:00 Excel data analysis - 3 00:03:00 Excel data analysis - 4 00:03:00 Excel data analysis - 5 00:11:00 Excel data analysis - 6 00:16:00 Excel data analysis - 7 00:02:00 Excel data analysis - 8 00:09:00 Excel data analysis - 9 00:16:00 Resource Resource - Excel Data Analysis Diploma 00:00:00 Assignment Assignment - Excel Data Analysis for Beginner 03:00:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Unlock the power of Excel like never before with our 'Excel Add-in with C# VSTO and Web' course. This innovative curriculum fuses the potential of Excel with the dynamic capabilities of C# and the web. Grasp the foundational elements of VSTO and deepen your understanding through extensive modules. Transition smoothly to the vast arena of web basics, bridging the gap between spreadsheet functionalities and online applications. Experience a synthesis of software development and data management in one cohesive learning journey. Learning Outcomes Understand the integration of Excel and C# through VSTO. Grasp foundational concepts and advanced features of VSTO. Gain knowledge on how to create powerful Excel add-ins. Delve into the essential principles of web applications in relation to Excel. Harness the potential of merging Excel with the web for enhanced functionality. Why choose this Excel Add-in with C# VSTO and Web course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Excel Add-in with C# VSTO and Web Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Excel Add-in with C# VSTO and Web course for? Developers keen on integrating Excel functionalities into applications. Data analysts aiming to amplify their Excel capabilities. IT professionals aspiring to combine web applications with Excel. Excel enthusiasts curious about the crossover with C# and web. University students pursuing a career in software development with a focus on Excel add-ins. Career path Excel VSTO Developer: £30,000 - £55,000 Web Application Engineer: £25,000 - £50,000 Data Integration Specialist: £35,000 - £60,000 C# Developer with Excel Focus: £32,000 - £58,000 IT Consultant Specialising in Office Integrations: £40,000 - £70,000 Data Analytics Manager: £45,000 - £80,000 Prerequisites This Excel Add-in with C# VSTO and Web does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel Add-in with C# VSTO and Web 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Introduction 00:03:00 VSTO basics Basic interactions 00:07:00 Advanced interactions 00:21:00 More on Vsto Multiple sheets 00:07:00 Charts 00:07:00 Web Basics Preparation and single cell input/output 00:23:00 Working with multiple cells 00:15:00

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

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 Excel 2016 Advanced Formulas and Functions 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 Excel 2016 Advanced Formulas and Functions Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Excel 2016 Advanced Formulas and Functions 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 Excel 2016 Advanced Formulas and Functions 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 Excel 2016 Advanced Formulas and Functions? 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 Excel 2016 Advanced Formulas and Functions 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 Excel 2016 Advanced Formulas and Functions 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 Excel 2016 Advanced Formulas and Functions does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel 2016 Advanced Formulas and Functions 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 Excel 2016 Advanced Formulas and Functions is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Advanced Functions Work with Ranges 00:18:00 Use Specialized Functions 00:12:00 Work with Logical Functions 00:24:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:06:00 Watch and Evaluate Formulas 00:09:00 Automating Workbook Functionality Search for Invalid Data and Formulas with Errors 00:04:00 Troubleshoot Invalid Data and Formula Errors 00:08:00 Other Functions and Formulas Use Text Functions 00:34:00 Use Specialized Functions 00:44:00 Use Date Functions 00:12:00 Use Financial Functions 00:26:00 Automate SUM Functions 00:36:00