488 Office Productivity courses

Duration 5 Days 30 CPD hours This course is intended for This course is intended for anyone who is new to software development and wants, or needs, to gain an understanding of programming fundamentals and object-oriented programming concepts. They will typically be high school students, post-secondary school students, or career changers, with no prior programming experience. They might want to gain an understanding of the core programming fundamentals before moving on to more advanced courses such as Programming in C#. Overview Explain core programming fundamentals such as computer storage and processing. Explain computer number systems such as binary. Create and use variables and constants in programs. Explain how to create and use functions in a program. Create and use decisions structures in a computer program. Create and use repetition (loops) in a computer program. Explain pseudocode and its role in programming. Explain the basic computer data structures such as arrays, lists, stacks, and queues. Implement object-oriented programming concepts. Create and use classes in a computer program. Implement encapsulation, inheritance, and polymorphism. Describe the base class library (BCL) in the .NET Framework. Explain the application security concepts. Implement simple I/O in a computer program. Identify application errors and explain how to debug an application and handle errors. Identify the performance considerations for applications. In this 5-day course, students will learn the basics of computer programming through the use of Microsoft Visual Studio 2022 and the Visual C# and Visual Basic programming languages. The course assumes no prior programming experience and introduces the concepts needed to progress to the intermediate courses on programming, Programming in C#. The focus will be on core programming concepts such as computer storage, data types, decision structures, and repetition by using loops. The course also covers an introduction to object-oriented programming covering classes, encapsulation, inheritance, and polymorphism. Coverage is also included around exception handling, application security, performance, and memory management. 1 - INTRODUCTION TO CORE PROGRAMMING CONCEPTS * Computer Data Storage and Processing * Application Types * Application Lifecycle * Code Compilation 2 - CORE PROGRAMMING LANGUAGE CONCEPTS * Syntax * Data Types * Variables and Constants 3 - PROGRAM FLOW * Introduction to Structured Programming Concepts * Introduction to Branching * Using Functions * Using Decision Structures * Introducing Repetition 4 - ALGORITHMS AND DATA STRUCTURES * Understand How to Write Pseudocode * Algorithm Examples * Introduction to Data Structures 5 - ERROR HANDLING AND DEBUGGING * Introduction to Program Errors * Introduction to Structured Error Handling * Introduction to Debugging 6 - INTRODUCTION TO OBJECT-ORIENTED PROGRAMMING * Introduction to Complex Structures * Introduction to Structs * Introduction to Classes * Introducing Encapsulation 7 - MORE OBJECT-ORIENTED PROGRAMMING * Introduction to Inheritance * Introduction to Polymorphism * Introduction to .NET and the Base Class Library 8 - INTRODUCTION TO APPLICATION SECURITY * Authentication and Authorization * Code Permissions on Computers * Introducing Code Signing 9 - CORE I/O PROGRAMMING * Using Console I/O * Using File I/O 10 - APPLICATION PERFORMANCE AND MEMORY MANAGEMENT * Value Types vs Reference Types * Converting Types * The Garbage Collector ADDITIONAL COURSE DETAILS: Nexus Humans 55337 Introduction to Programming 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 55337 Introduction to Programming 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.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft Office 2010, 2013, or 2016 edition of the Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. Overview In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment. You will: Sign in, navigate, and identify components of the Office 365 environment. Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive© for Business, and Delve. Collaborate and work with colleagues using the Yammer and Planner apps. Use email and manage contacts with Outlook on the web. Collaborate using Teams. Configure Teams. This course introduces working with shared documents in the familiar Office 365 online apps?Word, PowerPoint©, and Excel©?as an alternative to installing the Microsoft© Office desktop applications. This course also introduces several productivity apps including Yammer?, Planner, and Delve© that can be used in combination by teams for communication and collaboration. Prerequisites * Outlook - Part 1 * PowerPoint - Part 1 * Word 2016 - Part 1 * Using Microsoft Windows 10 1 - GETTING STARTED WITH OFFICE 365 * Topic A: Sign In to Office 365 * Topic B: Navigate the Office 365 Environment 2 - COLLABORATING WITH SHARED FILES * Topic A: Work with Shared Documents in SharePoint * Topic B: Edit Documents in Office Online * Topic C: Collaborate on the SharePoint Site * Topic D: Work with OneDrive for Business and Delve 3 - USING PRODUCTIVITY APPS * Topic A: Work with Productivity Apps in Combination * Topic B: Broadcast Messages with Yammer * Topic C: Manage Tasks with the Planner App 4 - USING OUTLOOK ON THE WEB * Topic A: Send and Receive Email * Topic B: Manage Contacts * Topic C: Schedule Appointments * Topic D: Personalize Outlook on the Web 5 - COLLABORATING WITH TEAMS * Topic A: Overview of Microsoft Teams * Topic B: Converse and Share in Teams * Topic C: Call and Meet in Teams * Topic D: Collaborate with Office 365 Apps and Teams 6 - CONFIGURING TEAMS * Topic A: Configure Teams * Topic B: Configure Channels * Topic C: Configure Tabs

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - EXECUTING A SIMPLE QUERY * Connect to the SQL Database * Query a Database * Save a Query * Modify a Query * Execute a Saved Query 2 - PERFORMING A CONDITIONAL SEARCH * Search Using a Simple Condition * Compare Column Values * Search Using Multiple Conditions * Search for a Range of Values and Null Values * Retrieve Data Based on Patterns 3 - WORKING WITH FUNCTIONS * Perform Date Calculations * Calculate Data Using Aggregate Functions * Manipulate String Values 4 - ORGANIZING DATA * Sort Data * Rank Data * Group Data * Filter Grouped Data * Summarize Grouped Data * Use PIVOT and UNPIVOT Operators 5 - RETRIEVING DATA FROM TABLES * Combine Results of Two Queries * Compare the Results of Two Queries * Retrieve Data by Joining Tables * Check for Unmatched Records * Retrieve Information from a Single Table Using Joins 6 - PRESENTING QUERY RESULTS * Save the Query Result * Generate an XML Report

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

Register on the Work Area Organisation for Increased Office Productivity today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Work Area Organisation for Increased Office Productivity is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! WHAT YOU GET WITH THE WORK AREA ORGANISATION FOR INCREASED OFFICE PRODUCTIVITY * Receive a e-certificate upon successful completion of the course * Get taught by experienced, professional instructors * Study at a time and pace that suits your learning style * Get instant feedback on assessments  * 24/7 help and advice via email or live chat * Get full tutor support on weekdays (Monday to Friday) COURSE DESIGN The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of * Video lessons * Online study materials CERTIFICATION After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. WHO IS THIS COURSE FOR: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. REQUIREMENTS: The online training is open to all students and has no formal entry requirements. To study the Work Area Organisation for Increased Office Productivity, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. COURSE CONTENT Work Area Organisation for Increased Office Productivity Module 01: Introduction 00:01:00 Module 02: Purge 00:02:00 Module 03: Redistributing 00:04:00 Module 04: Fences Software 00:04:00 Module 05: Create Work Spaces 00:06:00 Module 06: Proximity 00:04:00 Module 07: Lable What You Can 00:03:00 Module 08: Move to Digital 00:03:00 Module 09: Clean Your Desk Off 00:03:00 Module 10: Multiple Inboxes 00:03:00 Module 11: Mailings 00:03:00 Module 12: Discard Dates 00:03:00 Module 13: Magazines 00:02:00 Module 14: File Weekly 00:03:00 FREQUENTLY ASKED QUESTIONS Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

AUDIENCE This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS. PREREQUISITES You should have practical experience with Db2 for z/OS DURATION 2 days.  COURSE OBJECTIVES Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS. COURSE CONTENT * Unit 1: Db2 v12 Function Levels: Selected Highlights * Unit 2: Migrating to Db2 13 * Unit 3: Availability & Scalability * Unit 4: Performance * Unit 5: Application Management and SQL Changes * Unit 6: SQL Data Insights * Unit 7: Security * Unit 8: IBM Db2 Utilities * Unit 9: Instrumentation and Serviceability

A course by Xpert Learning RequirementsA computer or mobile device with an internet connectionA basic understanding of Microsoft Office applicationsA willingness to learn and grow Audience Business Professionals Administrative assistants Project managers Team leaders Office managers Business owners Anyone who wants to advance their career in the workplace AUDIENCE * Business Professionals * Administrative assistants * Project managers * Team leaders * Office managers * Business owners * Anyone who wants to advance their career in the workplace

Duration 1 Days 6 CPD hours This course is intended for This course is for individuals who are new to Adobe Acrobat Pro, but need to create and share PDF files and PDF portfolios. Students should have some experience using office productivity applications, such as word processor, a multimedia presentation application, or a spreadsheet application. Overview In this course, you will create and work with PDF documents. You will: Access information in a PDF document Create and save PDF documents Navigate content in a PDF document Modify PDF documents Review PDF documents Convert PDF documents Adobe Acrobat Pro DC puts the power of the Portable Document Format, literally, at your fingertips. By taking advantage of the functionality & features available in Acrobat, you will ensure the integrity of your documents regardless of who views them. Prerequisites To ensure your success in this course, you should have basic experience with computers and exposure to Windows 8, as well as common productivity tools such as Microsoft Office Word & Microsoft Office PowerPoint. You can obtain this level of skill & knowledge by taking the following courses: Using Microsoft Windows 8 Microsoft Windows 8 Transition from Windows 7 Microsoft Office Word 2013: Part 1 Microsoft Office PowerPoint 2013: Part 1 1 - ACCESSING PDF DOCUMENTS * Topic A: Open a PDF Document * Topic B: Browse a PDF Document 2 - CREATING AND SAVING PDF DOCUMENTS * Topic A: Create and Save a PDF Document from an Existing Document * Topic B: Create a PDF Document from a Web Page * Topic C: Combine Multiple PDF Documents 3 - NAVIGATING CONTENT IN A PDF DOCUMENT * Topic A: Perform a Search in a PDF Document * Topic B: Search Multiple PDF Documents * Topic C: Work with Bookmarks * Topic D: Create Links and Buttons 4 - MODIFYING PDF DOCUMENTS * Topic A: Manipulate PDF Document Pages * Topic B: Edit Content in a PDF Document * Topic C: Add Page Elements 5 - REVIEWING PDF DOCUMENTS * Topic A: Add Comments and Markup * Topic B: Compare PDF Documents * Topic C: Initiate and Manage a Review * Topic D: Digitally Sign PDF Documents 6 - CONVERTING PDF FILES * Topic A: Reduce the File Size of a PDF Document * Topic B: Optimize PDF Files * Topic C: Convert and Reuse PDF Document Content

Level 5 QLS Diploma | QLS Endorsed Certificate Included | 10 CPD Courses & PDF Certificates | 145 CPD Points

Level 3, 5 & 7 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access