10275 Office courses

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 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 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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 Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office 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

Thursday 3 July,10am - 12.30pm    Are you interested in developing programmes and exhibits with LGBTQ+ content for children and families?    About this training    During this training session, we will address the challenges museum staff and volunteers face when creating LGBTQ+ content for children and families. Alongside this we will discuss strategies for advocating for this content and explore resources for planning and implementation.    This webinar will be led by Margaret Middleton, a freelance exhibit designer and museum consultant based in Manchester. Their background is in children's museums and they have written and consulted widely on creating LGBTQ+ museum content for families, especially those with children aged 10 and under.    Margaret will be joined by Dylan Saul, Family Programmes Facilitator and Moa Strand, Families and Young People Programmes Manager at Royal Museums Greenwich and Daniel Jessop, Learning and Community Engagement Officer at Novium Museum, who will talk about their LGBTQ+ work for children and families.     The session will help you to:  Understand the importance of this work, Think critically about the challenges you may face undertaking this work, Develop ways to advocate for this work, Gain inspiration from case studies to take your own work forward.   Take a look at the full schedule.    This training event will be delivered virtually on Zoom over one half-day session (two hours and 30 minutes with a short break).     Who should attend?  This training is aimed at staff and volunteers who work in museums, art galleries and heritage sites and are interested in developing programmes and exhibits with LGBTQ+ content for children and families.   

Course Overview Secretaries and Personal Assistants are integral to the smooth running of a business, making sure that office procedures are maintained effectively and everyday administrative duties are completed to a high standard. They are responsible for managing meetings, greeting clients, maintaining records, and other key office support duties.  In this Personal Assistant Training Course, you will develop all the essential skills needed to fast track your career in this field, equipping you with practical knowledge that will help boost your earning potential. It will guide you through a range of office procedures, from organising your binder and workspace to Microsoft Office training and putting together an office procedure guide. Not only that, but you will learn how to build a positive relationship with your manager and learn strategies for building your professional image. Stand out to prospective employers with this accredited Personal Assistant Training Course! What You Will Learn In this Executive Personal Assistant Course, you'll learn a range of administrative and transferable skills needed to provide quality office support. It provides essential information on key office procedures, as well as strategies for improving your efficiency in the workplace. Fundamental Office Administrative Procedures Putting Together The office Procedure Guide What You Should Include in Your Binder Verbal & Nonverbal Communication Skills Steps to Effective Meeting Management Microsoft Word, Excel & PowerPoint Training Effective Time Management Strategies Building a Strong Working Relationship With Your Manager Building Your Self-Esteem and Professional Image Influencing and Negotiating Techniques Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course.

Already possess the ADR Core & Packages qualification? Level up with our 1.5-Day Tanks Add-On Course!  Learn online, but exams must be taken in person at our Grantham Training Centre. Why Choose Our ADR Tanks Add-On Course? Convenient and Time-Saving: Complete your ADR Tanks qualification in just 1.5 days, saving you valuable time and resources. Comprehensive Preparation: Receive in-depth coverage of all areas of the syllabus for the ADR Tanks examination, ensuring you're well-equipped to succeed. Flexible Online Delivery: Attend the course from the comfort of your own home or office via Zoom, while still receiving the same high-quality training. In-Person Exam for Certification: Take the final exam in person at our Grantham office under exam conditions to receive your official ADR Vocational Training Licence from the SQA. Benefits of Attending: Gain the ADR Tanks qualification without retaking the entire 5-day course. Prepare thoroughly for the ADR Tanks examination with comprehensive course content. Benefit from the flexibility of online training while receiving personalised attention during the in-person exam. Earn up to 7 hours towards Driver CPC periodic training with an additional fee. Course Details: Duration: 1.5 days (7 hours towards Driver CPC for an additional fee) Examinations: In-person exam at our Grantham office Course Content: All areas of the syllabus for ADR Tanks examination, including: Classification of dangerous goods in Class 3Packaging and labeling of Class 3 dangerous goods, Vehicle requirements for the carriage of Class 3 dangerous goods, Loading and unloading procedures for Class 3 dangerous goods, Emergency procedures for Class 3 dangerous goods. Who Should Attend? This course is designed for ADR Core & Packages qualified drivers who need to add the ADR Tanks qualification to their credentials. Fees Include: Online training materials In-person exam Exams fee Booking: Secure your spot today by booking your ticket through Cademy or contacting us at 0345 9001312. Please note that all bookings are non-refundable and non-exchangeable. Don't miss out on this valuable opportunity to expand your ADR qualifications and enhance your career prospects. Please review our Terms and Conditions for more information.

***Transform Yourself: From Beginner to Legal Secretary in One Course*** Did you know according to a recent report, the demand for Legal Secretaries is expected to grow by 5% in the next few years? This essential role provides the foundation for a successful legal career. If you're looking to step into the exciting world of law, this legal course comprehensive course equips you with the knowledge and skills to thrive as a Legal Secretary. This Legal Secretary - Legal Office Administration and Support course is designed to provide a theoretical grounding in all the key areas a Legal Secretary needs to excel. Through a series of engaging modules, you'll gain a thorough understanding of English Law, legal terminology, and essential secretarial practices. Learning Outcomes By the end of this Legal Secretary - Legal Office Administration and Support course, you will be able to: Gain a thorough understanding of the legal secretary's role and responsibilities within a legal practice. Develop a strong foundation in English Law and the legal systems that govern the UK. Master the fundamentals of contract law, tort law, wills & probate, property law, criminal law, and family law. Hone your skills in professional writing, document creation, proofreading, and editing. Learn effective meeting management, minute-taking techniques, and data management practices. Develop a comprehensive understanding of human rights and their application in legal contexts. Key Highlights for Legal Secretary - Legal Office Administration and Support Course: CPD QS Accredited Proficiency with this Legal Secretary course. After successfully completing the Legal Secretary course, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Legal Secretary course. The online test with immediate results You can study and complete the Legal Secretary course at your own pace. Study for the Legal Secretary course using any internet-connected device, such as a computer, tablet, or mobile device. This Legal Secretary - Legal Office Administration and Support course is your gateway to a fulfilling career as a Legal Secretary. Throughout the course, you'll delve into various legal areas, including contract law, tort law, wills & probate, property law, criminal law, family law, and business law. You'll gain insights into the legal systems within the UK and explore the intricacies of legal documents. The Legal Secretary course also emphasizes the importance of communication, interpersonal skills, and organization, all essential for success as a Legal Secretary. Furthermore, you'll develop proficiency in document proofreading, editing, and minute-taking, ensuring accuracy and efficiency in your daily tasks. The Legal secretary course also covers essential secretarial skills like data management, record-keeping, and meeting management, equipping you to provide exceptional support to lawyers and legal teams. Curriculum Breakdown of the Legal Secretary - Legal Office Administration and Support Course Module 01: Introduction to Legal Secretary Module 02: English Law & Legal Systems Module 03: Law of Contract & Law of Tort Module 04: Wills, Probate, Estate Law Module 05: Property Law & Conveyancing Practice Module 06: Criminal Law Module 07: Understanding Criminal Psychology Module 08: Contract & Business Law Module 09: Family Law and Insurance Practice Module 10: Conflict and Conflict Resolution Module 11: Professional Writings and Documents Module 12: Document Proofreading and Editing Module 13: Meeting Management & Minute Taking Module 14: Data Management and Record-Keeping Module 15: Other Essential Skills for Secretarial Role Module 16: Human Rights CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Legal Secretary - Legal Office Administration and Support course is suitable for: Individuals with an interest in a career in law. Those seeking to become a Legal Secretary. Professionals looking to enhance their legal knowledge and secretarial skills. Graduates seeking entry-level positions in the legal sector. Career changers interested in transitioning into the legal field. Anyone who wants to gain a foundational understanding of the legal system. Requirements There are no specific prerequisites for this Legal Secretary - Legal Office Administration and Support However, a basic understanding of legal terminology and strong written communication skills will be beneficial. Career path This Legal Secretary - Legal Office Administration and Support course provides a strong foundation for a fulfilling career as : Paralegal Legal Assistant Solicitor (with further qualifications) Legal Compliance Officer Legal Consultant Legal Case Manager ***Enroll today and take the first step towards becoming a successful Legal Secretary!*** Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Dynamic Arrays in Microsoft Excel Training Course Overview Are you looking to begin your Microsoft Office Excel career or want to develop more advanced skills in Microsoft Office Excel? Then this dynamic arrays in Microsoft Excel training course will set you up with a solid foundation to become a confident office admin and help you to develop your expertise in Microsoft Office Excel. This dynamic arrays in Microsoft Excel training course is accredited by the CPD UK & IPHM. 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. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this dynamic arrays in Microsoft Excel training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as an office admin. The dynamic arrays in Microsoft Excel training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as an office admin. This comprehensive dynamic arrays in Microsoft Excel training course is the perfect way to kickstart your career in the field of Microsoft Office Excel. This dynamic arrays in Microsoft Excel training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as an office admin or want to learn more skills on Microsoft Office Excel but unsure of where to start, then this dynamic arrays in Microsoft Excel training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. 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 dynamic arrays in Microsoft Excel training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive dynamic arrays in Microsoft Excel training 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 Microsoft Office Excel. Entry Requirement There are no academic entry requirements for this dynamic arrays in Microsoft Excel training 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. Method of Assessment On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately.. Career path This dynamic arrays in Microsoft Excel training course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. 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. Quality Licence Scheme Endorsed 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.     Certificate of Achievement 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

Overview of Admin, Secretarial & PA Training In today’s busy UK business world, skilled administrative staff are vital to keeping things running smoothly. The Admin, Secretarial & PA Training sector is a growing £2.8 billion industry, with over 1.2 million professionals working across the country. From large companies in London to smaller businesses in Manchester and Birmingham, trained administrative professionals are always needed. This Admin, Secretarial & PA Training course is designed to help motivated individuals become strong and reliable office support staff. Through this course, learners will study useful Admin, Secretarial & PA Training modules that include personal assistance, managing office tasks, and staying organised. You will also build important skills such as proper telephone manners, writing professional emails and letters, and handling daily responsibilities in a clear and efficient way. Topics like time management, clear communication, arranging meetings, and working with Excel and PowerPoint are all part of the training. These skills help learners stand out when applying for jobs. Admin, Secretarial & PA Training is a smart choice for those who want steady work and career growth. With admin roles growing by 15% every year and average pay around £35,000, this training can lead to rewarding job opportunities. Whether helping top managers or running a busy office, learners finish the course with all the important skills needed in today’s workplace. Learning Outcomes By the end of this Admin, Secretarial & PA Training course, learners will be able to: Provide strong personal assistant and administrative support Organise tasks and manage office work smoothly Answer calls and write emails or letters professionally Manage time well and communicate clearly with others Plan and arrange meetings while understanding body language Use Excel and PowerPoint to complete office jobs Who Is This Course For? This Admin, Secretarial & PA Training is ideal for: People changing careers who want to start in admin roles with a solid base in secretarial and office support School leavers or graduates who want to build important office skills like time management, business writing, and Microsoft Office before starting work Current admin workers wanting to learn more about meeting planning, organising work better, and improving communication Those returning to work after a break and needing to refresh their admin knowledge and learn new tools Small business owners who want to handle office work, client communication, and schedules on their own Process of Evaluation After studying the Admin, Secretarial & PA Training Course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Admin, Secretarial & PA Training Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Career Path Completing this Admin, Secretarial & PA Training can lead to the following roles: Personal Assistant – £18,000 to £35,000 per year Administrative Assistant – £16,000 to £28,000 per year Office Manager – £22,000 to £40,000 per year Executive Secretary – £20,000 to £38,000 per year Reception Manager – £18,000 to £30,000 per year

Register on the Work Area Organisation for Increased Office Productivity today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Work Area Organisation for Increased Office Productivity is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Work Area Organisation for Increased Office Productivity Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Work Area Organisation for Increased Office Productivity, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Work Area Organisation for Increased Office Productivity Module 01: Introduction 00:01:00 Module 02: Purge 00:02:00 Module 03: Redistributing 00:04:00 Module 04: Fences Software 00:04:00 Module 05: Create Work Spaces 00:06:00 Module 06: Proximity 00:04:00 Module 07: Lable What You Can 00:03:00 Module 08: Move to Digital 00:03:00 Module 09: Clean Your Desk Off 00:03:00 Module 10: Multiple Inboxes 00:03:00 Module 11: Mailings 00:03:00 Module 12: Discard Dates 00:03:00 Module 13: Magazines 00:02:00 Module 14: File Weekly 00:03:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

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

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