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

1544 Running courses delivered Online

Microsoft Office 2010 Excel Advanced - Complete Video Course

4.3(43)

By John Academy

Description: This course follows up from the Beginners Excel 2010 course by delving even deeper into features and functions of this powerful spreadsheet software. This Microsoft Office 2010 Excel Advanced - Complete Video Course builds on the skills and concepts taught in Excel 2010: intermediate. In this series you will learn to work with advanced formulas, as well lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will learn how to work with Pivot Tables and PivotCharts, how to import and export data, and how to query external databases. Finally, you will learn about the analytical features of Excel, running and recording macros, SmartArt graphics and conditional formatting with graphics, and more. Before you taking this course you should have a firm grasp of the basics. This course will pull up your basic knowledge. So join this course to be an expert. 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 Advanced - 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 Advanced - 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. Logical and Statistical Functions Logical Functions FREE 00:17:00 Math and Statistical Functions 00:19:00 Financial and Date Functions Financial Functions 00:04:00 Date and Time Functions 00:10:00 Array Formulas 00:09:00 Displaying and Printing Formulas 00:08:00 Lookups and Data Tables Using Lookup Functions 00:14:00 Using MATCH and INDEX 00:06:00 Array Formulas 00:07:00 Advanced Data Management Validating Cell Entries 00:08:00 Exploring Database Functions 00:06:00 Exporting and Importing Exporting and Importing Text Files 00:11:00 Exporting and Importing XML Data 00:03:00 Querying External Databases 2 hours agoMore 00:09:00 Analytical Tools Goal Seek and Solver 00:15:00 The Analysis ToolPak 00:05:00 Scenarios 1 hour agoMore 00:06:00 Macros and Custom Functions Running and Recording a Macro 00:19:00 Working with VBA Code 00:07:00 Creating Functions 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2010 Excel Advanced - Complete Video Course
Delivered Online On Demand3 hours 48 minutes
£21

Kitchen Manager, Nutrition with Food Hygiene and Safety

4.7(26)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Kitchen Manager, Nutrition with Food Hygiene and Safety Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Unveil the secrets of a well-run, hygienic, and nutritious kitchen with our integrated course bundle, "Kitchen Manager, Nutrition with Food Hygiene and Safety." Learn from three QLS-endorsed courses that provide a comprehensive understanding of Kitchen Management, Nutrition, and Food Hygiene and Safety for Catering, coming with a hardcopy certificate upon completion. Moreover, expand your theoretical comprehension with five relevant CPD QS accredited courses. The topics covered include improving your Food Hygiene Rating, Catering Management, and principles of UK Cooking and Gastronomy. Also, delve into the importance of personal hygiene in the kitchen setting. Elevate your knowledge and proficiency with our "Kitchen Manager, Nutrition with Food Hygiene and Safety" bundle today. Key Features of the Kitchen Manager, Nutrition with Food Hygiene and Safety Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Kitchen Manager, Nutrition with Food Hygiene and Safety bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Kitchen Manager QLS Course 02: Nutrition-Diploma QLS Course 03: Level 2 Food Hygiene and Safety for Catering 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: How to Improve Your Food Hygiene RatingCourse 02: Catering - Catering managementCourse 03: UK Cooking and Gastronomy TechnicianCourse 04: Higher Technician in Cooking and Gastronomy Course 05: Personal Hygiene In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV WritingCourse 02: Job Search SkillsCourse 03: Self Esteem & Confidence BuildingCourse 04: Professional Diploma in Stress ManagementCourse 05: Complete Communication Skills Master Class Convenient Online Learning: Our Kitchen Manager, Nutrition with Food Hygiene and Safety courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the role and responsibilities of a Kitchen Manager. Gain a comprehensive understanding of Nutrition. Understand the importance of Food Hygiene and Safety in Catering. Learn how to improve your Food Hygiene Rating. Understand the principles of Catering Management. Learn the nuances of UK Cooking and Gastronomy. Understand the importance of personal hygiene in the kitchen setting. Gain an in-depth understanding of running a successful and safe kitchen with our course bundle. The QLS-endorsed courses provide a comprehensive overview of the responsibilities of a Kitchen Manager, the principles of Nutrition, and the importance of Food Hygiene and Safety in Catering. You will learn the theory behind creating nutritious menus, maintaining high hygiene standards, and effectively managing kitchen operations. The CPD QS accredited courses delve into various related topics like enhancing your Food Hygiene Rating, understanding UK cooking and gastronomy techniques, and managing a catering business. This bundle aims to equip you with the theoretical knowledge required to maintain a successful, healthy, and safe kitchen. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aiming to become effective Kitchen Managers. Professionals working in the catering industry interested in expanding their knowledge. Aspiring chefs and caterers seeking to improve their understanding of food hygiene and nutrition. Individuals interested in UK cooking and gastronomy. Career path Kitchen Manager - average salary in the UK: £24,000 - £38,000 Catering Manager - average salary in the UK: £20,000 - £35,000 Nutritionist - average salary in the UK: £23,000 - £45,000 Food Hygiene and Safety Inspector - average salary in the UK: £25,000 - £40,000 Gastronomy Chef - average salary in the UK: £25,000 - £50,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Kitchen Manager, Nutrition with Food Hygiene and Safety
Delivered Online On Demand41 hours
£309

HR, Payroll,Paye, Tax Professional Diploma

5.0(10)

By Apex Learning

Overview Gainup-to-date HR skills with the HR, Payroll,Paye, Tax Professional Diploma course. This HR, Payroll,Paye, Tax Professional Diploma course will provide you with an in-depth understanding of human resource management fundamentals and the skills to manage payroll expertly. It is designed to assist you to grasp every concept, from the basics to the advanced aspects.Boost your career with HR skills and gain the knowledge to work for leading companies. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this HR, Payroll,Paye, Tax Professional Diploma. It is available to all students, of all academic backgrounds. Requirements Our HR, Payroll,Paye, Tax Professional Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 16 sections • 47 lectures • 12:12:00 total length •Human Resource Management: 01:00:00 •HR Planning, Recruitment and Selection: 01:00:00 •Induction, Training and Development: 00:45:00 •HR Department's Responsibilities: 00:45:00 •The UK Recruitment Legislations Guide: 00:20:00 •Organisational Culture: 00:45:00 •Motivation, Counseling, Resignations and Retirement: 01:00:00 •Performance Appraisal: 00:45:00 •Remuneration Policy: 00:15:00 •Records and Statistics: 00:30:00 •Industrial Relations: 00:15:00 •The UK Recruitment Industry Statistics: 00:25:00 •Introduction to Payroll Management: 00:10:00 •An Overview of Payroll: 00:17:00 •Running the payroll - Part 1: 00:14:00 •Running the payroll - Part 2: 00:18:00 •Manual payroll: 00:13:00 •Benefits in kind: 00:09:00 •Computerised systems: 00:11:00 •Total Photo scenario explained: 00:01:00 •Brightpay conclude: 00:03:00 •Find software per HMRC Brightpay: 00:03:00 •Add a new employee: 00:14:00 •Add 2 more employees: 00:10:00 •Payroll settings: 00:04:00 •Monthly schedule - Lana: 00:14:00 •Monthly schedule - James: 00:08:00 •Directors NI: 00:02:00 •Reports: 00:02:00 •Paying HMRC: 00:05:00 •Paying Pensions: 00:04:00 •RTI Submission: 00:02:00 •Coding Notices: 00:01:00 •Journal entries: 00:07:00 •Schedule: 00:03:00 •AEO: 00:06:00 •Payroll run for Jan & Feb 2018: 00:13:00 •Leavers - p45: 00:03:00 •End of Year p60: 00:02:00 •Installing Brightpay: 00:13:00 •PAYE TAX: 00:13:00 •NI: 00:11:00 •Pensions: 00:06:00 •Online calculators: 00:07:00 •Payslips: 00:03:00 •Journal entries: 00:07:00 •Conclusion and Next Steps: 00:08:00

HR, Payroll,Paye, Tax Professional Diploma
Delivered Online On Demand12 hours 12 minutes
£12

Payroll Management and Systems Diploma

4.3(43)

By John Academy

Description: Payroll is the process by which employers pay an employee for the work they have completed. Any business with employees should have a payroll process established; payroll is often the largest expense for a business. If you want to learn how to perform payroll, gross pay, RTI and more, then this will be the perfect choice for you. This Payroll Management and Systems Diploma is all about payroll management, how to calculate the payroll and general overall understanding about what payroll is and the legal requirements in place, the forms, the deadlines, the process and procedures. The course will develop your skills in how to effectively perform a payroll run, understand statutory deductions, PAYE and real time income. Whether you currently work in finance, or wanting to work in finance, run your own business or simply want to gain a new skills then you should join us today! 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? Payroll Management and Systems Diploma 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 Payroll Management and Systems Diploma 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. Introduction Introduction to the Course and Instructor FREE 00:10:00 An Overview of Payroll 00:17:00 The UK Payroll System Running the payroll - Part 1 00:14:00 Running the payroll - Part 2 00:18:00 Manual payroll 00:13:00 Benefits in kind 00:09:00 Computerised systems 00:11:00 Total Photo scenario explained 00:01:00 Brightpay Brightpay conclude 00:03:00 Find software per HMRC Brightpay 00:03:00 Add a new employee 00:14:00 Add 2 more employees 00:10:00 Payroll settings 00:04:00 Monthly schedule - Lana 00:14:00 Monthly schedule - James 00:08:00 Directors NI 00:02:00 Reports 00:02:00 Paying HMRC 00:05:00 Paying Pensions 00:04:00 RTI Submission 00:02:00 Coding Notices 00:01:00 Journal entries 00:07:00 102 Schedule 00:03:00 AEO 00:06:00 Payroll run for Jan & Feb 2018 00:13:00 Leavers - p45 00:03:00 End of Year p60 00:02:00 Installing Brightpay 00:13:00 Paye, Tax, NI PAYE TAX 00:13:00 NI 00:11:00 Pensions 00:06:00 Online calculators 00:07:00 Payslips 00:03:00 Conclusion and Next Steps Conclusion and Next Steps 00:07:00 Assessment Assignment - Payroll Management and Systems Diploma 00:00:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Payroll Management and Systems Diploma
Delivered Online On Demand4 hours 19 minutes
£25

Version 2 - How to use CAD Heat Engineer Software 15th Feb 4pm

3.7(8)

By Heat Engineer

This is designed to be an introduction into how to start a room by room survey using the new CAD Heat Engineer feature, using the online dashboard. We will then go through the different steps to complete this heat loss report. Optional pages will also be worked through and shown. Examples of how to select the flow temperature and the heat source (heat pumps and boilers) will be presented once the heat loss result is completed.

Version 2 - How to use CAD Heat Engineer Software 15th Feb 4pm
Delivered OnlineJoin Waitlist
£47.93

HR, Payroll and Recruitment - 3 Courses in 1 Bundle

By Lead Academy

Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this HR, Payroll and Recruitment - 3 in 1 course will set you up with a solid foundation to become a confident Payroll Administrator and develop more advanced skills. This comprehensive course is the perfect way to kickstart your career in the field of Payroll Management. This course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. How Will I Benefit? Boost your career in Payroll Management Deepen your knowledge and skills in your chosen field just in hours not years! Study a course that is easy to follow. Save money and time by studying at your convenient time Have access to a tutor whenever you are in need So, what are you thinking about! Start getting the benefits by enrolling today! Why Choose Lead Academy: Lifetime Access High-quality e-learning study materials Learn the most in-demand skills Self-paced, no fixed schedules 24/7 customer support through email Available to students anywhere in the world No hidden fee Study in a user-friendly, advanced online learning platform Who is this course for? This comprehensive course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Payroll Management. Entry Requirement There are no academic entry requirements for this course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Course Curriculum HR Administrator Module 01: Introduction To HRM Module 02: Define HRM Module 03: Scope of HRM Module 04: Processes in HRM Module 05: Skills of HR Professionals Module 06: HRM & Performance Management Module 07: Hiring Strategies Module 08: Various Retention Strategies Module 09: Human Resource Planning Module 10: Managing Employee's Performance Module 11: Management of Contractors Module 12: Strategic HRM Module 13: Global HRM Module 14: HR Information System Module 15: Tips for Effective HRM Introduction Introduction to the Course and Instructor An overview of Payroll The UK Payroll System Running the payroll - Part 1 Running the payroll - Part 2 Manual payroll Benefits in kind Computerised systems Total Photo scenario explained Brightpay Find software per HMRC Brightpay Installing Brightpay Add a new employee Add 2 more employees Payroll settings Monthly Schedule - Lana Monthly Schedule - James Directors NI Reports Paying HMRC Paying Pensions RTI Submission Coding Notices 102 Schedule AEO Payroll run for Jan & Feb 2018 Leavers - p45 End of Year p60 Brightpay conclude Paye, Tax, NI PAYE Tax NI2 Pensions Online calculators Payslips Journal entries Conclusion and Next Steps Conclusion and Next Steps Recruitment Consultant Recruitment Skills - Introduction What is Recruitment? Importance of Recruitment Sources of External Recruitment Sources of Internal Recruitment Various Approaches to Recruitment Recruitment Process Factors Affecting the Process Stages of Recruitment Explain the Selection Process Various Selection Tests Types of Interview Developing Good Interviewing Skills Body Language Cues in Interviews Qualities of a Good Recruiter Talent Acquisition Specialist Payroll Administrator Training Certificate of Achievement Certificate of Achievement from Lead Academy On successful completion of the course, 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. You/your employer can verify your certificate through our website. 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

HR, Payroll and Recruitment - 3 Courses in 1 Bundle
Delivered Online On Demand
£129

Food Hygiene Level 3

5.0(2)

By Intellelearn

This online Level 3 Food Hygiene course is essential for anybody wanting to advance their career in the Food and Drink Industry. The course is also ideal for people running their own business and wanting to operate legally and safely.

Food Hygiene Level 3
Delivered Online On Demand1 hour
£25

CUIC11.6EU-Cisco Unified Intelligence Center 11.6 for End Users

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for The primary audiences for the course are as follows: Cisco customers ? Contact Center Management, Contact Center Supervisors and Customer technical personnel Cisco technology partners Cisco employees Overview Upon completing this course, the learner will be able to meet these overall objectives: Provide a comprehensive overview of Cisco Unified Intelligence Center Describe reporting concepts and capabilities and features of Cisco Unified Intelligence Center reports Provide a detailed description and labs of how to modify reports from normal data sources (Cisco Unified CCE and Cisco Unified CVP) by customizing reports using various methods. (i.e. creating thresholds, show/hide columns, charts and more) The Cisco Unified Intelligence Center 11.6 for End Users (CUIC11.6EU v1.1) course is a two-day instructor-led training (ILT) course. Cisco Unified Intelligence Center is a comprehensive, end-to-end reporting solution, designed to make the task of creating and modifying reports easier on the customer and, at the same time, to present a consistent user interface and a common tool to access varied data across multiple Cisco product families. Cisco Unified Intelligence Center Overview Introducing Cisco Unified Intelligence Center What Contact Center products use CUIC for reporting Cisco Unified Intelligence Center Administration and Security The End User and CUIC Security Running and Modifying CUIC Reports Running Cisco Unified Intelligence Center Reports Using Permalinks Help Dashboards Modifying a CUIC Stock Report Cisco Unified Intelligence Center Dashboards Understanding Cisco Unified CCE Key Concepts Creating a New Cisco Unified Intelligence Center Report

CUIC11.6EU-Cisco Unified Intelligence Center 11.6 for End Users
Delivered OnlineFlexible Dates
Price on Enquiry

Microsoft Excel Macros & VBA - Online classroom

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Excel Macros & VBA - Online  classroom
Delivered OnlineFlexible Dates
£550

Financial Documents 101

By OnlineCoursesLearning.com

Financial Documents 101 Monetary records assume a basic part in running little and huge organizations. The records help organizations of numerous sorts in various enterprises to convey their monetary data to outer gatherings or elements like financial backers and banks. The monetary reports sum up a business' bookkeeping methods and highlights money and record title arrangements. The monetary reports likewise grandstand the monetary status or position and execution of an organization or individual, remembering changes for accounts over a predefined period. Organizations target utilizing the assertions to impart monetary choices to inner and outside gatherings to assist with financial choices. Information sourced from business monetary frameworks are utilized to total, gather and work on the advancement of monetary reports. The assertions basically show results from an organization's bookkeeping framework. The monetary archives are typically evolved and delivered on a yearly premise each monetary year. This course has been intended to acquaint you with the nuts and bolts of monetary reports. Right off the bat, we characterize monetary records and clarify what they are. The course additionally momentarily clarifies what goes into making fiscal summaries. Then, we cover the four fundamental kinds of budget reports that you should think about. The course presents every assertion and clarifies what they do and include. It likewise clarifies the part of every assertion in the activity of a business and in the existence of people. At long last, we express a few advantages of monetary reports to the business, including outside substances, like moneylenders and financial backers. You Will Learn: What monetary reports are The reason for monetary archives The four fundamental kinds of monetary reports The highlights of various sorts of monetary reports The advantages of monetary records to business elements Advantages of Taking This Course: Taking this course will help you: Know the various kinds of monetary archives Lean the capacity of each kind of monetary record Know the various highlights of each monetary record Comprehend the part of monetary records in business Gain essential information on monetary reports Find out about the advantages of monetary records to organizations Decide whether you need to get familiar with monetary reports

Financial Documents 101
Delivered Online On Demand
£50