2686 Office Skills & Productivity courses delivered On Demand

Master Microsoft Office 2016 with our comprehensive course tailored for beginners. Learn essential skills in Word, Excel, PowerPoint, and more to boost your productivity and efficiency. Perfect for beginners looking to enhance their proficiency in office software. Enroll now and unlock the full potential of Microsoft Office!

Excel Crash 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 Excel Crash 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 03 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. Analysis of Twitter Dataset and Designing Heatmaps Introduction to the Excel crash course 00:06:00 Understanding the Twitter Dataset 00:05:00 Extracting Other Details for Analysis 00:09:00 Creating Pivot Tables 00:08:00 Applying Conditional Formatting using Color Scales 00:03:00 Adding Slicers to Dashboard 00:02:00 Applying Custom Number Formats 00:03:00 Adding Custom Images to Charts 00:11:00 Interlude - Data Manipulation Challenge 00:02:00 Adding Heatmap Legend 00:02:00 Wrapping Up - Introduction to Open Analytics 00:02:00 Advanced Currency Converter using Dynamic Arrays Introduction to Modern Excel Tables and Dynamic Arrays 00:11:00 Using Power Query for Data Manipulation 00:08:00 Applying Power Query Data Transformations 00:06:00 Structured Table Referencing 00:12:00 XLOOKUP Function and Pivot Table Calculations 00:05:00 Laundry Service Model and Invoicing Dashboard Introduction to the Project 00:01:00 Overview of the Laundry Model Project 00:04:00 Understanding the Inputs 00:03:00 Formatting the Input Tables 00:04:00 Duplicate and Combine Tables with Power Query 00:09:00 Rounding Digits in Power Query 00:02:00 Load Specific Tables from Power Query 00:02:00 Feature Extraction and Named Ranges 00:10:00 Combining Elements - Data Validation with Named Ranges 00:08:00 Combining Elements - Understanding the INDIRECT Function 00:02:00 Combining Elements - Dynamic Drop-down Menu with Data Validation 00:04:00 Combining Elements - INDEX and MATCH with Multiple Criteria 00:12:00 Understanding the MATCH Formula with Multiple Criteria 00:06:00 Business Invoice Dashboard Design 00:06:00

Learn to design, plan, and scale cloud implementations with Google Cloud Platform's BigQuery. This course will walk you through the fundamentals of applied machine learning and BigQuery ML along with its history, architecture, and use cases.

Team management course will teach you how to build high-performance teams, and how to manage multicultural teams effectively.

You will learn how to become a Python developer through this course.

Advance your Python skills with Level 2 Programming! From strings and operators to control flow and games, this course sharpens your coding prowess, culminating in a hands-on Python project. Ideal for those seeking to deepen their understanding and application of Python.

Course Overview Acquiring an expert hand in JavaScript can be massive support for climbing the career ladder. The JavaScript Data Structures Foundation Course is here to improve your Java skills. In the course, you will learn the essentials of JavaScript data structure and add one more valuable skill set to your list. The JavaScript Data Structures Foundation Course will teach you the fundamentals of JavaScript concepts. There will be extensive lessons on how to list and stack data structures. You will become skilled in implementing content. The modules will cover detailed information about setting data structure and the skills to implement different set features. You will become an expert in creating unique sets. In this step by step process, you will achieve the expertise to build a solid foundation in this subject.  This JavaScript Data Structures Foundation Course will provide you with theoretical knowledge and practical skills on JavaScript data structure. Enroll the course and boost your career in the relevant sector. Learning Outcomes Learn about the essential JavaScript concepts Comprehend the skills to list and stack data structures Understand the process of implementing contents and clear features Enrich your knowledge of queue data structure Identify the challenges and gain the skills to overcome them Know the procedure of creating a unique set Who is this course for? Web Developers, programmers or anyone interested to build their skills in this area. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path  The JavaScript Data Structures Foundation Course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Programmer Web Developer Introduction Welcome to the Course 00:03:00 Essential Concepts Essential Concepts 00:02:00 Constructor Function 00:09:00 Protoype 00:04:00 Class 00:04:00 List Data Structure List Data Structure 00:01:00 Creating Class For List Data Structure 00:03:00 Implementing Add And Remove Feature 00:09:00 Working On Find And Remove Feature 00:08:00 Creating InsertAfter Feature 00:05:00 Implementing Contains And Clear Feature 00:04:00 Challenge - Work On Traverse List Features 00:03:00 Solution - Implementing List Traverse Features 00:08:00 Challenge - Work On DisplayElementNameOnPostion Features 00:01:00 Solution - Implementing DisplayElementNameOnPostion Features 00:06:00 Stack Data Structure Stack Data Structure 00:03:00 Using Object To Create Stack Class 00:04:00 Implementing Push and Pop Feature 00:09:00 Working with Peek and Clear Feature 00:04:00 Challenge - Extend Stack Class Feature 00:01:00 Solution - Extending Stack Class Feature 00:03:00 Challenge - Convert Stack Class From Object To Array Class 00:01:00 Solution - Converting Stack Class From Object To Array Class 00:05:00 Queue Data Structure Queue Data Structure 00:03:00 Using Object To Create Queue Class 00:04:00 Implementing Enqueue Feature 00:03:00 Implementing Tricky Dequeue Feature 00:09:00 Working On PeeK Size and Clear Features 00:03:00 Extending Features With Two Extra Methods 00:06:00 Challenge Convert Queue Class From Object To Array Class 00:01:00 Solution Converting Queue Class From Object To Array Class 00:04:00 Set Data Structure Set Data Structure 00:02:00 Creating Set Class 00:03:00 Implementing Add And Remove Feature 00:09:00 Working On Contains, Show And Size Method 00:05:00 Creating Unique Set 00:09:00 Adding Mutual Members Feature 00:04:00 Challenge Implement Difference Set Feature 00:02:00 Solution Implementing Difference Set Feature 00:03:00 Final Thought Final Thought 00:01:00 Resources Resources - JavaScript Data Structures Foundation Course 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Whether you are already a professional in the IT industry or aspire to be one, the more programming languages you will learn, the faster you will climb the career ladder. The PHP Tutorial for Absolute Beginners - PHP Course 2021 course is here to help you build your expertise in one more programming language and enrich your CV. In this PHP Tutorial for Absolute Beginners - PHP Course 2021 course, you will receive the essential knowledge and skills required for PHP coding. First, the course will introduce you to the core elements of PHP. Here, you will get the opportunity to introduce yourself to different operators. The highly informative modules will enhance your understanding of loops, arrays and functions. The course will equip you with the key skills to read and write PHP code. Join this PHP Tutorial for Absolute Beginners - PHP Course 2021 course today and prepare yourself to build a promising career in the relevant industry. Learning Outcomes Understand the course principles of PHP programming language Familiarize with the steps of installing PHP Learn about the basic syntax, variables, and constants Enrich your understanding of Arithmetic Operators, Assignment Operators and more Explore different functions of PHP code Who is this course for? This PHP Tutorial for Absolute Beginners - PHP Course 2021 course is for those interested in learning the PHP programming language for the very first step. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The PHP Tutorial for Absolute Beginners - PHP Course 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Programmer Unit 01: Introduction Introduction 00:07:00 Unit 02: Installation Installing Xampp 00:10:00 Installing Sublime 00:03:00 Unit 03: Basic Syntax and First Steps Basic Syntax 00:12:00 Echo 00:04:00 Print and Differences between Echo and Print 00:08:00 Variables 00:07:00 Constants 00:06:00 Comments 00:05:00 Single vs Double Quotes 00:04:00 Unit 04: Data Types Integers 00:05:00 Floats 00:01:00 Booleans 00:02:00 Strings 00:03:00 Nulls 00:02:00 Unit 05: Operators Arithmetical Operators 00:05:00 Assignment Operators 00:06:00 Comparison Operators 00:06:00 Increment and Decrement Operators 00:04:00 Unit 06: Statements If Elseif Else 00:09:00 Switch 00:06:00 Unit 07: Loops While 00:09:00 For 00:06:00 Unit 08: Arrays Arrays and Indexed Arrays 00:06:00 Associative Arrays 00:06:00 Multidimensional Arrays 00:08:00 Unit 09: Functions Functions 00:07:00 Functions with Arguments 00:06:00 Unit 10: Super Globals Intro to Super Globals 00:04:00 Post 00:11:00 Get 00:14:00 Sessions pt. 1 00:09:00 Sessions pt. 2 00:08:00 Unit 11: Date and Time Date 00:04:00 Time 00:09:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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 Transition from 8.1 will give you the knowledge of Windows 8.1 users become familiar with the many changes that have been made to Windows with release. It focuses on new and improved features in Windows 10, such as the return of the Start menu, the addition of Microsoft Edge, and more. If you are interested to increase your knowledge and skills, you can join this course now. Learning Outcomes: Learn to use desktop and Start menu, multitask using apps, and focus on the new Snap Assist feature Familiarize yourself with notifications, Action Center, Contana, search fields, and virtual desktops in the Windows 10 environment before learning how to connect devices to PC Customize the Window according to your needs using the Settings window and Control panel to modify Windows settings Further personalize the lock screen, desktop, and get introduced to OneDrive - a prominent feature of this version of Windows Work with 3 key productivity apps: Mail, Calendar and Camera Have fun with the entertainment side of Windows 10 by getting to know Groove Music, Movies &TV, and Xbox apps Browse the internet using Microsoft Edge 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 Transition from 8.1 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 Transition from 8.1 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. Navigating the Windows 10 Environment Navigate the Desktop 01:00:00 Explore the Start Menu 01:00:00 Multitask with Apps 00:15:00 Working with the Windows 10 Environment View Notifications 00:30:00 Search Your Computer 01:00:00 Work with Virtual Desktops 00:30:00 Connect Devices to Your PC 00:30:00 Customizing the Windows 10 Environment Change Basic Windows Settings 01:00:00 Customize the Lock Screen 00:30:00 Customize the Desktop 00:30:00 Store and Share Files with OneDrive 00:30:00 Working with Apps in Windows 10 Use Mail 01:00:00 Use Calendar 01:00:00 Use Camera 00:30:00 Having Fun in Windows 10 Use Groove Music 00:30:00 Use Movies & TV 00:30:00 Use Xbox 01:00:00 Using Microsoft Edge Navigate Microsoft Edge 00:30:00 Use Microsoft Edge 01:00:00 Manage Tabs 00:15:00 Modify Microsoft Edge Options 01:00:00 Mock Exam Mock Exam- Microsoft Windows 10 Transition from 8.1 00:20:00 Final Exam Final Exam- Microsoft Windows 10 Transition from 8.1 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 2 Hours 26 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Fusion 360 graphic designing Understand the core competencies and principles of Fusion 360 graphic designing Explore the various areas of Fusion 360 graphic designing Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert graphic designer Microsoft Office Excel 2016: Part 2 (Intermediate Level) Course Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive excel 2016 intermediate level course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel 2016 intermediate leve course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this excel 2016 intermediate leve course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive excel 2016 intermediate leve course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This excel 2016 intermediate leve course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This excel 2016 intermediate leve course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This excel 2016 intermediate leve course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Course Overview Introduction and Course Overview 00:02:00 Working with Functions Working and Function - Introduction 00:01:00 Work with Ranges - Introduction 00:01:00 Name and Edit Ranges 00:05:00 Use Defined Names in a Formula 00:03:00 Locate and Use Specialized Functions 00:05:00 Work with Logical Functions - Introduction (02:13) 00:02:00 IF Function 00:04:00 AND, OR and NOT Function 00:05:00 Combine Functions 00:06:00 Functions Similar to the IF Function 00:05:00 Work with Date and Time Functions - Introduction 00:01:00 TODAY, NOW and DATE Functions 00:03:00 NETWORKDAY, WEEKDAY, WORKDAY and ISOWeeknum Functions 00:05:00 Work with Text Functions - Introduction 00:01:00 LEFT, RIGHT and MID Functions 00:02:00 FIND Function 00:03:00 Text to Columns Feature 00:03:00 CONCATENATE Function 00:03:00 UPPER, LOWER and PROPER Functions 00:02:00 Practice File Working with Functions Practice File Working with Functions 00:00:00 Working with Lists Sort Data - Introduction 00:01:00 Sort Data 00:03:00 Filter Data - Introduction 00:01:00 Filter Data 00:02:00 Query Data with Database Functions 00:01:00 Database Functions 00:03:00 Outline and Subtotal Data - Introduction 00:01:00 Use Subtotals to Summarize Data 00:03:00 Practice File Working with Lists Practice File Working with Lists 00:00:00 Assessment Mock 1 Assessment Mock 1 - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Analyzing Data Create and Modify Tables - Introduction 00:01:00 Create and Modify Tables 00:06:00 Use Summary Functions in Tables 00:03:00 Apply Intermediate Conditional Formatting - Introduction 00:01:00 Apply Intermediate Conditional Formatting 00:02:00 Apply Advanced Conditional Formatting - Introduction 00:01:00 Use Logical Functions to Apply Conditional Formatting 00:03:00 Practice File Analyzing Data Practice File Analyzing Data 00:00:00 Visualizing Data with Charts Create Charts - Introductions 00:01:00 Create Charts 00:04:00 Modify and Format Charts - Introduction 00:01:00 Modify and Format Charts 00:05:00 Use Advanced Chart Features - Introduction 00:01:00 Create a Dual-Axis Chart 00:04:00 Create a Chart Template 00:03:00 Visualizing Data with Charts - Best Practice 00:04:00 Practice File Visualizing Data with Charts Practice File Visualizing Data with Charts 00:00:00 Using PivotTables and PivotCharts Create a PivotTable - Introductions 00:01:00 Create a PivotTable 00:04:00 Analyze PivotTable Data - Introduction 00:01:00 Analyze PivotTable Data 00:04:00 Present Data with PivotCharts - Introduction 00:01:00 Present Data with PivotCharts 00:05:00 Filter Data by Using Timelines and Slicers - Introduction 00:01:00 Filter Data by Using Slicers and Timelines 00:04:00 Bonus Lecture 00:01:00 Practice File Using PivotTables and PivotCharts Practice File Using PivotTables and PivotCharts 00:00:00 Assessment Mock 2 Assessment Mock 2 - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Final Assessment Final Assessment - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00