UdemyMicrosoft Excel

Pengolahan Database dengan MS Excel

التصنيف الكامل: Office Productivity > Microsoft > Microsoft Excel

Pengolahan Database dengan MS Excel

عن هذا الكورس

MS Excel sudah sering dikenal sebagai software untuk pengolahan data. Nah, sumber data itu ada banyak. Salah satunya berasal dari database. Maka dari itu, video course ini menjelaskan bagaimana mengkolaborasikan data-data dari sebuah database ke dalam MS Excel. Ada dua buah aplikasi yang dibahas, yaitu:MS Excel sebagai software utama.MySQL sebagai database server.Mengapa kita perlu mengolaborasikan data-data itu ke dalam MS Excel? Agar dapat diolah menggunakan fungsi-fungsi dan formula MS Excel. Jadi, kalau Anda pengguna MS Excel maka ini merupakan kabar baik sebab ada banyak fungsi yang bisa Anda pakai untuk mendapatkan hasil olahan data. Jadi, pelajari bagaimana caranya menggabungkan MS Excel dan database dengan mengikuti video course ini.

تعلم أونلاين 100%

شاهد الدروس في أي وقت ومن أي مكان

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق ومباشر

ينقلك لصفحة التسجيل الرسمية

سعر الكورس
$19.99
المنصة:Udemy
الانتقال للكورس / التسجيل الآن
🔒 عند النقر، سيتم فتح صفحة الكورس الرسمية على منصة Udemy في نافذة جديدة.

كورسات مقترحة في نفس المجال

عرض كل الكورسات ←
Linux Virtual Machine Setup on Oracle Virtual Box
Udemy
Database Administration

Linux Virtual Machine Setup on Oracle Virtual Box

Oracle is among the world's most complex and sophisticated databases, and mastering this complex set of computer programs requires many skills. Learning Oracle is only appropriate for experienced professionals with appropriate prerequisite training. An Oracle DBA is a senior-level manager who often earns as much as a Vice President, and has lots of responsibility, managing the mission-critical data for the whole company. Basic Skills Required to Become an Oracle DBA System Analysis Design skillsDatabase Design skillsPhysical Disk Storage skillsData Security skillsBackup and Recovery skillsChange Control Management skills Why This Course?Learn the fundamentals to creating your initial setup at home and dirty your hands with important tools. This course is built to help you excel in basic Oracle setup at home. Its a mandatory course to proceed with any of the Oracle DBA courses. Use this course to install all the mandatory tools and give them the best practice you can

Web Development: Ultimate Web Development Pro Bootcamp
Udemy
Front End Web Development

Web Development: Ultimate Web Development Pro Bootcamp

Become a job-ready full-stack developer with this all-in-one, industry-focused bootcamp that combines modern web development with the power of Artificial Intelligence. Designed for beginners and professionals alike, this course takes you from zero to advanced by building real-world, production-ready applications used by top tech companies.You’ll master frontend development using HTML, CSS, JavaScript, React, Next.js and Docker and become confident in backend development with Node.js, Express, REST APIs, authentication, and databases like MongoDB and PostgreSQL. Learn how to design scalable architectures, implement secure user authentication, and deploy applications to the cloud.What makes this bootcamp unique is its strong focus on AI-powered development. You’ll learn how to integrate AI features using tools like OpenAI APIs, build intelligent chatbots, recommendation systems, AI-driven forms, and automate development workflows using AI assistants. Discover how AI can help you write better code, debug faster, generate UI components, and optimize performance.This course is 100% project-driven, featuring multiple real-world projects such as SaaS platforms, dashboards, e-commerce applications, and AI-enabled web apps. You’ll also learn Git GitHub, DevOps basics, CI/CD, Docker fundamentals, and modern deployment strategies. By the end of this bootcamp, you’ll have a strong portfolio, practical experience, and the confidence to apply for Full-Stack Developer, Frontend/Backend Developer, or AI-enabled Web Developer roles.

Microsoft Excel Crash Course 2026: Masterclass for Weekend
Udemy
Microsoft Excel

Microsoft Excel Crash Course 2026: Masterclass for Weekend

The "Microsoft Excel Crash Course 2026: Masterclass for Weekend" is your fast track to mastering Excel in just a weekend. Designed for beginners and professionals alike, this comprehensive course equips you with the skills to harness the full power of Excel for data management, analysis, and visualization. In this hands-on crash course, you’ll start with the basics of Excel, learning how to navigate the interface, create and format worksheets, and organize data efficiently. Quickly progress to mastering essential features like formulas, functions, and pivot tables to analyze data with ease. update: Learn the top AI tools every professional needs to boost productivityDiscover how to create dynamic charts and graphs to visually represent data and share insights effectively. Explore math formulas, data validation, and filters to enhance your datasets and make them more interactive. The course also introduces advanced topics, such as VLOOKUP, HLOOKUP, INDEX-MATCH, and other critical functions that save time and improve accuracy. Learn to automate tasks with macros, and gain insights into Excel’s data analysis tools for more sophisticated workflows. By the end of this weekend masterclass, you’ll confidently manage and analyze data, build professional-grade spreadsheets, and create stunning visual reports. Whether you're preparing for a job, tackling business challenges, or improving productivity, this crash course is your ultimate guide to Excel mastery. Make the most of your weekend. Enroll now and unlock the full potential of Microsoft Excel!

Microsoft Excel in Tamil (தமிழ்) - From Beginner to Pro
Udemy
Microsoft Excel

Microsoft Excel in Tamil (தமிழ்) - From Beginner to Pro

Excel சிறப்பினராக ஆகவும் – அடிப்படை முதல் AI-ஆதரவு பெறும் உற்பத்தித்திறன் வரைநீங்கள் Microsoft Excel இல் நிபுணராக ஆக தயாரா? முழுமையான தொடக்கன் அல்லது திறன்களை மேம்படுத்த விரும்புபவரா? இந்த தமிழ்-மொழி (Tamil Language) Excel பாடநெறி நீங்கள் step-by-step மூலம் functions, formulas, menu options மற்றும் AI-ஆதார Excel tools பற்றி முழுமையான வழிகாட்டி வழங்கும். இது உங்களுக்கு வேகமாகவும் திறமையாகவும் வேலை செய்ய உதவும்.இந்த பாடநெறியில் நீங்கள் கற்றுக்கொள்ளப் போகும் விஷயங்கள்:Excel ஐ அறிந்து கொள்வது:Rows, columns, cells, ranges, data types பற்றி விளக்கங்கள்Navigation shortcuts, search bar, name box, formula bar அறிமுகம்Tabs, groups, sliders, zoom, Quick Access Toolbar பற்றி விளக்கம்Cell Values மற்றும் Data கையாளுதல்:Copy, cut, drag மற்றும் Fill Handle ஐ சரியாக பயன்படுத்துதல்Insert/delete rows & columns, hide/unhide sheetsBasic formulas மற்றும் smart data entry தொழில்நுட்பங்கள் கற்றுக்கொள்வதுகணித மற்றும் புள்ளியியல் Functions:SUM, MIN, MAX, AVERAGE, RANK, ROUND, ROUNDUP, ROUNDDOWNSUMPRODUCT, MOD, QUOTIENT, FILTER, SUBTOTAL, SPARKLINESAbsolute vs. Relative cell references மற்றும் Conditional FormattingText Functions:RIGHT, LEFT, MID, LEN, CONCAT, TEXTJOIN, TRIM, SUBSTITUTE, FIND, SEARCHFlash Fill, Text-to-Column, REPT, TEXT, CHOOSE, UPPER, LOWER, PROPERDate & Time Functions:Excel இன் date & time system பற்றி விளக்கம்DATE, TIME, DAY, MONTH, YEAR, NETWORKDAYS, WEEKNUM, WORKDAY, EOMONTHநிதி மற்றும் பிற Functions:Loan calculations: PV, FV, NPV, IRR, RATEData validation, RAND, RANDBETWEEN, UNIQUE, SORT, ISNUMBER, ISEVEN, ERROR.TYPE<

SAP ECC EHP7 IDES Installation + 30 Days of Access
Udemy
SAP Basis

SAP ECC EHP7 IDES Installation + 30 Days of Access

For your free 30 days access please send us a message and we will send you your access !! This tutorial is designed to guide you through all the steps necessary to complete the installation of SAP GUI (most current version). At the end of this tutorial you will have your own study environment and will be able to train for 365 days with real access on an SAP server.Do not waste time and start building your own training environment right now.Our videos not only give you an overview of how SAP works, but is delivered in such a way that anyone who engages in it will have no problem understanding all the topics presented.Our classes make it easy to learn SAP, you will be executing transactions and analysing data faster than you think.In order not to tire you with a lot of theory, this course focuses on teaching from practical examples, putting your hand in the dough. It is full of step-by-step activities, ensuring that you are able to use SAP from day one!Learn more about the latest innovations through ramification and connections with other SAP students and experts with Open and Massive Online Courses delivered here on Youtube. Designed for SAP professionals, developers, consultants, entrepreneurs, teachers and students, these free classes provide the flexibility to learn when, where and how you want.ThanksiTD Training

Windows 10 Crash Course: Beginner to Advanced
Udemy
Windows 10

Windows 10 Crash Course: Beginner to Advanced

Windows 10 is the new innovative operating system from Microsoft that you have been waiting for! Microsoft has learned a lot since releasing Windows 8 and introduced all the features that we wanted. Get to know the new interface, start menu, browser, a unique personal assistant Cortana and a brand new browser - Microsoft Edge. Master all new Windows 10 features today! Get a free upgrade to Windows 10.This course is based on the final version of Windows 10 (not beta, preview etc.) and includes real world examples and tests of Windows 10 features and apps!Why Upgrade?It is FREE! Yes, no strings attached! You can get a full version of Windows 10 as an upgrade from Windows 7 and 8.1. You will love Windows 10 - it is faster, better and more polished.What will I learn?Learn how to install Windows 10Upgrade from Windows 7 and 8Understand Windows 10 EditionsMaster The New Awesome InterfaceTweak The Start MenuAdd Cool Apps Using Windows StoreCustomize Windows 10 SettingsLearn About Security FeaturesMeet The New Personal Assistant CortanaStart Using MS Edge - The Next Generation for IEMake Back-ups And Recover Windows 10Tips And TricksContents and Overview In over 5 hours of content including more than 50 lectures this course covers basic and advanced features of Microsoft Windows 10.We start from scratch discussing all installation and upgrade options, the new interface and start menu, user accounts, computer settings and network features.Learn the brand new Windows 10 today! Join now.