3504 Courses

Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives  By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code

Use some of the hidden statistical analysis tools within Excel to build complex data models. Course overview Duration: 1 day (6.5 hours) This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used. This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths. Objectives By the end of the course you will be able to: Use Goal Seek Create and view scenarios Use Forecast Sheet Create single and double input data tables Create models using the solver Install and use the Analysis Toolpak Create and use array formulas Use a range of advanced Financial and Statistical Excel functions Content Using what if analysis options Using Goal Seek Creating, saving and viewing scenarios Generating a Forecast sheet Solver Creating models Projecting scenarios with Solver Using data tables Creating single input data tables Creating double input data tables Projecting with data tables Financial functions PMT FV NPV Analysing data with Analysis ToolPak Installing the Analysis Toolpak Generating statistical analysis Visualising data using Histograms Array formulas Using embedded Excel Array formulas Create an Array formula Multi and single cell Array formula Using TRANSPOSE to flip rows or columns Use the FREQUENCY Function Use an array to count unique entries in a range Dynamic arrays Spilling data Using the new dynamic array functions Advance functions in formulas Statistical functions:MEAN, MEDIAN and MODERANKLARGE and SMALLMODPERCENTILE Use the AGGREGATE function to sum data in ranges with errors

🏡 Master Your Household Finances with Household Ledger Course! 📊 Are you ready to take control of your household finances and achieve financial freedom? Introducing our Household Ledger course, a comprehensive text-based program designed to empower you with the skills and knowledge needed to manage your finances effectively. Say goodbye to financial stress and hello to financial empowerment with our easy-to-follow lessons and practical exercises.   🌟 Benefits of Taking the Household Ledger Course: Financial Literacy: Gain a solid understanding of basic financial principles, including budgeting, tracking expenses, and managing debt. Improved Money Management: Learn how to create and maintain a household ledger to track income, expenses, and savings accurately. Debt Reduction: Discover strategies for reducing debt and building a solid financial foundation for you and your family. Budgeting Mastery: Develop effective budgeting techniques to allocate funds wisely, prioritize spending, and achieve your financial goals. Financial Planning: Learn how to set realistic financial goals, create a savings plan, and prepare for unexpected expenses or emergencies. Empowerment and Confidence: Gain the confidence to make informed financial decisions and take control of your financial future. Enhanced Communication: Improve communication with family members about financial matters, fostering teamwork and cooperation in managing household finances.   👨‍👩‍👧‍👦 Who is this for? Individuals and families looking to gain control over their household finances. Those seeking to improve their financial literacy and money management skills. Anyone struggling with debt or financial stress and in need of practical solutions. Couples or families wanting to work together to achieve their financial goals.   🚀 Career Path: While the Household Ledger course primarily focuses on personal finance management, the skills learned can also be valuable in various career paths, including: Financial Planning: Pursue a career as a financial planner or advisor, helping individuals and families create comprehensive financial plans to achieve their goals. Accounting and Bookkeeping: Apply your knowledge of budgeting and ledger management in roles such as accounting clerk, bookkeeper, or financial analyst. Financial Counseling: Become a financial counselor or coach, assisting clients in overcoming financial challenges, managing debt, and achieving financial wellness. Education: Share your expertise by teaching financial literacy courses in schools, community centers, or online platforms, empowering others to take control of their finances. Entrepreneurship: Use your financial management skills to start your own business or consultancy focused on personal finance education and coaching.   🔍 FAQ: Q: Is this course suitable for beginners? A: Yes! The Household Ledger course is designed for individuals with varying levels of financial knowledge, including beginners. Our easy-to-follow lessons and practical exercises make it accessible to everyone. Q: Do I need any special software to take this course? A: No, you do not need any special software. The Household Ledger course utilizes simple and accessible methods for managing household finances, including manual ledger tracking techniques. Q: How long does it take to complete the course? A: The duration of the course depends on your learning pace and schedule. On average, students complete the course in 4-6 weeks, dedicating a few hours per week to study and practice. Q: Will I receive a certificate upon completion of the course? A: Yes, upon successful completion of the Household Ledger course, you will receive a certificate of achievement, showcasing your newfound skills in household finance management. Q: Can I apply the skills learned in this course to manage small business finances? A: While the focus of the course is on household finances, many of the principles and techniques taught can be applied to small business finance management as well. Q: Is there any support available if I have questions or need assistance during the course? A: Yes, our dedicated support team is available to assist you throughout your learning journey. You can reach out via email or through our online platform for prompt assistance.   🌐 Ready to Take Control of Your Finances? Don't let financial stress hold you back from achieving your dreams. Enroll now in the Household Ledger course and embark on a journey to financial empowerment and security. Start building a brighter financial future for you and your loved ones today! 💰🏡✨ Course Curriculum Module 1 Introduction to Household Ledger Management Introduction to Household Ledger Management 00:00 Module 2 Mastering Budgeting and Financial Tracking Mastering Budgeting and Financial Tracking 00:00 Module 3 Frugal Living and Efficient Spending Frugal Living and Efficient Spending 00:00 Module 4 Building an Emergency Fund for Financial Security Building an Emergency Fund for Financial Security 00:00 Module 5 Mastering Debt Management and Achieving Financial Freedom Mastering Debt Management and Achieving Financial Freedom 00:00 Module 6 Introduction to Investing for Financial Growth Introduction to Investing for Financial Growth 00:00 Module 7 Secure Your Future_ Retirement Planning for a Comfortable Retirement Secure Your Future_ Retirement Planning for a Comfortable Retirement 00:00

What Will I Learn? Communicate well in a professional setting Discuss general business matters in Vietnamese Discuss finance Discuss sales and marketing Discuss accounting Discuss human resource management Discuss production management Requirements Some basic Vietnamese Description This course is intended to help you communicate confidently in Vietnamese in professional environments. With this Vietnamese for Business course, you'll learn everything you need to know for your job in Vietnamese in Vietnam. From advanced vocabulary and language to generally talk about business matters in Vietnamese, this course will help you out all the way. Learn professionally greet and meet with co-workers and clients. Moreover, this course also discusses finance, the stock market, and investing including converse about management and human resources, sales and marketing, general business matters in Vietnam, etc. If you're interested in learning the Vietnamese language for the business purpose, then welcome to join the course and take your skills to an advanced level. In Vietnamese for Business you will learn: 1. How to generally talk about business matters in Vietnamese 2. How to professionally greet and meet with coworkers and clients 3. How to discuss finance, the stock market, and investing 4. How to converse about management and human resources 5. How to talk about sales and marketing 6. How to discuss general business matters 7. Much more Vietnamese language practice This course is for anyone studying the Vietnamese language who has already learned the tones and alphabet and is ready for more advanced vocabulary and language. While it is specifically designed for those working in a professional environment it is also a great supplement for general Vietnamese language learners as the vocabulary, pronunciation, and style are all natural and colloquial. In other words, this is the way that local Vietnamese people use the language every day. It took me ten years to attain the level of fluency that I currently enjoy in the language. I have recently moved back to Vietnam, where I teach Vietnamese to foreigners, Business, and other subjects full time. If you're serious about learning the Vietnamese language, I encourage you to join the course and take your next step toward total fluency! Who is the target audience? People with a basic understanding of Vietnamese who are or intend to communicate in the work related setting with Vietnamese people   Introduction Introduction Vietnamese for Business FREE 00:13:00 Professional Greeting, Finance and Real Estate Professional Greetings 00:13:00 Finance 00:11:00 Real Estate 00:11:00 Commodities, Meetings, Sales & marketing Metals and Commodities 00:08:00 Meetings 00:11:00 Sales & Marketing 00:09:00 Human Resources, Accounting, and Management Human Resources 00:07:00 Accounting 00:03:00 Management 00:05:00 Conclusion Conclusion 00:06:00

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want This course will help you understand the intricacies of logistics, inventory management and procurement strategies. From this course, you will learn the essential skills of cost-reduction, supply chain process optimisation and enhance overall operational efficiency. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand tips for effective supply chain management Know the key issues of SCM Understand vendor-managed inventory Learn warehouse management Understand the role of logistics in SCM Know the finished goods supply chain Get to know the significance of SCM Understand demand planning Know the role of IT in SCM Learn global supply chain management Understand reverse logistics Why Supply Chain Management Training Course right for you? This comprehensive course will guide you on the nuances of supply chain management, supply chain network design, demand planning, and the relevance of IT in SCM. You will have a broad understanding of global supply chain management, finished goods supply chain, and vendor-managed inventory. In addition, this course will educate you on warehouse management, factors of warehouse efficiency, and the throughput of the process chain. Apart from that, this interactive course will update you on the critical issues of SCM and the tips for effective SCM. By the end of the course, you will have a deep understanding of supply chain management, supply chain network design, demand planning, and reverse logistics. Xero Accounting and Bookkeeping Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum SCM - Introduction SCM - Introduction Importance of SCM Importance of SCM What is Supply Chain Management What is Supply Chain Management Supply Chain Network Design Supply Chain Network Design What is Demand Planning What is Demand Planning Role of IT in SCM Role of IT in SCM Role of Logistics in SCM Role of Logistics in SCM Global Supply Chain Management Global Supply Chain Management Finished Goods Supply Chain Finished Goods Supply Chain What is Reverse Logistics What is Reverse Logistics Vendor Managed Inventory Vendor Managed Inventory Warehouse Management Warehouse Management Factors of Warehouse Efficiency Factors of Warehouse Efficiency Throughput of Process Chain Throughput of Process Chain Key Issues of SCM Key Issues of SCM Tips for Effective SCM Tips for Effective SCM Who should take this course? This extensive course is suitable for those who want to have an in-depth understanding of supply chain management, logistics, and supply chain network design. It is ideal for those who wish to pursue a career in the field of supply chain management. Entry Requirements There are no academic entry requirements for this supply chain management training course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This supply chain management training course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

The Cambridge First Certificate in English (FCE) represents the third level examination of the “Cambridge in English for Speakers of Other Languages” classification and it is equivalent to a B2 (Upper Intermediate) level from the Common Framework for European languages. FCE Exam Registration The FCE exams are held on a monthly basis, and if interested, Castleforbes College will provide you with all the necessary information and preparation for the exam. All FCE exams are arranged in external certified centres located in Dublin.

Duration 2.25 Days 13.5 CPD hours This course is intended for The job roles best suited to the material in this course are: sales personnel, accountants, administrators, auditors, lab assistants, office job positions. Overview Work with functions. Work with lists. Analyze data. Visualize data with charts. Use PivotTables and PivotCharts. Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality. Use Lookup functions and formula auditing. Forecast data. Create sparklines and map data This course provides the knowledge to create advanced workbooks and worksheets that can deepen the understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it and present that information to decision makers. In addition this course will give you the ability to collaborate with colleagues, automate complex or repetitive tasks and use conditional logic to construct and apply elaborate formulas and functions which will allow you to work through a lot of data and generate the answers that your organisation needs. WORKING WITH FUNCTIONS Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date and Time Functions Topic E: Work with Text Functions WORKING WITH LISTS Topic A: Sort Data Topic B: Filter Data Topic C: Query Data with Database Functions Topic D: Outline and Subtotal Data ANALYZING DATA Topic A: Create and Modify Tables Topic B: Apply Intermediate Conditional Formatting Topic C: Apply Advanced Conditional Formatting VISUALIZING DATA WITH CHARTS Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Use Advanced Chart Features USING PIVOTTABLES AND PIVOTCHARTS Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS Topic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data SHARING AND PROTECTING WORKBOOKS Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks AUTOMATING WORKBOOK FUNCTIONALITY Topic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros USING LOOKUP FUNCTIONS AND FORMULAS AUDITING Topic A: Use Lookup Functions Topic B: Trace Cells Topic C: Watch and Evaluate Formulas FORECASTING DATA Topic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Forecast Data Trends CREATING SPARKLINES AND MAPPING DATA Topic A: Create Sparklines Topic B: Map Data

Duration 1 Days 6 CPD hours This course is intended for The audience for this course includes professionals who are new to Looker who are interested in leveraging Looker for data analysis, visualization, and reporting. The course is designed for individuals seeking to gain a comprehensive understanding of Looker's functionalities and apply these skills in their organizations to drive data-driven decision-making. Overview Working in a hands-on learning environment led by our expert facilitator, you'll explore and gain: Solid foundation in Looker's platform: Acquire a comprehensive understanding of Looker's key features, functionality, and interface, enabling you to effectively utilize the platform for your data analysis and visualization needs. Proficiency in LookML and data modeling: Develop essential skills in Looker's unique data modeling language, LookML, to create efficient and customized data models tailored to your organization's specific requirements. Expertise in creating Explores: Learn how to build, customize, and save Explores with dimensions, measures, filters, and calculated fields, empowering you to analyze your data and uncover valuable insights in a short amount of time. Mastery of dashboard design and visualization: Gain the skills to design visually appealing and informative dashboards, create various types of visualizations, and customize them to effectively communicate your data story. Improved content organization with folders and boards: Understand how to effectively use folders and boards in Looker to organize, manage, and discover content, making your data insights easily accessible for you and your team. Looker Basics: Quick Start to Analyzing and Visualizing Data using Looker is a one day, hands-on course designed to equip professionals from a variety of backgrounds with the knowledge and skills needed to harness the full potential of their data using Looker's powerful platform. With the guidance of our expert trainers, you will gain a basic understanding of Looker's features, enabling you to create visually engaging, interactive, and insightful reports and dashboards to drive informed decision-making. Throughout this interactive workshop, you will explore Looker's key functionalities, including connecting to data sources, mastering LookML, building custom Explores, and designing captivating dashboards. With about 40% of the course dedicated to hands-on labs and a guided project, you will have ample opportunity to apply the skills you've learned in real world scenarios. Don't miss this opportunity to elevate your data analysis and visualization capabilities, enhance your professional skill set, and unlock the power of data-driven decision making. Getting Started with Looker Overview of Looker and its key features Navigating the Looker interface Connecting to Data Sources and LookML Basics Setting up and managing data connections Exploring database schemas Understanding LookML: Looker's data modeling language Creating and Customizing Explores Building and customizing Explores Adding dimensions, measures, and filters Creating calculated fields Data Visualization and Dashboard Design Creating visualizations using Looker's visualization library Customizing chart types, colors, and labels Displaying visualizations in dashboards Organizing Content with Folders and Boards Introduction to folders and boards in Looker Creating and managing folders for organizing content Setting up boards for easy content discovery Hands-on Workshop and Project Participants work on a guided project to apply the skills learned Wrap-up and Q&A Additional course details: Nexus Humans Looker Basics: Quick Start to Analyzing and Visualizing Data using Looker (TTDVLK01) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Looker Basics: Quick Start to Analyzing and Visualizing Data using Looker (TTDVLK01) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.