Microsoft Excel
Learn Excel from expert trainers. Perfect course for Accounts and HR candidates to master Excel formulas, shortcuts, spreadsheets, and daily office tasks.
Course Modules
- Introduction
- Structure
- Formatting
- Charts
- Page Setup
- Case Study 1 & 2
- Assignment 1 & 2
- Introduction
- Shortcut Keys
- Conditional Formatting
- Data Validation
- Case Study 1
- Assignment 1
- Introduction
- Formulas
- Case Study 1 & 2
- Assignment 1 & 2
- Introduction
- Advanced Excel Formula
- Pivot Table
- V Lookup & H Lookup
- Case Study 1 & 2
- Assignment 1 & 2
What We Teach: Practical Case Studies & Assignments
- Basic Accounting: Understand basic accounting & pass entries based on Practical/US Accounting rules.
- Tally Setup: Create companies, manage data, and backup/restore.
- Voucher Entries: Record transactions for the current financial year in Tally.
- Method of Accounting: Apply accounting principles in Tally.
- Ledger Finalization: Reconcile and finalize ledger balances in Tally.
- Bank Reconciliation: Prepare Bank Reconciliation Statements (BRS) in Tally.
Exam Pattern
In order to complete the course and download the certificate, you will need to complete the course.
Course completion will be considered when you have completed the following:
- Answered all of the Assessments and MCQs that come at random intervals during the course.
- Complete all of the Experiments, Case Studies and Assignments.
- Take the Final test and score at least 50% in it.
Your final marks will be evaluated as follows:
- 20% – Course MCQs
- 20% – Simulation Completion
- 60% – Final MCQ Exam (20 Questions; 30 Minutes)
Once you have completed it all, you will be provided with marks and a ‘Grade’ and you will be able to download the certificate.
Get Certified in Our Practical Courses
Enhance your skills and boost your career prospects with our comprehensive range of courses. Get certified today!
- Industry-recognized certification upon completion.
- Users can download certificate after completing the final course test.
4 Chapters
13 Case Studies
32 Assessments
10+ Recordings
20 MicroVideos
15 Languages
Get Practical Experience with Simulation!
Enhance your skills and boost your career prospects with our comprehensive range of courses. Get certified today!
Conduct unlimited experiments in FINC Lab you want.
File returns in Government (exact same) portal (Full Simulation)
How you'll learn!
Practically learn in our Lab! Get the best practical experience in all topics with Case Studies, Gamification, Simulation, etc., in your language!
More Features in Lab!
Our courses are designed based on current industry requirements, ensuring students gain practical skills that companies are looking for.
FAQs.
Get all your questions answered
How will live sessions work?
What is Simulation Experiment?
What are Short Videos?
What is Simulation?
What is Full Simulation?
Can I study in my own language?
Have More Questions?
Submit your details. Our Team will get back to you shortly.