excel for beginners

In Excel, you can format text as: 👉 This is useful for math formulas, chemical formulas, and notes 1. Apply Superscript (x²) Steps: Result: The number appears slightly above (x²) 2. Apply Subscript (H₂O) Steps: Result: The character appears slightly below (H₂O) ⚠️ Important Note 👉 Example: 3. How to Calculate Powers To square a

Strikethrough is a formatting style that draws a line through text.👉 It’s useful for showing something is done, canceled, or no longer needed — while still keeping it visible. 1. Apply Strikethrough Steps: Result: Text now has a line through it 2. Use Keyboard Shortcut (Faster) Steps: Result: 👉 Press Ctrl + 5 again to

You can merge cells to create one larger cell.This is useful when you want a title or label across multiple columns. 1. Merge Cells (Basic Use) Steps: Result: ⚠️ Important Warning If you merge cells with multiple values: 👉 Example: 2. Unmerge Cells 👉 Note: Deleted values will NOT come back unless you undo 3.

When your text is too long for a cell, Excel can display it on multiple lines inside the same cell.This makes your data easier to read. 1. Wrap Text Automatically Excel can automatically move text to a new line. Steps: Result: 2. Adjust Column Width Sometimes you need more space: 3. Adjust Row Height To

Format Painter is a very useful tool that helps you👉 copy formatting from one cell and apply it to another This saves a lot of time because you don’t need to format each cell manually. What can Format Painter copy? It copies things like: How to Use Format Painter 1. Select the cell with the

Excel already has many built-in formats like Currency, Date, Time, Percentage, etc.But sometimes, they don’t match what you need — that’s when Custom Number Format is useful. 1. Leading Zeros Instead of typing extra zeros manually, let Excel do it for you. Steps: Result: 2. Decimal Places You can decide how many decimal places to

In Excel: Sometimes, you may want numbers to behave like text (for IDs, phone numbers, etc.). 1. Change Number Format to Text Now, anything you type will be treated as text (even numbers) 2. Add an Apostrophe Excel will treat it as text, but the apostrophe won’t show in the cell 3. Use the TEXT

In Excel, text is left-aligned and numbers are right-aligned. This example teaches you how to convert ‘text strings that represent numbers’ to numbers. 1. Select the range A1:A4 and change the number format to General. 2. Numbers preceded by an apostrophe are also treated as text. Select cell A5 and manually remove the apostrophe. 3a. You can also combine

In Excel, Currency and Accounting formats are used to display money values.They look similar, but they behave slightly differently. 1. Apply Currency Format Step 1: Select the cells Select the range of cells that contains numbers. Step 2: Apply the format Go to: Home → Number group → Currency Shortcut: Ctrl + Shift + 4

Excel allows you to enter fractions, change fraction formats, and display fractions in different ways. 1. Enter a Fraction in Excel Mixed fraction To enter 1 4/7 (one and four sevenths) Simple fraction To enter 4/7, type: 0 4/7 The 0 is important, because without it Excel may think you are entering a date. Example: