Learn to use Excel’s most powerful features on this 2-day advanced Excel training course. This course is hands-on. It includes plenty of time to experiment with what you are being taught and ask questions. By the time you finish, you’ll be an expert Excel user. ✔ A complete course that covers all of Excel’s most advanced functions. ✔ Friendly expert trainers, small groups and a comfortable place to learn. ✔ Ongoing support & help with any issues you may have after the course. Our courses are delivered in Guildford, London, Online, or even on-site at your offices!
Whether you’re entering the job market, switching careers, or aiming to stand out in your current role, this 20-in-1 Functional Skills bundle gives you the workplace fundamentals that every employer wants—across every sector. Description Functional skills are the building blocks of employability. Employers across industries—from administration to customer service, healthcare to logistics—look for candidates who can communicate effectively, manage time, handle basic IT tasks, and adapt under pressure. This bundle blends essential English, Maths, and IT skills with key workplace competencies such as Microsoft Office, operations management, and communication. It’s ideal for jobseekers, apprentices, and those looking to brush up on core skills that never go out of demand. And with 20 career-ready courses rolled into one value-packed bundle, it’s a smarter, more affordable way to increase your hireability now—before someone else takes your place on the shortlist. FAQ Q: Who is this bundle best suited for? A: Anyone looking to improve employability across sectors like retail, admin, hospitality, education, or customer service. Q: Will this help with apprenticeship or entry-level job applications? A: Absolutely—these skills are often essential for foundational roles. Q: Can it help adults return to education or training? A: Yes, it's designed for learners at all stages, including adult returners. Q: Is this recognised in professional settings? A: While not an accredited qualification, the skills are highly transferable and job-relevant. Q: Do I get lifetime access to the content? A: Yes—study anytime, at your own pace.
Modern project teams rely on more than managers—they rely on smart, organised, and proactive support professionals. This Project Support Officer: 20-in-1 bundle gives you the edge to break into PMO teams, consultancy, and corporate operations with confidence. Description Project support roles are the unsung heroes behind major business outcomes—and employers are constantly on the lookout for those who bring structure, communication, and coordination to fast-moving projects. This bundle arms you with versatile training for roles in project coordination, business support, admin teams, and public sector delivery units. With added certifications in Agile, Lean, and Microsoft Office tools, this package appeals to employers across industries—whether in construction, tech, logistics, or government. You’ll build the kind of profile that gets noticed in job boards and internal promotions. For a single price, gain 20 job-ready credentials and prove you’re more than just admin—you’re the backbone of project delivery. Secure your spot before the next job posting closes. FAQ Q: Who is this bundle aimed at? A: Ideal for aspiring project coordinators, support officers, executive assistants, and PMO team members. Q: What sectors does it apply to? A: Construction, software, logistics, public sector, finance, and professional services. Q: Do I need project experience first? A: Not at all—this bundle is designed for new entrants and those upskilling from admin roles. Q: Are certificates included? A: Yes—each course comes with its own certificate for your portfolio. Q: Is the training flexible? A: Yes, all content is available with lifetime access and can be studied anytime.
Office Skills & Administration (Office Management) Training for Receptionist & Executive PA Enhance your communication, time management, and problem solving skills with our Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course! Are you willing to lead the managerial function in an organisation? Our Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course is a comprehensive program for you to enhance your knowledge and skills in this field. The Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course is divided into 13 modules, each of which focuses on a distinct management topic. The Foundations of Office Administration and the Basics of Microsoft Office Skills are covered in order in the Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. You will learn about mail services, shipment information, and quality maintenance from our Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. This Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course module will show you how to manage risks and challenges that you may encounter in your professional life. You will also learn business strategy, etiquette rule-making, and marketing technology in this Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. You could look into a variety of job options after completing the Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. Don't pass up this chance to make an investment in your future. Enroll in the Office Management and Administration course right away to begin your successful learning journey. Learning Outcomes Know about the fundamentals of Office Administration. Recognize the opportunities in Office Administration. Learn about the requirements, duties and responsibilities of Office Administration. Get knowledge about how to develop effective skills for office management and administration and how to become a great office administrator. Get an overview of shipping and mail services in the UK. Learn about royal mail services and the alternatives to royal mail. Understand the ways to create effective plans and schedules and Work Breakdown Structure (WBS)in project management. Get the ultimate guide to project planning. Recognize the importance and processes of risk management. Acknowledge effective techniques and skills to develop business writing skills. Know about business document structure, meaning and the importance of editing and Proofreading. Get an overview of time management. Learn about the basics of Microsoft Office Skills and the key benefits of using Microsoft Office Skills. Main Course: Level 5 Office Management and Administration Free Courses are including with this Office Skills & Administration (Office Management) Training for Receptionist & PA Course Along with The Level 5 Office Management and Administration Course, We Offer a free Diploma in Medical Receptionist and Secretary Course Along with The Level 5 Office Management and Administration Course, We Offer a free Executive Secretary & PA Training Course Special Offers of this Office Skills & Administration (Office Management) Training for Receptionist & PA Course This Office Skills & Administration (Office Management) Training for Receptionist & PA Course includes a FREE PDF Certificate. Lifetime access to this Office Skills & Administration (Office Management) Training for Receptionist & PA Course Instant access to this Office Skills & Administration (Office Management) Training for Receptionist & PA Course Get FREE Tutor Support to this Office Skills & Administration (Office Management) Training for Receptionist & PA Course Office Skills & Administration (Office Management) Training for Receptionist & Executive PA The Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course will help you better understand Job Search and Interview Skills and other important topics. You will have learned all of the necessary skills and knowledge to be successful in this sector after completing the Office Administration and Management course. The office management and administration course will help you better understand Job Search and Interview Skills and its key areas. You will have achieved all of the necessary skills and knowledge to be successful in this industry by completing an Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate course. Who is this course for? Office Skills & Administration (Office Management) Training for Receptionist & Executive PA For individuals hoping to get a head start or who want to become future professionals in this Office Management and Administration field, the Office Management and Administration course is perfect. This Office Management and Administration course has been created to strengthen your CV and increase your competence. Requirements Office Skills & Administration (Office Management) Training for Receptionist & Executive PA To enrol in this Office Skills & Administration (Office Management) Training for Receptionist & PA Certificate Course, students must fulfil the following requirements. To join in our Course, you must have a strong command of the English language. To successfully complete our Course, you must be vivacious and self driven. To complete our Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Course. Career path Office Skills & Administration (Office Management) Training for Receptionist & Executive PA You will be able to grasp your abilities for a career in the appropriate employment field, such as: Office Management Assistant, Officer, or Office Management and Administration, after completing the Office Management and Administration course.
Duration 1 Days 6 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3. 1. Using VBA to Solve Business Problems Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) 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 VBA with Microsoft Excel (v1.2) 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.
Duration 1 Days 6 CPD hours This course is intended for To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers. Overview Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation. This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data. Getting Started with Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter and Edit Cell Data Fill Cells with Series of Data (AutoFill and Flash Fill) Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions and use Autocomplete Reuse Formulas and Functions Create an Absolute Reference Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Move and Copy Data between Cells Search for and Replace Data Use Spellcheck and Proofing Formatting a Worksheet Apply Text Formats Apply Number Formats Align Cell Contents Apply and Copy Cell Styles Apply Basic Conditional Formatting Printing Workbooks Preview and Print a Workbook Controlling Page Layout Adding Headers and Footers Set Print Titles and Print Ranges Managing Workbooks Manage Worksheets Insert and Delete Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties