Microsoft Excel and tally prime Basic to Advance Certification Course

Last updated: Tuesday August 17, 2021

4.9 by 40 Users | 112 Students Enrolled | Languages:Hindi, English

1999 7999

Hurry up, few days left at this price!

What you'll learn

  • Master Microsoft Excel from Beginner to Advanced
  • Learn the most common Excel functions used in the Office
  • Wow your boss by unlocking dynamic formulas with IF, XLOOKUP, VLOOKUP, INDEX, MATCH functions and many more
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Master unique tips, tools and case studies that you won't find in ANY other course, guaranteed
  • Become Master in using Advance Features Like Slicer, Flashfill, Sparkline charts
  • How to Import Data from Web, Tally ODBC Server
  • How to Record Macro and how VBA Works
  • Master Tally from Beginner to Advanced
  • Learn the most common Tally functions used in the Office
  • Learn How to manage Accounting of any Company with GST Independently
  • Learn how to compute TDS & extract TDS Reports
  • How to create GST Computation & Reports in Tally Prime Erp with GST
  • RCM - Reverse Charge Mechanism in Tally Prime Erp with GST Training
  • How to avail Input GST Credit
  • How to apply GST at Multiple Level

Course Description

Microsoft Excel Certificate Course

In our continuous endeavor to empower more and more finance professionals,this Microsoft Excel certification course has been designed for you.  Detailed 6 Days course has been designed where daily more than 2 hrs sessions have been organized. This Course contains Videos along with study material, Excel Files. Live trainning on Excel will be given.

How I will get the course:

This is an online Excel Certification course so there will not be any physical delivery of the lectures. After the purchase of the Excel Certification course you can see the Excel Certification course under my account option under purchased courses. All the videos, stydy materials, PDF files, PPT’s, excel files will be uploaded there for quick access of participants. This Excel Certification course is valid for 60 Days.

Who is Eligible to Join Excel Certification Course:

There is no bound on the eligibility from our side for Excel Certification Course. Any person who want to learn and master in Excel can join this course. However, it will be more beneficial for the below-mentioned persons:

⭐Commerce Graduates/CA/CS/CMA/Law students

⭐Tax professionals whether in JOB or Practice

⭐Qualified CA/CS/CMA/LLB

⭐Semi-qualified CA/CS/CMA working in CA Firms or in Industry

⭐Any other person not covered above can join course if interested.

Course Duration:

The course duration is around 12+ hours.


A Certificate of Participation from Studycafe will be provided on completion of the Excel Certification course.

Views Limitation:

This is a Completely online course, no bar on the number of views. During 60 days you can access this Excel Certification course from anywhere at any time with unlimited views.

Course Start Date:

Microsoft Excel Certification Course is starting from Aug 16, 2021 and will be completed on Aug 21, 2021.

Course Timing:

Timing: 07:00 PM to 09:00 PM.

Course Content

Day 1 - Data Cleansing & Date related Calculation Functions :

120 Mins

Alt Function, Excel Smart Shortcuts, Edit Tool Bar, Randomdata, Smart Copy Paste, Smart Paste special, Transpose, now, date function, Format Cell, Concatenate, Trim & Clean, Proper, Upper, Lower, Left, Right, Mid & Len, Filter, Advance Filter, Format Painter.

Day 2 - Advanced Features in Excel :

120 Mins

Concatenate & Text Join, Giving password to excel and back up, Advance Find & Replace, Smart Sorting, Skip Blank, TDS Working Check list, GST Late Fees Calculator, Import 26 AS data and converting in to excel

Day 3 - Advanced Excel Functions :

120 Mins

Text to Columns, Flash Fill, Remove Duplicate, Data Validation, Consolidation, Conditional Formatting, if functions, Goto Special, Macro of Spell Number, etc.

Day 4 - Advanced Excel Functions :

120 Mins

Calculate Drs Ageing, Sumif, Sumifs, Advance Subtotal, Iferror, Match Function, Vlookup, IF Error+Vlook up, IFError+Vlookup, Hlookup, Xlookup, How to Record Macro, Relative Size factor Theory (RSF) in Excel to identify red flags or fraudulent transactions in audit,

Day 5 - Advanced Excel Functions :

120 Mins

Table, Vlookup, Hlookup, X Lookup Funcation, How to Create Pivot Table, USe of Pivot Table Pivot Table, Advance Pivot Table Features, Pivot Charts, Sparkline Chart,

Day 6 - Advanced Excel Functions :

120 Mins

Preperation of Balance Sheet from trial, CFO or Management Dashboard, Extract data in Excel from NET, Excel worksheet to corporate (or Tally) database & extract any data that you want, Connect your Excel worksheet to live data on the Internet to track (for e.g.) current value of investments, Reconcillation of GSTR2A with GSTR3B ,

Day 7 - Fundamentals of Tally Prime

120 Mins

Fundamentals of Tally Prime, Accounting Masters in Tally Prime,Tally Prime Shortcuts, Difference Between Tally.ERP9 and TallyPrime,

Day 8 - Tally Prime Shortcuts & Entries

120 Mins

Purchase and Sales Entries with GST, Advanced Features in Tally Prime which includes Auto Invoice Series,

Day 9 - Advanced Features in Tally Prime

120 Mins

Advance Entries in Tally Prime like, RCM, Import, Export, SEZ, Ineligible Goods, How to pass entries for TDS, How to deduct TDS Automatically

Day 10 - Difference Between Tally.ERP9 and TallyPrime

120 Mins

Tally Back up & Restore, Technological Advantages of Tally.ERP 9, Tally.NET and Remote Capabilities, Email Facility in Tally, How to add the logo in invoices, Backup, Restore & Splitting of Company,

Day 11 - Application Management and Controls

120 Mins

Bank Reconciliation, Audit feature of How to Check who has passed the entry, Extract Report from tally in Excel with TALLY ODBC Server, Export and Import GL from XML File.

Day 12 - How to File GST Returns from Tally

120 Mins

How to File GST Returns from Tally, Tally.ERP9 Audit Features, How to Generate JSON File of E-way Bill, How to Create Cost Centres, Cost Categories in Tally, How to merge branch and HO in Tally, How to Merge Group Companies in Tally


Who can join Microsoft Excel and tally prime Basic to Advance Certification Course ?

⭐ Commerce Graduates/CA/CS/CMA/Law students ⭐ Tax professionals whether in JOB or Practice ⭐ Qualified CA/CS/CMA/LLB ⭐ Semi-qualified CA/CS/CMA working in CA Firms or in Industry ⭐ Any other person not covered above can join course if interested.

What will be Language of Microsoft Excel and tally prime Certification Course

It will be in Mix of English and Hindi Language.

What is the Duration of the Course?

Course Duration will be of more than 12 Hrs.

Whether Course Material will be Provided?

Yes, Course Material will be Provided.

Whether Course Recording will be Provided?

Yes Recording will be Provided for 60 Days.

How Can we Join ths Course?

Please register yourself and pay the fees. After paying fees you can see the Lectures in Course section.

Terms and Conditions

  • Recording will be Valid for 60 Days Only.
  • Fees will not be refunded after enrollment.


  • Required internet connection. Lectures can be viewed on Mobile or Laptop

This course includes:

  • Hindi, English
  • 12+ Hours of Video Content
  • Recording is Available for 60 Days
  • Studycafe Certificate of Completion
  • Access on mobile or Computer/Laptop
  • Downloadable Material

Certificate to be provided to all the participants.

In case of any Query Please Call us or Whats App

About Authors

Deepak Gupta

CA: Business

CA Deepak Gupta,is Co-founder of Studycafe. He is Microsoft Office Specialist and Trainer of Microsoft Excel, PowerPoint and Tally. CA Deepak Gupta, is Having more than 10 plus years of industry experience, and he has Worked with best brands Like, Hero, Wipro, Ericsson before Starting Studycafe. He has Trained more than 5000 Persons in Excel, Tally and Powerpoint.