top of page

INTRODUCTION TO EXCEL

Prior to delving into Excel functions and tools, there are certain fundamentals that should be addressed initially.

Let us commence our enchanting voyage in Excel collectively! Excel, crafted by Microsoft, stands as the most widely used spreadsheet software worldwide. And the remarkable aspect? Excel Online comes at no cost whatsoever.

This website harnesses the power of Excel Online technology to aid you in comprehending and honing your Excel skills, without necessitating the installation of Excel on your computer. Kudos to Microsoft! 

Therefore, let's conclude the chatter and embark on practical exercises!

Typing in Excel

While Excel is renowned for its ability to handle intricate calculations, it also serves as a suitable platform for typing regular text, akin to what you would do in Word or any comparable software.

Simply designate a cell of your choice and commence typing to seamlessly input your desired text.

                     How does Excel work?

                     Allow us to explore a few fundamental concepts in Excel:

                    - Excel Cell

                    - Excel Range

                    - Excel Worksheet

                    - Excel Workbook

                     The Excel Cell stands as the tiniest constituent within Excel and serves as a storage unit for data.

                     In Excel, an arrangement of rows and columns constitutes the structure. The rows are denoted by                               numbers, while the columns are indicated by leters.

Screen Shot 2023-06-26 at 5.04_edited.jpg

The Excel Range encompasses a collection of two or more contiguous cells, which can be positioned within the same row, the same column, or even span across multiple rows and columns!

For example, Range A1:C1 of the following picture:

Screen Shot 2023-06-26 at 5.12_edited.jpg

The Excel Spreadsheet consists of rows and columns. The standard Excel Spreadsheet comprises of 1,048,576 rows and 16,384 columns.

We can efficiently move between spreadsheets by utilizing the shortcut Ctrl+Page Up/Ctrl+Page Down.

Screen Shot 2023-06-26 at 6.02_edited.jpg

All right, let's kick off the enjoyable segment! Performing calculations in Excel is a breeze.
To initiate a calculation within a cell, we simply input the = sign (equals) followed by our desired calculation.
The following are the fundamental operators that can be employed:
+ Addition
- Subtraction
/ Division
* (Asterisk) Multiplication
^ Exponentiation (Power)

Screen Shot 2023-06-26 at 6.11.16 PM.png
bottom of page