MS Excel untuk Pemula Hingga Mahir (Kurikulum Komplet!)

A warm welcome to the SAP BPC 11.1 Embedded course by Uplatz.The BPC model used in SAP BPC embedded is a model centered on Business Warehouse-Integrated Planning. The BPC embedded model is diverse from the Standard model. This model comprises of data access to all community employers. The data provided by this model is at various levels and it can lead the transactional data. The transactional data is provided from host EDW environment and can be accessed by the application. By using the embedded model in BPC user can easily access the transactional and master data within the host BW. This data is organized by the administrator group and can be shared with many other users. With integration in BPC it can provision the use of real- time info providers. It can also support the aggregation levels. In the BPC embedded model one can perform BW Queries into the SAP EPM for MS Office. The embedded model also runs audit functions which further permits to create audit reports.With BPC embedded you can rapidly build a team and thus allows you to quickly scale a project. The embedded BPC also permits to run on a HANA Database that means Embedded planning functions run directly in the HANA database, as opposed to Standard functions. The embedded functions allow to migrate over to S/4HANA implementation at a later date to achieve real time consolidation without a full re-implementation. Standard BPC cannot be migrated to any form of Embedded be it on BW or S/4HANA. This model is integrated with Lumira, Webi and Design Studio and other front-end tools and thus give easy reporting with additional tools​.SAP BPC Embedded 11.1 - Course SyllabusTOPIC 1: OverviewGeneral Concepts in Business Planning – OverviewBW Overview/ ArchitectureTOPIC 2: Integrated Planning OverviewInfo ObjectsIn

A warm welcome to the Oracle Multitenant Architecture and Database Administration course by Uplatz.Post Oracle 12c, Oracle came up with new architecture called Multitenant Architecture.In previous versions of Oracle database versions, there was a major problem - if the user starts a new instance there are particular background processes for each instance and each of these process wasted a lot of memory and resources thus affecting the system performance badly. Hence, Oracle came up with a new idea to connect different databases into one database technique. That idea is called “Multitenant Architecture.”That one main database is called CDB (Container Database) and other databases which are used to connect the main database are called PDB (Pluggable Database). A pluggable database is fully compatible with a non-CDB. In fact, Oracle has something called the PDB/non-CDB compatibility guarantee, which states that anything you would do in a non-CDB would also work in a PDB. This compatibility guarantee is important when it comes to certifying things like third-party vendor products to work in a multitenant architecture.How to create a multitenant database environment in Oracle 12cWhen creating a database, you must designate it as a CDB or non-CDB for it to be able to support the multitenant architecture. The next set of examples walks you through the steps to create a container database with the DBCA. There is only one step that differentiates a CDB from a non-CDB when using the DBCA.The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. The Oracle Multitenant Database Architecture is designed to host multiple “PLUGGABLE DATABASE” PDB databases within a single CDB “CONTAINER DATABASE” container instance. The architecture of the CDB instance maintains more PDBs within it, using the same set of processes and the same SG

A warm welcome to the SAP Materials Management course by Uplatz.SAP MM (Materials Management) is a module of the SAP Enterprise Resource Planning (ERP) package that is used for Procurement Handling and Management. SAP MM is a material management tool that can help automate and streamline corporate Procurement Handling and Inventory Management (in other words it is about managing resources). Materials management is integrated with other modules such as SD, PP and QM.SAP Materials Management (SAP MM) is one of the most important SAP functional modules that deals with management of material and inventory that helps to run any business operation smoothly. SAP MM module also supports other logistic functions where material and inventory information is required. SAP MM plays vital role in speeding up the procurement and material management activities as well as to run business operations.Uplatz offers comprehensive SAP MM Training course with focus on imparting world-class quality.This course will equip you with knowledge and hands-on practical business scenarios. This will also prepare you well for SAP MM job market as well as for SAP MM certification. Our SAP MM Training course is delivered by a highly experienced and expert tutor with industry experience of more than 15 years.SAP MM - Course CurriculumIntroduction to ERP and SAP MM (Materials Management)Enterprise StructureLogistics GeneralPurchasingSchema DeterminationVendor EvaluationPhysical InventoryValuation and Account AssignmentLogistic Invoice VerificationIntegrationExcise Duty ConfigurationPurchase OrderMaterial MasterRFQ QuotationQuota ArrangementInfo Records

In this course you will learn how to manage files and how to exchange data between files and between different Microsoft Office applications using VBA.We will start giving some fundamental information e.g. VBA files and folder functionsVBA files and folder attributesVBA data structuresVBA typesAdvanced Data Structures in VBAVBA - StringsVBA - Date and TimeVBA - ArraysVBA Excel ObjectsVBA ClassesVBA filesFunctions needed to write files in VBAThe StringBuilder classSome important information from the Application object (RecentFiles, defaultPath) This information is the basis to continue in this course.In details we will then learn:VBA and text files: how to read and write to text files, how to modify a text file, how to append text to an existing text file, how to load an Array variable with data from a delimited text file. We will also see how to read and write to CSV files in VBAVBA and binary files: how to read and write to binary files, how to read from binary file and import into Excel, how to create a Binary File from Text File and Read to Excel, how to append to binary fileFile Converters in VBA: VBA – Convert File Formats, how to convert CSV to Excel with VBA, how to convert Excel to CSV with VBA, Excel to PDF exporter, how to convert html to text file, how to convert text file into excel, how to convert html to PDFConnect MS Office applications: Controlling One Microsoft Office Application from Another, copy data from Excel to Powerpoint, activating Other Applications with Excel VBA, Using VBA to Paste from Excel to Word and PowerPoint, Controlling Powerpoint and Word from Excel using VBA, Export the text of a presentation to a CSV/Excel file, export Wo

في كورس واحد Google Workspace أتقن أشهر أدواتدون الحاجة لشراء ثلاثة كورسات منفصلة؟ Google Docs وGoogle Sheets وGoogle Slides هل تريد تعلم Google Workspace هذا الكورس يجمع أهم تطبيقات في رحلة تعليمية عملية تبدأ من الأساسيات وتنتهي بالاحتراف، مع تطبيقات واقعية تساعدك على استخدامها في الدراسة، والعمل، وإدارة مشاريعك اليومية.سواء كنت طالبًا، موظفًا، معلمًا، أو تعمل عن بُعد، ستتعلم كيف تنشئ مستندات احترافية، وتحلل البيانات، وتصمم عروضًا تقديمية جذابة، وتتعاون مع فريقك بسهولة.ماذا ستتعلم؟ احتراف جوجل دوكس لإنشاء وتنسيق المستندات. احتراف جوجل شيت لإدارة البيانات واستخدام الصيغ والدوال. احتراف جوجل سلايدز لتصميم عروض تقديمية احترافية.إنشاء الجداول والرسوم البيانية. مشاركة الملفات والعمل الجماعي وتتبع التعديلات. استخدام اختصارات لوحة المفاتيح لتوفير الوقت. تجهيز الملفات للطباعة أو المشاركة.محتوى الكورس Google Docs :أولًاستتعلم إنشاء المستندات الاحترافية، تنسيق النصوص، إدراج الصور والجداول، الفهارس، التعليقات، مشاركة الملفات، وتتبع التعديلات. Google Sheets :ثانيًاستتعلم إدخال البيانات، استخدام أشهر الدوال، الفرز والتصفية، الرسوم البيانية، الجداول المحورية (Pivot Tables)، وتحليل البيانات بطريقة عملية. Google Slides :ثالثًاستتعلم تصميم عروض تقديمية احترافية، تنسيق الشرائح، إضافة الصور والأشكال، الانتقالات، الحركات، وطرق تقديم العرض باحتراف.لماذا هذا الكورس؟ثلاث كورسات في كورس واحد شرح عملي خطوة بخطوة. مناسب للمبتدئين. تطبيقات ومشاريع واقعية. يمكنك تطبيق ما تتعلمه مباشرة في الدراسة أو العمل.

1. ObiettiviIl corso è una guida passo‑passo con lo scopo di condurre l'utente ad utilizzare SharePoint Online come piattaforma cloud per organizzare dati e documenti, collaborare in team e costruire un ambiente di lavoro digitale strutturato. Imparerai a usare SharePoint anche come Web Database grazie agli elenchi di dati e alle librerie documenti, progettati per gestire informazioni in modo tabellare e collaborativo. 2. Cosa saprai fare al termineSaprai creare e gestire elenchi di dati in SharePoint impostando colonne e diverse tipologie di dati, così da raccogliere informazioni in modo ordinato e coerente con le esigenze operative. Potrai intervenire in modo pratico sulla gestione dei contenuti, effettuando modifiche e aggiornamenti, lavorando anche sulle pagine collegate al sito e mantenendo una struttura chiara e facilmente consultabile. Inoltre, sarai in grado di usare gli allegati quando necessario e di applicare logiche di organizzazione dei contenuti che rendano l’elenco davvero utile nel lavoro quotidiano, evitando confusione e duplicazioni. Saprai anche costruire librerie documenti come archivio centralizzato per i file dell’organizzazione, creando e gestendo raccolte documentali pensate per il lavoro in team. In questo contesto potrai usare metadati per descrivere e classificare i documenti, migliorando la ricerca e la reperibilità dei contenuti. Avrai padronanza della cronologia delle versioni per tracciare le modifiche e recuperare varianti precedenti, e sfrutterai il co‑authoring per lavorare in modo realmente collaborativo, anche in contemporanea con i colleghi, in un flusso di lavoro aziendale c