Skip to main content
BPA Educators

BPA Educators

By BPA Educators
Listen on
Where to listen
Apple Podcasts Logo

Apple Podcasts

Breaker Logo

Breaker

Google Podcasts Logo

Google Podcasts

Overcast Logo

Overcast

Pocket Casts Logo

Pocket Casts

RadioPublic Logo

RadioPublic

Spotify Logo

Spotify

Excel 30 Day Live Session | Day 4
Excel is most useful tool in todays world 
31:01
October 12, 2020
Excel 30 Day Live Session | Day 3
Hello All,  #Welcome to #Free #30 #Day #Session of #Excel provided by #BPA #Educators . BPA Educators Launching this youtube #live knowing today's requirement of #Excel in #Market. Excel is very useful and it's a #need of today as we all know in the coming 5 years all the #traditional jobs will be #EXTINCT and the #demand for excel #experts will increase #tredemously.  Topic Covered Today  1.) #Home Tab - #ConditionalFormatting 2.)#Home Tab - #RowInsert,#ColumnInsert,#DeleteColumn,#DeleteRow 3.)#Home Tab - #Formatastable 4.)#Home Tab - #Shortcut #Keys    #Functions in excel- https://www.youtube.com/watch?v=R3GRg7lVycM&t=106s  Popular videos: How to use #pivot# table in excel https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s  Data validation in excel - https://www.youtube.com/watch?v=xDVHtUYC6w8   KEY FEATURES  1 Live project  A Certificate of #Professional #Training after the completion of the course.  OJT Certificate. OJT(On the Job Training).  To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/  Expert advice Call: +91-8512851249 Address: C-8/13, Sector-7, Rohini, Delhi-110085  Website: www.bpaeducators.com  Instagram: https://www.instagram.com/bpaeducator/  Facebook: https://www.facebook.com/bpaeducator  Twitter: https://twitter.com/EducatorsBpa  LinkedIn https://www.linkedin.com/company/bpa-educators/
39:06
September 12, 2020
Excel 30 Day Live Session | Day 2
Hello All,  #Welcome to #Free #30 #Day #Session of #Excel provided by #BPA #Educators . BPA Educators Launching this youtube #live knowing today's requirement of #Excel in #Market. Excel is very useful and it's a #need of today as we all know in the coming 5 years all the #traditional jobs will be #EXTINCT and the #demand for excel #experts will increase #tredemously.  Topic Covered Today  1.) #Home Tab - #PasteSepcial 2.)#Home Tab - #Font 3.)#Home Tab - #WrapText 4.)#Home Tab - #Numbers   #Functions in excel- https://www.youtube.com/watch?v=R3GRg7lVycM&t=106s  Popular videos: How to use #pivot# table in excel https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s   Data validation in excel - https://www.youtube.com/watch?v=xDVHtUYC6w8   KEY FEATURES  1 Live project  A Certificate of #Professional #Training after the completion of course.  OJT Certificate. OJT(On the Job Training).  To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/  Expert advice Call: +91-8512851249 Address: C-8/13, Sector-7, Rohini, Delhi-110085  Website: www.bpaeducators.com  Instagram: https://www.instagram.com/bpaeducator/  Facebook: https://www.facebook.com/bpaeducator  Twitter: https://twitter.com/EducatorsBpa  LinkedIn: https://www.linkedin.com/company/bpa-educators/
34:23
September 12, 2020
Excel 30 Day Live Session | Day 1
Hello All,  #Welcome to #Free #30 #Day #Session of #Excel provided by #BPA #Educators . BPA Educators Launching this youtube #live knowing today's requirement of #Excel in #Market. Excel is very useful and it's a #need of today as we all know in the coming 5 years all the #traditional jobs will be #EXTINCT and the #demand for excel #experts will increase #tredemously.  Topics Covered:-  1. #File Tab - #New 2. File Tab - #Open 3. File Tab - #Save 4. File Tab - #Save As 5. File Tab - #Print 6. #Home Tab - #Cut 7. Home Tab - #Copy 8. Home Tab - #Paste 9. Home Tab - #FormatPainter  And their #shortcut #key  And #Overview of #Row,#Column,#Cell,#Worksheet,#Workbook,#Data    #Functions in excel- https://www.youtube.com/watch?v=R3GRg7lVycM&t=106s  Popular videos: How to use #pivot# table in excel https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s   Data validation in excel - https://www.youtube.com/watch?v=xDVHtUYC6w8   KEY FEATURES  1 Live project  A Certificate of #Professional #Training after the completion of course.  OJT Certificate. OJT(On the Job Training).  To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/  Expert advice Call: +91-8512851249 Address: C-8/13, Sector-7, Rohini, Delhi-110085  Website: www.bpaeducators.com  Instagram: https://www.instagram.com/bpaeducator/  Facebook: https://www.facebook.com/bpaeducator  Twitter: https://twitter.com/EducatorsBpa  LinkedIn: https://www.linkedin.com/company/bpa-educators/
28:55
September 12, 2020
What is form 26AS?
Form 26AS is an annual consolidated credit statement issued under Section 203AA of the Income-tax Act, 1961. It contains details of various taxes deducted on your income by deductors: be it your employer, bank, or even a tenant.  check the video to know in detail about 26AS form  BPA Educators offer Basic and advance courses in taxes and accounting, which helps you run your business properly and manage your business wisely.   #26AS #whatis26as #tds #directtax #taxes #tax #bpaeducators  #learnwithbpa #bpamastery #learndirecttax #bpainbihar #Bpaindelhi #learnwithbpa #BPAisbest    Linked videos:  What is GST-https://www.youtube.com/watch?v=5a7BilM2S9s   Popular videos: How to use a pivot table in excel https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s    KEY FEATURES   1 Live project   A Certificate of Professional Training after the completion of course.   OJT Certificate.  OJT(On the Job Training).    To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/    Expert advice  Call: +91-8512851249  Address: C-8/13, Sector-7, Rohini, Delhi-110085   Website: www.bpaeducators.com   Instagram: https://www.instagram.com/bpaeducator/   Facebook: https://www.facebook.com/bpaeducator   Twitter: https://twitter.com/EducatorsBpa   LinkedIn: https://www.linkedin.com/company/bpa-educators/
10:39
July 28, 2020
What is Input Tax Credit (ITC)?
Input Tax Credit means reducing the taxes paid on inputs from taxes to be paid on output. When any supply of services or goods is supplied to a taxable person, the GST charged is known as Input Tax.  Check the video to know what is the input tax credit (ITC)  BPA Educators offer Basic and advance courses in taxes and accounting, which helps you run your business properly and manage your business wisely.   #Whatisitc #ITC #tds #GST  #taxes #tax #bpaeducators  #learnwithbpa #bpamastery #learndirecttax #bpainbihar #Bpaindelhi #learnwithbpa #BPAisbest    Linked videos:  What is GST-https://www.youtube.com/watch?v=5a7BilM2S9s   Popular videos: How to use a pivot table in excel https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s    KEY FEATURES   1 Live project   A Certificate of Professional Training after the completion of course.   OJT Certificate.  OJT(On the Job Training).    To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/    Expert advice Call: +91-8512851249  Address: C-8/13, Sector-7, Rohini, Delhi-110085   Website: www.bpaeducators.com   Instagram: https://www.instagram.com/bpaeducator/   Facebook: https://www.facebook.com/bpaeducator   Twitter: https://twitter.com/EducatorsBpa   LinkedIn: https://www.linkedin.com/company/bpa-educators/
10:09
July 28, 2020
What are the casual taxable person?
A casual taxable person means a person who supplies taxable goods or services occasionally in a taxable Territory where he does not have a fixed place of business. The person can act as a Principal or agent or in any other capacity supply goods or services for the furtherance of business.  In this video, we will learn  Who is a casual taxable person?  BPA Educators offer Basic and advance courses in taxes and accounting, which helps you run your business properly and manage your business wisely.   #Accounts #casualperson #accounts #tax #bpaeducators #useofgst #learnwithbpa #bpamastery #learngst #bpainbihar #Bpaindelhi #tally #learnwithbpa #BPAisbest    Linked videos:  What is GST-https://www.youtube.com/watch?v=5a7BilM2S9s   Popular videos: How to use a pivot table in excel https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s  KEY FEATURES  1 Live project   A Certificate of Professional Training after the completion of course.   OJT Certificate. OJT(On the Job Training).   To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/   Expert advice Call: +91-8512851249 Address: C-8/13, Sector-7, Rohini, Delhi-110085   Website: www.bpaeducators.com   Instagram: https://www.instagram.com/bpaeducator/   Facebook: https://www.facebook.com/bpaeducator   Twitter: https://twitter.com/EducatorsBpa   LinkedIn: https://www.linkedin.com/company/bpa-educators/
07:29
July 19, 2020
How to file TDS Return
TDS Return is a summary of all the transactions related to TDS made during a quarter. TDS Return is a quarterly statement submitted by the deductor to the Income Tax Department. The statement shows a summary of all the entries for TDS collected by the deductor and the TDS paid by the deductor to the Income Tax Authority. The TDS Return statement includes details like the PAN number of the deductor & the deductees, all the detailed particulars of the TDS paid to the government and the TDS Challan information. Let us just see in this video how to file TDS RETURN?  BPA Educators offer Basic and advance courses in taxes and accounting, which helps you run your business properly and manage your business wisely. #TDS #howtofiletdsretunr @onlinereturn #directtax #taxes #tax #bpaeducators  #learnwithbpa #bpamastery #learndirecttax #bpainbihar #Bpaindelhi #learnwithbpa #BPAisbest #tdsreturn Linked videos:  What is GST-https://www.youtube.com/watch?v=5a7BilM2S9s Popular videos: How to use a pivot table in excel https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s KEY FEATURES  1 Live project A Certificate of Professional Training after the completion of course. OJT Certificate. OJT(On the Job Training). To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/   Expert advice Call: +91-8512851249 Address: C-8/13, Sector-7, Rohini, Delhi-110085 Website: www.bpaeducators.com Instagram: https://www.instagram.com/bpaeducator/ Facebook: https://www.facebook.com/bpaeducator Twitter: https://twitter.com/EducatorsBpa LinkedIn: https://www.linkedin.com/company/bpa-educators/
05:51
July 19, 2020
GST Challan
After making all adjustments and taking Input Tax Credit (ITC) available to a taxpayer, a taxpayer is required to pay any balance GST liability online.  Here is a step-by-step guide video that will help you make GST payment with ease.  BPA Educators offer Basic and advance courses in taxes and accounting, which helps you run your business properly and manage your business wisely.   #GST #GSTCHALLAN #indirecttax #taxes #tax #bpaeducators  #learnwithbpa #bpamastery #learndirecttax #bpainbihar #Bpaindelhi #learnwithbpa #BPAisbest   Linked videos:  What is GST-https://www.youtube.com/watch?v=5a7BilM2S9s   Popular videos: How to use a pivot table in excel https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s    KEY FEATURES  1 Live project   A Certificate of Professional Training after the completion of course.   OJT Certificate. OJT(On the Job Training).    To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/   Expert advice Call: +91-8512851249 Address: C-8/13, Sector-7, Rohini, Delhi-110085   Website: www.bpaeducators.com   Instagram: https://www.instagram.com/bpaeducator/   Facebook: https://www.facebook.com/bpaeducator   Twitter: https://twitter.com/EducatorsBpa   LinkedIn: https://www.linkedin.com/company/bpa-educators/
05:06
July 19, 2020
Nested IF
One IF function has one test and two possible outcomes, TRUE or FALSE. Nested IF functions, meaning one IF function inside of another, allows you to test multiple criteria and increases the number of possible outcomes.   Functions in excel- https://www.youtube.com/watch?v=R3GRg7lVycM&t=106s  Popular videos: How to use a pivot table in excel https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s   Data validation in excel - https://www.youtube.com/watch?v=xDVHtUYC6w8   KEY FEATURES   1 Live project   A Certificate of Professional Training after the completion of course.   OJT Certificate. OJT(On the Job Training).   To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/  Expert advice Call: +91-8512851249 Address: C-8/13, Sector-7, Rohini, Delhi-110085   Website: www.bpaeducators.com   Instagram: https://www.instagram.com/bpaeducator/   Facebook: https://www.facebook.com/bpaeducator   Twitter: https://twitter.com/EducatorsBpa  L inkedIn: https://www.linkedin.com/company/bpa-educators/
06:08
July 19, 2020
Sumif and CountIf in excel 2016
The Excel SUMIF function returns the sum of cells that meet a single condition. Criteria can be applied to dates, numbers, and text. The SUMIF function supports logical operators and wildcards (*,?) for partial matching.  Syntax =SUMIF (range, criteria, [sum_range])  COUNTIF is a function to count cells that meet a single criterion. COUNTIF can be used to count cells with dates, numbers, and text that meet specific criteria. The COUNTIF function supports logical operators and wildcards (*,?) for partial matching Syntax =COUNTIF (range, criteria)  BPA Educators's main aim is to offer the best of the services to our students. From the last 10 years, it is always been ‘give and take’ experience for us. We’ve learned a lot from our students and experts from different industries, also, we’ve provided our services to a lot of candidates and counsel them to decide their rightful career. We believe the sharing of knowledge is as important as utilizing it. Linked videos: Cost Center in Tally | Use of Cost Center in Tally- BPA Educators - https://www.youtube.com/watch?v=cFUbqlM0aEo  Popular videos: How to use pivot table in excel - https://www.youtube.com/watch?v=zuPy6...  Data validation in excel - https://www.youtube.com/watch?v=xDVHt... KEY FEATURES Live projects A Certificate of Professional Training after the completion of course. OJT Certificate. OJT(On the Job Training).  Expert advice Call: +91-8512851249  Address: C-8/13, Sector-7, Rohini, Delhi-110085 Email: info@bpaeducators.com Website: www.bpaeducators.com  Instagram: https://instagram.com/bpaeducator?igshid=b1rskij5lfc8 Facebook: https://www.facebook.com/bpaeducator  Twitter: https://twitter.com/bpa_educators LinkedIn: https://www.linkedin.com/in/bpa-educators-627052190/
08:42
June 19, 2020
Pivot Tables in Excel 2016
Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. Creating Pivot Table in Advance Excel 1. Select any cell in the source data table. 2. On the Ribbon, click the Insert tab. 3.In the Tables group, click Recommended PivotTables. 4. In the Recommended PivotTables window, scroll down the list, to see the suggested layouts. Click on a layout, to see a larger view. 5. Click on the layout that you want to use, then click OK. #advanceexceltutorial #pivottableinexcel #pivottableoption BPA Educators has been established with a vision to aid students and professionals in achieving their goals. We at BPA Educators understand the aspirations of young students and professionals. Our sole aim is to reduce the hassle that one can encounter while choosing the right career option. We have striven hard for the past 10 years and trained over 1000+ students till date. Our team of counselors is qualified and experienced, consisting of CA’s, CMA’s, CS, LLB, and MBA’s who have exposure to practical training with hands-on experience in the industry, having experience of 10 to 15 years and growing strong with a commitment to transform the career of students with better opportunities amongst various age groups.  Linked videos: Cost Center in Tally | Use of Cost Center in Tally- BPA Educators - https://www.youtube.com/watch?v=cFUbqlM0aEo   Popular videos: How to use pivot table in excel - https://www.youtube.com/watch?v=zuPy6...   Data validation in excel - https://www.youtube.com/watch?v=xDVHt...  KEY FEATURES Live projects A Certificate of Professional Training after the completion of course. OJT Certificate. OJT(On the Job Training).  Expert advice Call: +91-8512851249  Address: C-8/13, Sector-7, Rohini, Delhi-110085 Email: info@bpaeducators.com Website: www.bpaeducators.com  Instagram: https://instagram.com/bpaeducator?igshid=b1rskij5lfc8 Facebook: https://www.facebook.com/bpaeducator  Twitter: https://twitter.com/bpa_educators LinkedIn: https://www.linkedin.com/in/bpa-educators-627052190/
08:20
June 19, 2020
Cost Centers in Tally
A cost center is nothing but a separate department within a business to which costs can be allocated. This also includes departments that do not produce directly but incur costs to the business. For example, the manager and employees of the cost center are not accountable for the profitability and investment decisions of the business but they are responsible for some of its costs. #costcenterlecture #costcentrevideo #costcenterintally BPA Educators faculty incorporate the hands-on, inquiry-rich experiences into the training sessions. The trainers are experts in their respective areas and aim to bridge the gap between education and real-life experiences by delivering work-based learning through acute workshops and doubt clearing sessions. Excelled in the Job Oriented Training 10+ years’ experience and qualified trainers Fully practical approach  Strong placement network 1000 + satisfied and placed students   Linked videos: Cost Center in Tally | Use of Cost Center in Tally- BPA Educators - https://www.youtube.com/watch?v=cFUbqlM0aEo  Popular videos: How to use pivot table in excel - https://www.youtube.com/watch?v=zuPy6...   Data validation in excel - https://www.youtube.com/watch?v=xDVHt...  KEY FEATURES Live projects A Certificate of Professional Training after the completion of course. OJT Certificate. OJT(On the Job Training).  Expert advice Call: +91-8512851249  Address: C-8/13, Sector-7, Rohini, Delhi-110085 Email: info@bpaeducators.com Website: www.bpaeducators.com  Instagram: https://instagram.com/bpaeducator?igshid=b1rskij5lfc8 Facebook: https://www.facebook.com/bpaeducator  Twitter: https://twitter.com/bpa_educators LinkedIn: https://www.linkedin.com/in/bpa-educators-627052190/
05:52
June 19, 2020
Logical function in Excel
https://youtu.be/5a7BilM2S9s The IF function checks whether a condition is met and returns one value if true and another value if false. 1. For example, take a look at the IF function in cell C2 below. Explanation: if the score is greater than or equal to 60, the IF function returns Pass, else it returns Fail. BPA Educators offers Basic and advance courses of Microsoft Excel, which helps you to keep the data of number and analyze them properly, according to the requirements and needs. Linked videos: Functions in excel- https://www.youtube.com/watch?v=R3GRg7lVycM&t=106s Popular videos: How to use a pivot table in excel https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s Data validation in excel - https://www.youtube.com/watch?v=xDVHtUYC6w8 To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/ and also join my Mighty Community for more knowledge sharing https://bpa-mastery.mn.co/share/VQRRdW7UpMSRVFaz
07:10
June 19, 2020
Mail Merge in word 2016
😊😊 Microsoft word is one of the most important applications to be used in the office for daily work.  Mail merge is a word processing procedure that enables you to combine a document with a data file, for example a list of names and addresses, so that copies of the document are different for each person it is sent to. A mail merge is a method of taking data from a database, ... packages (e.g., Microsoft Word) are capable of performing a mail merge.   BPA Educators offers Basic and advance courses of Microsoft Excel, which helps you to keep the data of number and analyze them properly, according to the requirements and needs.   #msword #msoffice #bpa #bpaeducators #useofmsoffice #learnwithbpa #bpamastery #learmsword #Mailmerge #bestinstituteinrohini    Linked videos: How to use word 2016 - https://youtu.be/drCzCv9iJJM   Popular videos: How to use a pivot table in excel - https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s  Data validation in excel - https://www.youtube.com/watch?v=xDVHtUYC6w8   KEY FEATURES 1 Live project  A Certificate of Professional Training after the completion of course.  OJT Certificate. OJT(On the Job Training).   To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/   Expert advice Call: +91-8512851249  Address: C-8/13, Sector-7, Rohini, Delhi-110085 Website: www.bpaeducators.com  Instagram: https://www.instagram.com/bpaeducator/  Facebook: https://www.facebook.com/bpaeducator  Twitter: https://twitter.com/EducatorsBpa  LinkedIn: https://www.linkedin.com/company/bpa-educators/
09:24
May 26, 2020
Word 2016
Hello all, I am uploading new episode about what 2016 if you want video of this episode follow our facebook,youtube,Instagram and Twitter  Thanku Team BPA Educators
14:20
May 19, 2020
Introduction
Hello all
00:24
May 11, 2020