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

6449 Finance courses

Microsoft Office 2010 Excel Intermediate - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2010 Excel Intermediate - Complete Video Course builds on the skills and concepts taught in Excel 2010: Basic. You will learn how to use multiple worksheets and workbooks efficiently, and you will start working with more advanced formatting options including styles, themes, and backgrounds, create informative, eye-catching charts and harness the power of Excel's data analysis and filtering tools, how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. You will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. In addition, you'll find out how easy it is to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by adding time-saving functions to your repertoire. 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? Microsoft Office 2010 Excel Intermediate - Complete Video Course 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 Microsoft Office 2010 Excel Intermediate - Complete Video Course 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. Using Multiple Worksheets and Workbooks Using Multiple Workbooks 00:05:00 Linking Worksheets with 3-D Formulas 00:05:00 Linking Workbooks 00:09:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:10:00 Using Functions to Format Text 00:09:00 Working with Styles 00:08:00 Working with Themes 00:07:00 Other Advanced Formatting 00:17:00 Outlining and Subtotals Outlining and Consolidating Data 00:13:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:14:00 Managing Names 00:07:00 Tables Sorting and Filtering Data 00:09:00 Advanced Filtering 00:08:00 Working with Tables 00:10:00 Web and Sharing Features Saving Workbooks as Web Pages 00:05:00 Using Hyperlinks 00:06:00 Sharing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:05:00 Combination Charts 00:08:00 Graphical Elements 00:11:00 Documenting and Auditing Auditing Features 00:05:00 Comments in Cells and Workbooks 00:04:00 Protection 00:08:00 Workgroup Collaboration 00:09:00 Templates and Settings Application Settings 00:08:00 Built-in Templates 00:04:00 Creating and Managing Templates 00:05:00 PivotTables and PivotCharts Working with PivotTables 00:14:00 Rearranging PivotTables 00:06:00 Formatting PivotTables 00:03:00 Using PivotCharts 00:04:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2010 Excel Intermediate - Complete Video Course
Delivered Online On Demand4 hours 49 minutes
£22

Anti Money Laundering(AML), Know Your Client (KYC) and Risk Management Certification

By Compliance Central

Are you looking to enhance your AML, KYC and Risk Management skills? If yes, then you have come to the right place. Our comprehensive course on AML, KYC and Risk Management will assist you in producing the best possible outcome by mastering the AML, KYC and Risk Management skills. The AML, KYC and Risk Management is for those who want to be successful. In the AML, KYC and Risk Management, you will learn the essential knowledge needed to become well versed in AML, KYC and Risk Management. Our AML, KYC and Risk Management starts with the basics of AML, KYC and Risk Management and gradually progresses towards advanced topics. Therefore, each lesson of this AML, KYC and Risk Management is intuitive and easy to understand. Why would you choose the AML, KYC and Risk Management from Compliance Central: Lifetime access to AML, KYC and Risk Management course materials Full tutor support is available from Monday to Friday with the AML, KYC and Risk Management Learn AML, KYC and Risk Management skills at your own pace from the comfort of your home Gain a complete understanding of AML, KYC and Risk Management Accessible, informative AML, KYC and Risk Management learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the AML, KYC and Risk Management bundle Study AML, KYC and Risk Management in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your AML, KYC and Risk Management Curriculum Breakdown Diploma in Anti Money Laundering (AML) Module 01: Introduction to Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Development of Anti-Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Officer Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: Awareness and Training KYC Module 01: Introduction to KYC Module 02: Customer Due Diligence Module 03: AML (Anti-Money Laundering) Module 04: KYC, AML, and Data Privacy Regulations for Businesses Operations in the United Kingdom Module 05: Regulations to be Complied by Industries Module 06: Methods for carrying out KYC and AML and the Future of KYC Compliance Risk Management Process Module 01: Introduction to Risk Management. Module 02: Risk Management Process. Module 03: Benefits of Risk Management. Module 04: Enterprise Risk Management. Module 05: Managing Financial Risks. Module 06: Managing Technology Risks. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The AML, KYC and Risk Management helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in AML, KYC and Risk Management. It is also great for professionals who are already working in AML, KYC and Risk Management and want to get promoted at work. Requirements To enrol in this AML, KYC and Risk Management, all you need is a basic understanding of the English Language and an internet connection. Career path The AML, KYC and Risk Management will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to AML, KYC and Risk Management. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99

Anti Money Laundering(AML), Know Your Client (KYC) and Risk Management Certification
Delivered Online On Demand7 hours
£12

Microsoft Office 2013 Excel Intermediate - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2013 Excel Intermediate - Complete Video Course covers the intermediate functions and features of Excel 2013. You will learn about creating formulas, inserting graphics and enhancing workbooks. You will also learn how to organize worksheet data with tables and charts and how to analyze data using PivotTables, Slicers and PivotCharts. In this course creating advanced formulas, you will learn how to apply range names and how to use specialized functions. Once you are comfortable with the basics, you will be ready for this intermediate level. Here, you will explore more advanced formatting with terms, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas and applying conditional formatting to your worksheet, and more. If you want to take your Microsoft Excel 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch. 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? Microsoft Office 2013 Excel Intermediate - Complete Video Course 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 Microsoft Office 2013 Excel Intermediate - Complete Video Course 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. Creating Advanced Formulas Apply Range Names FREE 00:18:00 Use Specialized Functions 00:14:00 Analyzing Data with Logical and Lookup Functions Leverage Questions and Testing to Write Formulas 00:01:00 Use Logical and Lookup Functions to Find Answers to Questions 00:25:00 Organizing Worksheet Data with Tables Create and Modify Tables 00:09:00 Sort and Filter Data 00:27:00 Use Summary and Database Functions to Calculate Data 00:25:00 Visualizing Data with Charts Create Charts 00:05:00 Modify and Format Charts 00:25:00 Create a Trendline 00:10:00 Create Advanced Charts 00:09:00 Analyzing Data with PivotTables, Slicers, and PivotCharts Create a PivotTable 00:24:00 Filter Data by Using Slicers 00:09:00 Analyze Data by Using PivotCharts 00:07:00 Inserting Graphics Insert and Modify Graphic Objects 00:10:00 Layer and Group Graphic Objects 00:12:00 Incorporate SmartArt 00:06:00 Enhancing Workbooks Customizing Workbooks 00:08:00 Manage Themes 00:06:00 Create and Use Templates 00:06:00 Protect Files 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2013 Excel Intermediate - Complete Video Course
Delivered Online On Demand5 hours 4 minutes
£22

Getting Started Fast-track your journey to becoming a transformative leader through the MBA Advanced Entry route. This route is designed to expedite your progress towards impactful leadership roles. An MBA is a significant milestone for senior managers and aspiring directors, as it combines essential theoretical knowledge with practical skills needed to lead teams and achieve tangible results effectively. Typically pursued after gaining several years of professional experience, an MBA offers numerous benefits, such as enhanced career prospects, a high professional reputation, and an expanded business network. The programme provides access to a global network, a diverse student community, promising career opportunities, and a rigorous academic curriculum. The MBA Advanced Entry route is tailored for individuals with relevant hands-on management experience, a recognised Postgraduate Diploma (PgD) in management, or a comparable qualification. The programme is designed for individuals aspiring to advance their careers in senior management.  It comprises two key components: the Research Methods module and the Consultancy Project Report. The Research Methods module begins with Induction and Research Methods webinars, allowing students to finalise their project research proposals. On the other hand, the Consultancy Project Report module offers an opportunity to explore a specific area of interest within an organisational context. The module emphasises independent thought, continuous learning, and critical reflection. Students must produce a Consultancy Project Report that provides a practical and realistic solution to a strategic business challenge supported by theoretical and conceptual analysis. The MBA Advanced Entry is delivered by the London Graduate School and awarded by the University of Buckingham. School of Business and Technology London partners with the London Graduate School to promote this programme. Throughout the programme, students receive support from the academic team, including a dedicated supervisor to guide them through the Consultancy Project Report module. The MBA Advanced Entry route typically takes 6 to 9 months to complete. Upon successful completion, students are awarded the degree of Master of Business Administration from the University of Buckingham. They also have the option to attend the graduation ceremony held in the UK, commemorating their achievements. The programme aims to provide students with comprehensive support and valuable opportunities for personal and professional growth, ensuring they make the most of their investment in their future. About Awarding Body Buckingham is unique. It is the only independent University in the UK with a Royal Charter and probably the smallest, with around 2,700 students (approx 1,600 on campus). The University campus is well known for being one of the most attractive locations in the region. The Great Ouse River, home to much wildlife, winds through the heart of campus. Each student mixes with over 100 other different nationalities, so being at Buckingham is just like being in a mini global village. These contacts, acquaintances and friendships carry on long after life at Buckingham is over. Ranked Top 10 for Student Satisfaction Ranked Top 10 for Graduate Prospect Recognised by World Education Services (WES) OTHM Qualifications are approved and regulated by Ofqual (Office of Qualifications and Examinations Regulation) and recognised by Qualifications Wales. OTHM qualifications have achieved a reputation for maintaining significant skills in various job roles and industries like Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. OTHM serves the progression option with several UK universities that acknowledges the ability of learners after studying Level 3-7 qualifications to be considered for advanced entry into corresponding degree year/top-up and Master's/top-up programmes. Regulated by ofqual.gov.uk Recognised by World Education Services (WES) Assessment Assignments and Projects No Examinations Entry Requirements To be eligible for the MBA Advanced Entry route, you must meet the following criteria: OTHM Level 7 Diploma in Strategic Management and Leadership A Bachelor's degree or an equivalent higher qualification. Submission of a copy of your valid photo ID to verify your identity. A well-crafted Statement of Purpose outlining your motivations, career aspirations, and reasons for pursuing the MBA Advanced Entry route. An updated Curriculum Vitae (CV) demonstrating a minimum of two years of work experience at the graduate level, either in a managerial or professional capacity. By meeting these application requirements, you will take the initial steps towards joining the MBA Advanced Entry programme, enabling you to enhance your managerial and leadership skills significantly. English Requirements A pass in English at the A level. Completion of a Bachelor's degree programme conducted and assessed in English. An overall score of 6.5 or higher in the International English Language Testing System (IELTS) with a minimum score of 6.0 in each component. A Test of English as a Foreign Language (TOEFL) score of 72 or higher, with a minimum of 18 in reading, 17 in listening, 20 in speaking, and 17 in writing. This includes scores from the Home Edition of TOEFL. In addition to the requirements above, all applicants must participate in a live virtual interview with a staff member from the London Graduate School. Progression An MBA graduate can pursue a fruitful career in many industries. MBA can open career opportunities in various sectors such as banking and financial services, investment banking, management consulting, insurance, hospitality, media, information technology (IT) and marketing. An MBA is often a pathway to promotion or a career change as you will gain a professional reputation and develop essential skills in the sector you choose to pursue. 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. Structure MBA Advanced Entry Programme Structure Research Methods Consultancy Project Report Delivery Methods The MBA Advanced Entry delivered by London Graduate School, awarded by the University of Buckingham through distance learning. You will receive excellent support from academic team of London Graduate School, including your programme manager and your supervisor who will be with you every step of the way. 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.

MBA (Advanced Entry)
Delivered OnlineFlexible Dates
Price on Enquiry

Know Your Client (KYC)

5.0(1)

By LearnDrive UK

Master the critical domain of Know Your Client (KYC) practices with this in-depth course. Gain a comprehensive understanding of KYC regulations, client due diligence, anti-money laundering, and more. Elevate your compliance acumen and set a new standard in client onboarding and risk assessment.

Know Your Client (KYC)
Delivered Online On Demand1 hour
£5

Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes!

4.8(9)

By Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes!
Delivered Online On Demand1 hour 38 minutes
£25

Accredited Microsoft Excel 2007 for Beginners

By iStudy UK

This course was created to help anyone learn about Microsoft Excel 2007 for beginners. Through this course, you will learn the importance of planning and organise your thoughts when creating a worksheet. This will help you maximise the capability of the Excel program. You will learn the basic functions and formula that are commonly used in Microsoft Excel. You will also know the importance of saving, editing and creating new worksheets in an effective manner. This course will help you practice what you've learned and learn how to apply what you've learned in your career. Course Highlights Accredited Microsoft Excel 2007 for Beginners is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Microsoft Excel 2007 for Beginners into several modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Microsoft Excel 2007 for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Microsoft Excel 2007 for Beginners is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Accredited Microsoft Excel 2007 for Beginners 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Accredited Microsoft Excel 2007 for Beginners 00:00:00 Mock Exam Final Exam

Accredited Microsoft Excel 2007 for Beginners
Delivered Online On Demand11 hours 30 minutes
£25

Data Analyst (Data Analytics) Training

4.7(47)

By Academy for Health and Fitness

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now in this Data Analyst Course! Unlock the power of Data Analysis and become a master of insights with our Data Analyst (Data Analytics) course. Gain the Data Analyst skills to decipher complex datasets, extract valuable information, and make data-driven decisions that drive success as a Data Analyst. Join us on this Data Analyst (Data Analytics) course and embark on a journey to transform raw data into actionable intelligence, empowering businesses to thrive in the digital age with Data Analyst (Data Analytics) Courses Included in This Data Analyst (Data Analytics) Training: Course 01: Diploma in Data Analysis at QLS Level 5 Course 02: Diploma in Business Data Analysis at QLS Level 5 Course 03: SQL Masterclass: SQL For Data Analytics Learning outcome of this Data Analyst (Data Analytics) course: Master retail Data analytics for data-driven decisions. Uncover consumer behavior with retail psychology. Enhance retail performance through data analytics. Apply data-driven strategies for retail planning. Optimise inventory and product assortment in retail. Why Prefer This Data Analysis at QLS Level 5 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Get instant access to this Data Analyst (Data Analytics) course. Learn Data Analyst (Data Analytics) from anywhere in the world Data Analyst (Data Analytics) is affordable and simple to understand Data Analyst (Data Analytics) is entirely online, interactive lesson with voiceover audio Lifetime access to the Data Analyst (Data Analytics) course materials Data Analyst (Data Analytics) comes with 24/7 tutor support Start your learning journey straight away with this Data Analyst (Data Analytics) course and take a step toward a brighter future! Why Prefer This Data Analyst (Data Analytics) Course? FREE certificate on Data Analyst (Data Analytics) accredited by CPDQS Get instant access to this Data Analyst (Data Analytics) course. Learn Data Analyst (Data Analytics) from anywhere in the world Data Analyst (Data Analytics) is affordable and simple to understand Data Analyst (Data Analytics) is entirely online, interactive lesson with voiceover audio Lifetime Access to the Data Analyst (Data Analytics) course materials Data Analyst (Data Analytics) comes with Data Analysis Assessment Process of Data Analyst(Data Analytics) QLS Course: Assignment & MCQ Based 60% Marks to pass Instant Assessment Certificate of Data Analyst QLS Endorsed Certificate (additional cost) CPD Approved Certificate CPD 150 CPD hours / points Accredited by CPD Quality Standards Course 01- Data Analysis: Modifying a Worksheet 25:59 1: Insert, Delete, and Adjust Cells, Columns, and Rows Preview 10:08 2: Search for and Replace Data 08:38 3: Use Proofing and Research Tools 07:13 Working with Lists 37:47 4: Sort Data 10:03 5: Filter Data 09:49 6: Query Data with Database Functions 09:02 7: Outline and Subtotal Data 08:53 Analyzing Data 12:33 8: Apply Intermediate Conditional Formatting 06:50 9: Apply Advanced Conditional Formatting 05:43 Visualizing Data with Charts 38:03 10: Create Charts 13:18 11: Modify and Format Charts 12:16 12: Use Advanced Chart Features 12:29 Using PivotTables and PivotCharts 44:25 13: Create a PivotTable 13:28 14: Analyze PivotTable Data 12:00 15: Present Data with PivotCharts 07:35 16: Filter Data by Using Timelines and Slicers 11:22 Working with Multiple Worksheets and Workbooks 24:00 17: Use Links and External References 12:24 18: Use 3-D References 05:51 19: Consolidate Data 05:45 Using Lookup Functions and Formula Auditing 30:28 20: Use Lookup Functions 12:45 21: Trace Cells 09:05 22: Watch and Evaluate Formulas 08:38 Automating Workbook Functionality 35:27 23: Apply Data Validation 13:28 24: Search for Invalid Data and Formulas with Errors 04:06 25: Work with Macros 17:53 Creating Sparklines and Mapping Data 07:19 26: MapData 07:19 Forecasting Data 27:54 27: Determine Potential Outcomes Using Data Tables 08:47 28: Determine Potential Outcomes Using Scenarios 09:16 29: Use the Goal Seek Feature 04:16 30: Forecasting Data Trends 05:35 Course 02- Module 1: Introduction to Retail Analytics 32:03 31: Introduction to Retail Analytics Preview 32:03 Module 2: Retail Psychology 07:06 32: Retail Psychology 07:06 Module 3: Retail and Data Analytics 12:00 33: Retail and Data Analytics 12:00 Module 4: Benefits of Retail Analytics 16:26 34: Benefits of Retail Analytics 16:26 Module 5: Retail Strategy 09:44 35: Retail Strategy 09:44 Module 6: Retail Buying and Merchandising 11:27 36: Retail Buying and Merchandising 11:27 Module 7: Forecasting 23:27 37: Forecasting 23:27 Module 8: Retail Pricing 16:30 38: Retail Pricing 16:30 Module 9: Analytics Software 19:37 39: Analytics Software 19:37 Module 10: Supply Chain Management in Retailing 07:37 40: Supply Chain Management in Retailing 07:37 Module 11: The Sales Process and Dealing with Customers at the Checkout 04:57 41: The Sales Process and Dealing with Customers at the Checkout 04:57 Module 12: Selling in Multiple Channels 12:40 42: Selling in Multiple Channels 12:40 Module 13: Taking Trends and Targeting Customers Effectively 05:38 43: Taking Trends and Targeting Customers Effectively 05:38 Assessment (Optional) 12:00 44: MCQ Question 12:00 Order Your Certificate 02:00 45: Order Your CPD Certificate 01:00 46: Order Your QLS Endorsed Certificate 01:00 Who is this course for? Data Analyst (Data Analytics) Training This course is for people who want to quickly and easily learn about Data Analyst (Data Analytics). Requirements Data Analyst (Data Analytics) Training You will not need any prior background or expertise to enrol in this Data Analyst (Data Analytics) course. Career path Data Analyst: £25,000 - £50,000 Junior Data Scientist: £30,000 - £60,000 Senior Data Analyst/Scientist: £50,000 - £100,000 Data Analytics Manager: £60,000 - £120,000 Certificates Cademy certificate of completion Digital certificate - Included Will be downloadable when all lectures have been completed Certificate of completion Digital certificate - £10 Diploma in Retail And Data Analytics at QLS Level 5 Hard copy certificate - £119 Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Retail And Data Analytics at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 119 GBP inside the UK 129 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)

Data Analyst (Data Analytics) Training
Delivered Online On Demand8 hours
£12

Cryptocurrency Diploma

4.7(160)

By Janets

This Cryptocurrency Diploma is designed to provide you with all the information you need to know how to confidently use, mine or trade this digital asset. The course will not only instruct you on how to use cryptocurrency, but also how to understand the technology behind it. Learn the skills of the trade today and develop the expertise you need to make the most of this often highly-rewarding industry. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £69. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Who is this course for? Cryptocurrency Diploma is suitable for anyone who want to gain extensive knowledge, potential experience and skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject.

Cryptocurrency Diploma
Delivered Online On Demand5 days
£9.99

Sage 50 Accounts

By Xpert Learning

About Course Sage 50 Accounts: Master the Popular Accounting Software Learn how to use Sage 50 Accounts, one of the most popular accounting software solutions available, with this comprehensive online course. This course is designed for everyone, from beginners to experienced professionals. You will learn everything you need to know to use Sage 50 Accounts effectively, from setting up a new company to creating year-end reports. The course is taught by industry experts and covers a wide range of topics, including: Setting up and managing a company Recording transactions Payroll processing Creating reports Tax compliance You will learn through a combination of video lessons, interactive exercises, and self-paced assessments. By the end of the course, you will be able to: Use Sage 50 Accounts to manage all aspects of your accounting Create accurate and timely financial reports Comply with all relevant tax regulations Why study this course? Sage 50 Accounts is a powerful accounting software solution used by millions of businesses worldwide. Learning how to use Sage 50 Accounts can help you to save time and improve the efficiency of your accounting processes. Sage 50 Accounts is a highly sought-after skill by employers. This course is perfect for: Small business owners Bookkeepers and accountants Anyone who wants to learn a new accounting skill Enroll today and start your journey to becoming a Sage 50 Accounts expert! Course features: Taught by industry expert Comprehensive coverage of all aspects of Sage 50 Accounts Interactive exercises and self-paced assessments Requirements: For practice purposes, you should have Sage 50 Software installed on your PC. The software is not included with this course. What Will You Learn? Use Sage 50 Accounts to manage all aspects of your accounting Create accurate and timely financial reports Comply with all relevant tax regulations Course Content Getting Started Getting Started Setting up of the System Virtual Tour of Sage 50cloud Accounts Edit and Modify Default Chart of Accounts Add a Business Bank Account, Credit Card Account and Petty Cash Account Creating and Deleting Departments Customers and Suppliers Setting up Customers and Suppliers Create a Project List Entering Purchase (Supplier Invoice), Purchase Credit Note, Purchase Order.. Entering Sales Fixed Assets Fixed Asset Register Bank Payments and Receipts Bank Payments and Transfer Recording Customer Receipts and Supplier Payments Adding Recurring Items Petty Cash Petty Cash Account Bank Reconciliation with Bank Feed Bank Reconciliation - Current Account Bank Reconciliation - Petty Cash and Credit Card Aged Reports Aged Reports Payroll Journals Payroll Posting and Payroll Journal Vat Return (Making Tax Digital) Vat Return Opening balances on Sage 50 Cloud Accounts Opening Balances on Sage 50 Year End Journals Year End Journals Cash Flow, Budgets and Accountant's Report Cash Flow, Budgets and Accountant's Reports Apps and Add-ons Apps and Add-ons Correction of Error, Backup and Restore Correction of Error, Back Up and Restore Course Book Coursebook for Sage 50 Cloud Accounts (V.29) - 2023 A course by Ujjwala D'Souza MAAT, Sage/Xero/Quickbooks Trainer/Advisor RequirementsFor practice purposes, you should have Sage 50 Software installed on your PC. The software is not included with this course. Audience Small business owners Bookkeepers and accountants Anyone who wants to learn a new accounting skill Audience Small business owners Bookkeepers and accountants Anyone who wants to learn a new accounting skill

Sage 50 Accounts
Delivered Online On Demand4 hours 12 minutes
£9.99