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

7085 Courses

Accounts Assistant - Bookkeeping and Accounting Basics

By Compliance Central

Turn Your Dreams into Reality with the Accounts Assistant - Bookkeeping and Accounting Basics Training course. This comprehensive Accounts Assistant - Bookkeeping and Accounting Basics online course will equip you with the knowledge and skills you need to succeed in your chosen field. Whether you're a beginner or looking to take your career to the next level, this course has covered you. Key Learning Outcomes: Understanding the core concepts and theories in your field Building your knowledge and skills through practical, hands-on learning Developing the ability to think critically and solve problems effectively Enhancing your communication skills and the ability to work effectively with others Gaining a competitive edge in your career and reaching your full potential With a flexible online format that allows you to learn at your own pace, Accounts Assistant - Bookkeeping and Accounting Basics training course offers a convenient and accessible way to boost your career prospects. So why wait? Enrol today and take the first step towards success! Vital Component of the Accounts Assistant - Bookkeeping and Accounting Basics course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced online course Modules Covers to Explore Multiple Job Positions Transform your career with the Accounts Assistant - Bookkeeping and Accounting Basics Bundle! Perfect your skills and stand out in the employment market with our comprehensive training program. Impress potential employers and add valuable expertise to your resume. Don't wait-enrol in the Accounts Assistant - Bookkeeping and Accounting Basics Bundle now and take the first step towards a successful and fulfilling career! Course Outline: Section 01: Accounting Fundamental Lecture-1.What is Financial Accounting Lecture-2. Accounting Double Entry System and Fundamental Accounting Rules Lecture-3.Financial Accounting Process and Financial Statements Generates Lecture-4.Basic Accounting Equation and Four Financial Statements Lecture-5.Define Chart of Accounts and Classify the accounts Lecture-6. External and Internal Transactions with companies Lecture-7.Short Exercise to Confirm what we learned in this section Section 02: Accounting Policies Lecture-8.What are Major Accounting Policies need to be decided by companies Lecture-9.Depreciation Policies Lecture-10.Operational Fixed Asset Controls Lecture-11.Inventory Accounting and Controls Lecture-12.Revenue Accounting and Controls Lecture-13.Expenses Accounting and Working Capital CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is the perfect fit for anyone seeking to start or advance in the Accounts Assistant - Bookkeeping and Accounting Basics industry. Whether you're a beginner or looking to expand your knowledge, this comprehensive training will provide you with the essential skills and expertise to succeed. Requirements Join the Excitement-With this Accounts Assistant - Bookkeeping and Accounting Basics course, there's no limit to what you can achieve. From day one, you'll be on your way to building a fulfilling career in this thriving field. No prior experience is required to enrol in this course. Career path Upon completion, you'll have the opportunity to pursue a variety of in-demand Accounts Assistant - Bookkeeping and Accounting Basics jobs, with endless possibilities for growth and success. Certificates Certificate of completion Digital certificate - Included After successfully completing this course, you can get a CPD accredited digital PDF certificate for FREE. Certificate of completion Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Accounts Assistant - Bookkeeping and Accounting Basics
Delivered Online On Demand2 hours
£12

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

Certified Diploma in Microsoft Excel

By iStudy UK

Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. This course is designed to enable you to analyse lots of data and tell a story quickly and interactively. Explore various time-saving Formulas, create automated reports with the press of a button, amaze your manager with professional Excel Charts and get noticed by top management & prospective employers. Course Highlights Certified Diploma in Microsoft Excel 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 Certified Diploma in Microsoft Excel into 39 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 1 day, 9 hours 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 Certified Diploma in Microsoft Excel 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? Certified Diploma in Microsoft Excel 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 Certified Diploma in Microsoft Excel 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. Microsoft Excel for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities - Microsoft Excel for Beginners CPD & IAO Accredited 00:00:00 Microsoft Excel - Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 00:30:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 00:30:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working With Macros 00:30:00 Module Seven - Working With Forms 00:30:00 Module Eight - Applying Advanced Chart Features 01:00:00 Module Nine - Working With Slicers and Timelines 00:30:00 Module Ten - Working With Multiple Tables, Relationships and External Data 00:30:00 Module Eleven - Working With PowerView 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities- Microsoft Excel Intermediate Level CPD & IAO Accredited 00:00:00 Microsoft Excel - Advanced Level Module One - Getting Started FREE 01:00:00 Module Two - SmartArt and Objects FREE 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel Advanced CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Certified Diploma in Microsoft Excel 00:30:00 Final Exam Final Exam- Certified Diploma in Microsoft Excel 00:30:00

Certified Diploma in Microsoft Excel
Delivered Online On Demand33 hours
£25

Data Analysis with SQL & Tableau for Data Analytics - 8 Courses Bundle

By NextGen Learning

Are you ready to embark on an enlightening journey of wisdom with the Data Analysis bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Data Analysis with SQL & Tableau for Data Analytics. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Introduction to Data Analytics with Tableau Course 2: Big Data Analytics with PySpark Tableau Desktop and MongoDB Course 3: Big Data Analytics with PySpark Power BI and MongoDB Course 4: Google Data Studio: Data Analytics Course 5: SQL for Data Science, Data Analytics and Data Visualization Course 6: Business Analysis Course Level 5 Course 7: Financial Analysis Course 8: Data Analysis and Forecasting in Excel Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Data Analysis with SQL & Tableau for Data Analytics bundle illuminate your path to wisdom. The Data Analysis with SQL & Tableau for Data Analytics bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Data Analysis with SQL & Tableau for Data Analytics package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Data Analysis bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Data Analysis with SQL & Tableau for Data Analytics community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Data Analysis with SQL & Tableau for Data Analytics Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Data Analysis bundle. Establish robust bases across each course nestled within the Data Analysis bundle. Decipher intricate concepts through the articulate content of the Data Analysis bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Data Analysis with SQL & Tableau for Data Analytics bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Data Analysis bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Data Analysis with SQL & Tableau for Data Analytics bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Data Analysis bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Data Analysis bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Data Analysis journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Data Analysis with SQL & Tableau for Data Analytics Bundle. Career path Armed with the Data Analysis with SQL & Tableau for Data Analytics bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Data Analysis bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Data Analysis with SQL & Tableau for Data Analytics - 8 Courses Bundle
Delivered Online On Demand32 hours
£39

Crime Analyst with Interrogations And Confessions Psychology - 8 Courses Bundle

By NextGen Learning

Unlock the secrets of the criminal mind with our comprehensive "Crime Analyst with Interrogations And Confessions Psychology" bundle! In the UK alone, crime rates have surged by 15% in the last year, highlighting the critical need for crime analysis and investigation experts. This bundle equips you with a powerful skill set to navigate the complexities of modern crime. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01:- 8 Courses Bundle  Course 02: Accident Investigation Course 03: Criminal Law Course 04: Criminal Psychology and Profiling Course 05: Interrogations And Confessions Psychology Course 06: Anti-Money Laundering (AML) and Financial Crime Course 07: Forensic Science Level 3 Course Course 08: Human Rights Elevate your expertise in understanding crime from multiple angles with our "Crime Analyst with Interrogations And Confessions Psychology" bundle. Enrol now to unravel the secrets that lie within every investigation. Take advantage of this opportunity to delve into the fascinating world of crime analysis! Learning outcomes Master Criminal Investigation Techniques Expertise in Accident Investigation Comprehensive Understanding of Criminal Law Proficiency in Criminal Psychology and Profiling Mastery of Interrogations And Confessions Psychology Anti-Money Laundering and Financial Crime Prevention Get a head start on your career in crime analysis and investigative psychology with our comprehensive "Crime Analyst with Interrogations And Confessions Psychology" bundle. This thoughtfully curated collection of courses is your ticket to a dynamic and impactful role in criminal justice. Become familiar with investigative techniques, criminal law frameworks, and psychological insights that drive successful crime analysis. With a focus on decoding criminal behaviour and understanding the science of obtaining reliable information, this Crime Analyst with Interrogations And Confessions Psychology bundle equips you with the skills needed to excel in this competitive field. Learn how to navigate the complexities of financial investigations and uncover hidden patterns that reveal illicit activities. Discover the ethical considerations that underpin every facet of criminal justice, ensuring you're well-prepared to handle sensitive information and situations. By enrolling in this "Crime Analyst with Interrogations And Confessions Psychology" bundle, you're setting the stage for a successful career that's both personally satisfying and socially impactful. Don't just dream about a rewarding profession - make it a reality with our "Crime Analyst with Interrogations And Confessions Psychology" bundle. Your journey towards a promising career starts here. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring Crime Analysts Law Enforcement Professionals Legal Consultants and Advisors Private Investigators Students Pursuing Criminal Justice Studies Professionals in Financial Services Career path Upon completing the Crime Analyst bundle, you'll be equipped with a diverse skill set that opens doors to a range of compelling career paths like Crime Analyst (£20k - £50k+ per year) Criminal Investigator (£20k - £40k+ per year) Forensic Psychologist (£25k - £44k+ per year) Financial Crime Analyst (£20k - £60k+ per year) Legal Consultant (£25k - £80k+ per year) Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Crime Analyst with Interrogations And Confessions Psychology - 8 Courses Bundle
Delivered Online On Demand31 hours
£39

NFT for Beginners Course

By NextGen Learning

Overview By enroling in NFT for Beginners, you can kickstart your vibrant career and strengthen your profound knowledge. You can learn everything you need to know about the topic. The NFT for Beginners course includes all of the most recent information to keep you abreast of the employment market and prepare you for your future. The curriculum for this excellent NFT for Beginners course includes modules at all skill levels, from beginner to expert. You will have the productivity necessary to succeed in your organisation once you have completed our NFT for Beginners Program. So enrol in our NFT for Beginners course right away if you're keen to envision yourself in a rewarding career. Description Enroling in this NFT for Beginners course can improve your NFT for Beginners perspective, regardless of your skill levels in the NFT for Beginners topics you want to master. If you're already a NFT for Beginners expert, this peek under the hood will provide you with suggestions for accelerating your learning, including advanced NFT for Beginners insights that will help you make the most of your time. This NFT for Beginners course will act as a guide for you if you've ever wished to excel at NFT for Beginners. Why Choose Us? After successfully completing the NFT for Beginners Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of NFT for Beginners learning materials. Online test with immediate results Enroling in the course has no additional cost. You can study and complete the NFT for Beginners course at your own pace. Study for the NFT for Beginners course using any internet-connected device, such as a computer, tablet, or mobile device. Who Is This Course For? This NFT for Beginners course is a great place to start if you're looking to start a new career in NFT for Beginners field. This training is for anyone interested in gaining in-demand NFT for Beginners proficiency to help launch a career or their business aptitude.  Requirements The NFT for Beginners course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of NFT for Beginners, without any fuss. Career Path This NFT for Beginners training will assist you develop your NFT for Beginners ability, establish a personal brand, and present a portfolio of relevant talents. It will help you articulate a NFT for Beginners professional story and personalise your path to a new career. Furthermore, developing this NFT for Beginners skillset can lead to numerous opportunities for high-paying jobs in a variety of fields. Course Curriculum Module 01: Introduction to Non-Fungible Tokens Introduction to Non-Fungible Tokens 00:25:00 Module 02: Blockchain and Ethereum Blockchain and Ethereum 00:25:00 Module 03: NFT Marketplaces and Projects NFT Marketplaces and Projects 00:25:00 Module 04: NFT Security and Standards NFT Security and Standards 00:20:00 Module 05: Creating and Selling NFTs Creating and Selling NFTs 00:20:00 Module 06: Investing In NFTs Investing In NFTs 00:25:00 Module 07: The Future of NFTs The Future of NFTs 00:20:00

NFT for Beginners Course
Delivered Online On Demand2 hours 40 minutes
£25

Data Analysis In Excel Course

By NextGen Learning

Overview By enroling in Data Analysis In Excel, you can kickstart your vibrant career and strengthen your profound knowledge. You can learn everything you need to know about the topic. The Data Analysis In Excel course includes all of the most recent information to keep you abreast of the employment market and prepare you for your future. The curriculum for this excellent Data Analysis In Excel course includes modules at all skill levels, from beginner to expert. You will have the productivity necessary to succeed in your organisation once you have completed our Data Analysis In Excel Program. So enrol in our Data Analysis In Excel course right away if you're keen to envision yourself in a rewarding career. Description Enroling in this Data Analysis In Excel course can improve your Data Analysis In Excel perspective, regardless of your skill levels in the Data Analysis In Excel topics you want to master. If you're already a Data Analysis In Excel expert, this peek under the hood will provide you with suggestions for accelerating your learning, including advanced Data Analysis In Excel insights that will help you make the most of your time. This Data Analysis In Excel course will act as a guide for you if you've ever wished to excel at Data Analysis In Excel. Why Choose Us? This course is accredited by the CPD Quality Standards. Lifetime access to the whole collection of the learning materials. Online test with immediate results. Enroling in the course has no additional cost. You can study and complete the course at your own pace. Study for the course using any internet-connected device, such as a computer, tablet, or mobile device. Will I Receive A Certificate Of Completion? Upon successful completion, you will qualify for the UK and internationally-recognised CPD certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £4.99 and Hardcopy Certificate for £9.99. Who Is This Course For? This Data Analysis In Excel course is a great place to start if you're looking to start a new career in Data Analysis In Excel field. This training is for anyone interested in gaining in-demand Data Analysis In Excel proficiency to help launch a career or their business aptitude.  Requirements The Data Analysis In Excel course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of Data Analysis In Excel, without any fuss. Career Path This Data Analysis In Excel training will assist you develop your Data Analysis In Excel ability, establish a personal brand, and present a portfolio of relevant talents. It will help you articulate a Data Analysis In Excel professional story and personalise your path to a new career. Furthermore, developing this Data Analysis In Excel skillset can lead to numerous opportunities for high-paying jobs in a variety of fields. Order Your Certificate To order CPD Quality Standard Certificate, we kindly invite you to visit the following link: Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Assignment Assignment - Data Analysis In Excel 00:00:00 Order Your Certificate Order Your Certificate 00:00:00

Data Analysis In Excel Course
Delivered Online On Demand4 hours 43 minutes
£25

Excel Essentials for Office Administrators

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

Excel Essentials for Office Administrators
Delivered Online On Demand23 hours 44 minutes
£25

Microsoft Excel - Intermediate Level

4.3(43)

By John Academy

Description: Microsoft Excel was created to become a useful program to help you become more efficient and effective in manipulating your data. This program is being used by almost all the professionals. You will know how to share workbooks, its advanced functions and formulas through this course. You will learn the importance of security setting when sharing workbooks with Macros. You will take advantage of the host of functions available in Excel to perform every type of calculation you can imagine. Who is the course for? Professionals who want to learn about Microsoft Office Excel Essentials 2013. People who have an interest in knowing all the features of Microsoft Excel 2013 Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Excel Intermediate Level course is a useful qualification to possess and would be beneficial for any for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager Microsoft Excel - Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 00:30:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 00:30:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working With Macros 00:30:00 Module Seven - Working With Forms 00:30:00 Module Eight - Applying Advanced Chart Features 01:00:00 Module Nine - Working With Slicers and Timelines 00:30:00 Module Ten - Working With Multiple Tables, Relationships and External Data 00:30:00 Module Eleven - Working With PowerView 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities- Microsoft Excel - Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel - Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft Excel - Intermediate Level 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Excel - Intermediate Level
Delivered Online On Demand8 hours 10 minutes
£19

Microsoft Excel 2007 Advanced Level

4.3(43)

By John Academy

Description: Knowing how to utilise the advanced features of Microsoft Excel 2007 opens an entirely new experience in utilising this spreadsheet program. This course is designed to provide you with everything you need to know about Microsoft Excel 2007. From the essentials to the most advanced tools, by the end of this course, you will have the skills to utilise Microsoft Excel 2007 at an expert level. Once you complete the course, your familiarity and confidence in using the advanced feature of Excel 2007 will increase, making Excel 2007 a more useful tool for you at work or home. Who is the course for? New users, beginners, intermediates and advanced Excel users can benefit from this course. This course would be ideal for individuals who wish to develop their skills of using Microsoft Office Excel application. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career path: The Microsoft Excel 2007 Advanced Level will be very beneficial and helpful, especially to the following professionals: Administrative Assistant. PA. Secretary. Administrator. Office Manager. Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2007 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Excel 2007 Advanced Level 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Excel 2007 Advanced Level
Delivered Online On Demand11 hours 40 minutes
£19