STATISTICAL

DATA ANALYSIS

LAB

​

23^rd October 2024

Topics to discuss

​

• Introduction to M.S.Excel
• Introduction to Ribbons
• New Functions & Features of Excel 2007
• Short cuts in Excel
• Q&A

Do You Know?

​

• How to open Excel File?
• How many Number of Rows & Columns?
• What is Cell?
• How many number of sheets we can create in one excel file?
• What is the size in memory for excel empty file?

Introduction to M.S.Excel

• Microsoft Excel (MS Excel) is a widely-used spreadsheet application developed by Microsoft, designed to organize, format, and calculate data using formulas. It’s an essential tool for performing a wide range of tasks, from simple calculations to complex data analysis, and is commonly used in fields like business, finance, data analysis, and education.
• MS Excel is a powerful and flexible tool used for organizing and analyzing data, performing calculations, and creating visual representations of data. It’s widely used for both simple tasks (like budgeting) and complex analyses (like data modeling).

M.S.Excel

​

• Microsoft Excel was first introduced in 1985 for the Apple Macintosh. Later, it was released for Microsoft Windows in 1987, marking its introduction to a broader audience on the Windows platform. Excel quickly became one of the most widely used spreadsheet applications in the world.

​

Introduction to M.S.Excel�

• Excel is an electronic spreadsheet program that can be used for storing, organizing, analyzing and manipulating data.
• Microsoft Excel consists of worksheets.
• Each worksheet consists of a grid of columns and rows.
• There are 16,384 columns in each worksheet, lettered consecutively from A to XFD.
• The rows are numbered consecutively from 1 to 1,048,576

​

Key Features of Excel

Data Management: Excel allows users to store large datasets and organize them into tables for better management.

Formulas and Functions: It provides built-in mathematical, logical, and statistical functions, which can be used to perform complex calculations automatically.

Data Visualization: Excel supports creating various types of charts (like pie, bar, line charts) to visually represent data patterns and trends.

Pivot Tables: These enable dynamic data summarization and report generation.

Macros: Excel allows automation of repetitive tasks using macros, which are sequences of recorded actions.

Introduction to Ribbons

The Excel Ribbon is the toolbar at the top of the Excel interface that organizes commands into logical groups. It is composed of Tabs, Groups, and Commands. Here's a breakdown of its components:

*Tabs(Main Sections)

*Groups(Sub-Section with Tabs)

*Commands(Specific Actions)

*Quick Access Toolbar

*File Tab (Backstage View):

​

�1. Tabs (Main Sections)�

The Ribbon has several tabs, each containing related commands:

Home: Basic functions like formatting, alignment, number formatting, and clipboard commands (cut, copy, paste).

Insert: Tools for inserting tables, charts, illustrations (images, shapes), and other objects like links or text boxes.

Page Layout: Controls for page setup, themes, and print settings (margins, orientation).

Formulas: Functions and formulas, formula auditing tools, and named ranges.

Data: Tools for sorting, filtering, data validation, and external data connections (importing data).

Review: Spell check, comments, and protection-related options.

View: Options to change workbook views, freeze panes, and zoom.

​

��2. Groups (Sub-sections within Tabs):��

Each tab is divided into Groups that categorize related commands. For example:

Home Tab:

• Clipboard: Cut, copy, paste.
• Font: Font type, size, bold, italics, underline, color.
• Alignment: Horizontal and vertical alignment, merge cells.
• Number: Number formatting (currency, percentage, etc.).

Insert Tab:

• Tables: Insert tables or pivot tables.
• Charts: Insert various chart types (bar, line, pie).

​

�3. Commands (Specific Actions):�

​

• Within each Group, there are individual commands or tools. For example:
• In the Font Group (within the Home tab), you have specific commands like changing the font type, adjusting font size, bolding text, etc.
• In the Formulas Tab, you have commands like Insert Function, AutoSum, Financial Functions, etc.

​

�4. Quick Access Toolbar:�

• Located above the ribbon, it provides quick access to frequently used commands, such as Save, Undo, and Redo. You can customize it by adding more commands based on personal preference.

​

5. File Tab (Backstage View):�

• The File tab (on the far left) takes you to the Backstage View, where you can manage files (open, save, print, share, export, etc.), adjust settings, and access options like Excel Options.

​

Any Questions

Visit my blogger page to reach out

Open Google in your mobile browser

In the search page start type as

asksreenivas

​