MS- Excel-2007

📘 Getting Started with Excel 2007

Microsoft Excel 2007 introduces several new features alongside familiar tools. The main elements you'll frequently interact with are:

• 📌 Microsoft Office Button
• 📌 Quick Access Toolbar
• 📌 Ribbon Interface

MS Excel 2007 Tutorial by ABCSA

🧮 Spreadsheets

A spreadsheet is a digital document with vertical columns and horizontal rows. The intersection of a column and row is a cell, where data is entered and formulas are applied. A workbook can hold multiple worksheets.

🟡 Microsoft Office Button

Found in the top-left corner, this button replaces the older 'File' menu. It allows you to:

• Create a new workbook
• Open, Save, Save As
• Print, Send, Close workbooks

📌 Ribbon Interface

The Ribbon has 7 main tabs: Home, Insert, Page Layout, Formulas, Data, Review, View. Each tab includes logical groups of tools. To access more features in a group, click the small arrow in the bottom-right of the group.

• Home: Clipboard, Fonts, Alignment, Styles, Editing
• Insert: Tables, Charts, Illustrations, Links
• Page Layout: Themes, Page Setup, Arrange
• Formulas: Function Library, Auditing
• Data: Sort, Filter, Data Tools
• Review: Proofing, Comments, Protection
• View: Zoom, Macros, Window Options

⚡ Quick Access Toolbar

A customizable toolbar with frequently used commands. Right-click any Ribbon button and select "Add to Quick Access Toolbar" to include it. You can move it below the Ribbon by clicking the small arrow on its right side.

✏️ Mini Toolbar

The Mini Toolbar appears when you right-click text. It provides quick formatting tools like Bold, Italic, Font Size, and Color.

📁 Working with Workbook

📄 Create a Workbook

• Click Microsoft Office Button
• Select New
• Choose Blank Workbook

💾 Save a Workbook

• Click Office Button → Save
• Or use Save As to rename or save in an older format (Excel 97-2003)

📂 Open a Workbook

• Click Office Button → Open
• Browse to the file and open

⌨️ Entering Data

• Click a cell and type
• Or type in the formula bar after selecting the cell

✂️ Manipulating Data

🔲 Select Data

• Click and drag to select cells
• Click row/column headers to select entire rows/columns

📋 Copy & Paste

• Select → Home tab → Copy
• Go to destination → Paste

✂️ Cut & Paste

• Select → Home tab → Cut
• Paste in new location

↩️ Undo & Redo

• Click Undo or Redo on the Quick Access Toolbar

🔁 Auto Fill

Fill cells with repetitive data or patterns (e.g. days, numbers). Just:

• Type initial data
• Use the Fill Handle (bottom-right corner of cell)
• Drag to auto-fill

🛠️ Modifying the Worksheet

➕ Insert Cells/Rows/Columns

• Select row/column
• Home tab → Cells group → Insert
• Choose: Insert Cell, Row, or Column

🗑️ Delete Cells, Rows & Columns

• Click the cell, row, or column you wish to delete
• Go to Home tab → Cells group → Delete
• Select: Delete Cells / Delete Rows / Delete Columns

🔍 Find and Replace

• Home tab → Editing group → Find & Select
• Select Find or Replace
• Enter the text in Find What
• Click Options for advanced settings

📌 Go To Command

• Home tab → Editing group → Find & Select
• Click Go To to jump to a cell reference or named range

📝 Spell Check

• Go to the Review tab
• Click Spelling

🧮 Performing Calculations

➕ Excel Formulas

Formulas in Excel begin with an = sign and may include:

• References: Cell or range used in calculation (e.g., A1, B1:B5)
• Operators: +, -, *, / etc.
• Constants: Fixed values like 100 or "Hello"
• Functions: Predefined calculations like =SUM()

To enter a formula:

• Click the target cell
• Type = followed by the formula (e.g., =A1+B1)
• Press Enter

📊 Calculate with Functions

1. SUM: Adds numbers
2. AVERAGE: Finds average
3. MIN: Finds smallest number
4. MAX: Finds largest number
5. COUNT: Counts numeric entries

Steps:

• Select the cell where result should appear
• Click Insert Function (fx)
• Choose function & enter range
• Click OK

📚 Function Library

Located in the Formulas tab, this includes:

1. AutoSum: Quick totals
2. Financial: Interest, cash flow etc.
3. Logical: AND, OR, IF
4. Text: Text functions like CONCATENATE
5. Date & Time: NOW, TODAY
6. Math & Trig: ROUND, SIN, COS

🔁 Relative, Absolute & Mixed References

Excel updates formula cell references when copied unless you use absolute references:

• Relative: =A1+B1 → changes as copied
• Absolute: =$A$1+$B$1 → fixed reference
• Mixed: =A$1+$B2 → part fixed, part relative

🔗 Linking Worksheets

To reference a cell in another worksheet, use the format:
=SheetName!CellAddress
Example: =A1 + Sheet2!A2

📑 Sort and Filter

🔡 Basic Sorts

• Select data range
• Home tab → Sort & Filter
• Choose Sort A-Z or Sort Z-A

🧩 Custom Sorts

• Click Sort & Filter → Custom Sort
• Select primary sort column
• Click Add Level for more columns
• Click OK

🔍 Filtering

• Select the data column(s)
• Click Sort & Filter → Filter
• Click the dropdown in a column header
• Apply Text Filter or value-based filters
• To clear filter: Sort & Filter → Clear

📘 Continue to the next part for Charts, Printing, and Advanced Tools in Excel!

📈 Working With Charts

Charts help visualize worksheet data in formats such as Column, Line, Pie, Bar, Area, Scatter, and more.

🎨 Create a Chart

• Select data to visualize
• Go to Insert tab
• Choose desired chart type

✏️ Modify a Chart

• Move: Drag chart or use Move Chart on Design tab
• Change Data: Click chart → Select Data
• Switch Axes: Click chart → Switch Row/Column
• Edit Labels: Layout tab → Chart Title/Data Labels

🧰 Chart Tools

Available tabs when chart is selected:

• Design: Chart types, layout, location
• Layout: Labels, axes, background, shapes
• Format: Fonts, styles, effects

📄 Copy Chart to Word

• Select the chart → Copy
• Open Word → Paste chart into document

🎨 Format Worksheet

🔠 Convert Text to Columns

• Highlight desired column
• Data tab → Text to Columns
• Select Delimited (comma/tab) or Fixed Width

🔤 Modify Fonts

• Select cells
• Use Font group on Home tab: type, size, color, bold, italic, underline

📦 Format Cells Dialog

Home tab → Alignment group → Dialog Box Launcher opens:

1. Number: Format numbers/decimals
2. Alignment: Text position, wrap, merge
3. Font: Style, size, color
4. Border: Outline styles
5. Fill: Cell background

📌 Borders & Colors

• Borders: Home tab → Borders dropdown
• Fill: Home tab → Fill Color dropdown
• Styles: Home tab → Cell Styles

📏 Adjust Column Width/Row Height

• Home tab → Cells group → Format
• Choose manual value or AutoFit

🙈 Hide/Unhide Rows or Columns

• Select row/column → Format → Hide & Unhide

🔗 Merge Cells

• Select cells → Home tab → Merge & Center
• Options: Merge & Center, Merge Across, Merge Cells, Unmerge

🧭 Align Cell Content

• Use options in Alignment group: Top/Middle/Bottom Align, Left/Center/Right Align, Indent, Orientation

📘 Developing a Workbook

📌 Rename Worksheet / Change Tab Color

• Home tab → Format → Rename Sheet / Tab Color

↔️ Reposition Worksheets

• Drag worksheet tab to new position

➕ Insert / 🗑️ Delete Worksheets

• Home tab → Cells group → Insert / Delete → Sheet

📄 Copy Worksheets

• Right-click sheet tab → Move or Copy → Check "Create a copy"

🖨️ Page Setup & Printing

📝 Set Print Titles

• Page Layout tab → Print Titles
• Select rows/columns to repeat

📄 Header & Footer

• Insert tab → Header & Footer
• Use Design tab to insert page #, date, etc.

📐 Margins & Orientation

• Page Layout tab → Margins or Orientation
• Choose preset or custom values

📃 Page Breaks & Print Area

• Insert breaks: Page Layout → Breaks
• Print range: Select area → Page Layout → Print Area

📐 Layout Tools

🔀 Split Worksheet

• Select a cell → View tab → Split

❄️ Freeze Panes

• View tab → Freeze Panes → Freeze Top Row / Left Column
• Unfreeze via same menu

🙈 Hide / Show Worksheets

• Right-click sheet tab → Hide / Unhide

Download PDF Tutorial

Take Online Excel Test

MS Excel 2007 tutorial by ABCSA – Learn Excel online for free!