Installing Excel

To either Access Excel on your browser or Download it. Click here

The first step to Accessing Excel on your browser is to sign into your microsoft account. This can be provided by an Institution or Organization, where you can sign in with a work or school email.

If you are interested in Downloading Excel, you can click the link provided, and scroll down to the Download the app section, where it will prompt you with instructions to download the proper installation files.

Excel Basics

Sheets VS Workbooks

Before we start, a quick distinction should be made between Sheets and Workbooks.

In excel, we work in a Workbook. This is what we assign a name to when creating the file. When we are working within a workbook we are manipulating a Sheet. There can be multiple different sheets in one workbook.

Data Types

There are many different data types in excel.

Understanding when to use what datatypes is important for ensuring you have Clean Data that is compatible with scripts and can be Transferred Among Softwares.

Having the right data can also keep your spreadsheet Organized

Data Type Appearance Best Purpose
General Hello If you have no specific purpose
Number 6 Running computations and doing math
Currency $ 6.00 Running functions requiring currency remainders
Date 1/1/2026 Working with Time Series Data
Accounting $ 6.00 Running accounting related math
Time 1/1/2026: 12:00 PM Logging specific events or values at certain times
Percentage 83% Performing Statistical or Scientific Work
Fraction 6 1/2 Working with data that needs to be semi-precise
Scientific 6.00 E+00 Data with extremely large values, can help save memory
Text Basic Text Logical Operators, classifying data by groups, and organizing columns and rows.

Headers

Spreadsheet headers allow you to Navigate Excel’s Different Tools.

  • Home

    The Home section of the spreadsheet houses most of the Stylistic and Formatting Features for Your Spreadsheet. Some examples are the Text Size, Font, Conditional Formatting, Borders, and Highlighting Within Cells.

  • Insert

    The Insert section is one of the most widely used sections as it allows you to add External Information to your spreadsheet such as Data, and Images. This section also allows you to Visualize Data.

  • Share

    The share section allows you to Publish Your Data and create shareable links.

  • Page Layout

    The layout section allows you to modifyLarge Scale and Specific Aesthetic features in a spreadsheet or in your whole workbook.

  • Formulas

    One of the most important excel sections. This section allows you to Insert Functions, Formulas, and run Calculations in your workbook.

  • Data

    This section allows you to Manipulate Your Data in significant ways that can help clean up the organization of it. Base Level Analysis can also be done in the data section.

  • Review

    You can review the History and Back end Performance with this section.

  • View

    This section allows you to Change how you View the sheet.

  • Automate

    You are able to Import Scripts into your spreadsheet to improve efficiency.

  • Help

    Access Tutorials, and other Resources to improve your excel skills.

  • Draw

    Create Informal Annotations in your spreadsheet.

Common Excel Tools

Transferring Data Between Cells

Copying information is possible through pressing CTRL+C / CMD+C in one cell, and CTRL+V/CMD+V in your target cell. You copy and paste information from your current workbook, other workbooks, spreadsheets, and URLS.

The Small Green box in the bottom right corner of the cell your working in allows you to also copy a value from one cell and paste it to an undetermined amount of cells within the same row or column.

This tool also is used able to Automate Tedious Processes with functions. This is done when you provide at least 2 data points in adjacent cells as a reference.

When we Highlight Two Cells that show a certain pattern such as two cells with the numbers 1 and 2 in them, when we drag down with the green box it will begin to fill in the Pattern Within the Empty Cells.

We would be left will cells that count from 1 through Any Number depending on where stopped.

Add and Remove content

with Excel you can Add or Remove columns with the + / - symbols when you near the edge of a cell.

You can also do so by Right Clicking on a Column or row, which will give you the option to remove or add a row/column.

Cell Modification

The Wrap Button is located in our home header and looks like a blue snake.

Pressing this button will take any text in your cell and make it fit the cell width.


--------------------------------------------------------
its the differ|ence| betwe|en a cell tha|t is long like this 
--------------|----|------|-------------|---------------                        
and a shorter |    |      |             |
              |    |      |             |
cell like this|    |      |             |
---------------------------------------------------------

We can also Change the Width of cells. This can be done by moving our cursor to the Edge of a Cell until we access the arrow tool. Then, we can click and drag to any width we want.

Merge

Right clicking over a series of cells will allow you to Merge the contents of those cells into one much larger cell.

Working With Spreadsheet Data

Data Organization

Excel offers a variety of simple tools that allow you to Organize, and Clean data.

  • Ascending and Descending Functions

    Excel’s ascending and descending feature allow you to display your data by Columns Values. It will sort select columns either from Maximum to Minimum values, or from Minimum to Maximum values.

  • Custom Sort

    Custom sort is a powerful tool when working with spreadsheets that allows you to Organize your spreadsheet by Ascending or Descending values in Multiple Different Columns.

  • Pivot Tables

    Pivot tables are an effective way to Filter Large Spreadsheets to select for data of interest.

    Filter

    Within the Data header. The Filter Command allows you to create a Dropdown for selected columns.

    This Dropdown allows you to Select Certain Row Values that you want displayed in your spreadsheet.

  • Data Validation

    Excels data validation tools allows you to Predetermine what Data Types Values are allowed in certain columns. You can use this to organize columns by 1 data type consistently or if you have values that need to have uniform syntax.

    the List validation tool allows you to Create a List of Words and Values that are allowed in a column, helping to make tedious data entry faster.

Visualizing Data

There are many tools that serve different purposes in excel for analyzing data. While there are many ways to visualize data, these are some common ones.

Visualization Tool Name Common Purpose
Table Visualizing grouped data
Line Graph Graph Depicting relationships between 2 variables
Column Graph Comparing two different variables
Pie Chart Showing variance in a groups responses
Box Plot Comparing statistical factors between variables
Histogram Showing the distribution of values in a spreadsheet
Conditional Formatting Highlighting Changes in Cell Values

Analyzing Data

We have various functions that help us Automate tedious tasks. These are grouped into different types of Formulas.

Formula Type Purpose
Financial Computes values to provide financial information
Logical Computes boolean values for a column of data to group and filter
Text Allows you to maniuplate characters and strings
Date & Time Lets you pull values from date and time data types
Look up & Reference Provides functions to pull certain cell values and types
Math Lets you run mathematics operations

Using Functions

when we use functions in a cell, we will use the = sign and then our function.

Lets make a function that would sum a series of values within a spreadsheet.

First, we will assign our function


=SUM()

Now that our function is assigned we can add the cells we would like to apply our function to.

=SUM(A1:C10)

’ Our colon symbol represents the values between A11 and C10, this means we want to calculate the sume of all values from A1 through C10.’

These functions can be used to Compute Statistical Values such as Means, Medians, and Modes, filter data into groups such as a Yes and No, and compute conversions between Kilometers and Miles, or Kilograms and Pounds.

There are many more functions and operations that you can perform with our = command, we recommend that you check out our CSU and Non CSU resources to learn more!

Next Steps

Now that we have introduced some basic components of excel. We will briefly outline VBA Coding and how we can use this to Write Scripts.

« Previous: Excel Next: Using VBA Code »