Basics of Excel Tutorial - বেসিক এক্সেল অপশন পরিচিতি

Basics

 

This section explains the basics of Excel.

1:- Ribbon: 

Excel selects the ribbon's Home tab when you open it. Learn how to use the ribbon.

2:- Workbook: 

A workbook is another word for your Excel file. When you start Excel, click Blank workbook to create an Excel workbook from scratch.

3:- Worksheets: 

A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.

4:- Format Cells: 

When we format cells in Excel, we change the appearance of a number without changing the number itself.

5:- Find & Select: 

Learn how to use Excel's Find, Replace and Go To Special feature.

6:- Templates: 

Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used.

7:-Data Validation: 

Use data validation to make sure that users enter certain values into a cell.

8:- Keyboard Shortcuts: 

Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed.

9:-Print: 

This chapter teaches you how to print a worksheet and how to change print settings.

10:- Share: 

Learn how to share Excel data with Word documents and other files.

11:- Protect:

Encrypt an Excel file with a password so that it requires a password to open it.

Basics +

 

Become an Excel pro! You can find related examples and features on the right side of each chapter. Below you can find an overview.

Ribbon: 

1.      Quick Access Toolbar

2.      Customize the Ribbon

3.      Developer Tab

4.      Status Bar

5.      Checkbox

Workbook: 

1.      Themes

2.      View Multiple Workbooks 

3.      AutoRecover 

4.      Save in 97-2003 Format

Worksheets: 

1.      Zoom 

2.      Split 

3.      Freeze Panes 

4.      Group Worksheets 

5.      Consolidate 

6.      View Multiple Worksheets 

7.      Get Sheet Name 

8.      Spell Check

Format Cells: 

1.      Decimal Places 

2.      Fractions 

3.      Currency vs Accounting 

4.      Text to Numbers 

5.      Numbers to Text 

6.      Custom Number Format 

7.      Format Painter 

8.      Cell Styles

9.      Wrap Text 

10.  Merge Cells 

11.  Strikethrough 

12.  Superscript and Subscript 

13.  Check Mark

Find & Select: 

1.      Find Features 

2.      Delete Blank Rows 

3.      Row Differences 

4.      Copy Visible Cells Only 

5.      Search Box

 Templates: 

1.      Budget 

2.      Calendar 

3.      Holidays 

4.      Meal Planner 

5.      Invoice 

6.      Automated Invoice 

7.      Default Templates 

8.      Time Sheet 

9.      BMI calculator

Data Validation: 

1.      Reject Invalid Dates 

2.      Budget Limit 

3.      Prevent Duplicate Entries 

4.      Product Codes

5.      Drop-down List 

6.      Dependent Drop-down Lists 

7.      Cm to inches 

8.       Kg to lbs

Keyboard Shortcuts: 

1.      Function Keys 

2.      Insert Row 

3.      Save As 

4.      Delete Row 

5.      Scroll Lock 

6.       Bullet Points 

7.      Line Break 

8.      Show Formulas

 Print: 

1.      Workbook Views 

2.      Page Breaks 

3.      Headers and Footers 

4.      Page Numbers 

5.      Print Titles 

6.      Center on Page 

7.      Print Gridlines & Headings 

8.      Print Area

 Share: 

1.      Embed 

2.      PDF 

3.      Share Workbooks 

4.      OneDrive 

5.       Online 

6.      Import Access Data 

7.      Microsoft Query 

8.      Import/Export Text Files 

9.      XML

 Protect: 

1.      Protect Workbook 

2.      Protect Sheet 

3.      Lock Cells 

4.      Read-only Workbook 

5.      Mark as Final