843 Numbers courses delivered Online

Level 5 QLS Endorsed Course | CPD Accredited | Audio Visual Training | Free PDF Certificate | Lifetime Access

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

Have you ever ordered something from Amazon and received the wrong product? Chances are, no, you haven't. That's because Amazon warehouse operatives are skilled and good at their job. Speaking of Amazon, with the ever-looming pandemic outside and everyone ordering things from home, companies like Amazon, TESCO, eBay and all these big eCommerce companies are hiring warehouse operatives in large numbers. This warehouse operative course is a quick and easy way to learn the essentials of working in a warehouse. With its step by step lessons and no fluff method of content delivery, the course saves you time and money as it's available at a discounted price at the moment. Warehouse Operative course Learning Outcomes: Upon successful completion of this highly appreciated Warehouse Operative course, you'll be a skilled professional, besides- The purpose of the warehouse and several Layouts. Principles, tools, and procedures in warehousing Techniques and tools for completing orders Examine the many storage devices utilised in warehouses. Implement the appropriate security measures. Good Practices for Warehousing Curriculum Breakdown of the warehouse operative Course Module 01: The Role Module 02: Introduction to Warehouse Safety Module 03: Health and Safety Management Module 04: General Warehouse Hazards Module 05: Manual and Mechanical Handling Module 06: Site Safety Each topic has been designed to deliver more information in a shorter amount of time. This makes it simple for the learners to understand the fundamental idea and apply it to diverse situations. Key Features of Warehouse Operative 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 Covers to Explore Multiple Job Positions So, without any further ado, get started now. The faster you learn, the sooner you can start building your career as a Warehouse Operative. Certification CPD Accredited (CPD QS) Certificate Digital (PDF) & Hardcopy certificates are available Who is this course for? Those looking to pursue a profession in warehouse management. A person who wishes to begin their career in supply chain management in a warehouse setting. Owners and partners of e-commerce businesses who need to grow and start their own warehouse processes. Jobseekers who are looking to ace their logistics and supply chain management interviews. Requirements Students seeking to enrol for Along with the warehouse course should meet the following requirements; Basic knowledge of English Language, which already you have Be age 16 years or above Basic Knowledge of Information & Communication Technologies for studying online or digital platform. Stable Internet or Data connection in your learning devices. Career path The course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Warehouse Operative, such as- Warehouse Managers Supply Chain Officer Inventory Managers Logistics Manager international Business Managers Importers - Exporters Freight Managers and Supervisors Courier and Parcel operators E-Commerce Fulfilment Managers Business Consultants Certificates Certificate of completion Digital certificate - Included After successfully completing this course, you can get CPD accredited digital PDF certificate for free. Certificate of completion Hard copy certificate - Included After successfully completing this course, you can get CPD accredited hardcopy certificate for free. The delivery charge of the hardcopy certificate inside the UK is £3.99 and international students need to pay £9.99 to get their hardcopy certificate.

Overview This comprehensive course on Computer Science With Python will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Computer Science With Python comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Computer Science With Python. It is available to all students, of all academic backgrounds. Requirements Our Computer Science With Python is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 152 lectures • 04:54:00 total length •Introduction: 00:03:00 •Quiz 1: 00:02:00 •Quiz 1 Solution: 00:01:00 •What is Programming: 00:03:00 •Quiz 2: 00:01:00 •Quiz 2 Solution: 00:01:00 •Meeting the interpreter and Problem Quiz 3: 00:01:00 •Quiz 3 solution: 00:01:00 •Congratulations: 00:01:00 •Why programming and Quiz 4: 00:02:00 •Quiz 4 Solution: 00:03:00 •Grammar and Python Rules: 00:04:00 •Backus Naur Form: 00:03:00 •Quiz 4 part 2: 00:01:00 •Quiz 4 part 2 Solution: 00:01:00 •Python Grammar and Quiz 5: 00:05:00 •Quiz 5 Solution: 00:03:00 •Quiz 6: 00:01:00 •Quiz 6 Solution: 00:02:00 •Processors: 00:02:00 •Introducing Variables: 00:05:00 •Variables Quiz 7: 00:02:00 •Variables Can Vary: 00:03:00 •Variables Quiz 8: 00:01:00 •Quiz 8 Solution: 00:01:00 •Variables Quiz 9: 00:01:00 •Quiz 9 Solution: 00:01:00 •Variables Quiz 10: 00:01:00 •Quiz 10 Solution: 00:03:00 •Introducing Strings: 00:04:00 •Using Strings Quiz 11: 00:01:00 •Quiz 11 Solution: 00:03:00 •Strings and Numbers - String Concatenation Quiz Solution: 00:03:00 •String indexing: 00:02:00 •Quiz 13: 00:01:00 •Quiz 13 Solution: 00:03:00 •String subsequences: 00:04:00 •String subsequences quiz 14: 00:01:00 •Quiz 14 solution: 00:02:00 •Understanding selection quiz 15: 00:01:00 •Quiz 15 solution: 00:04:00 •Finding string in string quiz 16: 00:04:00 •Quiz 16 solution: 00:02:00 •Testing and quiz 17: 00:02:00 •Quiz 17 solution: 00:03:00 •Find With Parameter Quiz 18: 00:02:00 •Quiz 18 solution: 00:01:00 •Extracting links from a web page Quiz 19: 00:03:00 •Extracting links from a web page Quiz 19 Solution: 00:02:00 •Final Quiz: 00:01:00 •Final Quiz Solution: 00:02:00 •Congratulations: 00:01:00 •Unit Overview: 00:03:00 •Procedural Abstraction: 00:03:00 •Introducing Procedures: 00:04:00 •Procedure code quiz 1: 00:04:00 •Quiz 1 Solution: 00:01:00 •Output and quiz 2: 00:01:00 •Quiz 2 Solution: 00:02:00 •Return Statement and Quiz 3: 00:03:00 •Quiz 3 solution: 00:02:00 •Inc Procedure Quiz 4: 00:01:00 •Quiz 4 Solution: 00:01:00 •Sum Procedure and Quiz 5: 00:01:00 •Quiz 5 Solution: 00:02:00 •Sum procedure with a return statement: 00:02:00 •Square procedure quiz 6: 00:01:00 •Quiz 6 Solution: 00:02:00 •Sum 3 Quiz 7: 00:01:00 •Quiz 7 Solution: 00:02:00 •Double string procedure quiz 8: 00:01:00 •Quiz 8 Solution: 00:01:00 •Find second quiz 9: 00:02:00 •Quiz 9 Solution: 00:02:00 •Equality Comparison Quiz 10: 00:04:00 •Quiz 10 Solution: 00:01:00 •If statement quiz 11: 00:03:00 •Quiz 11 Solution: 00:03:00 •Is friend quiz 12: 00:02:00 •Quiz 12 solution: 00:02:00 •Is friend quiz 13: 00:02:00 •Quiz 13 Solution: 00:02:00 •The Or construct: 00:03:00 •Quiz 14 solution: 00:06:00 •While loop quiz 15: 00:05:00 •Quiz 15 solution: 00:03:00 •While loop quiz 16: 00:01:00 •Quiz 16 solution: 00:02:00 •Print numbers quiz 17: 00:01:00 •Quiz 17 solution: 00:02:00 •Factorial quiz 18: 00:02:00 •Quiz 18 solution: 00:02:00 •Break quiz 19: 00:04:00 •Quiz 19 solution: 00:03:00 •Quiz 20: 00:05:00 •Quiz 20 Solution: 00:01:00 •No links quiz 21: 00:01:00 •Print all links quiz 21 solution: 00:03:00 •Final Quiz: 00:01:00 •Final Quiz Solution: 00:02:00 •Unit Overview: 00:03:00 •Stooges and quiz 1: 00:01:00 •Quiz 1 Solution: 00:01:00 •Countries quiz: 00:01:00 •Quiz 3 solution: 00:01:00 •Relative Size Quiz: 00:01:00 •Quiz 4 Solution: 00:01:00 •Lists Mutation: 00:01:00 •Different Stooges quiz: 00:01:00 •Quiz 5 Solution: 00:01:00 •Secret Agent Man Quiz: 00:01:00 •Replace Spy Quiz: 00:01:00 •Quiz 7 Solution: 00:03:00 •Python List Addition and Length: 00:02:00 •List Operations In Python: 00:02:00 •Python lists length quiz: 00:01:00 •Quiz 8 Solution: 00:01:00 •Append Quiz: 00:01:00 •Hard drive quiz: 00:01:00 •Quiz 11 Solution: 00:01:00 •Python Loops on Lists Quiz: 00:02:00 •Quiz 12 solution: 00:02:00 •Python For loops: 00:03:00 •Sum List Quiz: 00:01:00 •Measure a String Quiz: 00:01:00 •Find Element Quiz: 00:02:00 •Quiz 15 solution: 00:04:00 •Quiz 16 solution: 00:01:00 •Python Union Procedure Quiz: 00:01:00 •Quiz 17 solution: 00:01:00 •Pop in Python Quiz 18: 00:02:00 •Quiz 18 solution: 00:03:00 •Collecting Links: 00:01:00 •Get All Links: 00:02:00 •Starting Get All Links Quiz: 00:01:00 •Quiz 19 solution: 00:01:00 •Updating Links Quiz: 00:01:00 •Quiz 20 Solution: 00:01:00 •Finishing Get All Links Quiz: 00:01:00 •Quiz 21 Solution: 00:01:00 •Finishing the Python Web Crawler: 00:03:00 •Crawling Process Quiz: 00:01:00 •Quiz 22 Solution: 00:01:00 •Crawl Web Quiz: 00:01:00 •Quiz 23 Solution: 00:01:00 •Crawl Web Loop Quiz: 00:01:00 •Quiz 24 Solution: 00:02:00 •Crawl If Quiz: 00:01:00 •Quiz 25 Solution: 00:01:00 •Finishing Crawl Web and Final Quiz: 00:02:00 •Final Quiz Solution & Conclusion: 00:03:00 •Assignment - Computer Science With Python: 00:00:00

About Course Master the art of Retail business with this comprehensive online course on Retail Management and Merchandising Retail Management Online course will teach you the basics to start a potential career or business in the promising field of the Retail Industry. Retail is an ever-growing industry. Retail management saves time and ensures that customers easily locate their desired merchandise and return home satisfied. Effective management avoids unnecessary chaos at the store and rather increases the sales of the store. Over the last couple of decades, total retail sales numbers in the United States have grown considerably, from just under 3 trillion U.S. dollars in 2000 to almost 6.6 trillion U.S. dollars in 2021. So it is definitely promising to start a business or career in the Retail industry. This Retail management online course will help individuals who are looking to start their career in the Retail management profession, or thinking about starting a business in this industry, This beginner's level course will be your stepping stone into the industry, and with a high level of professionalism, experience, and skills that it will enable, you have the potential to be en route to becoming a successful professional in the Retail industry. The retail Management online course is strategically divided into 9 modules to cover the key professional elements related to the Retail industry. It is designed in a way that not it will help the job seekers in this field but also the individuals with some experience who want to start a business. The course will help you learn from scratch and reach a higher level of professionalism. As you may know, organisational skills are important because good organisational skills establish trust and professionalism in the workplace. So, if you are looking to join the various Retail Management and organisational skills, then this Retail Management is your most desired course. What Will You Learn? Develop skills required for successful Retail Management and Merchandising Enhance communication skills for relationship selling and networking in retail management. Learn effective strategies for dealing with difficult customers and suppliers. Gain knowledge about stock management, including warehouse activities, aims of warehousing, material handling, and packaging. Course Content Introduction to Retail Management Productivity Techniques for Maximum Selling Communication Skills for Relationship Selling The Selling Process, Theories and Sales Promotions The Importance of Consumer Behavior Dealing with difficult customers Dealing with Suppliers Dealing with the management of stock Retail Merchandising Concluding Remarks A course by Xpert Learning RequirementsLearners with no prior Retail Management knowledge can enroll in this Retail Management course. Audience Retail store owners or managers who want to improve their knowledge of retail management and merchandising strategies to increase their business profitability. Entry-level retail employees who want to develop their skills and knowledge of the retail business and eventually advance to managerial positions. Professionals from other fields who are considering a career change to retail management or who want to acquire knowledge about the retail industry. Audience Retail store owners or managers who want to improve their knowledge of retail management and merchandising strategies to increase their business profitability. Entry-level retail employees who want to develop their skills and knowledge of the retail business and eventually advance to managerial positions. Professionals from other fields who are considering a career change to retail management or who want to acquire knowledge about the retail industry.

Picture this: A vast cloud realm, brimming with data, all ready to weave tales of insight and wisdom. Welcome aboard our 'Microsoft Azure Machine Learning' odyssey! This isn't just a course; it's a canvas where technology meets art. Unravel the mysteries of Azure Machine Learning Studio, dance with data modules, and play with predictions about incomes and the price tags of fancy cars. Ready for a whirlwind romance with data? Learning Outcomes Become best pals with Microsoft Azure Machine Learning Studio - it's cooler than it sounds! Play detective with a variety of puzzling machine learning modules. Predict tomorrow! Well, not literally, but we'll dabble in forecasting incomes and car prices. Revel in the drama of data as we churn stories from raw numbers. Flip through the fascinating pages of notebooks in Azure, a bibliophile's techy delight. Why choose this Microsoft Azure Machine Learning course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Microsoft Azure Machine Learning Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Microsoft Azure Machine Learning course for? Tech aficionados itching to ride the cloud wave. Curious data wizards eager to add Azure spells to their grimoire. Project champs on a quest for the perfect cloud platform. Code artists seeking to stitch machine learning into their digital tapestry. Future stars of tech, dreaming big and aiming higher. Career path Azure Machine Learning Maestro - £45,000 - £65,000 Data Alchemist - £50,000 - £72,000 Cloud Castle Architect - £70,000 - £92,000 Machine Learning Magician - £55,000 - £78,000 Storyteller of Stats - £60,000 - £85,000 Azure Artisan - £40,000 - £60,000 Prerequisites This Microsoft Azure Machine Learning does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Azure Machine Learning was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Azure Machine Learning Module 01: Introduction to Microsoft Azure Machine Learning Studio and Administration 00:22:00 Module 02: Various Modules in Machine Learning 00:13:00 Module 03: Prediction of Income (Automated Tutorial) 00:33:00 Module 04: Prediction of Automobile Price using Linear Regression Algorithm 00:59:00 Module 05: Dataset Processing and Analysis (Sample-1) 00:57:00 Module 06: Cross Validation for Regression (Sample-2) 00:28:00 Module 07: Clustering Group Iris data (Sample-3) 00:17:00 Module 08: Introduction on Notebook in Microsoft Azure Machine Learning Studio 00:18:00 Assignment Assignment - Microsoft Azure Machine Learning 00:00:00

Unlock the power of mathematics and pave the way for academic and professional success with our Functional Skills Maths Level 2 course. Designed to provide a comprehensive understanding of key mathematical concepts, this course equips learners with the essential skills needed to excel in both academic and real-world settings.

Description: Payroll is a very big part of any company, as it helps manage the company's finances when it comes to employee salaries. There is a huge demand for people who can use their skills in this department as there are a lot of numbers that need to be taken care of. If you already have an accounting degree but would like to focus on payroll then you should definitely get this Diploma in Payroll Management course. The course starts with explaining to you what payroll is and the principles of payroll systems - including positive and negative pay. Then you move onto the confidentiality and security information section of the course before following into effective payroll processes. You will also learn to increase the efficiency of payroll management before addressing risk and time management aspects. Furthermore you will get more information on personal filing, net and gross pay and so much more. The course is well balanced and goes quite in depth into payroll management, and getting it will help you focus more on payroll management as a career. Who is the course for? People who are interested in learning how payroll works for large organisations Professionals seeking to get into a payroll or accounting related job 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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: Diploma in Payroll Management is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Accounting manager Accounting assistant Payroll manager Diploma in Payroll Management What Is Payroll? 00:30:00 Principles Of Payroll Systems 01:00:00 Confidentiality And Security Of Information 00:30:00 Effective Payroll Processing 01:00:00 Increasing Payroll Efficiency 01:00:00 Risk Management in Payroll 00:30:00 Time Management 00:30:00 Personnel Filing 00:30:00 When Workers Leave Employment 01:00:00 Hiring Employees 00:30:00 Paye and Payroll for Employers 01:00:00 Tell HMRC about a New Employee 01:00:00 Net And Gross Pay 00:30:00 Statutory Sick Pay 00:30:00 Minimum Wage for Different types of Work 01:00:00 Mock Exam Mock Exam- Diploma in Payroll Management 00:20:00 Final Exam Final Exam- Diploma in Payroll Management 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Microsoft Office skills are in high demand across industries, and proficiency in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Office 365 opens up numerous career opportunities. In the UK, administrative roles, data analysis positions, office management, project coordination, and marketing support roles are just a few examples of job prospects. With average salaries ranging from £20,000 to £45,000 per year, individuals with comprehensive Microsoft Office skills can secure stable employment and contribute to the success of various organisations. Enrol in the Ultimate Microsoft Office Skills Training course today and equip yourself with the knowledge and expertise needed to thrive in the ever-evolving workplace. You Will Learn Following Things: Develop a solid foundation in Microsoft Office applications, including Word, Excel, PowerPoint, and Office 365. Acquire essential skills to efficiently navigate and manipulate data in Microsoft Excel, such as organising, sorting, filtering, and writing formulas. Gain proficiency in creating professional presentations in Microsoft PowerPoint, utilising features like multimedia, transitions, animations, and smart graphics. Master the art of document creation and formatting in Microsoft Word, including tables, styles, page layouts, envelopes, labels, and mail merges. Understand advanced features like pivot tables, charts, and data analysis tools in Microsoft Excel, enabling effective data visualisation and decision-making. This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This course is designed for individuals who want to enhance their Microsoft Office skills for personal or skilled purposes. Whether you are a student, an experienced entrepreneur, or anyone who regularly works with Microsoft Word, Excel, PowerPoint, and Office 365, this Microsoft Office skills course will provide you with a solid foundation and advanced techniques to maximise your productivity and efficiency. No prior experience is required, making it suitable for beginners and intermediate users looking to expand their knowledge and capabilities in the Microsoft Office suite. On the other hand, anyone who wants to establish their career as: like MS Office User Microsoft Office 2019 User Touch Typing Worker Audio Typist Can take this Ultimate Microsoft Office Skills Training (Word, Excel, PowerPoint, and 365) course. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career path Administrative Assistant - £20K to £30K/year Data Analyst - £25K to £45K/year Office Manager - £25K to £40K/year Project Coordinator - £25K to £35K/year Marketing Assistant - £20K to £30K/year Course Curriculum Section 01: Getting Started Introduction 00:03:00 Getting started on Windows, macOS, and Linux 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: Excel 2021: Basics Excel Overview 00:05:00 Start Excel Spreadsheet 00:04:00 Enter Text and Numbers 00:07:00 Relative References 00:04:00 Working with ranges 00:07:00 Save and Save as Actions 00:08:00 File Extensions, Share, Export, and Publish files 00:06:00 Section 03: Excel 2021: Rows, Columns, and Cells Adding Rows and Columns 00:03:00 Modifying Rows and Column lengths 00:05:00 Section 04: Excel 2021: Data Handling Copy, Cut, and Paste 00:07:00 Copying Formulas 00:03:00 Section 05: Excel 2021: Page Setting Up and Print Page setup options 00:06:00 Fit to print on One Page 00:03:00 Print Workbooks 00:03:00 Section 06: Excel 2021: Sorting and Filtering Sorting Data Ascending Order 00:04:00 Sorting Data Descending Order 00:02:00 Filter Data 00:04:00 Section 07: Excel 2021: Writing Formulas Creating Basic Formulas 00:06:00 Datetime Formulas 00:06:00 Mathematical formulas phase1 00:20:00 Mathematical formulas phase2 00:12:00 Section 08: Excel 2021: Advanced Formulas VLOOKUP formula 00:12:00 HLOOKUP formula 00:04:00 Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 XLOOKUP 00:08:00 Handling #NA and Approximates match in XLOOKUP 00:11:00 Section 10: Excel 2021: Data and Tools Split Text into columns 00:07:00 Flash Fill 00:07:00 Data Validation 00:07:00 Remove Duplicates 00:08:00 Import Data from Text files 00:06:00 Import Data from .CSV files 00:03:00 Section 11: Excel 2021: Formatting data and tables Formatting Font 00:04:00 Formatting Alignment 00:06:00 Formatting Numbers 00:05:00 Formatting Date 00:03:00 Formatting Tables 00:05:00 Section 12: Excel 2021: Pivot Tables Pivot Tables 00:07:00 Pivot Charts 00:02:00 Section 13: Excel 2021: Charts Excel Charts - Categories 00:03:00 Elements of a chart 00:04:00 Creating Charts 00:02:00 Column or Bar charts 00:04:00 Formatting charts 00:04:00 Line Charts 00:02:00 Pie and Doughnut charts 00:04:00 Section 14: PowerPoint 2021: Course Introduction Overview 00:04:00 Start PowerPoint Presentation 00:05:00 Screen setting and Views 00:05:00 Section 15: PowerPoint 2021: Basics Presentation Tips and Guidelines 00:06:00 Creating a New Presentation 00:04:00 Working with Slides 00:04:00 Save a Presentation 00:04:00 Print Slides 00:03:00 Section 16: PowerPoint 2021: Text and Bullet Options Formatting Text 00:05:00 Slide Text Alignments 00:03:00 Multi-Column Text Alignments 00:02:00 Adding Bullets and Numbered List Items 00:03:00 Section 17: PowerPoint 2021: Adding Graphic Assets Insert Shapes 00:03:00 Insert Icons 00:03:00 Insert Graphics 00:04:00 Add 3D Models 00:03:00 Insert Pictures 00:03:00 Section 18: PowerPoint 2021: Picture Formatting Picture Options 00:04:00 Picture Cropping 00:03:00 Applying Built-in Picture Styles 00:04:00 Section 19: PowerPoint 2021: SmartArt Graphics Add SmartArt Graphic 00:03:00 Modifying SmartArt 00:03:00 Creating a Target Chart using SmartArt 00:03:00 Section 20: PowerPoint 2021: Working with Tables Create a Table on Slide 00:04:00 Formatting Tables 00:02:00 Inserting Tables 00:02:00 Table Layouts 00:01:00 Section 21: PowerPoint 2021: Working with Charts Add a Chart 00:02:00 Formatting Charts 00:02:00 Insert Chart from Microsoft Excel 00:03:00 Section 22: PowerPoint 2021: Adding Multimedia Adding Video to a Presentation 00:03:00 Adding Audio to a Presentation 00:02:00 Screen Recording and Adding 00:02:00 Section 23: PowerPoint 2021: Working with Transition Applying Transitions to Presentation 00:04:00 Section 24: PowerPoint 2021: Animation Object Animation 00:03:00 Effect Options 00:02:00 Advanced Animation 00:02:00 Triggers to control animation 00:02:00 Section 25: PowerPoint 2021: Slideshow Effects Onscreen Presentation 00:02:00 Hiding Slides 00:02:00 Changing Order of Slides 00:02:00 Copying Slides 00:02:00 Section 26: Word 2021: Introduction Overview of MS Word 00:04:00 Start MS Word 2021 00:05:00 Section 27: Word 2021: Basics Create a new blank document 00:04:00 Creating a paragraph text 00:05:00 Non-printing characters 00:03:00 Save a document 00:03:00 Open a document 00:01:00 Find and replace 00:04:00 Section 28: Word 2021: Word Formatting AutoCorrect options 00:03:00 Formatting text 00:04:00 Copy cut and paste 00:04:00 Character formatting 00:02:00 Format painter 00:04:00 Work with numbers 00:02:00 Add bullets 00:03:00 Outline creation 00:04:00 Section 29: Word 2021: Tables Creating a table 00:03:00 Adding rows and columns to a table 00:02:00 Formatting table data 00:02:00 Borders and shading 00:02:00 Sorting in a table 00:04:00 Draw a table 00:04:00 Convert text to table 00:03:00 Convert table to text 00:02:00 Insert a spreadsheet 00:02:00 Quick tables - readily available formats 00:02:00 Section 30: Word 2021: Styles Working with styles 00:02:00 Creating styles 00:02:00 Clear formatting 00:01:00 Section 31: Word 2021: Page Layout Margins 00:02:00 Orientation 00:01:00 Page size setting 00:01:00 Adding columns 00:03:00 Page break - section break 00:02:00 Adding watermark 00:03:00 Headers and footers 00:03:00 Section 32: Word 2021: Envelops and Lables Create envelops 00:02:00 Creating labels 00:02:00 Section 33: Word 2021: Mail Merges Creating a mail merge document 00:03:00 Section 34: Word 2021: Review and Printing Thesaurus and spell check 00:01:00 Word count 00:01:00 Speech - read aloud 00:01:00 Language - translate 00:01:00 Tracking 00:01:00

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.