Google Sheets Course: Free Online Spreadsheet with AI

Updated in 2021 : Course updated to include S/4 HANA new aATP and BackOrder ProcessingUpdated in 2017 : Course updated to reflect new content concerning S/4 HANA and ATPSeemingly simple, the SAP Available to Promise (ATP) functionality is quite a complex topic to comprehend and requires experience in multiple SAP implementation to fully comprehend the functionality, especially with SAP's new S/4 HANA functionlities. This course aims to distill and compress years of knowledge and experience into a comprehensive, easy to understand course that can be used in today's workplace.The course we deepdive into the following areasHow would a business used ATP in their process. The configuration behind ATPSystem demonstrations Troubleshooting some of the basic problems with ATPFor this, the course covers the following SAP conceptsHow ATP is used in SAP. How a schedule lines uses ATP to determine the delivery milestonesHow the ATP logic determines if a material is available and if not whenHow ATP reschedule a sales order.Route determinationS/4 HANA aATP solution as per 1909 S/4 HANA BackOrder Processing - BOP as per 1909This course is part of the larger SAP Supply Chain course, but has been segregated as to provide a targeted, deepdive session into the SAP functionality of "Available to Promise"This course is suitable for all users of SAP, either from a normal user to SAP consultants. DO NOT purchase this course if you already have the SAP Supply Chain Course from myself, as a lot of the content is similar.

Reviews:"This is a very good starting point in VBA. But doing this course one realize how extensive and huge VBA is. As always the teacher is great and one feels his in depth knowledge" -- Daniel SandbergWelcome to Excel VBA - An Introduction. This course delves into the Visual Basic which allows you to automate Microsoft Excel (and other MS Office products).Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.Microsoft Excel is an extremely powerful tool – and yet most people only scratch the surface of what it can do. In addition to PivotTables, VLookup formulas and the like, you can also automate it. You can add buttons and forms to add interactive features – yet most people don’t even know it’s there. Maybe you have someone in your organization who is an absolute wizard, getting the computer to do things and walking away while it does it. Do you want to be able to do that? Welcome to wizard school – or in other words, Visual Basic for Applications (VBA). In this course, I’ll assume that you have some fair knowledge of Excel – able to do basic formulas and colour cells and the like – but you don’t need any prior knowledge of VBA or any programming language for that matter. Of course, the more you already have, the better. I’ll take things nice and slowly. Each video will center around one new aspect, or we’ll consolidate what you already know with coding exercises. Once you have finished the course, then you will be well on your way to developing your own macros to solve your own problems. And you’ll be able to take your new-found knowledge for use in Word and PowerPoint as well.

With over 8 years of experience as a Computer Management Analyst specializing in MS Office, I have developed a comprehensive video course designed to help you start from zero with Microsoft Excel. ### Program OverviewThis program provides a detailed, step-by-step understanding of every aspect of Microsoft Excel, covering topics from the beginning to intermediate levels. Although the course is presented using Excel 2013, it is suitable for any version of Microsoft Excel (recommended: 2003 or above).### Course Inclusions- Sample questions and practice sets are included to reinforce learning.### Course Content1. **Introduction to the Course**2. **Uses of Excel and Its Definition**3. **How to Open Excel on Your Computer**4. **Detailed Introduction of Excel Interface (A-Z)**5. **Everything About Formatting and Saving Excel Files**6. **Discussing the Insert Tab**7. **Working with Arithmetic Operators**8. **Discussing Functions: SUM, COUNT, MAX, MIN, AVERAGE, CONCATENATE**9. **Conditional Formatting (A-Z) in One Video**10. **Tables and Their Uses, Including How to Remove a Table**11. **Filter and Sort Functions**12. **Charts and Their Uses**13. **Understanding IF, IF AND, IF OR Statements**14. **Data Validation (A-Z) Complete Knowledge**15. **Learning Pivot Tables in Simple Steps**16. **Understanding VLOOKUP in Simple Steps**17. **All Settings for Printing**### Learning OutcomesAll these topics are discussed in detail to ensure every new student can understand them without any doubts.Enjoy the course!

If you're looking to improve your MS Word skills, this Advanced Microsoft Word course is the perfect fit for you. Whether you're a beginner or an experienced user, this course is Microsoft Word Ultimate Guide covers everything you need to know to create professional-looking documents. Starting with font and paragraph formatting, you'll learn how to create and apply styles and formatting options to your text. You'll also learn how to create and format tables, insert cover and page, and use advanced features like voice to text.This course covers all the essential tools and features of MS Word, such as inserting spreadsheets, shapes, and pictures, charts and graphs, hyperlinks, bookmarks, and comments, headers, footers, and page numbers. You'll also learn how to use design and layout options to make your documents more visually appealing and easier to read.Additionally, this course covers advanced features like references, mailings, and review, giving you a complete understanding of how to use Microsoft Word Word for a variety of tasks. By the end of this course, you'll have gained the confidence and proficiency to use Word to create professional documents with ease and efficiency. This course is suitable for anyone looking to improve their MS Word skills, from beginners to experienced users.

In this Learning PowerPoint 2016 for Mac training course, expert author Guy Vaccaro will teach you how to build presentations and run slideshows in Microsoft PowerPoint. This course is designed for the absolute beginner, meaning no previous experience with PowerPoint is required. You will start by learning how to create a new presentation, then jump into learning how to design slides. From there, Guy will teach you about charts and graphs, organization charts, WordArt, shapes, SmartArt, and images. This video tutorial also covers how to manage and run the presentation, add animations, access master slides, and use templates. Finally, you will learn how to print your slides, and how to share your presentation online. Once you have completed this computer based training course, you will be fully capable of using PowerPoint for Mac to create your own presentations and run your own slideshows. Working files are included, allowing you to follow along with the author throughout the lessons.

SuccessFactors Employee Central Payroll - Course CIn this course you can learn SAP SuccessFactors Employee Central Payroll Administration. You will be introduced to payroll roles and process as well as the data required to process payroll. Additionally, you will learn how to use Employee Central to complete Employee, Manager, and HR Administrator tasks associated with creating and maintaining the data required for processing payroll. After completing the course you will be able to summarize the functionality of Payroll Control Center in Employee Central Payroll and identify the components in the integration between Employee Central and Employee Central Payroll. You will also be able to configure a One-Click Monitoring process to identify errors and alerts prior to production payrollIt is a complete course on SuccessFactors Employee Central Payroll. It covers below configuration topics:Employee Central Payroll overviewEmployee payroll data managementPayroll processes and alert resolutionSubsequent payroll processesOff-cycle Employee Central payroll processesPayroll auditingThis course would be helpful to below audience:Functional ConsultantsTechnical Consultants who wish to get a Techno-Functional roleEnd usersStudentsAspirants who wish to seek career in SAP HCM or SAP SuccessFactorsCourse Exclusions:Below topics are not covered under this offered course.1. Point to Point Integration between SuccessFactors Employee Central and Employee Central Payroll2. SuccessFactors Employee Central Payroll - Payroll Control Center