Excel Basic Features

Salesforce Admin
Excel Training
Study Material

Basic Features

Certainly! Here are some of the most basic features in Microsoft Excel that are commonly known:

Cells, Rows, and Columns: Understanding the basic structure of Excel, where data is entered into cells, organized in rows and columns.

Data Entry: Entering data into cells by typing text or numbers directly.

AutoSum: Quickly adding up a column or row of numbers using the AutoSum function.

Basic Formulas: Performing basic arithmetic operations like addition, subtraction, multiplication, and division using simple formulas.

Copy and Paste: Copying data from one cell or range and pasting it to another location.

Formatting: Basic text formatting options such as bold, italic, underline, font size, and color.

Cell Alignment: Aligning text to the left, right, or center within a cell.

Fill Handle: Using the fill handle (small square at the bottom-right corner of a cell) to copy values or create number sequences.

Undo and Redo: Reversing or redoing the last action performed in Excel.

Save and Open Files: Saving a workbook and opening existing ones.

Sheet Navigation: Switching between different sheets in a workbook.

Basic Chart Creation: Creating simple charts, such as bar charts or pie charts, from selected data.

Sorting Data: Sorting data in ascending or descending order based on a selected column.

Filtering Data: Using the filter tool to display specific data based on criteria.

Spell Check: Checking the spelling of text within cells.

Print Preview: Previewing how a document will appear when printed.

Zoom In/Out: Adjusting the zoom level to make the content more readable or fit more on the screen.

Freeze Panes: Freezing rows or columns to keep them visible while scrolling through large datasets.

Cell References: Understanding the difference between relative and absolute cell references in formulas.

Merge and Center: Combining multiple cells into one and centering the content.

These basic features provide a foundation for using Excel and are typically among the first skills that users acquire when getting started with the program. They form the building blocks for more advanced Excel functionalities as users progress in their proficiency with the software.

Course Video

Course Video

YouTube Reference :