9790 Office courses

Java Evenings Course. Basic Java syntax and principles of object-oriented programming. Our Style: Hands-on, Practical Course, Instructor-led Course. Level: From basics to fully functional. Who would benefit from the course: basics to Java, attend after work. Duration: one lesson of 2 hours per week for 6 weeks, from 6pm to 8pm.

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

Overview This comprehensive course on Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. It is available to all students, of all academic backgrounds. Requirements Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 34 sections • 135 lectures • 08:20:00 total length •Introduction: 00:03:00 •Getting started on Windows, macOS, and Linux: 00:01:00 •How to ask great questions: 00:01:00 •FAQ's: 00:01:00 •Excel Overview: 00:05:00 •Start Excel Spreadsheet: 00:04:00 •Enter Text and Numbers: 00:07:00 •Relative References: 00:04:00 •Working with ranges: 00:07:00 •Save and Save as Actions: 00:08:00 •File Extensions, Share, Export, and Publish files: 00:06:00 •Adding Rows and Columns: 00:03:00 •Modifying Rows and Column lengths: 00:05:00 •Copy, Cut, and Paste: 00:07:00 •Copying Formulas: 00:03:00 •Page setup options: 00:06:00 •Fit to print on One Page: 00:03:00 •Print Workbooks: 00:03:00 •Sorting Data Ascending Order: 00:04:00 •Sorting Data Descending Order: 00:02:00 •Filter Data: 00:04:00 •Creating Basic Formulas: 00:06:00 •Datetime Formulas: 00:06:00 •Mathematical formulas phase1: 00:20:00 •Mathematical formulas phase2: 00:12:00 •VLOOKUP formula: 00:12:00 •HLOOKUP formula: 00:04:00 •XLOOKUP: 00:08:00 •Handling #NA and Approximates match in XLOOKUP: 00:11:00 •Split Text into columns: 00:07:00 •Flash Fill: 00:07:00 •Data Validation: 00:07:00 •Remove Duplicates: 00:08:00 •Import Data from Text files: 00:06:00 •Import Data from .CSV files: 00:03:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Numbers: 00:05:00 •Formatting Date: 00:03:00 •Formatting Tables: 00:05:00 •Pivot Tables: 00:07:00 •Pivot Charts: 00:02:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Creating Charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line Charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Overview: 00:04:00 •Start PowerPoint Presentation: 00:05:00 •Screen setting and Views: 00:05:00 •Presentation Tips and Guidelines: 00:06:00 •Creating a New Presentation: 00:04:00 •Working with Slides: 00:04:00 •Save a Presentation: 00:04:00 •Print Slides: 00:03:00 •Formatting Text: 00:05:00 •Slide Text Alignments: 00:03:00 •Multi-Column Text Alignments: 00:02:00 •Adding Bullets and Numbered List Items: 00:03:00 •Insert Shapes: 00:03:00 •Insert Icons: 00:03:00 •Insert Graphics: 00:04:00 •Add 3D Models: 00:03:00 •Insert Pictures: 00:03:00 •Picture Options: 00:04:00 •Picture Cropping: 00:03:00 •Applying Built-in Picture Styles: 00:04:00 •Add SmartArt Graphic: 00:03:00 •Modifying SmartArt: 00:03:00 •Creating a Target Chart using SmartArt: 00:03:00 •Create a Table on Slide: 00:04:00 •Formatting Tables: 00:02:00 •Inserting Tables: 00:02:00 •Table Layouts: 00:01:00 •Add a Chart: 00:02:00 •Formatting Charts: 00:02:00 •Insert Chart from Microsoft Excel: 00:03:00 •Adding Video to a Presentation: 00:03:00 •Adding Audio to a Presentation: 00:02:00 •Screen Recording and Adding: 00:02:00 •Applying Transitions to Presentation: 00:04:00 •Object Animation: 00:03:00 •Effect Options: 00:02:00 •Advanced Animation: 00:02:00 •Triggers to control animation: 00:02:00 •Onscreen Presentation: 00:02:00 •Hiding Slides: 00:02:00 •Changing Order of Slides: 00:02:00 •Copying Slides: 00:02:00 •Overview of MS Word: 00:04:00 •Start MS Word 2021: 00:05:00 •Create a new blank document: 00:04:00 •Creating a paragraph text: 00:05:00 •Non-printing characters: 00:03:00 •Save a document: 00:03:00 •Open a document: 00:01:00 •Find and replace: 00:04:00 •AutoCorrect options: 00:03:00 •Formatting text: 00:04:00 •Copy cut and paste: 00:04:00 •Character formatting: 00:02:00 •Format painter: 00:04:00 •Work with numbers: 00:02:00 •Add bullets: 00:03:00 •Outline creation: 00:04:00 •Creating a table: 00:03:00 •Adding rows and columns to a table: 00:02:00 •Formatting table data: 00:02:00 •Borders and shading: 00:02:00 •Sorting in a table: 00:04:00 •Draw a table: 00:04:00 •Convert text to table: 00:03:00 •Convert table to text: 00:02:00 •Insert a spreadsheet: 00:02:00 •Quick tables - readily available formats: 00:02:00 •Working with styles: 00:02:00 •Creating styles: 00:02:00 •Clear formatting: 00:01:00 •Margins: 00:02:00 •Orientation: 00:01:00 •Page size setting: 00:01:00 •Adding columns: 00:03:00 •Page break - section break: 00:02:00 •Adding watermark: 00:03:00 •Headers and footers: 00:03:00 •Create envelops: 00:02:00 •Creating labels: 00:02:00 •Creating a mail merge document: 00:03:00 •Thesaurus and spell check: 00:01:00 •Word count: 00:01:00 •Speech - read aloud: 00:01:00 •Language - translate: 00:01:00 •Tracking: 00:01:00

Course Objectives At the end of this course you will be able to: Modify the PowerPoint environment Using Master View in order to customise a design template Add and customize SmartArt graphics Add animations and change its effect options Add action buttons to control the flow of the presentation Use various options to customise slide shows Use different PowerPoint file types to distribute presentations ' 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 Very clearly explained Good pace. Lucy Tailor - 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. Customising the PowerPoint Environment Customise the User Interface Set PowerPoint Options Customising Design Templates Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Adding SmartArt to a Presentation Create SmartArt Modify SmartArt Working with Media Add Audio to a Presentation Add Video to a Presentation Working with Animations Entrance, Emphasis and Exit Animations Animate Charts by Category and Series Customise Animations and Transitions Collaborating on a Presentation Review a Presentation Store and Share Presentations on the Web Customising a Slide Show Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks Add Action Buttons Record a Presentation Securing and Distributing a Presentation Secure a Presentation Create a Video or a CD Distribute the Presentation in different File Formats Who is this course for? Who is this course for? This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. Requirements Requirements Preferably, delegates should have attended the Powerpoint 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 Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our 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. Tailored in company 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. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. 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

Build your communication skills to boost the productivity of office administration. Learn Business Etiquette, Organisational Skills, Effective Planning and Scheduling.

Recent studies have shown a significant surge in demand for professionals skilled in Hospitality Management, HR Management, and Office Administration. With the global economy rebounding post-pandemic, industries are gearing up for growth, particularly in the service sector. In light of this, our Hospitality Management and HR management bundle offers a comprehensive suite of courses tailored to equip individuals with the expertise required to thrive in these dynamic fields. The Hospitality Management, HR Management with Office Administration QLS Endorsed Diploma bundle encompasses a diverse range of topics crucial for success in today's competitive job market. From mastering the intricacies of HR Management to honing skills in Hospitality Management and Office Administration, this bundle provides a holistic approach to professional development. Furthermore, with additional modules focusing on personal growth and career advancement, participants can elevate their capabilities to excel in various roles within these industries. In this bundle, learners will delve into the fundamentals of Hospitality Management, exploring topics such as restaurant management, catering management, and customer service. Simultaneously, they will gain insights into HR Management, delving into areas such as HR audit and delegation skills. Moreover, the inclusion of Hospitality Management and HR management courses on office management and administration ensures that learners are equipped with the necessary organizational and administrative skills vital for success in any workplace setting. QLS Endorsed Courses: Course 01: Advance Certificate in Office Management & Administration at QLS Level 3 Course 02: Certificate in HR Management at QLS Level 3 Course 03: Diploma in Hospitality Management at QLS Level 5 CPD QS Accredited Courses: Course 04: Certificate in HR Audit Course 05: Delegation Skills Course 06: Travel and Tourism Course 07: Leisure Management Course 08: Concierge Course 09: Restaurant Management Course 10: Catering Management Course 11: Customer Service Diploma Take your career to the next level with our bundle that includes technical courses and five guided courses focused on personal development and career growth. Course 12: Career Development Plan Fundamentals Course 13: CV Writing and Job Searching Course 14: Networking Skills for Personal Success Course 15: Ace Your Presentations: Public Speaking Masterclass Course 16: Decision Making and Critical Thinking Seize this opportunity to elevate your career with our comprehensive bundle, endorsed by the prestigious QLS and accredited by CPD. Hospitality Management, HR Management with Office Administration QLS Endorsed Diploma. Learning Outcomes: Gain a comprehensive understanding of Hospitality Management principles and practices. Develop essential Hospitality Management and HR management skills, including HR audit and delegation techniques. Acquire proficiency in office management and administration. Enhance personal development through Hospitality Management and HR management courses focused on career planning, networking, and confidence-building. Master time management techniques to boost productivity and efficiency. Learn strategies for anxiety and stress management to maintain well-being in a demanding professional environment. In this comprehensive Hospitality Management and HR management courses, participants will embark on a journey through the core principles and practices of Hospitality Management, HR Management, and Office Administration. Through engaging modules, learners will delve into the intricate workings of the hospitality industry, understanding the dynamics of restaurant and catering management, as well as the nuances of providing exceptional customer service. They will explore the fundamentals of HR management, including the crucial aspects of HR audit and delegation skills, enabling them to effectively manage human resources within organizations. Moreover, participants will gain invaluable insights into office management and administration, acquiring essential organizational skills and administrative techniques vital for success in any workplace environment. Through a combination of theoretical knowledge and practical applications, learners will develop a holistic understanding of these fields, equipping them with the expertise needed to excel in their careers and make meaningful contributions to their respective industries. CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? After successfully completing the Hospitality Management and HR management course, you should be able to: Aspiring professionals seeking to enter the hospitality industry. Individuals aiming to advance their careers in Hospitality Management and HR management. Office administrators looking to enhance their skills and qualifications in Hospitality Management and HR management. Students pursuing a comprehensive diploma in Hospitality Management and HR management endorsed by QLS. Professionals seeking personal growth and career development opportunities. Anyone interested Requirements You are warmly invited to register for this bundle. Please be aware that there are no formal entry requirements or qualifications necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment Career path This Hospitality Management and HR management course will help you to develop your knowledge to pursue different careers, such as: Hospitality Manager HR Coordinator Office Manager Catering Supervisor Customer Service Manager HR Auditor Administrative Assistant Certificates 13 CPD Quality Standard Certificates Digital certificate - Included 3 QLS Endorsed Certificates Hard copy certificate - Included

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Legal Office Administration Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Legal Office Administration Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Legal Office Administration Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Legal Office Administration Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Legal Office Administration? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Legal Office Administration there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Legal Office Administration course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Legal Office Administration does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Legal Office Administration was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Legal Office Administration is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Certification for Paralegals Certifications 00:07:00 The Law Office 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 Billing How Attorneys Charge 00:09:00 Time and Cost Entries 00:05:00 Trust Accounts 00:04:00 Docket Administration 00:05:00 Preparing Legal Documents Basic Preparation 00:13:00 Legal Citations 00:05:00 The Law Library 00:05:00 Litigation What is Litigation 00:04:00 Delivery of Documents 00:04:00 Motions Prior to and During Trial 00:07:00 Contracts The Basics 00:04:00 The Essential Elements 00:03:00 Remedies for Breach of Contract 00:04:00 Torts The Goal of Tort Law 00:10:00 Negligence 00:11:00 Strict Liability 00:07:00 Criminal Law and Procedure Criminal Law Basics 00:20:00 Criminal Procedure 00:15:00 Family Law Marriage 00:08:00 Annulment and Divorce 00:05:00 Child Custody 00:09:00 Business Law Types of Organizations 00:07:00 Corporations 00:09:00 Real Estate The Basics 00:10:00 Documenting Transactions 00:12:00 Estate Planning and Guardianship The Basics 00:07:00 Characteristics of a Will 00:08:00 Types of Trusts and Funding 00:04:00 Elder Law 00:06:00 Bankruptcy The Basics 00:14:00 Mock Exam Mock Exam- Legal Office Administration 00:20:00 Final Exam Final Exam- Legal Office Administration 00:20:00

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. Overview Navigate the Report Builder Environment. - Create table reports. - Format reports. - Create basic and complex expressions. - Group report data. - Create matrix reports. - Sort and filter data. - Summarize data with charts. - Print and export reports. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. Prerequisites ?Familiarity with Windows. ?Creating and navigating folders. ?Opening programs. ?Manipulating windows. ?Copying and pasting objects. ?Formatting text. ?Saving files. 1 - Exploring the Report Builder Environment Introducing the Report Builder Environment Working with Existing Reports Lab 1: Exploring the Report Builder Application 2 - Adding Data to Table Reports Create Report Data Sources Create Report Datasets Work with the Tablix Data Region Create a Table Report Lab 1: Creating Table Reports 3 - Formatting Data and Creating Expressions in Reports Formatting Reports Sorting and Filtering Report Data Adding Data to a Dataset Creating Simple Expressions Creating Complex Expressions Lab 1: Formatting Reports 4 - Grouping Report Data Group Data in Reports Group Data Using an Expression Creating Subgroups and Group Aggregates Lab 1: Creating Reports with Groups and Aggregates 5 - Matrix Reports Creating and Modifying Matrix Data Regions Creating and Modifying Column Groups Lab 1: Creating Matrix Reports 6 - Charts Create and Modify Chart Wizard Reports Add Charts to Existing Reports Modify Charts in Reports Lab 1: Creating Charts and Chart Reports 7 - Printing and Exporting Reports Print Features and Print Options Export Reports Lab 1: Printing and Exporting Reports

Are you looking to enhance your Secretary skills? If yes, then you have come to the right place. Our comprehensive course on Secretary Skills will assist you in producing the best possible outcome by mastering the Secretary Skills skills. The Secretary Skills course is for those who want to be successful. In the Secretary Skills course, you will learn the essential knowledge needed to become well versed in Secretary Skills. Our Secretary Skills course starts with the basics of Secretary Skills and gradually progresses towards advanced topics. Therefore, each lesson of this Secretary Skills course is intuitive and easy to understand. Why would you choose the Secretary Skills course from Compliance Central: Lifetime access to Secretary Skills course materials Full tutor support is available from Monday to Friday with the Secretary Skills course Learn Secretary Skills skills at your own pace from the comfort of your home Gain a complete understanding of Secretary Skills course Accessible, informative Secretary Skills learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Secretary Skills Study Secretary Skills in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Secretary Skills Course Secretary Skills Curriculum Breakdown of the Secretary Skills Course Course Outline: Module 1: Introduction to Personal Assistant Module 2: Business Telephone Skills Module 3: Representing Your Boss and Company Module 4: Mail Services and Shipping Module 5: Travel Arrangements Module 6: Organising Meeting and Conferences Module 7: Time Management Module 8: Record Keeping and Filing Systems Module 9: 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 Module 15: Professional Conduct and Ethics CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Secretary Skills course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Secretary Skills. It is also great for professionals who are already working in Secretary Skills and want to get promoted at work. Requirements To enrol in this Secretary Skills course, all you need is a basic understanding of the English Language and an internet connection. Career path Administrative Assistant: £18,000 to £25,000 per year Office Manager: £25,000 to £35,000 per year Executive Assistant: £25,000 to £40,000 per year Personal Assistant: £20,000 to £35,000 per year Office Administrator: £18,000 to £25,000 per year Communications Coordinator: £22,000 to £30,000 per year 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