Basic Excel Course & MS Office Training | Samyak Computer Classes

Welcome to the world of Excel! Whether you're looking to organize your budget or manage data at work, Excel is essentially a digital grid designed to do the "heavy lifting" of math and organization for you.

Here is a breakdown of the essentials to get you started.

1. The Anatomy of a Spreadsheet
Before you dive into data, it’s helpful to know the "map" of your workspace.

Cells: The individual rectangles where you type data. Each cell has an address (e.g., A1 is column A, row 1).

Columns: Vertical sections identified by Letters (A, B, C).

Rows: Horizontal sections identified by Numbers (1, 2, 3).

Workbooks vs. Sheets: A Workbook is your entire Excel file. A Sheet (or Tab) is a single page within that file.

2. Entering and Formatting Data
Excel is smart, but it needs to know what kind of data you are using to treat it correctly.

Text: Usually aligns to the left.

Numbers: Usually aligns to the right.

Formatting: Use the Home tab to change colors, bold text, or turn numbers into Currency ($) or Percentages (%).

AutoFill: If you type "January" in a cell and drag the bottom-right corner of that cell downward, Excel will automatically fill in the rest of the months for you.

3. Basic Formulas (The Magic)
This is where Excel shines. Every formula must start with an equals sign (=). If you don't type =, Excel just thinks you're writing a note.

Function What it does Example
SUM Adds a range of numbers together. =SUM(A1:A10)
AVERAGE Finds the mean value. =AVERAGE(B1:B5)
COUNT Counts how many cells have numbers in them. =COUNT(C1:C20)
MIN / MAX Finds the lowest or highest value. =MAX(D1:D10)
Pro Tip: Instead of typing numbers into formulas, click on the cells. That way, if you change the number in the cell later, your total updates automatically!

4. Helpful Shortcuts
To move like a pro, try these keyboard shortcuts:

Ctrl + Z: Undo (your best friend).

Ctrl + C / Ctrl + V: Copy and Paste.

Ctrl + Arrow Keys: Jump to the very edge of your data.

Alt + = : The "AutoS