Microsoft Excel Masterclass: From Beginner to Advanced

التعرف على جداول البيانات سيتم تعريفك على جداول البيانات في Excel والعديد من الوظائف والدالات الأساسية للبرنامجوسيتم تغطية المواضيع التالية:قراءة البيانات في Excel من باستخدام أنواع مختلفة من البيانات.الوظائف الأساسية في Excel كالحساب والدالات المنطقية.تنسيق الأسطر والأعمدة.استخدام الدالات ونسخها بحالات تثبيت المرجع وتغيره. دوال تنظيم جدول البيانات.في هذه الوحدة سيتم تعريفك على طيف واسع ومهم من دوال التنظيم والاستعلام في Excel كـ : الدالات الشرطية ودالات البحث.وسيتم تغطية المواضيع التالية:الدالات الشرطية IF وفروعهاالدالات البحثية VLOOKUP, HLOOKUPالدالات المولدة للأرقام العشوائية. التعرف على التصفية والجداول المحورية والرسوم البيانية.في هذه الوحدة سيتم تعريفك على قدرات التصفية، وأداة التلخيص الرائع "الجداول المحورية – Pivot Tables"، كما سيتم شرح الرسوم البيانيةوسيتم تغطية المواضيع التالية:دالة VLOOKUP عبر عدة جداول متعددة.تصفية البيانات.استخدام الجداول المحورية مع البيانات الفئوية والبيانات الرقمية.التعرف على الرسوم البيانية وقدراتها. الرسوم و الأشكال البيانية المتقدمة.في هذه الوحدة سيتم استكشاف مختلف أنواع الرسوم البيانية والتقنيات المتاحة لتعديل الرسوميات في Excelوسيتم تغطية المواضيع التالية:الرسومات والأشكال الخطية، الأعمدة البيانية، الدائرة (الفطيرة)الرسوم المحورية.شكل انتشار.المدرج التكراريتطوير الخوارزميات للتحليل الإحصائي للبيانات الضخمة.الحصول على المعرفة اللازمة حول تطبيقات البيانات الضخمة.التعر

This google sheets course is designed to help you move from basic sheet usage to full confidence in handling real work data. Many people open Google Sheets daily but only use a small part of its power. They enter data, maybe add a simple formula, and stop there. This course changes that.You will learn Google Sheets in a clear, step-by-step way, starting from the basics and moving toward real-world tasks used in offices, businesses, and freelance work. Every topic is explained with examples that match daily use, not theory.This course starts with the foundation. You will understand how Google Sheets works, how rows, columns, and cells behave, and how to avoid common mistakes beginners make. Once that is clear, you move into formulas and functions, which are the heart of any online spreadsheet.You will learn how to use Auto Fill and Smart Fill to save time, apply math rules like BODMAS correctly, and work with important functions such as SUM, AVERAGE, COUNT, MAX, and MIN. These are used daily in reports, tracking sheets, and dashboards.As you move ahead, you will work with logical functions like IF and related conditions. This helps you make sheets that think and respond based on rules. For example, showing results based on marks, status, or limits. You will also practice tasks that combine multiple conditions, which is a key skill for job-ready work.Text functions are another major part of this course. You will learn how to clean and format data using functions like UPPER, LOWER, PROPER, TRIM, LEFT, RIGHT, MID, FIND, CONCATENATE, REPLACE, and SUBSTITUTE. These skills are very useful when dealing with imported data, customer lists, or reports from other tools.This google sheets tutorial also covers filtering, sorting, slicers, and conditional formatting. These features help you read large data easily and present it clearly. You will know how to highlight values, filter records, and prepare sheets that others can understand quickly.You will also le

A POS, or point of sale, enables merchants to process payments and log transactions. It is a computer-based cash register with software capable of tallying up orders, taking payments, monitoring inventory and buying trends, creating invoices, and collecting marketing data.In case of Odoo, the merchants can be retail store of RestaurantHow does a POS system work?A POS system combines hardware and softwareHardware includes cash registers, card readers, barcode scanners, and receipt printers Software manages sales, inventory, customer data, procurement, finally financial transactions are stored in Accounting towards generating Profit/Loss and Balance sheet.POS systems can be used on a variety of devices, including traditional registers, smartphones, and tablets What are the benefits of a POS system? Speed up transactions, Reduce the risks of human error, Streamline business operations, Make inventory management easier, and Provide quick access to business data. This course covers the following topics. Understanding on Premise and Cloud through a real time analogy Point of Sales - Restaurant Retail Store POS - Restaurant Overview POS - Retail Store Overview Odoo Point of Sales (POS) critical set up Odoo Point of Sales Set up as floor plan and table for Restaurant Odoo Point of Sales Set up as Restaurant or Retail Store? Odoo Point of Sales - Product Set upProduct Set UpProduct types.Point of sales Transaction Business with Kitchen Display

SAP is the most popular enterprise business system used by the biggest organisations in the world to help run their companies. This SAP power-user course is designed for SAP beginners and will teach you the basics to intermediate level of the SAP system knowledge in no time. After you have completed this course you will be comfortable working with the most commonly-used functions and features of SAP. This course not only gives you a thorough insight into how the SAP work but is delivered in such a way that everyone who takes the course will have absolutely no problem in understanding all the topics discussed. This course makes it so easy to learn SAP, you will running transactions and analyzing report data in no time. So not to bog you down with theory this course focuses on learning through a hands-on approach and is packed full of practical step by step examples so that you are using SAP from day one. Whether you are a new SAP user, Business Analyst, Project Manager or a C-Level executive, this SAP course is designed to be your guide and introduction to SAP systems. So What is Covered as Part of this Course: Introduction to the CourseIntroduction to Enterprise Resource Planning (ERP) and the SAP SystemHow to Navigate in the SAP SystemRole of Organizational Structure in the SAP SystemA Business Example: Samsung Inc.,Fundamentals of Sales DistributionHow to Create SD Master Data in the SAP SystemPerform end to end (Order to Cash Cycle) transactional activities in the SAP SystemA bonus task: Introduction to the Customization and ASAP MethodologyAnd much more!

Excel Macros - VBA for Report AutomationThe objective of this course is to make you expert in writing own macros code Exclusive for Report Automation. If you see the course outline its all practical topics and only those codes has been taught which is regularly used in the report automation. The other benefit is its a complete class room training hence i have very slow step by step to make you understand each topics.In this course i have even covered Sheets and Files Consolidation Segregation Project which is regular required in Report Automation in Corporates.OverviewAdvanced Excel users encounter repetitive tasks such as: reports that need to be produced, data that needs to be updated or tables that need to be formatted on a regular basis. Using “Macros” many of these routine tasks can be automated. Using advanced knowledge of Excel learned in this class they can record the steps or operations that they want to perform, and then press a button to repeat them over and over again (and again).Prerequisite : Proficient knowledge of Microsoft Excel. This class is for non-programmers.Target StudentThis course is for individuals who use Excel 2016, 2013 or 2010 frequently and who need to automate routine tasks. Programming experience is not required.Thanks RegardsRamzan RajaniMicrosoft Excel Specialist and Certified Trainer

Learn the basics of the world’s most powerful document-creation softwareWord is more than a word processor. It has the potential to make you more productive and make your job easier! While used by millions of people daily, there are few who know how to maximize Word’s functions and features. In this course taught by Microsoft trainer Christina Tankersley, we’ll show you everything you need to know to work efficiently and create polished documents.From starting new blank documents to using existing templates, you will learn how to create documents that are easy to read, use, and share. In addition, you will learn many keyboard shortcuts that will make you more efficient when navigating inside long documents. You’ll learn to use styles for quick formatting, and the Editor tools to polish your document. And if you’ve wondered how to easily work with tables to organize and sort your data, our trainer will show you the best ways to do it. If you want to start creating professional documents—this course is for you!Topics covered include:Navigating within documents using shortcutsCreating, saving, and printing documentsSelecting, copying, and moving textUsing Find, Replace, and Go ToFormatting textApplying StylesUsing the Format PainterFormatting paragraphsWorking with tablesSorting listsUsing the Editor, the Thesaurus, and the Read Aloud featureInserting and modifying graphicsQuickly search and find the skills you want to master from our list of lessons – then just point, click, and learn.Enjoy high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!