3200 Accounting & Finance courses in Garforth delivered Online

Overview: Diploma in Investment Are you ready to unlock the secrets of successful investing and pave your way to financial prosperity? Introducing our comprehensive 'Diploma in Investment' program, meticulously crafted to provide you with the knowledge and skills needed to navigate the complex world of investments. This diploma is your passport to understanding stocks, bonds, real estate, and alternative assets, empowering you to make informed and strategic investment decisions.   Module 1: Introduction to Investment and Understanding Stocks Dive into the fundamentals of investing, gaining a solid foundation in investment principles and exploring the dynamic world of stocks. Learn how to analyze stocks, interpret market trends, and make informed decisions that set the stage for a successful investment journey.   Module 2: Investing in Bonds and Investing in Real Estate Unlock the potential of fixed-income securities as you delve into the realm of bonds. Understand how bonds work, their various types, and how to integrate them into your investment portfolio. Simultaneously, explore the lucrative world of real estate investment, discovering strategies to identify profitable opportunities in the property market.   Module 3: Investing in Stocks and Investing in Bonds Refine your understanding of stocks, delving deeper into advanced strategies for stock selection and portfolio management. Simultaneously, revisit the bond market, gaining insights into advanced bond investing techniques that will elevate your investment acumen.   Module 4: Investing in Real Estate and Investing in Alternative Assets Expand your investment horizons by exploring the intricacies of real estate investment in more detail. Additionally, venture into the exciting realm of alternative assets, such as cryptocurrencies, commodities, and more. Learn how to diversify your portfolio intelligently and strategically.   Key Features: Expert-Led Learning: Benefit from the knowledge of industry experts and seasoned investors who will guide you through each module. Practical Application: Apply theoretical concepts through real-world case studies, ensuring you can confidently apply your knowledge in actual investment scenarios. Interactive Learning: Engage in discussions, webinars, and practical exercises that foster a dynamic and interactive learning experience. Comprehensive Materials: Receive comprehensive course materials, including guides, tutorials, and reference materials that serve as valuable resources even beyond the course completion. Networking Opportunities: Connect with like-minded individuals and industry professionals, expanding your network within the investment community.   Enroll now in the 'Diploma in Investment' program and embark on a journey towards financial mastery. Elevate your investment strategy, mitigate risks, and maximize returns with this indispensable diploma. Don't just invest; invest intelligently! Course Curriculum Module 1_ Introduction to Investment and Understanding Stocks Introduction to Investment and Understanding Stocks.docx 00:00 Module 2_ Investing in Bonds and Investing in Real Estate Investing in Bonds and Investing in Real Estate 00:00 Module 3_ Investing in Stocks and Investing in Bonds Investing in Stocks and Investing in Bonds.docx 00:00 Module 4_ Investing in Real Estate and Investing in Alternative Assets Investing in Real Estate and Investing in Alternative Assets.docx 00:00

🌟 Unlock Financial Mastery with 'Mastering Precision in Bookkeeping with QuickBooks' 🌟 Are you ready to revolutionize your bookkeeping skills and take control of your financial success? Look no further! Introducing our exclusive online course: 'Mastering Precision in Bookkeeping with QuickBooks.'   🚀 Why Choose This Course? ✅ Comprehensive QuickBooks Training: Dive deep into the world of QuickBooks with our expert-led modules. From the basics to advanced features, you'll master every aspect of this powerful accounting tool. ✅ Precision in Bookkeeping: Learn the art of precision in bookkeeping-because accuracy is key. Our course will guide you through best practices, ensuring your financial records are flawless and audit-ready. ✅ Hands-On Learning: Gain practical experience through hands-on exercises and real-world scenarios. Apply your knowledge in a simulated environment, so you're ready to handle any bookkeeping challenge. ✅ Time-Saving Techniques: Discover time-saving tips and tricks to streamline your bookkeeping process. Boost your efficiency without compromising accuracy, allowing you to focus on growing your business. ✅ Expert Guidance: Our instructors are seasoned professionals with extensive experience in bookkeeping and QuickBooks. Benefit from their insights, tips, and personalized feedback throughout the course. ✅ Flexible Learning: Access the course anytime, anywhere. Whether you're a busy entrepreneur or a student, our flexible schedule allows you to learn at your own pace. ✅ Lifetime Access: Enjoy lifetime access to the course material and updates. Stay current with the latest QuickBooks features and industry trends, ensuring your skills are always in demand.   📚 What You'll Learn: QuickBooks Fundamentals: Master the basics of QuickBooks, from setting up your account to navigating the interface with ease. Advanced Features: Explore advanced QuickBooks features to enhance your bookkeeping capabilities and automate repetitive tasks. Financial Statement Mastery: Learn to create accurate financial statements that provide valuable insights into your business's financial health. Troubleshooting and Error Resolution: Develop the skills to identify and resolve common QuickBooks issues, ensuring data integrity. Custom Reporting: Customize reports to meet your business's unique needs, empowering you with actionable financial information.   🎓 Who Should Enroll: Small Business Owners Entrepreneurs Accounting Professionals Students pursuing a career in finance or accounting   🌈 Bonuses: Exclusive QuickBooks shortcuts guide Access to a private community for networking and support Q&A sessions with industry experts   Ready to elevate your bookkeeping game and become a QuickBooks pro? Enroll now in 'Mastering Precision in Bookkeeping with QuickBooks' and take the first step toward financial mastery!   Course Curriculum Basic Overview 00:00 AAA-Advisors-Attorneys-Accounts 00:00 Plans and Pricing 00:00 Advantages of The Cloud Based Version 00:00 Purchase of QB Online (Cloud) 00:00 a Basics of QB Set Up 00:00 b Basics of QB Set Up - Part 2 00:00 c Basics of QB Set Up - Part 3 00:00 Installation of Mobile App 00:00 Mileage Tracking 00:00 Entering Sales By Desktop 00:00 Entering Sales By Mobile 00:00 Entering Expenses Paid In Desktop 00:00 Entering Expenses Paid on Mobile 00:00 Capturing Reciepts 00:00 Organizing Reciepts 00:00 Entering Customers 00:00 Entering Invoices Sent To Customers 00:00 Entering Invoices Paid By Customers 00:00 Entering Invoices Sent By Vendors 00:00 Entering Invoices Paid To Vendors 00:00 Conclusion 00:00 Advanced Overview 00:00 Customer Refunds 00:00 Issuing Customer Credits 00:00 Vendor Refunds to You 00:00 Vendor Credits Issued to You 00:00 Deposits and Withdrawals 00:00 Working with 1099 Contractors 00:00 Purchase of Inventory 00:00 Purchasing Inventory 00:00 Accounting for Inventory Sold 00:00 Sending Estimates 00:00 Cash Account Fees - Part 1 00:00 Cash Account Feeds 00:00 Editing Feed Transactions 00:00 Recurring Transactions 00:00 Tracking Sales Taxes 00:00 Collecting Sales Taxes on Invoices 00:00 Paypal Transactions 00:00 Basic Reports 00:00 Basic Reports 00:00 Conclusion 00:00

🎉 Master the Art of Tax Preparation with TurboTax Online - Satisfying Uncle Sam! 🎉 Are you ready to conquer tax season like a pro and confidently navigate the intricate world of taxes? Look no further than our comprehensive online course - 'Tax Preparation with TurboTax Online - Satisfying Uncle Sam!'   Unlock the secrets to seamless tax preparation and gain expertise in maximizing your returns while minimizing stress. With TurboTax Online as your ultimate tool, this course is your ticket to a hassle-free tax season. What you'll gain from this course: 📚 In-depth guidance: Learn the ins and outs of TurboTax Online from start to finish, making tax filing a breeze. 💡 Pro tips & tricks: Discover expert strategies and insider tips to optimize your deductions and credits, ensuring you get the most out of your return. 🔧 Practical hands-on experience: Navigate real-life tax scenarios with ease using TurboTax's step-by-step guidance and gain confidence in handling complex situations. 📈 Financial empowerment: Take control of your finances and build your confidence in managing your taxes independently, year after year. 🎓 Certification: Receive a certificate of completion, validating your newfound tax preparation skills.   Why choose our course? 🌟 Comprehensive curriculum: Developed by tax professionals, our curriculum covers everything you need to know about using TurboTax Online effectively. 🔒 Convenience & accessibility: Access the course from anywhere, at any time, and at your own pace, ensuring a stress-free learning experience. 🤝 Supportive community: Join a community of learners, share insights, and get your questions answered by experts and fellow tax enthusiasts. 💰 Value for money: Invest in your financial well-being with a course that provides lifelong skills at an affordable price. Don't let tax season overwhelm you! Empower yourself with the knowledge and skills to conquer your taxes confidently and efficiently. Course Curriculum Module 1-Let's Get Caught Up On Anything That's Changed In Turbotax Let's Get Caught Up On Anything That's Changed In Turbotax 00:00 Module 2-Documents And Info You'll Need In Turbotax Documents And Info You'll Need In Turbotax 00:00 Module 3-Review Qbse Business Income And Expenses Before Import To Turbotax Review Qbse Business Income And Expenses Before Import To Turbotax 00:00 Module 4-Checking Quickbooks Self-Employed Before Importing To Turbotax! Checking Quickbooks Self-Employed Before Importing To Turbotax! 00:00 Module 5-Submitting Quickbooks Self-Employed Business Transactions To Turbotax Submitting Quickbooks Self-Employed Business Transactions To Turbotax 00:00 Module 6-Turbotax Vs Turbotax Live Self-Employed Turbotax Vs Turbotax Live Self-Employed 00:00

Revenue Operations course is designed to provide a comprehensive overview of revenue operations within an organization, as well as its benefits, importance, and the roles that they play in the above mentioned organization

Trade Gold with Confidence Course The Trade Gold with Confidence Course is designed to help you learn the basics of gold trading, even if you're just starting out. This course walks you through gold as a valuable asset, how trading works, and how gold fits into the stock market. You will also explore how to spot trends, avoid mistakes, and trade safely. By the end, you’ll feel more confident and ready to take on the gold market with smart, steady steps. Course Curriculum Module 01: Introduction to Gold Module 02: Basics of Trading Module 03: Stock Market Module 04: The Gold Trade Module 05: Gold Mining Stocks Assignment (Learn more about this online course)

Did you know that the average project manager in the UK earns £55,000 per year? But to earn that kind of salary, you need to have the skills to manage projects effectively, including the financial aspects. Are you poised on the threshold of elevating your project management game? Then, delve deep into a world where finance meets project execution. We've curated a premium Finance for Project Managers bundle that seamlessly marries the key tenets of finance with core project management principles. Presenting: "Finance for Project Managers". This bundle comprises a compendium of eight meticulously designed courses: Course 1: Project Management Training Course 2: Project Management: How to Build a Project Charter Course 3: Cost Control & Project Scheduling Course 4: Finance Principles Course 5: Corporate Finance: Working Capital Management Course 6: Managerial Accounting Masterclass Course 7: Financial Analysis : Finance Reports Course 8: Finance: Financial Risk Management Each course is tailored to blend theoretical knowledge with holistic understanding, perfect for the aspiring or seasoned project manager keen on integrating financial prowess into their skill set. According to a recent survey, 90% of project managers believe that financial skills are essential for success. The average project manager spends 20% of their time on financial tasks. Project managers who have strong financial skills are more likely to deliver successful projects on time and within budget. So why wait? Click the 'enrol' button and start learning about the Finance for Project Managers bundle and start your journey to becoming a skilled financial individual! Learning Outcomes: Grasp the foundational principles of project management and finance. Understand the intricate process of building a project charter. Gain insights into effective cost control and project scheduling techniques. Deepen knowledge of working capital management and its impact. Master managerial accounting principles and their application in projects. Analyse financial reports to make informed project decisions. At the heart of every successful project lies a project manager who understands the nuances of both project execution and finance. This bundle begins with "Project Management Training", setting the foundational understanding of projects. As you delve deeper, "Project Management: How to Build a Project Charter" unravels the strategic process behind project initiation. But what's a project without timelines and budgets? "Cost Control & Project Scheduling" ensures you're on top of both. Dive into "Finance Principles" and "Corporate Finance: Working Capital Management" to immerse yourself in the world of capital, investments, and returns. "Managerial Accounting Masterclass" and "Financial Analysis: Finance Reports" equip every project manager with the analytical tools needed, and lastly, "Finance: Financial Risk Management" ensures that you're prepared for uncertainties, making your projects financially resilient. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring project managers aiming to enhance their financial knowledge. Current project managers seeking to improve project financial outcomes. Professionals in finance keen on transitioning to project-based roles. Business analysts aiming to integrate financial and project management insights. Consultants looking to offer comprehensive project advisory services. Career path Project Coordinator Assistant Project Manager Project Manager Senior Project Manager Financial Analyst (Project Management) Project Finance Manager Director of Project Management Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

The aim of this course is to provide learners with a comprehensive understanding of variable costing analysis and its applications in managerial accounting. The course will equip you with the necessary knowledge and skills to perform variable costing analysis and make informed decisions about pricing, product mix, and production volume.After the successful completion of the course, you will be able to learn about the following, Analysis of units manufactured. Analysis of variable and absorption costing. Contribution margin analysis. This course is designed to provide learners with a comprehensive understanding of variable costing analysis and its applications in managerial accounting. The course covers key topics such as variable and fixed costs, direct and indirect costs, contribution margin, and absorption costing. You will learn how to calculate and analyze variable and fixed costs, determine contribution margins, and use this information to make informed decisions about pricing, product mix, and production volume. This course is designed to provide learners with a thorough understanding of the principles and applications of variable costing in managerial accounting. The course will cover topics such as variable and fixed costs, direct and indirect costs, contribution margins, and absorption costing. Students will learn how to calculate and analyze variable and fixed costs, determine contribution margins, and use this information to make informed decisions about pricing, product mix, and production volume. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding Variable Costing Analysis Self-paced pre-recorded learning content on this topic. Understanding Variable Costing Analysis Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Financial Analyst Business Manager Operations Manager Management Accountant Financial Controller Cost Accountant Strategic Planner Chief Financial Officer (CFO) Budget Analyst Sales Manager. Investment Advisor Financial Planner Wealth Management Specialist Mutual Fund Manager Investment Analyst Portfolio Manager Financial Consultant Retirement Planning Specialist Investment Operations Specialist Securities Trader Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

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

Description: Microsoft Excel was created to become a useful program to help you become more efficient and effective in manipulating your data. This program is being used by almost all the professionals. You will know how to share workbooks, its advanced functions and formulas through this course. You will learn the importance of security setting when sharing workbooks with Macros. You will take advantage of the host of functions available in Excel to perform every type of calculation you can imagine. Who is the course for? Professionals who want to learn about Microsoft Office Excel Essentials 2013. People who have an interest in knowing all the features of Microsoft Excel 2013 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 you have successfully passed the test, 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 hard copy at a cost of £39 or in PDF format at a 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 Microsoft Excel Intermediate Level course is a useful qualification to possess and would be beneficial for any for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager Microsoft Excel - Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 00:30:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 00:30:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working With Macros 00:30:00 Module Seven - Working With Forms 00:30:00 Module Eight - Applying Advanced Chart Features 01:00:00 Module Nine - Working With Slicers and Timelines 00:30:00 Module Ten - Working With Multiple Tables, Relationships and External Data 00:30:00 Module Eleven - Working With PowerView 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities- Microsoft Excel - Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel - Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft Excel - Intermediate Level 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day basis. It is used to store and retrieve numerical data and it is ideal for entering, calculating and analysing company data such as sales figures, sales taxes or commissions. This Level 3 Diploma in Microsoft Excel 2016 is a course which will help you learn the various features incorporated in the software. This course has been specially designed to cover everything from the basic concepts to the advanced levels. This course allows you to take advantage of the online aspect of training by learning at your own pace. As long as you have access to an eligible device, such as a laptop, or smartphone, and an internet connection, you can access this Level 3 Diploma in Microsoft Excel 2016 from anywhere, and anytime. Learning Outcomes: Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time-dependent data Saving data in different formats and protecting reports Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Level 3 Diploma in Microsoft Excel 2016 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Level 3 Diploma in Microsoft Excel 2016 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 1 Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Module : 2 Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Module : 3 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Module : 4 Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Module : 5 Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00