Invact Finance Associate

Invact Finance Associate - 8

An Intense training where you will be creating Financial Models and Forecasting Income Statement and other financial concepts.

Enroll for free

Course curriculum

1. GS-101-Data Entry and Arithmetic Operation-Part 1
2. GS101A.1_[Class Exercise]Result and Marks
3. GS101A.1_[Practice Exercise]Quiz Score
4. GS101A.1_[Practice Exercise]Social Media Usage
5. GS-101-Data Entry and Arithmetic Operation-Part 2
6. GS101A.2_[Class Exercise]Result and Marks
7. GS101A.2_[Practice Exercise]Average Quiz Score
8. GS101A.2_[Practice Exercise]Average Social Media Usage
1. GS-102-Multiplication and Sum Function-Part 1
2. GS102A.1_[Class Exercise]Grocery Expense
3. GS102A.1_[Practice Exercise]Riya Shopping Expense
4. GS-102-Multiplication and Sum Function-Part 2
5. GS102A.2 [Class Exercise]Grocery Expense
6. GS102A.2_[Practice Exercise]Riya Shopping Expense
1. GS-201-Dragging 1
2. GS201A.1_[Class Exercise]Morning Ritual Time Tracker
3. GS201A.1_[Practice Exercise]Children Activity Tracker
4. GS201A.1_[Practice Exercise]ScreenMedia Tracker
1. 1.GS-202-Dragging 2-Part 1 (Same Increment)
2. GS202A.1[Class Exercise1]Study Record Tracker
3. GS202A.1[Practice Exercise1]Steps count tracker
4. GS-202-Dragging 2-Part 2 (Different Increment)
5. GS202A.2[Class Exercise]Youtube Views
6. GS202A.2[Practice Exercise 1]Instagram follower Tracker
1. GS-203-Dragging 3-Part 1 (Same Decrement)
2. GS203A.1_[Class Exercise1]Weight Loss Tracker
3. GS203A.1_[Practice Exercise1]Water Tank Storage
4. GS-203-Dragging 3-Part 2 (Different Decrement)
5. GS203A.2_[Class Exercise2]Electricity Consumption Tracker
6. GS203A.2_[Practice Exercise 2]Calorie Intake Tracker
1. GS-204-Dragging 4 (Percentage Increment)
2. GS204A.1_[Class Exercise]Friends Savings Tracker
3. GS204A.1_[Practice Exercise 1]_Population Tracker
1. GS-205-Dragging 5
2. GS205A.1_[Class Exercise]Riya's total Yearly Saving
3. GS205A.1_[Practice Exercise 1]Anshu's total Yearly Savings
1. GS-301-Same Sheet Referencing-Part 1
2. GS301A.1_[Class Exercise]Fruit Spending
3. GS301A.1_[Practice exercise]Calories Calculator
4. GS-301-Same Sheet Referencing-Part 2
5. GS301A.2_[Class Exercise]Fruit Spending
6. GS301A.2_[Practice exercise]Calories Calculator
7. GS-301-Same Sheet Referencing-Part 3
8. GS301A.3_[Class Exercise]Fruit Spending
9. GS301A.3_[Practice Exercise]Calories Calculator
1. GS-302-Multi-Sheet Referencing - Part 1
2. GS302A.1_[Class Exercise]Household Expense
3. GS302A.1_[Practice Exercise]Training program expense
4. GS-302-Multi-Sheet Referencing - Part 2
5. GS302A.2_[Class Exercise]Household Expense
6. GS302A.2_[Practice Exercise]Training program expense
1. GS-400-Application of Referencing
2. GS400A.1_[Class Exercise]Electricity Bill Calculator
3. GS400A.1_[Practice Exercise]Petrol Expense Calculator
4. GS400A.1_[Practice Exercise]Ad Expense Calculator
1. A1.1 NearbyStore_Sales&Cost
2. [ClassExercise]A1.1 Nearby Store_Sales&Cost
3. Exercise A1.1 Sai Bottles_Sales&Cost
4. Exercise A1.1 Anu Dairy_Sales&Cost
5. Exercise A1.1 Vocal for Local_Sales&Cost
1. A1.2 NearbyStore_Cash Balances
2. [ClassExercise]A1.2 Nearby Store_Cash Balances
3. Exercise A1.2 Sai Bottles_Cash Balances
4. Exercise A1.2 Anu Dairy_Cash Balances
5. Exercise A1.2 Vocal for Local_Cash Balances
1. A1.3 NearbyStore_Stock Balances
2. [ClassExercise]A1.3 Nearby Store_Stock Balances
3. Exercise A1.3 Sai Bottles_Stock Balances
4. Exercise A1.3 Anu Dairy_Stock Balances
5. Exercise A1.3 Vocal for Local_Stock Balances
1. A1.4 NearbyStore_Stock Wastage
2. [ClassExercise]A1.4 Nearby Store_Stock Wastage
3. Exercise A1.4 Sai Bottles_Stock Wastage
4. Exercise A1.4 Anu Dairy_Stock Wastage
5. Exercise A1.4 Vocal for Local_Stock Wastage
1. A1.5 NearbyStore_Purchase Payments
2. [Class Exercise]A1.5 NearbyStore_Purchase Payments
3. Exercise A1.5 Sai Bottles_Purchase Payments
4. Exercise A1.5 Anu Dairy_Purchase Payments
5. Exercise A1.5 Vocal for Local_Purchase Payments
1. A1.6 NearbyStore_Product Calculation
2. [ClassExercise]A1.6 Nearby Store_Product Calculation
3. Exercise A1.6 Sai Bottles_Product Calculation
4. Exercise A1.6 Anu Dairy_Product Calculation
5. Exercise A1.6 Vocal for Local_Product Calculation
1. [Full Exercise 1-Question]A1.7 Oho Cake
2. [Full Exercise 2-Question]A1.7 Flower House
3. [Final Assignment-Question]A1.8 Dubey Dry Fruits
1. A2.1 Tea Shop_Sales_Cost_and_Cash Balance
2. [ClassExercise]A2.1 TeaShop_Sales_Cost_&_CashBalances
3. Exercise A2.1 Biryani Corner_Sales_Cost_&_Cash Balance
4. Exercise A2.1 Pakora Shop_Sales_Cost_&_Cash Balance
5. Exercise A2.1 Sandwich Centre_Sales_Cost_&_Cash Balance
1. A2.2 Tea Shop_Stock_Wastages
2. [ClassExercise]A2.2 TeaShop_Stock Wastages
3. Exercise A2.2 Biryani Corner_Stock Wastages
4. Exercise A2.2 Pakora Shop_Stock Wastages
5. Exercise A2.2 Sandwich Centre_Stock Wastages
1. A2.3 Multiple_Customers
2. [ClassExercise]A2.3 TeaShop_Multiple Customers
3. Exercise A2.3 Biryani Corner_Multiple Customers
4. Exercise A2.3 Pakora Shop_Multiple Customers
5. Exercise A2.3 Sandwich Centre_Multiple Customers
1. A2.4 Sales_Collections
2. [ClassExercise]A2.4 TeaShop_Sales Collections
3. Exercise A2.4 Biryani Corner_Sales Collections
4. Exercise A2.4 Pakora Shop_Sales Collections
5. Exercise A2.4 Sandwich Centre_Sales Collections
1. A2.5 Purchase_Payments
2. [ClassExercise]A2.5 TeaShop_Purchase Payments
3. Exercise A2.5 Biryani Corner_Purchase Payments
4. Exercise A2.5 Pakora Shop_Purchase Payments
5. Exercise A2.5 Sandwich Centre_Purchase Payments
1. [Full Exercise 1]A2.6 Momos Magic
2. [Full Exercise 2]A2.6 Paratha Junction
3. [Final Assignment]A2.7 Poha Stall
1. A3.1 Sales Growth
2. [ClassExercise]A3.1 BurgerJoint_Sales Growth
3. Exercise A3.1 Bhaiyaji VadaPav_Sales Growth
4. Exercise A3.1 Rolls on Wheels_Sales Growth
5. Exercise A3.1 Creamy Bliss_Sales Growth
1. A3.2 Additional_Product
2. [ClassExercise]A3.2 BurgerJoint_Additional_Product
3. Exercise A3.2 Bhaiyaji VadaPav_Additional Product
4. Exercise A3.2 Rolls on Wheels_Additional Product
5. Exercise A3.2 Creamy Bliss_Additional Product
1. [Full Exercise 1]A3.3 Wokonaka Chowmein
2. [Full Exercise 2]A3.3 Ravi Chaat Corner
3. [Final Assignment]A3.4Srikanta Dosa Shop
1. A4.1 SportsShop_Forecasting_Sales_1
2. [ClassExercise]A4.1 SportsShop_Forecasting_Sales_1
3. Exercise A4.1 Magazine Store_Forecasting_Sales_1
4. Exercise A4.1 Clothes Shop_Forecasting_Sales_1
5. Exercise A4.1 Plasticware Store_Forecasting_Sales_1
1. A4.2 SportsShop_Forecasting_Sales_2
2. [ClassExercise]A4.2 SportsShop_Forecasting_Sales_2
3. Exercise A4.2 Magazine Store_Forecasting_Sales_2
4. Exercise A4.2 Clothes Shop_Forecasting_Sales_2
5. Exercise A4.2 Plasticware Store_Forecasting_Sales_2
1. [Full Exercise 1]A4.3 Stationery Store
2. [Full Exercise 2]A4.3 Footwear Shop
3. [Final Assignment]A4.4 Gadget Accessories Store
1. A5.1 Biscuit Factory_Raw Material Plan
2. [ClassExercise]A5.1 Biscuit Factory_Raw Material Plan
3. Exercise A5.1 ChocolateCompany_Raw Material Plan
4. Exercise A5.1 DonutCompany_Raw Material Plan
5. Exercise A5.1 CakeCompany_Raw Material Plan
1. A5.2 Biscuit Factory_Sales and Costs-1
2. A5.2 Biscuit Factory_Sales and Costs-2
3. [ClassExercise]A5.2 Biscuit Factory_Sales and Costs
4. Exercise A5.2 ChocolateCompany_Sales and Costs
5. Exercise A5.2 DonutCompany_Sales and Costs
6. Exercise A5.2 CakeCompany_Sales and Costs
1. A5.3 Biscuit Factory_Payables and Collections
2. [ClassExercise]A5.3 Biscuit Factory_Payables and Collections
3. Exercise A5.3 Chocolate Company_Payables and Collections
4. Exercise A5.3 DonutCompany_Payables and Collections
5. Exercise A5.3 CakeCompany_Payables and Collections
1. [Full Exercise 1]A5.4 Chips Company
2. [Full Exercise 2]A5.4 Candle Company
3. [Final Assignment]A5.5 Agarbatti Company
1. A6.1 Mobile Store_Sales&Cost
2. [ClassExercise]A6.1 Mobile Store_Sales&Cost
3. Exercise A6.1 Digital device store_Sales&Cost
4. Exercise A6.1 Grooming products store_Sales&Cost
5. Exercise A6.1 Electronic store_Sales&Cost
1. A6.2 Mobile Store_MultiStore
2. [ClassExercise]A6.2 Mobile Store_MultiStore
3. Exercise A6.2 Digital device store _MultiStore
4. Exercise A6.2 Grooming products store _MultiStore
5. Exercise A6.2 Electronic store _MultiStore
1. [Full Exercise 1]A6.3 Sports goods store
2. [Full Exercise 2]A6.3 Home appliance store
3. [Final Assignment]A6.4 Furniture store
1. A7.1 Pizza outlets_Sales&costs
2. [ClassExercise]A7.1 Pizza outlets_Sales&costs
3. Exercise A7.1 Fried chicken outlet_Sales&Cost
4. Exercise A7.1 Pani puri outlet_Sales&Cost
5. Exercise A7.1 Spring rolls outlet_Sales&Cost
1. A7.2 Pizza outlets_Additional outlets
2. [ClassExercise]A7.2 Pizza outlets_Additional outlets
3. Exercise A7.2 Fried chicken outlet_Additional outlets
4. Exercise A7.2 Pani puri outlet_Additional outlets
5. Exercise A7.2 Spring roll outlet_Additional outlets
1. [Full Exercise 1]A7.3 Sandwich outlet
2. [Full Exercise 2]A7.3 Pasta outlet
3. [Final Assignment]A7.4 Coffee House
1. B1.1 Salesperson data_Functions 1
2. [ClassExercise]B1.1 Salesperson data_Functions 1
3. [PractiseExercise-1]B1.1 Student test scores
4. [PractiseExercise-2]B1.1 Sports competition points
5. [PractiseExercise-3]B1.1 Song streaming
6. [PractiseExercise-4]B1.1 Social media Ads
7. [PractiseExercise-5]B1.1 Sales of stores
1. B1.2_Salesperson data_Functions 2
2. [ClassExercise]B1.2_Salesperson data_Functions 2
3. [PractiseExercise-1]B1.2 Student test scores
4. [PractiseExercise-2]B1.2 Sports competition points
5. [PractiseExercise-3]B1.2 Song streaming
6. [PractiseExercise-4]B1.2 Social media Ads
7. [PractiseExercise-5]B1.2 Sales of stores
1. [Full Exercise-1] B1.3 Regional sales
2. [Full Exercise-2] B1.3 Movies released
3. [Full Exercise-3] B1.3 Flat rents
4. [Full Exercise-4] B1.3 Book store
5. [Final Assignment] B1.4 Food orders
1. B2.1 Employee data_Vlookup 1
2. [ClassExercise]B2.1 Employee data_Vlookup 1
3. [PractiseExercise-1]B2.1 Critic's Restaurant Ranking
4. [PractiseExercise-2]B2.1 Best seller ratings
5. [PractiseExercise-3]B2.1 Corporate tax
6. [PractiseExercise-4]B2.1 Exam Score
7. [PractiseExercise-5]B2.1 Health&Wellness Index
1. B2.2 Employee data_Vlookup 2
2. [ClassExercise]B2.2 Employee data_Vlookup 2
3. [PractiseExercise-1]B2.2 Critic's Restaurant Ranking
4. [PractiseExercise-2]B2.2 Best seller ratings
5. [PractiseExercise-3]B2.2 Corporate tax
6. [PractiseExercise-4]B2.2 Exam Score
7. [PractiseExercise-5]B2.2 Health&Wellness Index
1. B2.3 Employee data_Vlookup 3
2. [ClassExercise]B2.3 Employee data_Vlookup 3
3. [PractiseExercise-1]B2.3 Critic's Restaurant Ranking
4. [PractiseExercise-2]B2.3 Best seller ratings
5. [PractiseExercise-3]B2.3 Corporate tax
6. [PractiseExercise-4]B2.3 Exam Score
7. [PractiseExercise-5]B2.3 Health&Wellness Index
1. [Full Exercise-1] B2.4 Educational Institution Ranking
2. [Full Exercise 2] B2.4 Energy impact score
3. [Full Exercise 3] B2.4 Employee performance score
4. [Full Exercise 4] B2.4 Customer Loyalty Score
5. [Final Assignment] B2.5 Gym progress record
1. B3.1 Employee&Company data_Text functions 1
2. [ClassExercise]B3.1 Employee&Company data_Text functions 1
3. [PractiseExercise-1]B3.1 Employee&Company data 2
4. [PractiseExercise-2]B3.1 Fictional characters and Authors
5. [PractiseExercise-3]B3.1 Movies and Actors
6. [PractiseExercise-4]B3.1 Cars Data
7. [PractiseExercise-5]B3.1 Products and Types
1. B3.2 Employee&Company data_Text functions 2
2. [ClassExercise]B3.2 Employee&Company data_Text functions 2
3. [PractiseExercise-1]B3.2 Employee&Company data 2
4. [PractiseExercise-2]B3.2 Fictional characters and Authors
5. [PractiseExercise-3]B3.2 Movies and Actors
6. [PractiseExercise-4]B3.2 Cars Data
7. [PractiseExercise-5]B3.2 Products and Types
1. B3.3 Weights data_Text functions 3
2. [ClassExercise]B3.3 Weights data_Text functions 3
3. [PractiseExercise-1]B3.3 Distance Travelled
4. [PractiseExercise-2]B3.3 Number of pages
5. [PractiseExercise-3]B3.3 Movie Collections
6. [PractiseExercise-4]B3.3 Engine Capacity
7. [PractiseExercise-5]B3.3 Product Weight
1. [Full Exercise-1] B3.4 Varied Data 1
2. [Full Exercise 2] B3.4 Manufacturing units and Areas
3. [Full Exercise 3] B3.4 Varied Data 2
4. [Final Assignment] B3.5 Student ID/ Brand segregation
1. B4.1 Product bill data_IF function 1
2. [ClassExercise]B4.1 Product bill data_IF function 1
3. [PractiseExercise-1]B4.1 Perishable Products
4. [PractiseExercise-2]B4.1 Movie Tickets
5. [PractiseExercise-3]B4.1 Bonus Calculation
6. [PractiseExercise-4]B4.1 Inventory
7. [PractiseExercise-5]B4.1 Tax Calculation
1. B4.2 Product bill data_IF function 2
2. [ClassExercise]B4.2 Product bill data_IF function 2
3. [PractiseExercise-1]B4.2 Perishable Products
4. [PractiseExercise-2]B4.2 Movie Tickets
5. New [PractiseExercise-3]B4.2 Bonus Calculation
6. [PractiseExercise-4]B4.2 Inventory
7. [PractiseExercise-5]B4.2 Tax Calculation
1. B4.3 Product bill data_IF function & Vlookup
2. [ClassExercise]B4.3 Product bill data_IF function & Vlookup
3. [PractiseExercise-1]B4.3 Perishable Products
4. [PractiseExercise-2]B4.3 Movie Tickets
5. [PractiseExercise-3]B4.3 Bonus Calculation
6. [PractiseExercise-4]B4.3 Inventory
7. [PractiseExercise-5]B4.3 Tax Calculation
1. B4.4 Weights_IF & Text functions
2. [ClassExercise]B4.4 Weights_IF & Text functions
3. [PractiseExercise-1]B4.4 Wastage weights
4. [PractiseExercise-2]B4.4 Litre Conversion
5. [PractiseExercise-3]B4.4 Money Conversion
6. [PractiseExercise-4]B4.4 Currency Conversion
7. [PractiseExercise-5]B4.4 Uniform Format
1. [Full Exercise-1] B4.5 Student grades
2. [Full Exercise-2] B4.5 ID Creation
3. [Full Exercise-3] B4.5 Debtor Ageing
4. [Final Assignment] B4.6 Bank Transaction
1. B5.1 FabIndia_Data Cleaning
2. [ClassExercise]B5.1 FabIndia_Data Cleaning
3. [PractiseExercise-1]B5.1 Craftmanship Pvt Ltd.
4. [PractiseExercise-2]B5.1 Marketing Mix Pvt Ltd.
1. [ClassExercise]B5.2 FabIndia_Variance Analysis 1
2. [ClassExercise]B5.2 FabIndia_Variance Analysis 1
3. [PractiseExercise-1]B5.2 Craftmanship Pvt Ltd.
4. [PractiseExercise-2]B5.2 Marketing Mix Pvt Ltd.
1. B5.3 FabIndia_Variance Analysis 2
2. [ClassExercise]B5.3 FabIndia_Variance Analysis 2
3. [PractiseExercise-1]B5.3 Craftmanship Pvt Ltd.
4. [PractiseExercise-2]B5.3 Marketing Mix Pvt Ltd.
1. B5.4 FabIndia_Variance Analysis 3
2. [ClassExercise]B5.4 FabIndia_Variance Analysis 3
3. [PractiseExercise-1]B5.4 Craftmanship Pvt Ltd.
4. [PractiseExercise-2]B5.4 Marketing Mix Pvt Ltd.
1. [Full Exercise-1] B5.5 M&M Marketing
1. Revision Exercise 1 (Topics- A1 to A2)
2. Revision Exercise 2 (Topics- A1 to A3)
3. Revision Exercise 3 (Topics- A1 to A4)
4. Revision Exercise 4 (Topics- A1 to A5)
5. Revision Exercise 5 (Topics- A1 to A6)
6. Revision Exercise 6 (Topics- A1 to A7)
1. Revision Exercise 1- Onix Pvt Ltd
2. Revision Exercise 2- Milo Hospitals
3. Revision Exercise 3- Asis Pvt Ltd
4. Revision Exercise 4- X Factory
1. B6.1 EBS Lifestyle_Net Sales Calculation
2. [ClassExercise]B6.1 EBS Lifestyle_Net Sales Calculation
3. [PractiseExercise-1]B6.1 Vauld Ltd.
4. [PractiseExercise-2]B6.1 LearnGenius
1. B6.2 EBS Lifestyle_Variance Analysis
2. [ClassExercise]B6.2 EBS Lifestyle_Variance Analysis
3. [PractiseExercise-1]B6.2 Vauld Ltd.
4. [PractiseExercise-2]B6.2 LearnGenius
1. B6.3 EBS Lifestyle_Manager Performance Report
2. [ClassExercise]B6.3 EBS Lifestyle_Manager Performance Report
3. [PractiseExercise-1]B6.3 Vauld Ltd.
4. [PractiseExercise-2]B6.3 LearnGenius
1. B6.4 EBS Lifestyle_Customer Report
2. [ClassExercise]B6.4 EBS Lifestyle_Customer Report
3. [PractiseExercise-1]B6.4 Vauld Ltd.
4. [PractiseExercise-2]B6.4 LearnGenius
1. [Full Exercise] B6.5 DFC Consulting
1. Revision Exercise 1- ABC Insurance
2. Revision Exercise 2- VRS Retailers
3. Revision Exercise 3- Assignment- Project Costs
1. Revision Exercise 4- B2B Sales
2. Revision Exercise 5- AV Furniture Pvt Ltd.
3. Revision Exercise 6- Marketing Services
4. Revision Exercise 7- Invo Pvt Ltd.
1. C1.1 Diamond Icecream Candy_Assets Register
2. [ClassExercise]C1.1 Diamond Icecream Candy_Assets Register
3. [PractiseExercise-1]C1.1 Footwear Haven
4. [PractiseExercise-1]C1.1 Electronic Trading Co
5. [PractiseExercise-1]C1.1 King Sandwich Corner
1. C1.2 Diamond Icecream Candy_Depreciation
2. [ClassExercise]C1.2 Diamond Icecream Candy_Depreciation
3. [PractiseExercise-1]C1.2 Footwear Haven
4. [PractiseExercise-1]C1.2 Electronic Trading Co
5. [PractiseExercise-1]C1.2 King Sandwich Corner
1. C1.3 Diamond Icecream Candy_Sales&Cost
2. [ClassExercise]C1.3 Diamond Icecream Candy_Sales&Cost
3. [PractiseExercise-1]C1.3 Footwear Haven
4. [PractiseExercise-1]C1.3 Electronic Trading Co
5. [PractiseExercise-1]C1.3 King Sandwich Corner
1. C1.4 Diamond Icecream Candy_Cash details and Balances
2. [ClassExercise]C1.4 Diamond Icecream Candy_Cash details and Balances
3. [PractiseExercise-1]C1.4 Footwear Haven
4. [PractiseExercise-1]C1.4 Electronic Trading Co
5. [PractiseExercise-1]C1.4 King Sandwich Corner
1. C1.5 Diamond Icecream Candy_Asset Purchase
2. [ClassExercise]C1.5 Diamond Icecream Candy_Asset Purchase
3. [PractiseExercise-1]C1.5 Footwear Haven
4. [PractiseExercise-1]C1.5 Electronic Trading Co
5. [PractiseExercise-1]C1.5 King Sandwich Corner
1. C1.6 Diamond Icecream Candy_Multiple Asset Purchase
2. [ClassExercise]C1.6 Diamond Icecream Candy_Multiple Asset Purchase
3. [PractiseExercise-1]C1.6 Footwear Haven
4. [PractiseExercise-1]C1.6 Electronic Trading Co
5. [PractiseExercise-1]C1.6 King Sandwich Corner
1. C1.7 Diamond Icecream Candy_ Asset Disposal
2. [ClassExercise]C1.7 Diamond Icecream Candy_Asset Disposal
3. [PractiseExercise-1]C1.7 Footwear Haven
4. [PractiseExercise-1]C1.7 Electronic Trading Co
5. [PractiseExercise-1]C1.7King Sandwich Corner
1. C1.8 Diamond Icecream Candy_Multiple Asset Disposal
2. [ClassExercise]C1.8 Diamond Icecream Candy_Multiple Asset Disposal
3. [PractiseExercise-1]C1.8 Footwear Haven
4. [PractiseExercise-1]C1.8 Electronic Trading Co
5. [PractiseExercise-1]C1.8 King Sandwich Corner
1. [Full Exercise 1] C1.9 Royal Saree
2. [Full Exercise 2] C1.9 Sports Hub
3. [Final Assignment] C1.10 Gift Town
1. C2.1 TeeWave_Fixed Assets and Depreciation
2. [ClassExercise]C2.1 TeeWave_Fixed Assets and Depreciation
3. [PractiseExercise-1]C2.1 Glittering Gems_Fixed Assets and Depreciation
4. [PractiseExercise-1]C2.1 Silver Shine_Fixed Assets and Depreciation
5. [PractiseExercise-1]C2.1Auto Attire_Fixed Assets and Depreciation
1. C2.2 TeeWave_Balances
2. [ClassExercise]C2.2 TeeWave_Balances
3. [PractiseExercise-1]C2.2 Glittering Gems_Balances
4. [PractiseExercise-1]C2.2 Silver Shine_Balances
5. [PractiseExercise-1]C2.2 Auto Attire_Balances
1. C2.3 TeeWave_Asset Purchase
2. [ClassExercise]C2.3 TeeWave_Asset Purchase
3. [PractiseExercise-1]C2.3 Glittering Gems_Asset Purchase
4. [PractiseExercise-1]C2.3 Silver Shine_Asset Purchase
5. [PractiseExercise-1]C2.3 Auto Attire_Asset Purchase
1. C2.4 TeeWave_ Multiple Assets Purchase and disposal
2. [ClassExercise]C2.4 TeeWave_ Multiple Assets Purchase and disposal
3. [PractiseExercise-1]C2.4 Glittering Gems_Multiple Assets Purchase and disposal
4. [PractiseExercise-1]C2.4 Silver Shine_Multiple Assets Purchase and disposal
5. [PractiseExercise-1]C2.4 Auto Attire__Multiple Assets Purchase and disposal
1. [Full Exercise 1] C2.5 Soundwear
2. [Full Exercise 1] C2.5 Mobile Planet
3. [Final Assignment] C2.6 BlossomBloom
1. C3.1 Chocolate Factory_ Multiple Asset Purchase
2. [ClassExercise]C3.1 Chocolate Factory_ Multiple Asset Purchases
3. [PractiseExercise-1] C3.1 Buzz Bear_Multiple Asset Purchases
4. [PractiseExercise-2] C3.1 The Modak House_Multiple Asset Purchases
5. [PractiseExercise-3] C3.1 Homeify_Multiple Asset Purchases
1. C3.2 Chocolate Factory_ Multiple Asset Disposal
2. [ClassExercise]C3.2 Chocolate Factory_ Multiple Asset Disposal
3. [PractiseExercise-1] C3.2 Buzz Bear_Multiple Asset Disposal
4. [PractiseExercise-2] C3.2 The Modak House_Multiple Asset Disposal
5. [PractiseExercise-3] C3.2 Homeify_Multiple Asset Disposal
1. [Full Exercise-1] C3.3 Paint & Twist
2. [Full Exercise-2] C3.3 Samosa Shop
3. [Final Assignment] C3.4 CustomWear Creations
1. C4.1 Stationery Retailers_Small Store
2. [ClassExercise]C4.1 Stationery Retailers_Small Store
3. [PractiseExercise-1] C4.1 Suitcase stores_Small Store
4. [PractiseExercise-2] C4.1 Jewellery stores_Small Store
5. [PractiseExercise-3] C4.1 Sports stores_Small Store
1. C4.2 Stationery Retailers_Medium Store
2. [ClassExercise]C4.2 Stationery Retailers_Medium Store
3. [PractiseExercise-1] C4.2 Suitcase stores_Medium Store
4. [PractiseExercise-2] C4.2 Jewellery stores_Medium Store
5. [PractiseExercise-3] C4.2 Sports stores_Medium Store
1. C4.3 Stationery Retailers_Large Store
2. [ClassExercise]C4.3 Stationery Retailers_Large Store
3. [PractiseExercise-1] C4.3 Suitcase stores_Large Store
4. [PractiseExercise-2] C4.3 Jewellery stores_Large Store
5. [PractiseExercise-3] C4.3 Sports stores_Large Store
1. C4.4 Stationery Retailers_Consolidation
2. [ClassExercise]C4.4 Stationery Retailers_Consolidation
3. [PractiseExercise-1] C4.4 Suitcase stores_Consolidation
4. [PractiseExercise-2] C4.4 Jewellery stores_Consolidation
5. [PractiseExercise-3] C4.4 Sports stores_Consolidation
1. [Full Exercise-1] C4.5 Bedding stores
2. [Full Exercise-2] C4.5 Puja stores
3. [Final Assignment] C4.6 Bag Retailers
1. D1.1 Zoom CCTV_Equity Share Capital
2. [ClassExercise]D1.1 Zoom CCTV_Equity Share Capital
3. [PractiseExercise-1] D1.1 Luna Lens_Equity Share Capital
4. [PractiseExercise-2] D1.1 Comfort Clouds_Equity Share Capital
5. [PractiseExercise-3] D1.1 Dizzle Dazzle_Equity Share Capital
1. D1.2 Zoom CCTV_Loan and Interest
2. [ClassExercise]D1.2 Zoom CCTV_Loan and Interest
3. [PractiseExercise-1] D1.2 Luna Lens_Loan and Interest
4. [PractiseExercise-2] D1.2 Comfort Clouds_Loan and Interest
5. [PractiseExercise-3] D1.2 Dizzle Dazzle_Loan and Interest
1. D1.3 Zoom CCTV_Loan Repayment
2. [ClassExercise]D1.3 Zoom CCTV_Loan Repayment
3. [PractiseExercise-1] D1.3 Luna Lens_Loan Repayment
4. [PractiseExercise-2] D1.3 Comfort Clouds_Loan Repayment
5. [PractiseExercise-3] D1.3 Dizzle Dazzle_Loan Repayment
1. D1.4 Zoom CCTV_Dividend and Tax
2. [ClassExercise]D1.4 Zoom CCTV_Dividend and Tax
3. [PractiseExercise-1] D1.4 Luna Lens_Dividend and Tax
4. [PractiseExercise-2] D1.4 Comfort Clouds_Dividend and Tax
5. [PractiseExercise-3] D1.4 Dizzle Dazzle_Dividend and Tax
1. [Full Exercise-1] D1.5 Fast N Speedy
2. [Full Exercise-2] D1.5 Bookstore 101
3. [Final Assignment] D1.6 CellPower Solutions
1. Revision 4- Exercise 1_Whili Ltd.
2. Revision 4- Exercise 2_Namaste cafe
3. Revision 4- Exercise 3_Waffle Go
4. Revision 4- Exercise 4_Shoe Store
1. D2.1 MVF bats_Delayed Payment of Expenses I
2. [ClassExercise]D2.1 MVF bats_Delayed Payment of Expenses I
3. [PractiseExercise-1] D2.1 Electrifying Solution_Delayed Payment of Expenses I
4. [PractiseExercise-2] D2.1 Garden Decor_Delayed Payment of Expenses I
5. [PractiseExercise-3] D2.1 Creative Homes_Delayed Payment of Expenses I
1. D2.2 MVF bats_Delayed Payment of Expenses II
2. [ClassExercise]D2.2 MVF bats_Delayed Payment of Expenses II
3. [PractiseExercise-1] D2.2 Electrifying Solution_Delayed Payment of Expenses II
4. [PractiseExercise-2] D2.2 Garden Decor_Delayed Payment of Expenses II
5. [PractiseExercise-3] D2.2 Creative Homes_Delayed Payment of Expenses II
1. D2.3 MVF bats_Loan and Dividend
2. [ClassExercise]D2.3 MVF bats_Loan and Dividend
3. [PractiseExercise-1] D2.3 Electrifying Solution_Loan and Dividend
4. [PractiseExercise-2] D2.3 Garden Decor_Loan and Dividend
5. [PractiseExercise-3] D2.3 Creative Homes_Loan and Dividend
1. [Full Exercise-1] D2.4 GreenThumb Nursery
2. [Full Exercise-2] D2.4 Glitters Ltd.
3. [Final Assignment] D2.5 TechWonders
1. D3.1 Venus Chocolates_Sales & Receivables
2. [ClassExercise] D3.1 Venus Chocolates_Sales & Receivables
3. [PractiseExercise-1] D3.1 Excel Yoga_Sales & Receivables
4. [PractiseExercise-2] D3.1 Blankie Co_Sales & Receivables
5. [PractiseExercise-3] D3.1 CosmetiX_Sales & Receivables
1. D3.2 Venus Chocolates_Purchase, Expense & Stock
2. [ClassExercise] D3.2 Venus Chocolates_Purchase, Expense & Stock
3. [PractiseExercise-1] D3.2 Excel Yoga_Purchase, Expense & Stock
4. [PractiseExercise-2] D3.2 Blankie Co_Purchase, Expense & Stock
5. [PractiseExercise-3] D3.2 CosmetiX_Purchase, Expense & Stock
1. D3.3 Venus Chocolates_Asset, Capital & Loan
2. [ClassExercise] D3.3 Venus Chocolates_Asset, Capital & Loan
3. [PractiseExercise-1] D3.3 Excel Yoga_Asset, Capital & Loan
4. [PractiseExercise-2] D3.3 Blankie Co_Asset, Capital & Loan
5. [PractiseExercise-3] D3.3 CosmetiX_Asset, Capital & Loan
1. D3.4 Venus Chocolates_Profit & Loss
2. [ClassExercise] D3.4 Venus Chocolates_Profit & Loss
3. [PractiseExercise-1] D3.4 Excel Yoga_Profit & Loss
4. [PractiseExercise-2] D3.4 Blankie Co_Profit & Loss
5. [PractiseExercise-3] D3.4 CosmetiX_Profit & Loss
1. D3.5 Venus Chocolates_Cash Details
2. [ClassExercise] D3.5 Venus Chocolates_Cash Details
3. [PractiseExercise-1] D3.5 Excel Yoga_Cash Details
4. [PractiseExercise-2] D3.5 Blankie Co_Cash Details
5. [PractiseExercise-3] CosmeticX_Cash Details
1. D3.6 Venus Chocolates_Balance Sheet
2. [ClassExercise] D3.6 Venus Chocolates_Balance Sheet
3. [PractiseExercise-1] D3.6 Excel Yoga_Balance Sheet
4. [PractiseExercise-2] D3.6 Blankie Co_Balance Sheet
5. [PractiseExercise-3] D3.6 CosmetiX_Balance Sheet
1. [Full Exercise-1] D3.7 RoadGrip
2. [Full Exercise-2] D3.7 Candle Cult
3. [Final Assignment] D3.8 Ceramic World
1. Revision 5- Exercise 1_Crumbly Joy
2. Revision 5- Exercise 2_Daytime Care
3. Revision 5- Exercise 3_Jewels of Imagination
4. Revision 5- Exercise 4_Tool Hub
1. [ClassExercise]B7.1
2. [ClassExercise]B7.1
3. [PracticeExercise-1]B7.1
4. [PracticeExercise-2]B7.1
5. [PracticeExercise-3]B7.1
1. [Class Exercise]B7.2
2. [Class Exercise]B7.2
3. [PracticeExercise-1]B7.2
4. [PracticeExercise-2]B7.2
1. [Class Exercise]B7.3
2. [Class Exercise]B7.3
3. [PracticeExercise-1]B7.3
4. [PracticeExercise-2]B7.3
1. [Class Exercise]B7.4
2. [Class Exercise]B7.4
3. [PracticeExercise-1]B7.4
4. [PracticeExercise-2]B7.4
1. B7 Full Exercise 1
2. B7 Full Exercise 2
3. B7 Final Assignment
1. B8.1 Sales Analysis_Pivot Tables
2. [ClassExercise] B8.1 Sales Analysis_Pivot Tables
3. [PractiseExercise-1] B8.1 All-in-One Furnishings Sales Analysis
4. [PractiseExercise-2] B8.1 MobileMix Sales Analysis
5. [PractiseExercise-3] B8.1 OfficeMax Sales Analysis
1. [ClassExercise] B8.2 Percentage Analysis_Pivot Tables
2. [ClassExercise] B8.2 Percentage Analysis_Pivot Tables
3. [PractiseExercise-1] B8.2 All-in-One Furnishings Percentage Analysis
4. [PractiseExercise-2] B8.2 MobileMix Percentage Analysis
5. [PractiseExercise-3] B8.2 OfficeMax Percentage Analysis
1. B8.3 Count, Min, Max Analysis_Pivot Table
2. [ClassExercise] B8.3 Count, Min, Max Analysis_Pivot Table
3. [PractiseExercise-1] B8.3 All-in-One Furnishings Count, Min, Max Analysis
4. [PractiseExercise-2] B8.3 MobileMix Count, Min, Max Analysis
5. [PractiseExercise-3] B8.3 OfficeMax Count, Min, Max Analysis
1. [ClassExercise] B8.4 Multiple rows and column with filters
2. [ClassExercise] B8.4 Multiple rows and column with filters
3. [PractiseExercise-1] B8.4 All-in-One Furnishings Multiple rows and column with filters
4. [PractiseExercise-2] B8.4 MobileMix Multiple rows and column with filters
5. [PractiseExercise-3] B8.4 OfficeMax Multiple rows and column with filters
1. [Full Exercise-1] B8.5 Phone bazaar
2. [Full Exercise- 2] B8.5 Gift Shop
3. [Final Assignment] B8.6 OfficeTech & More
1. D4.1 Venus Chocolates_Quarterly Consolidation
2. [ClassExercise] D4.1 Venus Chocolates_Quarterly Consolidation
3. [PractiseExercise-1] D4.1 Excel Yoga_Quarterly Consolidation
4. [PractiseExercise-2] D4.1 Blankie Co_Quarterly Consolidation
5. [PractiseExercise-3] D4.1 CosmetiX_Quarterly Consolidation
1. D4.2 Venus Chocolates_Liquidity Ratios
2. [ClassExercise] D4.2 Venus Chocolates_Liquidity Ratios
3. [PractiseExercise-1] D4.2 Excel Yoga_Liquidity Ratios
4. [PractiseExercise-2] D4.2 Blankie Co_Liquidity Ratios
5. [PractiseExercise-3] D4.2 CosmetiX_Liquidity Ratios
1. D4.3 Venus Chocolates_Turnover Ratios
2. [ClassExercise] D4.3 Venus Chocolates_Turnover Ratios
3. [PractiseExercise-1] D4.3 Excel Yoga_Turnover Ratios
4. [PractiseExercise-2] D4.3 Blankie Co_Turnover Ratios
5. [PractiseExercise-3] D4.3 CosmetiX_Turnover Ratios
1. D4.4 Venus Chocolates_Profitability Ratios
2. [ClassExercise] D4.4 Venus Chocolates_Profitability Ratios
3. [PractiseExercise-1] D4.4 Excel Yoga_Profitability Ratios
4. [PractiseExercise-2] D4.4 Blankie Co_Profitability Ratios
5. [PractiseExercise-3] D4.4 CosmetiX_Profitability Ratios
1. D4.5 Venus Chocolates_Risk Ratios
2. [ClassExercise] D4.5 Venus Chocolates_Risk Ratios
3. [PractiseExercise-1] D4.5 Excel Yoga_Risk Ratios
4. [PractiseExercise-2] D4.5 Blankie Co_Risk Ratios
5. [PractiseExercise-3] D4.5 CosmetiX_Risk Ratios
1. D4.6 Venus Chocolates_Dupont Analysis
2. [ClassExercise] D4.6 Venus Chocolates_DuPont Analysis
3. [PractiseExercise-1] D4.6 Excel Yoga_DuPont Analysis
4. [PractiseExercise-2] D4.6 Blankie Co_DuPont Analysis
5. [PractiseExercise-3] D4.6 CosmetiX_DuPont Analysis
1. [Full Exercise-1] D4.7 RoadGrip
2. [Full Exercise-2] D4.7 Candle Cult
3. [Final Assignment] D4.8 Ceramic World

About this course

Free
600 lessons
0 hours of video content

Discover your potential, starting today

Enroll today

GS100_Introduction to Google Sheets

GS-102-Multiplication and Sum Function

GS-201-Dragging 1

GS-202-Dragging 2

GS-203-Dragging 3

GS-204-Dragging 4

GS-205-Dragging 5

GS-301-Absolute Referencing

GS-302-Mixed Referencing

GS-400-Application of Referencing

A1.1 NearbyStore_Sales&Cost

A1.2 NearbyStore_Cash Balances

A1.3 NearbyStore_Stock Balances

A1.4 NearbyStore_Stock Wastage

A1.5 NearbyStore_Purchase Payments

A1.6 NearbyStore_Product Calculation

A1.7 Full Exercises

A2.1 Sales_Cost_&_Cash Balance

A2.2 Stock_Wastages

A2.3 Multiple_Customers

A2.4 Sales_Collections

A2.5 Purchase_Payments

A2.6 Full Exercises

A3.1 Sales Growth

A3.2 Additional_Product

A3.3 Full Exercises

A4.1 Forecasting_Sales_1

A4.2 Forecasting_Sales_2

A4.3 Full Exercises

A5.1 Raw Material Plan

A5.2 Biscuit Factory_Sales and Costs

A5.3 Biscuit Factory_Payables and Collections

A5.4 Full Exercises

A6.1 Sales&Cost

A6.2 MultiStore

A6.3 Full Exercises

A7.1 Sales&costs

A7.2 Additional outlets

A7.3 Full Exercises

B1.1 Functions 1

B1.2 Functions 2

B1.3 Full Exercises

B2.1 Vlookup 1

B2.2 Vlookup 2

B2.3 Vlookup 3

B2.4 Full Exercises

B3.1 Text functions 1

B3.2 Text functions 2

B3.3 Text functions 3

B3.4 Full Exercises

B4.1 IF function 1

B4.2 IF function 2

B4.3 IF function & Vlookup

B4.4 IF & Text functions

B4.5 Full Exercises

B5.1 Data Cleaning

B5.2 Variance Analysis 1

B5.3 Variance Analysis 2

B5.4 Variance Analysis 3

B5.5 Full Exercises

Revision- Financial Modelling

Revision- Expense Variance Analysis (B5)

B6.1 Net Sales Calculation

B6.2 Variance Analysis

B6.3 Manager Performance Report

B6.4 Customer Report

B6.5 Full Exercises

Revision- Expense Variance Analysis (B5)

Revision- Sales Performance Analysis (B6)

C1.1 Asset Register

C1.2 Depreciation

C1.3 Sales&Cost

C1.4 Cash details and Balances

C1.5 Asset Purchase

C1.6 Multiple Asset Purchase

C1.7 Asset Disposal

C1.8 Multiple Asset Disposal

C1.9 Full Exercise

C2.1 Fixed Assets and Depreciation

C2.2 Cash details and Balances