• Regeln für den Video-Bereich:

    In den Börsenbereich gehören nur Angebote die bereits den Allgemeinen Regeln entsprechen.

    Einteilung

    - Folgende Formate gehören in die angegeben Bereiche:
    - Filme: Encodierte Filme von BluRay, DVD, R5, TV, Screener sowie Telesyncs im Format DivX, XviD und x264.
    - DVD: Filme im Format DVD5, DVD9 und HD2DVD.
    - HD: Encodierte Filme mit der Auflösung 720p oder darüber von BluRay, DVD, R5, TV, Screener sowie Telesyncs im Format x264.
    - 3D: Encodierte Filme von BluRay, die in einem 3D Format vorliegen. Dies gilt auch für Dokus, Animation usw.
    - Serien: Cartoon/Zeichentrick, Anime, Tutorials, Dokumentationen, Konzerte/Musik, Sonstiges sind demnach in die entsprechenden Bereiche einzuordnen, auch wenn sie beispielsweise im High Definition-Format oder als DVD5/DVD9/HD2DVD vorliegen. Ausnahme 3D.
    - Bereich Englisch: Englische Releases gehören immer in diesen Bereich.
    - Bereich Talk: Der Bereich, in dem über die Releases diskutiert werden kann, darf, soll und erwünscht ist.


    Angebot/Beitrag erstellen

    - Ein Beitrag darf erst dann erstellt werden, wenn der Upload bei mindestens einem OCH komplett ist. Platzhalter sind untersagt.
    - Bei einem Scenerelease hat der Threadtitel ausschließlich aus dem originalen, unveränderten Releasenamen zu bestehen. Es dürfen keine Veränderungen wie z.B. Sterne, kleine Buchstaben o.ä. vorgenommen werden. Ausnahme Serienbörse:
    - Bei einem Sammelthread für eine Staffel entfällt aus dem Releasename natürlich der Name der Folge. Beispiel: Die Simpsons S21 German DVDRip XviD - ITG
    - Dementsprechend sind also u.a. verboten: Erweiterungen wie "Tipp", "empfehlenswert", "only", "reup", usw. / jegliche andere Zusatzinformation oder Ergänzung, welche nicht in obiger Beschreibung zu finden ist.

    Aufbau des Angebots und Threadtitel

    Der Titel nach folgendem Muster erstellt zu werden. <Name> [3D] [Staffel] [German] <Jahr> <Tonspur> [DL] [Auflösung] <Quelle> <Codec> - <Group>
    Beispiel: The Dark Knight German 2008 AC3 DVDRip XviD - iND
    Beispiel: The Dark Knight 2008 DTS DL BDRip x264 - iND
    Beispiel: The Dark Knight 2008 AC3 DL BDRip XviD - iND
    Beispiel: The Dark Knight German 2008 AC3 720p BluRay x264 iND
    Beispiel: The Dark Knight 2008 DTS DL 1080p BluRay x264 iND
    Beispiel: Die Simpsons S01 German AC3 DVDRip XviD iND
    Beispiel: Die Simpsons S20 German AC3 720p BluRay x264 iND
    Beispiel: Sword Art Online II Ger Sub 2014 AAC 1080p WEBRip x264 - peppermint
    Entsprechend sind also u.a. verboten: Sonderzeichen wie Klammern, Sterne, Ausrufezeichen, Unterstriche, Anführungszeichen / Erweiterungen wie "Tipp", "empfehlenswert", "only", "reup", usw. / jegliche andere Zusatzinformation oder Ergänzung, welche nicht in obiger Beschreibung zu finden ist
    Ausnahmen hiervon können in den Bereichen geregelt sein.

    Die Beiträge sollen wie folgt aufgebaut werden:
    Überschrift entspricht dem Threadtitel
    Cover
    kurze Inhaltsbeschreibung
    Format, Größe, Dauer sind gut lesbar für Downloader außerhalb des Spoilers zu vermerken
    Nfo sind immer Anzugeben und selbige immer im Spoiler in Textform.
    Sind keine Nfo vorhanden z.B. Eigenpublikationen, sind im Spoiler folgende Dateiinformationen zusätzlich anzugeben :
    Quelle
    Video (Auflösung und Bitrate)
    Ton (Sprache, Format und Bitrate der einzelnen Spuren)
    Untertitel (sofern vorhanden)
    Hosterangabe in Textform außerhalb eines Spoiler mit allen enthaltenen Hostern.
    Bei SD kann auf diese zusätzlichen Dateiinformationen verzichtet werden.

    Alle benötigten Passwörter sind, sofern vorhanden, in Textform im Angebot anzugeben.
    Spoiler im Spoiler mit Kommentaren :"Schon Bedankt?" sind unerwünscht.


    Releases

    - Sind Retail-Release verfügbar, sind alle anderen Variationen untersagt. Ausnahmen: Alle deutschen Retail-Release sind CUT, in diesem Fall sind dubbed UNCUT-Release zulässig.
    - Im Serien-Bereich gilt speziell: Wenn ein Retail vor Abschluss einer laufenden Staffel erscheint, darf diese Staffel noch zu Ende gebracht werden.62
    - Gleiche Releases sind unbedingt zusammenzufassen. Das bedeutet, es ist zwingend erforderlich, vor dem Erstellen eines Themas per Suchfunktion zu überprüfen, ob bereits ein Beitrag mit demselben Release besteht. Ist dies der Fall, ist der bereits vorhandene Beitrag zu verwenden.
    - P2P und Scene Releases dürfen nicht verändert oder gar unter einem iND Tag eingestellt werden.


    Support, Diskussionen und Suche

    - Supportanfragen sind entweder per PN oder im Bereich Talk zu stellen.
    - Diskussionen und Bewertungen sind im Talk Bereich zu führen. Fragen an die Uploader haben ausschließlich via PN zu erfolgen, und sind in den Angeboten untersagt.
    - Anfragen zu Upload-Wünschen sind nur im Bereich Suche Video erlaubt. Antworten dürfen nur auf Angebote von MyBoerse.bz verlinkt werden.


    Verbote

    - Untersagt sind mehrere Formate in einem einzigen Angebotsthread, wie beispielsweise das gleichzeitige Anbieten von DivX/XviD, 720p und 1080p in einem Thread. Pro Format, Release und Auflösung ist ein eigener Thread zu eröffnen.
    - Grundsätzlich ebenso verboten sind Dupes. Uploader haben sich an geeigneter Stelle darüber zu informieren, ob es sich bei einem Release um ein Dupe handelt.
    - Gefakte, nur teilweise lauffähige oder unvollständige Angebote sind untersagt. Dies gilt auch für eigene Publikationen, die augenscheinlich nicht selbst von z.B. einer DVD gerippt wurden. Laufende Serien, bei denen noch nicht alle Folgen verfügbar sind, dürfen erstellt und regelmäßig geupdatet werden.
    - Untersagt sind Angebote, welche nur und ausschließlich in einer anderen Sprache als deutsch oder englisch vorliegen. Ausnahmen sind VORHER mit den Moderatoren zu klären.


    Verstoß gegen die Regeln

    - Angebote oder Beiträge, die gegen die Forenregeln verstoßen, sind über den "Melden"-Button im Beitrag zu melden.
  • Bitte registriere dich zunächst um Beiträge zu verfassen und externe Links aufzurufen.

*** Bestes IPTV *** bester Preis *** gratis Test ***



Englische Tutorials

1e05ec66bb92d4488005bf3dxx.jpg


Gaia - Beyond Belief - Season 5
Last updated 12/2022
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + Subs | Duration: 12 Lessons (7h 59m) | Size: 12.3 GB

Join George Noory, from Coast to Coast AM, each week, as we explore the amazing and unusual world we live in. Tap into the minds of experts in their field who work tirelessly to unravel the greatest mysteries. Join us for thought-provoking discussions on paranormal phenomena, conspiracies and all things unexplained.



beyondbeliefseason5hifil.jpg








 
1e05ec66bb92d4488005bf3dxx.jpg


Gaia - Beyond Belief - Season 1
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + Subs | Duration: 28 Lessons (27h 19m) | Size: 42.3 GB



Author: George Noory

Join George Noory, from Coast to Coast AM, each week, as we explore the amazing and unusual world we live in. Tap into the minds of experts in their field who work tirelessly to unravel the greatest mysteries. Join us for thought-provoking discussions on paranormal phenomena, conspiracies and all things unexplained.



beyondbeliefseason113dss.jpg




















 
1e05ec66bb92d4488005bf3dxx.jpg


Gaia - Beyond Belief - Season 4
Last updated 12/2022
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + Subs | Duration: 62 Lessons (33h 7m) | Size: 50.7 GB

Join George Noory, from Coast to Coast AM, each week, as we explore the amazing and unusual world we live in. Tap into the minds of experts in their field who work tirelessly to unravel the greatest mysteries. Join us for thought-provoking discussions on paranormal phenomena, conspiracies and all things unexplained.



beyondbeliefseason4g7cbw.jpg
























 
1e05ec66bb92d4488005bf3dxx.jpg


Gaia - Beyond Belief - Season 2
Last updated 12/2022
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + Subs | Duration: 28 Lessons (19h 48m) | Size: 30.6 GB



Author: George Noory

Join George Noory, from Coast to Coast AM, each week, as we explore the amazing and unusual world we live in. Tap into the minds of experts in their field who work tirelessly to unravel the greatest mysteries. Join us for thought-provoking discussions on paranormal phenomena, conspiracies and all things unexplained.



beyondbeliefseason2kqeoy.jpg
















 
1e05ec66bb92d4488005bf3dxx.jpg


Gaia - Beyond Belief - Season 3
Last updated 12/2022
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + Subs | Duration: 71 Lessons (35h 13m) | Size: 54.4 GB

Join George Noory, from Coast to Coast AM, each week, as we explore the amazing and unusual world we live in. Tap into the minds of experts in their field who work tirelessly to unravel the greatest mysteries. Join us for thought-provoking discussions on paranormal phenomena, conspiracies and all things unexplained.



beyondbeliefseason38teqd.jpg
























 
5021772ea8d2v9e0t.jpg


The School for Emotional Transformation - 1st weekend
Published 12/2022
Created by Shai Tubali
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 12 Lectures ( 11h 25m ) | Size: 14.7 GB



Introduction to Chakra Psychology



What you'll learn
What are emotions?
How can we overcome the gap between our intellectual understanding and the raw power of our primal emotions?
Why are emotions so challenging?
The seven layers of emotions according to Chakra Psychology

Requirements
No prerequisites are needed

Description
* This course includes the first weekend the 8 weekends of the School.1st Module: Introductory weekend + Introduction to Chakra PsychologyIn this introductory seminar we will start by exploring the journey ahead through thesyllabus and the school structure and processes of learning. We will also learn about thebasic principle of the TIP (= True Inner Power) Method and the unique nature oftransformational coaching. We will then approach the world of emotions as if for the firsttime, attempting to gain a penetrating insight into the very phenomenon of emotion. Hence,the first questions we should answer are: What are emotions? How can we overcome the gapbetween our intellectual understanding and the raw power of our primal emotions? And also,why are emotions so challenging? After exploring the role and meaning of emotions, andbased on this insight, we will study the most comprehensive mapping of the emotional world:the seven layers of emotions according to Chakra Psychology as well as their correspondingseven transformations - the seven forms of emotional transformation. We will apply theknowledge of Chakra Psychology through initial practices of Chakra reflection. Emotional maturity is a rare thing. Even if we understand a lot intellectually, our emotions and patterns and themes tend to remain stubbornly fixed.How can you finally let these confused emotions mature? How can you evolve them from unchanging patterns to light and spiritual strength? And how can we move from stuck emotions to a flow of creative action in life?If we can speak the language of emotions, we are able to whisper to them until they reveal their innermost spiritual energy

Who this course is for
Anyone who want to reach true emotional maturity



theschoolforemotionalc9dlx.jpg








 
n7qkt8jacwkuxy5k7fqsd6wiih.jpg


How To Raise Healthy Children.
Published 12/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 19.02 GB | Duration: 15h 11m

The popular app for mothers Social mom built this course with doctors and experts to help moms raise healthy children



What you'll learn
Parenting Children With Developmental Differences with expert David Loyst
How to manage screen time in your family With Dr. Vanessa Lapointe
The Do's and Don'ts of Teething With Dr. Calvin Tham
Sleep Challenges With Expert Agnes Meyer
Tempers and Tantrums With Dr. Deborah MacNamarah
Car Seat Safety With Expert Holly Choi
Motor Milestones (0-1 yrs) With Expert Kate Heays
Speech and Language Development (0-2 yrs) With Expert Chelsea Chichak
Parenting Your Anxious Child With Expert Sonja Latifpour
Baby-Led Weaning With Expert Katie Reitsma
Taking Care of Your Baby: Advice From Dr. Linda Jando
Resistance and Opposition with Expert Genevi ve Brabant
Breastfeeding with Expert Agnes Mayer
Conscious Parenting With Expert David Loyst
Treating stress and burnout using natural medicine with Dr. Kathleen Mahannah
Discipline with Dr. Vanessa Lapointe
Speech & Language Development (2-5 yrs) With Expert Chelsea Chichak
Children s Emotional Development with Dr. Deborah MacNamara
Taking Care of Your Toddler: Advice from Doctor Linda Jando
How to Take Care of Your Child s Teeth With Dr. Calvin Tham
Pelvic Floor Health with Expert Sheree Budgell
Motor Milestones (1-5 yrs) With Expert Kate Heays
Motherhood Anxiety with Expert Nasreen Gulamhusein
Injury Prevention for Infants and Toddlers with Holly Choi
Hormone imbalances in women with Dr Kathleen Mahannah
How to raise a human with Dr. Vanessa Lapointe
Practicing positive discipline without hurting the relationship with your child
The Recipe for a Healthy Couple

Requirements
No child required ?. We built this course so you can be benefit from our collective experience.

Description
The Mom Academy is a series of 27 videos with doctors and licensed experts to equip you with science-based knowledge to raise your children. Here's an overview of the courses: - Motherhood Anxiety with Expert Nasreen Gulamhusein- Children s Emotional Development with Dr. Deborah MacNamara- Conscious Parenting with Expert David Loyst- Practicing positive discipline without hurting the relationship with your child with expert Genevieve Brabant - Discipline with Dr. Vanessa Lapointe- How to raise a human with Dr. Vanessa Lapointe- Parenting Your Anxious Child with Expert Sonja Latifpour- How to manage screen time in your family with Dr. Vanessa Lapointe- Hormone imbalances in women with Dr Kathleen Mahannah- Treating stress and burnout using natural medicine with Dr. Kathleen Mahannah- The Recipe for a Healthy Couple with Audrey Poulin & David Proulx- Sleep Challenges with Expert Agnes Meyer- Pelvic Floor Health with expert Sheree Budgell- Injury Prevention for Infants and Toddlers with Holly Choi- Taking Care of Your Baby: Advice From Dr. Linda Jando- Breastfeeding with Expert Agnes Mayer- Car Seat Safety With Expert Holly Choi- Baby-Led Weaning With Expert Katie Reitsma- Motor Milestones (0-1 yrs) With Expert Kate Heays- The Do's and Don'ts of Teething With Dr. Calvin Tham- Speech and Language Development (0-2 yrs) With Expert Chelsea Chichak- Tempers and Tantrums With Dr. Deborah MacNamarah- Resistance and Opposition with Expert Genevi ve Brabant- Speech & Language Development (2-5 yrs) With Expert Chelsea Chichak- Taking Care of Your Toddler: Advice from Doctor Linda Jando- Motor Milestones (1-5 yrs) With Expert Kate Heays- How to Take Care of Your Child s Teeth With Dr. Calvin Tham

Overview
Section 1: Introduction

Lecture 1 Introduction: Presentation of the Social.mom Academy with founder Audrey Poulin

Section 2: All Ages

Lecture 2 Motherhood Anxiety with Expert Nasreen Gulamhusein

Lecture 3 Children s Emotional Development with Dr. Deborah MacNamara

Lecture 4 Conscious Parenting With Expert David Loyst

Lecture 5 Practicing positive discipline without hurting the relationship with your child

Lecture 0 Discipline with Dr. Vanessa Lapointe

Lecture 0 How to raise a human with Dr. Vanessa Lapointe

Lecture 0 Parenting Your Anxious Child With Expert Sonja Latifpour

Lecture 0 How to manage screen time in your family With Dr. Vanessa Lapointe

Lecture 0 Hormone imbalances in women with Dr Kathleen Mahannah

Lecture 0 Treating stress and burnout using natural medicine with Dr. Kathleen Mahannah

Lecture 0 The Recipe for a Healthy Couple

Lecture 0 Sleep Challenges With Expert Agnes Meyer

Lecture 0 Pelvic Floor Health with Expert Sheree Budgell

Lecture 0 Injury Prevention for Infants and Toddlers with Holly Choi

Lecture 0 Taking Care of Your Baby: Advice From Dr. Linda Jando

Lecture 0 Breastfeeding with Expert Agnes Mayer

Lecture 0 Car Seat Safety With Expert Holly Choi

Lecture 0 Baby-Led Weaning With Expert Katie Reitsma

Lecture 0 Motor Milestones (0-1 yrs) With Expert Kate Heays

Lecture 0 The Do's and Don'ts of Teething With Dr. Calvin Tham

Lecture 0 Speech and Language Development (0-2 yrs) With Expert Chelsea Chichak

Section 3: Todlers

Lecture 0 Tempers and Tantrums With Dr. Deborah MacNamarah

Lecture 0 Resistance and Opposition with Expert Genevi ve Brabant

Lecture 0 Speech & Language Development (2-5 yrs) With Expert Chelsea Chichak

Lecture 0 Taking Care of Your Toddler: Advice from Doctor Linda Jando

Lecture 6 Motor Milestones (1-5 yrs) With Expert Kate Heays

Lecture 0 How to Take Care of Your Child s Teeth With Dr. Calvin Tham

Parents,New Parents,Soon to Be Parents,Mothers,Fathers



howtoraisehealthychilqdi69.jpg










 
45436662f4a371f8d.jpg


Complete Excel Megacourse: Beginner to Expert
Last Update: 11/2022
Duration: 34h 25m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 17.5 GB
Genre: eLearning | Language: English

Learn how to use Microsoft Excel like a pro with this step-by-step course!



What you'll learn
How to use Microsoft Excel and its basic functions
How to create worksheets
Everything about using and formatting cells
How to use autofill
The principles and use of formulas
How to manipulate data through different functions
How to use and master Excel s most famous functions: AVERAGE, SUM, PRODUCT, COUNT, COUNTA, IF, COUNTIF
Simple graphs and charts
How to create a budgetary system
All the new functions in Excel 365


Requirements
No previous knowledge of Excel required
A desire to learn!
A positive attitude!


Description
Learn Microsoft Excel!
Have you ever wanted to be able to use Microsoft Excel - the largest spreadsheets program, like a pro? From managing your accounts to running your business finances, modelling chaos to simulating airports, recording your progress to planning your time; spreadsheets are an invaluable tool to learn and understand. Whether you re looking to record your home incomings and outgoings, or want to explore Excel for its mathematical opportunities, investigate the statistical tools, and its data analysis wizards, this course is for you.
In this course, you re going to learn everything you need to know to get started with Excel. You will explore what cells and worksheets are, how to enter formulae, manipulate data through functions and present the data in an effective fashion. You ll even learn how to use Excel to develop diverse and interesting solutions to problems, as well as learn the individual techniques and how to apply them to a solution.
Our instructor has many years of experience teaching Excel to a wide range of audiences - from very young children through to professionals, and the expertly-crafted syllabus is designed to be easy to follow and thorough. We ve also included plenty of practical examples explained and done on-screen for you to study. That s why this is the only Microsoft Excel course you ll ever need to master this software!
Start using Excel today!
After taking this course you ll be able to

Work professionally with Microsoft Excel and its advanced features
Solve real work problem with the help of Excel
Use the elements and theories in Excel to make your work processes better

Who this course is for
Anyone who wants to learn to use Microsoft Excel - no experience needed!
Professionals who want to learn new tools of Excel
Anyone who wants take their Excel skills from beginner to advanced
Anyone with specialised needs (data analysts, businessmen, students, researchers, etc.)


Homepage

completeexcelmegacour1nfma.jpg










 
1e05ec66bb92d4488005bf3dxx.jpg


Gaia - Beyond Belief - Season 7
Last updated 12/2022
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 21 Lessons (15h 38m) | Size: 24.3 GB

Join George Noory, from Coast to Coast AM, each week, as we explore the amazing and unusual world we live in. Tap into the minds of experts in their field who work tirelessly to unravel the greatest mysteries. Join us for thought-provoking discussions on paranormal phenomena, conspiracies and all things unexplained.



beyondbeliefseason7fxdv0.jpg












 
1e05ec66bb92d4488005bf3dxx.jpg


Gaia - Beyond Belief - Season 9
Last updated 12/2022
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + Subs | Duration: 24 Lessons (21h 39m) | Size: 33.4 GB

Join George Noory, from Coast to Coast AM, each week, as we explore the amazing and unusual world we live in. Tap into the minds of experts in their field who work tirelessly to unravel the greatest mysteries. Join us for thought-provoking discussions on paranormal phenomena, conspiracies and all things unexplained.



beyondbeliefseason9kmiti.jpg
















 
236268866cc2vaf2d.jpg


The Advanced Excel, Power Pivot & VBA Bundle
Last updated 12/2022
Created by Simon Sez IT
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 238 Lectures ( 31h 3m ) | Size: 15.4 GB



Learn Advanced Excel, Power Pivot, Power Query and VBA with this easy to follow video course



What you'll learn
Learn to unlock advanced Excel tools Power Query and Power Pivot
Averages, percentiles, and LINEST functions
Calculating depreciation and interest and other Financial & Statistical Functions
PivotTables and Pivot Charts, Sparklines and data bars
Importing data from other data sources
Advanced data analysis techniques including Power Query
How to automate tasks and operations that you perform frequently.
General syntax rules, what keywords are, and how to add comments.
What variables are, and how they relate to functions versus methods and subroutines.
How to specify different variables, including arrays, and how to manage them in code.
How to use intellitext with variables, particularly those that are defined constants.
What functions are, how they are used, and how to stage a scenario to complete.
How to define inputs for functions.
How to use input boxes and message boxes to interact with the user.
The intricacies surrounding creating an array formula.
How to use the application object to control the user experience.
How to use the name and names object to manage named ranges.
General information about the PivotTable object and basic approaches to utilizing it.
How to write and implement Excel events, to modify how Excel reacts to different user actions.
Discover how to modify a variety of standard behaviors, such as double clicking, opening files and saving files through VBA.
Learn how to design and implement specialized classes of objects.
Discover how to customize the right click menu within cell ranges.
Learn external libraries, and how you can extend VBA's capabilities beyond standard Excel options.
Learn about where VBA falls within the Excel file structure, and how different Excel file types use VBA differently.
How to modify the Excel user interface, including the "Ribbon" and context menus to interact with your VBA code.
Learn custom classes, including introducing you to blank custom classes, and how to use user form classes.
Analyze huge buckets of data to make informed business decisions
Become confident cleaning, sorting and linking data from various sources
Learn via expert instruction and exercises designed to have you performing complex analysis

Requirements
Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.
Intermediate knowledge of Microsoft Excel.
Beginner knowledge of Excel for VBA.
You'll need a copy of Microsoft Excel that is compatible with the Power Pivot tool.

Description
**This course includes practice exercises and LIFETIME access**Get beyond the basics and supercharge your current Excel skills.In this 4-course bundle, you get over 20 hours of expert-led video training on Advanced Excel, Power Pivot, Power Query and VBA. You ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information before looking at Visual Basic for Applications for Excel.Advanced Excel 2019 CourseWhat You'll LearnWhat's new/different in Excel 2016Advanced charting and graphing in ExcelHow to use detailed formatting toolsLookup and advanced lookup functionsFinancial functions including calculating interest and depreciationStatistical functionsConnecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.How to create awesome visualizations using sparklines and data barsMastery of PivotTables and Pivot ChartsScenario Manager, Goal Seek, and SolverAdvanced charts such as Surface, Radar, Bubble and Stock ChartsVBA for BeginnersWhat You'll LearnIntroduction to VBA as a language (syntax and keywords)How to automate repetitive tasksMacros, subroutines and logical constructsIntroduction to VBA functions including returning values from functionsWriting an array formulaKey Objects and error handling in VBAPivotTable and Chart ObjectsIntermediate VBAWhat You'll LearnDeeper dive into the VBA LanguageCore VBA module interactionsAdvanced parameter definitionsExcel events including pre-defined and event parametersCustom Objects including creating and defining a ClassCreating and designing a UserformModifying the Excel interface and UIExternal references and Office InterlopThe ADODB and Scripting LibrariesPower Pivot, Power Query & DAXWhat You'll LearnHow to get started with Power QueryHow to connect Excel to multiple workbooksHow to get data from the web and other sourcesHow to merge and append queries using Power QueryHow the Power Pivot window worksHow to set up and manage relationships in a data modelHow to create a PivotTable to display your data from the Power Pivot data modelHow to add calculated columns using DAXHow to use functions such as CALCULATE, DIVIDE, DATESYTD in DAXAll about creating Pivot Charts and PivotTables and using your data modelHow to use slicers to adjust the data you displayAdvanced PivotTables in ExcelWhat You'll LearnHow to do a PivotTable (a quick refresher)How to combine data from multiple worksheets for a PivotTableGrouping, ungrouping, and dealing with errorsHow to format a PivotTable, including adjusting stylesHow to use the Value Field SettingsAdvanced Sorting and Filtering in PivotTablesHow to use Slicers, Timelines on multiple tablesHow to create a Calculated FieldAll about GETPIVOTDATAHow to create a Pivot Chart and add sparklines and slicersHow to use 3D Maps from a PivotTableHow to update your data in a PivotTable and Pivot ChartAll about Conditional Formatting in a PivotTableHow to create amazing looking dashboards***Exercise and demo files included*** This bundle includes: 5 distinct courses in one!28+-hours of video tutorialsOver 200 individual video lectures Exercise files to practice what you learnedDemo files used by the trainerCertificate of completionThis course is designed for students that already have a good understanding of Microsoft Excel and are looking to take their capabilities to the next level. If you're already using Excel to a high standard and are looking to start using more complex functions and automate repetitive tasks, then this 3-course bundle is for you. These courses are packed with practical examples of how you'd apply these new skills in a business context.Here s what our students are saying So far, this class is great; it is exactly the speed I need. I like that I can pause the video and try something or go back and watch it again if I missed something. So much better than the 8-hour classes where the instructor breezes through everything in a whirlwind! - Christy Sobczak Very easy to follow and looking forward to learning more from the instructor. Very riveting. Looking forward to learning more. Thanks. I recommend this instructor. He is very knowledgeable. There's a lot of material and I'm learning a lot. I hope I can remember it all. - BobSantero"It's been an amazing experience! Worth to try it... There are so many things I didn't know about, and it's a good opportunity EXCELLENT WORK !!! HIGHLY RECOMMEND IT!!!"- Andriana

Who this course is for
Those wanting to automate Excel task or procedures.
Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.



theadvancedexcelpower9jfwa.jpg










 
zvxpoor7o88hqfukk94fqg2dt2.jpg


Attachment Theory & Repair
Published 12/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 13.57 GB | Duration: 15h 12m

The Path to Earned Secure Attachment: A Deep Dive into Healing our Childhood Conditioning



What you'll learn
Understand how childhood life experiences affect your present relationships and inner life.
Develop meditation skills to notice negative beliefs or habits and change them.
Change in meaningful and lasting ways in the areas of relationships, emotional regulation, and metacognition.
Learn to stay calm in stressful situations and feel confident.

Requirements
No previous knowledge of Attachment Theory or meditation is necessary.

Description
This course uses visualization practices that use "perfect nurturers" to reparent our inner child.The intended outcome is to get you doing the meditation practice to move you along the path towards earned secure attachment.This program is for people who have insecure attachment, in particular those who have tried other healing modalities, like psychotherapy and mindfulness meditation, with disappointing results.This program will cover:The basics of attachment theory.How it forms much of the developmental foundation for adult mental health.How attachment conditioning is made up of attachment schemas which together form an internal working model of attachment (Bowlby).We will re-pattern and work through these attachment schemas systematically.How insecure attachment usually implies deficits in mentalization capacities (metacognitive, perspective taking abilities).Which we start correcting in the guided meditation.How to heal our early attachment conditioning in order to have much improved well-being, better romantic and platonic relationships, and a stronger, healthy sense of self.Why Is Focusing On Attachment Repair Especially Relevant To People Who Have Struggled With Other Healing Modalities?Attachment conditioning sets the foundation for much of psychological development thereafter. The foundation, optimally, should be healthy before further work is fruitful.Attachment conditioning happens between 6 and 20 months of age: before there is much narrative or cognitive functioning.For this reason doing work at a later developmental level (cognitive/narrative approaches to healing (CBT etc.)) is not as effective without a solid base. Healing attachment conditioning should come first. Then other healing modalities (talk therapy, mindfulness, meditation, etc) can more easily have their desired effects when built on the foundation of secure attachment conditioning.In order to fix attachment conditioning we must have lived, emotionally corrective experiences.This is the core focus on this course: Having emotionally corrective experiences that open up new possibilities for greater happiness and ease, better relationships, and more self-efficacy.

Overview
Section 1: Using Meditation to Heal Attachment Conditioning

Lecture 1 Using Meditation to Heal Attachment Conditioning

Section 2: Understanding Schema Repatterning Meditation (SRM)

Lecture 2 Understanding Schema Repatterning Meditation (SRM)

Section 3: Mentalizing the Modes (Understanding Our Parts)

Lecture 3 Mentalizing the Modes (Understanding Our Parts)

Section 4: Going Deeper with Metacognition

Lecture 4 Going Deeper with Metacognition

Section 5: Dismissing Attachment

Lecture 5 Dismissing Attachment

Section 6: Preoccupied Attachment

Lecture 6 Preoccupied Attachment

Section 7: Disorganized Attachment

Lecture 7 Disorganized Attachment

Section 8: Secure Attachment and the Healthy Adult Mode

Lecture 8 Secure Attachment and the Healthy Adult Mode

Anyone with insecure attachment.,Anyone who has tried psychotherapy, meditation, or other healing modalities with disappointing results.



attachmenttheoryrepai8uetx.jpg








 
Zurück
Oben Unten