3787 Office Skills courses in Cardiff delivered Online

Duration 2 Days 12 CPD hours This course is intended for Delegates should be PC literate, i.e., familiar with PC'S/Laptops and have used a mouse and keyboard; be able to launch and close programs; navigate to information stored on the computer; manage files and folders and be comfortable using Microsoft Office applications such as MS Excel, MS Word etc. Overview The purpose of this course is to provide delegates with the practical skills to build and manage project schedules. It is designed to provide techniques and tips that will help users of the software apply it as a powerful tool to develop competent and unambiguous schedules - while avoiding some of the traps associated with the incorrect application of scheduling features. Techniques learned will also facilitate communicating deliverables and milestones to project stakeholders. This course covers management practices and methodologies and an in-depth knowledge of MS Project functionality. Delegates will be able to create and manage project schedules during the course and reinforce attained skills through practical applications. Project Management Overview Concepts of project management and scheduling The project lifecycle and phases Fundamental importance of defining ? and agreeing ? project scope Developing a Work Breakdown Structure (WBS) to define project scope 4 steps to create a schedule based on the WBS Understanding task dependencies Understanding the concept of the project baseline Developing a Project Schedule Setting the ?Scheduling Mode? Creating Tasks, Recurring Tasks (e.g. progress or review meetings) and Milestones Defining task Dependencies Applying Lag and Lead Time Working with the Critical Path Managing Tasks in the schedule Add Notes and attach project documents to tasks Setting and removing task Constraints and Deadlines Applying the ?Task Path? feature to view dependencies Working with Resources Creating a Resource Pool Working with Resource Calendars Creating Team/Group Calendars Understanding Effort Driven and Non-Effort Driven scheduling Assigning Resources to tasks Working with Project Costs Managing Project Information Applying Field, Tables and Views Applying Filters and Groups Creating custom Fields, Tables and Views (Drop-down menus, Traffic Light reports, Flag Fields) Using the ?Organiser? feature for customised elements Communicating Project Information Applying formats to Views and Tables Using the ?Copy Picture? command Create and Print Project Reports Exporting to Excel Managing Resources Finding Resource Overallocations Resolving Overallocations (reassigning, splitting tasks, utilising float, changing work contours) Applying Resource Levelling features Tracking Progress Setting the Project Baseline Applying the Tracking Gantt and Tracking Table Using the ?Mark on Track? and ?Update Tasks? features Working with Dashboards and Burndown Reports Programme Management Methods to consolidate multiple Project Files Resource sharing - setting up a Master Resource Pool Creating and managing Master Project Files

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 180 CPD Points | Lifetime Access

Course Objectives At the end of this course you will be able to: Customise tables and charts Customise formatting with styles and themes Modify pictures in a document Create customised graphic elements Insert content using Quick Parts Control text flow Use templates to automate document creation Perform mail merges Use macros to automate common tasks '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 Excelent enviroment for training. Tahnk you. 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. 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. Working with Tables and Charts Sort Table Data Control Cell Layout Perform Calculations in a Table Create a Chart Customising Formats Using Styles and Themes Create and Modify Text Styles Create Custom List or Table Styles Apply Document Themes Using Images in a Document Resize an Image Adjust Image Appearance Integrate Pictures and Text Insert and Format Screenshots Use the Snipping tool Creating Custom Graphic Elements Create Text Boxes and Pull Quotes Draw Shapes Add WordArt and Other Text Effects Create Complex Illustrations with SmartArt Inserting Content Using Quick Parts Insert Building Blocks Create and Modify Building Blocks Insert Fields Using Quick Parts Controlling Text Flow Control Paragraph Flow Insert Section Breaks Insert Columns Link Text Boxes to Control Text Flow Using Templates Create a Document Using a Template Create a Template Using Mail Merge The Mail Merge Features Merge Envelopes and Labels Create a Data Source Using Word Using Macros Automate Tasks Using Macros Create a Macro Who is this course for? Who is this course for? This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools Requirements Requirements Preferably, delegates should have attended the Word 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

**24 FREE CPD Accredited Certificates Included** (15,000+ new jobs listed in Reed & LinkedIn) Whether you're aiming to become the organisational linchpin of a bustling office or the go-to right hand of a senior executive, this diploma course offers a structured and informative path into the world of office administration, secretarial work, and PA roles. Packed with essential knowledge and role-focused training, the course covers everything from time management and communication to document handling and professional etiquette—with just enough flair to keep things interesting. It’s ideal for those who want to be the calm, efficient presence in an otherwise chaotic inbox. Delivered entirely online, the course allows you to learn at your own pace, without dressing up or pretending to enjoy lukewarm coffee in a training room. You’ll explore the pillars of modern office management and discover how admin professionals really keep things ticking. This bundle includes the following courses: Course 01: Admin, Secretarial & PA Course 02: Performance Management Course 03: Team Management Course 04: Microsoft Word, PowerPoint & Outlook Course 05: Health and Safety in the Workplace Level 2 Course 06: Workplace First Aid Training Course 07: Information Management Course 08: Facilities Management and Workplace Services Course 09: UK Employment Law Course 10: Meeting Management Online Course 11: Minute Taking Certificate Course 12: Document Control & Administration Skills for Receptionist Course 13: Touch Typing Course 14: Email Writing Course 15: Corporate Risk And Crisis Management Course 16: Public Speaking Course 17: Cross-Cultural Awareness Training Course 18: Equality, Diversity and Discrimination Course 19: Presentation Skills Course 20: Workplace Confidentiality Course 21: Decision Making and Critical Thinking Course 22: Workplace Productivity Course 23: Communication and Organisational Skills Course 24: Project Management: Six Sigma Key Features Accredited by CPD Instant e-certificate Fully online, interactive Office Administration and Admin, secretarial & PA Skills courses with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases As you delve into the intricacies of Admin, Secretarial & PA dynamics, you'll find yourself not just navigating tasks but orchestrating a symphony of organisational prowess. Seamlessly blending tradition with innovation, this diploma is your gateway to a world of versatile expertise. Immerse yourself in the multifaceted landscape of workplace proficiency, where Performance Management and Team Management become second nature. With every keystroke, unlock the power of Microsoft Word, PowerPoint & Outlook, transforming the digital realm into your playground. Navigate the intricate tapestry of UK Employment Law and refine your finesse in Meeting Management and Minute Taking. Through Document Control & Administration Skills, master the receptionist's domain, seamlessly blending touch typing with the art of email communication. Elevate your decision-making prowess and critical thinking to unparalleled heights. Don't miss out on this opportunity to transform your professional journey. Elevate yourself above the competition with our Office Administration and Admin, Secretarial & PA Career Track Diploma. Enrol now, and let the doors to success swing wide open! How will you benefit from this Office Administration and Admin, secretarial & PA Career Track Diploma? All through this self-paced training, you will get engaging learning materials and acquire the necessary knowledge to work with various concepts to gain a competitive advantage in the employment market. Each course within this Office Administration and Admin, secretarial & PA Career Track Diploma Course Bundle is thoughtfully crafted to deepen your understanding of critical Office Administration and Admin, secretarial & PA Skills & concepts and arm you with theoretical knowledge and skills vital to Office Administration and Admin, secretarial & PA Skills. CPD 240 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to pursue careers in office administration and Admin, secretarial & PA. Professionals seeking to enhance administrative and organisational skills for career growth. Graduates entering the workforce and aiming for administrative positions. Employees in administrative roles aiming to upskill and advance their careers. Individuals looking to specialise in project management within an office setting. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Office Administrator Executive Assistant Facilities Coordinator Project Administrator Administrative Manager Workplace Services Coordinator Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Think about the backbone of any successful organization. It's the administrative team, the secretarial staff, and the PAs who keep things running smoothly. A recent study in the UK found that demand for skilled administrative professionals has grown by 15% in the last two years. Are you ready to step up and take on a leadership role in this essential field? This comprehensive Level 7 Diploma equips you with the advanced skills and knowledge to excel in administrative, secretarial, and personal assistant positions. You'll master essential areas like business communication, time management, project coordination, and legal procedures. Additionally, you'll gain expertise in using the latest Microsoft Office tools and navigate complex areas like GDPR and payroll. This Admin, Secretarial & PA at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 180 CPD points) to make your skill development & career progression more accessible than ever! With a single payment, you will gain access to Admin, Secretarial & PA course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Admin, secretarial & PA Bundle Package includes: Course 01: Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 10 Additional CPDQS Accredited Premium Courses - Course 01: Complete Microsoft Word Course 02: Microsoft Excel - Beginner, Intermediate & Advanced Course 03: Legal Secretary Course 04: GDPR Course 05: Payroll Course 06: Administrative Management Course 07: Leadership & Management Diploma Course 08: HR Assistant Course 09: Decision-Making in High-Stress Situations Course 10: Workplace Health and Safety Empower yourself to become an indispensable asset in today's competitive workplace. Enrol today and take your career to the next level! Learning outcome of this Admin, Secretarial & PA: Apply advanced administrative procedures for optimal efficiency. Demonstrate exceptional communication skills in written and verbal formats. Effectively manage time and prioritize tasks in a fast-paced environment. Utilize advanced Microsoft Office applications to streamline workflows. Navigate complex legal and regulatory requirements with confidence. Develop leadership qualities to motivate and support colleagues. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Admin, secretarial & PA Get a free student ID card with Admin, secretarial & PA Training program (£10 postal charge will be applicable for international delivery) The Admin, secretarial & PA is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Admin, secretarial & PA course materials The Admin, secretarial & PA comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Module 1: Personal Assistant Module 2: Admin Support Module 3: Administrative Management Module 4: Organisational Skills Module 5: Telephone Etiquette Module 6: Business Writing Module 7: Time Management Module 8: Body Language and Effective Communication Module 9: Meeting Management Module 10: Excel Basics Module 11: PowerPoint Basic Course 01: Complete Microsoft Word Manipulating Images Using Custom Graphic Elements Collaborating On Documents Adding Document References And Links Securing A Document Using Forms To Manage Content Automating Repetitive Tasks With Macros Course 02: Microsoft Excel - Beginner, Intermediate & Advanced Section 01: Getting Started Section 02: Excel Basics Section 03: Excel Essential Functions Section 04: XLookup Only For Excel 2021 And Office 365 Section 05: Get Data And Tools Section 06: Formatting Data And Tables Section 07: Pivot Tables Section 08: Excel Charts Section 09: Advanced Excel Charts Section 10: Pivot Charts Section 11: Maps Chart Above 2019 Section 12: Business-Geo Charts Section 13: Named Ranges Section 14: Import Data Into Excel Section 15: Advanced Excel =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £139) CPD 255 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Seasoned Admin, Secretarial & PA professionals seeking career growth. Aspiring executive and personal assistants. Career changers entering Admin, Secretarial & PA roles. Individuals specialising in Admin, Secretarial & PA. Advanced administrative skills seekers. Requirements No prior background or expertise is required for this Admin, secretarial & PA bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Executive Assistant: £25,000 - £50,000 Office Manager: £30,000 - £45,000 PA to CEO: £35,000 - £60,000 Administrative Director: £45,000 - £80,000 Operations Manager: £35,000 - £70,000 Business Development Manager: £35,000 - £70,000 Certificates Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free.

Mac Introduction course,

The course will be delivered through 9 online virtual classroom sessions. The 10th and last session will involve the additional practical work for the course as well as the written examination (multiple choice for City & Guilds and written for Hi-Tech Training) which will take place at our training centre at 43 North Great Georges Street, Dublin 1 (completed online for non ROI learners). During the virtual classroom sessions, trainees will have a live video feed with their instructor talking to them, doing practical live demonstrations on equipment being involved actively in the learning. We will send out a practical kit so that trainees can complete assignments and practical work at home. The kit is the property of Hi-Tech Training and will be returned to Hi-Tech Training on the last day of the course. (The kits may also be purchased by the learner….see the Kits Page Link for more details). The kit consists of power supply unit breadboard, multimeter, cables, The kit consists of breadboard, multimeter, oscilloscope, battery and connectors, components including resistors, LEDs and ICs (AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, Latches, Flip-Flops, Timers, etc). Trainees will build various projects as part of the course. The kit forms an integral part of the course, so full course fees need to be paid at least 7 days prior to course commencement to allow time to ship the kit in time for the course.

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Empower Your Administrative Excellence with Office Mastery Step into the realm of professional efficiency with the Admin, Secretarial & PA Bundle, enriched with 20 transformative courses. Master the art of minute-taking, cultivate touch typing prowess, and amplify your communication skills. From comprehensive office administration to refining your Microsoft Word expertise, this bundle equips you with the skills needed to excel in administrative roles. Learning Outcome Upon completion, you'll gain mastery in: Admin, secretarial, and PA roles. Touch typing and communication mastery. Minute taking for effective documentation. Microsoft Word proficiency for office tasks. Public speaking and interpersonal skills development. Business etiquette and customer service excellence. Workplace safety, confidentiality, and ethics. Copywriting and report writing for effective communication. This bundle is about enhancing your administrative, secretarial, and PA skills. Delve into touch typing mastery, minute taking expertise, and honing office administration skills. Learn the art of executive assistance and facilities management. Elevate your customer service acumen, and refine your Microsoft Word and email writing skills. Enhance your communication strategies and explore the essentials of public speaking. Develop interpersonal skills and gain insights into audiology and workplace confidentiality. Unveil the world of business etiquette and workplace safety, while also delving into the realms of copywriting and newspaper journalism for effective communication. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Tailored for: Aspiring and current admin, secretarial, and PA professionals. Individuals seeking to enhance office administration skills. Those aiming to excel in communication and office etiquette. Career path Forge your path with roles like: Administrative Assistant (£18,000 - £25,000). Office Manager (£25,000 - £40,000). Personal Assistant (£22,000 - £35,000). Customer Service Representative (£18,000 - £30,000). Copywriter (£20,000 - £35,000). Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included