PowerQuery M code language Part2 (5 hours)

بسم الله الرحمن الرحيمأساسيات مايكروسوفت إكسل: خطوة بخطوة للمبتدئينهل ترغب في تعلم برنامج مايكروسوفت إكسل من الصفر وبطريقة عملية ومبسطة؟هذه الدورة صممت خصيصًا لك إن كنت مبتدئًا وترغب في إتقان المهارات الأساسية التي تحتاجها لاستخدام Excel في العمل أو الدراسة.برنامج Microsoft Excel هو أداة لا غنى عنها في أي بيئة عمل اليوم، سواء في القطاع الحكومي أو الخاص، في الأعمال الصغيرة أو المؤسسات الكبرى. من خلال هذه الدورة، ستكتسب المهارات الأساسية للتعامل مع البيانات، إعداد الجداول، تنسيق التقارير، وتحليل المعلومات بطريقة فعالة ومنظمة.ما الذي ستتعلمه في هذه الدورة؟التعرف على واجهة البرنامج وأهم الأدوات المستخدمة في إكسل.تنظيم أوراق العمل وتنسيق الخلايا بأنواعها المختلفة.إدخال البيانات وتنسيقها بشكل احترافي.استخدام التعبئة التلقائية لتوفير الوقت والجهد.تطبيق تقنيات النسخ واللصق بطرق احترافية.فرز وتصفية البيانات للحصول على رؤى أوضح.إنشاء الجداول الذكية والتفاعلية داخل Excel.لماذا تختار تعلم Excel؟أداة مطلوبة في سوق العمل: العديد من الوظائف تتطلب إتقان إكسل كمطلب أساسي.تنمية المهارات العملية: استخدام إكسل سيساعدك على رفع كفاءتك وزيادة إنتاجيتك.مرونة في الاستخدام: Excel يُستخدم في مجالات متعددة مثل الإدارة، المحاسبة، التعليم، التحليل الإحصائي، والمزيد.سهولة التعلم: مع هذه الدورة، ستتعلم بأسلوب مبسط دون الحاجة لأي خلفية سابقة.لمن هذه الدورة؟المبتدئون في عالم مايكروسوفت إكسل.الطلاب والباحثون الراغبون في تنظيم بياناتهم وتحليلها.موظفو الشركات والمؤسسات والهيئات الحكومية.أي شخص يسعى ل

A warm welcome to the SAP HCM UK Payroll course by Uplatz.SAP HCM UK Payroll is an SAP module that manages the UK Payroll system including organizational management, different wage types, time management payroll, reporting HR, the configuration of master data, and more.Payroll in the UK can be run once-a-month, which is normal in the UK, or on a weekly basis if chosen. For running the payroll contains gathering UK payroll taxes from employees' salaries. Overseas employers need to consider both income tax and National Insurance tax. The UK holiday pay regime has been around for some time and most UK payroll managers, HR directors, and SAP Payroll administrators appear to be conscious of it. However, whilst some organizations use the novel designs, many employers still haven’t taken any action to change their processes or SAP payroll systems (Employee Central Payroll and on-premise SAP Payroll are affected in the same way). The reason for this is quite often that they are confused about the ambiguity of the court verdicts or that they are to come for SAP to provide a convenient solution that they can then just switch on.With SAP UK Payroll one can avoid expensive and hard to manage procedures. SAP UK Payroll is an SAP component that achieves the UK Payroll scheme including structural management, different wage types, time management payroll, reporting HR, the formation of master data, and more. This is a dedicated path for SAP HR advisors looking to advance payroll detailed knowledge. The course takes you over end to end payroll procedures covering UK legislations. Since payroll is a dangerous process in any association, the dedicated knowledge of it not only advances your career prospects but also makes you highly appreciated in SAP HR projects.Uplatz offers end-to-end training on SAP UK Payroll covering all topics in great detail and supported by real-life scenarios. This SAP UK

A warm welcome to the Oracle Documaker course by Uplatz.Oracle Documaker is a document automation and customer communications management (CCM) software solution developed by Oracle Corporation. It allows businesses to streamline the process of creating, managing, and delivering customized documents such as contracts, policies, statements, invoices, and other forms of correspondence. In fact, Oracle Documaker is one of the most widely-used Enterprise Document Automation (EDA) solutions available for the organizations globally.With Oracle Documaker, businesses can automate the entire document lifecycle, from document creation to delivery. The software provides a user-friendly interface that enables non-technical users to create and modify documents quickly and easily. It also supports multiple output formats, including PDF, HTML, and print, ensuring that documents can be delivered in the format that best suits the recipient.Oracle Documaker also offers advanced features such as content management, data integration, and workflow automation, which enable businesses to further improve their document creation and delivery processes. The software can be deployed on-premises or in the cloud, providing flexibility for businesses of all sizes and industries.In summary, Oracle Documaker is a powerful solution for businesses looking to automate their document creation and delivery processes, reduce costs, and improve customer engagement.What is Customer Communication Management (CCM)?A strategy to improve creation, delivery, storage and retrieval of outbound communications.Marketing, New product introductions, Renewal Notification , Claims Correspondences, bills and payment Notifications. Interaction with customer can happen through wide range of media and output including documents, email, SMS and HTML web pages.CCM supports these objectives by providing compa

Unlock the full potential of Google Sheets with our comprehensive Google Sheets Masterclass. Whether you're a beginner or an intermediate user, this course is designed to enhance your spreadsheet skills and empower you to tackle complex data analysis, create dynamic reports, and streamline your workflow like a pro.In this hands-on course, you'll embark on a transformative learning journey, guided by expert instructors who will demystify the powerful features and functionalities of Google Sheets. You'll gain a deep understanding of how to harness the full range of tools available, enabling you to leverage the platform's capabilities to their fullest.Learn What is Generative AI / Gen AIParticipate in Practice test to test your learning skillsupdate: Learn the top AI tools every professional needs to boost productivityKey Learning Objectives:Master the Fundamentals: Build a solid foundation by learning essential spreadsheet concepts, formatting techniques, and basic formulas and functions in Google Sheets.Advanced Formulas and Functions: Take your skills to the next level by exploring complex formulas, logical functions, statistical analysis, and data manipulation techniques.Data Analysis and Visualization: Discover how to transform raw data into meaningful insights using advanced data analysis tools, pivot tables, charts, and custom data visualization techniques.Collaboration and Automation: Learn how to collaborate effectively with others using real-time collaboration features, track changes, and automate repetitive tasks with scripts.Data Import and Integration: Explore methods for importing data from external sources, such as databases and APIs, and learn how to integrate Google Sheets with other Google Workspace applications.Data Protection and Security: Understand b

This comprehensive course provides a clear and structured introduction to Oracle Database fundamentals, designed for beginners who want to understand how databases work and build a solid foundation in Oracle Database Administration. Whether you are a student, aspiring database professional, or IT enthusiast, this course will guide you through the essential concepts and practical skills needed to manage and interact with an Oracle database confidently.Delivered entirely through high-quality, video-based lessons with a total duration of just over two hours, the course is concise, engaging, and easy to follow. Each module is logically structured, taking you step by step through the key components of Oracle Database technology.You’ll begin by exploring core database concepts, including data types and constraints, which define how data is stored and maintained. The course then introduces views and the dual table, essential tools for querying and managing data efficiently. You will also learn how to design and understand Entity Relationship Diagrams (ERDs), a crucial skill for visualizing database structures and relationships.As the course progresses, you will gain hands-on experience with SQL—the language of databases—learning how to use operators and SQL sub-languages to manipulate and retrieve data effectively. You’ll also explore how to install a sample Oracle Database, providing a practical environment to practice your skills. Finally, you’ll learn how to view, limit, and sort data, enabling you to manage and analyze information like a true database professional.By the end of this course, you will have a strong understanding of Oracle Database fundamentals and the confidence to take your first steps toward becoming an Oracle Database Administrator (DBA) or enhancing

Updated for 2026!Are you a Civil Engineer who wants to master Primavera P6 and build a career as a Planning Engineer?Then this is the course for you!In this Primavera P6 Masterclass, you’ll learn how to plan, schedule, and monitor real construction projects — buildings, roads, and infrastructure — step by step.I’ve designed this course based on my 8 years of site and planning experience, combining real-time civil projects, BOQ data, and construction workflows.Course Structure HighlightsOver 25+ hours of video contentHands-on planning exercises with site-based case studiesDownloadable resources templatesSubtitles + Lifetime access + Certificate of Completion What You’ll Learn:Project Setup PlanningHow to calculate duration for any construction projectCreating resources in Primavera P6 (manual + Excel import)Understanding and setting activity relationshipsAssigning high-level weightages to activities Resource Cost ManagementReading resource and activity usage spreadsheetsCreating and managing contract milestonesLinking activities with project milestonesTracking Progress ReportingCreating and evaluating S-CurvesAssigning baselines and tracking project performanceUpdating actual progress (Part 1 Part 2)Testing updated project schedulesEarned Value Management explained with real examples