UdemyMicrosoft Excel

External Data and Workbook Tools: Learn Excel 365

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

External Data and Workbook Tools: Learn Excel 365

عن هذا الكورس

This course includes downloadable course instructor and exercise files to work with and follow.External Data and Workbook Tools: Learn Excel 365 equips you with the skills to manage data efficiently across multiple worksheets, workbooks, and external sources. You will learn to link and synchronize data to stay accurate, dynamic, and consistent without repetitive manual updates.You’ll start by setting up your Excel environment for maximum productivity, including customizing the Ribbon with tabs and groups tailored to your workflow. You will practice creating links between cells in the same workbook, across different workbooks, and to external sources such as other Excel files, Access databases, and web data.The course also covers importing data using Power Query, cleaning and transforming it, and establishing live connections for real-time updates. You will explore tools like the Watch Window, which lets you monitor key data points in large datasets without endless scrolling, and learn strategies to ensure your connections remain secure and dependable.You will also work with Excel tables to improve organization, formatting, and analysis. This includes applying structured references for efficient formulas, using filters and slicers for interactive insights, and creating custom table styles to match your needs.By the end, you’ll be able to manage complex datasets with more speed, accuracy, and flexibility. These skills will save you time, reduce errors, and help you make confident decisions based on up-to-date information in Excel 365.This course includes:54 minutes of video tutorials11 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion

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

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

محتوى معتمد

مقدم من منصة Udemy

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

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

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

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

عرض كل الكورسات ←
PowerPoint 2016: PowerPoint Presentation Mastery
Udemy
PowerPoint

PowerPoint 2016: PowerPoint Presentation Mastery

Discover the power of PowerPoint through this course. Whether you're an avid user or just starting out with PowerPoint, this course is designed for administrators, clerks, executives, managers, students of all levels; who wants to further enhance their practical use and knowledge of PowerPoint. Welcome to PowerPoint 2016: PowerPoint Presentation Mastery! PowerPoint is a presentation program developed by Microsoft. It is widely used in business presentations and academic presentations, even in classes such as this. This program helps users communicate their ideas in a visual and creative way. As there are other presentation programs available, PowerPoint is the most popular and powerful presentation program available. Create Awesome and Eye-Catching presentations through PowerPoint? We'll walk through the basics of PowerPoint at the beginning of the course. After that, we'll walk through the advanced level of PowerPoint. That way, the course is useful for users at any level. Each lecture is filled to the best of my experience. As PowerPoint may be upgraded from time to time, the version I'm using is 2016. However, the layout of other versions may differ but it could be minimal. At the end of this PowerPoint course, here's what you can expect: A working knowledge of PowerPoint basic toolsConfidence to use PowerPointAbility to create presentations from scratchKnow-how of using PowerPoint drawing tools and table toolsBe the go-to person in your group for PowerPointThere's always something new to discover Complete the course and I'd appreciate if you could leave a positive feedback. If you have find this course useful, do recommend to your friends who will find this beneficial. Thank you for taking this course and I'll see you inside the course!

SAP Data Migration ( SAP ECC / S4 HANA Data Migration) | ETL
Udemy
SAP S/4HANA

SAP Data Migration ( SAP ECC / S4 HANA Data Migration) | ETL

This course covers End-to-End Data Migration processes, right from Data Mapping Sheet, Extraction, Transformation, Validations, Preload, Load and Building of Post Loads reports.In terms of Data Loading techniques, LSMW, BAPI, IDOC and LTMCs are covered right from Basic to Advance level. below are the list of Course Contents taught in this course. will keep on adding any additional topics which feels necessary to upskill in this course. 1. Course Introduction2. Data Migration Overview3. Extraction - Using Data Mapping Sheet ( Data Extracted from SAP System )4. Transformation - Using Data Mapping Sheet5. Validation - Mandatory Check6. Validation - Lookup Check7. Validation Job - Format Check8. Build Preload Report9. Data Loading Method - LSMW Batch Input ( Until Recording ) - Part I10. Data Loading Method - LSMW from 2nd step till Upload11. Build Post Load Report12. Build Preload Report - Source and Transformed side by side - Best Practice13. IDOC Overview14. How to find IDOC Type and related Message Types15. How to Create RFC Connection and Port for IDOC Processing16. How to Create Partner Profile and Find Process Code17. IDOC Loading Part I17a. IDOC Loading Part II18. IDOC Loading - PO Header with Multiple Items19. Process to Find BAPI for any Data Load Object20. How to Test BAPI in Transaction SE3721. BAPI Loading - PO Header with Multiple Items22. Direct Input Method RMDATIND ( Material Master Creation ( basic and MRP Views ))23. Direct Input Method Logs saving process - BMV024. How to write ABAP Code in LSMW ( SKIP RECORDS )25. LSMW Debug26. Long Text Upload ( LSMW )27. Using Multiple Recordings in a same LSMW ( Create , Update )28. Download Logs from Direct Input and Session Method30. IDOC Error Log Preparations (ARCKEY)31. How to Edit and Reprocess IDOC32. Table

Learn Microsoft Word from scratch  for Beginners + AI
Udemy
Microsoft Word

Learn Microsoft Word from scratch for Beginners + AI

Learn Microsoft Word from Scratch for Beginners + AIUnlock the power of Microsoft Word and discover how to create professional documents with confidence—even if you've never opened Word before. This comprehensive Microsoft Word for Beginners course is designed to take you from complete beginner to a confident user while showing you how to use AI tools to work faster, write better, and boost your productivity.Throughout this course, you'll learn the fundamentals of Microsoft Word, including navigating the interface, formatting text, creating beautiful documents, working with tables, inserting images, using templates, designing professional reports, and preparing documents for printing and sharing. You'll also discover modern AI techniques that can help you generate content, improve grammar, rewrite text, summarize documents, and save hours of manual work.Whether you're a student, job seeker, teacher, entrepreneur, office worker, freelancer, or business owner, this course provides practical, real-world skills you can use immediately. You'll build professional letters, resumes, CVs, reports, proposals, invoices, newsletters, flyers, meeting notes, and other business documents from scratch.By the end of this course, you'll confidently use Microsoft Word for personal, academic, and professional projects. You'll understand document formatting, page layout, headers and footers, tables, SmartArt, images, styles, mail merge, collaboration features, document protection, printing, PDF conversion, and many productivity shortcuts that experienced users rely on every day.No prior experience is required. Simply bring your curiosity and a computer with Microsoft Word installed. Every lesson is explained step by step, making it easy to follow regardless of your skill level.Enroll today and master Microsoft Word while learning how to leverage AI to create smarter, faster, and more professional documents that stand out.

Get Polished in PowerPoint
Udemy
PowerPoint

Get Polished in PowerPoint

When you write PowerPoint presentations, do you Pretend it's a Word document in landscape? Stick objects on a page until the white space is filled up? Write a bunch of slides, then think about how they go together?It's easy to get the basics in PowerPoint but hard to write compelling stories that your audience will find memorable and meaningful. Don't let insights you've discovered get lost in a maze of mediocre slides. In this 90-minute primer you'll go from slide monkey to slide master. We'll take an accelerated 'learn-by-doing' approach: picking up where we left off in Use Excel Like a Pro. Fast., we'll design a PowerPoint template, write a storyboard and craft a polished presentation. Along the way, we'll unpack the principles of great slide writing and cover time-saving shortcuts. What makes this course different?It's practical. The instructor worked in management consulting at BCG for eight years. That's a lot of real-world experience to share, and this courses focuses only on the most important practices.It's fast; only 90 minutes. You'll have what you need in no time.It uses the case-method pedagogy. By teaching in the context of an example, retention is far higher than a traditional approach, and way more fun.

SAP S/4HANA Sales (SD - Sales and Distribution)
Udemy
SAP S/4HANA

SAP S/4HANA Sales (SD - Sales and Distribution)

The course will prepare the students to learn and understand all the necessary end-to-end implementation steps to configure SAP S/4HANA Sales 2021, previously known as SAP SD (Sales and Distribution), along with End-User activities for any organization.After this course, the students will be able to identify and analyze the business requirements for any organization related to the Order to Cash process cycle and to configure SAP S4 HANA Sales accordingly.After taking this course, the Learners will be able to work both as a Consultant and End-User and can also take SAP S/4HANA Sales certification exam i.e., C_TS462_2023.Most of the lectures under each Section can easily be identified for 'Configuration' and 'End-User' activities, so if you are interested in the ‘End-User’ training only, then you can filter those lectures easily.Here are the highlights of the course:- Section 1 is about the SAP S/4HANA Business Suite and its HANA database capabilities including SAP Fiori as New User Interface- Section 2 demonstrates Business Requirements, SAP Activate Methodology, and kicks-off the configuration from the Enterprise Structure on SAP S/4HANA Business Suite- Section 4 makes this course unique by demonstrating the configuration of SAP S/4HANA Finance and Controlling module that is required to work on SAP S/4HANA Sales module and you will not easily find this information in most of the other training courses- Section 6 demonstrates the configuration and creation of Business Partner master data including Customer and Vendor master data- Section 7 demonstrates the configuration for Material master data and then shows how to create a Material master- Section 8 demonstrates the Material classification and Batch Management

AI Prompt Engineering Masterclass: ChatGPT, Claude & Gemini
Udemy
Prompt Engineering

AI Prompt Engineering Masterclass: ChatGPT, Claude & Gemini

Welcome to one of the most practical and powerful courses on AI Prompt Engineering. You’ll learn how to write expert-level prompts for ChatGPT, Claude, Gemini, and Grok, and unlock the full potential of AI across your personal, professional, and creative tasks.This course is designed for developers, marketers, writers, teachers, HR professionals, business owners, students, and content creators. Whether you're just getting started with AI or want to sharpen your skills, you’ll discover exactly how to communicate effectively with today’s leading AI tools and generate high-quality, accurate, and creative results.What you’ll learn:How to write effective prompts that produce useful, smart responsesHow to tailor prompts for real-world roles like software development, marketing, sales, HR, and real estateHow to control tone, style, and format to match your goals and audienceHow to compare outputs from ChatGPT, Claude, Gemini, and Grok and choose the right tool for the taskHow to refine poor AI responses and guide the output more preciselyHow to use AI in daily life for productivity, travel planning, communication, and idea generationWhat’s included:20+ video lessons with hands-on examplesDownloadable prompt templates organized by job roleInteractive exercises, quizzes, and a capstone projectLifetime access to all course materialsBy the end of the course, you’ll be confidently using AI to save time, improve your workflow, and stand out with powerful, well-crafted prompts. Learn how to make AI work smarter for you—across any platform, project, or profession.