How to Learn Basic Excel Skills

by

For many writers, the idea of tackling Microsoft Excel conjures images of complex formulas and intimidating spreadsheets, a world far removed from narrative arcs and evocative prose. Yet, in an increasingly data-driven world, even the most dedicated wordsmiths can benefit immensely from mastering basic Excel skills. Whether you’re tracking article submissions, managing freelance income, analyzing research data for non-fiction, or even just organizing your burgeoning book collection, Excel provides a powerful, often overlooked, toolkit for efficiency and clarity.

This guide isn’t about transforming you into a data analyst. It’s about equipping you with the fundamental skills that unlock Excel’s potential as a practical, everyday tool for writers. We’ll demystify the interface, break down core functionalities, and show you how to leverage this seemingly complex program for real-world writing tasks. Forget the fear; embrace the efficiency.

Deconstructing the Excel Canvas: Your Workspace Explained

Before we dive into actions, let’s understand your playground. When you open Excel, you’re greeted by a grid-like structure. This is your canvas.

Workbooks, Worksheets, and Cells: The Building Blocks

  • Workbook: Think of a workbook as an entire notebook. It’s the primary Excel file you save. It contains one or more worksheets.
  • Worksheet (Sheet): These are individual pages within your notebook. You’ll see tabs at the bottom labeled “Sheet1,” “Sheet2,” etc. Each worksheet is a separate grid. You can rename these for better organization (e.g., “Article Tracker,” “Income Log”).
  • Cell: This is the smallest unit in Excel, the intersection of a row and a column. Each cell has a unique address, or “cell reference,” like “A1” (Column A, Row 1), “C5” (Column C, Row 5). This addressing system is crucial for formulas.
  • Row: Horizontal lines of cells, numbered (1, 2, 3…).
  • Column: Vertical lines of cells, lettered (A, B, C…).
  • Range: A selection of two or more cells. You specify a range by its top-left and bottom-right cell references, separated by a colon, e.g., A1:C5 (all cells from A1 to C5). This is essential for applying operations to multiple data points.

The Ribbon: Your Command Center

At the top of the Excel window is the Ribbon, a dynamic set of tabs (Home, Insert, Page Layout, Formulas, Data, Review, View, Help) that house all of Excel’s commands.

  • Home Tab: This is your most-used tab for basic formatting, cell tools (cut, copy, paste), alignment, number formats, and basic sorting.
  • Insert Tab: For adding charts, pictures, pivot tables, and other objects.
  • Data Tab: Critical for organizing and analyzing your data, including sorting, filtering, and data validation.
  • Formulas Tab: Where you’ll find pre-built functions and tools for auditing formulas.

Spend a few minutes just clicking through these tabs to familiarize yourself with the general layout. You don’t need to memorize everything, just understand where to look.

Inputting and Managing Data: The Foundation of Any Spreadsheet

The first step in using Excel is getting your information into it. This seems obvious, but doing it efficiently makes a significant difference.

Entering Data into Cells

Click on a cell and start typing. Press Enter to move down a row, Tab to move right a column. Use the arrow keys to navigate freely.

Example for Writers:
Let’s say you’re tracking article submissions.
* In cell A1, type “Submission Date.”
* In cell B1, type “Publication.”
* In cell C1, type “Article Title.”
* In cell D1, type “Status.”
* In cell E1, type “Payment Due.”

Now, starting from A2, you’d fill in your submission details.

Editing and Deleting Data

  • Edit: Double-click the cell, or select the cell and press F2, or click in the Formula Bar (the long bar above the column letters).
  • Delete: Select the cell(s) and press Delete on your keyboard.

AutoFill: Your Time-Saving Ally

AutoFill is a brilliant feature for sequences. Hover your mouse over the bottom-right corner of a selected cell (it turns into a small black cross, the “fill handle”). Click and drag.

Concrete Examples:
* Series: Type “Monday” in A1. Drag the fill handle down, and Excel will auto-fill “Tuesday,” “Wednesday,” etc. Same for “Jan” (January), “Q1” (Quarter 1), “1st” (2nd, 3rd).
* Numbers: Type “1” in A1, “2” in A2. Select both cells. Drag the fill handle down, and Excel will continue the sequence (3, 4, 5…). If you just type “1” and drag, it will copy “1” repeatedly. Hold Ctrl while dragging if you only have one starting value and want a series.
* Dates: Enter “1/1/2024” in A1. Drag down, and it will fill consecutive dates.

This saves immense time when creating lists, schedules, or numbered entries.

Formatting for Clarity: Making Your Data Readable

Raw data can be overwhelming. Formatting makes it digestable, highlights important information, and improves readability. Everything in this section is primarily found under the Home Tab.

Basic Text and Number Formatting

  • Bold, Italic, Underline: Apply these as you would in a word processor. Highlight the cell(s) and click the respective icons (B, I, U).
  • Font and Font Size: Change the typeface and size to suit your needs.
  • Cell Background Color (Fill Color): Use to visually group or highlight categories. For your Article Tracker, you might color cells in “Status” green for “Accepted,” red for “Rejected,” and yellow for “Pending.”
  • Font Color: Change the color of the text itself.
  • Borders: Add lines around cells or ranges to create tables or emphasize sections. Select cells, click the borders dropdown, and choose your preferred border style.

Number Formatting: Essential for Financials and Dates

Excel sees raw numbers, but you need to tell it how to display them.

  • General: Default, no specific format.
  • Number: Displays numbers with a specific number of decimal places (e.g., 100.00).
  • Currency: Adds a currency symbol ($, €, £) and two decimal places. Crucial for tracking paychecks.
  • Accounting: Similar to currency, but aligns currency symbols and decimal points in a column.
  • Date (Short Date, Long Date): Displays numbers as dates. If you type “1/1/2024,” Excel usually recognizes it, but if you type “45292” it will look like gibberish until you format it as a date (it’s January 1, 2024, Excel counts days from Jan 1, 1900).
  • Percentage: Multiplies the number by 100 and adds a percent sign (e.g., 0.25 becomes 25%).
  • Text: Treats content as text, preventing Excel from trying to calculate it. Sometimes useful for numbers you don’t want treated as numerical values (e.g., product codes that start with zeros).

How to Apply: Select the cell(s), then either click the dropdown in the “Number” group on the Home Tab, or for more options, right-click and choose “Format Cells…”

Example:
* Your “Payment Due” column should be formatted as “Currency.”
* Your “Submission Date” column should be formatted as “Date.”

Alignment and Text Wrapping

  • Alignment: Control where text sits within a cell (left, center, right, top, middle, bottom).
  • Wrap Text: If you have long titles in your “Article Title” column, wrap text will make the row taller to display all content within the cell, rather than letting it spill over or cut off. Select the cell(s) and click “Wrap Text” on the Home Tab.
  • Merge & Center: Combines multiple cells into one large cell and centers the content. Useful for creating a main title across several columns. Be careful with this, as it can complicate some advanced functions.

Organizing Your Data: Rows, Columns, and Sheets

A well-organized spreadsheet is far more effective.

Inserting and Deleting Rows/Columns

  • Insert: Right-click on a row number (e.g., 5) to insert a new row above it. Right-click on a column letter (e.g., C) to insert a new column to its left. Or use the “Insert” command on the Home Tab.
  • Delete: Right-click on a row/column heading and select “Delete.” All data in that row/column will be removed.

Writer’s Use: You forgot to add a “Word Count” column after “Article Title.” Simply right-click column D, choose “Insert,” and a new column D will appear.

Adjusting Column Width and Row Height

  • Manually: Drag the boundary line between column letters or row numbers.
  • AutoFit: Double-click the boundary line, and Excel will automatically adjust the width/height to fit the widest/tallest content. This is a common time-saver.

Freezing Panes: Keeping Headers Visible

As your lists grow, you’ll scroll down and lose sight of your column headers (e.g., “Submission Date,” “Publication”). Freezing panes keeps them visible.

  • Select the cell below and to the right of the row/column you want to freeze. For example, to freeze row 1 (your headers), select A2.
  • Go to View Tab > Freeze Panes > Freeze Panes.
  • To freeze only the top row, choose “Freeze Top Row.”
  • To freeze only the first column, choose “Freeze First Column.”

This is incredibly useful for long lists of articles or research data.

Renaming, Adding, and Deleting Worksheets

  • Rename: Double-click the sheet tab (e.g., “Sheet1”) at the bottom, or right-click and choose “Rename.” Type in your new name (“Article Tracker,” “Book Expenses”).
  • Add: Click the “+” button next to the sheet tabs to add a new worksheet.
  • Delete: Right-click a sheet tab and choose “Delete.”

Keep related data on separate, clearly named sheets within the same workbook. For instance, one sheet for “Blog Post Ideas,” another for “Monthly Income Tracker,” and a third for “Research Notes.”

Basic Calculations with Formulas and Functions

This is where Excel truly shines. Even simple calculations save immense manual effort.

What’s the Difference? Formulas vs. Functions

  • Formula: An equation that performs calculations on your data. All formulas start with an equals sign (=). This is how Excel knows you want it to calculate, not just display text.
    • Example: =A1+B1 (adds the values in A1 and B1)
  • Function: Pre-defined formulas that perform specific calculations. They save you from typing out complex equations.
    • Example: =SUM(A1:A5) (adds up all values in the range A1 to A5)
    • Example: =AVERAGE(B1:B10) (calculates the average of values in B1 to B10)

Basic Arithmetic Operations

All formulas begin with =.

  • Addition: + (e.g., =A1+A2)
  • Subtraction: - (e.g., =A1-A2)
  • Multiplication: * (e.g., =A1*A2)
  • Division: / (e.g., =A1/A2)

Example:
If you have a “Rate per Word” in cell F2 and “Word Count” in cell E2, your “Total Payment” in cell G2 would be =F2*E2.

Essential Functions for Writers

The AutoSum button (summation symbol, Σ, on the Home tab) is your quick access for common functions.

  • SUM(range): Adds up all the numbers in a specified range.
    Writer’s Use: =SUM(G2:G50) to calculate your total earnings from articles.
  • AVERAGE(range): Calculates the average of numbers in a range.
    Writer’s Use: =AVERAGE(E2:E50) to find your average article word count.
  • MAX(range): Finds the largest number in a range.
    Writer’s Use: =MAX(G2:G50) to identify your highest paying article.
  • MIN(range): Finds the smallest number in a range.
    Writer’s Use: =MIN(E2:E50) to see your shortest article.
  • COUNT(range): Counts the number of cells in a range that contain numbers.
    Writer’s Use: =COUNT(A2:A50) to count how many article entries you have (assuming column A always has a number or date).
  • COUNTA(range): Counts the number of cells in a range that are not empty (contains any type of data).
    Writer’s Use: Better for counting your total articles, as it works even if column A has text identifiers.

Copying Formulas: Relative and Absolute References

This is a critical concept for efficiency. When you copy a formula, Excel changes cell references automatically unless you tell it not to.

  • Relative Reference (Default): When you copy =A1+B1 from C1 to C2, Excel changes it to =A2+B2. It adjusts references relative to the new position. This is usually what you want.
  • Absolute Reference: Sometimes, you want a reference to stay fixed when copied. Use the $ sign to “lock” a row, a column, or both.
    • $A$1: Locks both column A and row 1. (Always refers to A1)
    • $A1: Locks column A, but row 1 can change (e.g., A1, A2, A3).
    • A$1: Locks row 1, but column A can change (e.g., A1, B1, C1).

Writer’s Scenario:
You have a specific “Target Hourly Rate” in cell H1. You want to calculate “Time Spent (Hours)” in column I. Your formula in I2 might be =G2/H$1 (Total Payment / Target Hourly Rate). When you drag this formula down, G2 will change to G3, G4, etc. (relative), but H$1 will always refer to the fixed “Target Hourly Rate” in H1 (absolute). Without the $, H1 would become H2, H3, an incorrect calculation.

To quickly make a reference absolute, select the cell reference in the formula bar and press F4. Each press cycles through $A$1, A$1, $A1, and A1.

Data Manipulation: Sorting and Filtering

When you have a list of entries, sorting and filtering are indispensable for finding and organizing specific information. These features are primarily found under the Data Tab, or via the “Sort & Filter” button on the Home Tab.

Sorting Your Data

Sorting arranges your data in a specific order (alphabetical, numerical, chronological).

  • Single-Level Sort:
    1. Select any cell within your data range.
    2. Go to Data Tab > Sort & Filter group > A-Z or Z-A (for ascending/descending) or click the “Sort” button for more options.
    3. Excel usually auto-detects your data range and if you have headers. Confirm the column you want to sort by.
  • Multi-Level Sort:
    1. Select any cell within your data range.
    2. Go to Data Tab > Sort & Filter group > Sort.
    3. In the “Sort” dialog box, you can add multiple levels. For example, “Sort by Publication (A-Z), then by Status (A-Z), then by Submission Date (Newest to Oldest).”
    4. Ensure “My data has headers” is checked if you have them in the first row.

Writer’s Use: Sort your “Article Tracker” by “Publication” (A-Z) to see all submissions to a specific outlet, then by “Status” (e.g., “Accepted,” “Pending,” “Rejected”) to prioritize follow-ups.

Filtering Your Data

Filtering allows you to display only the rows that meet specific criteria, temporarily hiding the rest.

  1. Select any cell within your data range.
  2. Go to Data Tab > Sort & Filter group > Filter (or click the funnel icon on the Home tab).
  3. Small dropdown arrows will appear in your header row.
  4. Click an arrow in the column you want to filter.
  5. Text Filter: Uncheck “Select All” and select specific items (e.g., only “The New Yorker” from your “Publication” column). You can also use “Text Filters” for more complex criteria like “Contains ‘fiction’.”
  6. Number Filter: For numerical columns (like “Payment Due”), you can filter for “Greater Than,” “Less Than,” “Between,” etc.
  7. Date Filter: For date columns, you can filter by specific months, years, or relative dates like “Tomorrow,” “Last Week.”

Writer’s Use:
* To see all articles with “Pending” status: Click the filter arrow in “Status,” uncheck “Select All,” and check “Pending.”
* To see all articles where “Payment Due” is greater than $500: Click the filter arrow in “Payment Due,” choose “Number Filters,” then “Greater Than…” and enter 500.

To clear a filter, click the filter icon in the header again and choose “Clear Filter from [Column Name],” or click the main “Filter” button on the Ribbon again to remove all filters.

Essential Tools and Keyboard Shortcuts

Efficiency in Excel often comes down to knowing the useful little tricks and power-user shortcuts.

Copy, Cut, Paste (and Paste Special)

  • Ctrl+C (Copy): Copies selected cells.
  • Ctrl+X (Cut): Cuts selected cells.
  • Ctrl+V (Paste): Pastes copied/cut content.

Paste Special: This is incredibly useful. After copying, right-click the destination cell(s) and choose “Paste Special…” (or press Ctrl+Alt+V).

  • Values: Pastes only the results of formulas, not the formulas themselves. If you calculate =$A$1*B20 and paste as values, you’ll just get the number, not the formula. Essential when you want static data.
  • Formats: Pastes only the formatting (colors, fonts, borders), not the cell content.
  • Formulas: Pastes only the formula, without the destination cell’s formatting.
  • Transpose: Swaps rows and columns. If you have data in a column, it pastes it into a row, and vice-versa. Could be useful for re-orienting small datasets.

Writer’s Use Case for Paste Special: You’ve calculated your total earnings for the month using a SUM formula. You want to copy that total into a separate “Annual Income Summary” sheet, but you don’t want the formula linked to the original month’s sheet (what if you delete the monthly sheet?). Copy the cell with the sum, go to the summary sheet, and Paste Special > Values.

Undo and Redo

  • Ctrl+Z (Undo): Undoes your last action. A lifesaver for mistakes!
  • Ctrl+Y (Redo): Redoes the action you just undid.

Find and Replace

  • Ctrl+F (Find): Opens the Find dialog box.
  • Ctrl+H (Replace): Opens the Replace dialog box. Useful for correcting widespread typos (“Ms. Smith” to “Ms. Smyth”) or changing specific terms across a large dataset.

Quick Analysis Tool

When you select a range of data that contains numbers, a small icon appears in the bottom-right corner of the selection, or you can press Ctrl+Q. This brings up the “Quick Analysis” tool, offering context-sensitive options for:

  • Formatting: Conditional formatting (discussed next).
  • Charts: Quickly generate basic charts.
  • Totals: Add sums, averages, counts, etc., to selected data, either below or to the side.
  • Tables: Quickly convert your data into an Excel Table (highly recommended for many purposes, as tables auto-expand and make sorting/filtering easier).
  • Sparklines: Tiny charts within a single cell.

This is a very fast way to get insights into numerical data without digging into menus.

Visualizing Data: Simple Charts (Gantt Charts for Writers?!)

While Excel can create complex dashboards, even basic charts can help writers visualize progress, income trends, or research patterns.

Chart Types for Writers

  • Column/Bar Charts: Excellent for comparing discrete data points.
    • Writer’s Use: Compare word counts for different projects, or income per publication.
  • Line Charts: Best for showing trends over time.
    • Writer’s Use: Track monthly income, submissions over time, or progress on a long-term writing project (e.g., cumulative word count).
  • Pie Charts: Display parts of a whole (limited use for writers, often overloaded).
    • Writer’s Use: Breakdown of income by genre (if you have very few genres).

Creating a Basic Chart

  1. Select Your Data: Highlight the cells containing the data you want to chart, including any headers that will serve as labels for your chart axes. For example, to chart income by publication, select your “Publication” column and your “Total Payment” column. Make sure both columns are the same length.
  2. Go to Insert Tab > Charts group.
  3. Click on the chart type you want (e.g., “Recommended Charts” or “Column Chart”).
  4. Excel will generate a basic chart.
  5. Chart Elements: Use the + button that appears next to the chart to add or remove elements like Axis Titles, Data Labels, or a Legend.
  6. Chart Styles/Colors: Use the brush icon next to the chart to change its appearance.

Beyond the Basics: Simple Progress/Gantt Charts
While Excel isn’t a dedicated project management tool, you can create a simple Gantt chart-like view for your writing projects using conditional formatting and stacked bar charts.

Conceptual Idea for a Writing “Gantt” Chart:
* Columns: Project Name, Start Date, End Date, Duration (End-Start), then a column for each day of the month.
* Conditional Formatting: For each day column, apply a rule that colors the cell if the date falls between the project’s start and end dates. This creates a visual bar.
* A basic stacked bar chart can also represent project timelines by making the first “bar” transparent to act as an offset.

This takes a bit more setup but can be a powerful visual for tracking large writing projects.

Advanced Concepts (for when you’re ready): Conditional Formatting & Data Validation

Conditional Formatting: Visual Cues for Your Data

This automatically applies formatting (colors, icons, data bars) to cells based on their content, making trends and outliers instantly visible without manually coloring cells. Found on the Home Tab.

  1. Select the range of cells you want to format (e.g., your “Status” column, or your “Payment Due” column).
  2. Go to Home Tab > Styles group > Conditional Formatting.
  3. Highlight Cell Rules:
    • Greater Than/Less Than/Equal To: Highlight articles above a certain word count, or payments less than a target.
    • Text that Contains: Highlight cells in the “Status” column that contain “Pending” in yellow, “Accepted” in green, etc.
    • Duplicate Values: Find accidental duplicate entries in your submission tracker.
  4. Top/Bottom Rules: Highlight your top 10% of earning articles.
  5. Data Bars: Visual “fill” in a cell, proportional to its value. Excellent for showing payment amounts at a glance.
  6. Color Scales: Shades cells based on a gradient of colors (e.g., red for low values, green for high values).

Writer’s Scenario:
* Status at a Glance: Select your “Status” column. Conditional Formatting > Highlight Cell Rules > Text that Contains. Set up rules for “Accepted” (Green Fill), “Rejected” (Red Fill), “Pending” (Yellow Fill). Now you can see your pipeline instantly.
* Priority Payments: For your “Payment Due” column, use Conditional Formatting > Highlight Cell Rules > Greater Than. Set it to highlight payments > $1000 in bold blue, making your high-value invoices pop out.

Data Validation: Preventing Errors

Data validation restricts what users can enter into a cell, ensuring data consistency and accuracy. Found on the Data Tab.

  1. Select the cell(s) where you want to apply validation.
  2. Go to Data Tab > Data Tools group > Data Validation.
  3. Settings Tab:
    • Allow: Choose from:
      • Whole Number/Decimal: Restrict to numbers within a range.
      • List: Create a dropdown menu of pre-defined options. This is a game-changer!
      • Date/Time: Restrict to specific date ranges.
      • Text Length: Restrict the number of characters.
    • Data: Choose between, equal to, greater than, etc.
    • Source (for List): Type your options separated by commas (e.g., “Accepted,Pending,Rejected,Pitched”) or refer to a range of cells where your list is stored.
  4. Input Message Tab: Provide a helpful message when the user selects the cell.
  5. Error Alert Tab: Define what happens if the user enters invalid data (Stop, Warning, Information).

Writer’s Use Case:
* Standardized Status: For your “Status” column, use Data Validation to create a “List” dropdown with “Pitched,” “Submitted,” “Pending Edits,” “Accepted,” “Rejected,” “Paid.” This prevents typos and ensures all statuses are consistent, making filtering and analysis reliable.
* Valid Dates: For “Submission Date,” apply a “Date” validation to ensure only valid dates are entered.

Excel as a Writer’s Strategic Advantage

You’ve now navigated the core functionalities of Excel, moving beyond the intimidating grid to discover its practical applications for your writing life. This journey from basic data entry to powerful organization, calculation, and visualization tools is a significant step towards greater efficiency and clarity.

Embrace Excel not as a distraction from your craft, but as an invisible hand that tidies your workspace, tracks your progress, and illuminates your path. The more you use these foundational skills, the more intuitive they become, freeing up valuable mental space for what you do best: writing. Start small, experiment with the examples provided, and watch as Excel transforms from a bewildering program into a valuable ally in your literary pursuits. Your organized data awaits.