Excel Exam Prep: 4 Practice Tests Included

In this course, one can learn the below topics.1. Subcontracting Procurement2. Stock Transport Order Process3. Third Party Procurement4. Consignment Procurement5. Pipeline Procurement6. Returnable Transport Packing Procurement7. Service Procurement8. Import Procurement1. Subcontracting Procurement:In this course, I have explained the process steps of Subcontracting with sub scenarios like over and under consumption of components during Subcontracting procurement. And also accounting entries during Goods Receipt of Finished product are explained. I provided few doubts session videos along with main course video.1). Subcontracting Procurement Process with under and over consumption2). Subcontracting Procurement Process with Scrap and by product3). Subcontracting Procurement Process with Outbound Delivery in S/4 HANA4). Subcontracting Procurement Process to receive the Finished Goods to direct consumption5). Subcontracting Procurement Business flow on White board6). Comparison of Standard Procurement with Subcontracting Procurement.Doubts sessions will clarify the questions raised during the process of learning. The business usage and benefits will be helpful to beginners and experienced SAP Consultants. SAP Consulting needs in depth learning which will be provided in these sessions. 2. Stock Transport Order Process- Overall Stock Transport Order Process overview with frequently asked questions. Intra and Inter Company STO are explained. - Intra Company Stock Transport Order without Delivery configuration and step by step testing steps. This process will happen within SAP MM- Intra Company Stock Transport Order with Delivery configuration and step by step testing steps. This process is integrated with SAP SD- Movement types and accounting entries related to Intra Stock Transport Order are explained in this course

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software. Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform. We are covering Excel fundamentals, Quick Access Toolbar, Basic excel functions such as SUM, MIN MAX, Average AutoSum. Excel sheet modifications using Moving Copying data, Inserting deleting rows, Hiding, unhiding and re-naming. Formatting data, Font formatting, Creating styles, Conditional formatting, Creating Charts, Excel column chart, Adding and modifying data, Excel Pie chart. Pivot Table, Creating a Pivot table, Modifying pivot table, Grouping pivot table, Creating pivot charts, Filtering pivot charts, Excel conditional functions, IF function, Nesting function. Lookup functions VLookup, HLookup, INDEX MATCH. For PowerBi we go through Power BI , Introduction to PowerBI desktop, Connecting to Data, Table relationships, Data model, Filter Flow, Data Analysis Expressions (DAX) – Calculated Columns, Data Analysis Expressions (DAX) – Measures, IF, AND, OR, CALCULATE , CALCULATE ALL, SUMX, Report View in PowerBI, Inserting Charts, Formatting, Filtering options, Matrix Visuals, Treemaps, Trend lines and forecast, Managing roles in Power BIPublishing to PowerBI service.

In today's digital world, proficiency in Microsoft Word is a vital skill for anyone looking to succeed in their personal or professional life. From crafting polished resumes and reports to collaborating on projects and creating engaging content, Word's versatility makes it an indispensable tool for communication and productivity.This comprehensive video course is designed to take you on a transformative journey from a Word novice to a confident expert. Whether you're a student, a professional, or someone simply looking to enhance your digital literacy, this course offers a step-by-step approach to mastering all the essential features and functionalities of Microsoft Word.Course Highlights:Beginner-Friendly: We start from the ground up, assuming no prior knowledge of Word. You'll learn the fundamentals of typing, navigating the interface, and formatting text, building a solid foundation for more advanced concepts.Comprehensive Coverage: We cover a wide range of topics, from basic formatting and document creation to complex layouts, tables, charts, and collaborative features.Practical Examples: Each lesson is packed with real-world examples and exercises, ensuring you understand how to apply your newfound skills in practical situations.Timesaving Tips Tricks: We'll share insider secrets and shortcuts to streamline your workflow and boost your efficiency in Word.Engaging Visuals: High-quality video demonstrations and clear screen recordings make learning fun and effective.By the end of this course, you'll be able to:Confidently create, edit, and format documents of any complexity.Design visually appealing layouts with images, tables, and charts.Collaborate seamlessly with others on shared documents.Leverage advanced feat

Siapakah yang paling jago presentasi di kantor, kampus, atau ruang kelas? Harusnya jawabannya adalah: ANDA!Tak peduli kalau Anda minder di depan kelas, rapat kantor, atau belum pernah bekerja dengan slide presentasi sebelumnya. Tidak penting juga apakah Anda ingin meningkatkan skill presentasi semata. Yang jelas, video course ini tepat untuk Anda.Video ini adalah online course yang paling lengkap, to-the point, dan mudah dipahami untuk penggunaan MS Powerpoint berbahasa Indonesia di Udemy! Tidak memandang apakah Anda adalah seorang pelajar, mahasiswa, pekerja kantoran, manager, atau bos-bos, video course ini dirancang tentu saja untuk Anda! Dalam kursus ini, kami akan mengajari Anda menggunakan MS Powerpoint dari Zero SAMPAI Pro!Dilengkapi dengan berjam-jam video course, tugas-tugas, dan kuis, kami akan menyampaikan MS Powerpoint dalam bahasa yang mudah dipahami dan membumi. Yang Anda butuhkan hanyalah MS Powerpoint (2013-2021 atau 365). Video course ini akan mengajarkan Anda mengoperasikan MS Powerpoin secara praktis dengan setiap section dilengkapi screencast yang mengajarkan langkah-langkah, tip dan trik, dan pemanfaatan slide presentasi, lengkap dengan petunjuk visual yang oke banget! Tunggu apa lagi, ayo belajarlah dengan cara yang terbaik untuk Anda!Kami akan memulainya dengan operasi dasar MS Powerpoint seperti pembuatan slide presentasi dan section. Lantas, kami akan membantu Anda menggunakan MS Powerpoint sesuai kebutuhan. Anda akan kami ajak menyelami berbagai topik, termasuk:Membuat slide, section, dan mempercantik presentasiBekerja dengan teks, WordArt, dan Format untuk memperindah teks ituMemasukkan chart ke dalam slide dan bagaimana mengelola elemen

Why do CEOs pay consultancies hundreds of thousands to make a few slides and give a few presentations? Besides performing in-depth analysis, consultants synthesize hundreds of hours of research into a structured, compelling presentation that fits within 30 minutes to 1 hour. Would you like to bring this level of professionalism and polish to all your presentations at work? This course gives you the secrets used by top-tier consulting firms like McKinsey and BCG to present to CEOs and other senior clients. It is based on the first-hand experience of two consultants (ex-McKinsey and ex-BCG). Together, we have consolidated our experiences into one easy-to-follow course. This is a concise, to-the-point course summarizes for you the most important best practices for preparing and giving a presentation, alongside visual examples of good versus bad presentations. Equipped wtih these tips, you will stand out from colleagues, impress your stakeholders, and set yourself up for success in your role. This is applicable for anyone who needs to give a presentation, including students, potential consultants, Business Analysts, Data Analysts, Project Managers, Strategy and Corporate development roles (and many more!).By the end of the course, you will understand:How to structure a presentationHow to design slides to share quantitative and qualitative ideasHow to present confidently and professionally

Master the world's most widely used productivity tools with this comprehensive Microsoft Office Bundle course. Designed for beginners and professionals alike, this course provides step-by-step training in Microsoft Excel, Word, and PowerPoint, helping you build practical skills that are essential in today's workplace.You will start with the fundamentals and gradually progress to advanced features, learning how to create professional documents, analyze data efficiently, and design engaging presentations. Through hands-on exercises and real-world projects, you will gain the confidence to use Microsoft Office applications effectively in business, academic, and personal environments.In Microsoft Excel, you will learn formulas, functions, charts, PivotTables, data analysis, dashboards, and productivity-enhancing techniques. In Microsoft Word, you will master document formatting, templates, tables, styles, reports, mail merge, and professional document creation. In Microsoft PowerPoint, you will create visually appealing presentations using themes, animations, transitions, multimedia elements, and presentation best practices.Whether you are a student, job seeker, office professional, entrepreneur, or business owner, this course will help you improve productivity, enhance workplace efficiency, and develop valuable skills that employers actively seek.By the end of this course, you will be able to confidently use Excel, Word, and PowerPoint to create professional documents, analyze data, and deliver impactful presentations.