3800 Office Skills courses

Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '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 Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' 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. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. 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

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

📚 Unlock Your Potential: Administrative Assistant Course! 🖇️ Are you ready to embark on a career as an efficient and indispensable administrative assistant? Enroll in our Administrative Assistant Course, a comprehensive program meticulously crafted to equip you with the essential skills and knowledge needed to thrive in administrative roles. Join us on a transformative journey where organization, communication, and efficiency are the keys to success. 🌟 Module 1: Introduction to Administrative Assistance Begin your journey with Module 1, where you'll gain a comprehensive understanding of the role and responsibilities of administrative assistants. Learn the foundational principles that underpin effective administrative support, setting the stage for your success. 💻 Module 2: Office Technology and Equipment Master the tools of the trade in Module 2. Explore a range of office technologies and equipment, from software applications to hardware devices, empowering you to leverage technology to streamline administrative tasks and enhance productivity. 🗂️ Module 3: Organizational Skills and Task Prioritization Optimize your organizational skills in Module 3. Discover techniques for managing workflows, prioritizing tasks, and maintaining efficient systems, ensuring that you can juggle multiple responsibilities with ease and effectiveness. 📝 Module 4: Business Correspondence and Documentation Refine your communication skills in Module 4. Learn the art of crafting professional business correspondence, including emails, memos, and reports, and hone your documentation skills to ensure accuracy and clarity in all written communications. 🤝 Module 5: Meeting and Event Coordination Become a master of coordination in Module 5. Explore the ins and outs of meeting and event planning, from scheduling and logistics to execution and follow-up, ensuring that every gathering runs smoothly and efficiently. 💬 Module 6: Office Communication and Interpersonal Skills Cultivate your interpersonal skills in Module 6. Learn to navigate office dynamics, communicate effectively with colleagues and stakeholders, and build positive working relationships that contribute to a harmonious and productive workplace environment. 🧳 Module 7: Travel Arrangements and Expense Management Become a logistical wizard in Module 7. Explore the intricacies of travel arrangements and expense management, mastering the art of coordinating travel itineraries, accommodations, and expenses with precision and efficiency. 🗄️ Module 8: Records Management and Data Security Ensure compliance and confidentiality in Module 8. Learn best practices for records management and data security, including file organization, document retention policies, and measures to safeguard sensitive information. 🚀 Why Choose Our Administrative Assistant Course? Comprehensive Curriculum: Covering all essential aspects of administrative support, ensuring that you are well-prepared for the demands of the role. Practical Applications: Engage in hands-on exercises, case studies, and simulations to reinforce learning and build practical skills. Expert Instruction: Learn from experienced administrative professionals who bring real-world insights and expertise to the course. Career Advancement: Gain a valuable credential that can open doors to a wide range of administrative opportunities and career advancement prospects. 🎓 Who Should Enroll? Aspiring Administrative Assistants Office Administrators Executive Assistants Office Managers Anyone Seeking to Enhance Administrative Skills 🌐 Empower Your Career Today! Elevate your administrative skills and unlock new opportunities in the dynamic world of office support. Enroll now in the Administrative Assistant Course and take the first step toward a rewarding and fulfilling career as a trusted administrative professional. Your journey to success starts here! 🚪🔑📊 Course Curriculum Module 1 Introduction to Administrative Assistance. Introduction to Administrative Assistance. 00:00 Module 2 Office Technology and Equipment. Office Technology and Equipment. 00:00 Module 3 Organizational Skills and Task Prioritization. Organizational Skills and Task Prioritization. 00:00 Module 4 Business Correspondence and Documentation. Business Correspondence and Documentation. 00:00 Module 5 Meeting and Event Coordination. Meeting and Event Coordination. 00:00 Module 6 Office Communication and Interpersonal Skills. Office Communication and Interpersonal Skills. 00:00 Module 7 Travel Arrangements and Expense Management. Travel Arrangements and Expense Management. 00:00 Module 8 Records Management and Data Security. Records Management and Data Security. 00:00

5 STAR Rated | 17 in 1 Premium Bundle | CPD Certified | Free PDF Certificate | Lifetime Access

Are you looking forward to Project Management training, the most demanding skills, for the ongoing year and beyond? Then you are in the perfect place. Let's explore! A project management training course is an intensive training program that teaches managers how to effectively manage projects and people. Managers must understand the various elements of a project, as well as the different skills and qualities required to effectively lead projects. Most training programs are taught by project managers who have completed their own training courses and earned certifications. You will get 4 FREE CPD Accredited Course to make your career more magnificence! FREE Courses includes: Course 01: Agile Scrum Master Course 02: Team Management Course 03: Time Management Course 04: Office Skills Project Management course Basic Learning Outcomes: Upon successful completion of this highly appreciated Project Manager Course, you'll be a skilled professional, besides- Recognise what project management entails. Examine the advantages of learning project management techniques. Determine the life-cycle phases of a project. To divide a project into clearly manageable segments, use a simple lifecycle. List the different project planning instruments. Talk about the significance of finishing projects on schedule. You have the peace of mind that Project Manager course provides the top of the range content in the market. So, stand out in the job market by completing the course. Get CPD accredited certificate and add it to your resume to impress your employers. Key Highlights for Project Manager Course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced course modules Course Curriculum: Unit 01: Introduction Unit 02: Project Management Framework Unit 03: Integration Management Unit 04: Stakeholder Management Unit 05: Project Scope Management Unit 06: Schedule Management Unit 07: How Much/Many of the Project Unit 08: Where in the Project Unit 09: How Things are Done on a Project? Certification CPD Accredited (CPD QS) Certificate Digital (PDF) & Hardcopy certificates are available CPD 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Project Manager course. Besides, this course is ideal for- Office Manager Office Administrator Management Leader Requirements To enrol in this Project Manager course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Project Manager, such as- Project Management Office Manager Project Management Lead Project Management Administrator Certificates CPD Accredited PDF Certificate Digital certificate - Included 4 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

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.

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Learn to use Excel’s most powerful features on this 2-day advanced Excel training course. This course is hands-on. It includes plenty of time to experiment with what you are being taught and ask questions. By the time you finish, you’ll be an expert Excel user.  ✔ A complete course that covers all of Excel’s most advanced functions.  ✔ Friendly expert trainers, small groups and a comfortable place to learn.  ✔ Ongoing support & help with any issues you may have after the course. Our courses are delivered in Guildford, London, Online, or even on-site at your offices!

Dive into the intricate world of Office Facility Management, where every detail matters. Learn to harness office procedures and streamline work flow for optimal performance.