3413 Office Skills & Productivity courses in Stockport delivered Online

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback 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 classrom, 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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

Are you looking to enhance your Office Skills : Secretarial & PA Training skills? If yes, then you have come to the right place. Our comprehensive course on Office Skills : Secretarial & PA Training will assist you in producing the best possible outcome by mastering the Office Skills : Secretarial & PA Training skills. The Office Skills : Secretarial & PA Training course is for those who want to be successful. In the Office Skills : Secretarial & PA Training course, you will learn the essential knowledge needed to become well versed in Office Skills : Secretarial & PA Training. Our Office Skills : Secretarial & PA Training course starts with the basics of Office Skills : Secretarial & PA Training and gradually progresses towards advanced topics. Therefore, each lesson of this Office Skills : Secretarial & PA Training course is intuitive and easy to understand. Why would you choose the Office Skills : Secretarial & PA Training course from Compliance Central: Lifetime access to Office Skills : Secretarial & PA Training course materials Full tutor support is available from Monday to Friday with the Office Skills : Secretarial & PA Training course Learn Office Skills : Secretarial & PA Training skills at your own pace from the comfort of your home Gain a complete understanding of Office Skills : Secretarial & PA Training course Accessible, informative Office Skills : Secretarial & PA Training learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Office Skills : Secretarial & PA Training Study Office Skills : Secretarial & PA Training in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Office Skills : Secretarial & PA Training Course Office Skills : Secretarial & PA Training Curriculum Breakdown of the Office Skills : Secretarial & PA Training Course Module 01: Introduction to Admin Support Assistant Module 02: Introduction to Personal Assistant Module 03: Introduction to Office Administration Module 04: Skills of an Effective Administrator Module 05: Introduction to Reception and Receptionist Module 06: Business Telephone Skills Module 07: Representing Your Boss and Company Module 08: Business Etiquette Module 09: Mail Services and Shipping Module 10: Travel Arrangements Module 11: Organising Meeting and Conferences Module 12: Diary Management and Note taking Module 13: Time Management Module 14: Record Keeping and Filing Systems Module 15: Business Writing Skills Module 16: Organisational Skills Module 17: Communication Skills Module 18: Customer Service Module 19: Effective Planning and Scheduling Module 20: Invoicing Petty Cash CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Office Skills : Secretarial & PA Training course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Office Skills : Secretarial & PA Training. It is also great for professionals who are already working in Office Skills : Secretarial & PA Training and want to get promoted at work. Requirements To enrol in this Office Skills : Secretarial & PA Training course, all you need is a basic understanding of the English Language and an internet connection. Career path The Office Skills : Secretarial & PA Training course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Office Skills : Secretarial & PA Training. 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

Are you ready to elevate your administrative career to new heights? Our Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking Course is designed to empower you with the essential skills and knowledge needed to excel in today's fast-paced business environment. According to Reed a Executive Secretary can earn from £40,000 to £50,000 in a year depending on qualification, experience, location and other factors. Join our Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking course and become the indispensable right-hand person every executive dreams of. Key Features This Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking Course Includes: CPD Certified Office Skills: Admin, Secretarial & PA (Executive PA) Course Free Certificate from Reed CIQ Approved Office Skills: Admin, Secretarial & PA (Executive PA) Course Developed by Specialist Lifetime Access Course Curriculum of Office Skills: Admin, Secretarial & PA (Executive PA) Course: Module 1: Foundational Skills 1.1 Introduction to Personal Assistant 1.2 Telephone Etiquette for Business 1.3 Effective Business Writing 1.4 Enhancing Communication Skills Module 2: Representing the Company 2.1 Advocating for Your Boss and Company 2.2 Excellence in Customer Service Module 3: Organizational Skills 3.1 Organizational Skills 3.2 Successful Planning and Scheduling 3.3 Mastering Time Management Module 4: Record Keeping & Documentation 4.1 Maintaining Records and Filing Systems 4.2 Invoicing and Petty Cash Procedures Module 5: Meeting and Event Management 5.1 Coordination of Meetings and Conferences 5.2 Arranging Travel Logistics 5.3 Introduction to Minute Writing 5.4 Preparing for Minute-Taking 5.5 Understanding the Meeting Structure 5.6 Documenting Meetings, Decisions, and Actions 5.7 Techniques for Minute Taking 5.8 Building Confidence in Meeting Facilitation Module 6: Specialized Roles & Services 6.1 Handling Mail Services and Shipping Learning Outcomes: Understand roles of a PA and key communication techniques. Develop proficiency in business writing and telephone etiquette and Office Skills. Master organisational techniques for effective planning and scheduling. Implement record-keeping systems, including filing and invoicing. Coordinate meetings, conferences, and travel arrangements efficiently. Acquire expertise in minute taking and building confidence in related tasks. CPD 10 CPD hours / points Accredited by CPD Quality Standards Section 1: Foundational Skills 1:06:33 1: 1.1 Introduction to Personal Assistant 10:33 2: 1.2 Telephone Etiquette for Business 11:04 3: 1.3 Effective Business Writing 28:35 4: 1.4 Enhancing Communication Skills 16:21 Section 2: Representing the Company 32:55 5: 2.1 Advocating for Your Boss and Company 23:01 6: 2.2 Excellence in Customer Service 09:54 Section 3: Organizational Skills 1:13:39 7: 3.1 Organizational Skills 17:05 8: 3.2 Successful Planning and Scheduling 33:19 9: 3.3 Mastering Time Management 23:15 Section 4: Record Keeping & Documentation 35:09 10: 4.1 Maintaining Records and Filing Systems 17:30 11: 4.2 Invoicing and Petty Cash Procedures 17:39 Section 5: Meeting and Event Management 1:27:40 12: 5.1 Coordination of Meetings and Conferences 17:24 13: 5.2 Arranging Travel Logistics 14:19 14: 5.3 Introduction to Minute Writing 09:55 15: 5.4 Preparing for Minute-Taking 12:56 16: 5.5 Understanding the Meeting Structure 08:53 17: 5.6 Documenting Meetings, Decisions, and Actions 08:45 18: 5.7 Techniques for Minute Taking 07:52 19: 5.8 Building Confidence in Meeting Facilitation 07:36 Section 6: Specialized Roles & Services 18:15 20: 6.1 Handling Mail Services and Shipping 17:15 21: Leave A Review 01:00 Who is this course for? This Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking. Moreover, this course is ideal for: Individuals aspiring to administrative and secretarial roles. Employees seeking to enhance their office management capabilities. Professionals looking to upgrade their organisational skills. Individuals preparing for roles as executive PAs. Staff wanting to refine their communication and representation techniques. Anyone who wants to know more about Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking course. Requirements There are no requirements needed to enrol into this Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking course. We welcome individuals from all backgrounds and levels of experience to enrol into this Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking course. Career path After finishing this Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking are: Personal Assistant Executive Secretary Administrative Coordinator Office Manager Event Coordinator Travel Coordinator Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you ready to elevate your administrative career to new heights? Our Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking Course is designed to empower you with the essential skills and knowledge needed to excel in today's fast-paced business environment. According to Reed a Executive Secretary can earn from £40,000 to £50,000 in a year depending on qualification, experience, location and other factors. Join our Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking course and become the indispensable right-hand person every executive dreams of. Key Features This Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking Course Includes: CPD Certified Office Skills: Admin, Secretarial & PA (Executive PA) Course Free Certificate from Reed CIQ Approved Office Skills: Admin, Secretarial & PA (Executive PA) Course Developed by Specialist Lifetime Access Course Curriculum of Office Skills: Admin, Secretarial & PA (Executive PA) Course: Module 1: Foundational Skills 1.1 Introduction to Personal Assistant 1.2 Telephone Etiquette for Business 1.3 Effective Business Writing 1.4 Enhancing Communication Skills Module 2: Representing the Company 2.1 Advocating for Your Boss and Company 2.2 Excellence in Customer Service Module 3: Organizational Skills 3.1 Organizational Skills 3.2 Successful Planning and Scheduling 3.3 Mastering Time Management Module 4: Record Keeping & Documentation 4.1 Maintaining Records and Filing Systems 4.2 Invoicing and Petty Cash Procedures Module 5: Meeting and Event Management 5.1 Coordination of Meetings and Conferences 5.2 Arranging Travel Logistics 5.3 Introduction to Minute Writing 5.4 Preparing for Minute-Taking 5.5 Understanding the Meeting Structure 5.6 Documenting Meetings, Decisions, and Actions 5.7 Techniques for Minute Taking 5.8 Building Confidence in Meeting Facilitation Module 6: Specialized Roles & Services 6.1 Handling Mail Services and Shipping Learning Outcomes: Understand roles of a PA and key communication techniques. Develop proficiency in business writing and telephone etiquette and Office Skills. Master organisational techniques for effective planning and scheduling. Implement record-keeping systems, including filing and invoicing. Coordinate meetings, conferences, and travel arrangements efficiently. Acquire expertise in minute taking and building confidence in related tasks. CPD 10 CPD hours / points Accredited by CPD Quality Standards Section 1: Foundational Skills 1:06:33 1: 1.1 Introduction to Personal Assistant 10:33 2: 1.2 Telephone Etiquette for Business 11:04 3: 1.3 Effective Business Writing 28:35 4: 1.4 Enhancing Communication Skills 16:21 Section 2: Representing the Company 32:55 5: 2.1 Advocating for Your Boss and Company 23:01 6: 2.2 Excellence in Customer Service 09:54 Section 3: Organizational Skills 1:13:39 7: 3.1 Organizational Skills 17:05 8: 3.2 Successful Planning and Scheduling 33:19 9: 3.3 Mastering Time Management 23:15 Section 4: Record Keeping & Documentation 35:09 10: 4.1 Maintaining Records and Filing Systems 17:30 11: 4.2 Invoicing and Petty Cash Procedures 17:39 Section 5: Meeting and Event Management 1:27:40 12: 5.1 Coordination of Meetings and Conferences 17:24 13: 5.2 Arranging Travel Logistics 14:19 14: 5.3 Introduction to Minute Writing 09:55 15: 5.4 Preparing for Minute-Taking 12:56 16: 5.5 Understanding the Meeting Structure 08:53 17: 5.6 Documenting Meetings, Decisions, and Actions 08:45 18: 5.7 Techniques for Minute Taking 07:52 19: 5.8 Building Confidence in Meeting Facilitation 07:36 Section 6: Specialized Roles & Services 18:15 20: 6.1 Handling Mail Services and Shipping 17:15 21: Leave A Review 01:00 Who is this course for? This Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking. Moreover, this course is ideal for: Individuals aspiring to administrative and secretarial roles. Employees seeking to enhance their office management capabilities. Professionals looking to upgrade their organisational skills. Individuals preparing for roles as executive PAs. Staff wanting to refine their communication and representation techniques. Anyone who wants to know more about Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking course. Requirements There are no requirements needed to enrol into this Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking course. We welcome individuals from all backgrounds and levels of experience to enrol into this Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking course. Career path After finishing this Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Office Skills: Admin, Secretarial & PA (Executive PA) with Minute Taking are: Personal Assistant Executive Secretary Administrative Coordinator Office Manager Event Coordinator Travel Coordinator Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Office Management Course is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in Office Management and looks at skills needed to improve Office Management. By taking this course you will gain the necessary skills to perform effectively in this field. The Office Management Course is organised into 2 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 15 hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 Mock exams Multiple-choice assessment Certification Upon successful completion of the course you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of 9.99 and PDF Certificate at 4.99. Course Content Managing Office Building Your Management Team 01:00:00 Building A Successful Brand 01:00:00 Achieving Quality Through Teamwork 00:30:00 Keys To Staying Motivated 00:30:00 Improve Your Marketing 01:00:00 Provide Top Customer Service 00:30:00 Wrapping Up 00:30:00 Office Management Module One - Getting Started 00:30:00 Module Two - New Hires 01:00:00 Module Three - It's About Interacting and Influencing 01:00:00 Module Four - Dealing with Rumors Gossip and Half Truths 01:00:00 Module Five - Office Personalities (I) 00:30:00 Module Six - Office Personalities (II) 01:00:00 Module Seven - Getting Support for Your Projects 01:00:00 Module Eight - Conflict Resolution 01:00:00 Module Nine - Ethics 01:00:00 Module Ten - You Are Not an Island 01:00:00 Module Eleven - Social Events Outside of Work 00:30:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Diploma in Office Management 00:20:00 Final Exam Final Exam- Diploma in Office Management 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00: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.

PA - Personal Assistant Give a compliment to your career and take it to the next level. This PA - Personal Assistant Will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this PA - Personal Assistant Bundle will help you stay ahead of the pack. Throughout the PA - Personal Assistant Programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this PA - Personal Assistant Course, you will get 11 premium courses, an original hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This PA - Personal Assistant Bundle Consists of the following Premium courses: Courses are included in this PA - Personal Assistant Bundle? Course 01: Personal Assistant & Skill Development Training Course 02: Paralegal Course 03: GDPR Course 04: Microsoft Office Essentials Course 05: Document Control Course 06: Touch Typing Essentials Course 07: Online Meeting Management Course 08: Minute Taking Essentials Level 2 Course 09: Workplace Confidentiality Course 10: Stress Management Training Course 11: Workplace Safety Course Enrol now in PA - Personal Assistant To advance your career, and use the premium study materials from Apex Learning. The PA - Personal Assistant bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your PA - Personal Assistant Expertise and essential knowledge, which will assist you in reaching your goal. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this PA - Personal Assistant Bundle. Requirements This PA - Personal Assistant Course has been designed to be fully compatible with tablets and smartphones. Career path After successful completion this course, you can explore opportunities such as: Support Secretary Data Entry Clerk Administrative Assistant Office Manager Personal Concierge Executive Assistant And many more! Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Personal Assistant & Skill Development Training) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Are you part of the Office Management department of your company? Or are you a businessman who's having issues with office management? Can you say that you are someone who knows everything about office management or do you still need to learn about it? If so, then this course will help you in office management and find out how to run the business smoothly! Description: Office Management is an essential part of the business since this is where you would know how your office is run and is the key for your business to be successful. In this course, you will be learning how your business or the company you are working for has the right leaders to run its management and operations. You will also learn how to build a successful brand. Then know the importance of teamwork to be able to achieve and accomplish more things. You will also learn that motivation is at the heart of a better business and one of the ways to succeed. Moreover, you will know how to improve the marketing of the business and learn how to provide top customer service. Who is the course for? Businessmen, entrepreneurs or professionals that need to know about office management. People who have an interest in becoming part of the office management department. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diploma in Office Management is a useful qualification to possess, and would be beneficial for the following careers: Administrative Assistants Client Relations Manager Contract Administrator Data Entry Specialists Executive Assistants General Office Clerks Information Assistants Material Recording Clerks Secretaries Virtual Assistants. Managing Office Building Your Management Team 01:00:00 Building A Successful Brand 01:00:00 Achieving Quality Through Teamwork 00:30:00 Keys To Staying Motivated 00:30:00 Improve Your Marketing 01:00:00 Provide Top Customer Service 00:30:00 Wrapping Up 00:30:00 Office Management Module One - Getting Started 00:30:00 Module Two - New Hires 01:00:00 Module Three - It's About Interacting and Influencing 01:00:00 Module Four - Dealing with Rumors Gossip and Half Truths 01:00:00 Module Five - Office Personalities (I) 00:30:00 Module Six - Office Personalities (II) 01:00:00 Module Seven - Getting Support for Your Projects 01:00:00 Module Eight - Conflict Resolution 01:00:00 Module Nine - Ethics 01:00:00 Module Ten - You Are Not an Island 01:00:00 Module Eleven - Social Events Outside of Work 00:30:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Diploma in Office Management 00:20:00 Final Exam Final Exam- Diploma in Office Management 00:20:00

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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.

Efficient offices don’t run on coffee alone – they run on the steady hands of skilled managers and receptionists who know how to keep everything ticking without fuss or fluster. This CPD-accredited course is your passport to mastering the essentials of office coordination, administrative systems, and reception etiquette that make businesses function like a well-rehearsed string quartet (minus the violins). Whether you're looking to refine your organisational flair or finally understand what “scheduling synergy” actually means, this course has your back – with zero jargon and a touch of charm. We’ll guide you through key office procedures, professional communication techniques, document management, and the gentle art of telephone diplomacy. You'll also get the lowdown on digital tools that can turn chaos into calendar invites. Whether you're already perched behind the front desk or eyeing a career in office administration, this course offers structured learning without requiring a stapler in hand. It’s all designed to help you function with confidence, deliver impeccable service, and maybe even tame that printer that bites. Additionally, you get: Free exam Free assessment Free certificate Free Tutor support Hurry up and enrol, before the offer expires! Course Curriculum: Module 01: Core Skills Required Module 02: Self-Management (I) Module 03: Self-Management (II) Module 04: Time Management (I) Module 05: Time Management (II) Module 06: Organizing and Planning (I) Module 07: Organizing and Planning (II) Module 08: Communication (I) Module 09: Communication (II) Module 10: Additional Challenges Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Office Management and Receptionist Skills - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Office Management and Receptionist Skills - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Office Management and Receptionist Skills - CPD Accredited training.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step