-
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
-
-
Module-6
14-
Company Creation in Tally PrimeLecture6.1
-
Ledgers Creation in Tally PrimeLecture6.2
-
Journal Entries in Tally PrimeLecture6.3
-
Multi Rate Tax Invoices in Tally PrimeLecture6.4
-
Input Service Distributor (ISD) in Tally PrimeLecture6.5
-
Job Work out Entries in Tally PrimeLecture6.6
-
Composition Dealer entries in Tally PrimeLecture6.7
-
Purchase & Sales under Special Economic Zone (SEZ) with GSTLecture6.8
-
Job Work In entries in Tally PrimeLecture6.9
-
GST on Free sample, Donations, & DrawingsLecture6.10
-
GST Accounting for Composition Scheme DealerLecture6.11
-
Point of Sales in Tally PrimeLecture6.12
-
Payroll Voucher Entry in Tally PrimeLecture6.13
-
GST Return FilingLecture6.14
-
-
Module-7
6-
GSTR-1 Return Finalizing, Exporting & FilingLecture7.1
-
GSTR-2A Return Finalizing, Exporting & FilingLecture7.2
-
GSTR-2B Return Finalizing, Exporting & FilingLecture7.3
-
GSTR-3B Return Finalizing, Exporting & FilingLecture7.4
-
GSTR Return Tracking after FilingLecture7.5
-
Viewing of GSTR Return after filingLecture7.6
-
-
Advance excel :- Introduction to MS-Excel
10-
Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, SheetsLecture8.1
-
Difference between Excel 2003, 2007, 2010 and 2013Lecture8.2
-
Saving Excel File as PDF, CSV and Older versionsLecture8.3
-
Using Excel Shortcuts with Full List of ShortcutsLecture8.4
-
Copy, Cut, Paste, Hide, Unhide, and Linkthe Data in Rows, Columns and SheetLecture8.5
-
Using Paste Special OptionsLecture8.6
-
Formatting Cells, Rows, Columns and SheetsLecture8.7
-
Protecting & Unprotecting Cells, Rows,Columns and Sheets with or withoutPasswordLecture8.8
-
Page Layout and Printer PropertiesLecture8.9
-
Inserting Pictures and other objects in WorksheetsLecture8.10
-
-
Advance excel :- Working with Formulas/Functions
12-
Lookup and Reference Functions: VLOOKUP,HLOOKUP, INDEX, MATCH, etcLecture9.1
-
Logical Function: IF / ELSE, AND, OR, NOT,TRUE, NESTED IF/ELSE etcLecture9.2
-
Database FunctionsLecture9.3
-
Lookup and Reference Functions: VLOOKUP,Lecture9.4
-
HLOOKUP, INDEX, MATCH, etcLecture9.5
-
Logical Function: IF / ELSE, AND, OR, NOT,Lecture9.6
-
TRUE, NESTED IF/ELSE etcLecture9.7
-
Database FunctionsLecture9.8
-
Date and Time Functions: DATE, DATEVALUE,DAY, DAY360, SECOND, MINUTES,HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY,WORKDAY etcLecture9.9
-
Information Functions :Math and Trigonometry Functions: RAND, ROUND,CEILING, FLOOR, INT, LCM,MOD, EVEN, SUMIF,SUMIFS etcLecture9.10
-
Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT,COUNTA, COUNTBLANK, COUNTIF,FORECAST, MAX, MAXA ,MIN, MINA, STDEVA etcLecture9.11
-
Text Functions: LEFT, RIGHT, TEXT, TRIM, MID,LOWER, UPPER, PROPER,REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC,CONVER CONCATENATE, DOLLAR etcLecture9.12
-
-
Advance excel :- Conditional Formatting
4-
Using Conditional FormattingLecture10.1
-
Using Conditional Formatting with Cell RulesLecture10.2
-
Using Color Scales and Icon Sets in Conditional FormattingLecture10.3
-
Creating New Rules and Managing Existing RulesLecture10.4
-
-
Advance excel :- Data Sorting and Filtering
3-
Sorting Data A-Z and Z-ALecture11.1
-
Using Filters to Sort DataLecture11.2
-
Advance Filtering OptionsLecture11.3
-
-
Advance excel :- Pivot Tables
3-
Creating Pivot TablesLecture12.1
-
Using Pivot Table OptionsLecture12.2
-
Changing and Updating Data Range Formatting Pivot Table and Making Dynamic Pivot TablesLecture12.3
-
-
Advance excel :- Pivot Charts
3-
Creating Pivot ChartsLecture13.1
-
Types of Pivot Charts and Their UsageLecture13.2
-
Formatting Pivot Charts and Making Dynamic Pivot ChartsLecture13.3
-
-
Advance excel :- Data Analysis
5-
Advanced FilteringLecture14.1
-
Data validationLecture14.2
-
ConsolidationLecture14.3
-
GroupsLecture14.4
-
SubtotalLecture14.5
-
-
Advance excel :- Excel Macros
4-
What is Excel Macro ?Lecture15.1
-
How to Record / Run Excel Macro ?Lecture15.2
-
How Add Developer’s Tab in Excel 2007 / 2010Lecture15.3
-
How to add different types of controls like Text Box, Radio button, button etc. in ExcelLecture15.4
-
-
Basic Python
27-
Introduction to PythonLecture16.1
-
Python – The Universal LanguageLecture16.2
-
Installing PythonLecture16.3
-
Python – *Hello World*Lecture16.4
-
Using the InterpreterLecture16.5
-
iPython – a better Python interpreterLecture16.6
-
Types – Dynamic v/s Static Typing -tstrong v/s Weak TypingLecture16.7
-
NumbersLecture16.8
-
StringsLecture16.9
-
UnicodeLecture16.10
-
Complex TypesLecture16.11
-
Operators – Operator OverloadingLecture16.12
-
VariablesLecture16.13
-
Scopping And ExpressionsLecture16.14
-
Use of tabs and whitespaces as indentLecture16.15
-
Conditionals – for…elseLecture16.16
-
The general syntaxLecture16.17
-
Default values for argumentsLecture16.18
-
Returning and receiving multiple valuesLecture16.19
-
Variable number of arguments – args,kwargsLecture16.20
-
Scope revisitedLecture16.21
-
ListsLecture16.22
-
TuplesLecture16.23
-
Maps (or Dictionaries)Lecture16.24
-
SetsLecture16.25
-
EnumsLecture16.26
-
Looping TechniquesLecture16.27
-
-
Data Analysis with Python
25-
Installing Anaconda and Jupyter NotebookLecture17.1
-
Jupyter Notebook overviewLecture17.2
-
Importing data from a csv, text file or another databaseLecture17.3
-
Overview of various methods and attributes of NumpyLecture17.4
-
ArrayLecture17.5
-
Creating 1 dimensional arraysLecture17.6
-
Creating 2 dimensional arraysLecture17.7
-
Array indexingLecture17.8
-
Accessing array elementsLecture17.9
-
Concatenating Numpy arraysLecture17.10
-
Arithmetic operations with arraysLecture17.11
-
CovarianceLecture17.12
-
Linear RegressionLecture17.13
-
Overview of various methods and attributes of PandasLecture17.14
-
IntroductionLecture17.15
-
Working with various Series attributesLecture17.16
-
IntroductionLecture17.17
-
PivotingLecture17.18
-
SortingLecture17.19
-
AggregationLecture17.20
-
Descriptive statistical analysis with PandasLecture17.21
-
Introduction to MatplotlibLecture17.22
-
Various Matplotlib methodsLecture17.23
-
Creating Line, Scatter, Bar, etc. chartsLecture17.24
-
Customising charts using: X and Y labels, Limits, Ticks, LegendsLecture17.25
-
-
Ms Access
23-
Microsoft Access IntroductionLecture18.1
-
About Databases and NormalizationLecture18.2
-
Access Database ObjectsLecture18.3
-
Navigating MS AccessLecture18.4
-
Creating a Database and Adding TablesLecture18.5
-
Object ViewsLecture18.6
-
Simple FormsLecture18.7
-
Introduction to Controls and Formatting FormsLecture18.8
-
QueriesLecture18.9
-
Using Criteria, Operators, and WildcardsLecture18.10
-
Parameter QueriesLecture18.11
-
Relationships and JoinsLecture18.12
-
Creating Calculated ExpressionsLecture18.13
-
Summarizing DataLecture18.14
-
PivotTablesLecture18.15
-
PivotChartsLecture18.16
-
ReportsLecture18.17
-
Designing Your ReportLecture18.18
-
Advanced Formatting for ReportsLecture18.19
-
MacrosLecture18.20
-
Printing and Exporting ReportsLecture18.21
-
Importing and Exporting DataLecture18.22
-
Project( Management Information System)Lecture18.23
-
-
R Programming
34-
R–OVERVIEWLecture19.1
-
R – ENVIRONMENT SETUPLecture19.2
-
R – BASIC SYNTAXLecture19.3
-
R – DATA TYPESLecture19.4
-
R – VARIABLESLecture19.5
-
R – OPERATORSLecture19.6
-
R – DECISION MAKINGLecture19.7
-
R – LOOPSLecture19.8
-
R – FUNCTIONLecture19.9
-
R – LISTSLecture19.10
-
13.R – MATRICESLecture19.11
-
R – ARRAYSLecture19.12
-
R – FACTORSLecture19.13
-
R – DATA FRAMESLecture19.14
-
R – PACKAGESLecture19.15
-
R – DATA RESHAPING MeltLecture19.16
-
The DataLecture19.17
-
R – CSV FILESLecture19.18
-
R – EXCEL FILE Input as xlsxLecture19.19
-
R – BINARY FILESLecture19.20
-
R – XML FILESLecture19.21
-
R – WEB DATALecture19.22
-
R – DATABASESLecture19.23
-
R – PIE CHARTSLecture19.24
-
R – BAR CHARTSLecture19.25
-
R – BOXPLOTSLecture19.26
-
R – HISTOGRAMSLecture19.27
-
R – SCATTERPLOTSLecture19.28
-
R – MEAN, MEDIAN & MODELecture19.29
-
R – LINEAR REGRESSIONLecture19.30
-
R – MULTIPLE REGRESSIONLecture19.31
-
R – LOGISTIC REGRESSIONLecture19.32
-
R – NORMAL DISTRIBUTIONLecture19.33
-
R – BINOMIAL DISTRIBUTIONLecture19.34
-
This content is protected, please login and enroll course to view this content!