5099 Courses delivered Online

In this course, you will explore the core principles of risk and risk management in the context of the financial services sector. This training programme will cover a wide range of topics, from the regulatory environment and risk identification to the three lines of defence model and the impact of risk on the broader business environment. By the end of this course, you’ll be equipped with the knowledge and skills necessary to navigate the complex world of financial risk management. This training programme will guide you through the intricacies of the financial services industry, providing real-world examples and practical insights. The course features a structured approach with end-of-chapter questions to test your understanding, ensuring that you’re well-prepared to tackle risk management challenges. Join us on this educational journey to enhance your understanding of risk management in financial services and to develop the expertise needed to thrive in this dynamic industry! Study method Online, self-paced Course format What's this? Reading material - PDF/e-book, slides, article/plain text Duration 15 hours Access to content 365 days Certification AGRC Certificate in ESG Principles and Standards Overview During the past several years, ESG has gained plenty of prominence throughout the corporate world as a growing number of organisations have started embracing its three pillars and setting up programmes targeting issues such as climate change, diversity, equity and inclusion, employee benefits, executive bonus structures, and more. Pressure from stakeholders, the upcoming generation of professionals and consumers, and society at large have made it a crucial part of any organisation’s strategy to look after their activities and performance in these areas. In many cases, these organisations’ growth, stability, and continuity as businesses are at stake. As part of this programme, you will pick up the ins and outs of ESG from a compliance and reporting perspective and be better prepared to help your organisation develop a sound, effective, and long-term strategy to tackle all ESG issues. Certification AGRC Certificate in ESG Principles and Standards Awarded by Association of Governance, Risk and Compliance Description The AGRC Certificate in ESG Principles and Standards provides participants with a thorough understanding of a topic that has gained increasing significance and attention amongst corporations, regulators, and researchers. At the same, the Certificate offers guidance as to how corporations can best prepare under the growing number of ESG-related regulations. Topics to be covered by this certificate include: The Stakeholder Theory Corporate Social Responsibility (CSR) vs. ESG Sustainability The Environment, Social and Governance Pillars Green Finance Principles of Responsible Banking, Investment, and Insurance The Business Case for CSR, ESG, and Sustainability Global Initiatives and Development such as The Paris Agreement, the European Green Deal, and the UK’s Green Finance Strategy ESG Reporting Standards and Frameworks ESG Investing Strategies The Push for ESG into the Future By acquiring the Certificate, participants will be able to: Define the three ESG pillars—Environment, Social and Governance. Identify the importance of ESG and CSR programmes to an organisation’s corporate governance practices. Understand the main concepts behind Green Finance and how responsible banking, investment, and insurance work within this framework. Describe the objectives and main tenets of the many global initiatives set up to encourage policies that will contribute to the growth and advancement of ESG issues. Study the main ESG reporting standards and frameworks so that your organisation is better prepared to fulfil its reporting requirements. Understand the main concepts behind ESG investing. Who is this course for? This course is ideal for anyone wishing to be introduced to ESG and the different requirements that this sector might entail moving forward. Professionals carrying out the roles of directors, members of the Board, senior managers, lawyers, company secretaries, compliance and risk officers, and consultants may benefit from this course. Requirements No previous knowledge or experience is required, although it is assumed that participants have good knowledge of English and a sound educational background.

Data modelling and visualisation skills are in demand! Create Interactive Reports and Dashboards.

This course sets out the legal and regulatory requirements for safety reporting in clinical trials of medicinal products under the jurisdictions of the European Union and the USA. It builds on the foundation laid by our companion course CT13, Safety Reporting in Clinical Trials, and provides greater detail of specific requirements in those jurisdictions.

"Start your career as a Certified Business Analyst and earn up to £70,000 per Year." Looking to land a lucrative Business Analyst role in the UK, where demand is skyrocketing with over 30,000 job postings annually? Our comprehensive Business Analyst Job Ready Program, a bundle of 5 career-focused courses, is your express ticket. With dedicated career support, a money-back guarantee, and a tailored roadmap to success, we empower you to navigate the thriving business analytics landscape confidently and secure your dream job. Our mission is simple - to be your trusted partner every step of the way, from training to employment as a Bussiness Analyst. In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Business Analysts, so we can help you get your foot in the door. If you are not happy with our service, we also offer a 100% money-back guarantee. So what are you waiting for? Enrol in our Business Analyst Job Ready Program today and start your journey to becoming a successful Business Analyst! If you have any questions, you can contact us. We will be happy to provide you with all the information you need. Who Choose Us? So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Business Analyst Job Ready Program: Personalised Guidance: Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some experience, we will guide you towards honing your skills and developing a strong foundation in Business Analysis. One-On-One Consultation Sessions with Experts: Gain invaluable insights and guidance from seasoned professionals who have thrived in the Business Analyst field. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and expertise. Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking Business analysts. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere. Our aim is to maximise your employment prospects and provide you with a range of exciting opportunities to choose from. Interview Preparation: We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress. Money-Back Guarantee: Your satisfaction is our top priority. We are confident in the quality of our training and support, which is why we offer a 100% money-back guarantee. Continuous Career Support: Our commitment doesn't end when you secure a job. We'll be there for you throughout your career journey, offering continued support and guidance. Whether you need advice on career advancement, assistance with new projects, or simply a friendly ear to share your achievements, we'll be your trusted partner for long-term success. Here are the courses we will provide once you enrol in the program: Course 01: Business Analysis Course 02: Business and Data Analytics for Beginners Course 03: Business Analytics for Beginners Using SASS Course 04: Financial Forecasting Model for New Business Course 05: Data Analysis and Forecasting in Excel Course 06: Supply Chain Management for Different Retail Formats Course 07: Customer Analytics Training Course 08: Fundamentals of Marketing Analytics Course 09: Supply Chain Masterclass in Retail Course 10: Business Productivity Training Course 11: Dealing With uncertainty: Make Budgets and Forecasts Course 12: Cashflow Management and Forecasting Course 13: Raising Money & Valuations Course 14: Cost Control & Project Scheduling Course 15: Mini MBA Course 16: Business Accounting Training Course 17: Financial Analysis: Finance Reports Course 18: Presenting Financial Information Course 19: Finance: Financial Risk Management Course 20: Financial Modelling Course - Learn Online How Can We Offer Job Guarantees? HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector. The Business Analyst Job Ready Program is completed in 9 easy steps: Step 1: Enrol in the Programme Begin your exciting journey with us by enrolling in the Business Analyst Job Ready Program. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied. After you enrol in the Program, you will get lifetime access to 6 premium courses related to Business Development. These courses will teach you the knowledge and skills required to become a successful Business Analyst. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about a thing! Step 2: Initial One-On-One Counselling Session Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path. Step 3: Certification upon Course Completion After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject. Step 4: CV Revamping Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the business development industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently. Step 5: Building Network and Submitting CV We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile. Step 6: Interview Preparation With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills. Step 7: Securing Job Interviews Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want. Step 8: Post-Interview Support Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job. Step 9: Celebrate Your New Job! Once you've secured your dream job in business analysis, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role. We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful career as Business Analyst starts with us. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Business Analyst Job Ready program is ideal for: Aspiring Business Analyst seeking comprehensive training and industry-specific career guidance. Individuals looking to transition into a data-based role and require personalised mentorship. Graduates wanting to enhance their employability with tailored CV building and interview preparation. Career changers looking for an all-in-one solution to securing a job in the finance industry. Data Analysis enthusiasts desiring to leverage industry connections for job opportunities in business development. Career path Junior Business Analyst: £30,000 - £40,000 Business Analyst: £40,000 - £55,000 Senior Business Analyst: £55,000 - £70,000 Lead Business Analyst: £70,000 - £85,000 Business Analyst Manager/Director: £85,000 - £100,000+ Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Framed (Hardcopy) Certificate Hard copy certificate - Included Enrolment Letter Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included Student ID Card Digital certificate - Included

Getting Started The QUALIFI Level 7 Diploma in Accounting and Finance is aimed at addressing the demands of senior/middle managers and accountants in the functioning of their businesses and encouraging them to progress to higher levels within their organisation. The role to be played by managers is very crucial. For instance, they need to be aware of the issues, analyse their potential results and decide how to react. It is optional that they need to be experts in all business sectors. The prime requirement is to have a general awareness of the existing facilities and services and find a way to carry out the roles. The Accounting and finance courses program incorporates current topics with advanced content, which reflects key issues within the 21st-century business environment and the recent developments in management research. The Diploma is credited at the postgraduate Level 7 with 120 credits. We provide access to a dissertation at one of our UK University partners for a related Master's Degree after completing the Diploma. Key Benefits   This qualification will benefit the learner: Understanding Ethical behaviour and corporate governance Analysing strategic Financial Management in the organisation Understanding the key concept of Strategic Auditing Analyse problem-solving techniques specific to business and industry To understand and apply the principles of accounting and finance in a business environment To understand and use the guidelines of corporate reporting   Key Highlights Are you passionate about holding a middle or senior-level position in accounting and finance and gaining knowledge in global financial management? Then, the QUALIFI Level 7 Diploma in Accounting and Finance is the ideal starting point for your career journey. We will ensure your access to the first-class education needed to achieve your goals and dreams and to maximise future opportunities. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our Qualifi-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The Qualifi Level 7 Level Diploma in Accounting and Finance can open many career pathways including, but not limited to: Finance Director, with an estimated average salary of £ 70,348 per annum Chief Financial Officer, with an estimated average salary of £50,512 per annum Cost Accountant Manager, with an estimated average salary of £48,052 per annum Senior Financial Analyst, with an estimated average salary of £46,060 per annum Compliance officer with an estimated average salary of £44,190 per annum International Tax Manager, with an estimated average salary of £42,972 per annum Assistant controller with an estimated average salary of £35,728 per annum   About Awarding Body QUALIFI, recognised by Ofqual awarding organisation has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Leadership, Hospitality & Catering, Health and Social Care, Enterprise and Management, Process Outsourcing and Public Services. They are liable for awarding organisations and thereby ensuring quality assurance in Wales and Northern Ireland. What is included?   Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, which include real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules. Multiplatform accessibility through an online learning platform. This facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only). Assessment Time-constrained scenario-based assignments No examinations Entry Requirements   The qualifications have been made available to all without artificial barriers denying access and progression. The primary requirement is to get through the interview, and they are expected to hold the following: Level 6 Qualification or First Degree We also accommodate managers with significant years of experience despite needing formal qualifications. The criteria for admission will be through an interview for those who can demonstrate the skills to cope with the demands of the course. There would be at least three years in an accounting and finance role. Progression   Learners completing the QUALIFI Level 7 Diploma in Accounting and Finance will progress to: The QUALIFI Level 8 Diploma in Strategic Management and Leadership, or A university partner to complete a dissertation to receive a full master's degree, then Directly into employment in an associated profession. With QUALIFI, the learners can progress to several Universities to pursue a Master's degree once they have completed a dissertation. The pathway indicates the learner's progress towards a UK University degree and is based on the University's review of QUALIFI's learning programs and outcomes. Further information is available here: http://www.QUALIFI.net/learning-pathways/   Why gain a QUALIFI Qualification?   This suite of qualifications provides enormous opportunities to learners seeking career and professional development. The highlighting factor of this qualification is that: The learners attain career path support who wish to pursue their career in their denominated sectors; It helps provide a deep understanding of the Accounting and Finance sector and managing the organisations, which will help enhance the learner's insight into their chosen sector. The qualification provides a real combination of disciplines and skills development opportunities. The Learners attain in-depth awareness concerning the organisation's functioning, aims and processes. They can also explore how to respond positively to this challenging and complex Accounting and Finance environment. The learners will be introduced to managing a wide range of Accounting and Finance functions using theory, practice sessions and models that provide valuable knowledge. As a part of this suite of qualifications, the learners will be able to explore and attain hands-on training and experience in this field. Learners also learn to face and solve issues then and there by exposure to all the Units. The qualification will also help to Apply scientific and evaluative methods to develop those skills. Find out threats and opportunities. Develop knowledge in managerial, organisational and environmental issues. Develop and empower critical thinking and innovativeness to handle issues and difficulties. Practice judgement, own and take responsibility for decisions and actions. Develop the capacity to perceive and reflect on individual learning and improve their social and other transferable aptitudes and skills.   Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Ethical Behaviour and Corporate Governance Reference No : AF704 Credit : 20 || TQT : 200 Ethical Behaviour and Corporate Governance unit reveal the sequential development and guideline of accounting and therefore the impact of accounting and finance on the environment, the varied stakeholders and on society. The learners will be equipped with the knowledge and skills essential to act as an adviser in reference to the governing authorities within the private, public and charitable sectors. UNIT2- Corporate Reporting Reference No : AF705 Credit : 20 || TQT : 200 "Corporate Reporting unit helps to assist learners within the preparation and interpretation of monetary statements for a group of companies where they're prepared in accordance with generally accepted accounting principles and to know and evaluate the key aspects of accounting theory. On completion of the unit learners are going to be ready to communicate complex numerical and qualitative information effectively and solve problems during a selective and important manner." UNIT3- Financial Analyst Reference No : AF706 Credit : 20 || TQT : 200 "The purpose of this unit is to develop understanding of market equilibrium models, bond valuation and performance evaluation. At the top of this unit learners should be encouraged to form enquiries as to the cause and effect of the impact of current developments within the world's capital markets on the investment process and critically appraise current thinking on the theories and investments. UNIT4- Strategy and Global Finance Reference No : AF701 Credit : 20 || TQT : 200 Strategy and Global Finance unit make the learner to exercise techniques and choose on decisions that add value in terms of finance supported sound theoretical concepts. additionally, the unit helps the learner to present and interpret financial information during a recognised format and to work independently to unravel the issues arising within the required time given. It also ensures that the learning is often applied to the practical context. UNIT5- Strategic Financial Management Reference No : AF702 Credit : 20 || TQT : 200 Strategic Financial Management unit is to develop learner ability to exercise the techniques and to form value added decisions in terms of corporate strategy and finance supported sound theoretical concepts. Further itenhances the contribution to the formulation of business strategy, creation of comprehensive business development plans, bringing together their specialist accounting and finance skills also as the strategic management learning of the unit UNIT6- Strategic Auditing Reference No : AF703 Credit : 20 || TQT : 200 Strategic Auditing unit helps to assist learners understand the power to settle on and apply suitable investigative techniques to a spread of situations that are simple and non-simple within the accounting environment.The unit explains in detail on the aims, objectives and methods of auditors and their contribution to the achievement of a real and fair view on the published accounts. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

This course will teach you how Selenium WebDriver is used to test web applications. You will start by understanding the concepts of Java and gradually move toward understanding Selenium, TestNG framework, Maven, Jenkins, Cucumber, Gherkin, and a lot more interesting topics that will make you a pro in automation testing.

Getting Started The qualification is for the learners who wish to pursue their career in the financial services industry, professional accountancy, banking and finance or management. The learner will understand the basics of specialised and contemporary approaches to accountancy and finance, practical and theoretical issues and the latest developments in accountancy and reporting. The Level 7 Diploma in Accounting and Finance qualification also allows learners to work toward a relevant master's programme with advanced standing. Key Benefits   All the important management theories and models are covered in this course. As a result, the students will gain a better understanding of the various management techniques that are applicable in the workplace. It will be helpful to the students to develop their problem-solving skills through the practical application of the various management models and theories. A nationally - recognised qualification, the credits earned at this course can be transferred to other courses if the students want to pursue an MBA or any other Master's. On completing the course, the students can demonstrate their proficiency in the various management practices, improving their chances of successful career progression. About Awarding Body OTHM is an established and recognised Awarding Organisation (Certification Body) launched in 2003. OTHM has already made a mark in the UK and global online education scenario by creating and maintaining a user-friendly and skill based learning environment. OTHM has both local and international recognition which aids OTHM graduates to enhance their employability skills as well as allowing them to join degree and/or Master top-up programmes. OTHM qualifications has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. What is included?   Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, which include real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules. Multiplatform accessibility through an online learning platform. This facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only). Assessment Time-constrained scenario-based assignments No examinations Entry Requirements   An honours degree in a related subject or a UK level 6 diploma or an equivalent overseas qualification Learners must be 18 years or older at the beginning of the course. Mature learners (over 21) with management experience International students whose first language is not English will need to have a score of 5.5 or above in IELTS (International English Language Testing System) Progression   Learners completing the OTHM Level 7 Diploma in Accounting and Finance will progress to: Master's top-up programmes at many universities in the UK and overseas with advanced standing or Directly into employment in an associated profession   Why gain a OTHM Qualification?   Quality, Standards and Recognitions- OTHM qualifications are approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation); hence, the learners can be very confident about the quality of the qualifications as well. Career Development to increase credibility with employers- All OTHM qualifications are developed to equip learners with the skills and knowledge every employer seeks. The learners pursuing an OTHM qualification will obtain an opportunity to enhance learning and grow key competencies to tackle situations and work on projects more effectively, which will, in turn, give learners the potential to get promotions within the workplace. Alternatively, it allows them to progress onto an MBA top-up/Bachelor's degree / Master's degree programme around the World. Flexible study options- All OTHM qualifications have a credit value, which tells you how many credits are awarded when a unit is completed. The credit value will indicate how long it will normally take you to prepare for a unit or qualification. Three different types of qualification are: The award is achieved with 1 - 12 credits The certificate is completed with 13 - 36 credits The diploma is completed with at least 37 credits The OTHM Level 7 Diploma in Accounting and Finance qualification consists of 6 mandatory units for a combined total of 120 credits, 1200 hours Total Qualification Time (TQT) and 600 Guided Learning Hours (GLH) for the completed qualification. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Investment Analysis Reference No : R/615/3236 Credit : 20 || TQT : 200 The unit focusing on understanding of investment theories and evaluate investment performance. After completion of the unit the earner will capable of analysing the worlds capital market. Learners will be able to make effective recommendations for future investments. UNIT2- Corporate Reporting Reference No : D/615/3241 Credit : 20 || TQT : 200 The unit aim the learner to make capable of prepare and interpret financial statements of business organizations. They are also gain the skills of apply relevant accounting concepts and principles. UNIT3- Global Finance and Strategy Reference No : D/615/3238 Credit : 20 || TQT : 200 He unit will help the learner to take the decision when entering global markets. They will also gain the skills to take independent solutions to solve financial issues. UNIT4- Strategic Financial Management Reference No : H/615/3242 Credit : 20 || TQT : 200 The unit aims to develop the planning and managing skilss in an orgaisation financial resources. The learners will understand the importance of increasing stake holders return. UNIT5- Strategic Audit Reference No : Y/615/3240 Credit : 20 || TQT : 200 The unit aims to develop the skills of how managers can plan and execute business strategy accordingly. This will provide a deep knowledge in strategic audit concepts. UNIT6- Business Research Methods Reference No : T/508/0626 Credit : 20 || TQT : 200 The unit will help the learner to understanding of research principles including the formulation of research proposals, , referencing, data collection using interviews and surveys, literature reviews ,questionnaire design, statistical analysing using SPSS, qualitative data, and methods for drawing conclusions from the analysed data. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Getting Started The program will involve learners to assess, challenge critically, and apply a wide variety of theories, methods, leadership models, and particular ideas, practices, and tools. By analysing and criticising domestic and international organisations, Learners will examine how the various features and disciplines influence the organisation's strategy, achievement and operation. The qualification also requires learners to show various abilities required by leadership at the executive level, including problem-solving and writing reports. Learners will develop their analytical and research skills, as well. The qualification will allow students to become autonomous and self-directed, with the instruments and motivation to continue to learn, develop and reflect on exercise throughout their careers. Key Benefits   This qualification will benefit the learner: Holistic study of organisational issues and the responsibility of executive management Global trade and its impact on the strategy of the organisation Dealing with the operations, quality and supply chain of the organisation Analyse problem-solving techniques specific to business and industry To understand and apply the principles of strategic management To gain knowledge about operations, quality and supply chain management   Key Highlights Are you striving to enrich your skills and knowledge and intend to study holistic organizational issues in management? Then, the QUALIFI Level 7 Diploma in Executive Management is the ideal starting point for your career journey. We will ensure your access to the first-class education needed to achieve your goals and dreams and to maximize future opportunities. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our Qualifi-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The Qualifi Level 7 Level Diploma in Executive Management can open many career pathways including, but not limited to: Chief operating officer with an estimated average salary of £90,000 per annum Chief executive officer with an estimated average salary of £85,000 per annum General manager with an estimated average salary of £78,725 per annum President of operations, with an estimated average salary of £10,000 per annum Executive Administrator, with an estimated average salary of £40,000 per annum Financial manager with an estimated average salary of £57,685 per annum Sales manager with an estimated average salary of £47,515 per annum   About Awarding Body QUALIFI, recognised by Ofqual awarding organisation has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Leadership, Hospitality & Catering, Health and Social Care, Enterprise and Management, Process Outsourcing and Public Services. They are liable for awarding organisations and thereby ensuring quality assurance in Wales and Northern Ireland. What is included?   Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, including real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules. Multiplatform accessibility through an online learning platform. This facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only) Assessment School of Business London will internally assess all units. The units are all determined by coursework assignments. Students must show that they meet each assessment criteria detailed within each unit to the required standard for the unit level. Entry Requirements Level 6 Qualification or equivalent First Degree or Considerable managerial experience Progression Learners completing the QUALIFI Level 7 Diploma in Executive Management can progress to:  QUALIFI Level 7 Stategic management and Leardership and Strategic Management and Innovation QUALIFI Level 8 Stategic management and Leardership Directly into employment in an associated profession, An appropriate dissertation only for a Master's Degree at one of our University partnerships. Why gain a QUALIFI Qualification?   This suite of qualifications provides enormous opportunities to learners seeking career and professional development. The highlighting factor of this qualification is that: The learners attain career path support who wish to pursue their career in their denominated sectors; It helps provide a deep understanding of the health and social care sector and managing the organisations, which will, in turn, help enhance the learner's insight into their chosen sector. The qualification provides a real combination of disciplines and skills development opportunities. The Learners attain in-depth awareness concerning the organisation's functioning, aims and processes. They can also explore how to respond positively to this challenging and complex health and social care environment. The learners will be introduced to managing the wide range of health and social care functions using theory, practice sessions and models that provide valuable knowledge. As a part of this suite of qualifications, the learners will be able to explore and attain hands-on training and experience in this field. Learners also learn to face and solve issues then and there through exposure to all the Units. The qualification will also help to Apply scientific and evaluative methods to develop those skills. Find out threats and opportunities. Develop knowledge in managerial, organisational and environmental issues. Develop and empower critical thinking and innovativeness to handle issues and difficulties. Practice judgement, own and take responsibility for decisions and actions. Develop the capacity to perceive and reflect on individual learning and improve their social and other transferable aptitudes and skills.   Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Corporate Strategy Reference No : EXE 1.1 Credit : 15 || TQT : 150 The unit corperate strategy help learner to understand when strategies applied to global marketplace, how global ethical issue effect corporate strategy. Also helps to study about the relationship between strategy and organistation. Also studies about how corporate strategy can be used in organisational function UNIT2- Corporate Finance and Financial Strategy Reference No : EXE 1.2 Credit : 15 || TQT : 150 This unit help learner to understand the interelation between corporate finanace and financial strategy. UNIT3- Human Resource Practice, Leadership and Management Reference No : EXE 1.3 Credit : 15 || TQT : 150 This Unit will help learner to improve their Human resource techniques in hiring personnel and training individuals for a career. Learner can also develop their leadership quality and improve managerial approaches an organisation UNIT4- Global Trade and its Impact on Strategy Reference No : EXE 1.4 Credit : 15 || TQT : 150 Global trade and its impact on straegy unit begins with the discussion of issues facing in the global relationship and management of different multinational organisation. UNIT5- Research, Problem Solving and Business Reporting Reference No : EXE 1.5 Credit : 15 || TQT : 150 This unit help learner to understand about the relavant methods and theories to solve business problems. Also study about the research methods using research evidence. UNIT6- Operations, Quality and Supply Chain Management Reference No : EXE 1.6 Credit : 15 || TQT : 150 This unit will help learner to understand how to manage operations, supply chain inside an organisation UNIT7- Strategic Marketing Reference No : QF708 Credit : 15 || TQT : 150 This unit help learner to effectively examine marketing problems and opportunities and develop successful marketing strategies. UNIT8- Project Management Reference No : EXE1.7 Credit : 15 || TQT : 150 This unit help learner to dvelop their skills in setting goals. Also helps to understand how successful projects are administered. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

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