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 chapterat the bottom of each chapter. Below you can find an overview.

1 Ribbon: Quick Access Toolbar | Customize the Ribbon | Developer Tab | Status Bar | Checkbox

2 Workbook: Themes | View Multiple Workbooks | AutoRecover | Save in 97-2003 Format

3 Worksheets: Zoom | Split | Freeze Panes | Group Worksheets | Consolidate | View Multiple Worksheets | Get Sheet Name | Comments | Spell Check | Unhide Sheets

4 Format Cells: Decimal Places | Fractions | Currency vs Accounting | Text to Numbers | Numbers to Text | Custom Number Format | Format Painter | Cell Styles | Wrap Text | Merge Cells | Strikethrough | Superscript and Subscript | Check Mark

5 Find & Select: Find Features | Wildcards | Delete Blank Rows | Row Differences | Copy Visible Cells Only | Search Box

6 Templates: Budget | Calendar | Holidays | Meal Planner | Invoice | Automated Invoice | Default Templates | Time Sheet | BMI calculator

7 Data Validation: Reject Invalid Dates | Budget Limit | Prevent Duplicate Entries | Product Codes | Drop-down List | Dependent Drop-down Lists | Cm to inches | Kg to lbs

8 Keyboard Shortcuts: Function Keys | Insert Row | Save As | Delete Row | Formula to Value | Scroll Lock | Bullet Points | Line Break | Show Formulas | Paste Special

9 Print: Workbook Views | Page Breaks | Headers and Footers | Page Numbers | Print Titles | Center on Page | Print Gridlines & Headings | Print Area

10 Share: Embed | PDF | Share Workbooks | OneDrive | Online | Import Access Data | Microsoft Query | Import/Export Text Files | XML

11 Protect: Protect Workbook | Protect Sheet | Lock Cells | Read-only Workbook | Mark as Final

Basics+

 

Below you can find the most popular pages in this section.

1 Drop-down List: Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values.

2 Lock Cells: You can lock cells in Excel if you want to protect cells from being edited.

3 Budget: This example shows you how to create a budget in Excel.

4 Time Sheet: This example teaches you how to create a simple timesheet calculator in Excel.

5 Freeze Panes: If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.

6 Delete Blank Rows: This example teaches you how to delete blank rows or rows that contain blank cells.

7 Check Mark: To insert a check mark symbol in Excel, simply press SHIFT + P and use the Wingdings 2 font.

8 Calendar: This example describes how to create a calendar in Excel (2022 calendar, 2023 calendar, etc).

Check out all 300 examples.