Foundational Excel Skills: Mastering Data Manipulation

Overview

Acquire essential skills in Excel to proficiently organize and manipulate data within spreadsheets. Learn techniques such as sorting and filtering data, creating tables, and utilizing formulas and other powerful tools.

Audience

Faculty, Staff, Students

What is Microsoft Excel?

A spreadsheet program of columns and rows that can be manipulated mathematically. 

• Calculate, model and analyze data.
• Build charts and visualize insights.
• Identify trends, reporting, and forecasting

Process

(VIDEO) - Excel Video Training 

Use Welcome to Excel Spreadsheet to learn the following topics

Microsoft Excel Video Training consist of the following topics:

• Quick start
• Intro to Excel
• Rows & columns
• Cells
• Formatting
• Formulas & functions
• Tables
• Charts
• Pivot tables
• Share & co-author
• Linked data types
• Get to know Power Query

Getting Started with Excel

Cells are boxes that you see in the grid of an Excel Worksheet. Each Cell is identified by columns and rows location on worksheet. 

• Columns: Letters (vertical)
• Rows: Numbers (Horizontal)

Create a Workbook: Click the File tab and select New or press Ctrl + N. Double-click a workbook.

Open a Workbook: Click the File tab and select Open or press Ctrl + O. Select a recent file or navigate to the location where the file is saved.

Preview and Print a Workbook: Click the File tab and select Print.

Undo: Click the Undo button on the Quick Access Toolbar.

Redo or Repeat: Click the Redo button on the Quick Access Toolbar. The button turns to Repeat once everything has been re-done.

Use Zoom: Click and drag the zoom slider to the left or right.

Select a Cell: Click a cell or use the keyboard arrow keys to select it.

Select a Cell Range: Click and drag to select a range of cells. Or, press and hold down the Shift key while using the arrow keys to move the selection to the last cell of the range.

Select an Entire Worksheet: Click the Select All button where the column and row headings meet.

Select Non-Adjacent Cells: Click the first cell or cell range, hold down the Ctrl key, and select any non-adjacent cell or cell range.

Cell Address: Cells are referenced by the coordinates made from their column letter and row number, such as cell A1, B2, etc.

Jump to a Cell: Click in the Name Box, type the cell address you want to go to, and press Enter.

Change Views: Click a View button in the status bar. Or, click the View tab and select a view.

Recover an Unsaved Workbook: Restart Excel. If a workbook can be recovered, it will appear in the Document Recovery pane. Or, click the File tab, click Recover unsaved workbooks to open the pane, and select a workbook from the pane

Formulas:

Using Absolute Reference: https://support.microsoft.com/en-us/office/switch-between-relative-and-absolute-references-981f5871-7864-42cc-b3f0-41ffa10cc6fc