3417 Office Skills & Productivity courses delivered Online

Description: This Microsoft Office 2016 Excel Intermediate - Complete Video Course will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at high level. If you have equivalent knowledge of Microsoft Excel 2016 Introduction then this course is perfect for you to expand your knowledge and skills. So, if you want to advance your skill set by learning to work with advanced formulas, lists, and illustrations you can join this course. You will also work with charts and advanced formatting including styles. So, why are you thinking? Come and be a part of this course now. 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 Office 2016 Excel Intermediate - Complete Video 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 Office 2016 Excel Intermediate - Complete Video 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. Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Are you fascinated by the inner workings of computers and the ever-evolving world of technology? Are you seeking an exciting career path combining your passion for computer maintenance, cybersecurity, and cutting-edge advancements? Look no further! Our comprehensive "Computer Maintenance, PAT & Cyber Security" bundle will equip you with the skills and knowledge needed to thrive in this rapidly growing industry. The need for skilled computer maintenance professionals has never been greater in today's digital landscape. By joining our Computer Maintenance course, you'll gain valuable knowledge and practical skills to set you apart from the competition. Whether you aspire to work in IT helpdesk support, computer repair services, network administration, or cybersecurity, this course covers all the essential aspects to kick-start your career. Learning Outcomes: Develop expertise in building and configuring computers, enabling you to provide comprehensive computer maintenance services. Acquire advanced knowledge of network security, encryption, and cybersecurity principles, empowering you to protect networks and data from cyber threats. Master computer vision using C++ and OpenCV with GPU support, equipping you to work on cutting-edge projects like computer vision and augmented reality. Gain proficiency in troubleshooting Windows 10 issues, enhancing your skills as an IT helpdesk technician and enabling you to resolve complex software problems through our Computer Maintenance course. Obtain certification in Portable Appliance Testing (PAT), enabling you to ensure electrical safety in workplaces and comply with industry regulations. Our comprehensive computer maintenance course bundle is designed to equip you with the skills and knowledge necessary to excel in these in-demand fields. With a focus on practical learning and real-world applications, this bundle offers a unique opportunity to build a strong foundation and open doors to exciting career prospects. Computer Maintenance, PAT & Cyber Security Bundle Curriculum are: Building Your Own Computer Computer Networks Security from Scratch to Advanced Computer Vision By Using C++ and OpenCV with GPU support Advance Windows 10 Troubleshooting for IT HelpDesk Portable Appliance Testing (PAT) Internet of Things Cyber Security Awareness Training Encryption Take advantage of this incredible opportunity to enhance your skills and embark on a rewarding career in computer maintenance, PAT, and cyber security. Enrol now and take the first step towards a future filled with exciting opportunities and job prospects in this fast-paced and ever-evolving industry. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Computer Maintenance course is for: Aspiring computer maintenance professionals. IT helpdesk technicians. Individuals are interested in cybersecurity. Tech enthusiasts. Professionals in the electrical industry. Career path Our Computer Maintenance course will prepare you for a range of careers, including: Computer Maintenance Technician (£20K-£25K) Network Security Analyst (£30K-£45K) IT Helpdesk Technician (£20K-£30K) Cybersecurity Specialist (£40K-£70K+) Computer Vision Engineer (£40K-£60K) Electrical Safety Inspector (£25K-£35K) Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Duration 5 Days 30 CPD hours This course is intended for This course is aimed at consultants, project managers, project team members and key users. In this course, participants learn about the fundamental business processes in sales and distribution. Participants learn how to perform the most important functions in the process chain, from presales to customer payment, in the SAP system. Course Outline Organizational structures in sales and distribution Working with the relevant master data for the processes Overview of the process chain Introduction to the availability check Sales and distribution processing with make-to-order production Complaints processing Introduction to sales and distribution reporting Additional course details: Nexus Humans SCM600 SAP Sales Order Management 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 SCM600 SAP Sales Order Management course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for all levels of experience in using Microsoft Project, as well as all levels of experience in project management. In particular, this course is designed for persons who need to author Microsoft Project work schedules including Project Managers and Project Assistants. Overview To be properly introduced, or reintroduced, to Microsoft Project. To gain an understanding of a proven mindset Microsoft Project users should possess each time they open and work Microsoft Project schedules. To gain an understanding of globally accepted project management principles. To be able to effectively apply Microsoft Project into the Initiation and Planning phases of a normal project life cycle. MS Project: Project Initiation and Planning (part 1 of a 3 part series) course provides proven tools and techniques for successfully using Microsoft Project to assist with managing projects. MS Project: Project Initiation and Planning (part 1 of a 3 part series) course provides proven tools and techniques for successfully using Microsoft Project to assist with managing projects.

Duration 4 Days 24 CPD hours This course is intended for Project administrators and ETL developers responsible for data extraction and transformation using DataStage. Overview Describe the uses of DataStage and the DataStage workflowDescribe the Information Server architecture and how DataStage fits within itDescribe the Information Server and DataStage deployment optionsUse the Information Server Web Console and the DataStage Administrator client to create DataStage users and to configure the DataStage environmentImport and export DataStage objects to a fileImport table definitions for sequential files and relational tablesDesign, compile, run, and monitor DataStage parallel jobsDesign jobs that read and write to sequential filesDescribe the DataStage parallel processing architectureDesign jobs that combine data using joins and lookupsDesign jobs that sort and aggregate dataImplement complex business logic using the DataStage Transformer stageDebug DataStage jobs using the DataStage PX Debugger This course enables the project administrators & developers to acquire the skills necessary to develop parallel jobs in DataStage. Students will learn to create parallel jobs that access sequential & relational data, and combine and transform the data. Course Outline Introduction to DataStage Deployment DataStage Administration Work with Metadata Create Parallel Jobs Access Sequential Data Partitioning and Collecting Algorithms Combine Data Group Processing Stages Transformer Stage Repository Functions Work with Relational Data Control Jobs

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this class are Application Consultants, Business Process Architects, Business Process Owners/Team Leads/Power Users, and Program/Project Managers Overview Explore settings to map requirements in the area of Sales and Distribution (S&D) that require knowledge of cross-application Customizing functionsUnderstand and consider complex relationships in mapping organizational structuresConfigure and adapt special functions like copy control, text control, output controlUnderstand system modification options and personalization techniques This course is ideal for students who are requiring detailed cross-application configuration knowledge to map requirements integrated to sales and distribution. Copy Control Modifying Copy Control Text Control Identifying Text Sources Configuring Text Control Output Adjusting Output Determination Adjusting Output Types Using PDF-Based Forms in the Sales Process Enhancements & Modifications Using Enhancement Technology Adjusting the Screen Setup of a Transaction Using Table Controls Adjusting Lists in Sales and Distribution Controlling Customer Master Data Using Account Groups Adjusting the Screen Setup of a Transaction Using Transaction Variants Adding New Fields Performing System Modifications Using Classic Enhancement Technology Performing System Modifications Using the Enhancement Framework Additional course details: Nexus Humans SCM650 SAP Cross-Functional Customizing in Sales and Distribution 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 SCM650 SAP Cross-Functional Customizing in Sales and Distribution 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 2 Days 12 CPD hours This course is intended for Project team members & consultants In this course, students learn how to set up the billing interface points between sales and distribution and financial accounting. Course Outline Forms of billing in SD Methods for creating billing documents Methods for creating billing documents Invoice lists Billing plans and down payments Revenue account determination Special features of the SD/FI interface Additional course details: Nexus Humans SCM615 SAP Sales and Customer Service 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 SCM615 SAP Sales and Customer Service 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 3 Days 18 CPD hours This course is intended for Project team members In this course, students learn how to successfully set up functions and customizing settings for pricing in Sales and Distribution. Course Outline Condition technique for definition and maintenance of prices, surcharges and discounts Creating condition tables, access sequences, and condition types Using prices and other conditions in sales documents Promotions and sales deals Introduction to rebate processing