3419 Office Skills & Productivity courses in Cleckheaton delivered Online

Duration 5 Days 30 CPD hours This course is intended for This introductory-level Python course is geared for experienced users who want to use Python in web development projects, or system administrators and web site administrators who want to use Python to support their server installations, as well as anyone else who wants to automate or simplify common tasks with the use of Python scripts. Basic familiarity with any programming or scripting language would be helpful, along with a working, user-level knowledge of Unix/Linux, Mac, or Windows. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Throughout the hands-on course students, will learn to write essential Python scripts using the most current and efficient skills and techniques. Working in a hands-on learning environment, guided by our expert team, attendees will learn to: Create working Python scripts following best practices Use python data types appropriately Read and write files with both text and binary data Search and replace text with regular expressions Get familiar with the standard library and its work-saving modules Use lesser known but powerful Python data types Create 'real-world', professional Python applications Work with dates, times, and calendars Know when to use collections such as lists, dictionaries, and sets Understand Pythonic features such as comprehensions and iterators Write robust code using exception handling Mastering Python Programming is an introductory and beyond-level practical, hands-on Python training course that leads the student from the basics of writing and running Python scripts to more advanced features such as file operations, regular expressions, working with binary data, and using the extensive functionality of Python modules. Extra emphasis is placed on features unique to Python, such as tuples, array slices, and output formatting. This comprehensive, practical course provides an in-depth exploration of working with the programming language, not an academic overview of syntax and grammar. Students will immediately be able to use Python to complete tasks in the real world. An overview of Python What is python? Python Timeline Advantages/Disadvantages of Python Getting help with pydoc The Python Environment Starting Python Using the interpreter Running a Python script Python scripts on Unix/Windows Editors and IDEs Getting Started Using variables Builtin functions Strings Numbers Converting among types Writing to the screen Command line parameters Flow Control About flow control White space Conditional expressions Relational and Boolean operators While loops Alternate loop exits Array types About array types (AKA sequences) Lists and list methods Tuples Indexing and slicing Iterating through a sequence Nested sequences Sequence functions, keywords, and operators List comprehensions Generator Expressions Working with files File overview Opening a text file Reading a text file Writing to a text file Reading and writing raw (binary) data Converting binary data with struct Dictionaries and Sets About dictionaries Creating dictionaries Iterating through a dictionary About sets Creating sets Working with sets Functions Defining functions Parameters Global and local scope Nested functions Returning values Sorting The sorted() function Alternate keys Lambda functions Sorting collections Using operator.itemgetter() Reverse sorting Errors and Exception Handling Syntax errors Exceptions Using try/catch/else/finally Handling multiple exceptions Ignoring exceptions Modules and Packages The import statement Module search path Creating Modules Using packages Function and Module aliases An Introduction to Python Classes About o-o programming Defining classes Constructors Methods Instance data Properties Class methods and data Regular Expressions RE syntax overview RE Objects Searching and matching Compilation flags Groups and special groups Replacing text Splitting strings Using the Standard Library The sys module Launching external programs Math functions Random numbers Reading CSV data Dates and Times Working with dates and times Translating timestamps Parsing dates from text Formatting dates Calendar data Working with the File System Paths, directories, and filenames Checking for existence Permissions and other file attributes Walking directory trees Creating filters with fileinput Using shutil for file operations Advanced Data Handling Defaultdict and Counter Prettyprinting data structures Compressed archives (zip, gzip, tar, etc.) Persistent data Network Programming Using requests Grabbing web content Sending email Using SSH for remote access Using FTP Writing real-life applications Reading input files a la Unix Parsing command-line options Detecting the current platform Implementing logging Additional course details: Nexus Humans Mastering Python Programming (TTPS4820) 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 Mastering Python Programming (TTPS4820) 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 5 Days 30 CPD hours This course is intended for This course is intended for project team members and other key users (persons from special departments) responsible for creating and optimizing a cross location supply plan including production, procurement and distribution plans. In this course, students gain an understanding of how to create cross-location production plans, distribution resource plans, and procurement plans taking into account work center capacities, supplier capacities, and transportation capacities in SAP APO. Course Outline Overview of Supply Chain Planning in SAP SCM (APO), Integration with Demand Planning (DP) and Production Planning (PP/DS) Overview of exchanging master and transaction data with SAP ECC Master data for supply network planning, interchangeability and shelf live Configuring Supply Network Planning and interactive planning using planning books and macros Introduction to the Planner Home Page (EhP 3) Collaborative Supply Planning (supplier and manufacturer exchange data over the Internet) Integrated exception management in the alert monitor Discussions about the different planning methods: Heuristic including capacity leveling, optimization, capable-to-match, and VMI. Standard and advanced Cross-location safety stock planning Deployment: Implementing stock transport requisitions into manageable stock transport orders. Calculating and optimizing short-term replenishment plans for distribution centers and customers Transport Load Builder (TLB): Grouping stock transfers by threshold values for volumes, weight and pallets. Additional course details: Nexus Humans SCM230 SAP Supply Network Planning (APO-SNP) 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 SCM230 SAP Supply Network Planning (APO-SNP) 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.

Description: Windows 10 is the latest iteration of Microsoft's widely used Windows operating system. This new version of Windows incorporates hundreds of new features as well as improvements to existing ones. This Microsoft Windows 10 Certificate Course is designed to help both novice and experienced. By taking this course you will become familiar with the many changes that have been made to Windows. You will also be comfortable logging into Windows 10, completing basic actions using its user interface, customizing the user interface, understanding its security features, and using both Microsoft Edge and File Explorer. You can join this course to improve your skills. Learning Outcomes: Identify components of a personal computer, learn to sign into Windows 10, get familiarized with the user interface by exploring desktop and Start menu Multitask with apps, search computer, and view notifications Further your knowledge of Windows Store apps and Windows 10 navigation techniques Work with desktop windows, manage files and folders with File Explorer, and create files through desktop applications Browse the internet using Microsoft Edge, manage tabs and customize options Customize basic Windows settings, Lock screen, and desktop Configure passwords, use Windows Defender, and store and share files using OneDrive Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Windows 10 Certificate Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Windows 10 Certificate Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Windows 10 Certificate Course Identify Components of a Personal Computer 00:15:00 Sign Into Windows 10 00:15:00 Navigate the Desktop 00:30:00 Explore the Start Menu 00:30:00 Multitask with Apps 00:15:00 Search Your Computer 01:00:00 View Notifications 00:15:00 Windows 10 Navigation Summary 00:30:00 Manage Files and Folders with File Explorer 00:30:00 Create and Modify Files with Desktop Applications 00:30:00 Navigate Microsoft Edge 00:15:00 Use Microsoft Edge 00:30:00 Manage Tabs 00:15:00 Modify Microsoft Edge Options 00:30:00 Change Basic Windows Settings 00:30:00 Customize the Lock Screen 00:15:00 Customize the Desktop 00:15:00 Configure Passwords 00:15:00 Use Windows Defender 00:15:00 Store and Share Files with OneDrive 00:30:00 Mock Exam Mock Exam- Microsoft Windows 10 Certificate Course 00:20:00 Final Exam Final Exam- Microsoft Windows 10 Certificate Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Learn to connect team members from everywhere with the Microsoft Skype for Business 2016 course. Skype for Business is an instant messaging application that makes your office work easy and quick. You can instantly share your ideas and message using Microsoft Skype. The course shows you how to connect people or other team members anywhere using any devices or operating system Windows, Mac, iOS, and Android™. At first, the course familiarizes you with the user-interface and helps you to know the notification area icon. You will know how to bring remote participants into meeting spaces of all sizes using Skype for Business. The course discusses how you can use Skype to communicate with your colleagues in different ways such as instant message, audio messages, voice calling, video conferences, and more. Finally, the course teaches you to customize Skype including managing and creating groups, using recording features, and other options. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Skype for Business 2016 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Skype for Business 2016 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started TOPIC A: Getting Started 00:30:00 TOPIC B: Communicating with Contacts 00:30:00 TOPIC C: Updating Your Status Information 00:30:00 Working with Messages and Contacts TOPIC A: Sending Instant Messages, Part 1 00:30:00 TOPIC B: Sending Instant Messages, Part 2 00:45:00 TOPIC C: Managing Contacts 00:30:00 TOPIC D: Customizing the Contacts View 00:30:00 Joining Meetings and Calls TOPIC A: Setting up Meetings 00:30:00 TOPIC B: Participating in Meetings 00:30:00 TOPIC C: Presenting in Meetings 00:30:00 TOPIC D: Adding Interactivity to Meetings 00:45:00 Customizing Skype for Business TOPIC A: Customizing Contact Groups 00:30:00 TOPIC B: Using Recording Features 00:30:00 TOPIC C: Customizing Skype for Business Options 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Publisher helps you to create publications or documents so that you can print and distribute your contents. The Microsoft Publisher 2016 will help you to learn the features of Microsoft Publisher easily. You will also be able to know how to create a publication, how to format the text in the application, how to edit the existing text, or how to manage graphical images in your content, or how to prepare a publication for printing or electronic sharing. The Microsoft Publisher 2016 allows you to know all the essential features of Microsoft Publishers and make you an expert of the desktop application. Learning Outcomes: Creating simple publications while customizing the user interface Adding text to publications, organizing text boxes and picture holders, manage displays of content within text boxes and using building blocks Formatting paragraphs and texts in publication Skills in paragraph style and scheme application Publication text editing, presenting content in tables, and inserting symbols and special characters Manipulate picture appearance and add graphical objects Publication preparation for printing and sharing purposes Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Publisher 2016 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Publisher 2016 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Explore the Interface 00:30:00 Customize the Publisher Interface 00:30:00 Create a Publication 00:30:00 Add Text to a Publication 00:30:00 Organize Text Boxes and Picture Placeholders in a Layout 00:30:00 Control the Display of Content in Text Boxes 00:30:00 Use Building Blocks 00:30:00 Format Text and Paragraphs 00:30:00 Apply Paragraph Styles 00:30:00 Apply Schemes 00:15:00 Edit Text in a Publication 00:30:00 Present Content in Tables 00:30:00 Insert Symbols and Special Characters 00:30:00 Add Graphical Objects to a Publication 01:00:00 Manipulate the Appearance of Pictures 00:15:00 Save a Publication 00:30:00 Run the Design Checker 00:30:00 Preview and Print a Publication 00:30:00 Share a Publication 00:30:00 Activities Activities - Microsoft Publisher 2016 00:00:00 Mock Exam Mock Exam- Microsoft Publisher 2016 00:20:00 Final Exam Final Exam- Microsoft Publisher 2016 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description PL/SQL is program units which are composed by the Oracle Database server and stored in the database. The main function of PL/SQL is to hold SQL proclamation within its syntax. If you are interested to know more about SL/SQL function, and how it brings optimal competence in terms of 'procedural language', you may have a look at the Oracle 11g PL/SQL Beginner course. The course is designed in such a way that will assist the learners to know how it works with various strings, numbers, table row record, and error management. It also teaches the learner how to use different key data lexicon to synopsize and maintain the data. The learners will also be able to know about portability, productivity, and manageability of this most widely manipulative language. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Oracle 11g PL/SQL Beginner is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Oracle 11g PL/SQL Beginner is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Preparing Your Environment Course Setup 00:37:00 Working with Oracle Database Tools Selecting the Appropriate Database Tool 00:31:00 Language Features Understanding PL/SQL 00:18:00 PL/SQL Blocks 00:15:00 Working with SQL Plus 00:11:00 The DECLARE Clause DECLARE Clause Objects 00:16:00 PL/SQL Available Data Types 00:17:00 Declaring Simple Data Types and Assignments 00:12:00 Declaring Complex Data Types and Assignments 00:11:00 Declaring Complex RowTypes and Assignments 00:07:00 Declaring Complex Tables 00:08:00 Declaring Complex Records 00:08:00 Creating and Declaring User-Defined Types 00:09:00 The BEGIN Clause What Can Be Included in the BEGIN Clause 00:07:00 Working with CHAR and VARCHAR2 Variables 00:08:00 Handling String Literals 00:08:00 Working with Numeric Variables 00:07:00 Working with Date Variables 00:06:00 Assigning and Using Boolean Variables 00:08:00 Using Comparison Operators 00:07:00 Using SQL Functions 00:06:00 SQL DML within PL/SQL 00:15:00 Using SELECT 00:07:00 Exceptions and Embedded SQL 00:11:00 Using Sequences 00:14:00 Logic Control and Branching 00:07:00 Using GOTO 00:06:00 Working with LOOPS 00:19:00 Creating and Using the Indefinite Loop 00:07:00 Creating and Using the Conditional Loop 00:09:00 Using Nested Loops 00:12:00 Using the If-Then-Else 00:19:00 Using the CASE Statement 00:18:00 The EXCEPTION Clause What Are the Types of Exceptions 00:06:00 Trapping Exceptions 00:06:00 Identify Exception Details 00:11:00 Creating User-Defined Exceptions 00:11:00 Using SQLCODE and SQLERRM Objects 00:09:00 Understand the Implicit Cursor 00:15:00 Creating User-Defined Events 00:12:00 Explicit Cursors Understanding the Concept and Purpose of Explicit Cursors 00:18:00 Learn about Cursor Attributes 00:10:00 Using the Continue Statement 00:06:00 Working with Updateable Cursors 00:19:00 Creating and Using Cursor Parameters 00:15:00 FORLOOP Cursors 00:07:00 Nested Blocks Understanding Nested Blocks 00:11:00 Difference between Global vs Local Objects and Exceptions 00:13:00 Declared Subprograms Subprograms: How They Differ from Nested Blocks 00:18:00 Conclusion Conclusion 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course will take you from the basic structure of ASP.Net Core 5 to building and enhancing a functional website. You will deep dive into the concepts by creating a product catalog, connecting your application to a database, sending emails from your application, integrating a secure payment system into your application, and a lot more.

Overview Bookkeeping Tool : Google Sheets Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Bookkeeping Tool : Google Sheets Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Bookkeeping Tool: Google Sheets Unit 1: Introduction 00:03:00 Unit 2: Google Sheets Users 00:03:00 Unit 3: Cash Bookkeeping 00:04:00 Unit 4: Advantages of Google Sheets in Bookkeeping 00:02:00 Unit 5: Chart of Accounts 00:03:00 Unit 6: Templates view 00:02:00 Unit 7: Invoice Template 00:02:00 Unit 8: Creating an Expense Book 00:03:00 Unit 9: Creating the Profit and Loss Statement 00:06:00 Unit 10: Making Records in the Revenue Book 00:03:00 Unit 11: Making Records in the Expense book 00:04:00 Unit 12: How the Profit and Loss Statement Updates 00:03:00

Microsoft Word Masterclass is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Word Masterclass and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 3 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Manipulating Images Integrate Pictures and Text 00:15:00 Adjust Image Appearance 00:09:00 Insert Other Media Elements 00:02:00 Using Custom Graphic Elements Create Text Boxes and Pull Quotes 00:06:00 Add WordArt and Other Text Effects 00:05:00 Draw Shapes 00:07:00 Create Complex Illustrations with SmartArt 00:08:00 Collaborating on Documents Prepare a Document for Collaboration 00:09:00 Mark Up a Document 00:06:00 Review Markups 00:04:00 Merge Changes from Other Documents 00:06:00 Adding Document References and Links Add Captions 00:06:00 Add Cross References 00:08:00 Add Bookmarks 00:05:00 Add Hyperlinks 00:06:00 Insert Footnotes and Endnotes 00:05:00 Add Citations and a Bibliography 00:12:00 Securing a Document Suppress Information 00:08:00 Set Formatting and Editing Restrictions 00:06:00 Restrict Document Access 00:02:00 Add a Digital Signature to a Document 00:04:00 Using Forms to Manage Content Create Forms 00:09:00 Modify Forms 00:03:00 Automating Repetitive Tasks with Macros Automate Tasks by Using Macros 00:10:00 Create a Macro 00:19:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access