Fast-track to Google Sheets Mastery Weekend Crash Course
التصنيف الكامل: Office Productivity > Google > Google Sheets

عن هذا الكورس
تعلم أونلاين 100%
شاهد الدروس في أي وقت ومن أي مكان
محتوى معتمد
مقدم من منصة Udemy
رابط موثوق
ينقلك مباشرة لصفحة التسجيل الرسمية
كورسات مقترحة في نفس المجال
عرض كل الكورسات ←
Mastering Primavera P6: A Comprehensive Tutorial
Welcome to "Mastering Primavera P6: A Comprehensive Tutorial" - the ultimate course on mastering the world's leading project management software, Primavera P6. This course is designed to take you from a beginner to an expert level in Primavera P6, regardless of your level of expertise. It also includes a Bonus Course on use of MS Project.Throughout this course, you will learn how to use Primavera P6 to effectively plan, manage, and control projects. We will start by introducing you to the basics of project management, including project planning, scheduling, and control. You will then learn how to create a new project in Primavera P6, define project calendars, and establish project baselines.We will then dive into the essential features of Primavera P6, including creating a work breakdown structure (WBS), adding activities and resources, creating relationships between activities, and performing schedule analysis using critical path method (CPM).We will also cover advanced topics in Primavera P6, such as using earned value analysis (EVA) to measure project performance, resource leveling, and performing risk analysis.In addition, this course will also teach you how to customize Primavera P6, create custom reports, and integrate it with other software tools.By the end of this course, you will have the knowledge and skills necessary to use Primavera P6 to manage projects of any size or complexity. You will be able to develop and manage project schedules, track project progress, and identify potential problems before they become major issues.Don't miss this opportunity to take your project management skills to the next level. Enroll now and join our community of successful project managers who have mastered Primavera P6!Introduction to project management and Primavera P6Understanding of Primavera Interface Creating a new project in Primavera P6Defining project calendars and establishing project ba

Build Your Own AI Secretary with Google Sheets & Apps Script
Why this course?Monitoring routine productivity data, project progress and task status requires us to stay on top of critical Key Performance Indicators (KPI's) of various kinds. This can get complicated if many things are moving at parallel, and sometimes all we want is to have someone to summarize the important information and update us verbally. It is even better if a simple analysis can be done to highlight any anomalies, and present the information in a "standard" format consistently, so that we are able to grasp the key data easily. Who would need this?This is especially true (but not limited to) for business owners, project managers and team leaders who are generally busy with a wide range of responsibilities and are using Google Sheets to keep track of stuff. We all can do with an "AI secretary" that can keep us updated routinely on-the-go.Why now? The recent advancements in AI means now we all have the tools to create any type of custom AI solutions, including for the "problem" above. Google is especially great in this aspect, since it has some of the most advanced and cost efficient AI models, along with an entire tech stack that can be easily plugged into existing apps such as Sheets, Gmail, Docs, etc. Their newer AI models (such as Gemini 2.5 Pro) are extremely good in coding, which has further opened up possibilities to integrate AI automation into existing workflows via tools like Apps Script, which was previously a domain reserved for the IT savvy individuals. Google has empowered everyone to be a citizen developer now, enabling us to built custom solutions for our business and personal use. What is this course about?This short crash course illustrates the above point as easily and practically as possible. This course is about creating an "AI Secretary" that does the following:Look at a set of pre-determined KPI data in Google

Microsoft Excel 365 Master Class : Beginner to Advanced
Microsoft Excel 365 Full Basic to Advanced level PackageMaster Microsoft Excel 365 from Beginner to Advanced LevelBuild a solid understanding on the Basics of Microsoft ExcelLearn the most common Excel functions used in the OfficeLearn Microsoft Excel automation to increase efficiency in your day to day taskslearn tips and tricks how to maintain large sets of Excel data in a list or tableCreate dynamic reports by mastering one of the most popular tools, PivotTablesTake control by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions.Set up base for career advancement with MS-EXCEL 365This course is broken down into 17 Sections:Each Section takes you step by step through Excel so that even if you are beginning or are intermediate level user, your foundation is built up thoroughly, so that you can understand complex functions and get creative with complexity as offered by this course.I have added practical uses in lectures, which are driven by real life scenarios and things used in corporate level whether you are in Finance, HR, Marketing and Sales, or Admin. Enroll and take a deep dive of the most popular worldwide spreadsheet tool, Microsoft Excel. As a Microsoft Corporate Expert I will use my 10+ years of Excel use to guide you step by step through the beginner to advanced level and beyond.You will start at the very basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.At completion of this course you will have mastered the most popular Excel tools and have the confidence to complete any Excel tasks with efficiency and grace. See below a glimpse into what you will be learning:Creating effective spreadsheetsManaging large sets of dataMastering the

Mastering Microsoft OneNote 2016 Made Easy Training Tutorial
Learn Microsoft OneNote 2016 with this comprehensive course from TeachUcomp, Inc. Mastering OneNote Made Easy features 67 video lessons of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our printable classroom instruction manual, additional images and practice exercises. You will learn all about creating and formatting notes, organizing information, researching with OneNote, sharing and collaborating on notebooks and much more.Our courses were developed from our original classroom trainings. This helped to develop the curriculum of course topics we present that address the student’s real-world concerns and usage.Our course design helps maximize the learning retention of our self-study courses. Each course contains different learning modalities that help reinforce the topics. We initially present each topic’s information in a course manual in a written, conversational style to provide a conceptual overview. These overviews are followed by instructions, showing the specific actions required to perform the tasks related to the topic. These topic actions are then combined with each other into exercises at the end of each chapter to show their interconnected relationships.Each course topic is also enhanced with an audio-visual lesson in the form of a video. The video lesson shows how to perform the topic’s actions as the instructor simultaneously narrates the topic’s overview.Whether you are completely new to OneNote or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your persona

الدورة الشاملة لمايكروسوفت اكسل من المستوي المبتديء للمحترف
دورة Microsoft اكسل الشاملة وهي كورس تعليمي شامل في العالم العربي من حيث طريقة التعليم وتبسيطها ---------------------------------------------------------------- المستوي الأول: المستوي المبتديء اكسل 101هو المستوي الاساسي للمبتدئيين لفهم كل اساسيات ميكروسوفت اكسل وسنتعلم من خلاله:- أساسيات البرنامج من فتح وشرح واجهة واغلاق الملف وفهم المصنف وتخصيص الادوات- التعامل مع النصوص والارقام والصيغ المختلفة وتحريرها وتعديلها - انشاء بعض الدوال الاساسية في الاكسل وفهم طريقة كتابة الدوال- العمل مع ورقة العمل ككل والتعديل علي الصفوف والاعمدة من خلال اخفائها وحذفها- تنسيق البيانات في ورقة العمل من خلال استخدام الاساليب المختلفة والمتنوعة للتنسيق في الاكسل- التعامل مع الصور والاشكال واداراجها وتنسيقها- انشاء المخططات العمودية والدائرية وتنسيقها والتعامل معها في الاكسل- فهم الطباعة في الاكسل والتحكم بالاوامر المختلفة للطباعة للمستوي المطور- التعامل علي قوالب الاكسل*********المستوي الثاني: المستوي المتقدم اكسل 102 مستوي المتقدم في الاكسل وهو المستوي الخاص بالقوائم والاوامر والادوات المتقدمة- التعامل مع القوائم في الاكسل وفهمها واهميتها وتميزها في الاكسل كبيانات- انشاء دوال القوائم وفهمها والفرق بينهم وبين الدوال العادية- التحقق من صحة البيانات في الاكسل والعمل- استيراد وتصدير البيانات أثاث من والي الاكسل - التعامل مع الجداول المحورية في الاكسل وفهمها واحترافها - احتراف العمل مع الباور بيفيت وفهمها والتعامل معها - التعامل مع مجموعة كبيرة من البيانات في الاكسل والقدرة علي تنظيمها في الاكسل *********المستوي الثالث: المستوي الاحترافي اكسل 103هو المستوي الذي يؤهلنا الي الاحتراف في الاكسل- احتراف الدالات الشرطية في الاكسل والتعامل معها وطريقة تركيبها وتعشيشها- احتراف دوال البحث في الاكسل- احتراف الدوال التي تعمل بالاستناد علي القيم النصية في الاكسل وطريقة دمجها- التدقيق في ورقة العمل واستخراج المعلومات المستهدفة بكل احترافية- حماية اوراق العمل ومصنفات الاكسل و

Mastering Microsoft Word: From Basics to Advanced Techniques
Welcome to "Mastering Microsoft Word: A Comprehensive Journey from Basics to Advanced Features," an in-depth online course meticulously designed to equip learners with the complete array of skills needed to harness the full potential of Microsoft Word. This course is perfect for anyone seeking to enhance their document creation and management capabilities, from absolute beginners with little to no prior experience to intermediate users wishing to expand their knowledge and even advanced users looking to refine their expertise.The primary goal of this course is to provide learners with a robust understanding of Microsoft Word, enabling them to create, edit, and manage documents with precision and efficiency. By the end of the course, participants will have mastered Word's essential tools and functionalities, from basic text formatting to leveraging advanced features like mail merge, templates, and collaboration tools. Our course aims to transform how you interact with Word, making you not only a proficient user but also an innovative creator capable of crafting complex documents with ease.Course Content and Structure:The course is structured into several comprehensive modules, each targeting specific aspects of Microsoft Word functionality. Let's dive deeper into what each module offers:Introduction to Microsoft Word:Understand the layout and design of the Word interface.Learn how to customize toolbars and settings to fit your workflow.Explore basic document creation steps and understand document extensions and compatibility.Basic Document Formatting:Dive into text formatting, including font styles, sizes, and colors.Learn about paragraph styles, alignment, and line spacing.Discover how to use bullets, numbering, and lists effectively.Intermediate Text Features and Image Man