3800 Office Skills courses

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 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. 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. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. 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: 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 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. 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

Ready to stop sending your resume into the void? It’s time to master a fundamental life skill for every ambitious administrative professional: crafting a resume that doesn’t just list your entire work history, but actually it gets you interviews. Join us for an intensive workshop where we reveal the industry secrets behind the art and science of standout resumes.

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 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. 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. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students who already have experience creating Modern SharePoint sites and populating them with content, who want to learn advanced features to extend SharePoint's capabilities, make information easier to find and manage, use SharePoint features to improve governance and compliance, and improve the security of information and services within the SharePoint environment. Overview Create a custom site template to reduce the time spent creating similarly configured SharePoint sites. Configure managed metadata, including custom term sets, content types, and metadata-based navigation. Control access through permissions. Improve overall security of sites, lists, libraries, folders, list items, and documents. Microsoft© SharePoint©, in conjunction with the Microsoft 365? productivity and office automation suite, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location. Users who already have experience as SharePoint site members and owners may be ready to move on to more advanced site-building tasks such as using custom site templates, custom themes, applying advanced permissions settings, improving security, and preparing sites to support governance and compliance. Advanced site builders may be ready to undertake more advanced site management tasks, working in conjunction with their SharePoint Administrator to create and use custom site templates, term sets and metadata, manage information governance and compliance, and get deeper into SharePoint security configuration. This course focuses on these advanced site-building and administration tasks. Prerequisites To ensure your success in this course, you should have SharePoint site user skills such as the ability to view and enter data in SharePoint lists and libraries, and to navigate a typical SharePoint site. You should also have intermediate site builder skills such as the ability to create a SharePoint site, apply a site template, populate sites with pages, create lists and libraries, and connect a site to a hub site. NOTE: This course was developed using Microsoft 365 Business Standard edition. If you opt to use one of the Enterprise editions, be sure to key the course activities before you deliver the class so you will be able to anticipate any differences that students might see with the edition you use. Lesson 1: Creating Custom Site Templates Topic A: Prepare a Site Script Topic B: Generate and Use a Custom Site Template Lesson 2: Managing Content Services Topic A: Plan and Configure Managed Metadata Topic B: Create and Manage Content Types Topic C: Use Managed Metadata for Navigation and Filtering Lesson 3: Controlling Access Through Permissions Topic A: Assign Permissions Topic B: Manage Permissions Inheritance Lesson 4: Improving Security Topic A: Manage Access at the Site Level Topic B: Manage Access at the Tenant Level

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions

Are you ready to embark on an enlightening journey of wisdom with the Paralegal & Legal Secretary bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Paralegal, Legal Secretary, GDPR with Business Law Training. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Paralegal Training Course 02: Legal Advisor Training Course 03: Legal Secretary and Office Skills Diploma Course 04: UK Employment Law Course 05: Business Law Course 06: Commercial Law Course 07: Workplace Confidentiality Course 08: GDPR Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Paralegal, Legal Secretary, GDPR with Business Law Training bundle illuminate your path to wisdom. The Paralegal, Legal Secretary, GDPR with Business Law Training bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across five carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Paralegal, Legal Secretary, GDPR with Business Law Training package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Paralegal & Legal Secretary bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Paralegal, Legal Secretary, GDPR with Business Law Training community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Paralegal & Legal Secretary bundle. Establish robust bases across each course nestled within the Paralegal & Legal Secretary bundle. Decipher intricate concepts through the articulate content of the Paralegal & Legal Secretary bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Paralegal & Legal Secretary bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Paralegal & Legal Secretary bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Paralegal & Legal Secretary bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Paralegal & Legal Secretary bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Paralegal & Legal Secretary bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Paralegal & Legal Secretary journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Paralegal & Legal Secretary Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements To enrol in this Paralegal, Legal Secretary, GDPR with Business Law Training course, all you need is a basic understanding of the English Language and an internet connection. Career path Armed with the Paralegal & Legal Secretary bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Paralegal & Legal Secretary bundle lays a solid groundwork. Certificates CPD QS PDF Certificates Digital certificate - £4.99 CPD QS Hardcopy Certificate Hard copy certificate - £11.99

Overview: ***Get Free (PDF +Hard Copy) Certificates worth £180 as a Gift*** Learn how to start a flourishing career in Construction Management with our Construction Management, Building Surveying & Quantity Surveying Diploma course. This Construction Management course will teach you building surveying and construction management. It will teach you various aspects of construction management, ranging from cost management to legal topics. It will also train you in building surveying, covering the cores of Construction Management, Service Inspections, report writing, and more. With a single payment, you will gain access to the Construction Management & Building Surveying Diploma including 11 Premium courses for Construction Manager/ Quantity surveyor, original hardcopy certificate, a transcript and a student ID card. Courses included in this Construction Management, Building Surveying & Quantity Surveying bundle: Course 01: Building Surveying and Construction Management Diploma Course 02: Surveying Basics Course 03: Quantity Surveying Diploma Course 04: Construction Cost Estimation Diploma Course 05: Workplace Health and Safety Diploma Course 06: Manual Handling Level 2 Course 07: Real Estate Investor Level 3 Course 08: Property Law and Legislation Course 09: Working at Height Awareness Diploma Course 10: Office Skills Course 11: RIDDOR Training Learning Outcomes: Learn about essential elements of Construction Management Study the different types of parties and professionals in the construction process Get a solid introduction to Building Information Modelling (BIM) Explore the different steps of the building surveying process. Understand the principles and background of Quantity Surveying Discover how to accurately write reports as a Building Quantity Surveyor/ Manager Become confident in the acts of procurement and bill charging Learn about the main types of cost estimates Learn about building procurement and contract administration Explore how to manage materials for construction Gain an understanding of cost management Key Features of the Course: FREE Construction Management CPD-accredited certificate Get a free student ID card with Construction Management training (£10 applicable for international delivery) Lifetime access to the Construction Management course materials The Construction Management program comes with 24/7 tutor support Get instant access to this Construction Management course Learn Construction Management training from anywhere in the world The Construction Management training is affordable and simple to understand The Construction Management training is an entirely online Enrol today to deepen your understanding of Construction Management, Building Surveying & Quantity Surveying. Description: This Construction Management diploma offers learners the opportunity to acquire the skills that are highly valued in this field. With this Certification, graduates are better positioned to pursue career advancement and higher responsibilities within the Construction Management setting. The skills and knowledge gained from this Construction Management course will enable learners to make meaningful contributions to related fields, impacting their experiences and long-term development. ★★★ Course Curriculum of the Construction Management, Building Surveying & Quantity Surveying Bundle ★★★ Course 01: Building Surveying and Construction Management Diploma Construction Cost Estimation Introduction to Construction Management Cost Estimation Role of Cost Estimator and New Aspects of Cost Estimation Elements and Factors influencing Cost Estimation Elements and Factors influencing Cost Estimation Cost Management Management of Material Building Surveyor Training Building Survey: An Introduction Building Law Principles Building Procurement and Contract Administration Building Information Modelling Building Technology The Procedure of Building Survey and Surveys of Historic Buildings Beginning of the Survey: Foundation and In-Depth Survey in Walls Ground Level Investigation: Floors and Investigation Above the Ground: Roofs and Chimneys Inspection of Joinery and Woodwork Finishes and Surfaces of the Building Services Inspection Building Pathology Building Adaptation Understanding Work Breakdown Structure Report Writing Legal Aspects =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the Construction Management & Building Surveying course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £9.99*11 = £109) Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99) Who is this course for? This Construction Management, Building Surveying & Quantity Surveying for everyone. Requirements No Requirements to study Construction Management, Building Surveying & Quantity surveying. Career path This comprehensive Construction Management, Building Surveying & Quantity Surveying course is ideal for anyone who wants to take their professional development to the next level and fast track their career in any of the following roles: Manager Cost Estimator Worker Property Developer Independent builder or decorator Quantity surveyor Assistant Quantity Surveyor Project Manager Site Manager Certificates Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Building Surveying and Construction Management Diploma) absolutely Free! Other Hard Copy certificates are available for £14.99 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Digital certificate - Included

Get ready for an exceptional online learning experience with the Leadership & Managementbundle! This carefully curated collection of 30 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Leadership & Management is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Leadership & Management package has something for everyone. As part of the Leadership & Management package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Leadership & Management bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following Leadership & ManagementCPD Accredited Courses: Course 01: Leadership and Management Course Course 02: Building a Foundation for Leadership Success Course 03: Inspirational Leadership Skills: Practical Motivational Leadership Course 04: Creating an Innovation Culture Course 05: Day-to-Day Leadership Course 06: The Principles of Ethical Leadership Course 07: Leadership Skills For Organisational Development Course 08: Foundations of Leadership and Negotiation Skills Development Course 09: Supervisor Training Course 10: UK Employment Law Course 11: Delegation Skills Course 12: Personal Development Masterclass Course 13: Emotional Intelligence and Human Behaviour Course 14: Team Management Level 5 Course 15: Talent Management Level 3 Course 16: Diary Management Course 17: Business Management Course 18: Administrative Management Course 19: Project Management Course 20: Courageous Communication Strategies for Lead Course 21: Body Language Masterclass Communication Through Movement Course 22: Public Speaking: Presentations like a Boss Course 23: Equality, Diversity and Discrimination Course 24: Workplace Productivity Training Course 25: Legal Secretary and Office Skills Diploma Course 26: Conflict Resolution Course 27: Workplace Stress Management Course 28: Diploma in Risk Management Level 7 Course 29: Dealing With Difficult People In Life & Work Course 30: Decision-Making in High-Stress Situations What will make you stand out? Upon completion of this online Leadership & Management bundle, you will gain the following: CPD QS Accredited Proficiency with this Leadership & Management bundle After successfully completing the Leadership & Management bundle, you will receive a FREE CPD PDF Certificates as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this title bundle The online test with immediate results You can study and complete the Leadership & Management bundle at your own pace. Study for the Leadership & Management bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Leadership & Management bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Leadership & Management, a rich anthology of 30 diverse courses. Each course in the Leadership & Management bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisLeadership & Management bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Leadership & Management bundle offers you the flexibility and convenience to learn at your own pace. Make the Leadership & Management package your trusted companion in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Leadership & Management bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements You are cordially invited to enroll in this Leadership & Management bundle; please note that there are no formal prerequisites or qualifications required. We've designed this curriculum to be accessible to all, irrespective of prior experience or educational background. Career path Unleash your potential with the Leadership & Management bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Leadership & Managementbundle package. Certificates CPD Quality Standard Certificate Digital certificate - Included 30 CPD Quality Standard Certificates - Free

FREE QLS Hard Copy Certificate | 10 FREE CPD Courses & PDF Certificates | 180 CPD Points | Lifetime Access | Tutor Help