Category: Excel

  • 100 Basic Rules for the Correct Form of Verbs: Examples and Explanations

    Mastering the correct form of verbs is essential for effective communication in English. This comprehensive guide outlines 100 basic rules with examples and explanations to help you understand and apply the appropriate verb forms in various contexts. Whether you are a beginner or an advanced learner, these rules will be a valuable reference for enhancing your grammar skills.

    কোর্স এবং সরকারী সার্টিফিকেট সম্পর্কে বিস্তারিত জানতে ক্লিক করুন এই লিংকে

    Which of the following sentences has correct subject-verb agreement?

    a) The team of players are practicing hard. b) The team of players is practicing hard.

    c) The team of players were practicing hard. d) The team of players am practicing hard.

    Choose the sentence that has the correct tense.

    a) I was going to the gym yesterday. b) I is going to the gym tomorrow.

    c) I will be going to the gym last week. d) I will be going to the gym tomorrow.

    Which of the following sentences has the correct use of the present perfect tense?
    a) She has seen that movie yesterday.
    b) She saw that movie yesterday.
    c) She had seen that movie yesterday.
    d) She has seen that movie before.

    Choose the sentence that has the correct verb form.
    a) The dog barks loudly.
    b) The dog bark loudly.
    c) The dog barked loudly.
    d) The dog is barking loudly.

    Here are 100 basic rules for the correct form of verbs with examples and explanations:

    Rule: Use the base form of a verb after ‘to.’
    Example: I want to eat pizza.
    Explanation: ‘To’ is followed by the base form ‘eat.’

    Rule: Use the past simple form for completed actions in the past.
    Example: She finished her work yesterday.
    Explanation: ‘Finished’ is the past simple form of ‘finish.’

    Rule: Use the present perfect form for actions that started in the past and continue in the present.
    Example: He has lived here for five years.
    Explanation: ‘Has lived’ is the present perfect form of ‘live.’

    Rule: Use the past perfect form to describe an action completed before another action in the past.
    Example: She had left before I arrived.
    Explanation: ‘Had left’ is the past perfect form of ‘leave.’

    Rule: Use the future simple form to express actions that will happen in the future.
    Example: I will call you tomorrow.
    Explanation: ‘Will call’ is the future simple form of ‘call.’

    Rule: Use the present continuous form for actions happening now or in the near future.
    Example: She is studying for the test.
    Explanation: ‘Is studying’ is the present continuous form of ‘study.’

    Rule: Use the past continuous form to describe ongoing actions in the past.
    Example: He was watching TV when the phone rang.
    Explanation: ‘Was watching’ is the past continuous form of ‘watch.’

    Rule: Use the present perfect continuous form for actions that started in the past and continue until now.
    Example: They have been working on this project since January.
    Explanation: ‘Have been working’ is the present perfect continuous form of ‘work.’

    Rule: Use the past perfect continuous form to describe ongoing actions completed before another action in the past.
    Example: She had been waiting for two hours when he finally arrived.
    Explanation: ‘Had been waiting’ is the past perfect continuous form of ‘wait.’

    Rule: Use the future continuous form to express actions that will be ongoing at a specific time in the future.
    Example: I will be traveling to Paris next week.
    Explanation: ‘Will be traveling’ is the future continuous form of ‘travel.’

    Rule: Use the future perfect form to describe actions that will be completed before a specific time in the future.
    Example: By next year, she will have graduated from college.
    Explanation: ‘Will have graduated’ is the future perfect form of ‘graduate.’

    Rule: Use the future perfect continuous form to describe ongoing actions that will be completed before a specific time in the future.
    Example: By the end of the week, he will have been working on this project for a month.
    Explanation: ‘Will have been working’ is the future perfect continuous form of ‘work.’

    Rule: Use modal verbs (e.g., can, could, should, might, must, etc.) followed by the base form of a verb.
    Example: You should go to the doctor.
    Explanation: ‘Should’ is a modal verb followed by the base form ‘go.’

    Rule: Use the base form of a verb after ‘do,’ ‘does,’ or ‘did.’
    Example: Did you finish your homework?
    Explanation: ‘Did’ is followed by the base form ‘finish.’

    Rule: Use the present simple form for regular actions or general truths.
    Example: The sun rises in the east.
    Explanation: ‘Rises’ is the present simple form of ‘rise.’

    Rule: Use the present simple form for third-person singular subjects (he, she, it) with the addition of ‘s’ or ‘es.’
    Example: She plays the piano.
    Explanation: ‘Plays’ is the present simple form of ‘play’ with an added ‘s’ for the third-person singular subject ‘she.’

    Rule: Use the infinitive form after auxiliary verbs like ‘be,’ ‘have,’ or ‘had.’
    Example: I have to buy groceries.
    Explanation: ‘Have to’ is followed by the infinitive form ‘buy.’

    Rule: Use ‘been’ as the past participle form of ‘be.’
    Example: She has been to Paris twice.
    Explanation: ‘Has been’ is the present perfect form of ‘be.’

    Rule: Use the gerund form (-ing) after prepositions.
    Example: I’m thinking about going on vacation.
    Explanation: ‘About’ is a preposition followed by the gerund form ‘going.’

    Rule: Use the gerund form (-ing) for activities that are the subject of a sentence.
    Example: Swimming is my favorite sport.
    Explanation: ‘Swimming’ is the subject of the sentence and is in the gerund form.

    Rule: Use the base form of a verb for imperatives (commands).
    Example: Sit down, please.
    Explanation: ‘Sit’ is the base form used as an imperative.

    Rule: Use the past participle form of a verb after ‘have’ or ‘has.’
    Example: They have visited Rome.
    Explanation: ‘Have’ is followed by the past participle form ‘visited.’

    Rule: Use the past participle form of a verb after ‘had.’
    Example: We had planned a trip, but it was canceled.
    Explanation: ‘Had’ is followed by the past participle form ‘planned.’

    Rule: Use the past participle form for passive voice sentences.
    Example: The cake was baked by Mary.
    Explanation: ‘Was baked’ is the past participle form used in the passive voice.

    Rule: Use the past participle form after ‘being’ in the passive voice.
    Example: The car is being repaired.
    Explanation: ‘Is being’ is followed by the past participle form ‘repaired.’

    Rule: Use ‘will’ or ‘won’t’ with the base form of a verb for simple future actions.
    Example: I will study tonight.
    Explanation: ‘Will’ is followed by the base form ‘study.’

    Rule: Use ‘going to’ with the base form of a verb for future actions with prior plans.
    Example: She is going to apply for a new job.
    Explanation: ‘Is going to’ is followed by the base form ‘apply.’

    Rule: Use ‘shall’ or ‘shall not’ with the base form of a verb for future actions in formal situations (mostly with ‘I’ and ‘we’).
    Example: We shall overcome this challenge.
    Explanation: ‘Shall’ is followed by the base form ‘overcome.’

    Rule: Use ‘would’ or ‘would not’ with the base form of a verb for hypothetical situations or polite requests.
    Example: If I had the money, I would travel the world.
    Explanation: ‘Would’ is followed by the base form ‘travel.’

    Rule: Use the gerund form (-ing) after ‘like,’ ‘love,’ ‘hate,’ and ‘prefer’ to express general preferences.
    Example: I love reading books.
    Explanation: ‘Love’ is followed by the gerund form ‘reading.’

    Rule: Use the infinitive form after ‘like,’ ‘love,’ ‘hate,’ and ‘prefer’ to express specific preferences.
    Example: I’d like to read that book.
    Explanation: ‘Like’ is followed by the infinitive form ‘to read.’

    Rule: Use the gerund form (-ing) after ‘stop,’ ‘finish,’ ‘quit,’ and ‘begin’ to describe the action being stopped or started.
    Example: He stopped smoking last year.
    Explanation: ‘Stopped’ is followed by the gerund form ‘smoking.’

    Rule: Use the infinitive form after ‘stop,’ ‘finish,’ ‘quit,’ and ‘begin’ to describe the purpose or reason for the action.
    Example: He stopped to buy some groceries.
    Explanation: ‘Stopped’ is followed by the infinitive form ‘to buy.’

    Rule: Use the gerund form (-ing) after ‘start,’ ‘continue,’ and ‘begin’ to describe an ongoing action.
    Example: She started working on the project.
    Explanation: ‘Started’ is followed by the gerund form ‘working.’

    Rule: Use the infinitive form after ‘need,’ ‘want,’ ‘expect,’ ‘hope,’ ‘plan,’ ‘decide,’ and ‘intend’ to describe an action that is required, desired, or anticipated.
    Example: I need to study for the exam.
    Explanation: ‘Need’ is followed by the infinitive form ‘to study.’

    Rule: Use the past participle form after ‘have’ or ‘has’ to create the present perfect tense.
    Example: They have traveled to Spain.
    Explanation: ‘Have’ is followed by the past participle form ‘traveled.’

    Rule: Use the past participle form after ‘had’ to create the past perfect tense.
    Example: She had finished her work before leaving.
    Explanation: ‘Had’ is followed by the past participle form ‘finished.’

    Rule: Use the past participle form after ‘will have’ to create the future perfect tense.
    Example: By next week, I will have completed the project.
    Explanation: ‘Will have’ is followed by the past participle form ‘completed.’

    Rule: Use the gerund form (-ing) after ‘suggest,’ ‘recommend,’ ‘admit,’ ‘deny,’ and ‘consider’ to describe the recommended or considered action.
    Example: She suggested visiting the museum.
    Explanation: ‘Suggested’ is followed by the gerund form ‘visiting.’

    Rule: Use the infinitive form after ‘allow,’ ‘permit,’ ‘encourage,’ ‘advise,’ and ‘invite’ to describe the action being allowed, permitted, or encouraged.
    Example: They allowed us to enter the building.
    Explanation: ‘Allowed’ is followed by the infinitive form ‘to enter.’

    Rule: Use the gerund form (-ing) after ‘can’t help,’ ‘can’t stand,’ ‘mind,’ and ‘avoid’ to describe the action being done.
    Example: I can’t help laughing at his jokes.
    Explanation: ‘Can’t help’ is followed by the gerund form ‘laughing.’

    Rule: Use the infinitive form after ‘agree,’ ‘arrange,’ ‘decide,’ ‘deserve,’ ‘offer,’ ‘promise,’ ‘refuse,’ and ‘threaten’ to describe the action being agreed, arranged, or decided.
    Example: She agreed to help us with the project.
    Explanation: ‘Agreed’ is followed by the infinitive form ‘to help.’

    Rule: Use the infinitive form without ‘to’ after modal verbs like ‘can,’ ‘could,’ ‘may,’ ‘might,’ ‘must,’ ‘shall,’ ‘should,’ ‘will,’ and ‘would.’
    Example: You must arrive on time.
    Explanation: ‘Must’ is followed by the base form ‘arrive’ without ‘to.’

    Rule: Use the infinitive form after ‘had better,’ ‘would rather,’ and ‘would sooner’ to describe a preference or advice.
    Example: You had better study for the test.
    Explanation: ‘Had better’ is followed by the infinitive form ‘study.’

    Rule: Use the base form of the verb after the auxiliary ‘do,’ ‘does,’ or ‘did’ in questions and negative sentences.
    Example: Do you like ice cream?
    Explanation: ‘Do’ is followed by the base form ‘like.’

    Rule: Use the base form of the verb after ‘let,’ ‘make,’ and ‘help’ in active voice sentences.
    Example: She let him borrow her car.
    Explanation: ‘Let’ is followed by the base form ‘borrow.’

    Rule: Use the infinitive form after ‘let,’ ‘make,’ and ‘help’ in passive voice sentences.
    Example: He was made to clean the room.
    Explanation: ‘Was made’ is followed by the infinitive form ‘to clean.’

    Rule: Use the gerund form (-ing) after ‘appreciate,’ ‘enjoy,’ ‘imagine,’ ‘involve,’ ‘postpone,’ ‘quit,’ and ‘risk’ to describe the action being done or considered.
    Example: They enjoyed playing soccer together.
    Explanation: ‘Enjoyed’ is followed by the gerund form ‘playing.’

    Rule: Use the infinitive form after ‘appear,’ ‘claim,’ ‘demand,’ ‘expect,’ ‘fail,’ ‘hesitate,’ ‘hope,’ ‘intend,’ ‘learn,’ ‘manage,’ ‘pretend,’ and ‘seem’ to describe the action being done or expected.
    Example: She appears to know the answer.
    Explanation: ‘Appears’ is followed by the infinitive form ‘to know.’

    Rule: Use the gerund form (-ing) or the infinitive form interchangeably after ‘start,’ ‘begin,’ ‘continue,’ and ‘like’ without a significant change in meaning.
    Example: He started to work. / He started working.
    Explanation: Both ‘to work’ and ‘working’ can be used after ‘started’ without changing the meaning.


    Rule: Use the gerund form (-ing) after ‘keep,’ ‘keep on,’ and ‘go on’ to describe an ongoing or repetitive action.
    Example: She keeps practicing every day.
    Explanation: ‘Keeps’ is followed by the gerund form ‘practicing.’

    Rule: Use the infinitive form after ‘would like,’ ‘would love,’ ‘would prefer,’ and ‘would hate’ to describe a preference or desire.
    Example: I would like to visit Japan someday.
    Explanation: ‘Would like’ is followed by the infinitive form ‘to visit.’

    Rule: Use the gerund form (-ing) after ‘feel like’ to describe a preference or inclination.
    Example: I feel like going for a walk.
    Explanation: ‘Feel like’ is followed by the gerund form ‘going.’

    Rule: Use the gerund form (-ing) after ‘can’t bear’ to describe an intolerable action or situation.
    Example: I can’t bear listening to loud music.
    Explanation: ‘Can’t bear’ is followed by the gerund form ‘listening.’

    Rule: Use the infinitive form after ‘ask,’ ‘expect,’ ‘want,’ ‘would like,’ ‘need,’ ‘require,’ ‘prefer,’ and ‘tell’ when referring to a specific action or request.
    Example: She asked me to bring the documents.
    Explanation: ‘Asked’ is followed by the infinitive form ‘to bring.’

    Rule: Use the gerund form (-ing) after ‘think about,’ ‘worry about,’ ‘complain about,’ ‘talk about,’ and ‘dream about’ to describe the action or situation being considered or discussed.
    Example: We often dream about traveling the world.
    Explanation: ‘Dream about’ is followed by the gerund form ‘traveling.’

    Rule: Use the gerund form (-ing) after ‘look forward to,’ ‘be used to,’ and ‘get used to’ to describe anticipation, familiarity, or adaptation to an action or situation.
    Example: I look forward to meeting you in person.
    Explanation: ‘Look forward to’ is followed by the gerund form ‘meeting.’

    Rule: Use the base form of the verb after ‘rather than’ when comparing actions or preferences.
    Example: She decided to study rather than go to the party.
    Explanation: ‘Rather than’ is followed by the base form ‘go.’

    Rule: Use the gerund form (-ing) after ‘instead of’ when comparing actions or preferences.
    Example: They chose to watch a movie instead of going to the park.
    Explanation: ‘Instead of’ is followed by the gerund form ‘going.’

    Rule: Use the gerund form (-ing) after ‘be worth’ to describe the value or benefit of an action.
    Example: Learning a new language is worth the effort.
    Explanation: ‘Is worth’ is followed by the gerund form ‘learning.’


    Rule: Use the infinitive form after ‘too’ and ‘enough’ when expressing the degree of an action or situation.
    Example: She is too young to drive.
    Explanation: ‘Too’ is followed by the infinitive form ‘to drive.’

    Rule: Use the infinitive form after ‘so that’ and ‘in order to’ when expressing the purpose or intention of an action.
    Example: He studied hard in order to pass the exam.
    Explanation: ‘In order to’ is followed by the infinitive form ‘pass.’

    Rule: Use the gerund form (-ing) after ‘in spite of’ and ‘despite’ when expressing contrast or contradiction.
    Example: In spite of feeling tired, she continued working.
    Explanation: ‘In spite of’ is followed by the gerund form ‘feeling.’

    Rule: Use the infinitive form after ‘to be’ when expressing obligation or necessity.
    Example: You are to complete this assignment by tomorrow.
    Explanation: ‘Are to’ is followed by the infinitive form ‘complete.’

    Rule: Use the infinitive form after ‘it’s time,’ ‘it’s high time,’ and ‘it’s about time’ when expressing that something should happen or be done.
    Example: It’s high time to start your own business.
    Explanation: ‘It’s high time’ is followed by the infinitive form ‘to start.’

    Rule: Use the past subjunctive form after ‘wish,’ ‘if only,’ and ‘as if’ when expressing a hypothetical situation, regret, or unreal condition.
    Example: I wish I knew the answer.
    Explanation: ‘Wish’ is followed by the past subjunctive form ‘knew.’

    Rule: Use the past participle form after ‘have,’ ‘has,’ or ‘had’ in passive voice sentences.
    Example: The cake has been baked by her.
    Explanation: ‘Has been’ is followed by the past participle form ‘baked.’

    Rule: Use the gerund form (-ing) after ‘by’ when expressing the means or method by which an action is done.
    Example: By practicing daily, he improved his skills.
    Explanation: ‘By’ is followed by the gerund form ‘practicing.’

    Rule: Use the base form of the verb after ‘had better,’ ‘would rather,’ and ‘would sooner’ when expressing advice or preference.
    Example: You had better leave now to avoid traffic.
    Explanation: ‘Had better’ is followed by the base form ‘leave.’

    Rule: Use the base form of the verb after the word ‘why’ when forming a question.
    Example: Why take the risk?
    Explanation: ‘Why’ is followed by the base form ‘take.’


    Rule: Use the infinitive form after ‘try’ when expressing an attempt to do something different or a new approach.
    Example: She tried to change her study habits.
    Explanation: ‘Tried’ is followed by the infinitive form ‘to change.’

    Rule: Use the gerund form (-ing) after ‘try’ when expressing an attempt to see the outcome of an action.
    Example: Try adding some spices to the dish.
    Explanation: ‘Try’ is followed by the gerund form ‘adding.’

    Rule: Use the gerund form (-ing) after ‘regret’ when expressing a past action that one wishes had not happened.
    Example: She regrets leaving her job.
    Explanation: ‘Regrets’ is followed by the gerund form ‘leaving.’

    Rule: Use the infinitive form after ‘regret’ when announcing bad news or expressing sorrow for a future action.
    Example: We regret to inform you that your application has been rejected.
    Explanation: ‘Regret’ is followed by the infinitive form ‘to inform.’

    Rule: Use the gerund form (-ing) after ‘remember’ when expressing a recollection of a past action.
    Example: I remember visiting that museum when I was a child.
    Explanation: ‘Remember’ is followed by the gerund form ‘visiting.’

    Rule: Use the infinitive form after ‘remember’ when expressing the need to perform a future action.
    Example: Remember to call your parents tonight.
    Explanation: ‘Remember’ is followed by the infinitive form ‘to call.’

    Rule: Use the gerund form (-ing) after ‘forget’ when expressing a past action that was not performed.
    Example: She forgot returning the book to the library.
    Explanation: ‘Forgot’ is followed by the gerund form ‘returning.’

    Rule: Use the infinitive form after ‘forget’ when expressing the need to perform a future action.
    Example: Don’t forget to lock the door before you leave.
    Explanation: ‘Forget’ is followed by the infinitive form ‘to lock.’

    Rule: Use the gerund form (-ing) after ‘deny’ when expressing a refutation of a past action or accusation.
    Example: He denied stealing the money.
    Explanation: ‘Denied’ is followed by the gerund form ‘stealing.’

    Rule: Use the infinitive form after ‘afford’ when expressing the ability or means to perform an action.
    Example: They can’t afford to buy a new car.
    Explanation: ‘Afford’ is followed by the infinitive form ‘to buy.’


    Rule: Use the gerund form (-ing) after ‘admit’ when acknowledging a past action or behavior.
    Example: He admitted making a mistake.
    Explanation: ‘Admitted’ is followed by the gerund form ‘making.’

    Rule: Use the infinitive form after ‘agree’ when expressing consent or approval of a future action.
    Example: They agreed to help us with the project.
    Explanation: ‘Agreed’ is followed by the infinitive form ‘to help.’

    Rule: Use the gerund form (-ing) after ‘anticipate’ when expressing expectation or prediction of a future action.
    Example: We anticipate receiving the package next week.
    Explanation: ‘Anticipate’ is followed by the gerund form ‘receiving.’

    Rule: Use the gerund form (-ing) after ‘avoid’ when expressing the prevention or evasion of an action or situation.
    Example: He avoids using public transport during rush hour.
    Explanation: ‘Avoids’ is followed by the gerund form ‘using.’

    Rule: Use the infinitive form after ‘choose’ when expressing a decision or selection of a future action.
    Example: She chose to pursue a career in medicine.
    Explanation: ‘Chose’ is followed by the infinitive form ‘to pursue.’

    Rule: Use the gerund form (-ing) after ‘consider’ when expressing a thought or deliberation about an action or situation.
    Example: They are considering moving to another city.
    Explanation: ‘Considering’ is followed by the gerund form ‘moving.’

    Rule: Use the infinitive form after ‘decide’ when expressing a resolution or determination to perform a future action.
    Example: He decided to start his own business.
    Explanation: ‘Decided’ is followed by the infinitive form ‘to start.’

    Rule: Use the gerund form (-ing) after ‘delay’ when expressing the postponement or deferment of an action or event.
    Example: She delayed submitting her application.
    Explanation: ‘Delayed’ is followed by the gerund form ‘submitting.’

    Rule: Use the infinitive form after ‘expect’ when expressing a belief or anticipation of a future action.
    Example: They expect to arrive by 8 pm.
    Explanation: ‘Expect’ is followed by the infinitive form ‘to arrive.’

    Rule: Use the gerund form (-ing) after ‘forgive’ when expressing the act of pardoning or excusing a past action.
    Example: She forgave him for lying to her.
    Explanation: ‘Forgave’ is followed by the gerund form ‘lying.’


    Rule: Use the infinitive form after ‘hope’ when expressing a desire or aspiration for a future action or event.
    Example: We hope to see you at the party.
    Explanation: ‘Hope’ is followed by the infinitive form ‘to see.’

    Rule: Use the gerund form (-ing) after ‘imagine’ when expressing the formation of a mental image or concept of an action or situation.
    Example: Can you imagine living in a world without technology?
    Explanation: ‘Imagine’ is followed by the gerund form ‘living.’

    Rule: Use the infinitive form after ‘intend’ when expressing a plan or purpose for a future action.
    Example: She intends to study abroad next year.
    Explanation: ‘Intends’ is followed by the infinitive form ‘to study.’

    Rule: Use the gerund form (-ing) after ‘mention’ when referring to a previously stated or implied action.
    Example: He mentioned seeing you at the concert last night.
    Explanation: ‘Mentioned’ is followed by the gerund form ‘seeing.’

    Rule: Use the infinitive form after ‘offer’ when expressing a proposal or suggestion for a future action.
    Example: They offered to help us with the project.
    Explanation: ‘Offered’ is followed by the infinitive form ‘to help.’

    Rule: Use the gerund form (-ing) after ‘postpone’ when expressing the act of rescheduling or deferring an action or event.
    Example: They postponed making a decision until next week.
    Explanation: ‘Postponed’ is followed by the gerund form ‘making.’

    Rule: Use the infinitive form after ‘promise’ when expressing a declaration or assurance of a future action.
    Example: He promised to visit her soon.
    Explanation: ‘Promised’ is followed by the infinitive form ‘to visit.’

    Rule: Use the gerund form (-ing) after ‘suggest’ when proposing or recommending an action or idea.
    Example: She suggested reading the book before watching the movie.
    Explanation: ‘Suggested’ is followed by the gerund form ‘reading.’

    Rule: Use the infinitive form after ‘threaten’ when expressing an intention or warning of a future action or event.
    Example: He threatened to call the police if they didn’t leave.
    Explanation: ‘Threatened’ is followed by the infinitive form ‘to call.’

    Rule: Use the gerund form (-ing) after ‘enjoy’ when describing the act of deriving pleasure or satisfaction from an action or experience.
    Example: They enjoy hiking on weekends.
    Explanation: ‘Enjoy’ is followed by the gerund form ‘hiking.’

    Why are AI tools included in CSTC’s curriculum?

    What are AI tools, and why are they important?

    AI tools are software applications that use artificial intelligence to perform tasks that typically require human intelligence, such as problem-solving, data analysis, and decision-making. Including AI tools in CSTC’s curriculum ensures that students are prepared for the future job market, where AI skills are increasingly in demand.

    How will learning AI tools benefit me?

    Learning AI tools will give you a competitive edge in the job market. These tools are used in various industries, from business intelligence to data visualization. Being proficient in AI tools like Power BI can open up new career opportunities and make you more valuable to employers.

    How does CSTC ensure the effectiveness of its computer courses?

    What teaching methods does CSTC use?

    CSTC uses a combination of classroom instruction, hands-on practice, and personalized feedback to ensure students understand and retain what they learn. The courses are designed to be comprehensive and practical, with clear objectives for each class.

    How does CSTC support students who need extra help?

    CSTC is committed to ensuring that every student masters the course material. If a student struggles with a particular concept, the teaching team provides additional support and resources. This includes repeating lessons as needed and offering personalized guidance.

    What should I expect from the CSTC computer course?

    What skills will I gain from the CSTC computer course?

    You will learn essential computer skills, including typing, using Microsoft Office applications, and data visualization with Power BI. The course also covers more advanced topics, preparing you for a wide range of tasks in the workplace or for freelancing opportunities.

    How can I enroll in a CSTC course?

    You can enroll in a CSTC course by contacting the center directly via phone (01977957783) or WhatsApp. You can also visit their Facebook profile (BDCSTC) to inquire further. Enrollment is open daily, and you can choose a schedule that fits your needs.

  • Basic Computer Course in Dhaka

    A basic computer course introduces individuals to the fundamentals of computer operation and usage. Whether you’re a complete novice or looking to refresh your skills, this course can provide a solid foundation for navigating the digital world.

    Dhaka offers many options for individuals seeking to acquire basic computer skills. From established institutes to smaller training centers, you can find a suitable course to kickstart your digital journey.

    কোর্স এবং সরকারী সার্টিফিকেট সম্পর্কে বিস্তারিত জানতে ক্লিক করুন এই লিংকে

    Key Areas Covered in Basic Computer Courses

    Typically, a basic computer course in Dhaka covers the following fundamentals:

    • Typing Skills: Developing touch typing abilities for efficiency.
    • Computer Basics: Understanding hardware and software components, operating systems (Windows, macOS), file management.
    • Internet Basics: Exploring the internet, web browsing, email, search engines.
    • Microsoft Office Suite: Proficiency in Word, Excel, PowerPoint, and Outlook for document creation, data management, presentations, and communication.

    Benefits of Taking a Basic Computer Course

    • Enhanced Digital Literacy: Develop a strong understanding of computer concepts and terminology.
    • Improved Job Prospects: Many job roles require basic computer skills, increasing your employability.
    • Personal Productivity: Boost your efficiency and productivity in daily tasks.
    • Online Learning and Communication: Confidently navigate the digital world for education, social interaction, and entertainment.
    • Foundation for Further Studies: Build a strong base for pursuing advanced computer courses or certifications.

    Who Should Take a Basic Computer Course?

    • Complete Beginners: Individuals with no prior computer experience.
    • Refreshers: Those who want to update their existing knowledge.
    • Seniors: People looking to stay connected and independent in the digital age.
    • Students: Students who need basic computer skills for academic purposes.
    • Job Seekers: Individuals aiming to improve job prospects in a technology-driven world.

    By completing a basic computer course, you’ll gain the essential skills to confidently use computers in your personal and professional life. It’s an investment in your future and can open up new opportunities.

    If you are new to computers, you must learn basic computer courses as a beginner. This course will teach you everything you need to know about using Microsoft Office applications for work and home purposes. You’ll learn how to create basic documents and charts using Word, Excel, and PowerPoint, how to save and share your projects, and more.

    What is a Basic Computer Course?

    A Basic Computer Course is an introductory program designed to provide essential computer skills and knowledge. It covers fundamental concepts such as operating systems, Microsoft Office applications, internet usage, and basic typing skills. At Computer Solutions and Training Center (CSTC) in Dhaka, the course includes training on Windows XP, MS Word, MS Excel, MS PowerPoint, MS Access, designing, using AI tools, and more.

    What Courses Are Related to Basic Computer Training?

    Courses related to basic computer training typically include:

    • Microsoft Office Suite: Word, Excel, PowerPoint, and Access.
    • Operating Systems: Basics of Windows XP and other operating systems.
    • Internet and Email: Navigating the web and using email services.
    • Typing Skills: Learning to type efficiently in both Bengali and English.
    • AI Tools: Introduction to AI-based software tools.
    • Designing: Basics of graphic design and creating digital content.

    How Long Is a Basic Computer Course?

    The duration of a basic computer course varies depending on the institution. At CSTC in Dhaka, the course lasts for six months. This timeframe ensures that students gain a thorough understanding and practical experience of all the topics covered.

    What Is an A+ Basic Computer Skills Course?

    An A+ Basic Computer Skills Course is a certification program that covers essential computer knowledge, including hardware and software fundamentals, troubleshooting, and networking basics. CSTC offers this as part of their online computer office application course, where students can receive hands-on training.

    How to Learn Basic Computer Course?

    Learning a basic computer course can be done through:

    • Attending Classes: Enroll in a reputable institution like CSTC for structured learning.
    • Online Tutorials: Utilize online resources and tutorials available on platforms like YouTube.
    • Practice: Regular practice on a computer to reinforce learning.
    • Support from Instructors: Engage with instructors to clarify doubts and ensure you understand each topic.

    How to Learn Basic Computer Course Online?

    To learn a basic computer course online:

    • Enroll in an Online Course: Choose a certified online course like the one offered by CSTC. Their best online course on computer office application is comprehensive and flexible.
    • Use Online Resources: Leverage free resources and tutorials available on educational websites and YouTube.
    • Interactive Learning: Participate in live sessions, if available, for a more interactive learning experience.

    What Are the Basic Courses in Computer?

    Basic computer courses typically include:

    • Introduction to Computers: Understanding computer parts and functions.
    • Operating Systems: Basic navigation and usage.
    • Microsoft Office Applications: Word processing, spreadsheets, presentations, and databases.
    • Internet Usage: Browsing, email, and online communication.
    • Typing: Basic to advanced typing skills.

    What Is Included in a Basic Computer Course?

    A basic computer course generally includes:

    • Windows Operating System: Basics of using and managing the OS.
    • Microsoft Office: Comprehensive training on Word, Excel, PowerPoint, and Access.
    • Internet and Email: Practical skills for web browsing and email communication.
    • Typing Skills: Training in both Bengali and English typing.
    • Basic Designing: Introduction to graphic design and creating digital content.
    • AI Tools: Overview and application of AI in daily tasks.

    How Much Is a Basic Computer Course?

    The cost of a basic computer course can vary depending on the institution and course content. CSTC’s office can provide detailed information on fees. They also offer a government-recognized six-month computer course certificate, which is valuable for job seekers.

    How to Start a Basic Computer Course?

    To start a basic computer course:

    • Research: Look for government-approved training centers like CSTC.
    • Enroll: Sign up for the course by visiting the center or through online registration.
    • Attend Classes: Participate in the scheduled classes and engage with instructors.
    • Practice: Use a computer regularly to apply what you learn.

    What Does a Basic Computer Course Include?

    A basic computer course at CSTC includes:

    • Operating Systems: Learning Windows XP and its functionalities.
    • Microsoft Office: Detailed training in Word, Excel, PowerPoint, and Access.
    • Internet Usage: Navigating the web and managing emails.
    • Typing Skills: Training to type efficiently in Bengali and English.
    • Designing: Basics of creating digital content.
    • AI Tools: Practical applications of AI tools.

    What are approved courses that provide basic computer skills?

    Approved courses providing basic computer skills are those recognized by government bodies or educational boards. CSTC offers a 6-month computer course certificate approved by the Board of Technical Education, ensuring that the skills you learn are up to industry standards.

    What Are the Topics in a Basic Computer Course?

    Topics in a basic computer course typically include:

    • Computer Fundamentals: Basics of computer hardware and software.
    • Windows OS: Learning to navigate and manage the operating system.
    • Microsoft Office Applications: Word, Excel, PowerPoint, and Access.
    • Internet and Email: Using the internet for research and communication.
    • Typing Skills: Improving typing speed and accuracy.
    • Designing and AI Tools: Introduction to designing software and AI tools.

    Where Can I Find Basic Computer Training Courses Near Me?

    If you are in Dhaka, CSTC located at 19, Indira Road, Manshi Plaza, 2nd Floor, Farmgate, Dhaka 1215, is a government-recognized computer training center. They offer both in-person and online training options, making it convenient to access quality education.

    What Is the Syllabus of a Basic Computer Course?

    The syllabus of a basic computer course at CSTC includes:

    • Operating System: Windows XP fundamentals.
    • Microsoft Office: Comprehensive modules on Word, Excel, PowerPoint, and Access.
    • Internet Skills: Practical training on web browsing and email management.
    • Typing: Training in both Bengali and English.
    • Designing and AI Tools: Basic design techniques and using AI software.

    What Is the Best Online Course on Computer Office Application?

    The best online course on computer office application offers comprehensive coverage of essential office software like Microsoft Word, Excel, PowerPoint, and Access. CSTC’s online course is highly recommended as it is structured, practical, and leads to a government-recognized certification.

    What Is the Importance of a 6-Month Computer Course Certificate?

    A 6-month computer course certificate from a recognized institution like CSTC is highly valuable. It demonstrates your proficiency in computer skills and is a requirement for many government, private, police, and administrative jobs. The certification is a testament to your technical abilities and is respected in the job market.

    What Makes CSTC the Best Option for Basic Computer Courses in Dhaka?

    CSTC stands out as the best option for basic computer courses in Dhaka due to its government recognition, experienced instructors, comprehensive syllabus, and flexible learning options. Their focus on practical skills and the provision of a Board of Technical Education certificate make it an excellent choice for students, job seekers, and professionals alike.

    What Qualifications Do I Need to Enroll in the Basic Computer Course?

    To enroll in the Basic Computer Course at CSTC, candidates need to have passed at least the Dakhil or an equivalent examination. However, the educational qualification requirement is relaxed for Hafeez candidates. This inclusivity ensures that many students, including those from religious educational backgrounds, can access computer training.

    What Is the Importance of Learning Microsoft Office in a Basic Computer Course?

    Microsoft Office is an essential suite of applications used in various professional settings. Learning Microsoft Word, Excel, PowerPoint, and Access equips students with the skills to create documents, manage data, prepare presentations, and handle databases. These skills are crucial for job seekers, office workers, and anyone looking to improve their computer proficiency.

    Can I Get a Job After Completing a Basic Computer Course?

    Yes, completing a Basic Computer Course at CSTC can significantly enhance your job prospects. The skills you acquire are highly valued in many sectors, including banking, administrative roles, and office management. Additionally, the Board of Technical Education recognizes the 6-month computer course certificate, making it a valuable asset for securing government and private jobs.

    How Does CSTC Ensure Quality Training for Women?

    CSTC takes special care to provide women a safe and comfortable learning environment. They offer separate seating arrangements and batch timings exclusively for female students. Additionally, the instructors for women are A+ certified female teachers with years of experience in teaching computer courses. This ensures that women can learn in a supportive and gender-sensitive environment.

    What Makes CSTC’s Basic Computer Course Different from Others?

    CSTC’s Basic Computer Course is distinguished by its comprehensive curriculum, government recognition, and practical approach to learning. The course is designed to take even absolute beginners to a level of proficiency where they can confidently handle various computer tasks. CSTC also offers detailed course modules with pictures, ensuring transparency and structured learning from start to finish.

    How Does CSTC Incorporate AI Tools in the Basic Computer Course?

    CSTC includes training on AI tools as part of its Basic Computer Course. These tools are integrated into the curriculum to provide students with up-to-date knowledge of how AI can be used in everyday tasks and professional environments. Learning about AI tools gives students a competitive edge, especially in jobs that require data analysis, automation, or digital content creation.

    How Can I Practice Typing Skills Without a Computer?

    CSTC provides innovative solutions for students who do not have access to a computer. You can learn to type efficiently using a smartphone by following specific typing exercises designed to mimic the experience of typing on a keyboard. This method helps you achieve a typing speed of 20-25 words per minute, which is sufficient for most job requirements.

    What Is Power BI and Why Is It Important?

    Microsoft’s Power BI is a business analytics service that provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. CSTC includes Power BI training in its Basic Computer Course to equip students with the skills needed to analyze data and make informed business decisions. Mastery of Power BI is particularly valuable in roles that involve data-driven decision-making and reporting.

    What Kind of Certification Will I Receive Upon Completion?

    Upon completing the Basic Computer Course at CSTC, you will receive a 6-month computer course certificate recognized by the Board of Technical Education. This certification is essential for applying to government jobs, private sector roles, and further educational opportunities. It validates your computer skills and is an official acknowledgment of your training.

    How Does CSTC Support Students Who Struggle with Learning?

    CSTC is committed to ensuring that all students master the material, regardless of their initial proficiency. Instructors can provide additional support, and students are encouraged to repeat lessons as many times as necessary to achieve complete understanding. This patient and supportive approach ensures that no student is left behind.

    Are There Any Online Resources Provided by CSTC?

    Yes, CSTC supplements its in-person training with online resources, including access to video tutorials and downloadable course materials. These resources are designed to help students continue learning outside of class and reinforce what they have learned. The combination of classroom instruction and online materials provides a comprehensive learning experience.

    How Can I Enroll in the Basic Computer Course at CSTC?

    To enroll in the Basic Computer Course at CSTC, you can visit their office at 19, Indira Road, Manshi Plaza, 2nd Floor, Farmgate, Dhaka 1215. Alternatively, you can contact them via phone at 01977957783 (WhatsApp available) or through their Facebook profile, BDCSTC. Enrollment is open daily, and you can join classes at your convenience.

    How Does CSTC Ensure That Students Complete the Course Successfully?

    CSTC uses a detailed course module system, where each class is outlined with specific learning objectives. Students can check off each module as they complete it, ensuring they have covered all necessary topics. This structured approach helps both students and instructors stay on track and guarantees that the course is completed thoroughly.

    Why Is a Government-Recognized Certificate Important?

    A government-recognized certificate, like the one provided by CSTC, is crucial for job seekers because it is often a requirement for many job applications, especially in government and public sector roles. It serves as official proof of your skills and is more likely to be accepted by employers than certificates from unrecognized institutions.

    How Can I Continue Learning After Completing the Basic Computer Course?

    After completing the Basic Computer Course, you can continue learning by enrolling in more advanced courses offered by CSTC or other institutions. Additionally, CSTC’s online resources and the vast array of tutorials available on platforms like YouTube can help you further your knowledge. Engaging in real-world projects, freelancing, or taking on more complex tasks at work can also enhance your skills.

    What Are the Benefits of Learning at a Government Computer Training Center in Dhaka?

    Learning at a government-recognized computer training center like CSTC offers several benefits:

    • Accreditation: Courses are accredited and certificates are recognized by the Board of Technical Education.
    • Quality Instruction: Experienced and certified instructors provide high-quality education.
    • Job Market Relevance: The skills taught are aligned with current job market demands.
    • Official Certification: The certification is valid and respected in both public and private sectors.

    What Support Does CSTC Offer for Students After Course Completion?

    CSTC continues to support its students even after course completion by offering guidance on job placement and further education. Through the center, alumni can access additional resources, refresher courses, and networking opportunities. CSTC’s strong community of past students and instructors provides a valuable network for ongoing support and career development.

  • Excel Training in Bangladesh

    Microsoft Excel is a powerful spreadsheet application that can be used for all sorts of calculations and data analysis. It’s commonly used by business owners and managers to track customer data, inventory levels, and other financial information. In Bangladesh, the demand for skilled Excel users is rapidly increasing as businesses and organizations recognize the importance of data management and analysis.

    Excel training programs in Bangladesh are designed to equip individuals with advanced skills that enhance productivity, decision-making, and overall efficiency. This article delves into the significance of Excel training in Bangladesh, highlighting key functions, including financial, logical, text, date and time, and lookup and reference functions.

    The Importance of Excel Training

    Excel is more than just a spreadsheet application; it is a powerful tool for organizing, analyzing, and visualizing data. Professional Excel training offers numerous benefits:

    1. Enhanced Data Management: Efficiently handle large datasets with advanced sorting, filtering, and data validation techniques.
    2. Improved Decision-Making: Utilize complex formulas and functions to derive actionable insights from data.৩২৫
    3. Increased Productivity: Automate repetitive tasks with macros and advanced functions.
    4. Better Visualization: Create compelling charts and dashboards to present data clearly and effectively.
    5. Career Advancement: Excel proficiency is a valuable skill that opens up opportunities for career growth and better job prospects.

    Core Functions Covered in Excel Training

    Excel training programs in Bangladesh cover a wide range of functions that are essential for various professional applications. Here, we explore some of the key functions taught in these programs:

    Financial Functions

    Financial functions in Excel are crucial for tasks related to finance, accounting, and investment analysis. Some commonly used financial functions include:

    1. PMT: Calculates the payment for a loan based on constant payments and a constant interest rate.excelCopy code=PMT(rate, nper, pv, [fv], [type])
    2. FV: Calculates the future value of an investment based on periodic, constant payments and a constant interest rate.excelCopy code=FV(rate, nper, pmt, [pv], [type])
    3. PV: Returns the present value of an investment based on a series of future payments.excelCopy code=PV(rate, nper, pmt, [fv], [type])
    4. NPV: Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.excelCopy code=NPV(rate, value1, [value2], ...)
    5. IRR: Returns the internal rate of return for a series of cash flows.excelCopy code=IRR(values, [guess])

    These functions are invaluable for professionals in finance roles, helping them to make informed decisions about investments, loans, and financial planning.

    Logical Functions

    Logical functions in Excel are used to perform logical tests and return values based on the outcomes. Key logical functions include:

    1. IF: Returns one value if a condition is true and another value if it is false.excelCopy code=IF(logical_test, value_if_true, value_if_false)
    2. AND: Returns TRUE if all arguments are TRUE.excelCopy code=AND(logical1, [logical2], ...)
    3. OR: Returns TRUE if any argument is TRUE.excelCopy code=OR(logical1, [logical2], ...)
    4. NOT: Reverses the logical value of its argument.excelCopy code=NOT(logical)
    5. IFERROR: Returns a value if an error is found, otherwise returns the result of the formula.excelCopy code=IFERROR(value, value_if_error)

    Logical functions are essential for building complex formulas that require conditional logic, such as dynamic reporting and data validation.

    Text Functions

    Text functions in Excel are used to manipulate and format text strings. Some common text functions include:

    1. LEFT: Returns the specified number of characters from the start of a text string.excelCopy code=LEFT(text, [num_chars])
    2. RIGHT: Returns the specified number of characters from the end of a text string.excelCopy code=RIGHT(text, [num_chars])
    3. MID: Returns a specific number of characters from a text string, starting at the position you specify.excelCopy code=MID(text, start_num, num_chars)
    4. CONCATENATE: Joins two or more text strings into one string.excelCopy code=CONCATENATE(text1, [text2], ...)
    5. TEXT: Converts a value to text in a specific number format.excelCopy code=TEXT(value, format_text)
    6. LEN: Returns the number of characters in a text string.excelCopy code=LEN(text)
    7. TRIM: Removes all spaces from a text string except for single spaces between words.excelCopy code=TRIM(text)
    8. FIND: Returns the position of a substring within a text string, case-sensitive.excelCopy code=FIND(find_text, within_text, [start_num])

    Text functions are particularly useful for cleaning and preparing data for analysis, especially when dealing with large datasets that include textual information.

    Date and Time Functions

    Date and time functions in Excel are essential for managing and analyzing date and time data. Key functions include:

    1. TODAY: Returns the current date.excelCopy code=TODAY()
    2. NOW: Returns the current date and time.excelCopy code=NOW()
    3. DATE: Returns the serial number of a specific date.excelCopy code=DATE(year, month, day)
    4. EDATE: Returns the serial number of the date that is the specified number of months before or after a start date.excelCopy code=EDATE(start_date, months)
    5. EOMONTH: Returns the serial number of the last day of the month before or after a specified number of months.excelCopy code=EOMONTH(start_date, months)
    6. DATEDIF: Returns the difference between two dates in years, months, or days.excelCopy code=DATEDIF(start_date, end_date, unit)
    7. WORKDAY: Returns the serial number of the date before or after a specified number of workdays.excelCopy code=WORKDAY(start_date, days, [holidays])
    8. NETWORKDAYS: Returns the number of whole workdays between two dates.excelCopy code=NETWORKDAYS(start_date, end_date, [holidays])

    Date and time functions are vital for project management, scheduling, and financial modeling, allowing users to perform date calculations and track timelines effectively.

    Lookup and Reference Functions

    Lookup and reference functions in Excel are used to search for and retrieve data from a specific range. Some essential lookup and reference functions include:

    1. VLOOKUP: Searches for a value in the first column of a table array and returns a value in the same row from a specified column.excelCopy code=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
    2. HLOOKUP: Searches for a value in the first row of a table array and returns a value in the same column from a specified row.excelCopy code=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
    3. INDEX: Returns a value or reference of the cell at the intersection of a particular row and column in a given range.excelCopy code=INDEX(array, row_num, [column_num])
    4. MATCH: Returns the relative position of an item in an array that matches a specified value.excelCopy code=MATCH(lookup_value, lookup_array, [match_type])
    5. CHOOSE: Returns a value from a list of values based on an index number.excelCopy code=CHOOSE(index_num, value1, [value2], ...)
    6. OFFSET: Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.excelCopy code=OFFSET(reference, rows, cols, [height], [width])

    Lookup and reference functions are crucial for data analysis and reporting, enabling users to search, match, and retrieve data efficiently from large datasets.

    Excel Training Programs in Bangladesh

    Excel training programs in Bangladesh are offered by several reputable institutes, each providing comprehensive courses tailored to different skill levels. These programs typically include hands-on training, real-world examples, and practical applications of advanced Excel functions. Some notable training centers include:

    1. Computer Solution and Training Center (CSTC):
      • Location: 19, Indira Road, Farmgate, Dhaka-1215
      • Courses Offered: Basic to advanced Excel training, with a focus on financial and data analysis applications.
      • Features: Hands-on training, experienced instructors, and job placement assistance.
    2. New Horizons Computer Learning Center:
      • Location: Gulshan, Dhaka
      • Courses Offered: Comprehensive Excel training programs, including certification courses.
      • Features: Interactive learning, real-world projects, and flexible class schedules.
    3. Bdjobs Training:
      • Location: Various locations across Dhaka
      • Courses Offered: Excel for business professionals, financial modeling, and data analysis.
      • Features: Expert trainers, practical exercises,
  • ANNUAL YIELD

    মাইক্রোসফট এক্সেলে, ANNUAL YIELD ফাংশনটি একটি সিকিউরিটির বার্ষিক আয় (annual yield) গণনা করে।

    সহজ ভাষায় বলতে গেলে, ANNUAL YIELD ফাংশনটি আপনাকে বলে দেয় যে একটি সিকিউরিটি (যেমন, বন্ড, স্টক) আপনাকে এক বছরে কতটা আয় করবে।

    এই ফাংশনটি গণনা করার জন্য, এটিকে নিম্নলিখিত তথ্য প্রদান করা প্রয়োজন:

    • মূল্য (face value): সিকিউরিটির মোট মূল্য
    • কুপন হার (coupon rate): সিকিউরিটির বার্ষিক সুদের হার
    • সময়কাল (maturity): সিকিউরিটির মেয়াদ
    • বাজার মূল্য (market price): সিকিউরিটির বর্তমান বাজার মূল্য (ঐচ্ছিক)।

    উদাহরণ:

    ধরুন, আপনি একটি $1,000 মূল্যের বন্ড কিনেছেন যার 5% কুপন হার এবং 10 বছরের মেয়াদ। বর্তমানে বাজারে বন্ডটির মূল্য $900

    এই তথ্য ব্যবহার করে, আমরা ANNUAL YIELD ফাংশনটি ব্যবহার করে বন্ডের বার্ষিক আয় গণনা করতে পারি:

    =ANNUAL_YIELD(1000, 5, 10, 900)
    

    এই ফাংশনটি 5.56% ফেরত দেবে। এর মানে হল যে আপনি যদি এই বন্ডটি কিনেন, তাহলে আপনি প্রতি বছর $55.60 আয় করবেন।

    বাজার মূল্য বাদ দিয়ে আপনি ফাংশনটি ব্যবহার করতে পারেন, তবে এটি সঠিক আয় প্রদান করবে না। কারণ বাজার মূল্য মূল্য থেকে ভিন্ন হতে পারে।

    ANNUAL YIELD ফাংশনটি বিনিয়োগকারীদের জন্য একটি মূল্যবান সরঞ্জাম যা বিভিন্ন সিকিউরিটির তুলনা করতে এবং সেরা বিনিয়োগ সিদ্ধান্ত নিতে সাহায্য করতে পারে।

  • মাইক্রোসফট এক্সেলে Redemption: আর্থিক লেনদেন ট্র্যাক করতে সহায়তা করে

    সহজ ভাষায় বলতে গেলে, Redemption ব্যবহার করে আপনি কোন লেনদেন থেকে কত টাকা ফেরত পেয়েছেন বা কত টাকা ছাড় পেয়েছেন তা ট্র্যাক করতে পারেন।

    “Redemption” বলতে বোঝায় একটি সিকিউরিটির মূল্য যা প্রতি $100 মুখমানে পাওয়া যায়

    আরও স্পষ্টভাবে:

    • ধরুন আপনার কাছে একটি সিকিউরিটি আছে যার মুখমান $100।
    • “Redemption” মানে হল আপনি যদি সেই সিকিউরিটিটি বিক্রি করেন তাহলে আপনি কত টাকা পাবেন
    • সিকিউরিটির ধরন এবং বাজারের অবস্থা অনুসারে “Redemption” এর মান পরিবর্তিত হতে পারে।

    উদাহরণ:

    • যদি একটি সিকিউরিটির “Redemption” $105 হয়, তাহলে এর মানে হল আপনি যদি সেই সিকিউরিটিটি বিক্রি করেন তাহলে আপনি $100 মুখমানের জন্য $105 পাবেন।
    • যদি একটি সিকিউরিটির “Redemption” $95 হয়, তাহলে এর মানে হল আপনি যদি সেই সিকিউরিটিটি বিক্রি করেন তাহলে আপনি $100 মুখমানের জন্য $95 পাবেন।

    মনে রাখবেন:

    • “Redemption” হল সর্বোচ্চ সম্ভাব্য মূল্য যা আপনি একটি সিকিউরিটির জন্য পেতে পারেন।
    • আপনি যদি সিকিউরিটিটি বিক্রি করার সিদ্ধান্ত নেন তাহলে আপনি “Redemption” এর চেয়ে কম মূল্যেও পেতে পারেন।
  • মাইক্রোসফট এক্সেলে Depreciation Rate কি?

    মাইক্রোসফট এক্সেলে, Depreciation Rate হলো একটি সংখ্যা যা প্রতি বছর সম্পত্তির মূল্য কতটা কমে যায় তা নির্ধারণ করে।

    সহজ ভাষায় বলতে গেলে:

    • সম্পত্তি বলতে বোঝায় এমন জিনিস যা দীর্ঘ সময় ধরে ব্যবহার করা যায়, যেমন যন্ত্রপাতি, গাড়ি, বা ভবন।
    • Depreciation বলতে বোঝায় সম্পত্তির মূল্য কমে যাওয়া। সময়ের সাথে সাথে সম্পত্তি ব্যবহার করার ফলে এর মূল্য কমে যায়।
    • Depreciation Rate হলো প্রতি বছর সম্পত্তির মূল্য কত শতাংশ কমে যাবে তার একটি হিসাব।

    উদাহরণস্বরূপ:

    • ধরুন আপনার কাছে একটি মেশিন আছে যার মূল্য ৳100,000।
    • আপনি মনে করেন যে এই মেশিনটি 10 বছর টিকবে।
    • আপনি যদি 10% Depreciation Rate ব্যবহার করেন, তাহলে প্রতি বছর মেশিনের মূল্য ৳10,000 কমে যাবে।
    • 10 বছর পর, মেশিনের মূল্য ৳0 হয়ে যাবে।

    মাইক্রোসফট এক্সেলে Depreciation Rate কীভাবে ব্যবহার করা যায়:

    এক্সেলে, Depreciation Rate কয়েকটি বিল্ট-ইন ফাংশনে ব্যবহার করা যেতে পারে, যেমন:

    • SLN (Straight Line Depreciation): এটি সবচেয়ে সাধারণ Depreciation Method। এটি ধরে নেয় যে সম্পত্তির মূল্য প্রতি বছর সমান হারে কমে যায়।
    • DB (Declining Balance Depreciation): এটি ধরে নেয় যে সম্পত্তির মূল্য প্রথম বছরগুলিতে দ্রুত কমে যায় এবং তারপর ধীরে ধীরে কমে যায়।
    • SYD (Sum-of-Years’-Digits Depreciation): এটি ধরে নেয় যে সম্পত্তির মূল্য প্রথম বছরগুলিতে বেশি কমে যায় এবং তারপর ধীরে ধীরে কমে যায়।

    কোন Depreciation Method ব্যবহার করা উচিত তা নির্ভর করে:

    • সম্পত্তির ধরণ
    • সম্পত্তির ব্যবহার
    • Depreciation Rate কতটা নির্ভুল হতে হবে
  • Period: নির্দিষ্ট সময়কালকে বোঝানো হয়

    Period বলতে একটি নির্দিষ্ট সময়কালকে বোঝানো হয়। এটি Date ডেটা টাইপের একটি অংশ যা দিন, মাস, বছর, এবং সময় (যেমন, ঘন্টা, মিনিট, সেকেন্ড) ধারণ করে।

    Period আর্গুমেন্ট ব্যবহার করা হয় AMORLINC ফাংশন-এ, যা সম্পত্তির মূল্যহ্রাস হিসাব করার জন্য ফরাসি পদ্ধতি ব্যবহার করে। এটি আপনাকে নির্ধারণ করতে দেয় যে আপনি কোন নির্দিষ্ট সময়ের জন্য মূল্যহ্রাস গণনা করতে চান।

    সহজ কথায়:

    • Period আর্গুমেন্ট আপনাকে সম্পত্তির মূল্য কতটা কমে যাচ্ছে তা নির্ধারণ করতে সময়ের ব্যবধান (যেমন, 1 মাস, 2 বছর) নির্দিষ্ট করতে দেয়।
    • AMORLINC ফাংশন এই সময়ের ব্যবধান ব্যবহার করে মূল্যহ্রাসের পরিমাণ গণনা করে।
    • উদাহরণস্বরূপ: যদি আপনি একটি মেশিন কিনেন যার মূল্য ৳10,000 এবং এর মূল্যহ্রাসের হার 10% প্রতি বছর, তাহলে আপনি Period আর্গুমেন্টটি 1 ব্যবহার করে প্রথম বছরের জন্য মূল্যহ্রাস গণনা করতে পারেন।

    Period আর্গুমেন্ট ব্যবহারের কিছু গুরুত্বপূর্ণ বিষয়:

    • Period আর্গুমেন্ট একটি সংখ্যা হতে হবে যা সময়ের একক নির্দেশ করে (যেমন, মাস, বছর)।
    • যদি সম্পত্তি কোন সময়ের মাঝামাঝি কেনা হয়, তাহলে Period আর্গুমেন্টটি প্রথম সময়ের জন্য আনুপাতিক হারে (prorated) মূল্যহ্রাস গণনা করবে।
    • Period আর্গুমেন্ট AMORLINC ফাংশনের অন্যান্য আর্গুমেন্ট (যেমন, Cost, Date_purchased, Salvage, Rate) এর সাথে সামঞ্জস্যপূর্ণ হতে হবে।
  • Salvage value: সেই সর্বনিম্ন মূল্য যা সম্পত্তিটি বিক্রি করা সম্ভব হবে যখন সেটির আর ব্যবহার করা যাবে না

    মাইক্রোসফট এক্সেলে, Salvage value (বাংলায় অবশিষ্ট মূল্য) বলতে বোঝায় সম্পত্তির জীবনকালের শেষে সম্পত্তির মূল্য

    সহজ কথায়:

    • ধরুন আপনি একটি কম্পিউটার কিনেছেন।
    • কম্পিউটারটির আনুষ্ঠানিক জীবনকাল ৫ বছর ধরা হল।
    • ৫ বছর পর কম্পিউটারটি আর ব্যবহার করা যাবে না।
    • ৫ বছর পর কম্পিউটারটি বিক্রি করে আপনি যদি কিছু টাকা পেতে পারেন, তাহলে সেই টাকাই হবে Salvage value

    উদাহরণ:

    • আপনি একটি মেশিন কিনেছেন ১০,০০০ টাকায়।
    • মেশিনটির জীবনকাল ৫ বছর।
    • ৫ বছর পর মেশিনটি বিক্রি করে আপনি পেতে পারেন ৫,০০০ টাকা।
    • এই ক্ষেত্রে, Salvage value হবে ৫,০০০ টাকা

    Salvage value বিভিন্ন কারণের উপর নির্ভর করে, যেমন:

    • সম্পত্তির ধরণ
    • সম্পত্তির মান
    • সম্পত্তির বাজারমূল্য
    • সম্পত্তির ব্যবহারের পরিমাণ

    মাইক্রোসফট এক্সেলে Salvage value ব্যবহার করা হয় বিভিন্ন হিসাব করার জন্য, যেমন:

    • মূল্যহ্রাস (Depreciation)
    • সম্পত্তির মূল্য (Asset value)
    • লাভ বা ক্ষতি (Profit or loss)

    আশা করি এই ব্যাখ্যাটি আপনার জন্য সহায়ক হয়েছে।

    কিছু টিপস:

    • Salvage value সবসময় সম্পত্তির ক্রয়মূল্যের চেয়ে কম হবে।
    • Salvage value হিসাব করার জন্য আপনি বিভিন্ন ধরণের সূত্র ব্যবহার করতে পারেন।
    • Salvage value সম্পর্কে আরও জানতে, আপনি Microsoft Excel সাহায্য কেন্দ্রটি দেখতে পারেন।
  • মাইক্রোসফট এক্সেলে “End of the first period” বলতে কী বোঝায়?

    মাইক্রোসফট এক্সেলে, “End of the first period” বলতে প্রথম সময়কালের শেষ তারিখ বোঝায়। এটি একটি আর্গুমেন্ট হিসাবে ব্যবহৃত হয় যা বিভিন্ন ফাংশনে প্রয়োগ করা হয়।

    উদাহরণস্বরূপ:

    • AMORLINC ফাংশন: এই ফাংশন সম্পত্তির মূল্যহ্রাস হিসাব করে। “End of the first period” আর্গুমেন্টটি ব্যবহার করে, আপনি নির্দিষ্ট করতে পারেন যে প্রথম সময়কালের জন্য মূল্যহ্রাস কীভাবে হিসাব করা হবে।
    • EOMONTH ফাংশন: এই ফাংশন একটি নির্দিষ্ট মাসের শেষ তারিখ ফেরত দেয়। “End of the first period” আর্গুমেন্টটি ব্যবহার করে, আপনি নির্দিষ্ট করতে পারেন যে কোন মাসের শেষ তারিখ ফেরত দেওয়া উচিত।

    আরও স্পষ্টভাবে বলতে গেলে:

    • “End of the first period” বলতে প্রথম সময়কালের সর্বশেষ দিন বোঝায়।
    • এটি একটি নির্দিষ্ট তারিখ হতে পারে, যেমন 31 জানুয়ারী 2024।
    • এটি একটি ফাংশন হতে পারে যা একটি নির্দিষ্ট তারিখ ফেরত দেয়, যেমন EOMONTH ফাংশন।

    কিছু টিপস:

    • “End of the first period” আর্গুমেন্টটি ব্যবহার করার সময়, নিশ্চিত করুন যে আপনি যে ফাংশনটি ব্যবহার করছেন তার সঠিক সিনট্যাক্সটি ব্যবহার করছেন।
    • “End of the first period” আর্গুমেন্টটির জন্য আপনি যে মান ব্যবহার করেন তা আপনার ডেটার সাথে সামঞ্জস্যপূর্ণ তা নিশ্চিত করুন।

    উদাহরণ:

    ধরা যাক আপনার একটি স্প্রেডশিট রয়েছে যা একটি প্রকল্পের জন্য মাসিক খরচ ট্র্যাক করে। আপনি AMORLINC ফাংশন ব্যবহার করে প্রকল্পের সম্পত্তির মূল্যহ্রাস হিসাব করতে চান। “End of the first period” আর্গুমেন্টটি ব্যবহার করে, আপনি নির্দিষ্ট করতে পারেন যে প্রথম মাসের জন্য মূল্যহ্রাস কীভাবে হিসাব করা হবে।

    এই ক্ষেত্রে, আপনি নিম্নলিখিত সূত্রটি ব্যবহার করতে পারেন:

    =AMORLINC(cost, start_date, EOMONTH(start_date, 1), salvage, period, rate)

    যেখানে:

    • cost হল প্রকল্পের মোট খরচ।
    • start_date হল প্রকল্পের শুরুর তারিখ।
    • period হল মাসিক সময়কাল।
    • rate হল মূল্যহ্রাসের হার।

    এই সূত্রটি প্রথম মাসের জন্য মূল্যহ্রাস হিসাব করতে EOMONTH ফাংশন ব্যবহার করে। EOMONTH ফাংশন start_date থেকে 1 মাস যোগ করে এবং তারপর সেই মাসের শেষ তারিখ ফেরত দেয়।

  • Date Purchased Argument: সহজ বাংলায় ব্যাখ্যা

    “Date purchased” আর্গুমেন্টটি একটি সম্পত্তির ক্রয়ের তারিখকে নির্দেশ করে। এটি একটি স্প্রেডশিটে ডেটা বিশ্লেষণ এবং হিসাব করার জন্য ব্যবহৃত হয়।

    উদাহরণ:

    ধরুন, আপনার একটি স্প্রেডশিট আছে যা আপনার কম্পিউটারের অংশগুলির তালিকা করে। প্রতিটি অংশের জন্য, আপনার ক্রয়ের তারিখ, মডেল নম্বর, দাম এবং অন্যান্য তথ্য থাকতে পারে। “Date purchased” আর্গুমেন্টটি আপনাকে বিভিন্ন মানদণ্ডের ভিত্তিতে ডেটা বিশ্লেষণ করতে সাহায্য করতে পারে। উদাহরণস্বরূপ, আপনি নির্ধারণ করতে পারেন যে আপনি গড়ে কোন তারিখে অংশগুলি কিনেছেন, কোন মডেলগুলি সবচেয়ে বেশি কেনা হয়েছে, অথবা কোন অংশগুলি দ্রুততম প্রতিস্থাপন করা প্রয়োজন।

    কিভাবে ব্যবহার করবেন:

    “Date purchased” আর্গুমেন্টটি বিভিন্ন সূত্র এবং ফাংশনে ব্যবহার করা যেতে পারে। উদাহরণস্বরূপ, আপনি নিম্নলিখিত সূত্রটি ব্যবহার করতে পারেন গড় ক্রয় তারিখ গণনা করতে:

    =AVERAGE(Date_purchased_range)

    এখানে, “Date_purchased_range” হল সেলগুলির পরিসর যেখানে “Date purchased” আর্গুমেন্ট রয়েছে।

    আপনি নির্দিষ্ট তারিখের পরে কেনা অংশগুলির সংখ্যা খুঁজে পেতে COUNTIF ফাংশন ব্যবহার করতে পারেন:

    =COUNTIF(Date_purchased_range, ">=" & start_date)

    এখানে, “start_date” হল আপনি যে তারিখের পরে কেনা অংশগুলি গণনা করতে চান।

    উপকারিতা:

    “Date purchased” আর্গুমেন্টটি আপনাকে আপনার সম্পত্তির ক্রয়ের ইতিহাস ট্র্যাক করতে এবং বিশ্লেষণ করতে সাহায্য করতে পারে। এটি আপনাকে আরও ভাল সিদ্ধান্ত নিতে এবং আপনার সম্পদের কার্যকারিতা উন্নত করতে সাহায্য করতে পারে।

    মনে রাখবেন:

    “Date purchased” আর্গুমেন্টটি সঠিকভাবে কাজ করার জন্য, এটি একটি বৈধ তারিখ ফর্ম্যাটে ফর্ম্যাট করা উচিত। আপনি আপনার স্প্রেডশিটে তারিখ ফর্ম্যাটগুলি কীভাবে সেট করবেন তা জানতে Microsoft Excel সাহায্য কেন্দ্রটি দেখতে পারেন।