3722 Office Skills courses in Glasgow delivered Online

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

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. 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

Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Administration and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all in one Administration bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Administration course that will enhance your skills and prepare you for the competitive job market. Also, our Administration experts are available for answering your queries and help you along your learning journey. Advanced audiovisual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Administration, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Administration Bundle Consists of the following Premium courses: Course 01: Business Administration Level 3 Course 02: Paralegal Course 03: Law and Contracts - Level 2 Course 04: Corporate Risk And Crisis Management Course 05: Performance Management Course 06: Quality Management Course 07: Conflict Management Course 08: People Management Skills Level 3 Course 09: Online Meeting Management Course 10: Email Writing Training Course 11: Cross-Cultural Awareness Training Course 12: GDPR Data Protection Level 5 Course 13: Level 2 Microsoft Office Essentials Course 14: Effective Communication Skills Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 14 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum of Bundle Course 01: Business Administration Level 3 Representing Your Boss and Company Skills of an Effective Administrator Business Writing Skills Communication Skills Business Telephone Skills Mail Services and Shipping Travel Arrangements Organising Meeting and Conferences Time Management Record Keeping and Filing Systems Effective Planning and Scheduling Course 02: Paralegal Understanding the Concept of Paralegal Key Legal Terminology Effective Communication Skills for Paralegals The Legal Workplace & Professionals Law & Legal Systems Contract & Business Law Property Law Wills, Probate, Estate Law Criminal Law Common Paralegal Legal Matters Human Rights Conflict and Conflict Resolution Professional Conduct and Ethics of Paralegals Mandatory Knowledge Fields and Survival Tips for Paralegals Course 03: Law and Contracts - Level 2 Introduction to UK Laws Ministry of Justice Agreements and Contractual Intention Considerations and Capacities of Contact Laws Terms within a Contract Misinterpretations and Mistakes Consumer Protection Privity of Contract Insurance Contract Laws Contracts for Employees Considerations in International Trade Contracts Laws and Regulations for International Trade Remedies for Any Contract Breach Course 04: Crisis Management Course Getting Started Crisis Workplace Violence Myths Escalation Concerning Behaviors Domestic Violence Indicator Triggers of Workplace Violence Conflict Dangers Response Strategies Course 05: Supervisor Training Level 3 Introduction Setting Expectations Setting Goals Assigning Work Degrees of Delegation Implementing Delegation Providing Feedback Managing Your Time Resolving Conflict Tips for Special Situations A Survival Guide for the New Supervisor Wrapping Up Course 06: Quality Management Introduction to Quality Management Total Quality Management Quality Measurement and Improvement Quality Control Understanding Customer Expectations and Needs Six Sigma Supply Chain Management Quality Audits Course 07: Conflict Management Unit 01: Introduction Unit 02: Understand the Keys to Conflict Unit 03: How Misunderstandings Arise and the Solution Unit 04: Personality Types in Conflict Unit 05: Escalation of Conflict Unit 06: De-escalating Conflict Unit 07: Closing Section Course 08: Online Meeting Management Planning and Preparation Online Meeting Platforms Meeting Etiquette and Tips Course 09: Email Writing Training Module 1- E-Mail Communications Module 2- Fundamentals of Writing Effective E-mails Module 3- Manage Your E-mail Module 4- Writing Styles and Tone Module 5- Additional Tips for Writing Effective E-Mail Module 6- Exercise Caution Course 10: Cross-Cultural Awareness Training Introduction to Cross-Cultural Awareness Cross-Cultural Communication Corporate Cross-Cultural Awareness Cross-Cultural Design Cross-Cultural Competency Cultural Values Working with and Managing a Culturally Diverse Team Course 11: GDPR GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Course 12: Level 2 Microsoft Office Essentials Excel 2016 Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Word 2016 Getting Started with Word Formatting Text and Paragraphs Working More Efficiently Managing Lists Adding Tables Inserting Graphic Objects Controlling Page Appearance Preparing to Publish a Document Workbooks - Microsoft Word 2016 (Beginner) PowerPoint 2016 PowerPoint Interface Presentation Basics Formatting Inserting Options Working with Objects Table Charts Review and Presentatin Access 2016 Introduction to Access Modify Data Working with Queries Access Forms Working with Reports Course 13: Functional Skills IT Introduction Information Technology Components of IT Hardware Operating System Application/Software Networking Security Traffic Flow & Enterprise Level IT Components Storage Database Virtualisation & Cloud Management & Other IT Jobs Course 14: Work Area Organisation for Increased Office Productivity Introduction Purge Redistributing Fences Software Create Work Spaces Proximity Label What You Can Move to Digital Clean Your Desk Off Multiple Inboxes Mailings Discard Dates Magazines File Weekly How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Requirements Our course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this course expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Business Administration Level 3) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Business Administration Level 3) 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.

Description: The Office Admin and Legal Secretary Diploma course teaches you the techniques and skills for managing an Office as Office Admin or managing the role of a legal secretary. You will learn administration management skills, organisational skills and essential office management skills. The course also covers the skills required for a legal secretary such as fundamental concepts of the legal office, billing, preparing legal documents, contracts, torts, real estate, family law, business law, telephone etiquette, meeting management and minute management and more Who is the course for? This course is ideal for those wanting to improve their base skills in office administrative tasks This course would be ideal people who want to start working as a receptionist, office administrator, office manager, administration assistant or secretary 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 the cost of £39 or in PDF format at the 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 recognized 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: Office Admin and Legal Secretary Diploma is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Administrator support staff Administrative assistant Office managers Receptionist Office administrator Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30:00 Administrative Management Module One - Getting Started 00:30:00 Module Two - Why Your Office Needs Administrative Procedures 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Module One - Getting Started 00:30:00 Module Two - Remove the Clutter 01:00:00 Module Three - Prioritize 01:00:00 Module Four - Scheduling Your Time 01:00:00 Module Five - To Do Lists 01:00:00 Module Six - Paper and Paperless Storage 01:00:00 Module Seven - Organization in Your Work Area 01:00:00 Module Eight - Tools to Fight Procrastination 01:00:00 Module Nine - Organizing Your Inbox 01:00:00 Module Ten - Avoid the Causes of Disorganization 01:00:00 Module Eleven - Discipline is the Key to Stay Organized 01:00:00 Module Twelve - Wrapping Up 00:30:00 Office Management 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 Legal Secretary Introduction to Legal Secretary 00:15:00 Role of Legal Secretaries 00:15:00 General Duties and Day-to-Day Operations of a Legal Secretary 00:30:00 Record Keeping 00:30:00 Legal Writing Skills & Proofreading 00:15:00 Research Skills You Need to Know 00:30:00 Transcription, Editing & Correspondence to Judges 00:30:00 Legal System of UK 00:15:00 UK Court System 00:30:00 Meeting Management & Minute Taking Meeting Management 00:15:00 The Role of a Minute-Taker 00:15:00 The Skills of a Minute-Taker 00:30:00 Meeting Agreements 00:15:00 Minute Styles 00:30:00 What Do I Record? 00:30:00 Techniques for Preparing Minutes 00:30:00 The Minute Book 00:15:00 What to include/what to ignore 00:30:00 Motions and Resolutions 00:15:00 Method of recording minutes 00:30:00 Reasons for Meeting 00:30:00 What is a decision? 00:15:00 Minute Taking tips 00:30:00 Other Secretarial Roles and Responsibilities Working with Your Manager 01:00:00 Administrative Soft Skills 01:00:00 Effective Time Management 01:00:00 Tools of the Trade 01:00:00 Being an Effective Gatekeeper 00:15:00 Organizational Skills 00:15:00 Confidentiality Guidelines 00:15:00 Special Tasks 00:15:00 Legal Office Administration Ethical Considerations 00:10:00 The Basics 00:04:00 Client Relations 00:05:00 Dealing With Mail 00:05:00 File Management 00:03:00 Use Of Technology 00:06:00 Skills that Every Legal Secretary Should Have 00:06:00 What is Litigation 00:04:00 Delivery of Documents 00:04:00 Motions Prior to and During Trial 00:07:00 The Basics 00:04:00 The Essential Elements 00:03:00 Remedies for Breach of Contract 00:04:00 Customer Service Role Introduction To Customer Service 00:15:00 The Power of Positive Thinking in Customer Service 00:30:00 Types of Difficult Customers and How to Help them 01:00:00 How to Deal with Difficult Customers 00:30:00 Telephone Etiquette Aspects of Phone Etiquette 01:00:00 Using Proper Phone Language 01:00:00 Eliminate Phone Distractions 01:00:00 Inbound Calls 01:00:00 Outbound Calls 01:00:00 Handling Rude or Angry Callers 01:00:00 Handling Interoffice Calls 01:00:00 Methods of Training Employees 01:00:00 Correcting Poor Telephone Etiquette 01:00:00 Organizing Work Using MS Word Opening 01:00:00 Working with the Interface 01:00:00 Your First Document 01:00:00 Basic Editing Tasks 01:00:00 Basic Formatting Tasks 01:00:00 Formatting Paragraphs 00:01:00 Advanced Formatting Tasks 01:00:00 Working with Styles 01:00:00 Formatting the Page 01:00:00 Sharing Your Document 01:00:00 Proof Reading Introduction to Proofreading 00:15:00 What does a Proofreader do? 00:15:00 Proofreading 00:15:00 Proofreading Symbols 00:15:00 Proofreading on Paper & Screen 00:15:00 Strategies to Check for Specific Errors 00:15:00 Editing & Proofreading Strategies 00:15:00 Proofreading an Essay 00:15:00 Mock Exam Mock Exam- Office Admin and Legal Secretary Diploma 00:30:00 Final Exam Final Exam- Office Admin and Legal Secretary Diploma 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people who use PowerPoint for their business communication needs. Overview To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders. This course is intended for those who wish to take advantage of the application for high quality business presentations and reports. Presentations Create Attractive Presentations from Existing PowerPoint Templates Creating Presentations Quickly using Outline to build a Structure Incorporating and reusing slides from other presentations into your own Templates and Customization Using Slide Layouts Using the Slide Master Creating Custom Slide Layout Working with Charts and Tables Create and Modify Tables Create Charts and Graphs Copying Charts into PowerPoint Link Vs Embed Add Visual Elements to a Presentation Create and Modify Shapes Add Images Create SmartArt to Make Easily Modifiable graphics Use SmartArt to Give Dull Text a More Visual Appeal Working with Media and Animation Add Audio to A Presentation Add Video to A Presentation Add and Customize Animations Add and Customize Transitions Preparing to Present Add Notes to A Presentation Presenter View And Slide Show Controls Create A Custom Slide Show Saving and Sharing the Presentation Printing Options and Handouts Additional course details: Nexus Humans Microsoft PowerPoint for the Business User 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 Microsoft PowerPoint for the Business User 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.

24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Looking for a career with great earning potential? Consider becoming a personal assistant. With an average salary of £25,155 per year, personal assistants in the UK have the potential to earn up to £45,000 with experience and advanced skills. To excel in this role, it's essential to have the right skills and training. That's where our Personal Assistant Training bundle comes in. This bundle features eleven relevant and CPD-QS accredited courses that cover everything from office administration and receptionist skills to leadership and negotiation. By completing this comprehensive training, you will gain the expertise and confidence needed to excel in any administrative role. In addition, the first course in this bundle is QLS-endorsed and comes with a hardcopy certificate upon completion. This Certification is highly respected in the industry and will add an extra layer of credibility to your success, helping you stand out from other job candidates. By completing this comprehensive training package, you will gain the knowledge and skills necessary to excel in any administrative role. You'll learn effective communication techniques, organisational strategies, and time management tips that will help you stay on top of even the most demanding workload. Don't miss out on the opportunity to increase your earning potential and advance your career as a personal assistant. Enrol in our Personal Assistant Training bundle today. This PA - Personal Assistant Training Bundle Package includes: Course 01: Diploma in Personal Assistant at QLS Level 5 10 Premium Additional CPD QS Accredited Courses - Course 01: Office Admin and Receptionist Skills Course 02: Executive and Personal Assistant Training Course Course 03: Minute Taking Course 04: Diploma in Meeting Management Course 05: Strategic Planning Process Course 06: Organisational Skills Course for Administrator Course 07: Leadership Skills Course Course 08: Negotiation Skills Certificate Course 09: The Secrets of Body Language Course 10: Document Control Why Prefer This PA - Personal Assistant Training Bundle? You will receive a completely free certificate from the Quality Licence Scheme Option to purchase 10 additional certificates accredited by CPD Get a free Student ID Card - (£10 postal charges will be applicable for international delivery) Free assessments and immediate success results 24/7 Tutor Support After taking this PA - Personal Assistant Training bundle courses, you will be able to learn: Master communication skills for effective workplace communication Develop advanced organisational skills to enhance productivity Understand the strategic planning process and how to implement it successfully Gain leadership skills to help manage teams effectively Learn negotiation techniques to achieve successful outcomes in any situation Develop essential minute-taking skills for successful meetings Learn document control and management techniques to maintain efficiency in the workplace ***Curriculum breakdown of PA *** Module 01: Introduction to Personal Assistant Module 02: Business Telephone Skills Module 03: Representing Your Boss and Company Module 04: Mail Services and Shipping Module 05: Travel Arrangements Module 06: Organising Meeting and Conferences Module 07: Time Management Module 08: Record Keeping and Filing Systems Module 09: Business Writing Skills Module 10: Organisational Skills Module 11: Communication Skills Module 12: Customer Service Module 13: Effective Planning and Scheduling Module 14: Invoicing/Petty Cash How is the PA - Personal Assistant TrainingBundle Assessment Process? You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you successfully pass the exams. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course bundle is ideal for: Individuals interested in pursuing a career as a personal assistant Office administrators looking to enhance their skills and knowledge Receptionists seeking to develop their communication and organisational skills Professionals looking to advance their careers in the administrative field Career path Junior Personal Assistant: £18,000 - £24,000 per year Personal Assistant: £24,000 - £32,000 per year Executive Assistant: £32,000 - £40,000 per year Senior Executive Assistant: £40,000 - £50,000 per year Office Manager: £25,000 - £45,000 per year Operations Manager: £35,000 - £60,000 per year Note: The salary range mentioned here can vary depending on industry and experience. Certificates CPD QS Accredited Certificate Digital certificate - Included Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally. CPD QS Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location. Diploma in Personal Assistant at QLS Level 5 Hard copy certificate - Included

Level 3 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

Duration 1 Days 6 CPD hours This course is intended for This course is designed for Microsoft© Windows© and Microsoft Office users who are transitioning to a SharePoint environment, and who need to access information from and collaborate with team members within Microsoft SharePoint. Overview Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site. Use SharePoint workflow automation tools. In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft© SharePoint© is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents. Prerequisites To ensure your success in this course, you should have basic end-user skills with a current version of Microsoft Windows. Lesson 1: Navigating SharePoint Sites Topic A: Launch SharePoint Topic B: Gain Access to a Site You Didn't Create Topic C: Navigate Within a SharePoint Site Topic D: Access SharePoint from Your Mobile Device Lesson 2: Using Lists to Track Information Topic A: Add and Populate Lists Topic B: Change View Options Topic C: Create a Custom View Lesson 3: Using Document Libraries to Share and Organize Documents Topic A: Store Files in a Document Library Topic B: Create and Use Document Templates Lesson 4: Finding, Sharing, and Archiving Content Topic A: Search for Items in Lists or Libraries Topic B: Share Through Links Topic C: Move Files Offline Lesson 5: Authoring Documents as a Team Topic A: Work Together on Documents Topic B: Manage File Versions and Document Recovery Lesson 6: Automating Business Processes Topic A: Use Rule-Based Automation Topic B: Use Power Automate to Automate a Workflow

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.

Microsoft Teams Microsoft Teams is a cooperation instrument intended to unite individuals, correspondence and substance in a solitary interface. This course is focused on any individual who needs to make and work with the Microsoft Teams application. You might be a Microsoft Team proprietor needed to make and deal with a Teams territory for partners, or somebody who will utilize Teams to work with associates What you Will Learn: Explore around the Microsoft Teams App Make a Microsoft Team Add and Manage Owners and Members Make Channels Set Team and Channel Options Utilize the Conversation Tools Organize Teams Meetings Add Content utilizing Apps