Skip to main content

Basics Of Excel

MS Excel is a massive application, so you need to know the basics which will help you to navigate Excel and access features.

Below is the Image of Excel when you open it.










There are 5 important areas in the screen.

1. Quick Access Toolbar: This is a place where all the important tools can be placed. When you start Excel for the very first time, it has only 3 icons (Save, Undo, Redo). But you can add any feature of Excel to to Quick Access Toolbar so that you can easily access it from anywhere (hence the name).

2. Ribbon: Ribbon is like an expanded menu. It depicts all the features of Excel in easy to understand form. Since Excel has 1000s of features, they are grouped in to several ribbons. The most important ribbons are – Home, Insert, Formulas, Page Layout & Data.

3. Formula Bar: This is where any calculations or formulas you write will appear. You will understand the relevance of it once you start building formulas.

4. Spreadsheet Grid: This is where all your numbers, data, charts & drawings will go. Each Excel file can contain several sheets. But the spreadsheet grid shows few rows & columns of active spreadsheet. To see more rows or columns you can use the scroll bars to the left or at bottom. If you want to access other sheets, just click on the sheet name (or use the shortcut CTRL+Page Up or CTRL+Page Down).

5. Status bar: This tells us what is going on with Excel at any time. You can tell if Excel is busy calculating a formula, creating a pivot report or recording a macro by just looking at the status bar. The status bar also shows quick summaries of selected cells (count, sum, average, minimum or maximum values). You can change this by right clicking on it and choosing which summaries to show.

Labels:

Comments

Post a Comment

Popular posts from this blog

Metabase - Open Source BI tool

 Metabase          Metabase is a business software suite and open source business intelligence framework. It allows users to store data about their business or a specific aspect of their business for their analytics in a secure data source. This intuitive software is designed to allow users to ask questions about their data and access answers that reduce jargon and code, making it very user-friendly and ideal for professionals who want to visualize their business’s data accurately                    Install in docker https://github.com/punitprabhu/MetabaseNew.git         Excecute in CLI docker run -d -p 3000:3000 --name metabase metabase/metabase         Host http://localhost:3000 ,           http://localhost:3000/browse/1-sample-database                         ...
Post a Comment
Read more

Quantum Computing

  Quantum computing is a new kind of computing that uses the laws of quantum physics to solve certain problems much faster than classical computers.  It doesn’t replace your laptop but can tackle very complex simulations, optimization, and cryptography‑style tasks that are intractable for ordinary machines.  *** ### What is quantum computing? Quantum computing is a computing paradigm that uses quantum‑mechanical phenomena—like superposition, entanglement, and interference—to represent and process information in new ways. Instead of classical bits (0 or 1), quantum computers use **qubits**, which can be in a mix of 0 and 1 at the same time, enabling parallel computation.  *** ### Classical bits vs. qubits - A **classical bit** is either 0 or 1; operations are deterministic and sequential.  - A **qubit** can be 0, 1, or any quantum “blend” of both, written as $$ \alpha|0\rangle + \beta|1\rangle $$, where $$ \alpha $$ and $$ \beta $$ are complex numbers capturing p...
Post a Comment
Read more

How to Choose a BI tool

 How to choose a BI Tool                                          In the process of choosing a Business Intelligence (BI) tool, here is a list of seven key capabilities that are recommended to consider. These capabilities will help you evaluate and select the best BI tool that aligns with your specific business criteria and goals:                            Data integration              Data management              Data warehouse              Data analysis              Data visualization              Automation              Data security              Licensing Cost...
Post a Comment
Read more