• 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.




Englische Tutorials

Best Practical 8051 Microcontroller Programming Course 2022

456008423a06tudo4.jpg


Best Practical 8051 Microcontroller Programming Course 2022
Published 08/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 86 lectures (10h 34m) | Size: 5.4 GB



with Tens of Real-World Projects in C and Assembly Language



What you'll learn
At the end of this Course, students will have learned 8051 programming and hardware, as well as various real-world projects in assembly and C.
The student will learn how to create advanced embedded systems by using interrupts, timers, LCD and LED displays, keypads, and A/D converters.
Several 8051 emulators, including Proteus, Edsim51, and Edsim51, will be utilized and thoroughly described.
Students will learn the principles of embedded system hardware and software, as well as how they interact with real-world devices, in this course.
As assignments, there are various mini-projects with solutions.
Requirements
Basic knowledge of programming and digital circuit is needed
Description
I can assure you that this is the most practical 8051 Course you will discover! It includes tens of real-world projects written in Assembly and C. Everything was discussed step by step with various examples, and you will learn when and when to apply the theoretical notions. There are several assignment tasks with solutions.
Are you new to the microcontroller world? Great! Begin with the basics, and I'll teach you all you need to know. Do you have some experience with microcontrollers and want to learn more? Fantastic! You may pick and choose the modules you require.
The course is laboratory-based. Almost every lecture and component of the course directly leads to a hands-on laboratory assignment with a solution. The more you practice with 8051 hardware and software, the more proficient you will become.
I use lots and lots of examples. I take you step-by-step through the lessons - each time providing sample code and documentation to make sure you are supported through the course.
The course does not waste your time. From the very beginning, we jump right into your first project - Let's Get Started.
I am here to help. I am an educator with a singular focus on providing a meaningful experience for my students. And, while I cannot do the work for you, I am willing to work WITH you to help you succeed.
What you'll learn
Program microcontrollers with the Assembly and C programming languages.
Use several common output devices such as LED, 7-Segment, 16-Segment, Dot-matrix LED, LED bargraph and LCD
Use several common output devices such as keys, push-buttons, and keypads
Use Timer/Counter and Interrupt Service Routine to create advanced systems.
Use analog-to-digital converter peripherals
Use a liquid crystal display (LCD)
Use the 8051 to develop embedded systems
Are there any course requirements or prerequisites?
No.
Who this course is for
This course is meant for individuals who are not familiar with microcontrollers, the 8051, and/or the Assembly and C programming languages.
For more experienced individuals, the course will also expedite the learning curve for the 8051 and different simulators such as Proteus, NI-Multisim, and Edsim51.
Who this course is for
Students of Computer science, Electronics Engineering and anyone who loves to build a smart device controller
beginner system developers curious about microcontroller programming in C and assembly



bestpractical8051micr1zenf.jpg


Download from RapidGator




Download from DDownload




Archive Password: "English name of the Old Continent" [First Letter Capital]
 
Operations Management And Research Tools - A Complete Study

zktts4sx5lmosrp0hp3stmsdth.jpg


Operations Management And Research Tools - A Complete Study
Last updated 11/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 6.76 GB | Duration: 9h 54m

A Complete course on Operations Management for CA / CMA / MBA and Finance Professional Courses


What you'll learn
Operations Management
Linear Programming
Assignment
Transportation
Simulation
Network Analysis
Productivity Management
Replacement Analysis
Maintenance Management
Total quality management
Project management
Layout Analysis / Management
Forecasting Techniques
Material Planning

Requirements
No prerequisites

Description
Welcome to your course Operations Management and Research Tools A Complete Study.In this course, you will be learning about various statistical and research tools used in Operations Management. So, what is Operations Management?Operations management is the management of that part of an organization that is responsible for producing goods and/or services. There are examples of these goods and services all around you. Every book you read, every video you watch, every e-mail you send, every telephone conversation you have, and every medical treatment you receive involves the operations function of one or more organizations. So does everything you wear, eat, travel in, sit on, and access the Internet with.So if you are on the lookout for studying how various processes within an operation facility works smoothly, you have come to the RIGHT*PLACE!! In this course, you will learn about various tools and techniques, which are used Industries all over the world, for effective management of operations. The following are the contents for this study.a) What is Operations Managementb) Linear Programmingc) Assignmentd) Transportatione) Simulationf) Learning curveg) Queuing theoryh) Network analysis and project management - PERT and CPMi) Production planning and Controlj) Replacement and maintenance analysisk) Productivity Management l) Quality Managementm) Demand Forecastingn) Operations and process planning o) Layout analysis and managementThis course is structured in self paced learning style. Please use your headset for effective listening. Also have your notepad and pen to take note of key points.Go through the demo videos to get a feel of the course.See you inside!
Overview
Section 1: Introduction
Lecture 1 Introduction to Operation Management
Section 2: Linear Programming
Lecture 2 Linear Programming
Lecture 3 Linear Programming
Lecture 4 Linear Programming case study 1
Lecture 5 Linear Programming case study 2
Lecture 6 Linear Programming case study 3
Lecture 7 Linear Programming case study 4
Section 3: Assignment
Lecture 8 Concept introduction
Lecture 9 Assignment
Lecture 10 case study-2.mp4
Lecture 11 assignment case study-3
Section 4: Transportation
Lecture 12 Transportation
Lecture 13 transportation case study1.mp4
Lecture 14 transportation case study 2 part1
Lecture 15 transportation case study2 part2
Lecture 16 transportation case study 2 part3
Section 5: Simulation
Lecture 17 Simulation
Lecture 18 case study 1
Lecture 19 simulation case study 2 part-1
Lecture 20 simulation case study 2 part-2
Lecture 21 simulation case study 3 part-1
Lecture 22 simulation case study 3 part-2
Section 6: Network Analysis
Lecture 23 Concept Introduction
Lecture 24 network analysis concept-1.mp4
Lecture 25 network analysis concept-2.mp4
Lecture 26 Case Study 2 (Part 1).mp4
Lecture 27 Case Study 2 (Part2).mp4
Lecture 28 network analysis concept-3.mp4
Lecture 29 network analysis case study -3.mp4
Lecture 30 case study 4 (part - 1)
Lecture 31 Case Study 4 (Part 2)
Lecture 32 Case Study 4 (Part 3)
Section 7: Learning Curve
Lecture 33 learning curve case study1.mp4
Lecture 34 learning curve casestudy1 p1.mp4
Lecture 35 learning curve casestudy1 p2.mp4
Lecture 36 learning curve casestudy2.mp4
Lecture 37 learning curve concept intro.mp4
Section 8: Maintenance Management
Lecture 38 Maintenance management
Lecture 39 Maintenance of effectiveness
Lecture 40 Case Study 1 Maintenance management
Lecture 41 Case Study 2 Maintenance management
Lecture 42 Case Study 3 Maintenance management
Section 9: Replacement Analysis
Lecture 43 Replacement analysis
Lecture 44 Case Study 1 replacement analysis
Lecture 45 Case Study 2 replacement analysis
Lecture 46 Case Study 3 replacement analysis
Section 10: Spare parts management
Lecture 47 Spare parts management
Section 11: Additional Case studies
Lecture 48 Case Study 4 Replacement analysis ( Part 2 )
Lecture 49 Case Study 4 Maintenance management ( Part 1 )
Lecture 50 Case Study 4 Maintenance management ( Part 2 )
Lecture 51 Case Study 5 Maintenance management
Section 12: Queuing Theory
Lecture 52 Queuing the concept and formulas
Section 13: Productivity management
Lecture 53 Introduction to Productivity management
Lecture 54 Total Quality Management
Lecture 55 ISO Standards
Lecture 56 Productivity management Case Study 1
Lecture 57 Productivity management Case Study 2
Lecture 58 Productivity management Case Study 3
Lecture 59 Productivity management Case Study 4
Section 14: Production Planning and Control
Lecture 60 Introduction to Production Planning and Control
Lecture 61 Work Study
Lecture 62 method study and work measurement
Section 15: Strategic Management an introduction
Lecture 63 Introduction to Strategy
Lecture 64 Introduction to Strategic Management
Lecture 65 Introduction to Strategic Management (Cont.)
CMA Inter Students,CMA Final Students,CA Final Students,Finance Course Students,MBA students,Engineering students,Operations research students



operationsmanagementawsfkq.jpg


Download from RapidGator





Download from DDownload





Archive Password: "English name of the Old Continent" [First Letter Capital]
 
Accounting And Finance For Bankers - A Comprehensive Study

lbsfufanworlrc0fiocb78diiq.jpg


Accounting And Finance For Bankers - A Comprehensive Study
Last updated 6/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 15.60 GB | Duration: 43h 15m

Understand and appreciate Accounting and Finance nuances relevant for Bankers



What you'll learn
understand Accounting and Finance for Bankers topics relevant for JAIIB Examination
appear confidently for Accounting and Finance for Bankers paper in JAIIB / Diploma in Banking and Finance Examination
work out various quantitative problems on Accounting and Finance Chapters in this paper

Requirements
Basics of Accounting

Description
Welcome to Accounting and Finance for Bankers course.
This course will help you to understand Accounting and Finance aspects relevant and required for Bankers. It will also help you to equip yourself for Diploma in Banking and Finance Examination.
Topics covered in this course
Module A : Business Mathematics and Finance
Calculation of Interest and AnnutiesCalculation of YTMCapital BudgetingDepreciation and its AccountingForeign Exchange Arithmetic.
MODULE B: Principles of Bookkeeping and Accountancy
Definition, Scope and Accounting StandardsBasic Accountancy ProceduresMaintenance of Cash / Subsidiary Books and LedgerBank Reconciliation StatementTrial Balance, Rectification of Errors and Adjusting and Closing EntriesCapital and Revenue ExpenditureBills of Exchange
MODULE C: FINAL ACCOUNTS
Balance Sheet EquationPreparation of Final AccountsRatio AnalysisFinal Accounts of Banking CompaniesCompany Accounts ICompany Accounts IIAccounting in Computerised Environment
MODULE D: BANKING OPERATIONS
Banking OperationsOperational aspects of KYC / Customer ServiceOperational aspects of Accounting EntriesOperational aspects of Handling Cash / ClearingOperational aspects of Deposit AccountsOperational aspects of Loan AccountsOperational aspects of CBS EnvironmentBack office functions / Handling unreconciled entries in Banks
Course Structure:
This course is structured in self paced learning style. You can learn at your convenience at any time and you get life time access to this course.Video lectures were used to deliver the course content
Why you should take this course?
This is one of the comprehensive course covering each and every aspect of Accounting and Finance aspects relevant for Bankers.If you are looking for a career in Banking, Diploma in Banking and Finance offered by IIBF will be an added advance and this course is one of the core paper in that diploma.If you have already joined the Bank and looking for a career growth, then passing JAIIB is very crucial and this course covers on the critical paper of JAIIB.
All the very best.

Overview

Section 1: Calculation of YTM

Lecture 1 Debt and Bonds

Lecture 2 Terms associated with Bonds

Lecture 3 Types of Bonds

Lecture 4 Optionality in Bonds

Lecture 5 Valuation of Bonds

Lecture 6 Bonds With Semi Annual Interest

Lecture 7 Problem Bonds Semi Annual Interest

Lecture 8 Current Yield

Lecture 9 Yield to Maturity

Section 2: Calculation of Interest and Annuities

Lecture 10 Simple Interest

Lecture 11 Simple Interest Example

Lecture 12 Compounding Effect

Lecture 13 Compounding Computation

Lecture 14 Typical Compounding

Lecture 15 Compound Interest Example

Lecture 16 Monthly Compounding Example

Lecture 17 Problem Compounding1

Lecture 18 Problem Compounding2

Lecture 19 EMI

Lecture 20 Problem EMI

Lecture 21 Future Value of Single Amount

Lecture 22 Doubling Period

Lecture 23 Future Value of Fixed Cash Flows

Lecture 24 Problem FVIFA

Lecture 25 Present Value of Amount

Lecture 26 Present Value of Fixed Cash Flows

Lecture 27 Tables and PVIFA

Lecture 28 Problem PV 1

Lecture 29 Problem PV 2

Lecture 30 Problem PV 3

Lecture 31 Problem PV 4

Lecture 32 Problem PVIFA 1

Lecture 33 Problem PVIFA 2

Lecture 34 Problem PVIFA 3

Lecture 35 Problem Perpetuity

Section 3: Capital Budgeting

Lecture 36 NPV

Lecture 37 NPV Technique

Lecture 38 Advantages and Disadvantages of NPV

Lecture 39 Problem NPV

Lecture 40 Problem NPV Ranking

Lecture 41 Problem NPV (Cash Flows Derivation)

Lecture 42 Problem NPV of Different Projects

Lecture 43 Problem NPV and Capital Rationing

Lecture 44 IRR

Lecture 45 IRR Introduction

Lecture 46 Advantages and Disadvantages of IRR

Lecture 47 Modified IRR

Lecture 48 Problem 1 IRR

Lecture 49 Problem 2 IRR

Lecture 50 Problem 3 IRR ARR NPV and Ranking

Lecture 51 Problem 4 IRR DPB PI and Ranking

Lecture 52 Problem 5 PB IRR ARR NPV and Ranking

Lecture 53 Problem 6 IRR Mutually Exclusive Projects and Reinvestment

Lecture 54 Problem 7 NPV and IRR Suitability

Lecture 55 Introduciton and Importance of Capital Budgeting

Lecture 56 Capital Budgeting Process

Lecture 57 Project Cash Flows

Lecture 58 Types of Capital Investment Decisions

Lecture 59 Principles for Measuirng Project Cash Flows

Lecture 60 Capital Budgeting Techniques

Lecture 61 Problems on meauring cash flows

Lecture 62 Problem Measuring Cash Flows

Lecture 63 Pay Back Period Introduction

Lecture 64 Pay Back Period Example

Lecture 65 Payback Reciprocal

Lecture 66 Discounted Pay Back Period Method

Lecture 67 Problem on Pay Back Period

Lecture 68 Accounting Rate of Return

Lecture 69 Profitability Index

Lecture 70 Problem Profitability Index

Lecture 71 Decision Tree - Introduction

Lecture 72 Stages and Rules

Lecture 73 Evaluation rules

Lecture 74 Case Study 1 Decision Tree

Lecture 75 Case Study 2 Decision Tree

Lecture 76 Simulation Introduction

Lecture 77 Simulation eg

Lecture 78 Simulation steps

Lecture 79 Case Study Simulation

Section 4: Depreciation and its Accounting

Lecture 80 Introduction to Depreciation Accounting

Lecture 81 Methods of Deprection

Lecture 82 Straight Line Method of Depreciation

Lecture 83 Finding Amount of Depreciation

Lecture 84 Written Down Value Method of Deprecitation

Lecture 85 Problem 1 on Straight Line Method of Depreciation

Lecture 86 Problem 2 on Straight Line Method of Depreciation

Lecture 87 Problem 3 on Straight Line Method of Depreciation

Lecture 88 Problem 4 on Straight Line Method of Depreciation

Lecture 89 Problem 5 on Straight Line Method of Depreciation

Lecture 90 Comprehensive Problem on Straight Line Method

Lecture 91 Changes in Method of Depreciation

Section 5: Foreign Exchange Arithmetic

Lecture 92 Introduction

Lecture 93 Exchange Rate

Lecture 94 Direct Quote

Lecture 95 Indirect Quote

Lecture 96 Link between Direct Quote and Indirect Quote

Lecture 97 Examples for Direct Quote and Indirect Quote

Lecture 98 Foreign Exchange Market

Lecture 99 American Term and European Terms

Lecture 100 Examples for Americal Term and European Term

Lecture 101 Bid Rate and Ask Rate

Lecture 102 Two Way Quote

Lecture 103 Selecting Appropriate Rate

Lecture 104 Spread

Lecture 105 How to convert a Two Way Quote

Lecture 106 Illustration to understand Two Way Quote

Lecture 107 Cross Rate and Cross Multiplication

Lecture 108 Illustration for Cross Rate and Cross Multiplication

Lecture 109 Exchange Rate for a Day

Lecture 110 What is Spot Rate

Lecture 111 What is Forward Rate

Lecture 112 21 What is Appreciation and Depreciation in Direct Quote

Lecture 113 What is Appreciation and Depreciation in Indirect Quote

Lecture 114 How to compute Appreciation and Depreciation in Forex Rate

Lecture 115 What are Swap Points

Section 6: COMPANY ACCOUNTS I

Lecture 116 Introduction

Lecture 117 Features of Company

Lecture 118 Types of Companies

Lecture 119 Difference between Partnership and Company

Lecture 120 Classes of Share Capital

Lecture 121 Classification of Share Capital

Lecture 122 Issue of Shares

Lecture 123 Allotment of Shares

Lecture 124 Issue of Shares at Par

Lecture 125 Procedure for allotment of shares

Lecture 126 Calls in Arrears

Lecture 127 CALLS

Lecture 128 Calls in Advance

Lecture 129 Issue of Shares at Premium

Lecture 130 Issue of Shares at Discount

Lecture 131 Sweat Equity Shares

Lecture 132 Employees Stock Option Scheme

Lecture 133 Reissue of Forfeited Shares

Lecture 134 Forfeiture of Shares

Lecture 135 Forfeiture Example 1

Lecture 136 Forfeiture Example 2

Lecture 137 Issue of bonus shares

Lecture 138 Share Application and Allotment Problem 1

Lecture 139 Share Forfeiture Problem 1

Lecture 140 Share Forfeiture Problem 2

Lecture 141 Problem Bonus Issue

Lecture 142 Problem 1 Reissue of Forfeit shares

Lecture 143 Problem 2 Reissue of Forfeit shares

Lecture 144 Non Voting Shares

Section 7: COMPANY ACCOUNTS II

Lecture 145 Introduction to Financial Statements

Lecture 146 General Instructions - Financial Statements - Schedule III of Companies Act 2013

Lecture 147 General Instructions related to Assets and Liabilities

Lecture 148 General Instructions related to Share Capital

Lecture 149 General Instructions related to Reserves and Surplus

Lecture 150 GI General Instructions related to Long Term Borrowings

Lecture 151 General Instructions related to Long Term Provision

Lecture 152 General Instructions related to Short Term Borrowings

Lecture 153 General Instructions related to Other Current Liabilities

Lecture 154 Balance sheet format

Lecture 155 Tangible assets

Lecture 156 Intangible Assets

Lecture 157 Non Current Invt

Lecture 158 Long term LA

Lecture 159 Other NCA

Lecture 160 Inventories

Lecture 161 Trade Receivables

Lecture 162 Cash and CE

Lecture 163 Cont liab and commitment

Lecture 164 Short term LA

Lecture 165 PL Format

Lecture 166 GI PL

Section 8: Basic Accountancy Procedures

Lecture 167 Need and Importance of Accounting

Lecture 168 Book Keeping and objectives

Lecture 169 Advantages of Book Keeping

Lecture 170 Accounting and Objectives

Lecture 171 Accounting Process

Lecture 172 Accounting Cycle

Lecture 173 Accountancy Accounting Book keeping

Lecture 174 Relationship Between Accountancy, Accounting & Book Keeping

Lecture 175 Difference Between Accounting & Book Keeping

Lecture 176 Users of Accounting Information

Lecture 177 Branches of Accounting

Lecture 178 Transaction

Lecture 179 Capital

Lecture 180 Assets

Lecture 181 Liabilities

Lecture 182 Drawings

Lecture 183 Debtors and Creditors

Lecture 184 Purchase Sales and returns

Lecture 185 Voucher and Invoice

Lecture 186 Account

Lecture 187 Basic Assumptions in Accounting

Lecture 188 Basic Concepts in Accounting

Lecture 189 Fundamental Principles of Accounting

Lecture 190 Double Entry System Introduction

Lecture 191 Double Entry Features

Lecture 192 Classification of Accounts

Lecture 193 Eg for classification of accounts

Lecture 194 Golden Rule of Accouting

Lecture 195 Debit Credit Rule

Lecture 196 Basic Accounting Procedures Final

Lecture 197 Cash Memo and Invoice

Lecture 198 Receipt

Lecture 199 Debit and Credit Notes

Lecture 200 Pay in Slip and Cheque

Lecture 201 Voucher

Lecture 202 Accounting Equation

Lecture 203 Accounting Equation simple eg

Lecture 204 Accounting Equation Case Study1

Lecture 205 Accounting Equation Case Study 2

Lecture 206 Rules for Debiting and Crediting

Lecture 207 Books of Original Entry

Lecture 208 Steps in Journalising

Lecture 209 Journalising Comprehensive Examples

Lecture 210 Capital and Drawings

Lecture 211 Bank Account Transactions

Lecture 212 Compound Entry

Lecture 213 Accounting entry case study 1

Lecture 214 Accounting entry case study 2

Lecture 215 Accounting entry case study 3

Lecture 216 Acccounting Entry for cash Sales

Lecture 217 Accounting Entry for Banking Transaction

Lecture 218 Accounting Entry for Cash Purchase

Lecture 219 Accounting Entry for Cheque receipt

Lecture 220 Accounting Entry for Cheque receipt and deposit

Lecture 221 Accounting Entry for commission Income

Lecture 222 Accounting Entry for Credit Purchase

Lecture 223 Accounting Entry for Credit Sales

Lecture 224 Accounting Entry for Drawings

Lecture 225 Accounting Entry for Payment through Cheque

Lecture 226 Accounting Entry for Purchase Return

Lecture 227 Accounting Entry for Salary in cash

Lecture 228 Accounting Entry for Sales Return

Lecture 229 Compound Journal Entry

Lecture 230 Compound Journal Entry Case Study

Lecture 231 Accounting Enrty for Drawings Case Study

Lecture 232 Ledger

Lecture 233 Utility of Ledger

Lecture 234 Ledger Format

Lecture 235 Ledger for real personal nominal accounts

Lecture 236 Posting and Procedure

Lecture 237 Ledger Case Study 1

Lecture 238 Ledger Case Study 2

Lecture 239 Posting of Compound Entries to Ledger

Lecture 240 Posting Opening Entry in Ledger

Section 9: COMPUTERISED ACCOUNTING SYSTEM

Lecture 241 Introduction

Lecture 242 Classification of Computers

Lecture 243 Features

Lecture 244 Terms used

Lecture 245 Differences

Lecture 246 Adv and Disadv

Lecture 247 Functions of CAS

Lecture 248 Comp scope in banking

Lecture 249 Why compl automation

Lecture 250 Centralised Infrastructure

Lecture 251 Core bank and benefits

Lecture 252 Tech architecture of Core Banking Solution

Lecture 253 Flow of transaction

Lecture 254 Information Security

Lecture 255 SOP PC LAPTOP

Lecture 256 Password Management Policy

Section 10: BANKING OPERATIONS

Lecture 257 Introduction

Lecture 258 Functions of bank

Lecture 259 Main functions of bank

Lecture 260 Para Banking activites

Lecture 261 Front off bacl off

Lecture 262 Outsourcing activities

Lecture 263 Operational Instructions in Banks

Lecture 264 Banking Oper Manual

Section 11: OPER ASPECTS KYC

Lecture 265 Operational aspects of KYC Norms

Lecture 266 KYC Norms - Customer Acceptance Policy

Lecture 267 KYC Norms - Customer Identification Procedure

Lecture 268 KYC Monitoring Transaction

Lecture 269 KYC Risk Management

Lecture 270 Selecting Additional information KYC

Lecture 271 Norms for Periodic Updation of KYC

Lecture 272 KYC Relaxation

Lecture 273 eKYC

Lecture 274 Customer Service in Banks

Lecture 275 ATM Transactions

Lecture 276 Recent Changes in customer Service - RBI

Lecture 277 BCSBI

Section 12: LOAN ACCOUNTS

Lecture 278 Introduction

Lecture 279 Technical Term

Lecture 280 Technical Term 2

Lecture 281 Priority Sector 3

Lecture 282 Technical Term 4

Lecture 283 Basic Rate

Lecture 284 Fixed & Floating Rate

Lecture 285 Penal Rate of Interest

Lecture 286 Security

Lecture 287 Document of title to Goods & Bankers General Lien

Lecture 288 Negative lien , Restricted Advances, Rehabilitation & Recovery

Lecture 289 Operational Process of loan in Banks

Lecture 290 Methods for Assessment of loans

Lecture 291 Accounting aspects of loan Products

Lecture 292 Basic Operating Instructions on Loan Products

Lecture 293 Operating Manual for C & A

Lecture 294 Simple Operating Procedure

Lecture 295 Documentation & Margin

Lecture 296 VALUATION

Lecture 297 Marketability

Lecture 298 Insurance

Lecture 299 Godown Pledged Accounts

Lecture 300 Pledging of stocks

Lecture 301 Unpledged Goods Stored in Pledged Goods Godown

Lecture 302 Delivery of Stock Pledged

Lecture 303 Submission of Stock Statements

Lecture 304 Goods Hypothecated lying with Unhypothecated Goods

Lecture 305 Inspection of Stock

Lecture 306 SIP

Lecture 307 Inspating official comment in SIR

Lecture 308 SA

Lecture 309 Inspection Charge

Section 13: ACCOUNTING STANDARDS

Lecture 310 AS - Meaning & Process of Creating AS

Lecture 311 AS - Why Mandatory

Lecture 312 Acconting Standards 1

Lecture 313 Acconting Standards 2

Lecture 314 Acconting Standards 3

Section 14: Manintenace of Cash/Subsidiary Books and Ledger

Lecture 315 Subsidiary Books need and advantage

Lecture 316 Purchase Book

Lecture 317 Case Study on Purchase Book

Lecture 318 Sales Book

Lecture 319 Sales Book Case Study

Lecture 320 Return Books

Lecture 321 Purchase Return Book

Lecture 322 Purchase Return Book Case Study

Lecture 323 Sales Return Book

Lecture 324 Sales Return Book Case Study

Lecture 325 Cash Book

Lecture 326 Kinds of Cash Book

Lecture 327 Single Column Cash Book

Lecture 328 Case Study Single Column Cash Book

Lecture 329 Double Column Cash Book with Disc Column

Lecture 330 Case Study Double Column Cash Book with Discount Colum

Lecture 331 Double Colum Cash Book with Bank Column

Lecture 332 Case Study Double Column Cash Book with Bank Column

Lecture 333 Key Points in Cash Book

Lecture 334 Triple Column Cash Book

Lecture 335 Case Study Triple Column Cash Book

Lecture 336 Bill of Exchange

Lecture 337 BoE Technical Terms Part I

Lecture 338 BoE Technical Terms Part II

Lecture 339 BoE Technical Terms Part III

Lecture 340 Bills Books

Lecture 341 Journal Proper

Section 15: Bank Reconciliation Statement

Lecture 342 Cash Book and Bank Book

Lecture 343 Bank Pass Book

Lecture 344 Difference between ​Cash Book (with Bank Column) and Pass Book.

Lecture 345 Bank Reconciliation Statement

Lecture 346 Importance of BRS

Lecture 347 Causes for Disagreement

Lecture 348 1st Disagreement cheque paid not collected

Lecture 349 2nd Disagreement cheque issued not presented

Lecture 350 3rd Disagreement Amount directly credit by Bank w/o knowledge of company

Lecture 351 4th Disagreement Amount directly Debited by Bank w/o knowledge of company

Lecture 352 Bank Overdraft

Lecture 353 Overview of Bank Reconciliation Statement

Lecture 354 Procedure for preparing Bank Reconciliation Statement

Lecture 355 Format of Bank Reconciliation Statement

Section 16: Trial Balance, Rectification of Eroors and Adjusting & Closing Entries

Lecture 356 Trial Balance

Lecture 357 Methods and formats of Trial Balance

Lecture 358 Trial Balance Case Study

Lecture 359 Errors in Accounting

Lecture 360 Error of Principle

Lecture 361 Error of Omission

Lecture 362 Error of Commission

Lecture 363 Compensating Errors

Lecture 364 Errors and Trial Balance

Lecture 365 Case Study on Errors and effect on Trial Balance

Lecture 366 Steps to Locate Errors

Lecture 367 Suspense Account

Lecture 368 Case Study Suspense Acount

Lecture 369 Rectification of Errors

Lecture 370 Case Study 1 Rectification of Errors

Lecture 371 Case Study 2 Rectification of Errors

Lecture 372 Case Study 3 Rectification of Errors

Lecture 373 Case Study 4 Rectification of Errors

Lecture 374 Case Study 5 Rectification of Errors

Lecture 375 Case Study 6 Rectification of Errors - Copy

Lecture 376 Case Study 7 Rectification with Suspense AC

Section 17: Bill of Exchange

Lecture 377 Introduction to Bills of Exchange

Lecture 378 Accounting Aspects in Bills of Exchange

Lecture 379 Methods of Drawing Bills of exchnage

Lecture 380 Computation of Bill Due Date

Lecture 381 Endorsement of Bill of Exchange

Lecture 382 Problem on Endorsement of Bill of Exchange

Lecture 383 Discounting of Bill

Lecture 384 Problem on Discounting of Bill

Lecture 385 Retirement of Bill

Lecture 386 Problem on Retirement of Bill

Lecture 387 Dishonour of Bill

Lecture 388 Problem on Dishonour of Bill

Lecture 389 Dishonour of Bill - Different Scenarios

Lecture 390 Renewal of Bill of Exchange

Lecture 391 Problem 1 on Renewal of Bill of Exchange

Lecture 392 Problem 2 on Renewal of Bill of Exchange

Lecture 393 Insolvency of Customer

Lecture 394 Problem on Insolvency of Customer

Section 18: Balance sheet Equation

Lecture 395 Accounting Equation

Lecture 396 Accounting Equation (Talking Head)

Lecture 397 Accounting Equation simple eg

Lecture 398 Accounting Equation Comprehensive Example

Section 19: Preparation of Final Accounts

Lecture 399 Introduction to Final Accounts (Short Intro)

Lecture 400 Introduction To Final Accounts (Detailed Intro)

Lecture 401 Trading Account - Need and Format

Lecture 402 Closing entries in Trading Account

Lecture 403 Trading Accounts - Problem 1

Lecture 404 Trading Accounts - Problem 2

Lecture 405 Profit and Loss Account - Need and Format

Lecture 406 Profit and Loss Account - Problem 1

Lecture 407 Trading and Profit and Loss Account - Problem 2

Lecture 408 Trading and Profit and Loss Account from Trial Balance - Problem 3

Lecture 409 Trading, Profit and Loss and Balance Sheet Problem 4

Lecture 410 Adjustments - Outstanding and Prepaid Expenses

Lecture 411 Adjustments - Accrued Income and Income Received in Advance

Lecture 412 Adjustments - Interest on Capital and Drawings

Lecture 413 Adjustments - Depreciation

Lecture 414 Adjustments - Bad Debts

Lecture 415 Adjustments - Provision for Bad and Doubtful Debts

Lecture 416 Adjustments - Provision for Bad and Doubtful Debts and Discount on Debtors

Lecture 417 Adjustments - Provision for Discount on Debtors

Lecture 418 Case Study 1 - Provision for Bad and Doubtful Debts

Lecture 419 Case Study 2 - Provision for Bad and Doubtful Debts

Lecture 420 Case Study 3 - Provision for Bad and Doubtful Debts

Lecture 421 Final Accounts Case Study 1

Lecture 422 Final Accounts Case Study 2

Lecture 423 Final Accounts Case Study 3

Lecture 424 Final Accounts Case Study 4

Lecture 425 Final Accounts Case Study 5

Lecture 426 Final Accounts Case Study 6

Lecture 427 Final Accounts Case Study 7

Lecture 428 Final Accounts Case Study 8

Lecture 429 Final Accounts Case Study 9

Lecture 430 Final Accounts Case Study 10

Lecture 431 Final Accounts Case Study 11

Lecture 432 Final Accounts Case Study 12

Lecture 433 Final Accounts Case Study 13

Lecture 434 Final Accounts Case Study 14

Lecture 435 Final Accounts Case Study 15

Lecture 436 Final Accounts Case Study 16

Lecture 437 Final Accounts Case Study 17

Lecture 438 Final Accounts Case Study 18

Lecture 439 Final Accounts Case Study 19

Lecture 440 Final Accounts Case Study 20

Lecture 441 Final Accounts Case Study 21

Section 20: Ratio Analysis

Lecture 442 Introduction to Financial Ratios

Lecture 443 Current Ratio

Lecture 444 Quick Ratio

Lecture 445 Acid Test Ratio

Lecture 446 Defense Interval Ratio

Lecture 447 Problem on Current Ratio

Lecture 448 Problem 2 on Current Ratio

Lecture 449 Capital Structure Ratio (Equity Ratio)

Lecture 450 Capital Structure Ratios (Debt Ratio)

Lecture 451 Capital Structure Ratios (Debt to Equity Ratio)

Lecture 452 Coverage Ratios -Debt Service Coverage Ratio (DSCR)

Lecture 453 Interest Coverage Ratio

Lecture 454 Preference Dividend Coverage Ratio

Lecture 455 Capital Gearing Ratio

Lecture 456 Activity Ratios

Lecture 457 Capital Turnover Ratio

Lecture 458 Fixed Assets Turnover Ratio

Lecture 459 Total Assets Turnover Ratio

Lecture 460 Working Capital Turnover Ratio

Lecture 461 Inventory Turnover Ratio

Lecture 462 Inventory Holding Level

Lecture 463 Debtors Turnover Ratio

Lecture 464 Average Collection Period

Lecture 465 Creditors Turnover Ratio

Lecture 466 Average Payment Period

Lecture 467 General Profitability Ratios

Lecture 468 Gross Profit Ratio

Lecture 469 Operating Ratio

Lecture 470 Operating profit Ratio

Lecture 471 Expense Ratio

Lecture 472 Overall Profitability Ratio

Lecture 473 Net Profit Ratio

Lecture 474 Return on Assets

Lecture 475 Return on Capital Employed

Lecture 476 Return on Share Holders Funds

Lecture 477 Return on Equity Share Holders Funds

Lecture 478 Earnings Per Share

Lecture 479 Cash Flow Earnings Per Share

Lecture 480 Dividend Per Share

Lecture 481 Dividend Pay Out Ratio

Lecture 482 Dividend Yield Ratio

Lecture 483 Illustration on Return on Equity Share Holders Funds

Lecture 484 Market Value Ratio

Lecture 485 Earnings Yield Ratio

Lecture 486 Price Earnings Ratio

Lecture 487 Price to Cash Flow Ratio

Lecture 488 Market Value to Book value Ratio

Lecture 489 Leverage and its Types

Lecture 490 Leverage Concept Example

Lecture 491 Leverage Analysis and Sales Movement

Lecture 492 Business Financing Decisions

Lecture 493 Debt Vs Equity Financing

Lecture 494 Good Time and Bad Time for Debt Equity Financing

Lecture 495 Construct Balance Sheet from Ratios

Lecture 496 Construct Balance Sheet from Ratios - Part II

Lecture 497 Calculater Various Ratios from available information

Lecture 498 Take a decision based on Ratios

Lecture 499 Calculate Return based Ratios

Lecture 500 Prepare Balance Sheet from Ratios

Lecture 501 Calculate various Ratios from the Financials

Lecture 502 Prepare Income Statement and Balance Sheet from Ratios

Lecture 503 Interest coverage ratio case study 1

Lecture 504 liquidity ratios case study1

Lecture 505 liquidity ratios case study 2

Lecture 506 Proprietary Funds Case Study

Lecture 507 Debt Equity CS

Lecture 508 Debtors TO CS

Lecture 509 ESH Ratios

Lecture 510 Stock TO CS

Lecture 511 Ratio Analysis - Detailed CS 1

Lecture 512 Ratio Analysis - Detailed CS 2

Section 21: FINAL SECTION

Lecture 513 Bonus Lecture

This course is meant for students who are appearing for JAIIB and Diploma in Banking and Finance Examinations

Homepage


389dishonourofbilldif3jd4n.jpg










 
Direct Taxation In India A Comprehensive Study

rbgbzzzvoa1jpyce8hz4c6ice3.jpg


Direct Taxation In India A Comprehensive Study
Last updated 6/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 14.22 GB | Duration: 25h 44m

Online Course Direct Taxation relevant for students pursuing CA / CMA / CS / BCom / MCom



What you'll learn
Prepare and appear confidently for CA / CMA / CS / BCom / BBA / MCom Examinations
Apply Direct Taxation Theory in Practice

Requirements
Basics of Accounting

Description
PLEASE NOTE: It is going to be one of the comprehensive course on Direct Taxation and may have 500+ Lectures. All the lectures are not yet added. I will be adding lectures at regular intervals in the coming months. So go through course curriculum before buying this course. Ensure topics you require are already published before buying. It would take few more months for me to complete this course.Welcome to this course "Direct Taxation in India A Comprehensive Study"This course is created as a result of continuous demand from existing students for course on Direct Taxation. This Course is mainly for students pursuing professional courses in India like CA / CMA / CS and graduation like BCom / MCom / BBA, etc. This course is not meant for students outside India.This course will take you through following topics:a) Basic Concepts of Direct Taxationb) Residence and Scope of Total Incomec) Incomes which do not form part of Total Incomed) 5 Heads of Incomee) Incomes of other person included in Assessee's Total Incomef) Aggregation of Income, Set-Off and Carry forward of Lossesg) Deduction from Total Incomeh) Computation of Total Income and Tax Payablei) Advance Tax, TDS and Tax Collection at Sourcej) Provisions for filing return of Income and Self Assessment.This course is structured in self paced learning style. Use your head set for effective listening. Have your note pad or excel on your side to take note of what is taught so nothing goes unrecorded.See you inside the course.

Overview

Section 1: Basic Concepts

Lecture 1 What is Tax?

Lecture 2 Power to levy tax

Lecture 3 Overview of Income Tax Law in India

Lecture 4 Income Tax Act

Lecture 5 Finance Act

Lecture 6 Income Tax Rules

Lecture 7 Circulars & Notifications

Lecture 8 Case laws

Lecture 9 Levy of income Tax

Section 2: Process of Computing Total Income for Income Tax Purposes

Lecture 10 Process of computing Total Income

Lecture 11 Determine Residential Status

Lecture 12 Classify Income Under different heads

Lecture 13 Computation of Income Under each Head

Lecture 14 Clubbing of Income

Lecture 15 Set-off & Carry forward & Set off losses

Lecture 16 Computation of Total Income

Lecture 17 Slab rates for Individual / HUF / AOP / BOI / AJP

Lecture 18 Clarification regarding age of Senior & Very Senior Citizen

Lecture 19 Concessional Tax Rates u/s 115BAC

Lecture 20 Tax rates for Firm / LLP / Local Authority & Co-operative Society

Lecture 21 Tax rates for Company

Lecture 22 Tax rates for certain type of Income

Lecture 23 Computation of Tax Liability - Case Study

Lecture 24 Surcharge

Lecture 25 Rebate

Lecture 26 Health & Education Cess

Lecture 27 Marginal Relief Case Study 1

Lecture 28 Advance Tax

Lecture 29 Tax Deducted at Source (TDS)

Lecture 30 Tax Payable & Refundable

Lecture 31 Return of income

Lecture 32 Who is an Assessee?

Lecture 33 What is Assessment?

Section 3: Person

Lecture 34 Who is a person?

Lecture 35 Who is an Individual?

Lecture 36 What is HUF?

Lecture 37 What is company?

Lecture 38 Classess of companies

Lecture 39 What is firm?

Lecture 40 What is Association of Person?

Lecture 41 What is Body of Individuails?

Lecture 42 What is Local Authority?

Section 4: Income

Lecture 43 What is income?

Lecture 44 Concept of income under Income Tax Act

Lecture 45 Concept of Revenue and capital Receipts

Lecture 46 Transactions in the course of Business

Lecture 47 Profits from sale of shares and securities

Lecture 48 Whether single transaction constitute business?

Lecture 49 Compensation on Termination of Agency

Lecture 50 Treatment of Gift

Lecture 51 Definition of India

Lecture 52 Average Rate of Tax & Maximum marginal Rate

Lecture 53 Assessment Year & Previous year

Lecture 54 Previous Year for undisclosed source of income

Lecture 55 Previous Year for unexplained cash credit

Lecture 56 Previous year unexplained investments

Lecture 57 unexplained money

Lecture 58 Investment not fully disclosed in Books of Accounts

Lecture 59 Unexplained Expenditure

Lecture 60 Amount borrowed or repaid on Hundi & tax effect

Lecture 61 Cases where income of previous year assessed in previous year

Lecture 62 Taxability of shipping Business of Non - Resident

Lecture 63 Taxability of person leaving india

Lecture 64 Taxability of AOP/BOI/Artificial juridial persons formed for event or Purpose

Lecture 65 Taxability of persons likely to Transfer property to avoid tax

Lecture 66 Taxability of Discontinued Business

Lecture 67 Charge of Income Tax

Section 5: Rate of Taxes

Lecture 68 Income tax slab rates for individuals (A.Y. 2018-19)

Lecture 69 Income Tax slab rates for Senior citizens (A.Y.2018-19)

Lecture 70 Tax rates for firm,LLP,Local Authority, co-operative society

Lecture 71 Tax rates for companies

Lecture 72 Tax rates on other items

Lecture 73 Tax rates on Unexplained money & Unexplained investments

Lecture 74 Surcharges & Rate (>50L to 100L)

Lecture 75 Surcharges (income > 100L)

Lecture 76 Surcharge for companies

Lecture 77 Rebate u/s 87A

Lecture 78 Rate of Education Cess, Secondary & Higher Education Cess

Section 6: Residence and Scope of Total Income

Lecture 79 Introduction to Residential Status

Lecture 80 Residential Status of Individuals

Lecture 81 Exception to Residential Status Provisions

Lecture 82 How to determine period of stay in India for Indian Citizen Crew Member?

Lecture 83 How to determine period of stay in India for Indian Citizen Crew Member - Case S

Lecture 84 Who is Resident and Ordinarily Resident and Resident but not Ordinarily Resident

Lecture 85 Residential Status Case Study 1

Lecture 86 Residential Status Case Study 2

Lecture 87 Residential Status Case Study 3

Lecture 88 Case study - Residential Status of Individual leaving India for Employment (for

Lecture 89 Residential Status of HUF

Lecture 90 HUF - Resident Ordinarly Resident and not Ordinarily Resident

Lecture 91 Case Study on Residential Status of HUF

Lecture 92 Residential Status of Firms and Association of Persons

Lecture 93 Residential Status of Company

Lecture 94 Residential Status of Local Authorities and Artificial Juridical Persons

Lecture 95 Scope of Total Income and Residential Status

Lecture 96 Taxability of Income received by Non Resident Seafarers

Lecture 97 Case study on Scope of Total Income and Residential Status

Lecture 98 Meaning of "income Received or Deemed to be Received"

Lecture 99 Meaning of " income Accuring and Arising"

Lecture 100 What is Business Connection?(Amended)

Lecture 101 Income deemed to accrue or arise in india

Lecture 102 Cases not treated as Business connection for Non Residents

Lecture 103 Income from property, Asset or Source of Income in india

Lecture 104 Income through transfer of a capital Asset situated in India

Lecture 105 Declaration of Dividend by a Foreign Company

Lecture 106 Income from salaries Deemed to Accrue or Arise in india

Lecture 107 Case study - income from salaries Deemed to Accrue or Arise in india

Lecture 108 Dividend paid by indian company outside india

Lecture 109 Interest received by nonr resident - Deemed to accrue or arise in india

Lecture 110 Income from Royalty (Deemed to accrue or arise in india)

Lecture 111 Key points related to Royalty and its taxation

Lecture 112 Income From Technical Services (Deemed to Accrue or Arise in India)

Lecture 113 Taxation of Interest, Rotyalty & Fees for Technical Services received by Non Res

Lecture 114 Case Study on Residential Status

Lecture 115 Case study Resident but not ordinary Resident

Section 7: Agricultural Income

Lecture 116 What is Agricultural income?

Lecture 117 Meaning of Agricultural Operations

Lecture 118 Instance of Agri Income

Lecture 119 Instance of Non Agri Income

Lecture 120 Treatment of Partly Agricultural & Partly non Agricultural income (specified cas

Lecture 121 Treatment of party Agri & Non Agri income (other cases)

Lecture 122 Impact of Agriculture income Tax computation

Lecture 123 case study 1 on Agro income

Lecture 124 Case study 2 on Agro income

Lecture 125 Case study 3 Agro income

Lecture 126 Case study 4 Agro income

Section 8: Income which do not form part of Total income

Lecture 127 Agricultural income, members share in income of HUF, share of profit from firm &

Lecture 128 Remuneration to person who is not citizen of india

Lecture 129 Tax paid on income from leasing Aircraft

Lecture 130 Fees for Technical Services connceted with securing of india & Allowances / Perq

Lecture 131 Compensation received on account of disaster

Lecture 132 Sum received under Life insurance Policy

Lecture 133 Payment from national Pension Trust

Lecture 134 Payment from Approved super Annuation fund

Lecture 135 Interest on Securities

Lecture 136 Exemptions - Sec 10 (16 to 19)

Lecture 137 Exemptions - Sec 10 (19A), (20), (21), (22B)

Lecture 138 Income of Professional Institutions

Section 9: Income under head salary

Lecture 139 Basic Elements of salary

Lecture 140 State whether following receipts are salary ?

Lecture 141 Definition of salary

Lecture 142 General notes related to salary

Lecture 143 Basis of charge for salary

Lecture 144 Salary Due Vs Accrued

Lecture 145 Place of Accrual of salary

Lecture 146 Computation of salary at glance

Lecture 147 Taxability of Gratuity

Lecture 148 Gratuity received during continuation of service by Government Employee

Lecture 149 Gratuity on Terminate of service by non-goverment employee covered under payment

Lecture 150 Gratuity - Seasonal / Piece - rated employee

Lecture 151 Case 1 Taxability of Gratuity

Lecture 152 Gratuity received @ Termination by non - Government Employee not covered under p

Lecture 153 Case 2 Taxability of Gratuity

Lecture 154 Clarification on claiming statutory amount under gratuity Exemption

Lecture 155 Tax on Gratuity received after death of an employee

Lecture 156 Leave Salary Encashment

Lecture 157 Case study 1 leave salary encashment

Lecture 158 Case study 2 leave salary encashment

Lecture 159 What is Pension?

Lecture 160 Tax treatment of Pension

Lecture 161 Case Study - Tax treatment of Pension

Lecture 162 Retrenchment Compensation and Tax Treatment

Lecture 163 Compensation on VRS and its Tax Treatment

Lecture 164 Annuity and its Tax Treatment

Lecture 165 Salary received in lieu of Notice Period & Profit in Lieu of Salary

Lecture 166 Allowances and its Tax Treatment

Lecture 167 House Rent Allowance and its Tax Treatment

Lecture 168 Case 1 House Rent Allowance and Tax treatment

Lecture 169 Case 2 House Rent Allowance and Tax Treatment

Lecture 170 Special Allowances and Tax treatment

Lecture 171 Children Education Allowance & Hostel Allowance

Lecture 172 Truck Drivers Allowance and Tax Treatment

Lecture 173 Transport Allowance and Tax Treatment

Lecture 174 Allowance to Government Employee outside India and other allowances

Lecture 175 Allowance to Judges of High Court & Supreme Court and Salary to teacher / profes

Lecture 176 Allowance / Perquisite to member of UPSC

Lecture 177 Case 1 Children Education Allowance and Hostel Allowance

Lecture 178 Case 2 Children Education Allowance and Hostel Allowance

Lecture 179 Case 3 Computation of Gross Taxable Salary

Lecture 180 Case 4 Computation of Gross Taxable Salary

Lecture 181 Case 5 Computation of Gross Taxable Salary

Lecture 182 Perquisites - Meaning and Chargeability

Lecture 183 Exempted Perquisities

Lecture 184 Valuatio of Residential Accomodation - provided by CG / State Government

Lecture 185 Valuatio of Residential Accomodation - provided by Other Employer

Lecture 186 Valuatio of Residential Accomodation - provided by Government / Other Employer -

Lecture 187 Key points related to Valuation of Accomodation

Lecture 188 How to arrive at value of any concession w.r.to rent of any accommodation

Lecture 189 Case 1 Compute Taxable Value of Perquisite

Lecture 190 Case 2 Compute Taxable Value of Perquisite

Lecture 191 Case 3 Compute Taxable Value of Perquisite

Lecture 192 Case 4 Compute Taxable Value of Perquisite

Lecture 193 Relief u/s 89 - Case Study

Section 10: Income from House Property

Lecture 194 Introduction to Income from House Property

Lecture 195 Building or land appurtenant thereto

Lecture 196 "Annual value of a property - assessed to tax only in the hands of the owner"

Lecture 197 Composite Rent

Lecture 198 Net Annual Value of Property

Lecture 199 Property Let out Through out PY

Lecture 200 Property Let out Vacant for part of PY

Lecture 201 Self Occupied Property

Lecture 202 Self Occupied and Let out for parts of year

Lecture 203 Deemed Let out Property

Lecture 204 Property Stock in Trade

Lecture 205 Let out and Portion Self Occupied

Lecture 206 Tax Treatment of Unrealised Rent

Lecture 207 Property Tax

Lecture 208 Case-1 Compute Gross Annual Value[GAV]

Lecture 209 Case-2 Compute Net Annual Value of Property

Lecture 210 Format-Computation of Income from house property

Lecture 211 Case-3 compute income from house property let out through out Previous year

Lecture 212 Format compute income from house property- let out Property vacant for part of t

Lecture 213 Case-4 let out Property vacant for part of the year

Lecture 214 Format-Computation of Income from house property-Self Occupied Property or Unoc

Lecture 215 Case-5 Self Occupied Property

Lecture 216 Deductions from Annual Value

Lecture 217 Deductions for Self Occupied Property

Lecture 218 Receipt of Arrears Rent Unrealized Rent

Lecture 219 Income from CO-Owned Property

Lecture 220 Deemed Ownership

Lecture 221 Case-6 House Property Let-Out for Part of The Year And Self Occupied For Part of

Lecture 222 Case-8 House Property A Protion Let Out and A Protion Self Occupied

Lecture 223 Case-9 Arrears of Rent and Unrealized Rent Recived Subsequenly

Lecture 224 Case-10 Income From Co-Owned Property

Section 11: TDS

Lecture 225 What is TDS?

Lecture 226 TDS on salary

Lecture 227 Case study TDS on salary

Lecture 228 TDS on payment from Employees provident fund

Lecture 229 TDS on interest on securities

Lecture 230 TDS on Dividends

Lecture 231 TDS on interest other than interest on securities

Lecture 232 TDS on winning from lotteries cross word puzzles

Lecture 233 TDS on winning form house Races

Lecture 234 Tds on payment to contractors

Lecture 235 TDS on insurance commission

Lecture 236 TDS on items u/s 194DA, 194E, 194EE, 194F, 194G

Lecture 237 TDS on commission other than insurance commission

Lecture 238 TDS on Rent

Lecture 239 TDS on transfer of immoveable property

Lecture 240 TDS on payment of Rent by certain individual / HUF

Lecture 241 TDS on fees for Technical & professional services

Lecture 242 TDS on payment of compensation on acquisition of certain immoveable property

Section 12: Profits & Gains of Business and Profession

Lecture 243 What is Business and Profession?

Lecture 244 Income Chargeable under Head Profits and Gains of Business / Profession

Lecture 245 General aspects related to Profits and Gains of Business / Profession

Lecture 246 Income not taxable under head Profits and Gains of Business / Profession

Lecture 247 Expenditures allowed as deduction

Lecture 248 Rent, Rates, Taxes, Repairs and Insurance for Building

Lecture 249 Repairs, Insurance of Plant & Machinery & Furniture

Lecture 250 Depreciation under Sec 32 of Income Tax Act

Lecture 251 Method of Computing Depreciation

Lecture 252 Extract of Depreciation Rate

Lecture 253 Computation of Depreciation Case 1

Lecture 254 Computation of Depreciation Case 2

Lecture 255 Case Study on Depreciation

Lecture 256 Expenditure on Scientific Research (Sec 35) - Introduction

Lecture 257 Scientific research as Revenue Expenditure incurred by Assessee

Lecture 258 Scientific research as Capital Expenditure incurred by Assessee

Lecture 259 Application of Sec 41 on Sale of Capital Assets used for Scientific Research

Lecture 260 Deduction on Amount paid to University, College or other institution for Scienti

Lecture 261 Deduction on Amount paid to Company for Scientific Research

Lecture 262 Deduction on amount paid to Research Association / University / College / Other

Lecture 263 Deduction on amount paid to National Laboratory

Lecture 264 Deduction for Scientific Research to Company engaged in Business of Bio Technolo

Lecture 265 Table of Deductions for Scientific Research

Lecture 266 Case Study on Deduction for Scientific Research

Section 13: Capital Gains

Lecture 267 What is Capital Asset

Lecture 268 Stock in Trade -is it a Capital Asset?

Lecture 269 Personal Effects-is it a Capital Asset ?

Lecture 270 Rural Agricultural land -is it a Capital Assets ?

Lecture 271 Short Term And Long Term Capital Assets

Lecture 272 Exceptions

Lecture 273 Part 1 - Determination of period of holding[Clause (i) of Explanation 1 to sect

Lecture 274 Part 2 - Determination of period of holding[Clause (i) of Explanation 1 to sect

Lecture 275 Part 3 - Determination of period of holding[Clause (i) of Explanation 1 to sect

Lecture 276 Period of holding in respect of other capital assets

Lecture 277 Transfer :What it Means ?

Lecture 278 Capital Gain Year of Chargeability

Lecture 279 Insurance Receipts and Capital gains

Lecture 280 Capital Gains on conversion of Capital Asset as stock in trade

Lecture 281 Transfer of beneficial interest in securities[Section 45(2A)]

Lecture 282 Capital gains on introduction of capital contribution

Lecture 283 Capital Gain on distribution capital asset on distribution of firm /AOP/BOI

Lecture 284 Capital Gain on Compensation compulsory acquisition

Lecture 285 Capital Gain on Capital Gains on case of specified Agreement SEC 45 (5a)

Lecture 286 Capital Gain on Distribution of asset by companies in Liquidation (sec 46)

Lecture 287 Capital Gains on Buyback of shares OR other securities

Lecture 288 Transactions not regarded as transfer (Part 1)

Lecture 289 Transactions not Regarded as Transfer (Part 2)

Lecture 290 Transfer of Shares by Shareholder in Scheme of Amalgamation

Lecture 291 Transfer of Capital Asset under Reverse Charge Mechanism

Lecture 292 Case Study Reverse Charge Mechanism

Lecture 293 Mode of Computation of Capital Gain

Lecture 294 Cost of previous owner considered as cost of acquisition

Lecture 295 Ascertainment of Cost of Acquisition in specified circumstances - Part 2

Lecture 296 Ascertainment of Cost of Acquisition in specified circumstances - Part 3

Lecture 297 Ascertainment of Cost of Acquisition in specified circumstances - Part 4

Lecture 298 Ascertainment of Cost of Acquisition in specified circumstances - Part 5

Lecture 299 Ascertainment of Cost of Acquisition in specified circumstances - Part 6

Lecture 300 Ascertainment of Cost of Acquisition in specified circumstances - Part 7

Lecture 301 Cost Inflation Index

Lecture 302 Case Study on Conversion of Capital Asset into Stock in Trade and Capital Gains

Lecture 303 Capital Gain on Self Generated Goodwill

Lecture 304 Computation of Capital Gains in case of Depreciable Assets

Lecture 305 Case Study Computation of Capital Gains in case of Depreciable Assets

Lecture 306 Capital Gains on Slump Sale

Lecture 307 Case Study on Capital Gains on Slump Sale

Lecture 308 Case Study on Sec 50C - Full Value of Consideration in certain cases

Lecture 309 Transfer of Unlisted Shares

Lecture 310 Tax on Advance Money received on Capital Assets

Lecture 311 Income tax on Compulsory Acquisition of Urban Agricultural Land - Case Study

Lecture 312 Income tax on Compulsory Acquisition of Urban Agricultural Land - Case Study 2

Lecture 313 Income tax on Compulsory Acquisition of Urban Agricultural Land - Case Study 3

Lecture 314 Income tax on Compulsory Acquisition of Urban Agricultural Land - Case Study 4

Lecture 315 Income tax on Compulsory Acquisition of Urban Agricultural Land - Case Study 5

Lecture 316 Case Study Sec 54EC

Lecture 317 Capital Gain Account Scheme (CGAS)

Lecture 318 Case Study on Capital Gain Exemption Sec 54 & 54EC (Part 1)

Lecture 319 Case Study on Capital Gain Exemption Sec 54 & 54EC (Part 2)

Lecture 320 Case Study on Capital Gains with Exemptions

Lecture 321 Exemption under sec 54EE for Capital Gains

Lecture 322 Exemption under Sec 54F for Capital Gains

Lecture 323 Sec 54F Non compliance impact

Lecture 324 Case Study with exemption under section 54EC

Lecture 325 Case study on Capital Gain - Exemption u/s 54 & 54EC

Section 14: Income from Other Sources

Lecture 326 Income Frome Other Sources - Introduction

Lecture 327 Deemed Dividend Sec 2 (22) (a to e )

Lecture 328 Deemed Dividend Sec 2 (22) (e)- Case study

Lecture 329 Basic of Charge of Dividend

Lecture 330 Case Study Sec 115 BBDA

Lecture 331 Case Study Sec 115 BBDA

Lecture 332 Chargeability of Dividend in the hands of Shareholder

Lecture 333 Casual Income

Lecture 334 Tax on Consideration in excess of FMV when shares issued at premium

Lecture 335 Sec 56(2)(viib) - Case studies

Lecture 336 Interest received on Compensation / Enhanced compensation

Lecture 337 Tax on Advance forfeited on capital assets due to failure of negotiation

Lecture 338 Taxation of money / property received without / inadequate consideration

Lecture 339 Case Study - Sec 56(2)(x)

Lecture 340 Transfer of property / goods for inadequate consideration - Case Study Part 1

Lecture 341 Transfer of property / goods for inadequate consideration - Case Study Part 2

Lecture 342 Compensation or any other payment received in connection with termination of his

Lecture 343 Income chargeable under the head "Income from other sources"

Lecture 344 Keyman Insurance Policy

Lecture 345 Taxability of Residual Income

Lecture 346 BOND WASHING TRANSACTIONS AND DIVIDEND STRIPPING[SECTION 94]

Lecture 347 APPLICABLE RATE OF TAX IN RESPECT OF CASUAL INCOME[SECTION 115BB]

Lecture 348 DEDUCTIONS ALLOWABLE[SECTION 57]

Lecture 349 Deduction u/s 57(iv) - Case Study

Lecture 350 DEDUCTIONS NOT ALLOWABLE[SECTION 58]

Lecture 351 Deemed Income chargeable to Tax

Section 15: Clubbing Of Income

Lecture 352 Introduction to Clubbing of Income

Lecture 353 Transfer of Income without transfer of asset (Sec 60)

Lecture 354 Clubbing of Income on Revocable Transfer of Asset (Sec 61 & 62)

Lecture 355 Clubbing of Income arising to Spouse - Remuneration from a concern with Substant

Lecture 356 Clubbing of Income arising to Spouse - Income from Asset transferred without ade

Lecture 357 Clubbing of Income Case Study

Lecture 358 Cross Transfer - Case Study

Lecture 359 Clubbing of Income - Case Study

Lecture 360 Clubbing of Income - Comprehensive Case Study

Lecture 361 Minor Children & Spouse - Case Study

Lecture 362 Transfer of asset for the benefit of spouse

Lecture 363 Income arising to son's wife from asset transferred without adequate considerati

Lecture 364 Transferor of Asset for the benefit of Son's Wife

Section 16: Deductions from Gross Total Income

Lecture 365 Introductions to Deductions from Total Income

Lecture 366 Deduction under Sec 80C - Part 1

Lecture 367 Deduction under Sec 80C - Part 2

Lecture 368 Sec 80C related Case Study 1

Lecture 369 Sec 80C related Case Study 2

Lecture 370 Sec 80CCC - Deduction in respect of contribution made to certain pension funds

Lecture 371 Sec 80CCD - Deduction in respect of contribution to pension scheme of Central Go

Lecture 372 Sec 80CCD related Case Study 3

Lecture 373 Sec 80CCD related Case Study 4

Lecture 374 Sec 80CCG - Deduction in respect of Investment made under Equity Savings Scheme

Lecture 375 Sec 80CCG related Case Study 5

Lecture 376 Sec 80D - Medical Insurance Premium

Lecture 377 Sec 80DD - Deduction for Maintenance & Medical Treatment of Dependent Disabled

Lecture 378 Sec 80G Deductions

Lecture 379 Case Study Sec 80G

Lecture 380 Deduction in respect of Rent Paid - Sec 80GG

Lecture 381 Case Study Sec 80GG

Lecture 382 Case Study - Computation of Earnings of Employees and prepration of statement of

Lecture 383 Deductuions u/s 80GGA - Donations for Scientific Research and Rural Development

Lecture 384 Deductuions u/s 80GGB - Deduction for contribution by Companies to Political Par

Lecture 385 Case Study - Deductuions u/s 80GGB - Deduction for contribution by Companies to

Lecture 386 Deductuions u/s 80GGC - Deduction for contribution by any person to Political Pa

Section 17: Last Section

Lecture 387 Bonus Lecture

CA Intermediate Students,CMA Students,CS Students,BCom Students,BBA Students,MCom Students,Finance Professionals

Homepage


360clubbingofincomeco9fc5e.jpg








 
C# Masterclass: Make Rpg & Mobile Games In Unity® & Blender

uibft3bvtnpwtv67zhrpcjleyc.jpg


C# Masterclass: Make Rpg & Mobile Games In Unity® & Blender
Last updated 5/2018
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 8.94 GB | Duration: 41h 43m

Make a Zenda Role Player Game and Ninja Mobile Game in Unity® 5.4.3f1. A beginner's course for aspiring game developers!



What you'll learn
Build a Ninja Survival game for mobile in Unity®.
Build a 3D "Legend of Zenda" game in Unity® from scratch.
Code in C#.
Create artwork in Blender.
Make textures in Photoshop.
Learn the fundamentals of game design.

Requirements
To follow along with these tutorials, you will need the following programs: Blender (for 3D modeling), Photoshop or a free program like Gimp (for 2D art/texturing), and Unity® (for coding).
The tutorials were recorded on a Mac, but you can use a PC.

Description
Have you ever wanted to make your very own games? Well, you've come to the right place! ⭐ ⭐ ⭐ ⭐ ⭐ After purchasing this course, you'll be taken step-by-step through every process needed to do just that. Learn how to build a Legend of Zenda Role Playing Game and Ninja Survival Mobile Game!Our 2 talented instructors, Kevin Liao and Glauco Pires, explain everything from a basic, beginner level. That means you don't need any prior coding or digital art experience to succeed here.Glauco Pires will take you through the process of coding a game in Unity® from scratch.Kevin Liao will teach you how to create all the artistic elements you will need to complete the game. Kevin will teach this section of the course in Blender, the wonderful and free 3D modeling program. The final section will teach you how to integrate the art you created in Blender to the game in Unity®.Included in this course is material for beginners to get comfortable with the interfaces. Please note that we reuse this material in similar courses because it is introductory material. You can find some material in this course in the following related courses:Build 22 Games in GameMaker Studio, C# Unity® & BlenderC# Masterclass: Make RPG & Mobile Games in Unity & BlenderMake a Ninja Survival game for mobile in Unity and BlenderPractical Unity Developer Academy: Make Fully Featured GamesA to Z Unity Development: Code in C# and Make Low Poly ArtC# & Image Processing Masterclass: Make Mobile Games & AppsProfessional Game Development: 3D Modeling and Unity C#Create 19 Low Poly Models & Your First 3D RPG In Unity® C#Complete Unity and Android Development: Build Games and AppsC# Masterclass: Make RPG & Mobile Games in Unity & BlenderBuild "The Legend Of Zenda" Game in Unity and BlenderMake a 3D Unity Action Game & Low Poly Buildings in Blender28 Low Poly Models and a Unity® Game - Complete 3D DeveloperThe beauty of taking an online course like this is the ability to replay any of the lectures at any time. There is no time limit or final tests. You get to learn at your own pace with a practical model method of learning.One of the best features is that you can watch the courses at any speed you want. This means you can speed up the or slow down the video if you want to.This course is project based so you will not be learning a bunch of useless coding practices. At the end of this course you will have real world apps to use in your portfolio. Project based training content is the best way to get from A to B. Taking this course means that you learn practical & employable skills immediately.Learning how to code is a great way to jump in a new career or enhance your current career. Coding is the new math and learning how to code will propel you forward for any situation. Learn coding today and get a head start for tomorrow. People who can master technology will rule the future.You get full lifetime access to this course for a single one-time fee. Sign up now!

Overview

Section 1: Introduction

Lecture 1 Download Blender and Unity3D

Lecture 2 Legend of Zenda Gameplay!

Lecture 3 Ninja Gameplay!

Section 2: T01. Introduction to Unity

Lecture 4 1.1 Introduction

Lecture 5 1.2 Unity Editor

Lecture 6 1.3 Moving a Cube

Lecture 7 1.4 Materials

Lecture 8 1.5 Lights

Lecture 9 1.6 Particle System

Lecture 10 1.7 Applying Physics

Lecture 11 1.8 Asset Store

Section 3: T02. Introduction to Coding

Lecture 12 2.1 Introduction

Lecture 13 2.2 Variables

Lecture 14 2.3 Methods

Lecture 15 2.4 If Blocks

Lecture 16 2.5 Loops

Section 4: T03. Introduction to Inputs

Lecture 17 3.1 Introduction

Lecture 18 3.2 Key Press

Lecture 19 3.3 Moving a Player

Lecture 20 3.4 Jumping

Lecture 21 3.5 Moving Forward

Lecture 22 3.6 Cycling Cameras

Section 5: T04. Introduction to Prefabs

Lecture 23 4.1 Introduction

Lecture 24 4.2 Introduction to Prefabs

Lecture 25 FAQ on Instantiating Objects

Lecture 26 4.3 Random Angles

Lecture 27 FAQ on Destroying Objects

Lecture 28 4.4 Explosion Effect

Lecture 29 4.5 Adding explosion effects

Section 6: Zenda Source Code and Art Assets

Lecture 30 Assets and Source Code

Section 7: Player Movement | Zenda Game

Lecture 31 Creating a Project

Lecture 32 Designing the Player

Lecture 33 Moving the Player

Lecture 34 Key Input

Lecture 35 Activating Physics

Lecture 36 Jumping

Lecture 37 Double Jump Block

Lecture 38 Velocity

Lecture 39 Velocity Optimizations

Lecture 40 Looking Around

Section 8: Weapons | Zenda Game

Lecture 41 Designing a Sword

Lecture 42 FAQ on Rotating Objects

Lecture 43 Swinging the Sword

Lecture 44 Moving the Sword Back

Lecture 45 Retreating the Sword

Lecture 46 Designing a bomb

Lecture 47 Bomb Script

Lecture 48 Exploding the bomb

Lecture 49 Throwing Bombs

Lecture 50 Bow

Lecture 51 Swapping Weapons

Section 9: Enemies | Zenda Game

Lecture 52 Simple Enemies

Lecture 53 Strong Enemy

Lecture 54 Hit Area

Lecture 55 Patrolling Logic

Lecture 56 Shooting Enemy

Lecture 57 Enemy Bullet

Lecture 58 Damaging the Player

Section 10: Camera and User Interface | Zenda Game

Lecture 59 Camera

Lecture 60 Game Interface

Lecture 61 Health Bar

Lecture 62 Main Menu

Section 11: Terrains | Zenda Game

Lecture 63 Terrain Basics

Lecture 64 Painting the Terrain

Lecture 65 Trees and Grass

Lecture 66 Water

Lecture 67 Flares and Camera Effects

Section 12: Level Design | Zenda Game

Lecture 68 Level Terrain

Lecture 69 Dungeon Entrance

Lecture 70 Teleporting

Lecture 71 Dungeon

Lecture 72 Adding Shooting Enemies to the Dungeon

Lecture 73 Adding Remaining Enemies

Lecture 74 Remaining Enemies

Section 13: Introduction to Blender

Lecture 75 Overview of Blender

Section 14: Character Art | Zenda Game

Lecture 76 Reference Images

Lecture 77 Headset Ref

Lecture 78 Head Basic Shaping

Lecture 79 Head Medium Shaping

Lecture 80 Head Lips Shaping

Lecture 81 Head Shape Fixing

Lecture 82 Body Set Ref

Lecture 83 Body Basic Blocking

Lecture 84 Body Base Detailing

Lecture 85 Body Torso Detailing

Lecture 86 Body Hand Detailing

Lecture 87 Body Head Attaching

Lecture 88 Edge Flow Fixing

Lecture 89 Body UV Unwrapping

Lecture 90 Body Base Painting

Lecture 91 Body Painting Base Cleaning Up

Lecture 92 Body Painting Coloring

Lecture 93 Body Painting Detailing Eyes

Lecture 94 Body Painting Face

Lecture 95 Body Painting Full-Body Detailing

Lecture 96 Helmet Modeling

Lecture 97 Helmet Unwrapping and Texturing

Lecture 98 Rigging 01

Lecture 99 Rigging 02

Lecture 100 Rigging End Fix

Lecture 101 Weight Painting and Export

Lecture 102 Importing to Unity

Section 15: Weapons Art | Zenda Game

Lecture 103 Super Basic Prop Modeling

Lecture 104 Sword Basic Prop Modeling

Lecture 105 Bomb Basic Prop Modeling

Lecture 106 Shield Basic Prop Modeling

Lecture 107 Bow Basic Prop Modeling

Lecture 108 Arrow Basic Prop Modeling

Lecture 109 Arrow Quiver Basic Modeling

Lecture 110 Unity Weapon Toon Shading

Section 16: Basic Enemy Art | Zenda Game

Lecture 111 Basic Enemy Head

Lecture 112 Basic Enemy Body

Lecture 113 Basic Enemy Body Fixing

Lecture 114 Basic Enemy Body Rigging

Lecture 115 Basic Enemy UV Unwrapping

Lecture 116 Basic Enemy Texture Painting

Lecture 117 FAQ on Exporting

Lecture 118 Basic Enemy Unity Importing

Section 17: Strong Enemy Art | Zenda Game

Lecture 119 Strong Enemy Basic Modeling

Lecture 120 Strong Enemy Model Detailing

Lecture 121 Strong Enemy Basic Coloring

Lecture 122 Strong Enemy Rigging

Lecture 123 Strong Enemy Weight Painting

Lecture 124 Strong Enemy Toon Shading

Section 18: Swivel Cannon Art | Zenda Game

Lecture 125 Swivel Cannon Modeling

Lecture 126 Swivel Cannon Unity

Section 19: Dungeon Art | Zenda Game

Lecture 127 Modular Dungeon 1

Lecture 128 Modular Dungeon 2

Lecture 129 Modular Dungeon 3

Lecture 130 Modular Walls Unwrapping 1

Lecture 131 Modular Walls Unwrapping 2

Lecture 132 Modular Walls Exporting UV's

Lecture 133 Dungeon Texturing 1 Floors

Lecture 134 Dungeon Texturing 2 Single Wall

Lecture 135 Dungeon Texturing 3 Angled Walls

Lecture 136 Dungeon Textures Wall Fix

Lecture 137 Corner Wall Texture Quick Fix

Lecture 138 Dungeon Ceiling 1

Lecture 139 Dungeon Ceiling 2

Lecture 140 Dungeon in Unity

Section 20: Temple Art | Zenda Game

Lecture 141 Modeling Spawn Temple Basic

Lecture 142 Spawn Temple UV Unwrap

Lecture 143 Spawn Texturing

Section 21: Dungeon Entrance Temple Art | Zenda Game

Lecture 144 Modeling Temple Entrance Basics

Lecture 145 Temple Entrance Detailing

Lecture 146 Temple UV Unwrapping 1

Lecture 147 Temple Mountain UV Unwrap

Lecture 148 Temple Entrance Texturing

Lecture 149 Unity Dungeon Entrance Temple

Section 22: Humanoid Models | Zenda Game

Lecture 150 Integrating Cannons

Lecture 151 Humanoid and Animators

Lecture 152 Player Animations

Lecture 153 Player Walking

Lecture 154 Enemy Humanoids

Lecture 155 Patrolling Rotation

Section 23: Beat the Dungeon | Zenda Game

Lecture 156 Bomb Art

Lecture 157 Sword and Bow

Lecture 158 Attaching Weapons

Lecture 159 Sword Adjustment

Lecture 160 Dungeon Enemies

Lecture 161 Dungeon UI

Lecture 162 Designing a Treasure

Lecture 163 Collecting the Treasure

Lecture 164 Clearing Dungeons

Section 24: Effects and AI | Zenda Game

Lecture 165 Effect Manager

Lecture 166 Navigation

Lecture 167 Agents

Lecture 168 Agent Animation

Lecture 169 Enemy Chasing

Lecture 170 Enemy Chasing 2

Lecture 171 Challenge Time!

Lecture 172 New Player Orientation

Lecture 173 Camera Rotation

Lecture 174 Smooth Camera Rotation

Section 25: Jumpers | Ninja Game

Lecture 175 Setting up the project

Lecture 176 Building a simple scene

Lecture 177 Percent Coordinates

Lecture 178 Clicking Variation

Lecture 179 Player Movement

Lecture 180 Orthographic Camera

Lecture 181 Jumping Enemy

Lecture 182 Jumping Enemy Movement

Lecture 183 Killing the Player

Lecture 184 Canvas

Lecture 185 End Game Messages

Section 26: Adding More Functionality | Ninja Game

Lecture 186 Reusability

Lecture 187 Dynamically Adding the Enemy

Lecture 188 Game Mode Switch

Lecture 189 Setting up the rolling enemy

Lecture 190 Rolling Enemy Movement

Lecture 191 Enemy Position

Lecture 192 Killing the Player

Lecture 193 Depth Range

Lecture 194 HorizontalRange

Section 27: Enemy Logic | Ninja Game

Lecture 195 Creating the Bouncing Enemy

Lecture 196 Moving the Bouncing Enemy

Lecture 197 Diagonal Movement

Lecture 198 Movement Flip

Lecture 199 Initial Angle

Lecture 200 Enemy Collision

Lecture 201 Multiple Bouncers

Lecture 202 Depth Walls

Section 28: Designing the Game | Ninja Game

Lecture 203 Designing the Crawlers

Lecture 204 Crawling Enemy Movement

Lecture 205 Player's Rotation

Lecture 206 Jumping Force

Lecture 207 Finish The Jumping Logic

Lecture 208 Spawning Crawlers

Section 29: Turrets | Ninja Game

Lecture 209 Designing the Turret Enemy

Lecture 210 Turret States

Lecture 211 Turret Movement

Lecture 212 Smooth Aiming

Lecture 213 Aiming

Section 30: Game Logic | Ninja Game

Lecture 214 Preparing the Game Logic

Lecture 215 Raycast

Lecture 216 Shooting Weapons

Lecture 217 Aiming Improvements

Lecture 218 Targets

Lecture 219 Shooting the Player

Lecture 220 Destroying the Targets

Section 31: Configuring the Player | Ninja Game

Lecture 221 Configuring the Player

Lecture 222 Moving Up

Lecture 223 Jetpack Thrusters

Lecture 224 Designing the Enemy

Lecture 225 Wave Patterns

Lecture 226 Spawn Enemies

Section 32: Endless Mode | Ninja Game

Lecture 227 Setting up endless mode

Lecture 228 Highscores

Lecture 229 Refactoring the spawn logic

Lecture 230 Increasing the difficulty

Lecture 231 Bouncer Difficulty

Lecture 232 Crawler Difficulty

Lecture 233 Turrets Difficulty

Lecture 234 Targets Difficulty

Lecture 235 Jetpack Difficulty

Section 33: Menu and Level Design | Ninja Game

Lecture 236 Building the Menu Scene

Lecture 237 Level Selection

Lecture 238 Level Picker

Lecture 239 Losing the Game

Lecture 240 Level Parameters

Lecture 241 Setting Difficulties

Lecture 242 Setting Endless Mode

Section 34: Background Art | Ninja Game

Lecture 243 Floors

Lecture 244 Walls

Section 35: Game Assets | Ninja Game

Lecture 245 Bouncing Enemy

Lecture 246 Rolling Enemy

Lecture 247 Double Rolling Enemies

Lecture 248 Crawler Enemy

Lecture 249 Turret Enemy 1

Lecture 250 Turret Enemy 2

Lecture 251 Player Ninja Character

Lecture 252 Enemy Ninja Character

Lecture 253 Ninja Stars

Lecture 254 Flight Enemy

Lecture 255 Jet Pack

Section 36: Finalizing the Art | Ninja Game

Lecture 256 Assets Toon Shading

Lecture 257 Background

Section 37: Integrating the Art | Ninja Game

Lecture 258 Playing from the Game Scene

Lecture 259 Integrating Jumper Art

Lecture 260 Integrating the Roller Art

Lecture 261 Integrating Roller Art Con't

Lecture 262 Integrating the Crawler

Lecture 263 Integrating the turret model

Lecture 264 Aiming the New Turret

Lecture 265 Integrating the Target Enemies

Lecture 266 Integrating the Flying Enemy Art

Lecture 267 New Player Art

Lecture 268 Integrating the Dojo

Lecture 269 Adjusting the Interface

Lecture 270 Challenge Time!

Section 38: Ninja Resources

Lecture 271 Source Code and Art Assets

Lecture 272 Please leave us a rating!

Lecture 273 Bonus Lecture: How to get more content.

People who want to make games.,Even if you have never coded before, you can use these lessons to get a headstart in the game-making realm! This course is targeted towards beginners to immediate.,This course assumes you know a little about Unity Technologies and Blender.

Homepage


52simpleenemiesswcdc5.jpg






 
Vocal Workouts #1: SINGING SIMPLIFIED

iaza5d7ikrdfuupzjxvbejxdjr.jpg


Vocal Workouts #1: SINGING SIMPLIFIED
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 4h 2m | Size: 5.2 GB



What you'll learn
VOCAL WORKOUTS #1 gets you practicing what you're learning in Singing Simplified #1. Practice correctly and more consistently with me as your guide.
10, 30-minute Vocal Workouts to help you improve ALL aspects of your voice!l
Complete demonstrations for every single exercise in the course
Many more vocal tips and insights!
Vocal Warmups, Singing Exercises, and Warm-downs


Requirements
You do NOT have to be born with natural singing talent!
It's best if you've started Singing Simplified #1, but not necessary if you have some basic singing experience.
All you need is your voice, a place to practice, and a love for music!


Description
VOCAL WORKOUTS #1 gets you practicing what you're learning in Singing Simplified #1! You need to exercise your voice to reach your vocal goals, and that's what Vocal Workouts #1 is all about!

I'll be your personal singing trainer through these vocal workout sessions, helping you to improve your technique, strengthen your voice, and increase your vocal range even more quickly than you thought possible!

Included in the course

TEN, fun and challenging 30-minute Vocal Workouts for you to choose from - simple enough for Beginner to Intermediate students

Each Workout includes vocal warmups, 10-12 vocal exercises, a warm down, and a lot more helpful tips along the way.

EVERY EXERCISE IS DEMONSTRATED FOR YOU, IN FULL. I walk you through each one, step by step!

I answer the most popular questions about breathing for singing, vocal support, and how to get the best natural vocal tone.

The Workouts are great for intermediate to advanced students as well!

Simply choose a Vocal Workout each day and we'll go through it together! I hope to see you in class!

Steve Glazer

Who this course is for
Beginner to Intermediate level singers, but the exercises are great for singers of all levels.

Homepage


1.yourwarmupsvfeyn.jpg










Archive Password: "English name of the Old Continent" [First Letter Capital]
 
Accounting Standards A Complete Study For Ca/Cma/Cs

dyxdwtwuiajmxf3xcttexd7esf.jpg


Accounting Standards A Complete Study For Ca/Cma/Cs
Last updated 10/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.37 GB | Duration: 21h 49m

Course on Accounting Standards for CA / CMA / CS / MBA / M Com / B Com Students



What you'll learn
Theory and Practice of Accounting Standards

Requirements
Basic knowledge of Accounting

Description
Welcome to this course "Accounting Standards A Complete Study"
The objective of this course is to have a complete overview of theory and practice of Accounting Standards issued by Institute of Chartered Accountants of India. In this course, i have taken efforts to explain each and every part of Accounting Standards and they will be supported by case studies as well.
Knowledge of Accounting Standards is very essential from Examination perspective as well from Practical angle. Because, Accounting Standards significantly influence the way Financial Statements are prepared and presented. Students pursuing professional courses like Chartered Accountancy, Cost and Management Accountancy, Company Secretaryship, etc. should have through knowledge of Accounting Standards.
I will be covering following Accounting Standards in this course
AS 1 Disclosure of Accounting Policies
AS 2 Valuation of Inventories
AS 3 Cash Flow Statements
AS 4 Contingencies and events occuring after Balance Sheet Date
AS 5 Net Profit or Loss for the period, Prior period items and Changes in Accounting Policies
AS 9 Revenue Recognition
AS 10 Property, Plant and Equipment
AS 11 Effects of Changes in Foreign Exchange Rates
AS 12 Accounting for Government Grants
AS 13 Accounting for Investments
AS 16 Borrowing Costs
AS 17 Segment Reporting
AS 22 Accounting for Taxes on Income
This course is structured in self paced learning style. You can learn these number crunching topics at your own pace. Use head phone, have note pad / excel opened to scribble or take note of what you are learning.
Wish you a happy learning.

Overview

Section 1: Introduction

Lecture 1 Welcome Lecture

Section 2: AS 1 DISCLOSURE OF ACCOUNTING POLICIES

Lecture 2 Introduction to AS 1 Disclosure of Accounting Policies

Lecture 3 Fundamental Accounting Assumptions

Lecture 4 Accounting Policies

Lecture 5 Going Concern Assumption Case Study

Section 3: AS 2 VALUATION OF INVENTORY

Lecture 6 AS 2 Introduction

Lecture 7 Items excluded from scope of AS 2

Lecture 8 Types of Inventory

Lecture 9 Inventory cost ascertainment

Lecture 10 Valuation of Inventory

Lecture 11 Measurement of Inventory

Lecture 12 Cost of Inventory

Lecture 13 Joint Products or Byproducts

Lecture 14 Cost Formula

Lecture 15 Other Techniques of Cost Measurement

Lecture 16 Net Realisable Value

Lecture 17 Disclosure Requirements

Lecture 18 Value of Inventory Case Study

Lecture 19 Treatment of Fixed Overheads Case Study

Lecture 20 Computation of Cost of Inventory Case Study

Lecture 21 Valuation of Inventory Net Realiable Value Item by Item Basis Case Study

Lecture 22 Treatment of Normal and Abnormal Loss and Valuation of Inventory Case Study

Lecture 23 Treatment of Production Overheads in Valuation of Inventory Case Study

Section 4: AS 3 Cash Flow Statement

Lecture 24 Cash Flow Statement Introduction (Talking Head)

Lecture 25 Cash Flows from Various Activities (Talking Head)

Lecture 26 Cash Flow Statement Direct Method (Talking Head)

Lecture 27 Cash Flow Statement Indirect Method (Talking Head)

Lecture 28 Case Study 1 Cash flow study (Talking Head)

Lecture 29 Case Study 2 Cash flow study (Talking Head)

Lecture 30 Case Study 3 Cash flow study (Talking Head)

Section 5: AS 4 Contingencies and Events occuring after balance sheet date

Lecture 31 Introduction to AS 4

Lecture 32 Events occurring after Balance Sheet Date

Lecture 33 Adjusting Event and Non Adjusting Event

Lecture 34 Events not affecting Financial Statement

Lecture 35 Special Nature Event (Dividends Declared)

Lecture 36 Going Concern and Events occuring after Balance Sheet Date

Lecture 37 Case Study1 Events occurring after Balance Sheet Date

Lecture 38 Case Study2 Events occurring after Balance Sheet Date

Lecture 39 Case Study3 Events occurring after Balance Sheet Date

Lecture 40 Case Study4 Events occurring after Balance Sheet Date

Lecture 41 Case Study5 Events occurring after Balance Sheet Date

Lecture 42 Case Study6 Events occurring after Balance Sheet Date

Lecture 43 Case Study7 Events occurring after Balance Sheet Date

Lecture 44 Case Study8 Events occurring after Balance Sheet Date

Lecture 45 Case Study 9 Events occuring after Balance Sheet Date

Lecture 46 Case Study 10 Events occuring after Balance Sheet Date

Lecture 47 Case Study 11 Events occuring after Balance Sheet Date

Section 6: AS 5 Net Profit or Loss for the period, Prior Period Items and Changes in Accoun

Lecture 48 AS 5 Introduction

Lecture 49 Profit or Loss from Oridnary Items

Lecture 50 Extra Ordinary Items as per AS 5

Lecture 51 Exceptional Items

Lecture 52 Prior Period Items

Lecture 53 Changes in Accounting Estimates

Lecture 54 Changes in Accounting Policy

Lecture 55 Case Study - Prior Period Item

Lecture 56 Case Study - Disclosure for Ordinary Items

Lecture 57 Case Study - Disclosure for Ordinary Items

Lecture 58 Case Study Prior Period Item

Lecture 59 Case Study Change in Accounting Policy

Section 7: AS 7 Construction Contracts

Lecture 60 Construction Contract and its Type

Lecture 61 Objectives of Accounting for Construction Contract

Lecture 62 Applicability of AS7

Lecture 63 Measurement of Contract Revenue

Lecture 64 Contract Costs - Inclusion and Exclusions

Lecture 65 Basic Principles of Recognition of Revenue and Expenses

Lecture 66 Composition of Contract Revenue

Lecture 67 Provision for Expected Losses

Lecture 68 Effect of change in estimate in Construcition Contract

Lecture 69 Accounting Disclosures by Construction Contractors as per AS 7

Lecture 70 Contract Accounting Case Study 1

Lecture 71 Contract Accounting Case Study 2

Lecture 72 Contract Accounting Case Study 3

Section 8: AS 9 Revenue Recognition

Lecture 73 Revenue Recognition - Introduction

Lecture 74 Item excluded in Revenue Definition

Lecture 75 Timing of Revenue Recognition

Lecture 76 Conditions of Revenue Recognition

Lecture 77 Revenue Recognition when goods are sold subject to conditions

Lecture 78 Revenue from Rendering of service

Lecture 79 Special Treatment of Revenue Recognition

Lecture 80 When Revenue from sale of goods can berecognised?

Lecture 81 Treatment of interdepartmental Transfer

Lecture 82 Revenue Recognition Case Study 1

Lecture 83 Revenue Recognition Case Study 2

Lecture 84 Revenue Recognition Case Study 3

Lecture 85 Revenue Recognition Case Study 4

Lecture 86 Revenue Recognition Case Study 5

Lecture 87 Revenue Recognition Case Study 6

Lecture 88 Revenue Recognition Case Study 7

Lecture 89 Revenue Recognition Case Study 8

Section 9: AS 10 Property, Plant & Equipment

Lecture 90 Introduction to AS 10 (Revised)

Lecture 91 Property, Plant & Equipment - Definition

Lecture 92 Biological Assets & Bearer Plant Defintion

Lecture 93 Agricultural Activity & Produce as per AS 10

Lecture 94 Recognition criterial for Property, Plant & Equipment as per AS 10

Lecture 95 Case Study on Capitalisation of Remodelling Expenses

Lecture 96 "Treatment of Spareparts, Standby Equipment & Servicing Equipment"

Lecture 97 Treatment of Cost of Day to Day Servicing

Lecture 98 Treatment of Replacement of Parts of PPE

Lecture 99 Measurement at Recognition of PPE

Lecture 100 Purchase Price

Lecture 101 Directly Attributable Cost as per AS 10

Lecture 102 Case Study 1 Directly Attributable Cost

Lecture 103 Case Study 2 Directly Attributable Cost

Lecture 104 Case Study 3 Directly Attributable Cost

Lecture 105 Decommissioning, Restoration and similar liabilities

Lecture 106 Cost of Self Constructed Asset

Lecture 107 Measurement of Cost

Lecture 108 Commercial Substance in Exchange Transaction

Lecture 109 Case Study 1 Measurement of Cost

Lecture 110 Case Study 2 Measurement of Cost

Lecture 111 Measurement of Cost Part 2

Lecture 112 Measurement after Recognition

Lecture 113 Cost Model as per AS 10

Lecture 114 Revaluation Model as per AS 10

Lecture 115 Frequency of Revaluation

Lecture 116 Determination of Fair Value

Lecture 117 Accounting treatment under Revaluation Model

Lecture 118 Treatment of Revaluation Increase or Decrease

Lecture 119 Case Study on Treatment of Revaluation Increase or Decrease

Lecture 120 Treatment of Revaluation Surplus

Lecture 121 Depreciation and related aspects under AS 10

Lecture 122 Case Study on Depreciation with ref. to AS 10

Lecture 123 Review of Residual Value & Useful Life of Asset with Case Study

Lecture 124 Commencement of Period for Depreciation

Lecture 125 Cessation of Depreciation with Case Study

Lecture 126 Cessation of Depreciation (Continuation)

Lecture 127 Depreciation for Land and Building

Lecture 128 Change in Method of Depreciation as per AS 10

Lecture 129 Methods of Depreciation as per AS 10

Lecture 130 Case Study Method of Depreciation as per AS 10

Lecture 131 Changes in Decommissioning, Restoration & Other Liabilities as per AS 10

Lecture 132 Changes in Liabilities (Asset recognized under Cost Model) as per AS 10

Lecture 133 Changes in Liabilities (Asset recognized under Revaluation Model) as per AS 10

Lecture 134 4 Situations and its accounting as per AS 10

Lecture 135 Case Study Compensation from 3rd Party as per AS 10

Lecture 136 Retirement of PPE as per AS 10

Lecture 137 De-Recognition of PPE as per AS 10

Lecture 138 Disclosure requirement for PPE as per AS 10

Section 10: AS 11 The Effects of Changes in Foreign Exchange Rates

Lecture 139 Introduction to AS 11 The Effects of Changes in Foreign Exchange Rates

Lecture 140 Areas not covered by AS 11

Lecture 141 What is Foreign Currency Transaction?

Lecture 142 Monetary and Non Monetary Items

Lecture 143 integral and integral foreign operations

Lecture 144 Forward Exchange Contract and Forward Rate

Lecture 145 Initial Recognition of Foreign Exchange Transactions

Lecture 146 Reporting Foregin Currency Items at Balance Sheet Date

Lecture 147 Recognition of Exchange Differences

Lecture 148 Treatment of Exchange Differences of Long Term Monetary Items

Lecture 149 Translation of Financial Statements of Foreign Operations

Lecture 150 Translation of Financial Statements of Integral Foreign Operations

Lecture 151 Translation of Financial Statements of Non Integral Foregin Operations

Lecture 152 How to decide Non Integral Foregin Operations?

Lecture 153 Forward Contract and AS 11

Lecture 154 Case Study 1 Forex Difference and Loan Accounting

Lecture 155 Case Study 2 Capitalization of Foreign Exchange Difference attributable to Depre

Lecture 156 Case Study 3 Preparation of Trial Balance of Foreign Operations in Rupees

Lecture 157 Case Study 4 Recognition of Forward Contract Loss / Gain

Lecture 158 Case Study 5 Accounting for Speculative loss / gain out of Forward Contract

Lecture 159 Disclosures required in Financial Statements

Lecture 160 Presentation of Foreign Currency Monetary Item Translation Difference Account

Lecture 161 Case Study 6 Accounting for Translation of Integral Foreign Operations

Section 11: AS 12 Accounting for Government Grants

Lecture 162 Introduction to Accounting for Government Grants

Lecture 163 What is Government Grant?

Lecture 164 Accounting Treatment for Government Grant

Lecture 165 Recognition of Government Grants

Lecture 166 Presentation of Grants related to Specific Fixed Assets

Lecture 167 Case Study on Accounting for Government Grant (by deducting from Fixed Asset)

Lecture 168 Case Study on Government Grant (Treating as Deferred Income)

Lecture 169 Case Study (Utilisation of Government Grant and Accounting for asset recevied fr

Lecture 170 Presentation of Grants (Revenue & in nature of Promoter's Contribution)

Lecture 171 Case Study (Accounting treatment for Grant received for Investment)

Lecture 172 Refund of Government Grants

Lecture 173 Disclosures in Financial Statements for Government Grants

Lecture 174 Case Study (Accounting treatment for Refund of Grant credited to Fixed Asset)

Lecture 175 Case Study (Accounting treatment for Refund of Grant credited to Fixed Asset)

Lecture 176 Case Study (Accounting treatment Deferred Grant a/c and refund)

Section 12: AS 13 Accounting for Investments - Case Studies

Lecture 177 Investment Accounting

Lecture 178 Problem 1 Investment Accounting

Lecture 179 Problem 2 Investment Accounting

Lecture 180 Problem 3 Investment Accounting

Lecture 181 Accounting for Fixed Investment Securities

Lecture 182 Problem 4 Accounting for Fixed Investment Securities

Lecture 183 Problem 5 Accounting for Fixed Investment Securities

Section 13: AS 14 Accounting for Amalgamations

Lecture 184 Amalgamation Introduction

Lecture 185 Difference between Amalgamation Absortpion and External Reconstruction

Lecture 186 Types of Amalgamation

Lecture 187 Purchase Consideration

Lecture 188 Case 1 Purchase Consideration

Lecture 189 Case 2 Purchase Consideration

Lecture 190 Methods of Accounting for Amalgamation

Lecture 191 Case 3 Amalgamation in nature of Merger

Lecture 192 Case 4 Amalgamation in nature of Purchase

Lecture 193 Case 5 Purchase Consideration

Lecture 194 Case 6 Purchase Consideration

Lecture 195 Intercompany Owings in Amalgamation

Lecture 196 Journal Entries to be passed in Books of Selling Company

Lecture 197 Journal Entries to be passed in Books of Buying Company

Lecture 198 Intercompany Owings - Adjustment in Value of Stock in Amalgamation

Lecture 199 Case 7 Intercompany Owings and Amalgamation

Lecture 200 Case 8 Amalgamation Closing Ledger in Selling Companies

Lecture 201 Case 9 Amalgamation Closing Ledger in Buying Company

Section 14: AS 16 Borrowing Cost

Lecture 202 Introduction to AS 16 Borrowing Cost

Lecture 203 Definition of Qualifying Asset

Lecture 204 Exchange Difference on Foreign Currency Borrowings treated as Borrowing Cost

Lecture 205 Case Study Exchange Difference on Foreign Currency Borrowings treated as Borrowi

Lecture 206 Borrowing Cost Eligible for Capitalisation

Lecture 207 Specific Borrowing Cost and General Borrowing Cost

Lecture 208 Case study Capitalisation of Borrowing cost from general and specific borrowings

Lecture 209 Case Study Treatment of interest

Lecture 210 Case Study Borrowing cost to be capitalised

Lecture 211 Commencement of Capitalisation of Borrowing Cost

Lecture 212 Suspension of Capitalisation of Borrowing Cost

Lecture 213 Cessation of Capitalisation Cost

Lecture 214 Disclosure in Financial Statements

Lecture 215 Case Study - Treatment of Borrowing Cost on Investments

Section 15: AS 17 Segment Reporting

Lecture 216 Introduction to AS 17 Segment Reporting

Lecture 217 Scope of AS 17 Segment Reporting

Lecture 218 Business Segment Defintion as per AS 17

Lecture 219 Geographical Segment & Reportable Segment as per AS 17

Lecture 220 Segment Revenue, Expense & Result

Lecture 221 Segment Assets & Liabilties

Lecture 222 Treatment of Interest for determining Segment Expense

Lecture 223 Allocation to Segment

Lecture 224 Primary and Secondary Segment Reporting Formats

Lecture 225 Matrix Presentation

Lecture 226 Identifying Business & Geographical Segments

Lecture 227 Quantitative Thresholds for Identifying Reportable Segments as per AS 17

Lecture 228 Primary Reporting Format

Lecture 229 Secondary Segment Information

Lecture 230 Other Disclosures required under AS 17

Lecture 231 Segment Report Case Study 1

Lecture 232 Inter-Segment Transfer Pricing Policy Case 2

Lecture 233 Treatement of Deferred Tax Asset in Segment Reporting Case 3

Lecture 234 Preparation of Segmental Report Case 4

Lecture 235 Identifying Business Segments Case 5

Section 16: AS 19 Leases

Lecture 236 Introduction to AS 19 Leases and its applicability

Lecture 237 Non Cancellable Lease and Lease Term - Definition

Lecture 238 Minimum Lease Payments

Lecture 239 Fair Value, Economic Life & Useful Life

Lecture 240 Residual Value, Guaranteed & Unguaranteed Residual Value, Gross Investment in Le

Lecture 241 Unearned Finance Income, Interest rate implicit in lease & Contingent Rent

Lecture 242 Types of Lease

Lecture 243 Indicators of Financial Lease

Lecture 244 Accounting for Financial Lease

Lecture 245 Interest rate implicit in lease & Case Studies

Section 17: AS 20 Earnings Per Share

Lecture 246 Introduction to AS 20

Lecture 247 Important Definitions

Lecture 248 Basic EPS Introduction

Lecture 249 Case 1 Weighted Average No. of Equity Shares

Lecture 250 When shares are included in Denominator?

Lecture 251 Treatment of Partly Paid Equity Shares

Lecture 252 How to calculate EPS in case of Bonus Issue?

Lecture 253 How to calculate EPS in case of Rights Issue?

Section 18: AS 22 Accounting for Taxes on Income

Lecture 254 Introduction

Lecture 255 Matching Concept and Deferred Tax

Lecture 256 Generally Accepted Accounting Practices for Tax Accounting

Lecture 257 Basic Terms Explained

Lecture 258 Accounting Income and Taxable Income

Lecture 259 Impact of Differences

Lecture 260 Deferred Tax Assets and Liabilities

Lecture 261 Reasonable and Virtual Certainity

Lecture 262 Recognition of Deferred Tax

Lecture 263 Deferred Tax Example

Section 19: Q & A Compedium

Lecture 264 Computation of Depreciation

Section 20: Last Section

Lecture 265 Bonus Lecture

CA Intermediate Students,CMA Students,CS Students

Homepage


234preparationofsegmexyce1.jpg






 
Microsoft Access And Microsoft Excel Mastery Bundle 2022

r2jg2l4sipky0jvuaqlzrcedft.jpg


Microsoft Access And Microsoft Excel Mastery Bundle 2022
Last updated 1/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 19.77 GB | Duration: 42h 21m

In this 4-course bundle we combine the power of Excel and Access to help you conquer databases and spreadsheets



What you'll learn
Sorting information and running queries
Creating tables and relationships
Navigating the Access 2016 interface
Design forms and generate reports
Learn valuable new skills for complex data projects at work
Supercharge your database projects
Discover how to into import data from Excel
Learn Queries, use validations, how to create and print reports
How to compact, repair and backup your database
How to create a linked table
Discover how to use the Query Wizard
Learn to use Model Dialog and Macros
Discover how to effectively link to other data sources.
Learn how to split a database by splitting the frontend and backend.
Explore the use of Visual Basic for Applications (VBA).
Discover advanced options for the use of forms.
Dive into options for packaging your application for distribution.
Practice with included Access 2016 exercises files.
Follow along with the instructor with included instructor demostration files.
Discover advanced options and tips for building and using queries.
Follow along as you learn to create and maintain macros.
Complete database projects at the advanced level.
Get helpful techniques that allow you to link, report, and package your data quickly.
Discover new and improved features in Excel 2016.
How to effectively use Excel 2016 on a touchscreen device.
How create, save, and open a workbook.
Learn how to personalize your use of Excel using Excel Options.
How to use and how to customize the Quick Access Toolbar.
Complete data entry, cell formatting, working with multiple worksheets and the "Ribbon" interface.
The basics of entering and editing data in a workbook.
Discover how to format dates and numbers.
Learn practical methods in which you can backup and recover your Excel spreadsheets.
Effectively use autofill and flashfill so you are more productive.
Discover the essentials of using fomulas and functions.
How to rename, insert, move, and reference an Excel 2016 worksheet.
Discover how to create charts and graphs
Learn practical methods to sort and filter your data
How to protect and secure your Excel data
Working with dates and times
Averages, percentiles, and LINEST functions
Calculating depreciation
Using financial functions to determine payments
Sparklines and data bars
How to import and export data to and from Excel
Create and effectively use pivot tables
How to use Excel for data analysis
Discover practical methods for financial & statistical​ Functions

Requirements
A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases.
Microsoft Access 2016
Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer.

Description
**This course includes practice exercises and LIFETIME access**If you need to manipulate large buckets of data and turn them into meaningful business decisions, then this 4-course bundle showing you how to use both Access and Excel to an advanced level is for you.We start with the basics in each program before moving onto more complex functionality such as importing data into Excel from an Access database. Access 2016 Beginners

What you'll learn:What's new in Access 2016How to add records, and save and delete data.Using Access to set-up a database (desktop or web).To explore the Ribbon interface and how to work with touch devices.Create and work with forms and sub-forms.Sorting data in MS Access and running queries in Access.How Macros work in Access 2016 and how to use them.How to import data from external sources.Access 2016 Advanced

What you'll learn:How to effectively link to other data sources outside of AccessHow to split a database by splitting the frontend and backend.Dive into options for packaging your application for distribution.Learn to create, update and maintain macros.Explore the use of Visual Basic for Applications (VBA).Learn the advanced options for forms and queriesExcel 2016 Beginners

What you'll learn:How to get started with workbooks whether using a mouse or touch device.The new and improved features in Excel 2016.How to create sophisticated charts and graphs using custom visuals or templates.How to personalize your use of Excel 2016.To use autofill and flash fill to enter data quickly.How to apply themes and cell styles.Practical methods in which you can backup and recover your Excel spreadsheets.How to format dates and numbersExcel 2016 Advanced

What you'll learn:Advanced 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 ChartsThis bundle includes:4 courses covering Excel & Access 201636 hours of video tutorialsOver 240 individual video lecturesExercise files to practice what you learnedDemo files used by the trainerCertificate of completionHere's what our students are saying."I took this class as a requirement for a new job. I have never touched access before and I was able to pick it up very quickly with this video. The course flowed very nicely and started with the very basic information first before moving on to more complicated tasks. The instructor was very easy to understand and everything was presented at great pace. Since learning how to use access with this class, I have been to create my own database to practice my skills and learn new ones. I would recommend this class to anyone who would like to get a great understanding of access."- Greg Wehner"Time and money well invested! I have been learning by trial and error by myself watching youtube clip. Nevertheless, I never had the impression that I mastered Access or even its basic fundamentals. One day you start to doubt that you may not have the right approach at all. A moment has come to take a break and put the time to learn things well. With this course I feel that I master the basics, but also all the little details very useful that simplifies life. We also learn several tips and tricks to start a project well and avoid getting bogged down later. Above all, I learned a lot of things that I never doubted possible. The instructor is easy to understand and easy to listen to. I devoured the sections without seeing the time pass. In short it is a very complete course and pleasant to follow. I recommend."- Gabriel Beaulieu"Brilliant. Enjoyed it immensely. Learned everything I needed to know."- Brenda BellDid you know?Simon Sez IT teaches all sorts of software, including: - Microsoft Excel- Microsoft PowerPoint - Microsoft Word - Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements - Web Development Languages- And so much more!

Overview

Section 1: Access 2016: Introduction

Lecture 1 Introduction to Access 2016 Course

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Exercise Files

Lecture 4 DOWNLOADND ME: Course Demo Files

Lecture 5 Downloadable Course Transcript

Lecture 6 Acquiring Access 2016

Lecture 7 Structure of the Course

Lecture 8 What's New in Access 2016

Section 2: Access 2016: Using Touch

Lecture 9 Using Access in a Touch Device

Section 3: Access 2016: Getting Started

Lecture 10 Using Database Templates

Lecture 11 Creating, Saving, and Opening Databases

Lecture 12 The Access Workspace and Backstage

Section 4: Access 2016: Help

Lecture 13 Online Help and Tell Me

Section 5: Access 2016: The Ribbon and Toolbars

Lecture 14 The Ribbon

Lecture 15 The Quick Access Toolbar

Lecture 16 Contextual Menus

Section 6: Access 2016: Keyboard Shortcuts and Key Tips

Lecture 17 The Status Bar

Lecture 18 Keyboard Shortcuts

Lecture 19 Key Tips

Section 7: Access 2016: Access Options

Lecture 20 General, Current Databases, and Language Options

Section 8: Access 2016: Tables

Lecture 21 Creating a Table and Fields

Lecture 22 Indexed Field

Lecture 23 Lookup Wizard

Lecture 24 Numeric Fields

Lecture 25 Exercise 01

Section 9: Access 2016: Importing Data

Lecture 26 Importing Data from Excel

Lecture 27 Excercise 02

Section 10: Access 2016: Backup, Restore, and Repair

Lecture 28 Backing up your Database

Lecture 29 Compact and Repair

Section 11: Access 2016: Datasheet View

Lecture 30 Design in the Datasheet View

Lecture 31 Sorting and Filtering in Datasheet View

Lecture 32 Entering and Modifying Data in Datasheet View

Section 12: Access 2016: Relationships

Lecture 33 Creating a Link Table

Lecture 34 Setting up Relationships

Lecture 35 Exercise 03

Section 13: Access 2016: Forms

Lecture 36 Creating a Form

Lecture 37 Modifying a Form

Lecture 38 Exercise 04

Lecture 39 Forms in Layout View

Lecture 40 Forms in Design View

Lecture 41 Form Design

Lecture 42 Exercise 05

Section 14: Access 2016: Subforms

Lecture 43 Setting up Subforms - Part 1

Lecture 44 Setting up Subforms - Part 2

Lecture 45 Setting up Subforms - Part 3

Lecture 46 Exercise 06

Section 15: Access 2016: Queries

Lecture 47 Creating a Query

Lecture 48 Joins

Lecture 49 Query Wizard

Lecture 50 Exercise 07

Section 16: Access 2016: Expressions

Lecture 51 Setting up Validations

Lecture 52 Calculation using Expressions

Section 17: Access 2016: Reports

Lecture 53 Basic Report

Lecture 54 Report Design

Lecture 55 Complex Report

Lecture 56 Exercise 08

Section 18: Access 2016: Printing

Lecture 57 Printing and Print Properties

Section 19: Access 2016: More Data Types

Lecture 58 Yes/No, OLE Object, and Hyperlink Data Types

Section 20: Access 2016: More About Forms

Lecture 59 Form Controls

Lecture 60 Form Themes

Lecture 61 Form Navigation

Section 21: Access 2016: Modal, Dialogs, and Macros

Lecture 62 Introduction to Model Dialog and Macros

Lecture 63 Model Dialog and Macros Continued

Lecture 64 Form Validation

Lecture 65 Adding a Command Button to a Form

Lecture 66 Exercise 09

Section 22: Access 2016: Web App Basics

Lecture 67 Creating an Access Web App

Lecture 68 Importing an Access Database to a Web App

Lecture 69 Exercise 10

Section 23: Access 2016: Exporting

Lecture 70 Exporting an Access Database

Section 24: Access 2016: Application Parts

Lecture 71 Adding Application Parts to a Database

Section 25: Access 2016: More Access Options

Lecture 72 Additional Access 2016 Options

Section 26: Access 2016: Info Tab

Lecture 73 View and Edit Database Properties, and Encrypt with Password

Section 27: Access 2016: Security

Lecture 74 Trust Center Settings

Section 28: Access 2016: Conclusion

Lecture 75 Closing

Section 29: Access 2016 Advanced - Introduction to Microsoft Access 2016 Advanced

Lecture 76 Course Overview and Content

Lecture 77 WATCH ME: Essential Information for a Successful Training Experience

Lecture 78 DOWNLOAD ME: Course Exercise Files

Lecture 79 DOWNLOAD ME: Course Demo Files

Section 30: Access 2016 Advanced: Primary Keys and Indexes

Lecture 80 Primary Keys and Indexing Rules and Guidelines

Lecture 81 More About Indexes

Section 31: Access 2016 Advanced: Using Datasheet View

Lecture 82 Setting Up Northwind Database

Lecture 83 Working in a Datasheet View

Lecture 84 Customizing Datasheet View and Advanced Sorting and Filtering

Lecture 85 Subdatasheets

Lecture 86 Exercise 01

Section 32: Access 2016 Advanced: Linking to Other Access Databases

Lecture 87 Linking Two Tables to Other Access Databases

Section 33: Access 2016: Using ODBC and SQL Server

Lecture 88 Acquiring and Installing SQL Server Express

Lecture 89 Setting Up SQL Server Database

Lecture 90 Exercise 2

Section 34: Access 2016 Advanced: Splitting An Access Database

Lecture 91 Splitting an Access Database into Front-end and Back-end Databases

Lecture 92 Converting Shared Table into Local Table; Moving Back-end Database

Lecture 93 Exercise 03

Lecture 94 Addressing Multi-users Issues When Sharing Data

Section 35: Access 2016 Advanced: Macros

Lecture 95 Basics of Macros

Lecture 96 Macros on Events; AutoExec

Lecture 97 More About AutoExec; Bypassing AutoExec

Lecture 98 Macro Security Settings

Lecture 99 Exercise 04

Section 36: Access 2016 Advanced: The Ribbon

Lecture 100 Customizing the Ribbon and Quick Access Tool

Section 37: Access 2016 Advanced: Visual Basic for Applications in Access 2016

Lecture 101 Convert Macros to VBA; VBA Editor and Property Windows

Lecture 102 VBA Modules; Running Code and Error Handling

Lecture 103 Creating Modules; Subs, Functions, Intellisense and Variables

Lecture 104 Scope, Variable Naming and Strings

Lecture 105 Standard Functions; Logical, Case and Loop Statements

Section 38: Access 2016 Advanced: Access Events Model

Lecture 106 Adding Events to Assets Database

Lecture 107 Exercise 05

Lecture 108 Common Events; Form and Report Events

Lecture 109 Switchboard and Navigation Form; Error Handling

Lecture 110 Exercise 06

Section 39: Access 2016 Advanced: Forms

Lecture 111 Formatting Bound and Control Form

Lecture 112 Split Forms; Macro Error Handling

Lecture 113 Creating Form with Tab

Lecture 114 Go To Combo Box and Its Properties

Lecture 115 Exercise 07

Section 40: Access 2016: Advanced Use of Queries

Lecture 116 Basic of Queries: Review

Lecture 117 Syntax of SQL Statements

Lecture 118 Use of Multiple Where Criteria & Select Statements Function

Lecture 119 Joins and Its Types

Lecture 120 Exercise 08

Lecture 121 Action Queries - Part 1

Lecture 122 Action Queries - Part 2

Lecture 123 Subqueries

Section 41: Access 2016 Advance: Packaging Your Application

Lecture 124 Steps in Packaging Access Application

Lecture 125 Exercise 09

Section 42: Access 2016 Advanced: Conclusion

Lecture 126 Online Support and Conclusion

Section 43: Excel 2016: Introduction to Excel 2016 Beginner Course

Lecture 127 Introduction

Lecture 128 WATCH ME: Essential Information for a Successful Training Experience

Lecture 129 DOWNLOAD ME: Course Exercise Files

Lecture 130 DOWNLOAD ME: Course Demo Files

Lecture 131 Downloadable Course Transcript

Lecture 132 Exercise Files

Section 44: Excel 2016: What's New

Lecture 133 New and Improved Features in Excel 2016

Section 45: Excel 2016: Using Touch

Lecture 134 Overview of Principles of Using Touchscreen

Section 46: Excel 2016: Getting Started

Lecture 135 Creating and Saving a Workbook

Lecture 136 Opening a Workbook

Section 47: Excel 2016: Using Help

Lecture 137 Online Help and Contextual Help

Section 48: Excel 2016: Excel Options

Lecture 138 Personalizing your use of Excel

Section 49: Excel 2016: The Ribbon and Toolbars

Lecture 139 Basics of using the Ribbon

Lecture 140 Quick Access Toolbar

Lecture 141 Tell Me Feature

Lecture 142 Mini Toolbars and Contextual Menus

Lecture 143 Status Bar

Section 50: Excel 2016: Entering and Editing Data

Lecture 144 Basics of Entering and Editing Data in a Workbook

Lecture 145 Exercise 01

Lecture 146 Formatting Dates

Lecture 147 Formatting Numbers

Lecture 148 Exercise 02

Section 51: Excel 2016: Backup and Recovery

Lecture 149 AutoSave, Recover Unsaved Workbook, and Create a Backup Copy

Section 52: Excel 2016: Fill and Series

Lecture 150 Working with Fill and Series

Lecture 151 Flash Fill

Section 53: Excel 2016: Viewing and Printing

Lecture 152 Workbook Views, Zoom, and Freeze

Lecture 153 Printing

Lecture 154 Exercise 03

Section 54: Excel 2016: Cut, Copy, and Paste

Lecture 155 Methods of Cutting, Copying, and Pasting

Section 55: Excel 2016: Formatting a Worksheet

Lecture 156 Delete and Clear

Lecture 157 Insert, Hide, Column Width and Row Height, and Merge

Lecture 158 Alignment

Lecture 159 Themes and Styles

Lecture 160 Exercise 04

Section 56: Excel 2016: Formulas and Functions

Lecture 161 Basics of Fomulas and Functions

Lecture 162 Complex Examples of Formulas

Lecture 163 Exercise 05

Section 57: Excel 2016: Managing Worksheets

Lecture 164 Managing Worksheets

Section 58: Excel 2016: Working with Multiple Workbooks

Lecture 165 Working with Multiple Workbooks

Section 59: Excel 2016: Saving Workbooks

Lecture 166 Saving in Different File Types

Section 60: Excel 2016: Proofing

Lecture 167 The Spell Checker

Section 61: Excel 2016: Inserting Comments

Lecture 168 Inserting Comments

Lecture 169 Exercise 06

Section 62: Excel 2016: Basic Functions in Excel

Lecture 170 The VLOOKUP Function

Lecture 171 Text Functions

Lecture 172 Date and Time Functions

Lecture 173 Logical Functions

Section 63: Excel 2016: Graphs and Charts

Lecture 174 Creating Graphs and Charts

Lecture 175 Customizing a Cluster Column Chart

Lecture 176 Customizing a Pie Chart

Lecture 177 New Chart Types in Excel 2016

Lecture 178 Exercise 07

Section 64: Excel 2016: Sorting and Filtering Data

Lecture 179 Managing Data by Sorting

Lecture 180 Managing Date by Filtering

Lecture 181 Customizing Tables

Section 65: Excel 2016: Shapes and Pictures

Lecture 182 Inserting Shapes and Pictures

Lecture 183 Exercise 08

Section 66: Excel 2016: Formatting Cells Based on Content

Lecture 184 Conditional Formatting

Section 67: Excel 2016: Protection and Security

Lecture 185 Protecting Worksheets

Lecture 186 Protecting Workbooks

Section 68: Excel 2016: Naming Items

Lecture 187 Giving Items Names

Lecture 188 Exercise 09

Section 69: Excel 2016: Finding and Replacing Words

Lecture 189 Find and Replace

Section 70: Excel 2016: Borders

Lecture 190 Adding Borders

Section 71: Excel 2016: Workbook Inspection

Lecture 191 Inspecting a Workbook

Section 72: Excel 2016: Privacy Options

Lecture 192 Trust Center Privacy Options

Section 73: Excel 2016: Sharing Options

Lecture 193 Sharing a Workbook

Section 74: Excel 2016: Wrap Up

Lecture 194 Closing

Section 75: Excel 2016 Advanced: Introduction to Excel 2016 Advanced Course

Lecture 195 Prerequisites of the Course and Version of Excel

Lecture 196 WATCH ME: Essential Information for a Successful Training Experience

Lecture 197 DOWNLOAD ME: Course Exercise Files

Lecture 198 DOWNL:OAD ME: Course Demo Files

Lecture 199 Downloadable Course Transcript

Lecture 200 Course Structure

Section 76: Excel 2016 Advanced: Functions

Lecture 201 Functions - Part 1

Lecture 202 Functions - Part 2

Lecture 203 Autosum

Section 77: Excel 2016 Advanced: Date and Time Functions

Lecture 204 How Date and Time Works

Lecture 205 Basic Date and Time Functions

Lecture 206 Complex Date and Time Functions

Section 78: Excel 2016 Advanced: Text Functions

Lecture 207 Using Text Functions - Part 1

Lecture 208 Using Text Functions - Part 2

Section 79: Excel 2016 Advanced: Logical Functions

Lecture 209 Using Logical Functions

Lecture 210 Exercise 01

Section 80: Excel 2016 Advanced: Lookup Functions

Lecture 211 HLOOKUP Function

Lecture 212 VLOOKUP Function

Lecture 213 Exercise 02

Section 81: Excel 2016 Advanced: Financial Functions

Lecture 214 Financial Functions and Terminology

Lecture 215 Personal Financial Functions

Lecture 216 Professional Financial Functions

Lecture 217 Depreciation

Lecture 218 Exercise 03

Section 82: Excel 2016 Advanced: Statistical Functions

Lecture 219 Statistical Functions for Description - Part 1

Lecture 220 Statistical Functions for Description - Part 2

Lecture 221 Statistical Functions for Forecasting - Part 1

Lecture 222 Statistical Functions for Forecasting - Part 2

Lecture 223 Exercise 04

Lecture 224 One Click Forecasting

Lecture 225 Statistical Functions for Inference

Section 83: Excel 2016 Advanced: Connecting to External Data

Lecture 226 Connecting to Other Workbooks

Lecture 227 Connecting to Access Databases

Lecture 228 Connecting to Web Data Sources

Lecture 229 Get and Transform

Lecture 230 Exercise 05

Section 84: Excel 2016 Advanced: Tables

Lecture 231 Introduction to Tables

Lecture 232 Working with Tables

Lecture 233 Table References

Lecture 234 Table Styles

Lecture 235 Exercise 06

Section 85: Excel 2016 Advanced: Pivot Tables

Lecture 236 Introduction to Pivot Tables

Lecture 237 Working with Pivot Tables

Lecture 238 Filters and Slicers

Lecture 239 Pivot Charts

Lecture 240 Exercise 07

Section 86: Excel 2016 Advanced: Data Analysis

Lecture 241 What If Analysis

Lecture 242 Scenario Manager

Lecture 243 Goal Seek

Lecture 244 Solver

Lecture 245 Exercise 08

Section 87: Excel 2016 Advanced: Graphs and Charts

Lecture 246 Area Charts

Lecture 247 Surface Charts

Lecture 248 Radar Charts

Lecture 249 Bubble Charts

Lecture 250 Sparklines

Lecture 251 Stock Charts

Lecture 252 Exercise 09

Section 88: Excel 2016 Advanced: Excel Web App

Lecture 253 Web App - Part 1

Lecture 254 Web App - Part 2

Section 89: Excel 2016 Advanced: Conclusion

Lecture 255 Closing Message

Section 90: Extras

Lecture 256 EXTRA LESSON: Designing Better Spreadsheets Webinar Recording

Lecture 257 EXTRA LESSON: Data Cleaning in Excel Webinar Recording

Lecture 258 EXTRA LESSON: Top Ten Excel Functions You HAVE to Know Webinar Recording

Lecture 259 EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic

Lecture 260 EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic

Anyone new to Microsoft Access,Users new to Microsoft Access 2016 and those upgrading from previous software versions,Anyone new to the data management role,Anyone who wants to learn data management and Microsoft Access,Users of earlier versions of Excel looking to update their skills.,Those new to using Microsoft Excel 2016.,Users who have a foundation of Microsoft Excel and seeking to take advance there Excel 2016 knowledge.,If you want to refresh your memory and understanding of Excel.

Homepage


49querywizards96dl4.jpg










 
Financial Management For Ca Inter Exams (Icai New Syllabus)

qvk0iwhmmcnbp7atnerrtv9cjq.jpg


Financial Management For Ca Inter Exams (Icai New Syllabus)
Last updated 6/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 22.20 GB | Duration: 47h 50m

A Complete Course on Financial Management following ICAI New Syllabus



What you'll learn
Appear confidently for CA Inter Exams

Requirements
Basic knowledge of Accounting

Description
Welcome to this course "Financial Management for CA Inter Exams (ICAI New Syllabus)"
Financial Management is one of the scoring paper in CA Intermediate Examination. However, many students do not realise that. Due to lack of practice, they stamp this subject as complicated / toughest. Worry not!!!
Let us crack this subject with more practice. This course is structured to teach you Financial Management Chapter by Chapter strictly as per New Syllabus prescribed by ICAI (60 Marks).
Each and every chapter in this course will cover Theory and Practical Parts. Many past examination problems and study material problems will be discussed in this course. As you know, entire syllabus has been divided into 11 Chapters. They are
Chapter 1 Scope and Objectives of Financial Management
Chapter 2 Types of Financing
Chapter 3 Financial Analysis and Planning - Ratio Analysis
Chapter 4 Cost of Capital
Chapter 5 Financing Decisions - Capital Structure
Chapter 6 Financing Decisions - Leverages
Chapter 7 Investment Decisions
Chapter 8 Risk Analysis in Capital Budgeting
Chapter 9 Lease Financing
Chapter 10 Dividend Decisions
Chapter 11 Management of Working Capital
You will see all the above chapters will be discussed as 11 Sections in this course.
This course is structured in self paced learning style. Do carry a note book & pen or open an excel to simultaneously practice problems. Listen with headset for effective learning.
See you inside the course.
DISCLAIMER: This course is designed exclusively for students taking CA Inter Examination of ICAI. Many of the lectures in this course have been picked from two other courses namely Financial Management A Complete Study and Advanced Financial Management A Complete Study to meet the syllabus requirements. Several additional lectures have also been included. Hence, take this course only if you want to study Financial Management exactly as per new syllabus of ICAI. Kindly go through course curriculum before purchasing. VIDEO UPLOAD STATUS: This course will have 400+ Video Lectures and all lectures will be uploaded on or before 30th April 2018

Overview

Section 1: Introduction to Financial Management

Lecture 1 Introduction to Financial Management

Lecture 2 Meaning of Financial Management

Lecture 3 Procurement of Funds

Lecture 4 Effective Utilisation of Funds

Lecture 5 Evolution of Financial Management

Lecture 6 Finance Functions or Decisions

Lecture 7 Importance of Financial Management

Lecture 8 Scope of Financial Management

Lecture 9 Profit Maximisation as Objective of Financial Management

Lecture 10 Weath Maximisation as Objective of Financial Mangement

Lecture 11 Conflict in Profit Vs Wealth Maximisation

Lecture 12 Role of finance executive

Lecture 13 Role of CFO : Now and Past

Lecture 14 Financial Distress & Insolvency

Lecture 15 Relationship of financial management with related discipliness

Lecture 16 Financial Management & Accounting

Lecture 17 Financial management & other Disciplines

Lecture 18 Agency problem & Agency cost

Section 2: Financial Analysis

Lecture 19 Introduction to Financial Statements

Lecture 20 Statement of Profit and Loss

Lecture 21 Balance Sheet

Lecture 22 Preparing Financial Statements

Lecture 23 Difference Between Income, Expense, Asset, Liability, Profit & Cash

Lecture 24 Introduction to Ratio Analysis (Talking Head)

Lecture 25 Classification of Ratio (Talking Head)

Lecture 26 Introduction to Liqudity Ratio (Talking Head)

Lecture 27 Classification of Liqudity Ratio (Talking Head)

Lecture 28 Current Ratio (Talking Head)

Lecture 29 Quick Ratio (Talking Head)

Lecture 30 Ideal Current Ratio and Quick Ratio (Talking Head)

Lecture 31 Absolute liqudity Ratio (Talking Head)

Lecture 32 Basic Defense interval Ratio (Talking Head)

Lecture 33 Capital Structure Ratios (Talking Head )

Lecture 34 Turn over Ratio (Talking Head )

Lecture 35 Inventory Turn over Ratio (Talking Head )

Lecture 36 Debtors Turn over Ratio (Talking Head)

Lecture 37 Creditors Turn over Ratio (Talking Head)

Lecture 38 Inventory Holding Period (Talking Head)

Lecture 39 Creditors Payment Period (Talking Head)

Lecture 40 Debtors Collection Period (Talking Head)

Lecture 41 Case Study 1 Ratio Analysis (Talking Head)

Lecture 42 Case Study 2 Ratio Analysis (Talking Head)

Lecture 43 Case Study 3 Ratio Analysis (Talking Head)

Lecture 44 Case Study 4 Ratio Analysis (Talking Head)

Lecture 45 Debt Service Coverage Ratio (Talking Head)

Lecture 46 Interest Coverage Ratio (Talking Head)

Lecture 47 Preference Dividend Coverage Ratio (Talking Head)

Lecture 48 Capital Gearing Ratio (Talking Head)

Lecture 49 Profitability Ratio (Talking Head)

Lecture 50 General Profitability Ratio (Talking Head)

Lecture 51 Return on Investment Ratios (Talking Head)

Lecture 52 Various Ratio for Equity Share holders (Talking Head)

Lecture 53 Market Value Ratios (Talking Head)

Lecture 54 Summary and limitation of Ratio Analysis (Talking Head)

Lecture 55 Case Study 5 Ratio Analysis (Talking Head)

Lecture 56 Case Study 6 Ratio Analysis (Talking Head)

Lecture 57 Case Study 7 Ratio Analysis (Talking Head)

Lecture 58 Case Study 8 Ratio Analysis (Talking Head)

Lecture 59 Liquidity ratios case study1

Lecture 60 Interest Coverage Ratio Case Study 3

Lecture 61 Liquidity ratios case study 2

Lecture 62 Proprietary Funds Case Study 4

Lecture 63 Return on Asset Case Study 5

Lecture 64 Stock Turnover Case Study 6

Lecture 65 Equity Share Holders Ratios Case Study 7

Lecture 66 Ratio Analysis - Detailed Case Study 8

Lecture 67 Ratio Analysis - Detailed Case Study 9

Lecture 68 Case Study Ratio Analysis

Section 3: Cost of Capital

Lecture 69 Introduction to cost of Capital (Talking Head)

Lecture 70 Approach to Cost of Capital (Talking Head)

Lecture 71 Cost of Debt (Talking Head)

Lecture 72 Cost of Preference Share (Talking Head)

Lecture 73 Cost of Equity (dividend model) (Talking Head)

Lecture 74 Cost of Equity (CAPM) (Talking Head)

Lecture 75 Case Study 1 Cost of Redeemable Debenture (Talking Head)

Lecture 76 Case Study 2 Cost of Redeemable Debenture (Talking Head)

Lecture 77 Case Study 3 Cost of Equity (Talking Head)

Lecture 78 Case Study 4 Cost of debenture (Talking Head)

Lecture 79 Case Study 5 Cost of Preference and Equity (talking Head)

Lecture 80 Earning Price Approach (Talking Head)

Lecture 81 Realised Yield Approch (Talking Head)

Lecture 82 Case Study 6 Cost of Equality(CAPM) (Talking Head)

Lecture 83 Cost of Retained Earnings (Talking Head)

Lecture 84 Weighted Average Cost of Capital (Talking Head)

Lecture 85 Case Study 1 Weighted Average Cost of Capital (Talking Head)

Lecture 86 WACC (Market Value) (Talking Head)

Lecture 87 Case Study 2 WACC (Book Value and Market Value) (Talking Head)

Lecture 88 Case Study 3 WACC(Additonal Finance) (Talking Head)

Lecture 89 Marginal Cost of Capital (Talking Head)

Lecture 90 Case 4 WACC(BV,MV,MCC) (Talking Head)

Lecture 91 Case 5 WACC(Book value and Market value) (Talking Head)

Lecture 92 Case 6 WACC(Including Marginal cost of capital) (Talking Head)

Lecture 93 Case 7 WACC(Including Marginal cost of capital) (Talking Head)

Section 4: Capital Structuring Decisions

Lecture 94 Introduction to Capital Structure Decision (Talking Head)

Lecture 95 Business Financing Decisions

Lecture 96 Debt Vs Equity Financing Decision

Lecture 97 Good Time and Bad Time for Debt Equity Funding

Lecture 98 Capital Structure

Lecture 99 Capital Structure (Talking Head)

Lecture 100 Capital Structure Mix (Talking Head)

Lecture 101 Factors of Capital Structure Mix (Talking Head)

Lecture 102 Desining Optimal Capital Structure (Talking Head)

Lecture 103 Capital Structure Case Study 1(Talking Head)

Lecture 104 Capital Structure Case Study 2 (Talking Head)

Lecture 105 Capital Structure Case Study 3 (Talking Head)

Lecture 106 Capital Structuring Case Study 4

Lecture 107 Case Study on Capital Structuring and Tax Shield

Lecture 108 Indifference Point - Taking Head

Lecture 109 Indifferent Point Case Study 1 - Talking Head

Lecture 110 Indifference and Financial Break Even Point Case Study 2 - Talking Head

Lecture 111 Indifference point chart case study - Talking Head

Lecture 112 Financial Break Even and Indifference Analysis

Lecture 113 Capital Structure Theories - Net Income Approach

Lecture 114 Capital Structure Theories - Net Operating Income Approach

Lecture 115 Net Income Approach Problem

Lecture 116 Capital Structure Theories - Traditional Approach

Lecture 117 Capital Structure Theories - MM Approach and Arbitrage Case Study

Lecture 118 Case study on Arbitrage

Lecture 119 Introductory Problem on Capital Structuring

Lecture 120 Introductory Problem on IDP

Lecture 121 Problem on EPS EBIT IDP

Lecture 122 Problem on IDP with Chart

Lecture 123 Optimal Capital Structure

Lecture 124 Problem on EPS and Capital Structuring

Lecture 125 Problem on EPS and Financing Alternatives

Lecture 126 Problem on IDP

Section 5: Leverage

Lecture 127 Introduction to Leverage (Talking Head)

Lecture 128 Leverage Formula (Talking Head)

Lecture 129 Leverage Analysis Case Study 1 (Talking Head)

Lecture 130 Leverage Analysis Case Study 2 (Talking Head)

Lecture 131 Leverage Analysis Case Study 3 (Talking Head)

Lecture 132 Leverage and its Types

Lecture 133 Leverage Concept Example

Lecture 134 Leverage Analysis and Sales Movement

Lecture 135 Case Study 1 on Degree of Leverage

Lecture 136 Case Study 2 bon Degree of Operating Leverage

Lecture 137 Case Study 3 on Degree of Leverage

Lecture 138 Case Study 4 on Degree of Leverage

Section 6: Investment Decisions

Lecture 139 Why Capital Budgeting (Talking Head)

Lecture 140 Importance of Capital Investment (Talking Head)

Lecture 141 Capital Budgeting Process (Talking Head)

Lecture 142 Capital Budgeting Process (PPT Based Lecture)

Lecture 143 Types of Capital Investment Decisions (Talking Head)

Lecture 144 Project Cashflows (Talking Head)

Lecture 145 Initial Cashflow (Talking Head)

Lecture 146 Computation of Operational Cashflows(Share holders point of view) (Talking Head)

Lecture 147 Operational Cashflows (Lenders) (Talking Head)

Lecture 148 Terminal Cashflow (Talking Head)

Lecture 149 Principle for Measuring Project Cashflows (Talking Head)

Lecture 150 Case Study Cashflows (Talking Head)

Lecture 151 Project Cash Flows (PPT Based)

Lecture 152 Types of Capital Investment Decisions (PPT Based)

Lecture 153 Principles for Measuirng Project Cash Flows (PPT Based)

Lecture 154 Problems on Meauring cash flows (PPT Based)

Lecture 155 Problem Measuring Cash Flows (PPT Based)

Lecture 156 Cashflow computation (Excel Based)

Lecture 157 Cash Flow Perspective (Excel Based)

Lecture 158 Capital Budgeting Tools - Taking Head

Lecture 159 Payback period - Talking Head

Lecture 160 Pay Back Reciprocal (Talking Head)

Lecture 161 PayBack Period Case Study 1 - Taking Head

Lecture 162 PayBack Period Case Study 2 - Taking Head

Lecture 163 Accounting Rate of Return (Talking Head)

Lecture 164 Accounting Rate of Return (PPT Based)

Lecture 165 Capital Budgeting Techniques (PPT Based)

Lecture 166 Pay Back Period Introduction (PPT Based)

Lecture 167 Pay Back Period Example (PPT Based)

Lecture 168 Problem on Pay Back Period (PPT Based)

Lecture 169 Payback Reciprocal (PPT Based)

Lecture 170 Discounted Payback Period (Talking Head)

Lecture 171 Case Study 1 Discounted Payback (Talking Head)

Lecture 172 Case Study 2 Discounted Payback (Talking Head)

Lecture 173 Discounted Pay Back Period Method (PPT Based)

Lecture 174 Introduction to NPV (Talking Head)

Lecture 175 Case Study 1 NPV (Talking Head)

Lecture 176 Case Study 2 NPV (Talking Head)

Lecture 177 Case Study 3 NPV (Talking Head)

Lecture 178 Case Study 4 NPV (Talking Head)

Lecture 179 Case Study 5 NPV (Talking Head)

Lecture 180 Case Study 6 NPV (Talking Head)

Lecture 181 Case Study 7 NPV (Talking Head)

Lecture 182 Profitability Index Method (Talking Head)

Lecture 183 Case Study 1 Profitability Index (Talking Head)

Lecture 184 Case Study 2 Trial and Error Method (Talking Head)

Lecture 185 Equivalent Annual Flow Method (Talking Head)

Lecture 186 Equivalent Annual CF

Lecture 187 Introduction to Internal Rate of Return (Talking Head)

Lecture 188 How to find IRR (Talking Head)

Lecture 189 Case Study 1 IRR (Talking Head)

Lecture 190 Case Study 2 IRR (Talking Head)

Lecture 191 Case Study 3 IRR (Talking Head)

Lecture 192 Comphrehensive Case Study (NPVand IRR) (Talking Head)

Lecture 193 Case Study (Conflict between NPVand IRR) (Talking Head)

Lecture 194 NPV

Lecture 195 NPV Technique

Lecture 196 Advantages and Disadvantages of NPV

Lecture 197 Case Study 1 NPV

Lecture 198 Problem NPV Ranking

Lecture 199 Problem NPV (Cash Flows Derivation)

Lecture 200 NPV Case Study

Lecture 201 Problem NPV of Different Projects

Lecture 202 NPV Incremental Discount Rate Case Study

Lecture 203 Problem NPV and Capital Rationing

Lecture 204 New Case Study on NPV

Lecture 205 NPV Case Study on Tax Savings

Lecture 206 NPV Case Study 2 on Tax Savings

Lecture 207 NPV Case Study (opportunity Cost)

Lecture 208 NPV Case Study (Projects with different life period)

Lecture 209 Abandonment Decision in Replacement

Lecture 210 Replacement Decision

Lecture 211 Aggregate Cash Flow Method in Replacement

Lecture 212 Incremental Cash Flow Method in Replacement

Lecture 213 Replacement Analysis Case Study 1

Lecture 214 Replacement Analysis Case Study2

Lecture 215 Replacement Analysis Case Study3

Lecture 216 Replacement Analysis Case Study 4

Lecture 217 IRR Introduction

Lecture 218 Advantages and Disadvantages of IRR

Lecture 219 Modified Internal Rate of Return (Talking Head)

Lecture 220 Case Study 1 MIRR (Talking Head)

Lecture 221 Modified IRR

Lecture 222 IRR Simple Case Study

Lecture 223 IRR Simple Case Study 2

Lecture 224 Problem 1 IRR

Lecture 225 Problem 2 IRR

Lecture 226 Problem 3 IRR ARR NPV and Ranking

Lecture 227 Problem 4 IRR DPB PI and Ranking

Lecture 228 Problem 5 PB IRR ARR NPV and Ranking

Lecture 229 Problem 6 IRR Mutually Exclusive Projects and Reinvestment

Lecture 230 Problem 7 NPV and IRR Suitability

Lecture 231 Project and Equity IRR

Lecture 232 Profitability Index

Lecture 233 Case 1 Profitability Index

Lecture 234 Case Study on Profitability Index

Lecture 235 Equivalent Annual Cost Case Study

Lecture 236 Comprehensive Case Study on NPV

Lecture 237 Case Study on Cash Flow Computation in Capital Budgeting

Lecture 238 Case Study on NPV

Section 7: Risk Analysis

Lecture 239 Risk and Uncertainity

Lecture 240 Case Study Risk Uncertainity

Lecture 241 Probability and PD

Lecture 242 Expected Value

Lecture 243 Case study EV

Lecture 244 Standard Deviation

Lecture 245 Steps in Computing Standard Deviation

Lecture 246 Standard Deviation - Simple Case Study

Lecture 247 SD in Decision Making

Lecture 248 Case Stdy SD Decision Making

Lecture 249 Risk Adjusted Discount Rate

Lecture 250 Case Study RADR

Lecture 251 Case Study 2 RADR

Lecture 252 Certainity Equivalent Factor

Lecture 253 Certainity Equivalent Factor Example

Lecture 254 Case Study Certainity Equivalent Factor

Lecture 255 Decision Tree Introduction

Lecture 256 Stages and Rules

Lecture 257 Evaluation rules

Lecture 258 Case Study 1 Decision Tree

Lecture 259 Case Study 2 Decision Tree

Lecture 260 Decision Tree Comprehensive Case Study

Lecture 261 Simulation Introduction

Lecture 262 Simulation eg

Lecture 263 Simulation steps

Lecture 264 Case Study Simulation

Lecture 265 Hilliers Model

Lecture 266 Hillier Case Study part 1

Lecture 267 Hillier Case Study part 2

Lecture 268 Sensitivity Analysis

Lecture 269 Case Study Sensitivity Analysis

Lecture 270 Comprehensive Case Study on Sensitivity Analysis

Lecture 271 Scenario Analysis Introduction

Lecture 272 Steps in Scenario Analysis

Lecture 273 Case Study 1 Scenario Analysis

Lecture 274 Case Study 2 Part 1 Scenario Analysis

Lecture 275 Case Study 2 part 2 Scenario Analysis

Section 8: Lease Financing

Lecture 276 Introduction

Lecture 277 Leasing Fundamentals

Lecture 278 Leasing Mechanism

Lecture 279 Leasing Edge

Lecture 280 Evaluation of Lease

Lecture 281 Lease Rental - Case Study 1

Lecture 282 Lease Rental - Case Study 2

Lecture 283 Lease Rental - Case Study 3

Lecture 284 Lease Rental - Case Study 4

Lecture 285 Determing Maximum Lease Rental Case Study 5

Lecture 286 Indifference Point between Lease and Loan Case Study 6

Lecture 287 Lease Evaluation Case Study 6

Lecture 288 Weingartners Model

Lecture 289 Bower Herringer Williamson Model

Lecture 290 Bower Herringer Williamson Model Case Study 7

Lecture 291 Sale and Lease Back Case Study 8

Section 9: Dividend Decision - A Comprehensive Study

Lecture 292 Introduction to dividend

Lecture 293 Case Study on Basic terms of dividend

Lecture 294 Dividend Dates

Lecture 295 Case Study Dividend Dates

Lecture 296 Dividends and Market Price

Lecture 297 Dividend Policy

Lecture 298 Common Sense Approach

Lecture 299 Dividend Models

Lecture 300 Walter Model

Lecture 301 Walter Model Case Study

Lecture 302 Lintner model

Lecture 303 Lintner model Case study

Lecture 304 MM Model

Lecture 305 MM Model Formula

Section 10: Working Capital

Lecture 306 Introduction to Working Capital Management (Talking Head)

Lecture 307 Working Capital Introduction (Talking Head)

Lecture 308 Importance of Adequate Working Capital (Talking Head)

Lecture 309 Optimum Working capital (Talking Head)

Lecture 310 Current Asset to Fixed Asset Ratio (Talking Head)

Lecture 311 Case 1 Current Asset to Fixed Asset Ratio (Talking Head)

Lecture 312 Working Capital Cycle (Talking Head)

Lecture 313 Holding Period Computation (Talking Head)

Lecture 314 Case 2 Working Capital Cycle (Talking Head)

Lecture 315 Double Shift Working And Its Impact on Working Capital (Talking Head)

Lecture 316 Case 3 Double Shift Working And Its Impact on Working Capital (Talking Head)

Lecture 317 Introduction to Working Capital Management

Lecture 318 Optimum Working Capital

Lecture 319 Current Assets to Fixed Asset Ratio and Liquidity Vs Profitability

Lecture 320 Example for Liquidity Vs Profitability

Lecture 321 Working Capital Cycle Introduction

Lecture 322 Holding Period Computation

Lecture 323 Case 2 on Estimation of Working Capital

Lecture 324 Case 3 on Estimation of Working Capital on Cash Cost Basis

Lecture 325 Case 4 on Working Capital estimation on cash cost basis

Lecture 326 Case Study 8 on Working Capital

Lecture 327 Case Study 9 on Estimation of Working Capital

Lecture 328 Case Study 10 on Estimation of Working Capital

Lecture 329 Case Study 11 Estimation of Working Capital

Lecture 330 Treasury and Cash Management

Lecture 331 Management of Cash Collection and Disbursements

Lecture 332 Different Kinds of Float

Lecture 333 Lock Box System

Lecture 334 Miller Orr Cash Management Model 1966

Lecture 335 Opitmum Cash Balance

Lecture 336 Management of Marketable Securities

Lecture 337 Management of Payables

Lecture 338 Management of Receivables

Lecture 339 Monitoring of Receivables

Lecture 340 Innovations in Receivable Management

Lecture 341 Case Study 12 Credit Period Extension

Lecture 342 Case Study 13 Evaluation of Credit Policy

Lecture 343 Case Study 18 Debtors Funding option

Lecture 344 Pledging and Factoring

Lecture 345 Case Study 14 on Factoring

Lecture 346 Case Study 15 on Extension of Credit Period

Lecture 347 Case Study 16 on Seleciton of Credit Option

Lecture 348 Case Study 17 on Interpretation on Credit Period

Lecture 349 Case Study 19 Bank Loan against Receivable

Lecture 350 Case Study 20 on Inventory Management

Lecture 351 Cash Management and Types of Budgets

Lecture 352 Case Stuidy 21 on Cleared Funds Forecast

Lecture 353 Case Study 22 on Cash cycle and savings

Lecture 354 Format of Cash Budget

Lecture 355 Case Study 23 on Detailed Cash Budget

Lecture 356 Case Study 25 on Detailed Cash Budget

Lecture 357 Case Study 26 on Cash Budget and Projected Profit and Loss Account

Lecture 358 Case Study 27 on Cash Budget and Fund Flow Statement

Lecture 359 Case Study 28 on Cash Budget Additional Borrowings and Proforma Balance Sheet

Section 11: Last Section

Lecture 360 Bonus Lecture

Only students pursuing CA Inter Examination

Homepage


130leverageanalysiscarailr.jpg












 
Web Developer Fundamentals: Newbie To Pro Web Bootcamp!

1vathk2gd43bwvnocfkokmvc9n.jpg


Web Developer Fundamentals: Newbie To Pro Web Bootcamp!
Last updated 9/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 12.32 GB | Duration: 54h 35m

The 12 must have web programming courses to help you become the ultimate web developer. Includes 50+ hours of training.



What you'll learn
Create and manage websites
Learn to create websites using a wysiwyg HTML editor
Learn Basic HTML & CSS
Learn how to develop using PHP and MySQL
Advanced web development languages including JavaScript, jQuery and XML
Advanced programming techniques
Dozens of code examples to download and test
Learn how to create responsive websites using the Bootstrap framework
11 optional quizzes with over 300 questions to test what you've learned
Learn essentials for AngularJS
Put their skills into practice with a real Python project
What is Python and why was it created.
How Python fits into the diverse ecosystem of programming languages.
The basic data types in Python - Strings, Integers, Floats, and Boolean
The basic data types in Python - Strings, Integers, Floats, and Boolean
All about Pythons built-in functions
How to debug errors in Python
How Variables and Functions work in Python
How to use IF-Else Statements in Python
All about storing complex data, including Lists and Dictionaries
How to install Python locally
How to write your first script in Python

Requirements
Dreamweaver CC
A text editor
A passion to learn
No prior knowledge required

Description
"WOW! You built that?!" After taking this 50+ hour course, your web developer skills will quickly make you the envy of your friends, create awe among your colleagues, and even help you land a cool, high-paying job as a web developer. Best yet, this collection of courses is available at a fraction of what they'd cost individually. So you get exclusive access to thousands of dollars worth of web development training -- for just $199 - Sweet! This course is a careful compilation of the 12 most essential programming languages that you'll need to accelerate from absolute novice to advanced developer. You'll receive practical learning techniques, along with expert advice and valuable tips, on how to create fully interactive and custom-designed websites and web applications. Step-By-Step Advancement for Developer Success We've helped over 70,000 students become a wiz at web development. We carefully design each course to maximize your understanding and online learning success. You'll receive a combination of stimulating lectures, coding examples with exercise files for real hands-on practice, and an optional quiz to test your learning along the way. The end result? You'll go from total newbie to a totally talented web developer with a set of simple steps that can be completed in one week. 11-Steps to Becoming an Awesome Web Developer Dreamweaver CC for Beginners (Dreamweaver CS6 also included)HTML/CSS Crash for BeginnersHTML5 Essentials for BeginnersPHP Programming for BeginnersMySQL for BeginnersLearn Advanced PHP ProgrammingLearn JavaScript for BeginnersLearn XML Crash CourseBuild a Responsive Website with Bootstrap 3Learn jQuery Crash CourseLearn AngularJS Crash CourseIntroduction to Python (Added August 2020)The introductory Dreamweaver course teaches students with no previous website knowledge on web development how to create a website from scratch. Advancing to the HTML/CSS crash course will teach you basic website building plus the coding required. Expand your developer skills with PHP and MySQL courses - ideal for creating and maintaining dynamic websites. By the time you graduate to the JavaScript, XML Crash Courses, and Bootstrap courses, you'll be able to create fully interactive and engaging websites. DETAILS: 12 courses54 hours of video, over 350 videos12 optional quizzes to test what they've learned consisting of 300+ questions and answersAdditional Bonus: Effective February 2015, the Dreamweaver CS6 course is available at no additional cost. UPDATE: June 2015 AngularJS course added.UPDATE: August 2020 Introduction to Python added What our students are saying:"Very good well balanced web development course. Would highly recommend it". - Jamal Mahamed"Very broad, well presented course". - Marcus Simpson"Instructor presents the material clearly and completely". - William Powers

Overview

Section 1: Introduction to Course

Lecture 1 IMPORTANT: Start Here First and Read!

Section 2: Learn Dreamweaver CC Course: Introduction to Dreamweaver CC

Lecture 2 Acquiring Dreamweaver CC

Lecture 3 WATCH ME: Essential Information for a Successful Training Experience

Lecture 4 Dreamweaver CC Course Exercise Files

Section 3: Dreamweaver CC: Getting Started

Lecture 5 Start Using Dreamweaver CC

Section 4: Dreamweaver CC: The Workspace & Help Tools

Lecture 6 How to Create a New Workspace

Lecture 7 How to Create an HTML Page

Lecture 8 Dreamweaver CC Help

Section 5: Dreamweaver CC: Creating a Website & Web Page Basics

Lecture 9 How to Create a Website

Lecture 10 How to Publish Your Website Online

Lecture 11 Formatting Pages

Lecture 12 Creating a Second Page - Exercise 1

Section 6: Dreamweaver CC: How Hyperlinks Work

Lecture 13 Creating Hyperlinks

Lecture 14 Exercise 2

Section 7: Dreamweaver CC: Customization Tools

Lecture 15 Page Properties

Lecture 16 Learning CSS

Section 8: Dreamweaver CC: Previewing Pages

Lecture 17 Previewing Pages in Browsers

Section 9: Dreamweaver CC: Panels

Lecture 18 Using Panels

Section 10: Dreamweaver CC: Working with Text

Lecture 19 Adding and Styling Text

Lecture 20 Formatting Text, Adding Special Characters

Lecture 21 Formatting Using HTML

Section 11: Dreamweaver CC: Working with Lists

Lecture 22 Working with Lists

Lecture 23 Exercise 3

Section 12: Dreamweaver CC: Checking Spelling

Lecture 24 Checking the Spelling

Section 13: Dreamweaver CC: Introduction to CSS

Lecture 25 Introduction to CSS

Lecture 26 Fundamentals of CSS

Lecture 27 CSS Designer Panel

Section 14: Dreamweaver CC: CSS Style Sheets

Lecture 28 CSS Style Sheets

Lecture 29 Exercise 4

Section 15: Dreamweaver CC: Images

Lecture 30 Images in General

Lecture 31 Photographic Images

Lecture 32 Background Images

Lecture 33 Exercise 5

Section 16: Dreamweaver CC: Links

Lecture 34 Inserting Links

Lecture 35 Absolute Links

Lecture 36 E-mail Links, Adding Links to Graphics

Section 17: Dreamweaver CC: Page Layout

Lecture 37 Laying Out Pages

Lecture 38 Headers and Footers

Lecture 39 Exercise 6

Section 18: Dreamweaver CC: Styling with CSS

Lecture 40 Styling with CSS

Lecture 41 Creating CSS Rules

Lecture 42 Contextual Selectors, Styling Links

Lecture 43 Code Navigator

Lecture 44 Styling a Website's Menu

Lecture 45 Exercise 7

Section 19: Dreamweaver CC: Managing CSS Styles

Lecture 46 Style Management

Section 20: Dreamweaver CC: Managing Your Website

Lecture 47 Managing Sites and Content

Lecture 48 Testing Your Site Before Publishing It

Lecture 49 Publishing Websites

Lecture 50 Exercise 8

Section 21: Dreamweaver CC: Tables

Lecture 51 Using Tables

Lecture 52 Adding Rows and Columns, Adjusting Width and Height, Merging Cells

Lecture 53 Exercise 9

Section 22: Dreamweaver CC: More About the Workspace, Code View

Lecture 54 More About the Workspace

Lecture 55 Working With Codes

Section 23: Dreamweaver CC: Find and Replace

Lecture 56 Find and Replace

Section 24: Dreamweaver CC: Page Layout Tools

Lecture 57 Page Layout Tools

Section 25: Dreamweaver CC: Media Queries

Lecture 58 Media Queries

Lecture 59 Fluid Grid Layout

Lecture 60 Exercise 10

Section 26: Dreamweaver CC: Inserting Videos

Lecture 61 How to Insert HTML5 Video to a Website

Section 27: Dreamweaver CC: Forms and Fields

Lecture 62 Setting Up Forms and Fields

Lecture 63 More About Fields

Lecture 64 Exercise 11

Section 28: Dreamweaver CC: Behaviors

Lecture 65 Using Behaviors

Section 29: Dreamweaver CC: CSS Transitions

Lecture 66 CSS Transitions

Lecture 67 Exercise 12

Section 30: Dreamweaver CC: More Tips

Lecture 68 Closing

Section 31: HTML & CSS: Introducing HTML

Lecture 69 Course Objectives and Introduction to HTML

Lecture 70 WATCH ME: Essential Information for a Successful Training Experience

Lecture 71 HTML and CSS Course Demo Files

Lecture 72 Setting Up the Environment for Web Development - Demo

Lecture 73 Basic Formatting Tags

Lecture 74 How to Use the HTML Tags - Demo

Lecture 75 Lists, Hyperlinks and Image Tags

Lecture 76 More HTML Tags - Demo

Lecture 77 HTML Tables

Lecture 78 Table and Form Tags - Demo

Section 32: HTML & CSS: Introducing CSS

Lecture 79 Introduction to CSS

Lecture 80 CSS Styles - Demo

Lecture 81 Color Keywords, Text and Fonts

Lecture 82 How to use CSS Style Properties - Demo

Lecture 83 CSS Box Model

Lecture 84 CSS Box Model and How to Manipulate Placement of Elements - Demo

Section 33: HTML & CSS: More HTML and CSS

Lecture 85 Block and Inline Elements; More Tags

Lecture 86 Div Tag - Demo

Lecture 87 New HTML Tags

Lecture 88 Video, Footer and Nav Tags - Demo

Lecture 89 CSS Rule Set, Grouping, Nesting, Pseudo Classes and Pseudo Elements

Lecture 90 CSS Block Model and CSS Popup - Demo

Lecture 91 Position Property

Lecture 92 Designing a Web Site Using the CSS Concepts - Demo 1

Lecture 93 Designing a Web Site Using the CSS Concepts - Demo 2

Lecture 94 Advanced CSS

Lecture 95 Navigational Menu - Demo 1

Lecture 96 Navigational Menu - Demo 2

Lecture 97 Navigational Menu - Demo 3

Lecture 98 Course Wrapup

Section 34: HTML5 Crash Course

Lecture 99 HTML 5 Course Overview

Lecture 100 WATCH ME: Essential Information for a Successful Training Experience

Lecture 101 HTML5 Course Demo Files

Lecture 102 Filetype and Charset

Lecture 103 Comparing HTML 5 Doc to HTML 4 Doc - Part 1

Lecture 104 Comparing HTML 5 Doc to HTML 4 Doc - Part 2

Lecture 105 Forms

Lecture 106 Scalable Vector Graphics

Lecture 107 Video and Audio

Lecture 108 Microdata Tutorial

Lecture 109 Math element, MathML, and Canvas

Lecture 110 Conclusion

Section 35: Beginner PHP: Introduction

Lecture 111 Course Objectives and Introduction to PHP

Lecture 112 WATCH ME: Essential Information for a Successful Training Experience

Lecture 113 PHP Beginners Course Demo/Exercise Files

Lecture 114 PHP Development Environment; Whitespace and Comment; Exercise 1

Section 36: Beginner PHP: Variables, Syntax, Operators and Conditional Control

Lecture 115 Variables; Exercise 2

Lecture 116 Echo vs. Print; Single vs. Double Quotes

Lecture 117 Operators

Lecture 118 Controlling the Flow of Execution; Exercise 3

Section 37: Beginner PHP: Defining Loops and Debugging

Lecture 119 Repeating Codes; Exercise 4

Lecture 120 Debugging PHP; Scaffolding Code

Section 38: Beginner PHP: Working with Arrays and Functions

Lecture 121 Arrays; Exercise 5

Lecture 122 Functions - Part 1

Lecture 123 Functions - Part 2; Exercise 6

Lecture 124 External PHP

Lecture 125 Runtime Error Handling

Section 39: Beginner PHP: File Resources, Forms and Superglobals

Lecture 126 Reading and Writing to a File

Lecture 127 Reading a Configuration File; Exercise 7

Lecture 128 Form Processing; Cookies and Sessions Superglobals; Exercise 8

Section 40: Beginner PHP: Database Storage

Lecture 129 Database Storage - Part 1

Lecture 130 Database Storage - Part 2

Section 41: Beginner PHP: Object-Oriented Development

Lecture 131 Object-Oriented Development - Part 1

Lecture 132 Object-Oriented Development - Part 2

Lecture 133 Object-Oriented Development - Part 3

Lecture 134 Inheritance Demo

Lecture 135 Exercise 9

Section 42: Beginner PHP: Security

Lecture 136 Common Threats

Lecture 137 Security Demo and Exercise 10

Section 43: Beginner PHP: PHP Library

Lecture 138 PHP Built-in Constants and Standard PHP Library

Lecture 139 Standard PHP Library Demo - Part 1

Lecture 140 Standard PHP Library Demo - Part 2

Lecture 141 SPL Data Structures and Exception Types

Lecture 142 SPL Data Structures Demo

Lecture 143 SPL Exception Types Demo; Exercise 11

Section 44: Beginner PHP: SQL for Developers

Lecture 144 Relational Database Management Systems and SQL Language

Lecture 145 SQL Statement

Lecture 146 Select Statement Demo - Part 1

Lecture 147 Select Statement Demo - Part 2

Lecture 148 Table Joins and Union

Lecture 149 Joins Demo

Lecture 150 Insert, Update and Delete Commands; Aggregate Functions

Lecture 151 Queries and Store Procedure

Section 45: Beginner PHP: Design Pattern

Lecture 152 Design Pattern Categories

Lecture 153 Singleton Pattern Demo

Lecture 154 Observer Pattern Demo

Section 46: MySQL: Introduction

Lecture 155 Course Outline and Intro to MySQL and Database

Lecture 156 READ ME: Essential Information for a Successful Training Experience

Lecture 157 MySQL Architecture and Installation of MySQL

Lecture 158 Installation Demo - Part 1

Lecture 159 Installation Demo - Part 2

Section 47: MySQL: Database Design

Lecture 160 Database Design

Lecture 161 MySQL Workbench Download

Lecture 162 Database Table and Constraints

Lecture 163 Database Designing and Normalization - Part 1

Lecture 164 Database Designing and Normalization - Part 2

Lecture 165 Storage and Data Types

Lecture 166 Data Types Demo

Lecture 167 ACID and Transactions

Lecture 168 Locks, Deadlocks, Isolation Levels and Logging

Lecture 169 Isolation Levels and Locking Demo

Lecture 170 Locking Mechanism Demo and MySQL ACID Support

Section 48: MySQL: Administration

Lecture 171 Responsibilities of a Database Administrator

Lecture 172 Creating a User and Limiting Access to a Database; Basic Table Maintainance

Lecture 173 Protecting your Database; How to Perform Database Backup

Lecture 174 Performance Monitoring

Section 49: MySQL: Indexing for Performance

Lecture 175 InnoDB Indexing and Clustered vs. Unclustered Index

Lecture 176 Query and Where Clause

Lecture 177 Impact of Indexing on Database Performance

Lecture 178 Performance Optimization

Section 50: MySQL: SQL for Developers

Lecture 179 Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers

Lecture 180 Data Definition Language; How to Create Database Objects

Lecture 181 SQL Select Statements

Lecture 182 SQL Select Statements Demo

Lecture 183 Joins

Lecture 184 Combining Related Table Using Joins

Lecture 185 Insert, Update and Delete Commands

Lecture 186 Insert, Update, and Delete Commands Demo

Section 51: MySQL: Query Analysis and Optimization

Lecture 187 Query Optimization

Lecture 188 Query Optimization Demo

Section 52: MySQL: Data Replication

Lecture 189 Database Replication

Lecture 190 Setting Up Replication in MySQL

Lecture 191 Data Encryption

Lecture 192 Column-Level Database Encryption Demo

Lecture 193 High Availability

Lecture 194 Course Wrap-up

Section 53: Advanced PHP: Introduction to PHP Advanced Course

Lecture 195 Course Objectives; Review of the Basics - Part 1

Lecture 196 WATCH ME: Essential Information for a Successful Training Experience

Lecture 197 PHP Advanced Course - Demo Files

Lecture 198 Review of the Basics - Demo 1

Lecture 199 Review of the Basics - Part 2

Lecture 200 Review of the Basics - Demo 2

Lecture 201 Review of the Basics - Part 3

Lecture 202 Review of the Basics - Demo 3

Section 54: Advanced PHP: Functions, Date and Time, Debugging and Logging

Lecture 203 Code Reuse, Feeding a Function, Return Data from a Function, Pass-by-Value

Lecture 204 Call-by-Value vs. Call-by-Reference - Demo

Lecture 205 Date and Time Manipulation

Lecture 206 How to Manipulate Date and Time - Demo

Lecture 207 PHP Built-in Constants, Debugging PHP, and Application Logging

Lecture 208 Debugging and Logging PHP - Demo 1

Lecture 209 Debugging and Logging PHP - Demo 2

Section 55: Advanced PHP: Strings, REGEX, Runtime Error Handling, and File Resources

Lecture 210 String Manipulation and Regular Expressions

Lecture 211 String Manipulation Functions - Demo

Lecture 212 Regular Expression Functions - Demo

Lecture 213 Runtime Error Handling

Lecture 214 Runtime Error Handling using PHP Exception Handling Mechanism - Demo

Lecture 215 Manipulating Files with PHP

Lecture 216 Reading and Parsing Data in Comma Separated Value Format - Demo

Section 56: Advanced PHP: Database Access, Design Patterns, Mail Function, PEAR and cURL

Lecture 217 Database Storage

Lecture 218 Database Connectivity - Demo

Lecture 219 Design Patterns

Lecture 220 Mail Function

Lecture 221 Retrieving and Sending an E-mail using a PHP Function - Demo

Lecture 222 Send E-mail using Simple Mail Transfer Protocol - Demo

Lecture 223 PHP Extension and Application Repository

Lecture 224 PHP Extension and Application Repository - Demo

Lecture 225 Client URL

Lecture 226 Basic cURL - Demo

Lecture 227 Login to a Website and Post Status Update using cURL- Demo

Lecture 228 Webscraping using cURL - Demo

Section 57: Advanced PHP: Web Services

Lecture 229 Simple Object Access Protocol

Lecture 230 NU SOAP Library - Demo

Lecture 231 Web Services Description Language

Lecture 232 Benefits of using WSDL - Demo

Lecture 233 Developing Web Services using SOAP Protocol - Demo

Section 58: Advanced PHP: Introspection and Reflection

Lecture 234 Introspection and Reflection

Lecture 235 Introspection API - Demo

Lecture 236 Reflection API - Demo

Section 59: Advanced PHP: Smarty Template

Lecture 237 Smarty Templates

Lecture 238 Smarty Template Engine for PHP - Demo 1

Lecture 239 Smarty Template Engine for PHP - Demo 2

Section 60: Advanced PHP: Sessions

Lecture 240 Sessions

Lecture 241 PHP Session Mechanism - Demo

Section 61: Advanced PHP: PHP Framework

Lecture 242 CakePHP, Yii, Zend and Codelgniter

Section 62: Advanced PHP: Best Practices and Security

Lecture 243 Best Practices

Lecture 244 Use of Encryption - Demo

Section 63: Advanced PHP: Conclusion

Lecture 245 Wrap Up

Section 64: JavaScript: Introduction

Lecture 246 Course Objectives

Lecture 247 WATCH ME: Essential Information for a Successful Training Experience

Lecture 248 JavaScript Course Demo File

Lecture 249 Basic Setup

Section 65: JavaScript: Primitive Data Types, Strings, Operators, Numbers, Conditionals

Lecture 250 Primitive Data Types - Part 1

Lecture 251 Primitive Data Types - Part 2

Lecture 252 Operators

Lecture 253 Strings

Lecture 254 Numbers

Lecture 255 Conditional Statements

Lecture 256 Loops

Lecture 257 Nested for Loops

Lecture 258 Arrays

Lecture 259 Multidimensional Arrays

Lecture 260 Array Methods

Lecture 261 Looping through Arrays

Section 66: JavaScript: Functions

Lecture 262 Functions

Lecture 263 Scope Functions

Lecture 264 Variable Hoisting Functions

Lecture 265 Declarations and Expressions

Lecture 266 Self-Invoking and Anonymous Functions

Lecture 267 Callback Functions

Lecture 268 Functions that Return Functions

Lecture 269 Closures

Section 67: JavaScript: Objects

Lecture 270 Objects

Lecture 271 Copying Objects

Lecture 272 Objects Functions and This - Part 1

Lecture 273 Objects Functions and This - Part 2

Lecture 274 Constructors and Factories

Lecture 275 The Module Pattern

Section 68: JavaSript: Document Object Model and Course Conclusion

Lecture 276 Creating Elements

Lecture 277 Adding Selectors and Selecting Elements

Lecture 278 Event Handlers and Event Listeners

Lecture 279 Capturing Form Input

Lecture 280 More Selection Options

Lecture 281 Libraries

Section 69: XML: Introduction to XML

Lecture 282 Course Objectives and Introduction

Lecture 283 WATCH ME: Essential Information for a Successful Training Experience

Lecture 284 XLM Course Demo Files

Lecture 285 Creating an XML Document - Demo

Lecture 286 Practical XML

Lecture 287 Document Type Document - Demo

Lecture 288 Chapter 1 Summary

Section 70: XML: Advanced XML Topics

Lecture 289 XML Attributes

Lecture 290 Use of Attributes - Demo

Lecture 291 XML Schema

Lecture 292 Use of Namespaces - Demo

Lecture 293 XML Schema Documents - Demo

Lecture 294 Chapter 2 Summary

Section 71: XML: XSLT

Lecture 295 Extensible Stylesheet Language, XSL Transformation and XPATH

Lecture 296 Providing Presentation Option in the form of XSL for the XML- Demo

Lecture 297 Chapter 3 Summary

Lecture 298 Course Wrapup

Section 72: Introduction to Bootstrap

Lecture 299 What is Bootstrap and Where to Download It

Lecture 300 WATCH ME: Essential Information for a Successful Training Experience

Lecture 301 Bootstrap Course Demo Files

Lecture 302 Hello World Example

Lecture 303 Adding Navigation Elements

Lecture 304 Advanced Features and Controls - Part 1

Lecture 305 Advanced Features and Controls - Part 2

Lecture 306 Testing the Website in Different Devices

Lecture 307 Using Media Class to Add Images and Comments

Lecture 308 Cross Device Nav Bar ; Logo and Toggle Button

Lecture 309 Dropdown & Glypicon

Section 73: Bootstrap: Button Enhancements

Lecture 310 Adding Dropdown and Glyphicon to Buttons; Adding Search Field & Button

Lecture 311 Adding a Login Form

Lecture 312 Adding a Registration Form - Part 1

Lecture 313 Adding a Registration Form - Part 2

Lecture 314 Breadcrumbs, Badges and Bars

Lecture 315 Modal Dialog and Tool Tip

Lecture 316 Bootstrap Validator - Part 1

Lecture 317 Bootstrap Validator - Part 2

Lecture 318 Creating a Data Table and Modifying It using FooTable

Lecture 319 Creating Checkboxes, Radio Buttons and More using Fuel UX

Lecture 320 Themes, CSS Pre-Processors and Redistributions

Section 74: jQuery: Introduction

Lecture 321 Hello World Example

Lecture 322 WATCH ME: Essential Information for a Successful Training Experience

Lecture 323 jQuery Course Demo Files

Lecture 324 Setting Values with Text HTML

Lecture 325 Getting Values with Text HTML

Lecture 326 Selectors

Lecture 327 Events

Lecture 328 Showing and Hiding Effects

Lecture 329 Combining Events with Selectors

Lecture 330 Traversing and Filtering

Section 75: jQuery: Advance Concepts

Lecture 331 Introduction to Advance Features of jQuery

Lecture 332 Drawing and Mouse Position

Lecture 333 Recording Events

Lecture 334 UI Elements

Lecture 335 UI Dialog

Lecture 336 UI Datepicker

Lecture 337 UI SFx

Lecture 338 Plugins

Section 76: AngularJS: Introduction

Lecture 339 What is Angular JS and Creating an Angular App using JSFiddle

Lecture 340 READ ME: Essential Information for a Successful Training Experience

Lecture 341 Data Binding

Lecture 342 Controllers and Creating Simple Apps

Lecture 343 Controllers with Multiple Rows of Data

Lecture 344 Controllers with Scope Binding

Lecture 345 Scope Binding with CRUD Operation - Part 1

Lecture 346 Scope Binding with CRUD Operation - Part 2

Lecture 347 Using Angular in IDE Projects

Section 77: AngularJS: Advanced Topics

Lecture 348 Angular HTTP Service

Lecture 349 Angular Dependencies in Applications

Lecture 350 Combining Binding, Validation, and Directives

Lecture 351 Custom Directives - Part 1

Lecture 352 Custom Directives - Part 2

Lecture 353 Custom Directives With Scope

Lecture 354 Bonus Lecture

Section 78: Python: The Workplace Tech Divide

Lecture 355 Which Side of the Divide Are You On?

Lecture 356 WATCH ME: Essential Information for a Successful Training Experience

Lecture 357 DOWNLOAD ME: Course Exercise Files

Lecture 358 DOWNLOAD ME: Course Project Files

Lecture 359 Beginners Are Welcome

Lecture 360 Course Overview

Section 79: Introduction to Python

Lecture 361 What is Python?

Lecture 362 Python's Comparison to Other Programming Languages

Lecture 363 Examples of Python in the Workplace

Lecture 364 The Easiest Place to Practice Python

Lecture 365 Create an Account Online

Section 80: Python: Basic Data Types

Lecture 366 Python Data Types

Lecture 367 Strings

Lecture 368 Integers

Lecture 369 Floats

Lecture 370 Boolean

Lecture 371 Data Types Exercise

Section 81: Python Built-In Functions

Lecture 372 What is a Built-In Function?

Lecture 373 Where to Look For Built-In Functions

Lecture 374 Most Common Built In Functions

Lecture 375 Built In Functions Exercise

Section 82: Python: Variables and Functions

Lecture 376 Variables and Functions

Lecture 377 Storing Values as Variables

Lecture 378 Comparing Variables with Operators

Lecture 379 Basic Expressions

Lecture 380 Functions

Lecture 381 Commenting

Lecture 382 Variables and Functions Exercise

Section 83: Python: Errors and Debugging

Lecture 383 What is an Error?

Lecture 384 Reading a Stack Trace

Lecture 385 Print Function

Lecture 386 Try and Except

Lecture 387 You Are Not Alone

Lecture 388 Errors Exercise

Section 84: Python Keywords

Lecture 389 Python Keywords

Lecture 390 Common keywords

Lecture 391 Global

Lecture 392 Keywords Exercise

Section 85: If-Else Statements

Lecture 393 Basic Logic

Lecture 394 Syntax and Inline Evaluation

Lecture 395 Value Evaluation

Lecture 396 Complex If-Else Statements

Lecture 397 If-Else Exercises

Section 86: Storing Complex Data

Lecture 398 Advanced Data Types

Lecture 399 Lists

Lecture 400 Dictionaries

Lecture 401 Looping: Lists

Lecture 402 Looping: Dictionaries

Lecture 403 Advanced Data Exercise

Section 87: Python Modules

Lecture 404 Python Modules

Lecture 405 Python Built In Modules

Lecture 406 Importing Modules

Section 88: Installing Python and Modules

Lecture 407 Python Environments

Lecture 408 Mac

Lecture 409 Windows

Lecture 410 IDEs

Lecture 411 Python Idle

Lecture 412 Managing files and folders

Lecture 413 Executing Scripts

Lecture 414 PIP

Section 89: Project: Automate Data Updates For a Spreadsheet

Lecture 415 Project Introduction

Lecture 416 Setting Up Project

Lecture 417 Reading and Writing to Excel Files

Lecture 418 Working with CSV Files

Lecture 419 Dynamic File Paths

Lecture 420 Transform and Validate Transactions

Lecture 421 Transfer and Save Transactions

Lecture 422 Clean Up the Code

Lecture 423 Hardening the Script

Section 90: Course Close

Lecture 424 What's Next?

Complete beginners,Someone who has never coded before,Someone new to web development,Web masters who need to improve their development skills,Students requiring additional knowledge and instruction,Those considering a career in web development,Entrepreneurs looking to develop skills for a lean startup,People looking to learn the Python Programming Language

Homepage


18usingpanelssorfjv.jpg








 
The Ultimate Microsoft Excel 2022 Mastery Course

ltvvaxoc8lta0l0ntrbkqbmcq3.jpg


The Ultimate Microsoft Excel 2022 Mastery Course
Last updated 1/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.58 GB | Duration: 37h 57m

Master Microsoft Excel 2013 and 2016 The Easy Way - On Your Schedule. 4 Courses, 37 Hours of Training.



What you'll learn
Discover new and improved features in Excel 2013 and 2016
How to effectively use Excel 2013 or 2016 on a touchscreen device
How create, save, and open a workbook
Learn how to personalize your use of Excel using Excel Options
How to use and how to customize the Quick Access Toolbar
Complete data entry, cell formatting, working with multiple worksheets and the "Ribbon" interface
The basics of entering and editing data in a workbook
Discover how to format dates and numbers
Learn practical methods in which you can backup and recover your Excel spreadsheets
Effectively use autofill and flashfill so you are more productive
Discover the essentials of using fomulas and functions
How to rename, insert, move, and reference an Excel 2016 worksheet
Discover how to create charts and graphs
Learn practical methods to sort and filter your data
How to protect and secure your Excel data
Data entry, cell formatting, working with multiple worksheets and the "Ribbon" interface
Tips for mouse and touch screen users
Graphs and charts using templates or custom designs
Pivot tables and slicing
Working with flash fill
Working with dates and times
Averages, percentiles, and LINEST functions
Calculating depreciation
Inserting and formatting tables
Sparklines and data bars
How to import and export data to and from Excel
Discover practical methods for financial & statistical​ Functions
Using financial functions to determine payments
Practice what you learned with included exercise files

Requirements
Microsoft Excel 2013 or 2016 desktop version for Windows installed and ready to use on your computer.

Description
Learn Microsoft Excel 2013 & 2016 Inside and Out with This 4 Course Training Bundle
Includes 4 Courses: The Excel 2013 & 2016 Beginner Courses & The Excel 2013 & 2016 Advanced CoursesIncludes 37-Hours of High Quality Training by Your Professional TrainerTaught by a Professional TrainerPractice Along With Included Exercise FilesWatch and Learn with Demo Project Files That are IncludedProgresses Logically from Beginning to Advanced TopicsStarts Right at the Beginning with an Easy Intro to the SoftwareDeepen Your Knowledge and Master More Advanced SkillsLearn to Create Charts and GraphsCreating Charts and GraphsEffectively Create and Use Functions and FormulasImport and Export Data Create and Effectively Use Pivot TablesHow to Use Excel for Data AnalysisDiscover Practical Methods for Financial & Statistical Functions This bundle includes: 4 individual courses
37 hours of video tutorialsOver 200 individual video lectures
Exercise files to practice what you learnedPrintable course transcriptions to follow along and take notesCertificate of completionContents and Overview for the 9-Hour Excel 2016 Beginner Course
This course starts with where to find Microsoft Excel and installing
the program. Then you learn step-by-step, simple 1-2-3 methods for
getting up and running with Excel 2016. Watch just the first few videos
to have a basic knowledge of Excel. Then continue through the detailed
32 chapters of video lessons and 9 exercise files to gradually become a
proficient user. It's important to note that we don't assume you know anything about
Excel 2016. We start from the basics. After installation we discuss what
is new with 2016, using Touchscreen, opening a Workbook, and how to use
Help to get additional answers when you need them.Then we show you how to personalize Excel for your own use with
exciting Excel Options. We discuss all the Ribbons and Toolbars,
entering and editing data, backup and recovery, fill and series, and
printing your projects. We also work with formulas, functions, sorting
and filtering data, creating charts and graphs, and much more.Upon completion of this course you will know the essentials of Microsoft Excel 2016.Contents and Overview for the 9-Hour Excel 2016 Advanced Course
Colorful charts, sleek graphs, and cutting-edge databases that offer
insight into financial information are a breeze when you learn the
secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 - Advanced
course. That's because you'll get the tools you need to master Excel's
powerful data functions in this information-packed 9-hour video training
class. Your expert instructor will kick the course off by leading you
through graph and chart basics. Then, you'll explore Excel's array of
detailed formatting tools and discover how to make these work for you
when graphing and charting financial information. Next, you'll explore
the roles played by trends, relationships, and differences in charts,
and how to work with sparklines for data visualization and data bars.
The course will also take you through detailed discussions of pivot
tables, bubble charts, radar charts, and more. Contents and Overview for the 10-Hour Excel 2016 Beginner CourseImpress the people you work with by cultivating advanced spreadsheet skills. During this 10-hour training
course, you'll learn to create Excel spreadsheets with ease. Our expert
instructor will show you Excel 2013 features to navigate you through
the program. Starting with the basics, you'll discover how to enter and
format data in the quickest manner possible.
Next you'll be introduced to the power of Excel's functions and
formulas to help you calculate data and derive useful information. To
help you present it all in a visually appealing format, your instructor
will then walk you through how to create sophisticated charts and
graphs, and publish them online. Finally, you'll learn to analyze and
review worksheets for data discrepancies so you can prevent problems
before they arise. Turn your long lists of numbers into slick, engaging visuals that
bring data to life. Whether you need to create budgets, financial
projections, invoices, calendars, schedules, or lists, our elaborate
Excel 2013 training course will give you the skills you need to stand
out at work. Contents and Overview for the 9-Hour Excel 2013 Advanced CourseThrough 52 lectures and over 12.5 hours of content, this course will
take you through learning how to use functions in everyday work
environments. Personal and professional financial functions are covered
including payments, future value and depreciations. Students will learn
statistical functions like averages, percentiles, and regression.In order to improve efficiency, students will also cover concepts for
connecting to external data like other workbooks or web data; tables
including style, selection and sizing. Pivot tables and data analysis
will be key concepts helpful to the work environment.For help with reporting, students will learn surface charts, stock
charts, radar charts and bubble charts and graphs. Lastly, students will
cover important web applications.Upon completion of this course, students will be able to create
colorful charts and databases that communicate data and financial
records efficiently and effectively. Students will be able to apply data
to various reporting forms like tables, graphs and pivot tables in
order to show important analysis like depreciation, percentiles and
regression for use with strategizing and planning. Students who finish
this course will have an advanced knowledge of the versatility of Excel
that is immediately applicable to their work with the database. ** Updated July 2017. English close captions added** Updated June 2017. Course transcripts now available.Here's what our students are saying."A comprehensive and well-structured course, and the examples and explanations are clearly presented; and the instructor is very engaging, easy to listen to and even entertaining (which is always a plus for keeping one's interest)."- Arnold Schwartz"Even though English is not my first language I can understand every single word. Moreover, the teacher is fantastic. The best investment for sure."- Jesse Prestes da Silva"I have been using Excel for many years at a low intermediate level. In just the first few minutes, I am amazed at the new key combos that I have learned to make moving around the worksheets faster. Wow!"- RobDid you know?Simon Sez IT teaches all sorts of software, including:- Microsoft Excel- Microsoft PowerPoint- Microsoft Word- Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements- Web Development Languages- And so much more!Just search "Simon Sez IT" to see our full list of individual courses and incredible value multi-course bundles on Udemy.

Overview

Section 1: Excel 2013: Introduction to Excel 2013 Beginner Course

Lecture 1 Introduction to Excel 2013

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Excel 2013 Exercise Files

Lecture 4 Downloadable Course Transcripts

Lecture 5 What's New

Section 2: Excel 2013: Using Touch

Lecture 6 Overview of Principles

Section 3: Excel 2013: Getting Started

Lecture 7 Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns

Lecture 8 Templates; Creating, Opening, and Saving a Workbook

Section 4: Excel 2013: Help

Lecture 9 Online, Offline, and Contextual Help

Section 5: Excel 2013: Settings and Preferences

Lecture 10 Excel Options

Section 6: Excel 2013: The Ribbon and Toolbars

Lecture 11 Ribbon Interface

Lecture 12 Quick Access Toolbar

Lecture 13 Mini Toolbar

Section 7: Excel 2013: Backup and Recovery

Lecture 14 Create Backup Option; Auto-Recover and Autosave

Section 8: Excel 2013: Entering and Deleting Data

Lecture 15 Entering Text and Numbers

Lecture 16 Date Formats

Lecture 17 Formatting Cells; Editing and Deleting Data

Lecture 18 Fill

Lecture 19 Flash Fill

Section 9: Excel 2013: Formatting a Worksheet

Lecture 20 Themes and Cell Styles

Lecture 21 Inserting, Deleting, Hiding and Adjusting Rows and Columns

Lecture 22 Wrap Text and Alignment

Lecture 23 Merging Cells; Applying Themes and Styles

Lecture 24 Borders

Section 10: Excel 2013: Copy, Paste and Paste Special

Lecture 25 Copy, Cut and Paste

Section 11: Excel 2013: Proofing

Lecture 26 Spell checking

Section 12: Excel 2013: Managing Worksheets

Lecture 27 Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets

Section 13: Excel 2013: Comments

Lecture 28 Inserting Comments

Section 14: Excel 2013: Viewing and Printing

Lecture 29 Workbook Views, Zoom and Freeze

Lecture 30 Printing; Headers, Footers and Margins

Section 15: Excel 2013: Formulas and Functions

Lecture 31 Overview of Formulas and Functions

Lecture 32 Cell References

Lecture 33 Names

Lecture 34 Finding Errors; New Excel Functions

Section 16: Excel 2013: Working with Workbooks

Lecture 35 Multiple Workbooks and Windows; Comparing Workbooks

Section 17: Excel 2013: Find and Replace

Lecture 36 Go to; Find and Replace Options

Section 18: Excel 2013: Conditional Formatting

Lecture 37 Applying, Clearing and Managing Rules

Section 19: Excel 2013: Graphing and Charting

Lecture 38 Chart Types; Chart Recommendation

Lecture 39 Basic Formatting

Lecture 40 Selecting Data, Positioning and Printing Charts

Section 20: Excel 2013: File Types

Lecture 41 Saving Workbooks; PDF and CSV Formats

Section 21: Excel 2013: Managing Data

Lecture 42 Sorting

Lecture 43 Filtering

Lecture 44 Tables

Section 22: Excel 2013: Functions Case Study

Lecture 45 VLOOKUP

Lecture 46 Text Function

Lecture 47 Date and Time Functions

Lecture 48 Logical Functions

Section 23: Excel 2013: Analyzing Data

Lecture 49 Financial Analysis Case Study - Part 1

Lecture 50 Financial Analysis Case Study - Part 2

Lecture 51 Quick Analysis Tool

Section 24: Excel 2013: Shapes and Pictures

Lecture 52 Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt

Section 25: Excel 2013: Sharing and Protecting

Lecture 53 Protecting Worksheets

Lecture 54 Protecting Workbooks

Lecture 55 Sharing and SkyDrive

Section 26: Excel 2013: More Backstage View Options

Lecture 56 Trust Center; Export; Inspect Workbook

Section 27: Excel 2013: Closing

Lecture 57 Summary; More Help

Section 28: Excel 2013 Advanced: Introduction

Lecture 58 Prerequisites of Excel 2013 Advanced Course

Lecture 59 WATCH ME: Essential Information for a Successful Training Experience

Lecture 60 DOWNLOAD ME: Excel 2013 Advanced Exercise Files

Lecture 61 Downloadable Course Transcripts

Lecture 62 Course review

Section 29: Excel 2013 Advanced: Functions

Lecture 63 List of Functions; Common Types of Arguments; Basic Use of Functions

Lecture 64 Advanced Aspects of Functions; Searching for a Function

Lecture 65 Autosum

Section 30: Excel 2013 Advanced: Personal and Professional Financial Functions

Lecture 66 Payment

Lecture 67 Future Value

Lecture 68 Principle Payment

Lecture 69 Depreciations

Section 31: Excel 2013 Advanced: Date and Time Functions

Lecture 70 How Dates and Times are Stored

Lecture 71 Dates and Times Calculation

Lecture 72 Exercise on Date and Time Functions; Date and Time Settings

Section 32: Excel 2013 Advanced: Statistical Functions for Description and Prediction

Lecture 73 Average

Lecture 74 Percentile

Lecture 75 Regression

Lecture 76 LINEST Function

Lecture 77 Example of Functions for Inferential Statistics

Section 33: Excel 2013 Advanced: Text Functions

Lecture 78 Text Function Case Study - 1

Lecture 79 Text Function Case Study - 2

Section 34: Excel 2013 Advanced: Lookup Functions

Lecture 80 Lookup and Reference Functions

Section 35: Excel 2013 Advanced: Logical Functions

Lecture 81 Logical Functions

Section 36: Excel 2013 Advanced: Connecting to External Data

Lecture 82 Connecting to Other Workbooks

Lecture 83 Connecting to Access Data

Lecture 84 Connecting to Web Data

Section 37: Excel 2013 Advanced: Tables

Lecture 85 Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row

Lecture 86 Inserting Columns and Rows; Resizing Tables

Lecture 87 Table Reference

Lecture 88 Table Styles

Lecture 89 Table Selection

Section 38: Excel 2013 Advanced: Pivot Tables

Lecture 90 Basic Principles of Pivot Tables

Lecture 91 Presentational Side of Pivot Tables

Lecture 92 Filtering in Pivot Tables; Slices

Section 39: Excel 2013 Advanced: Data Analysis

Lecture 93 What if

Lecture 94 Scenario Manager

Lecture 95 Goal Seeker

Lecture 96 Solver

Section 40: Excel 2013 Advanced: Charts

Lecture 97 Area Charts

Lecture 98 Surface Charts

Lecture 99 Stock Charts - Part 1

Lecture 100 Stock Charts - Part 2

Lecture 101 Radar Charts

Lecture 102 Bubble Charts

Section 41: Excel 2013 Advanced: Graphs

Lecture 103 Regression and Scatter Chart

Section 42: Excel 2013 Advanced: Pivot Charts

Lecture 104 Creating Pivot Charts

Section 43: Excel 2013 Advanced: Sparklines

Lecture 105 Using Sparklines

Section 44: Excel 2013 Advanced: Web App

Lecture 106 Creating Workbooks using a Web App

Lecture 107 Sharing your Workbook

Section 45: Excel 2013 Advanced: Conclusion

Lecture 108 Closing

Section 46: Excel 2016: Introduction

Lecture 109 Acquiring Excel 2016 and Information on Installation and Upgrade

Lecture 110 WATCH ME: Essential Information for a Successful Training Experience

Lecture 111 DOWNLOAD ME: Excel 2016 Course Exercise and Demo Files

Lecture 112 Downloadable Course Transcripts

Lecture 113 Course exercise files

Section 47: Excel 2016: What's New

Lecture 114 New and Improved Features in Excel 2016

Section 48: Excel 2016: Using Touch

Lecture 115 Overview of Principles of Using Touchscreen

Section 49: Excel 2016: Getting Started

Lecture 116 Creating and Saving a Workbook

Lecture 117 Opening a Workbook

Section 50: Excel 2016: Using Help

Lecture 118 Online Help and Contextual Help

Section 51: Excel 2016: Excel Options

Lecture 119 Personalizing Your Use of Excel

Section 52: Excel 2016: The Ribbon and Toolbars

Lecture 120 Basics of using the Ribbon

Lecture 121 Quick Access Toolbar

Lecture 122 Tell Me Feature

Lecture 123 Mini Toolbars and Contextual Menus

Lecture 124 Status Bar

Section 53: Excel 2016: Entering and Editing Data

Lecture 125 Basics of Entering and Editing Data in a Workbook

Lecture 126 Exercise 01

Lecture 127 Formatting Dates

Lecture 128 Formatting Numbers

Lecture 129 Exercise 02

Section 54: Excel 2016: Backup and Recovery

Lecture 130 AutoSave, Recover Unsaved Workbook, and Create a Backup Copy

Section 55: Excel 2016: Fill and Series

Lecture 131 Working with Fill and Series

Lecture 132 Flash Fill

Section 56: Excel 2016: Viewing and Printing

Lecture 133 Workbook Views, Zoom, and Freeze

Lecture 134 Printing

Lecture 135 Exercise 03

Section 57: Excel 2016: Cut, Copy, and Paste

Lecture 136 Methods of Cutting, Copying, and Pasting

Section 58: Excel 2016: Formatting a Worksheet

Lecture 137 Delete and Clear

Lecture 138 Insert, Hide, Column Width and Row Height, and Merge

Lecture 139 Alignment

Lecture 140 Themes and Styles

Lecture 141 Exercise 04

Section 59: Excel 2016: Formulas and Functions

Lecture 142 Basics of Fomulas and Functions

Lecture 143 Complex Examples of Formulas

Lecture 144 Exercise 05

Section 60: Excel 2016: Managing Worksheets

Lecture 145 Rename, Insert, Move, and Reference a Worksheet

Section 61: Excel 2016: Working with Multiple Workbooks

Lecture 146 Working with Multiple Workbooks

Section 62: Excel 2016: Saving Workbooks

Lecture 147 Saving in Different File Types

Section 63: Excel 2016: Proofing

Lecture 148 The Spell Checker

Section 64: Excel 2016: Inserting Comments

Lecture 149 Inserting Comments

Lecture 150 Exercise 06

Section 65: Excel 2016: Basic Functions in Excel

Lecture 151 The VLOOKUP Function

Lecture 152 Text Functions

Lecture 153 Date and Time Functions

Lecture 154 Logical Functions

Section 66: Excel 2016: Graphs and Charts

Lecture 155 Creating Graphs and Charts

Lecture 156 Customizing a Cluster Column Chart

Lecture 157 Customizing a Pie Chart

Lecture 158 New Chart Types in Excel 2016

Lecture 159 Exercise 07

Section 67: Excel 2016: Sorting and Filtering Data

Lecture 160 Managing Data by Sorting

Lecture 161 Managing Date by Filtering

Lecture 162 Customizing Tables

Section 68: Excel 2016: Shapes and Pictures

Lecture 163 Inserting Shapes and Pictures

Lecture 164 Exercise 08

Section 69: Excel 2016: Formatting Cells Based on Content

Lecture 165 Conditional Formatting

Section 70: Excel 2016: Protection and Security

Lecture 166 Protecting Worksheets

Lecture 167 Protecting Workbooks

Section 71: Excel 2016: Naming Items

Lecture 168 Giving Items Names

Lecture 169 Exercise 09

Section 72: Excel 2016: Finding and Replacing Words

Lecture 170 Find and Replace

Section 73: Excel 2016: Borders

Lecture 171 Adding Borders

Section 74: Excel 2016: Workbook Inspection

Lecture 172 Inspecting a Workbook

Section 75: Excel 2016: Privacy Options

Lecture 173 Trust Center Privacy Options

Section 76: Excel 2016: Sharing Options

Lecture 174 Sharing a Workbook

Section 77: Excel 2016: Wrap Up

Lecture 175 Closing

Section 78: Excel 2016 Advanced: Introduction to Excel 2016 Advanced Course

Lecture 176 Prerequisites of the Course and Version of Excel

Lecture 177 WATCH ME: Essential Information for a Successful Training Experience

Lecture 178 DOWNLOAD ME: Excel 2016 Advanced Course Exercise and Demo Files

Lecture 179 Downloadable Course Transcripts

Lecture 180 Course Structure

Section 79: Excel 2016 Advanced: Functions

Lecture 181 Functions - Part 1

Lecture 182 Functions - Part 2

Lecture 183 Autosum

Section 80: Excel 2016 Advanced: Date and Time Functions

Lecture 184 How Date and Time Works

Lecture 185 Basic Date and Time Functions

Lecture 186 Complex Date and Time Functions

Section 81: Excel 2016 Advanced: Text Functions

Lecture 187 Using Text Functions - Part 1

Lecture 188 Using Text Functions - Part 2

Section 82: Excel 2016 Advanced: Logical Functions

Lecture 189 Using Logical Functions

Lecture 190 Exercise 01

Section 83: Excel 2016 Advanced: Lookup Functions

Lecture 191 HLOOKUP Function

Lecture 192 VLOOKUP Function

Lecture 193 Exercise 02

Section 84: Excel 2016 Advanced: Financial Functions

Lecture 194 Financial Functions and Terminology

Lecture 195 Personal Financial Functions

Lecture 196 Professional Financial Functions

Lecture 197 Depreciation

Lecture 198 Exercise 03

Section 85: Excel 2016 Advanced: Statistical Functions

Lecture 199 Statistical Functions for Description - Part 1

Lecture 200 Statistical Functions for Description - Part 2

Lecture 201 Statistical Functions for Forecasting - Part 1

Lecture 202 Statistical Functions for Forecasting - Part 2

Lecture 203 Exercise 04

Lecture 204 One Click Forecasting

Lecture 205 Statistical Functions for Inference

Section 86: Excel 2016 Advanced: Connecting to External Data

Lecture 206 Connecting to Other Workbooks

Lecture 207 Connecting to Access Databases

Lecture 208 Connecting to Web Data Sources

Lecture 209 Get and Transform

Lecture 210 Exercise 05

Section 87: Excel 2016 Advanced: Tables

Lecture 211 Introduction to Tables

Lecture 212 Working with Tables

Lecture 213 Table References

Lecture 214 Table Styles

Lecture 215 Exercise 06

Section 88: Excel 2016 Advanced: Pivot Tables

Lecture 216 Introduction to Pivot Tables

Lecture 217 Working with Pivot Tables

Lecture 218 Filters and Slicers

Lecture 219 Pivot Charts

Lecture 220 Exercise 07

Section 89: Excel 2016 Advanced: Data Analysis

Lecture 221 What If Analysis

Lecture 222 Scenario Manager

Lecture 223 Goal Seeker

Lecture 224 Solver

Section 90: Excel 2016 Advanced: Graphs and Charts

Lecture 225 Area Charts

Lecture 226 Surface Charts

Lecture 227 Radar Charts

Lecture 228 Bubble Charts

Lecture 229 Sparklines

Lecture 230 Stock Charts

Lecture 231 Exercise 09

Section 91: Excel 2016 Advanced: Excel Web App

Lecture 232 Web App - Part 1

Lecture 233 Web App - Part 2

Section 92: Excel 2016 Advanced: Conclusion

Lecture 234 Closing Message

Those new to using Microsoft Excel 2013 or 2016.,No previous knowledge of Excel required. This course is created for absolute beginners.,If you want to refresh your memory and understanding of Excel.,Users of earlier versions of Excel looking to update their skills.,Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2013 or 2016 knowledge.

Homepage


9onlineofflineandcont4mcqc.jpg






 
Chinese Language For Beginners,Mandarin Chinese Hsk1 Course

famnctdxfb5yprsiu9rrj0pd78.jpg


Chinese Language For Beginners,Mandarin Chinese Hsk1 Course
Published 8/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 11.84 GB | Duration: 20h 40m

Learn Chinese,Mandarin Chinese,HSK1 Mock test,Chinese beginner course progressing students beyond HSK 1



What you'll learn
Lesson 1: "Hello!你好!"
Lesson 2:"Thank you! 谢谢你!"
Lesson 3:"What's your name?你叫什么名字?"
Lesson 4:"She is my Chinese teacher.她是我的汉语老师."
Lesson 5:"Her daughter is 20 years old this year. 她女儿今年20岁."
Lesson 6:"I can speak Chinese. 我会说汉语."
Lesson 7:"What's the date today?今天几号?"
Lesson 8:" I'd like some tea. 我想喝茶. "
Lesson 9. " Where does your son work? 你儿子在哪工作?"
Lesson 10: " Can I sit here? 我能坐这儿吗? "
Lesson 11:" What's the time now? 现在几点? "
Lesson 12:" What's the weather like tomorrow? 明天天气怎么样?"
Lesson 13: " He is learning to cook Chinese food. 他在学做中国菜呢. "
Lesson 14: " She has bought quite a few clothes. 她买了不少衣服. "
Lesson 15:" I came here by air. 我是坐飞机来的. "
Epilogue and 30 Mock Tests

Requirements
Understand English
Any Chinese learner who is a complete beginner or above can take it

Description
HSK is the most authentic and widely-used Chinese textbook for overseas students. This HSK 1 standard course is consistent with the textbook, but with more detailed explanations and lots of tailor made exercises. It will move you from complete beginner to beyond HSK 1 level. It will improve your Chinese from listening, speaking, reading and writing, so you will not only pass HSK 1 exam with the ease but also be able to hold a basic conversation in daily life. This course consists of 15 lessons, covering 45 daily conversations in a variety of situations. Each lesson is divided into 8 to 14 sections, such as pronunciation, characters, warm-up, new words, text, language points, exercises, application and so on, so you can progress with your own pace and it makes it easy to find a topic if you'd like to revisit something. Besides, You can practice your spoken Chinese and interact with your teacher in the dialogue sections. The instructor also provides great examples, explanation and insights to help you remember the content.What's special:1. authoritativeFirst, this course is designed based on the most authoritative textbook. Secondly, the instructor had been teaching HSK in immersion schools for 10 years. She can help you grasp the HSK test essentials in an easy way.2. systematicEach lesson is divided into the following sections: pronunciation, characters, warm-up, new words, text, language points, exercises and application. From lesson 1 to 15, the content of each section develops from easy to difficult, step by step.3. comprehensiveEach lesson covers listening, speaking, reading and writing.4. detailedThe teacher explains everything in detail, esp. the potential questions. She provides explanation and insights to help you remember the content. That's why the course is as long as 20 hours, so far this is the longest HSK 1 course in Udemy.5. after serviceAny questions, you can contact us freely. You will get a reply within 2 working days. In addition, you can get a full refund within 30 days if you don't like the course.What's included in the course:45 daily conversationsOver 250 words and expressions;45 language points and essential grammar rules;32 speaking instructions and principles;38 writing explanations and worksheet;A full list of HSK 1 vocabulary

Overview

Section 1: Course introduction

Lecture 1 Course introduction

Section 2: Lesson 1:"Hello!你好!"

Lecture 2 Initials and Finals of Chinese Pinyin(1)

Lecture 3 Skills of Chinese Tones

Lecture 4 Chinese Syllables

Lecture 5 Tone Sandhi: 3rd tone +3rd tone

Lecture 6 Strokes of Chinese Characters(1),Single-Component Characters

Lecture 7 New words

Lecture 8 Text

Lecture 9 Classroom Activities

Section 3: Lesson 2:"Thank you !谢谢你!"

Lecture 10 Initials and Finals of Chinese Pinyin(2)

Lecture 11 Pronounce monosyllabic & disyllabic words

Lecture 12 The Neutral Tone

Lecture 13 Rules of Pinyin(1):Part(1) Tone Marking

Lecture 14 Rules of Pinyin(1):Part(2) Abbreviation

Lecture 15 Strokes of Chinese Characters(2),Single-Component Characters

Lecture 16 New words

Lecture 17 Text

Lecture 18 Classroom Expression

Section 4: Lesson 3: "What's your name?你叫什么名字?"

Lecture 19 Pronunciation of the initials "j","q","x"

Lecture 20 Pronunciation of the initials "z","c","s"

Lecture 21 Pronunciation of the finals "i","u","ü"

Lecture 22 Tone Sandhi of "不(bù)"

Lecture 23 Rules of Pinyin(2) Pay attention to the form and pronunciation of "ü"

Lecture 24 Strokes of Chinese Characters(3),Single-Component Characters,Strokes Order(1)

Lecture 25 Warm up

Lecture 26 New words

Lecture 27 Language Points

Lecture 28 Text 1 What's your name?

Lecture 29 Text 2 Are you a teacher?

Lecture 30 Text 3 Are you Chinese?

Lecture 31 Classroom exercises

Lecture 32 Application

Section 5: Lesson 4:"She is my Chinese teacher.她是我的汉语老师."

Lecture 33 Pronunciation of the initials "zh"、"ch"、"sh"、"r"

Lecture 34 Pronunciation of the alveolar "n" and the velar nasal "nɡ"

Lecture 35 Tone Sandhi of "一(yī)"

Lecture 36 Rules of Pinyin(3):use of "y" and "w"

Lecture 37 Strokes of Chinese Characters(4),Single-Component Characters,Strokes Order(2)

Lecture 38 Warm-up

Lecture 39 New Words

Lecture 40 Text 1 who is she?

Lecture 41 Text 2 Where are you from?

Lecture 42 Text 3 what about her?

Lecture 43 Language points (Part 1)

Lecture 44 Language points (Part 2)

Lecture 45 Classroom exercises

Lecture 46 Application

Section 6: Lesson 5:"Her daughter is 20 years old this year. 她女儿今年20岁."

Lecture 47 The Retroflex Final

Lecture 48 Pronunciation of the finals beginning with "i","u","ü"

Lecture 49 Difference between Aspirated and Unaspirated Initials

Lecture 50 Rules of Pinyin(4): syllable-dividing mark

Lecture 51 Strokes of Chinese Characters(5),Single-Component Characters,Strokes Order(3)

Lecture 52 Warm-up

Lecture 53 New Words

Lecture 54 Text 1 How many people are there in your family ?

Lecture 55 Text 2 How old is your daughter?

Lecture 56 Text 3 How old is Mr. Li?

Lecture 57 Language Points

Lecture 58 Classroom exercises

Lecture 59 Application

Section 7: Lesson 6:"I can speak Chinese. 我会说汉语."

Lecture 60 Tone Collocation in Disyllabic Words(1)

Lecture 61 Chinese Strokes Characters(6),Single-Component Characters,Structure of Character

Lecture 62 warm-up

Lecture 63 New Words

Lecture 64 Text 1 Can you speak Chinese?

Lecture 65 Text 2 Is Chinese food delicious?

Lecture 66 Text 3 Can you write Chinese?

Lecture 67 Language Points

Lecture 68 Classroom exercises

Lecture 69 Application

Section 8: Lesson 7:"What's the date today?今天几号?"

Lecture 70 Tone Collocation in Disyllabic Words(2)

Lecture 71 Single-Component Characters;Structure of Characters(2);Chinese Radicals

Lecture 72 warm-up

Lecture 73 New Words

Lecture 74 Text 1 What's the date today please?

Lecture 75 Text 2 Look at the calendar

Lecture 76 Text 3 In a coffee house

Lecture 77 Language Points

Lecture 78 Exercises

Lecture 79 Application

Section 9: Lesson8. " I'd like some tea. 我想喝茶. "

Lecture 80 Tone Collocation in Disyllabic Words(3)

Lecture 81 Characters Strokes, Structure of Characters(3), Chinese Radicals

Lecture 82 warm-up

Lecture 83 New Words

Lecture 84 Text 1 In the restaurant

Lecture 85 Text 2 In the living room

Lecture 86 Text 3 In a store

Lecture 87 Language Points

Lecture 88 Exercises

Lecture 89 Application

Section 10: Lesson9. " Where does your son work? 你儿子在哪工作?"

Lecture 90 Tone Collocation in Disyllabic Words(4)

Lecture 91 Chinese Characters Strokes, Structure and Chinese Radicals

Lecture 92 warm-up

Lecture 93 New Words

Lecture 94 Text 1 At home

Lecture 95 Text 2 At the railway station

Lecture 96 Text 3 On the phone

Lecture 97 Language Points

Lecture 98 Exercises

Lecture 99 Application

Section 11: Lesson10: " Can I sit here? 我能坐这儿吗? "

Lecture 100 Neutral-Tone Syllables

Lecture 101 Chinese Characters Strokes, Structure and Chinese Radicals

Lecture 102 Warm up

Lecture 103 New words

Lecture 104 Text 1 In the office

Lecture 105 Text 2 In the gym

Lecture 106 Text 3 In the library

Lecture 107 Language Points

Lecture 108 Exercises

Lecture 109 Application

Lecture 110 Culture

Section 12: Lesson11:" What's the time now? 现在几点? "

Lecture 111 Function of Neutral-Tone Syllables

Lecture 112 Characters Strokes, Chinese Radicals

Lecture 113 warm-up

Lecture 114 New Words

Lecture 115 Text 1 What time is it now?

Lecture 116 Text 2 When is dad coming home?

Lecture 117 Text 3 I'll go to Beijing on Monday

Lecture 118 Language Points

Lecture 119 Exercises

Lecture 120 Application

Section 13: Lesson 12:" What's the weather like tomorrow? 明天天气怎么样?"

Lecture 121 Tone Collocation in Trisyllabic Words(1)

Lecture 122 Characters Strokes, Chinese Radicals

Lecture 123 Warm up

Lecture 124 New words

Lecture 125 Text 1 On the road

Lecture 126 Text 2 In the gym(2)

Lecture 127 Text 3 In the sickroom

Lecture 128 Language Points

Lecture 129 Exercises

Lecture 130 Application

Section 14: Lesson 13: " He is learning to cook Chinese food. 他在学做中国菜呢. "

Lecture 131 Tone Collocation in Trisyllabic Words(2)

Lecture 132 Characters Strokes, Chinese Radicals

Lecture 133 Warm up

Lecture 134 New words

Lecture 135 Text 1 Hello, what are you doing?

Lecture 136 Text 2 In a coffee house

Lecture 137 Text 3 In the school office

Lecture 138 Language Points (Part 1)

Lecture 139 Language Points (Part 2)

Lecture 140 Language Points (Part 3)

Lecture 141 Exercises

Lecture 142 Application

Section 15: Lesson 14: " She has bought quite a few clothes. 她买了不少衣服. "

Lecture 143 Tone Collocation in Trisyllabic Words(3)

Lecture 144 Characters Strokes, Chinese Radicals

Lecture 145 Warm up

Lecture 146 New words

Lecture 147 Text 1 In the dorm

Lecture 148 Text 2 In the company

Lecture 149 Text 3 Outside a store

Lecture 150 Language Points (Part 1)

Lecture 151 Language Points (Part 2)

Lecture 152 Language Points (Part 3)

Lecture 153 Language Points (Part 4)

Lecture 154 Exercises

Lecture 155 Application

Section 16: Lesson 15. " I came here by air. 我是坐飞机来的. "

Lecture 156 Tone Collocation in Trisyllabic Words(4)

Lecture 157 Characters Strokes, Chinese Radicals

Lecture 158 Warm up

Lecture 159 New words

Lecture 160 Text 1 At the dining table

Lecture 161 Text 2 Outside a hotel

Lecture 162 Text 3 Nice to meet you!

Lecture 163 Language Points (Part 1)

Lecture 164 Language Points (Part 2)

Lecture 165 Exercises

Lecture 166 Application

Lecture 167 Culture(2)

Section 17: Epilogue and 30 downloadable mock tests

Lecture 168 Epilogue

Students who plan to study Chinese,HSK test takers,Any Chinese learner who is a complete beginner or above can take it

Homepage


70tonecollocationindinwi1f.jpg








 
Zurück
Oben Unten