Basic Excel Skills For Operators
1. Introduction to Excel
● What is Excel?
○ A spreadsheet application used for data organization, analysis, and visualization.
● Basic Interface Overview:
○ Workbook: An Excel file containing multiple sheets.
○ Worksheet: A single sheet inside the workbook.
○ Cells: The individual data holders, organized into rows and columns.
○ Columns and Rows: Columns are labeled with letters, rows with numbers.
○ Formula Bar: Where you can view and edit the contents of a selected cell.
2. Basic Functions of Excel
● Entering Data:
○ Click a cell and type to enter text, numbers, or dates.
● Formatting Cells:
○ Adjust font size, color, cell borders, alignment, and text orientation.
○ Apply number formatting (e.g., currency, percentages, date).
● Basic Data Operations:
○ Copy, cut, and paste data (using right-click or shortcuts: Ctrl+C, Ctrl+X,
Ctrl+V).
○ Use the "Fill Handle" (the small square at the corner of a selected cell) to copy
data to adjacent cells.
3. Simple Formulas and Functions
● Introduction to Formulas:
○ A formula starts with an equal sign (=).
○ Example: =A1+B1 will add the values in cells A1 and B1.
● Basic Math Functions:
○ =SUM(A1:A5) to sum up numbers in a range of cells.
○ =AVERAGE(A1:A5) to calculate the average of values in a range.
○ =MIN(A1:A5) and =MAX(A1:A5) to find the minimum and maximum values,
respectively.
○ =COUNT(A1:A5) to count the number of numerical entries in a range.
● Basic Text Functions:
○ =CONCATENATE(A1, " ", B1) or =A1 & " " & B1 to join text from two
cells.
○ =UPPER(A1) to convert text to uppercase.
○ =LOWER(A1) to convert text to lowercase.
○ =LEN(A1) to find the length of text in a cell.
4. Cell Referencing
● Relative vs Absolute References:
○ Relative reference (e.g., =A1+B1) changes when copied to another cell.
○ Absolute reference (e.g., =$A$1+$B$1) remains the same when copied.
● Mixed References:
○ Example: =$A1+B$1 — Only the column or row is fixed, not both.
5. Basic Data Organization and Sorting
● Sorting Data:
○ Sorting by ascending or descending order (numbers, dates, text).
○ Sort data alphabetically or numerically using the "Sort" feature in the ribbon.
● Filtering Data:
○ Use AutoFilter to display only specific data in a large dataset.
○ Set custom filters (e.g., show only values greater than 100).
6. Working with Tables
● Creating a Table:
○ Select a range of data and click "Insert" -> "Table" to create a structured table.
● Table Features:
○ Sort and filter data within a table.
○ Use table references (e.g., =Table1[@Column1]).
7. Basic Charts and Graphs
● Creating a Chart:
○ Select data and choose "Insert" -> "Chart" (e.g., bar, line, pie charts).
● Customizing Charts:
○ Change chart title, legend, and labels.
○ Modify chart style and colors.
● Chart Types:
○ Bar/Column Charts: For comparing values.
○ Line Charts: For showing trends over time.
○ Pie Charts: For showing parts of a whole.
8. Basic Data Validation
● Setting Validation Rules:
○ Use Data Validation to restrict what data can be entered in cells (e.g., only
numbers, dates, or a list of choices).
○ Example: Allow only numbers greater than 0 in a cell.
9. Printing and Page Layout
● Setting Print Areas:
○ Select the range to print and define it as the print area.
● Adjusting Page Layout:
○ Set margins, orientation (portrait/landscape), and paper size.
● Previewing and Printing:
○ Use the "Print Preview" to see how the worksheet will look when printed.
10. Basic Keyboard Shortcuts
● Ctrl + C: Copy
● Ctrl + X: Cut
● Ctrl + V: Paste
● Ctrl + Z: Undo
● Ctrl + Y: Redo
● Ctrl + F: Find
● Ctrl + S: Save
● Ctrl + A: Select all
● Ctrl + Shift + L: Toggle filters
11. Saving and Sharing Workbooks
● Saving a Workbook:
○ Save your workbook regularly using Ctrl + S.
○ Save in different formats (e.g., .xlsx, .xls, .csv).
● Sharing Workbooks:
○ Share through email or cloud services like OneDrive or Google Drive.
