MS Excel Advance

 

MS Excel

Microsoft Excel is a spreadsheet developed by Microsoft for Windows. Microsoft Excel is a spreadsheet program. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions. Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation. 

what is it?
Think of Excel as a super-smart digital notebook made of tables. It’s not for writing long stories, but for organizing information that has numbers, lists, and calculations.

  • For example: Your monthly expenses, class attendance sheet, cricket team scores, or even a list of your friends' birthdays.

Let's understand the 3 main parts:

  • The Workbook: This whole file is like a book. (Point to the screen)

  • The Worksheet (Sheet): Inside this book, each page is called a 'Sheet'. You see these tabs at the bottom? You can have many pages for different things.

  • The Cell: Each little box you see is called a 'Cell'. It’s the basic building block, like a single square in a chess board. This is where you type any information—text, numbers, or dates.

Excel has three big superpowers:

  • Superpower 1: Organization. It keeps your lists and data neat, sortable, and filterable. You can find anything in seconds.

  • Superpower 2: Calculation (The Real Magic!). Excel can do math for you—instantly! If you change one number, it updates all the related totals automatically. No more calculator needed!

  • Superpower 3: Visualization. It can turn boring numbers into beautiful charts and graphs (like pie charts, bar graphs) so you can see the story behind the data.


ASSIGNMENTS FOR STUDENTS - MICROSOFT EXCEL TASKS

ASSIGNMENTS FOR STUDENTS

MS EXCEL TASKS

 

Excel User Interface

Basic Sheets

Basic Arithmetical Sheets

 

Formatting Sheets

Date Sheets

Marksheets

 

Chart Sheet

Orientation Text Rotation Sheets

Conditional Formatting Sheets

 

Advance Function Sheets

Flash Fill Command Sheets

Concatenate Sheets

 

Balance Sheets

Electric Bill Sheets

Filter Command

 

 

 

Time Sheets

Pivot Table Data

Goal Seek

 

 

 

Trace Precedent-Dependent Sheets

Define Name Manager

Data Validation Command

 

Payroll Commands

VLOOKUP

Macro Command Excel

 

Layout All Sheets

Data Cleaning & CSV Files

Final Excel Sheets


                                                       

 




Excel Drive Folders Arrangement



MS EXCEL LOCAL & GLOBAL CERTIFICATIONS

MS EXCEL ADVANCE YOUTUBE PLAYLIST



MS EXCEL BASIC YOUTUBE PLAYLIST