-
Computer Accounting :- Module :- 1
11-
Fundamental of AccountsLecture1.1
-
Rules of AccountsLecture1.2
-
Creating /AlteringLecture1.3
-
Deleting CompanyLecture1.4
-
Group & Ledger CreationLecture1.5
-
Journal Entries in Tally AccountingLecture1.6
-
Day Book & Cash/Bank BookLecture1.7
-
Trading & P&L AccountLecture1.8
-
Trial Balance,Balance Sheet and Reports.Lecture1.9
-
Managing Accounts of Sole ProprietorshipLecture1.10
-
Managing Accounts of Consultancy FirmLecture1.11
-
-
Module - 2
11-
GST in Tally Accounting.Lecture2.1
-
Ledgers for GSTLecture2.2
-
GST ReportsLecture2.3
-
Inventory Management.Lecture2.4
-
Purchase & sale VouchersLecture2.5
-
Creating Stock GroupLecture2.6
-
Stock Items, & unitsLecture2.7
-
Maintaining Stock & Depreciation.Lecture2.8
-
Managing Account of Partnership FirmLecture2.9
-
Bill Wise Details.Lecture2.10
-
Inventory Reports.Lecture2.11
-
-
Module :- 3
12-
Managing Account of Different IndustriesLecture3.1
-
Journal Entries with GSTLecture3.2
-
Purchase & Sales orderLecture3.3
-
Cost Centers & Cost CategoriesLecture3.4
-
Creating Custom VouchersLecture3.5
-
Godwons & Currency CreationLecture3.6
-
Bills of Material (BOM)Lecture3.7
-
Inter-Godwon TransferLecture3.8
-
Creating & Maintaing Price-ListLecture3.9
-
Interest CalculationLecture3.10
-
Maintaining PayrollLecture3.11
-
Security ControlLecture3.12
-
-
Module - 4
9-
Budgeting systems & scenariosLecture4.1
-
Variance AnalysisLecture4.2
-
Costing Systems & Cost ClassificationLecture4.3
-
Management Control SystemsLecture4.4
-
Ratio AnalysisLecture4.5
-
Cash Flow & Fund Flow StatementLecture4.6
-
Analysing and Managing InventoryLecture4.7
-
Ordering Levels of StockLecture4.8
-
System Administration Other UtilitiesLecture4.9
-
-
Module - 5
14-
CGST, SGST, IGST & UTGSTLecture5.1
-
Link between the three taxesLecture5.2
-
Composition schemeLecture5.3
-
HSN codeLecture5.4
-
What is input tax credit (ITC)Lecture5.5
-
How to avail the ITCLecture5.6
-
Electronic ledgersLecture5.7
-
Payment of taxes and taking refundsLecture5.8
-
Different types of GST invoicesLecture5.9
-
E-way billLecture5.10
-
Generation of e-way billLecture5.11
-
Provisions of reverse chargeLecture5.12
-
Cases where reverse charge is applicableLecture5.13
-
Reverse charge in TallyLecture5.14
-
-
Advance excel :- Introduction to MS-Excel
10-
Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, SheetsLecture6.1
-
Difference between Excel 2003, 2007, 2010 and 2013Lecture6.2
-
Saving Excel File as PDF, CSV and Older versionsLecture6.3
-
Using Excel Shortcuts with Full List of ShortcutsLecture6.4
-
Copy, Cut, Paste, Hide, Unhide, and Linkthe Data in Rows, Columns and SheetLecture6.5
-
Using Paste Special OptionsLecture6.6
-
Formatting Cells, Rows, Columns and SheetsLecture6.7
-
Protecting & Unprotecting Cells, Rows,Columns and Sheets with or withoutPasswordLecture6.8
-
Page Layout and Printer PropertiesLecture6.9
-
Inserting Pictures and other objects in WorksheetsLecture6.10
-
-
Advance excel :- Working with Formulas/Functions
12-
Lookup and Reference Functions: VLOOKUP,HLOOKUP, INDEX, MATCH, etcLecture7.1
-
Logical Function: IF / ELSE, AND, OR, NOT,TRUE, NESTED IF/ELSE etcLecture7.2
-
Database FunctionsLecture7.3
-
Lookup and Reference Functions: VLOOKUP,Lecture7.4
-
HLOOKUP, INDEX, MATCH, etcLecture7.5
-
Logical Function: IF / ELSE, AND, OR, NOT,Lecture7.6
-
TRUE, NESTED IF/ELSE etcLecture7.7
-
Database FunctionsLecture7.8
-
Date and Time Functions: DATE, DATEVALUE,DAY, DAY360, SECOND, MINUTES,HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY,WORKDAY etcLecture7.9
-
Information Functions :Math and Trigonometry Functions: RAND, ROUND,CEILING, FLOOR, INT, LCM,MOD, EVEN, SUMIF,SUMIFS etcLecture7.10
-
Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT,COUNTA, COUNTBLANK, COUNTIF,FORECAST, MAX, MAXA ,MIN, MINA, STDEVA etcLecture7.11
-
Text Functions: LEFT, RIGHT, TEXT, TRIM, MID,LOWER, UPPER, PROPER,REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC,CONVER CONCATENATE, DOLLAR etcLecture7.12
-
-
Advance excel :- Conditional Formatting
4-
Using Conditional FormattingLecture8.1
-
Using Conditional Formatting with Cell RulesLecture8.2
-
Using Color Scales and Icon Sets in Conditional FormattingLecture8.3
-
Creating New Rules and Managing Existing RulesLecture8.4
-
-
Advance excel :- Data Sorting and Filtering
3-
Sorting Data A-Z and Z-ALecture9.1
-
Using Filters to Sort DataLecture9.2
-
Advance Filtering OptionsLecture9.3
-
-
Advance excel :- Pivot Tables
3-
Creating Pivot TablesLecture10.1
-
Using Pivot Table OptionsLecture10.2
-
Changing and Updating Data Range Formatting Pivot Table and Making Dynamic Pivot TablesLecture10.3
-
-
Advance excel :- Pivot Charts
3-
Creating Pivot ChartsLecture11.1
-
Types of Pivot Charts and Their UsageLecture11.2
-
Formatting Pivot Charts and Making Dynamic Pivot ChartsLecture11.3
-
-
Advance excel :- Data Analysis
5-
Advanced FilteringLecture12.1
-
Data validationLecture12.2
-
ConsolidationLecture12.3
-
GroupsLecture12.4
-
SubtotalLecture12.5
-
-
Advance excel :- Excel Macros
4-
What is Excel Macro ?Lecture13.1
-
How to Record / Run Excel Macro ?Lecture13.2
-
How Add Developer’s Tab in Excel 2007 / 2010Lecture13.3
-
How to add different types of controls like Text Box, Radio button, button etc. in ExcelLecture13.4
-
-
Basic Python
27-
Introduction to PythonLecture14.1
-
Python – The Universal LanguageLecture14.2
-
Installing PythonLecture14.3
-
Python – *Hello World*Lecture14.4
-
Using the InterpreterLecture14.5
-
iPython – a better Python interpreterLecture14.6
-
Types – Dynamic v/s Static Typing -tstrong v/s Weak TypingLecture14.7
-
NumbersLecture14.8
-
StringsLecture14.9
-
UnicodeLecture14.10
-
Complex TypesLecture14.11
-
Operators – Operator OverloadingLecture14.12
-
VariablesLecture14.13
-
Scopping And ExpressionsLecture14.14
-
Use of tabs and whitespaces as indentLecture14.15
-
Conditionals – for…elseLecture14.16
-
The general syntaxLecture14.17
-
Default values for argumentsLecture14.18
-
Returning and receiving multiple valuesLecture14.19
-
Variable number of arguments – args,kwargsLecture14.20
-
Scope revisitedLecture14.21
-
ListsLecture14.22
-
TuplesLecture14.23
-
Maps (or Dictionaries)Lecture14.24
-
SetsLecture14.25
-
EnumsLecture14.26
-
Looping TechniquesLecture14.27
-
-
Data Analysis with Python
25-
Installing Anaconda and Jupyter NotebookLecture15.1
-
Jupyter Notebook overviewLecture15.2
-
Importing data from a csv, text file or another databaseLecture15.3
-
Overview of various methods and attributes of NumpyLecture15.4
-
ArrayLecture15.5
-
Creating 1 dimensional arraysLecture15.6
-
Creating 2 dimensional arraysLecture15.7
-
Array indexingLecture15.8
-
Accessing array elementsLecture15.9
-
Concatenating Numpy arraysLecture15.10
-
Arithmetic operations with arraysLecture15.11
-
CovarianceLecture15.12
-
Linear RegressionLecture15.13
-
Overview of various methods and attributes of PandasLecture15.14
-
IntroductionLecture15.15
-
Working with various Series attributesLecture15.16
-
IntroductionLecture15.17
-
PivotingLecture15.18
-
SortingLecture15.19
-
AggregationLecture15.20
-
Descriptive statistical analysis with PandasLecture15.21
-
Introduction to MatplotlibLecture15.22
-
Various Matplotlib methodsLecture15.23
-
Creating Line, Scatter, Bar, etc. chartsLecture15.24
-
Customising charts using: X and Y labels, Limits, Ticks, LegendsLecture15.25
-
-
Ms Access
23-
Microsoft Access IntroductionLecture16.1
-
About Databases and NormalizationLecture16.2
-
Access Database ObjectsLecture16.3
-
Navigating MS AccessLecture16.4
-
Creating a Database and Adding TablesLecture16.5
-
Object ViewsLecture16.6
-
Simple FormsLecture16.7
-
Introduction to Controls and Formatting FormsLecture16.8
-
QueriesLecture16.9
-
Using Criteria, Operators, and WildcardsLecture16.10
-
Parameter QueriesLecture16.11
-
Relationships and JoinsLecture16.12
-
Creating Calculated ExpressionsLecture16.13
-
Summarizing DataLecture16.14
-
PivotTablesLecture16.15
-
PivotChartsLecture16.16
-
ReportsLecture16.17
-
Designing Your ReportLecture16.18
-
Advanced Formatting for ReportsLecture16.19
-
MacrosLecture16.20
-
Printing and Exporting ReportsLecture16.21
-
Importing and Exporting DataLecture16.22
-
Project( Management Information System)Lecture16.23
-
-
R Programming
34-
R–OVERVIEWLecture17.1
-
R – ENVIRONMENT SETUPLecture17.2
-
R – BASIC SYNTAXLecture17.3
-
R – DATA TYPESLecture17.4
-
R – VARIABLESLecture17.5
-
R – OPERATORSLecture17.6
-
R – DECISION MAKINGLecture17.7
-
R – LOOPSLecture17.8
-
R – FUNCTIONLecture17.9
-
R – LISTSLecture17.10
-
13.R – MATRICESLecture17.11
-
R – ARRAYSLecture17.12
-
R – FACTORSLecture17.13
-
R – DATA FRAMESLecture17.14
-
R – PACKAGESLecture17.15
-
R – DATA RESHAPING MeltLecture17.16
-
The DataLecture17.17
-
R – CSV FILESLecture17.18
-
R – EXCEL FILE Input as xlsxLecture17.19
-
R – BINARY FILESLecture17.20
-
R – XML FILESLecture17.21
-
R – WEB DATALecture17.22
-
R – DATABASESLecture17.23
-
R – PIE CHARTSLecture17.24
-
R – BAR CHARTSLecture17.25
-
R – BOXPLOTSLecture17.26
-
R – HISTOGRAMSLecture17.27
-
R – SCATTERPLOTSLecture17.28
-
R – MEAN, MEDIAN & MODELecture17.29
-
R – LINEAR REGRESSIONLecture17.30
-
R – MULTIPLE REGRESSIONLecture17.31
-
R – LOGISTIC REGRESSIONLecture17.32
-
R – NORMAL DISTRIBUTIONLecture17.33
-
R – BINOMIAL DISTRIBUTIONLecture17.34
-
