Advanced Excel Course in Dhaka

Computer Training Center in Farmgate Dhaka

Microsoft Excel is a powerful tool used for data analysis, financial modeling, and a wide range of business applications. While many are familiar with basic functions, mastering advanced Excel skills can significantly enhance your productivity and data management capabilities. Here’s a comprehensive guide to some of the advanced features and techniques in Excel that can help you become an expert.

Key areas covered in an Advanced Excel course typically include:

  • Data Modeling: Creating complex data structures and relationships.
  • PivotTables and Pivot Charts: Mastering these tools for data summarization and visualization.
  • Power Query: Efficiently cleaning, transforming, and loading data.
  • Power Pivot: Building data models and performing complex calculations.
  • Data Analysis Tools: Utilizing statistical functions and analysis tools.
  • Macros and VBA: Automating tasks and creating custom functions.
  • Data Visualization: Creating impactful and interactive dashboards.

By mastering these advanced Excel skills, you’ll be equipped to handle intricate data challenges, make data-driven decisions, and elevate your productivity to new heights.

Why Advanced Excel Skills Matter

Advanced Excel skills are crucial for professionals who need to manage, analyze, and visualize large datasets. Whether you’re a financial analyst, project manager, data scientist, or business professional, the ability to perform sophisticated calculations, create dynamic reports, and automate tasks can set you apart in the workplace. Advanced Excel skills enable you to:

  • Perform Complex Calculations: Utilize advanced formulas and functions to solve intricate problems and perform multi-step calculations.
  • Analyze Data Efficiently: Use advanced data analysis tools to identify trends, patterns, and insights from large datasets.
  • Automate Tasks: Streamline repetitive tasks through macros and VBA (Visual Basic for Applications) programming.
  • Create Professional Reports: Develop interactive dashboards and detailed reports that effectively communicate your data findings.

Key Components of an Advanced Excel Course

An Advanced Excel Course typically covers a range of topics designed to deepen your understanding of Excel’s capabilities and improve your ability to work with complex data. Here’s what you can expect:

  1. Advanced Formulas and Functions
    • Array Formulas: Perform calculations on multiple values at once using array formulas.
    • Lookup Functions: Master advanced lookup functions such as VLOOKUP, HLOOKUP, INDEX, and MATCH to retrieve and analyze data from different ranges.
    • Logical Functions: Utilize IF, AND, OR, and other logical functions to perform conditional calculations.
  2. Data Analysis and Pivot Tables
    • Pivot Tables: Create and customize pivot tables to summarize and analyze large datasets efficiently.
    • Pivot Charts: Use pivot charts to visualize data trends and insights derived from pivot tables.
    • Data Validation: Implement data validation techniques to ensure data accuracy and consistency.
  3. Advanced Data Visualization
    • Dynamic Charts: Create dynamic charts that update automatically with changes in your data.
    • Conditional Formatting: Apply conditional formatting to highlight key data points and trends.
    • Sparklines: Use sparklines to display trends within a cell, providing a compact visual representation of data.
  4. Automation with Macros and VBA
    • Recording Macros: Record and run macros to automate repetitive tasks and processes.
    • VBA Programming: Learn the basics of VBA programming to write custom code and create advanced automation solutions.
  5. Data Management and Analysis Tools
    • Power Query: Use Power Query to import, transform, and clean data from various sources.
    • Power Pivot: Enhance data modeling and analysis with Power Pivot, allowing for complex calculations and data relationships.
    • What-If Analysis: Perform scenario analysis and data forecasting using tools like Goal Seek and Data Tables.
  6. Advanced Workbook and Worksheet Management
    • Workbook Protection: Implement advanced security features to protect sensitive data and control access.
    • Worksheet Navigation: Master techniques for managing and navigating large workbooks with multiple sheets.

Benefits of Completing an Advanced Excel Course

  • Enhanced Efficiency: Streamline your workflow and save time by mastering advanced techniques and automation tools.
  • Improved Decision-Making: Gain the ability to analyze data more effectively and make informed decisions based on comprehensive insights.
  • Career Advancement: Strengthen your resume and increase your marketability by showcasing your advanced Excel skills to potential employers.
  • Professional Development: Expand your skill set and stay competitive in fields where advanced data analysis and reporting are essential.

How to Enroll in an Advanced Excel Course

To enroll in an Advanced Excel Course, follow these steps:

  1. Research Providers: Look for reputable institutions or online platforms offering Advanced Excel training. Check reviews and course content to ensure it meets your needs.
  2. Review Course Details: Examine the course syllabus, duration, format (online or in-person), and prerequisites to confirm it aligns with your learning objectives.
  3. Register: Complete the registration process by filling out the necessary forms and paying the course fee.
  4. Prepare for Classes: Gather any required materials and ensure you have access to the necessary software and tools.

How can I learn Advanced Excel?

You can learn Advanced Excel through CSTC live and online course.

What are the benefits of using Advanced Excel features?

Advanced Excel features enable you to handle larger datasets, perform complex analyses, automate repetitive tasks, and create dynamic reports. These skills can improve your efficiency, accuracy, and ability to make data-driven decisions.

What is VBA and how can it help?

VBA (Visual Basic for Applications) is a programming language that allows you to automate tasks in Excel, create custom functions, and build complex data models. You can use VBA to write macros that automate repetitive tasks, create custom user forms, and interact with other Office applications.

What is Advanced Excel?

Advanced Excel refers to the use of complex functions, tools, and features within Microsoft Excel to perform sophisticated data analysis, create dynamic reports, and automate tasks. This includes skills like using advanced formulas, Pivot Tables, Power Query, Power Pivot, and VBA programming.

Conclusion

The Advanced Excel Course is an essential investment for anyone looking to elevate their data management and analysis skills. By mastering advanced techniques and tools, you’ll enhance your ability to handle complex data tasks, automate repetitive processes, and create insightful reports. Whether for career advancement or personal development, gaining expertise in advanced Excel is a powerful way to unlock new opportunities and achieve greater efficiency in your work.

āϕ⧋āύ āϏāĻžāϞ⧇ āĻŦāĻžāĻ‚āϞāĻžāĻĻ⧇āĻļ⧇ āĻĒā§āϰāĻĨāĻŽ āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻšāϝāĻŧ? āĻ•. ⧧⧝ā§Ģ⧝ āĻ–. ⧧⧝ā§Ŧā§­ āĻ—. ⧧⧝⧭ā§Ē āϘ. ⧧⧝ā§Ŧā§Ē

F5 āĻšāϤ⧇ F25 āϏ⧇āϞ⧇āϰ āĻĄāĻžāϟāĻž āϝ⧋āĻ— āĻ•āϰāĻžāϰ āĻĢāĻžāĻ‚āĻļāύ- āĻ•. SUM (F5, F25) āĻ–. SUM (F5: F25) āĻ—. SUM (F5+F25 āϘ, SUM (F5. F25)

āĻĄāĻžāϟāĻžāĻŦ⧇āϏ āĻ—āĻ āĻŋāϤ āĻšāϝāĻŧ- āĻ•. āĻ•āϤāĻ•āϗ⧁āϞ⧋ āϰ⧇āĻ•āĻ°ā§āĻĄ āύāĻŋāϝāĻŧ⧇ āĻ–. āĻ•āϤāĻ•āϗ⧁āϞ⧋ āĻĢāĻŋāĻ˛ā§āĻĄ āύāĻŋāϝāĻŧ⧇
āĻ—. āĻ•āϤāĻ•āϗ⧁āϞ⧋ āĻĢāĻžāχāϞ āύāĻŋāϝāĻŧ⧇ āϘ. āĻāĻ• āĻŦāĻž āĻāĻ•āĻžāϧāĻŋāĻ• āĻĄāĻžāϟāĻž āύāĻŋāϝāĻŧ⧇

LAN āĻļāĻŦā§āĻĻ⧇āϰ āĻĒā§‚āĻ°ā§āĻŖāϰ⧂āĻĒ āϕ⧋āύāϟāĻŋ? āĻ•. Local Assemble Network āĻ–. Local Area Note āĻ—. Local Area Network āϘ. Legal Assemble Network

āϕ⧋āύāϟāĻŋ Network Operating system? āĻ•. Window 98 āĻ–. DOS āĻ—. Google earth āϘ. UNIX

(⧍⧝)ā§§ā§Ļ āϏāĻ‚āĻ–ā§āϝāĻžāϟāĻŋāϕ⧇ āĻŦāĻžāχāύāĻžāϰāĻŋāϤ⧇ āĻĒā§āϰāĻ•āĻžāĻļ āĻ•āϰāϞ⧇ āĻ•āϤ āĻšāϝāĻŧ? āĻ•. (ā§§ā§§ā§Ļā§§ā§§)⧍ āĻ–. (ā§§ā§§ā§§ā§§ā§Ļ)⧍ āĻ—. (ā§§ā§§ā§§ā§Ļā§§)⧍ āϘ ,(ā§§ā§Ļā§§ā§§ā§§) ⧍

Query āĻāϰ āĻ•āĻžāϜ āĻšāϞ⧋ āĻĄāĻžāϟāĻžāĻŦ⧇āϏ āĻĨ⧇āϕ⧇ āĻĒā§āĻ°ā§Ÿā§‹āϜāĻ¨ā§€ā§Ÿ āĻĄāĻžāϟāĻž āĻ•. āϏāĻžāϜāĻŋāϝāĻŧ⧇ āĻĒā§āϰāĻŋāĻ¨ā§āϟ āĻ•āϰāĻž āĻ–. āϖ⧁āρāĻœā§‡ āĻŦ⧇āϰ āĻ•āϰāĻžāϰ āĻ—. āϏ⧁āĻ¨ā§āĻĻāϰāĻ­āĻžāĻŦ⧇ āĻĒā§āϰāĻĻāĻ°ā§āĻļāύ āĻ•āϰāĻž āϘ. āϰ⧇āĻ•āĻ°ā§āĻĄ āϗ⧁āϞ⧋ āϏāĻžāϜāĻžāύ⧋

āύāĻŋāĻšā§‡āϰ āϕ⧋āύāϟāĻŋ āĻĢāĻžāĻ°ā§āĻŽāĻ“āϝāĻŧā§āϝāĻžāϰ? āĻ•. Processor āĻ–. CMOS āĻ—. ROM-BIOS āϘ. ROM

IC āĻāϰ āĻ…āĻ°ā§āĻĨ āĻ•. Important Circuit āĻ–. Integrated Circuit āĻ—. International Circuit āϘ. Impossible Circuit

Save āĻāϰ āϕ⧀-āĻŦā§‹āĻ°ā§āĻĄ āĻ•āĻŽāĻžāĻ¨ā§āĻĄ āϕ⧋āύāϟāĻŋ? āĻ•. Ctrl + P āĻ–. Ctrl + S āĻ—. Ctrl + C āϘ. Ctrl +X

āϏāĻ āĻŋāĻ• āĻļāĻŦā§āĻĻ āĻĻāĻŋāϝāĻŧ⧇ āĻļā§‚āĻ¨ā§āϝāĻ¸ā§āĻĨāĻžāύ āĻĒā§‚āϰāĻŖ āĻ•āϰāĨ¤

āĻŽā§‡āĻŽāϰāĻŋāϰ āĻāĻ•āĻ• āĻšāĻšā§āϛ⧇ __

āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ⧇āϰ āĻĒā§āϰāĻĨāĻŽ āĻĒā§āϰ⧋āĻ—ā§āϰāĻžāĻŽ āϰāϚāϝāĻŧāĻŋāϤāĻžāϰ āύāĻžāĻŽ__

= Sum (*5″. 15, TRUE) == _

Microsoft Power Point __ Software Package

Page break āĻ•āϰāĻžāϰ āϕ⧀- āĻŦā§‹āĻ°ā§āĻĄ āĻ•āĻŽāĻžāĻ¨ā§āĻĄ _

ROM āĻāĻ•āϟāĻŋ āĻŽā§‡āĻŽā§‹āϰāĻŋ _

A4 āĻ•āĻžāĻ—āĻœā§‡āϰ āϏāĻžāχāϜ __

Recycle bin-āĻ āĻĢāĻžāχāϞ āϜāĻŽāĻž āĻĨāĻžāϕ⧇ __

NIC āĻāϰ āĻĒā§‚āĻ°ā§āĻŖāύāĻžāĻŽ __

āĻāĻ•āϟāĻŋ āϚāĻŋāĻ āĻŋ āĻŦāĻŋāĻ­āĻŋāĻ¨ā§āύ āĻ āĻŋāĻ•āĻžāύāĻžāϝāĻŧ āĻĒā§āϰ⧇āϰāϪ⧇āϰ āϜāĻ¨ā§āϝ__ āĻŦā§āϝāĻŦāĻšā§ƒāϤ

āϏāĻ¤ā§āϝ āĻŽāĻŋāĻĨā§āϝāĻž āϞ⧇āĻ–āσ

Office program āĻāϰ āĻĄāĻžāϟāĻž My Computer-āĻ Save āĻšāϝāĻŧāĨ¤

Software āĻšāĻšā§āϛ⧇ āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ⧇āϰ āĻāĻ•āϟāĻŋ āĻĒā§āϰāĻ•ā§āϰāĻŋāϝāĻŧāĻžāĻ•āϰāĻŖ āĻ…āĻ‚āĻļāĨ¤

Copy āĻ•āϰāĻžāϰ āϕ⧀-āĻŦā§‹āĻ°ā§āĻĄ āĻ•āĻŽāĻžāĻ¨ā§āĻĄ Ctrl + X

āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ⧇āϰ āĻ­āĻžāχāϰāĻžāϏ āĻāĻ•āϟāĻŋ āĻĒā§āϰ⧋āĻ—ā§āϰāĻžāĻŽ āĨ¤

Ms Word-āĻ āĻŦāĻžāύāĻžāύ āĻļ⧁āĻĻā§āϧ āĻ•āϰāĻžāϰ āϜāĻ¨ā§āϝ Spell Checker āĻŦā§āϝāĻŦāĻšā§ƒāϤ āĻšāϝāĻŧāĨ¤

My Access āĻāϰ āĻ•ā§āώ⧇āĻ¤ā§āϰ⧇ āϕ⧁āϝāĻŧ⧇āϰāĻŋ ā§Ģ (āĻĒāĻžāρāϚ) āĻĒā§āϰāĻ•āĻžāϰāĨ¤

(ā§§ā§Ļā§Ļā§§)2 āϏāĻ‚āĻ–ā§āϝāĻžāϟāĻŋāϕ⧇ āĻĻāĻļāĻŽāĻŋāĻ• āϏāĻ‚āĻ–ā§āϝāĻžāϝāĻŧ āĻĒā§āϰāĻ•āĻžāĻļ āĻ•āϰāϞ⧇ ā§§ā§§ āĻšāϝāĻŧāĨ¤

āĻĒā§āϰāĻĨāĻŽ āĻŦāĻžāĻŖāĻŋāĻœā§āϝāĻŋāĻ• āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ⧇āϰ āύāĻžāĻŽ UNIVAC

Form āĻāϰ āĻ•āĻžāϜ āĻšāϞ⧋ āϰ⧇āĻ•āĻ°ā§āĻĄāϗ⧁āϞ⧋ āϏāĻžāϜāĻžāύ⧋āĨ¤

Google āĻāĻ•āϟāĻŋ Internet āϏāĻžāĻ°ā§āϚ āχāĻžā§āϜāĻŋāύāĨ¤

āĻ…āϤāĻŋ āϏāĻ‚āĻ•ā§āώ⧇āĻĒ⧇ āωāĻ¤ā§āϤāϰ āĻĻāĻžāĻ“ :

āĻĻ⧁āϟāĻŋ Spreadsheet package āĻāϰ āύāĻžāĻŽ āϞ⧇āĻ–āĨ¤

āĻšāĻžāχāĻĒāĻžāϰ āϞāĻŋāĻ™ā§āĻ• āĻŦāϞāϤ⧇ āϕ⧀ āĻŦ⧁āĻāĻžāϝāĻŧ?

Function āϕ⧀?

āφāϧ⧁āύāĻŋāĻ• āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ⧇āϰ āϜāύāĻ• āϕ⧇?

Mall Merge āϕ⧀?

Column Break āĻ•āϰāĻžāϰ āϜāĻ¨ā§āϝ āϕ⧀-āĻŦā§‹āĻ°ā§āĻĄ āĻĨ⧇āϕ⧇ āĻĒā§āϰāĻĻāĻ¤ā§āϤ āĻ•āĻŽāĻžāĻ¨ā§āĻĄ āϕ⧀?

Marks-Field āĻāϰ Data type āϕ⧀?

āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ āϕ⧀?

āĻĻ⧁āϟāĻŋ Network operating systems āĻāϰ āύāĻžāĻŽ āϞ⧇āĻ–āĨ¤

Row/Column Auto Fit āϕ⧇āύ āĻ•āϰāĻž āĻšāϝāĻŧ?

Fill in the blanks with appropriate preposition :

I would like — appear the final examination.

You have to do well to get merchandising ——- training Institute.

I do feel you- honestly.

Steel is made __ iron, sils

She was lying – my bed

Translate into English:

āφāĻŽāĻŋ āĻŽāĻžāĻ°ā§āĻšā§‡āĻ¨ā§āĻĄāĻžāχāϜāĻŋāĻ‚ āĻŸā§āϰ⧇āĻĄā§‡āϰ āĻāĻ•āϜāύ āĻ›āĻžāĻ¤ā§āϰāĨ¤

āϏ⧂āĻ°ā§āϝ āĻĒā§‚āĻ°ā§āĻŦāĻĻāĻŋāϕ⧇ āĻ“āϠ⧇āĨ¤

āφāĻŽāĻžāϰ āĻŦāĻžāĻŦāĻž āĻāĻ•āϜāύ āĻ—āϰ⧀āĻŦ āϞ⧋āĻ•āĨ¤

āφāĻŽāĻŋ āĻāĻ•āϟāĻŋ āĻ—āĻžāĻ°ā§āĻŽā§‡āĻ¨ā§āϟāϏ-āĻ āϚāĻžāĻ•āϰāĻŋ āĻ•āϰāĻŋāĨ¤

āφāĻŽāĻŋ āĻŦāĻžāĻĄāĻŧāĻŋ āϝāĻžāĻŦāĨ¤

* āϏāĻ āĻŋāĻ• āωāĻ¤ā§āϤāϰāϟāĻŋāϤ⧇ āϟāĻŋāĻ• (V) āϚāĻŋāĻšā§āύ āĻĻāĻžāĻ“ āĨ¤ 

MS word-āĻ āĻŦāĻžāύāĻžāύ āĻļ⧁āĻĻā§āϧ āĻ•āϰāĻžāϰ āϜāĻ¨ā§āϝ āĻŦā§āϝāĻŦāĻšā§ƒāϤ āĻšāϝāϝāĻŧāĻžāϰāĻĻ

(āĻ•)  Edit (āĻ–) Format (āĻ—)Spelling checker  (āϘ) Print

āϕ⧋āύāϟāĻŋ Optical device?(āĻ•)   CD (āĻ–)  Pen drive (āĻ—) FDD(āϘ)  HDD

Document āύāĻžāĻŽ āĻŦāĻĻāϞāĻŋāϝāĻŧ⧇ Save āĻ•āϰāĻžāϰ āϜāĻ¨ā§āϝ āĻŦā§āϝāĻŦāĻšā§ƒāϤ

(āĻ•) Save (āĻ–)  Save new (āĻ—)  Save as  (āϘ)  Save old

  āĻ­āĻŋāĻ¨ā§āύ āĻ­āĻŋāĻ¨ā§āύ āĻŽāĻžāύ⧇āϰ Data store āĻ•āϰāĻžāϰ āϜāĻ¨ā§āϝ āĻŦā§āϝāĻŦāĻšā§ƒāϤ āĻšāϝāĻŧ

āĻ•. Hot key āĻ–.  Primary key āĻ—. Secondary key āϘ. Key

āϕ⧋āύāϟāĻŋ Logical Functfon?

āĻ•. = IF () āĻ–. = SUM()āĻ—. AVG () āϘ. MOD ()

ā§ŦāĨ¤ MS Word-āĻāϰ Table āĻ

āĻ•, āĻļ⧁āϧ⧁ Raw āĻŦāĻžāĻĄāĻŧāĻžāύ⧋ āϝāĻžāϝāĻŧ āĻ–, āĻļ⧁āϧ⧁ āĻ•āϞāĻžāĻŽ āĻŦāĻžāĻĄāĻŧāĻžāύ⧋ āϝāĻžāϝāĻŧ āĻ—. āωāĻ­āϝāĻŧāχ āĻŦāĻžāĻĄāĻŧāĻžāύ⧋ āϝāĻžāϝāĻŧ āϘ. āϕ⧋āύāϟāĻŋāχ āĻŦāĻžāĻĄāĻŧāĻžāύ⧋ āϝāĻžāϝāĻŧ āύāĻž 

MS-Access-āĻ Data entry āĻ•āϰāĻžāϰ āϜāĻ¨ā§āϝ āĻŽā§‚āϞāϤ āĻŦā§āϝāĻŦāĻšā§ƒāϤ āĻšāϝāĻŧ- āĻ•. Query āĻ–. Macro āĻ—. Report āϘ, Form 

āĻāĻ• āĻ¸ā§āĻĨāĻžāύ⧇āϰ āϞ⧇āĻ–āĻž āĻŽā§āϛ⧇ āĻ…āĻ¨ā§āϝ āĻ¸ā§āĻĨāĻžāύ⧇ āύāĻŋāϤ⧇ āĻšāϞ⧇ āĻ•āϰāϤ⧇ āĻšāĻŦ⧇-

āĻ•. Cut-paste  āĻ–. Copy-paste āĻ—. Delete-paste āϘ. Copy

Presentation Package āϕ⧋āύāϟāĻŋ?

āĻ•. Front page āĻ–. Oracle āĻ—. Outlook  āϘ. Power Point 

Excel-āĻ āĻāĻ•āĻžāϧāĻŋāĻ• Cell āĻāĻ•āĻ¤ā§āϰāĻŋāϤ āĻ•āϰāĻžāϕ⧇ āĻŦāϞ⧇

āĻ•. Add āĻ–. Join āĻ—. Merge āϘ. Union 

āϏāĻ āĻŋāĻ• āĻļāĻŦā§āĻĻ āĻĻāĻŋāϝāĻŧ⧇ āĻļā§‚āĻ¨ā§āϝāĻ¸ā§āĻĨāĻžāύ āĻĒā§‚āϰāĻŖ āĻ•āϰ

āĻšāĻžāĻ°ā§āĻĄ āĻĄāĻŋāĻ¸ā§āĻ• āĻšāϞ āĻāĻ•āϟāĻŋ__ āĻĄāĻŋāĻ­āĻžāχāϏ

MS Excel āĻāϰ āĻĒā§āϰāϤāĻŋāϟāĻŋ āĻ“āϝāĻŧāĻžāĻ°ā§āĻ•āĻļā§€āĻŸā§‡ __āϟāĻŋ Row āφāϛ⧇āĨ¤ 

Data base (MS Access) āĻĢāĻžāχāϞ⧇āϰ āĻāĻ•ā§āϏāĻŸā§‡āύāĻļāύ āĻšāϞ__

Record āĻšāϞ āĻ•āϤāĻ•āϗ⧁āϞ⧋ —āĻāϰ āϏāĻŽāĻˇā§āϟāĻŋāĨ¤

OMR āĻāϰ āĻĒā§‚āĻ°ā§āĻŖāύāĻžāĻŽ āĻšāϞ –

Accounting āĻ•āĻžāĻœā§‡ āĻŽā§‚āϞāϤ – āĻĒā§āϝāĻžāϕ⧇āϜ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻ•āϰāĻž āĻšāϝāĻŧāĨ¤

Pen drive āϏāĻ‚āϝ⧁āĻ•ā§āϤ āĻ•āϰāĻžāϰ āϜāĻ¨ā§āϝ — Port āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻ•āϰāĻž

1 GB=__ MB

 Mouse āĻāĻ•āϟāĻŋ āϜāύāĻĒā§āϰāĻŋāϝāĻŧ___ āϝāĻ¨ā§āĻ¤ā§āϰāĨ¤

āĻāĻ•āχ āϚāĻŋāĻ āĻŋ āĻāĻ•āĻžāϧāĻŋāĻ• āύāĻžāĻŽā§‡āϰ āĻ āĻŋāĻ•āĻžāύāĻžāϝāĻŧ āĻĒā§āϰ⧇āϰāϪ⧇āϰ āϜāĻ¨ā§āϝ Ms Word___āĻ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻ•āϰāĻž āĻšāϝāĻŧāĨ¤

*āϏāĻ¤ā§āϝ āĻšāϞ⧇ āĻ¸â€™ āĻāĻŦāĻ‚ āĻŽāĻŋāĻĨā§āϝāĻž āĻšāϞ⧇ āĻŽāĻŋ’ āϞ⧇āĻ–āσ

 MS word-āĻ āϏāĻŽāĻžāĻ°ā§āĻĨāĻ• āĻļāĻŦā§āĻĻ āĻŦ⧇āϰ āĻ•āϰāĻžāϰ āϜāĻ¨ā§āϝ Find āĻ•āĻŽāĻžāĻ¨ā§āĻĄ āĻŦā§āϝāĻŦāĻšā§ƒāϤ āĻšāϝāĻŧāĨ¤

 G5 āĻšāϤ⧇ K5 āĻĒāĻ°ā§āϝāĻ¨ā§āϤ āϝ⧋āĻ— āĻ•āϰāĻžāϰ āĻĢāĻžāĻ‚āĻļāύ āĻšāϞ =SUM(G5:K5)

Front page āĻ“āϝāĻŧ⧇āĻ­ Page āϤ⧈āϰāĻŋāϰ āϜāĻ¨ā§āϝ āĻŦā§āϝāĻŦāĻšā§ƒāϤ āĻšāϝāĻŧāĨ¤

$B$20 āĻāĻ•āϟāĻŋ āĻ…ā§āϝāĻžāϏāĻŋāϞ⧁āϟ āĻ…ā§āϝāĻžāĻĄā§āϰ⧇āϏāĨ¤

a4 ‘ āϞ⧇āĻ–āĻžāϰ āϜāĻ¨ā§āϝ Subscript āĻŦā§āϝāĻŦāĻšā§ƒāϤ āĻšāϝāĻŧāĨ¤

āϕ⧋āύ⧋ Folder-āĻ File āĻ“ Folder āωāĻ­āϝāĻŧāχ āĻĨāĻžāĻ•āϤ⧇ āĻĒāĻžāϰ⧇āĨ¤

Database-āĻ āϕ⧋āύ āĻ•āĻŋāϛ⧁ āĻ›āĻžāĻĒāĻžāύ⧋āϰ āϜāĻ¨ā§āϝ Report āϤ⧈āϰāĻŋ āĻ•āϰāϤ⧇ āĻšāϝāĻŧāĨ¤’

 Bijoy āĻāĻ•āϟāĻŋ āĻŦāĻžāĻ‚āϞāĻž āĻĢāĻ¨ā§āĻŸā§‡āϰ āύāĻžāĻŽāĨ¤

āĻŦāĻžāĻ‚āϞāĻž-āχāĻ‚āϰ⧇āϜāĻŋ Keyboard āĻĒāϰāĻŋāĻŦāĻ°ā§āϤāύ⧇āϰ āϜāĻ¨ā§āϝ āĻ•āĻŽāĻžāĻ¨ā§āĻĄ Ctrl+Alt+B1

Header/Footer margin āĻāϰ āĻŦāĻžāχāϰ⧇ āĻ›āĻžāĻĒāĻž āĻšāϝāĻŧāĨ¤

āĻ…āϤāĻŋ āϏāĻ‚āĻ•ā§āώ⧇āĻĒ⧇ āωāĻ¤ā§āϤāϰ āĻĻāĻžāĻ“

Macro āĻ•āĻŋ ?

Excel-āĻ āϚāĻŋāĻšā§āύ āĻ•āĻ–āύ āĻŦā§āϝāĻŦāĻšā§ƒāϤ āĻšāϝāĻŧ?

Data base-āĻ āĻ›āĻŦāĻŋ āϕ⧋āύ āϧāϰāύ⧇āϰ Data?

Equation editor ?

Windows XP āϕ⧀ āĻ•āĻžāĻœā§‡ āĻŦā§āϝāĻŦāĻšā§ƒāϤ āĻšāϝāĻŧ?

Recycle bin āĻāϰ āĻŦā§āϝāĻŦāĻšāĻžāϰ āϞ⧇āĻ–āĨ¤

Ctrl+Z āĻ•āĻŽāĻžāĻ¨ā§āĻĄā§‡āϰ āĻ•āĻžāϜ āϞāĻŋāĻ– ?

Excel-āĻ āϕ⧋āύ Cell āĻāϰ Address-āĻ āϕ⧀ āϕ⧀ āĻŦā§āϝāĻŦāĻšā§ƒāϤ?

Query āĻ•āĻ–āύ āĻĒā§āϰāϝāĻŧā§‹āϜāύ āĻšāϝāĻŧ?

WWW-āĻāϰ āĻĒā§‚āĻ°ā§āĻŖāύāĻžāĻŽ āϞ⧇āĻ–āĨ¤

Fill in the blanks and complete the paragraph using the clues given below: (is, I’m, address, telephone number, is, I’m, old, is, years old, are, is)

 My name __ Martin and__ a doctor. My__ is York Avenue, 23 and my__—+ 4423517534,___ 40 years and I’m married. My son, Peter,___ tenMy wife, Linda, is American. She___a lawyer.

*Choose the correct word or phrase to complete the questions: 

How__ money do you have in your pocket? 

(a) Many (b) few (c) much (d) some

Did you go__mosque last friday?

 (a) at (b) in (c) to (d) on

What___ in your free time?

(a) you do (b) do you do   (c) are you doing

Where __you born?

(a) are (b) were (c) was

__ do you do?

(a) Who (b) What (c) How

* āϏāĻ āĻŋāĻ• āωāĻ¤ā§āϤāϰāϟāĻŋāϤ⧇ āϟāĻŋāĻ• (v) āϚāĻŋāĻšā§āύ āĻĻāĻžāĻ“ āĨ¤

HDD āĻšāϞ

(āĻ•)Hard Drive Disk (āĻ–)Head Disk Drive (āĻ—)Hard Disk Drive (āϘ)Header Disk Drive 

CPU āĻšāϞ -(āĻ•)Central Processing Unit (āĻ–) Central Providing Unit (āĻ—) Control Programming Unit (āϘ)Control Problem Unit 

(ā§§ā§§)ā§§ā§Ļ āϏāĻ‚āĻ–ā§āϝāĻžāϟāĻŋāϕ⧇ āĻŦāĻžāχāύāĻžāϰāĻŋ āϏāĻ‚āĻ–ā§āϝāĻžāϝāĻŧ āĻĒā§āϰāĻ•āĻžāĻļ āĻ•āϰāϞ⧇ āĻ•āϤ āĻšāĻŦ⧇?

āĻ•. (ā§§ā§Ļā§§ā§§)⧍ āĻ–. (ā§Ļā§§ā§§ā§§ā§Ļ)⧍ āĻ—. (ā§§ā§Ļā§§ā§Ļ)⧍ āϘ. (ā§§ā§§ā§Ļā§Ļ)⧍

Macro āϕ⧀? āĻ•, āĻĒā§āϰ⧋āĻ—ā§āϰāĻžāĻŽ āĻ­āĻžāώāĻžāϝāĻŧ āĻŦā§āϝāĻŦāĻšā§ƒāϤ āĻŦāĻŋāĻ­āĻŋāĻ¨ā§āύ āϧāϰāύ⧇āϰ āύāĻŋāĻ°ā§āĻĻ⧇āĻļāύāĻž āĻ–, āĻĢāĻžāĻ°ā§āĻŽāĻ“āϝāĻŧā§āϝāĻžāϰ āĻ—, āϏāĻĢāϟāĻ“āϝāĻŧā§āϝāĻžāϰ āϘ, āĻšāĻžāĻ°ā§āĻĄāĻ“āϝāĻŧā§āϝāĻžāϰ 

5 thoughts on “Advanced Excel Course in Dhaka”

  1. Pingback: āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ āϕ⧋āĻ°ā§āϏ – āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ āϏāϞāĻŋāωāĻļāύ āĻāĻ¨ā§āĻĄ āĻŸā§āϰ⧇āύāĻŋāĻ‚ āϏ⧇āĻ¨ā§āϟāĻžāϰ

  2. Pingback: Computer Training Center Registration in Bangladesh: A Guide by Computer Solution and Training Center (CSTC) – āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ āϏāϞāĻŋāωāĻļāύ āĻāĻ¨ā§āĻĄ āĻŸā§āϰ⧇āύāĻŋāĻ‚ āϏ⧇āĻ¨ā§āϟāĻžāϰ

  3. Pingback: āĻ›āϝāĻŧ āĻŽāĻžāϏ āĻŽā§‡āϝāĻŧāĻžāĻĻā§€ āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ āϕ⧋āĻ°ā§āϏ āĻļāĻŋāĻ–āϤ⧇ āϚāĻžāĻšā§āϛ⧇āύ? – āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ āϏāϞāĻŋāωāĻļāύ āĻāĻ¨ā§āĻĄ āĻŸā§āϰ⧇āύāĻŋāĻ‚ āϏ⧇āĻ¨ā§āϟāĻžāϰ

  4. Pingback: āϘāϰ⧇ āĻŦāϏ⧇āχ āĻ…āύāϞāĻžāχāύ⧇ āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ āĻĒā§āϰāĻļāĻŋāĻ•ā§āώāϪ⧇āϰ āϏ⧁āϝ⧋āĻ— āĻĻāĻŋāĻšā§āϛ⧇ āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ āϏāϞāĻŋāωāĻļāύ – āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ āϏāϞāĻŋāωāĻļāύ āĻāĻ¨ā§

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top