Categories
Uncategorized

Excel (Basic)

Excel/Spreadsheet/Calc :

Excel is an application software that is used for storing and calculating data , preparing reports and preparing dashboards. Excel is useful for many roles (job profiles) like Business Analytics  , Research Analytics , Data Analytics  , HR Analytics  , Finance Analytics  ,MIS Executive , etc.

Moreover , excel is used for creating business insights.

How to start Excel :-

Step 1 :

Windows key (or Winkey)     + R

Note : The Windows key (Winkey) is a key on a Windows-compatible computer keyboard that has the Microsoft Windows logo. Te Windows key provides shortcuts. For example, pressing the key by itself will open the Windows Start menu.

Step 2:

“Run” option will open

Step 3:

Type “Excel”  in the open option

Step 4 :

Click “enter” key

Or click “OK”

Step 5 :

Click “enter” key  again

Rough idea of Excel or Spreadsheet or Calc :-

In 2023 , there are multiple “Office Suites” each providing  spreadsheets and few are mentioned below :

 1) Zoho Workplace

2) Microsoft Office

3) Google Workspace (formerly G suite)

4) Apple Office Suite / iWork

5) Apache OpenOffice

6) WPS Office (Kingsoft WPS Office)

7) FreeOffice

8) LibreOffice

9) Calligra (Calligra office suite)

10) OfficeSuite

11) Polaris Office

12) OnlyOffice

13) WordPerfect

14) NeoOffice

15) SSuite Office

16) ThinkFree Office

17) SoftMaker Office

18) Office Online (Microsoft)

19) CryptPad

Note : The factors which varies among “Office Suites” are mentioned :l(1) Tab(s)   ,  (2) Group(s)  ,  (3)  Option(s)  &  (4)  Usage of formulas and short keys

A – Title bar

B – Tab

C – Option(s’)

D – Group

E – Name box

F – Function

G – Formula bar

H – Maximise/Minimise

I – Maximise/Minimise

J – Close

Note : For all the “Office Suites” whether word , spreadsheet , powerpoint ,etc the below mentioned 04 options

are most important

 A – Title bar

B – Tab

C – Option(s’)

D – Group

K – “Sheet tab” means  Sheet (s’) in which individual(s) / industries or companies work  to collect , maintain and analyse data

L – Option to add more sheet(s’)  

“Range” – A collection of cells is known as range.Example- D10:E13 which means complete region from Dth column & 10th row (D10 cell)  to Eth column & 13th row (E13 cell).

In short ,  the below mentioned image is an overview :