Welcome
To
Concept Computer Education
Online & Offline Computer Courses
1. DCA / ADCA Course
2. Advanced Excel Course
3. Programming Course (Coding)

Call / WhatsApp : 9650597419 (Vinay Sir)

Download The App Now: Vinaytips

Computer PDF Notes in Hindi & English






1. Basic Computer PDF Notes Buy Now
2. CCC PDF Notes Buy Now
3. DCA PDF Notes Buy Now
4. ADCA PDF Notes Buy Now
5. MS Word PDF Notes Buy Now
6. MS Excel PDF Notes Buy Now
7. Advanced Excel PDF Notes Buy Now
8. Power Point PDF Notes Buy Now
9. Internet PDF Notes Buy Now
10. Tally Prime PDF Notes Buy Now
11. HTML PDF Notes Buy Now
12. CSS PDF Notes Buy Now
13. Java Script PDF Notes Buy Now
14. C Language PDF Notes Buy Now
15. C++ PDF Notes Buy Now
16. Hardware PDF Notes Buy Now
17. Repairing PDF Notes Buy Now

MS Excel Tutorial

MS Excel Tutorial


MS Excel Tutorial Provides basic and advance concept of Excel. Our MS Excel tutorial is designed for beginners and professionals by keeping their requirements in mind.

Microsoft Excel is a computer application program written by microsoft. It mainly comprises Tabs, Group of Commands and worksheets. It stores the data in tabular form and allows the users to perform manipulation operations on them.

Our MS Excel tutorial will cover all topics from basic to advance. Such as Introduction of MS Excel, worksheets, ribbon and tabs, function, formula, conditional formatting, data validation and more. Along with it, we will also show you the steps to download and activate MS Excel.

What is Microsoft Excel?

Microsoft Excel is an office use application designed by microsoft. It comes with Office suite with several other Microsoft Application such as Word, Power Point, Access, Outlook and One note etc. It is supported in Windows as well as Mac Operating System too.

Microsoft Excel is one of the must suitable spreadsheet programs that help us to store and represent the data in tabular form, manage and manipulate data, create optically logical charts and more. Excel provides you the worksheet to create a new document in it. You can save the excel file with .xls extension.  

Note: we are using Excel 2010 for this excel tutorial.

Worksheet

A worksheet is made of rows and columns that intersect each other to form cells where data is entered. It is capable of performing multiple tasks like calculations, data analysis and integrating data.

In excel worksheet, rows are represented by numbers and columns by alphabets.

A single excel workbook can consist of several sheets named sheet1, sheet2,  sheet3,........sheetN. You can add one or more sheets to your excel worksheet.

MS Excel Features

There are several features that are available in excel to make our task more manageable. Some of the main features are:


1. Auto sum: Auto sum feature helps us to calculate the sum of row or column automatically by inserting an addition formula for a range of cells.

2. List Auto Fill: It automatically develops cell formatting when a new component is added to the end of a list.

3. Auto Fill: The feature allows us to quickly fill cells with a repetitive or sequential record such as dates or numbers and repeated list. Auto fit can also be used to copy functions. We can also alter text and numbers with this features.

4. Auto Shapes: Auto shapes toolbar will allow us to draw some geometrical shapes, arrows, flowchart items, stars and more. With these shapes, we can draw our graphs.

5. Wizard:  It guides us to work effectively while we work by displaying several helpful tips and techniques based on what we are doing. Drag and drop feature will help us to reposition the record and text by simply dragging the data with the help of the mouse.

6. Charts: This feature will help you to present the data in graphical form by using Pie, Bar, Lines, Charts and more.

7. Pivot Table: It flips and sums data in seconds and allows us to execute data analysis and generating documents like periodic financial statements, statistical documents etc. We can also analyze complex data relationships graphically.

8. Shortcut Menus: The shortcut menu helps users to make the work done through shortcut commands that need a lengthy process.

How to Open Micro Soft Excel?

1. Click on the start button and search for the MS Excel. If it is already installed in your system. It will appear here like this. 


Double Tap on this icon to open the excel.
When the excel opens, an interface will appear like this. From here, you can create a new workbook.

2. Press Window + R and type "excel" then press "enter" button. 




MS Excel Interface




Menu Bar

Menu Bar is also known as Tab Bar. It also has many menus like: Home, Insert, Page Layout, Formulas, View and Review etc.

Title Bar

Title Bar is at the top of the Menu Bar, indicating the file name. You have saved this document by what name it shows it only. Book1 – Microsoft Excel will be written before saving and its name will be changed after saving.

Ribbon Menu

When we click on any of the menus like: Home, Insert, Page Layout etc. Then again a menu opens in front of us which are called Ribbon Menu.

Minimize, Maximize & Close Button

These three buttons are used to change the state of MS Excel’s open current windows.

Understand the meaning of all three.

               i.          With this you can minimize your Windows Screen.

              ii.          With this you can maximize your Windows Screen.

             iii.          With this you can close MS Excel.

Help Option

Through this, we can take any kind of help related to Microsoft Excel. For this, we have to click this Help Button Pore, After that we have to search our problem.

Work area or Worksheet

When we open Microsoft Excel, a worksheet with Spreadsheet opens in front of us in which all the work is done. It is organized in all cells.

Sheet Tab

Through this, we can open as many worksheets inside Excel as we want, but in excel only By Default three sheets are given Sheet 1, Sheet 2, Sheet 3. To open this more worksheet, Press F11 with shift in the keyboard and open as many worksheets as you want.

You can also open a new by clicking on this option.

Customize Sheet Tab

Insert, Delete, Rename, Move or copy, View Code, Protect Sheet, Tab Color, Hide, Unhide, Select all sheet.

When we go to any sheet and press the right button of the mouse, we see many options like: Insert, Delete, Rename, Move or Copy, View Code, Protect Sheet, tab Color, Hide, Unhide, Select all sheet.

After clicking on the option with insert, there is a windows open which has two options General and Spreadsheet Solution. Through this option, you can work on an option like Worksheet, Chart, Sales Report, Time Card, Billing Statement etc. By inserting in excel.

Delete

Through this, you can delete any particular sheet.

Rename

Through this, you can edit any particular sheet. i.e. its name.

Move or Copy

Through this, you can copy or move your sheets from one place to another.

View Code

Through this, you can view the code.

Protect sheet

Through this, you can protect any sheet with a password.

Tab Color

Through this, you can change the color of Sheets Tab.

Hide

Through this, you can hide any sheets.

Unhide

Through this, you can unhide the hidden sheets.

Select all sheet

By clicking on it, all your sheets in Excel will be selected. To Un-select it again go to one of the sheets and press the right button of the mouse and ungroup it.

Quick Access Toolbar

This is a tool using which we can open any option or tool quickly, that is, if I use a lot of shape, I will add it to the Quick Access Toolbar so that option is always visible on our screen. We will keep giving it and we will open it directly.

Work Area

The distance we work within Excel is the called the Work Area

Cells & Cell name

There are a lot of cell in Excel in which in we solve arithmetic questions.but the cell name is the one which shows that the name of the cell in which we are presently is shown to us.

Formula Bar

Whatever from of cell we use inside Excel ,those formula is shown in the “Formula Bar”

Horizontal & Vertical Scroll Bar

Vertical and horizontal use Scorll Bar for scrolling the page .If the number of row and columns increases more, then we can back and forth throught it.

Page View

It has three options that change the page Layout. You can try alternatelby click on the three options.

Post a Comment

0 Comments

Advance Excel Training By: Vinay Sir (M. 99650597419)

1. vinaytips.com क्या है? जरूर जाने इसके बारे में।
2. कंप्यूटर या लैपटॉप में बिना नाम का folder कैसे बनाते है ?
3. कंप्यूटर या लैपटॉप में बिना दिखाई देने वाला फोल्डर कैसे बनाये?
4. कंप्यूटर में फोल्डर का आइकॉन कैसे बदले ?
5. कंप्यूटर में CON नाम का फोल्डर कैसे बनाते है ?
6. किसी भी फोल्डर में पासवर्ड कैसे लगाते है?
7. कंप्यूटर में Taskbar को कैसे छुपाये?
8. किसी भी फोल्डर पर अपना फोटो कैसे लगाये ?
9. Desktop icon क्या है पूरी जानकारी हिंदी में।
10. कंप्यूटर या लैपटॉप में Screenshot कैसे लेते है?
11. Keyboard क्या है ? कितने प्रकार के होते है ? पूरी जानकारी हिंदी में।
12. keyboard में कितने प्रकार की keys होती है ? पूरी जानकारी हिंदी में।
13. Mouse क्या है? Mouse की पूरी जानकारी हिंदी में।
14. Monitor क्या है ? Monitor कितने प्रकार के होते है? पूरी जानकारी हिंदी में।
15. कंप्यूटर या लैपटॉप में Screenshot कैसे लेते है?
16. Speaker क्या है ? पूरी जानकारी हिंदी में।
17. कंप्यूटर कीबोर्ड के सभी Symbols का नाम हिंदी में।
18. Printer क्या है ? Printer कितने प्रकार के होते है? पूरी जानकारी हिंदी में।
19. Scanner क्या है ? Scanner कितने प्रकार के होते है ? पूरी जानकारी हिंदी में।
20. Motherboard क्या है ? Motherboard कितने प्रकार के होते है ? पूरी जानकारी हिंदी में।
21. RAM क्या है RAM की पूरी जानकारी हिंदी में।
22. ROM क्या है ? ROM कितने प्रकार के होते है ? पूरी जानकारी हिंदी में।
23. Processor क्या है ? Processor कितने प्रकार के होते है ? पूरी जानकारी हिंदी में।
24. Hard Disk क्या है ? Hard Disk कितने प्रकार के होते है ? पूरी जानकारी हिंदी में।
25. BIOS और CMOS क्या है ? पूरी जानकारी हिंदी में।
26. USB क्या है और USB कितने प्रकार के होते है? पूरी जानकारी हिंदी में।
27. SMPS क्या है? SMPS कितने प्रकार के होते है? पूरी जानकारी हिंदी में।
28. VGA Port और VGA Cable क्या होते हैं? पूरी जानकारी हिंदी में।
29. Software क्या है? Software कितने प्रकार के होते हैं? पूरी जानकारी हिंदी में।
30. Cloud Computing क्या है? Cloud Computing की पूरी जानकारी हिंदी में।
31. Credit Card क्या होता है? पूरी जानकारी हिंदी में।
32. मेमोरी कार्ड क्या होता है और कैसे काम करता है? पूरी जानकारी हिंदी में।
33. पेन ड्राइव क्या है? और कैसे काम करता है? पूरी जानकारी हिंदी में।
34. Email क्या है? और E - mail का इतिहास । पूरी जानकारी हिंदी में।
35. Cyber Security क्या है? ये कितने प्रकार के होते हैं? पूरी जानकारी हिंदी में।
1. Basic Computer Notes
2. 100+ Computer Related Full Form
3. Memory Units
4. Keyboard Symbols Name
5. Computer Shortcut Keys
6. MS Word Notes
7. MS Word Shortcut Keys
8. MS Excel Notes
9. MS Excel Shortcut Keys
10. MS Power Point Notes
11. MS PowerPoint Shortcut Keys
12. Common Shortcut Keys Used in MS Office
13. 100+ Computer Fundamental Objective Question & Answer