Skip to main content

Learn MS Excel Practically

Learning Microsoft Excel Practically, Tutorials with Pictures and Original Microsoft Excel Worksheets With Excel Formulas and Functions
Learn Microsoft Excel Practically by creating Worksheets
Learning Microsoft Excel Practically, Tutorials with Pictures and Original Microsoft Excel Worksheets With Excel Formulas and Functions
Learning Microsoft Excel Practically, Tutorials with Pictures and Original Microsoft Excel Worksheets With Excel Formulas and Functions


Microsoft Excel Formulas and Functions Fast and Easy Way -1

Using Simple Formulas in Excel With Arithmetic Operators 2

How Functions are Used in Excel Fast and Easy Way 3

Create Bar Chart in Excel Easily by Example

Employee Pay sheet Formulas in Microsoft Excel 

Students Test Score Grades Result Sheet in Excel

MS Excel House Building Expense Management Formulas Worksheet

Excel Worksheet With Income Tax Calculation Formula on Employee Pay

Microsoft Excel Formulas To Calculate Your Age in Years Months Days and Day of Birth

Create 3D Line Chart in MS EXCEL for 2 Cricket Teams

 Create Save Password Protect Workbook in Excel

 Use of Text Functions Left Right Mid in Excel

 Use of Max Min Functions in Excel

Use of Average Function With Examples

 Uses of Excel in Business and Commerce

 Use of SUM Function With Examples in MS Excel

 Create PIE Chart in MS Excel




Comments

Post a Comment

Popular posts from this blog

What are Dual Devices or Both Input/ Output Devices

The devices that can be used to perform both functions -input and output- are called Dual Devices. These devices are also called Dual Purpose Devices or Both Input/Output Devices. With the help of a dual purpose device, we can enter data into computer as well as we can output data from the computer to outside world.  For example, Dual devices include:  Touch Screen Monitor, Modem, Network Interface Card, Sound card, Hard disk drive, Floppy disk Drive, Magnetic Tape Drive CD-Writer and DVD-Writer etc. These are also called Input/output devices, because they perform both functions. Touch Screen Monitor Dual Devices or Both Input / Output Devices - Touch screens Touch Screen Monitor is an input/output device. It uses a special touch sensitive screen. The User can enter data by touching icons or menus on the screen. As soon as the user selects a command from menu, output is displayed on screen. Commonly touch screen monitors use sensors to detect touch of finger. ...
1 comment
Read more

Explain Different Types Of Data

DATA Data is the collection of raw facts and figures. It is without any proper meaning. Data may be collection of words, numbers, graphics or sounds. What is data? Explain different types of data Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form     contains raw facts (data of student) like name, father’s name, address of student etc. 2)    Data of Citizens During census, data of all citizens is collected. 3)    Survey Data Different companies collect data by survey to know the opinion of people about their product. 4)    Students Examination data In examination data about obtained marks of different subjects for all students is collected.    Different Types Of Data There are following main types of Data. 1)    NUMERIC DATA Numeric data consists of 0 to 9 digits, + and – sign and dec...
Post a Comment
Read more

Using Simple Formulas in Excel With Arithmetic Operators-2

What are Arithmetic Operators in Excel? Arithmetic Operators are used to perform arithmetic operations like addition, subtraction, multiplication and division etc. There are following arithmetic operators in Microsoft Excel: Using Arithmetic / Mathematical Operators in MS Excel Formulas 1.  + Operator The + arithmetic operator is used to perform addition of numbers. It is used with in formulas along with Cell References normally. For example, to add the number 10 in A1 cell and the number 20 in B1 cell, we can write a formula =A1+B1 in cell C1. After pressing Enter key we will see the answer 30 in the cell C1. Important Points To Write a Simple Formula in Excel Every formula in Microsoft Excel is started with an Equal sign ( = ). Arithmetic operators (+ for addition, - for subtraction, * for multiplication, / for division) are used. Percentage is calculated by % operator. ( =B2*10%       means 10% of the number in cell B2) Pow...
1 comment
Read more