UdemyMicrosoft Excel

Flowcharting in Microsoft Excel

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

Flowcharting in Microsoft Excel

عن هذا الكورس

There are many courses on how to use Excel. In contrast the instructor focuses on workbook design so that workbooks are:Easy to understand for both the developer and the user.Error-freeAutomatedThis logical and structured approach is called ‘Excel Engineering’. The first step in the Excel Engineering approach is to create a flowchart (or flowsheet).Flowcharts are commonly used in process modelling, engineering, simulation and software development. All well-designed Excel workbooks will have flowcharts visualising dataflow.Once an effective flowchart is created, both the user and developer gain clarity in understanding the dataflow within a workbook. The course introduces concepts such as hyperlinking to and from the flowchart to the Excel data (enabling easy navigation, and eliminating the need for provided Excel functionality such as trace precedents and dependents).The course also confronts some of the limitations of flowcharting in front-end Excel and provides ways to increase the Excel functionality of Excel Flowcharting by providing VBA add-ins that are freely available to course participants.The course is divided into 5 sections: Introduction ( a general explanation about flowcharting and relevant flowcharting concepts)Hands-on flowcharting in Excel (focus on shape and connectors, and putting these into a canvas)Creating a flowchart of a workbook ( a simple example of how to create a flowchart for a defined workbook)Using flowcharts software provided by instructor (Excel flowchart capability is limited so add-ins provided by the instructor are provided to enhance flowchart capability, A fundamental add-in is that which automates hyperlinking to and from the flowchart and the workbook data rendering navigation much easier).This sec

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

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

محتوى معتمد

مقدم من منصة Udemy

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

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

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

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

عرض كل الكورسات ←
Stress Management at Work: Simple Ayurveda for Energy
Udemy
Personal Productivity

Stress Management at Work: Simple Ayurveda for Energy

This course contains the use of Artificial Intelligence.Stress and burnout don’t usually happen all at once. They build gradually through disrupted routines, energy crashes, reduced focus, and difficulty recovering after work. Many professionals are taught to manage time, but not how to manage energy, stress load, and recovery in a sustainable way.This course teaches a practical, business-safe system for managing stress, protecting focus, and preventing burnout, using simple routines, food timing, and seasonal awareness. The framework is inspired by Ayurvedic principles but presented in modern, non-medical, non-spiritual language appropriate for the workplace.Instead of offering generic self-care advice, this course helps you understand how your energy behaves under stress, recognize early burnout signals, and make small, realistic adjustments that support performance over time.You will learn how stress affects focus, mood, digestion, and decision-making, why one-size-fits-all productivity advice often fails, and how to build a personal self-care system that adapts as workload and seasons change.This course is designed for working adults who want to stay effective without pushing themselves into exhaustion.What You’ll LearnHow stress disrupts focus, energy, and decision-making at workHow to recognize early signs of burnout before performance declinesHow different energy patterns respond to stress, routine, and food timingHow digestion and meal timing influence mental clarity and emotional stabilityHow to build simple daily routines that reduce cognitive loadHow to prevent burnout by adjusting pace and expectations seasonallyHow to create a personalized self-care system you can reuse long-termWhy This Course Is Different

Advanced DAX for Excel Power Pivot
Udemy
Data Analysis Expressions (DAX)

Advanced DAX for Excel Power Pivot

You know enough DAX to get by. This course takes you past that.If you've finished a beginner Power BI or Excel Power Pivot course and your measures still behave in ways you can't fully explain, this is where you go next. No more guessing. No more copying formulas and hoping they work. You'll finally understand the logic behind DAX, not just the syntax.This course is built for business analysts and Excel power users, not IT developers. Every concept is explained visually, step by step, using real data and practical examples you can apply at work immediately.What you'll be able to do after this course:Explain and control filter context and row context with full confidenceWrite CALCULATE formulas that do exactly what you intend, using ALL, ALLEXCEPT, ALLSELECTED, and KEEPFILTERS correctlyKnow when to use SUMX vs SUM, and why getting this wrong silently breaks your resultsUnderstand context transition well enough to debug any measure or calculated column returning unexpected valuesBuild advanced calculations: dynamic rankings with RANKX, TOPN analysis, disconnected slicers, and running customer countsUse variables to write cleaner, faster, easier-to-read DAXUse DAX Studio to visualize intermediate results and debug formulas step by stepOptimize your data model with smart decisions about cardinality and data compressionWhy this course explains things differently:Most DAX courses describe what a function does. This one shows you what is happening inside the engine at each step. Filter context and row context are explained visually so the logic becomes intuitive, not memorized. You'll see exactly how CALCULATE processes its filters before evaluating your expression. Understanding it this way means you can write measures from scratch, not just adapt examples you f

The Complete Excel Pivot Table: Data Analysis and Reporting
Udemy
Microsoft Excel

The Complete Excel Pivot Table: Data Analysis and Reporting

Pivot Tables are one of the most powerful tools in Microsoft Excel for analyzing, summarizing, and reporting data. Yet many professionals only use a fraction of their potential. This course is designed to give you a complete, hands on mastery of Pivot Tables, helping you transform raw data into clear, actionable insights.Whether you’re a beginner just learning Excel or an experienced user looking to sharpen your data analysis skills, this course will guide you step by step through building dynamic Pivot Tables and professional reports used in business, finance, marketing, and beyond.What You Will Learn:What is Data Analysis?Overview of Excel as a Data Analysis ToolKey Excel Features for AnalystsWhat Is a Pivot Table and Why Use It?Creating Your First Pivot Table (Step-by-Step)Understanding Pivot Table Interface: Rows, Columns, Values, FiltersBest Practices for Structuring Raw DataCleaning Data Using Excel ToolsRemoving Duplicates and Handling BlanksUsing Tables as Dynamic Pivot Data SourcesFormatting Data for AnalysisSorting and Filtering Pivot DataGrouping Data by Dates, Numbers, or TextValue Summarization: Sum, Count, Average, etc.Using the Field List and Pivot Table SettingsAdding and Using Calculated FieldsCreating Custom Calculations with % of Total, Difference, Running TotalUsing Show Values As for Advanced ComparisonsManaging Grand Totals and SubtotalsIntroduction to Pivot ChartsCreating Interactive Dashboards with Slicers and TimelinesLinking Pivot Tables to ChartsFormatting and Customizing Charts for ReportsUsing Multiple Pivot Tables from the Same Data Source<

Learning PL/SQL -  Truly Basic to Advanced The Example Way
Udemy
PL/SQL

Learning PL/SQL - Truly Basic to Advanced The Example Way

*****************************************************************************Added lecture PL/SQL Object Table Row Object *** Section - Object Oriented PLSQL (09 Jan 2020)*****************************************************************************After a successful study in SQL, now you need to know the PL/SQL thoroughly to make make you a genuine back end programmer. Even if you are an acclaimed front-end programmer, with the study of SQL coupled with PL/SQL through this course you will become virtually invincible in the field as database analyst/programmer, DBA and trainer.If you have already wasted your time and money in hunting for a complete yet concise course in PL/SQL through random youtube videos mostly offered by inexperienced people and not certified for their authenticity and quality - then you are at the right place here. This course brings step-by-step lessons in its logical series of videos to help you master the programming in PL/SQL. Moreover this same channel brings to you a complete course in SQL to make a one stop shop for all your database side learning.This course has been brought by an highly experienced faculty who have had 20+ years of experience in working as Oracle developer and DBA out of which 6 years onside in USA and UK. The faculty has been working in Oracle field ranging from Oracle version 6 to the latest 19C. Who this course is for?Students seeking database side prestigious career as Programmer AnalystWorking professionals who are next targeting to become a DBA must know the SQL PL/SQL thoroughlyAll UG students from Engineering, Science and Commerce streams stepping into the field of Information TechnologyProject analysts, analysts and designersAll those who have studied SQL must learn PL/SQL to make the circle complete

Google NotebookLM Complete Course: Visual AI Mastery
Udemy
Google NotebookLM

Google NotebookLM Complete Course: Visual AI Mastery

Welcome to Google NotebookLM Complete Course: Visual AI Mastery — a practical, beginner-friendly course that teaches you how to use Google NotebookLM to turn complex information into clear, useful, and visual knowledge.In this course, you will learn how to use NotebookLM with PDFs, websites, YouTube videos, reports, research papers, notes, and business documents. You will discover how to summarize long content, ask better questions, extract key ideas, organize notes, create study guides, generate quizzes, and build visual learning materials.The main focus of this course is visual AI generation. You will learn how to use NotebookLM to create infographic-ready content, diagram structures, mind maps, slide outlines, research summaries, business briefings, and training materials. You will also learn how to improve your prompts so your outputs become clearer, more professional, and easier to use.This course is designed for beginners, students, teachers, trainers, course creators, business analysts, consultants, researchers, and professionals who work with documents and information every day. You do not need programming, design, or technical experience. Everything is explained step by step in a simple and practical way.By the end of the course, you will be able to build a complete visual knowledge workflow: upload sources, ask smart questions, create summaries, generate diagrams, prepare infographics, design slide outlines, and review AI outputs for accuracy and clarity.If you want to save time, understand information faster, and create beautiful visual knowledge assets using AI, this course is for you

Get Motivated to Reach Your Goals
Udemy
Motivation

Get Motivated to Reach Your Goals

Motivation is a pivotal force in driving us toward our objectives, providing the essential energy and determination needed to navigate the path to success. It fuels our daily actions, helping us persevere through challenges and maintain focus on our goals. Without motivation, the journey toward achieving our dreams can feel overwhelming and unattainable. This course is meticulously designed to help you tap into and sustain this vital inner drive. It explores various methods to ignite and maintain motivation, ensuring that you can stay committed and resilient as you pursue your goals. By engaging with this course, you will develop a deeper understanding of how to set realistic and achievable goals, stay motivated despite setbacks, and ultimately turn your aspirations into tangible achievements.Throughout this comprehensive course, you will be introduced to foundational and advanced theories of motivation. You'll delve into the intricacies of how different personality types influence motivation and how this understanding can help you tailor your approach to achieving success. The course covers a range of motivational theories, offering practical strategies to address and overcome common motivational blocks. Key areas of focus include the principles of Motivation Theory, effective techniques for overcoming obstacles that hinder motivation, and the benefits of cultivating a positive mindset. You'll also learn how to create and implement a system for setting and achieving your goals, ensuring that you can navigate the journey with confidence and clarity.This course is designed to cater to a diverse audience, making it ideal for anyone eager to enhance their motivation and achieve their goals. Whether you are a professional seeking to advance your career, a student aiming for academic excellence, an entrepreneur looking to grow your business, or an individual interested in personal development, this course offers valuable insights and actionable strategies. It is especially beneficial for those who fee