#MS OFFICE EXCEL 2007 TUTORIAL HOW TO#
#MS OFFICE EXCEL 2007 TUTORIAL SOFTWARE#

In Excel 3 sheets are already opened by default, now to add a new sheet :

View: It contains the commands to manage the view of the workbook, show/hide ruler, gridlines, etc, freezing panes, and adding macros.

Review: This tab provides the facility of thesaurus, checking spellings, translating the text, and helps to protect and share the worksheet and workbook.

It also helps to access data(s) from different sources as well, such as from Ms-Access, from web, etc.

Data: The Data Tab helps to perform different operations on a vast set of data like analysis through what-if analysis tools and many other data analysis tools, removing duplicate data, transpose the row and column, etc.

Formulas: It is a package of different in-built formulas/functions which can be used by user just by selecting the cell or range of cells for values.

The worksheet appearance will be the same in the hard copy as well.

Page layout: It provides all the facilities related to the spreadsheet-like margins, orientation, height, width, background etc.

Insert Tab: It provides the facilities like inserting tables, pivot tables, images, clip art, charts, links, etc.

Home Tab: It provides the basic facilities like changing the font, size of text, editing the cells in the spreadsheet, autosum, etc.

The Ribbon in MS-Excel is the topmost row of tabs that provide the user with different facilities/functionalities. There are three types of cell references in Excel:

Referencing the cell of other programs is known as Remote referencing.

Referencing the cell of other worksheets is known as External referencing.

We can reference the cell of other worksheets and also of other programs.

#MS OFFICE EXCEL 2007 TUTORIAL SOFTWARE#

It helps the software to identify the cell from where the data/value is to be used in the formula. this is also known as a cell reference.Ĭell references: The address or name of a cell or a range of cells is known as Cell reference. Each cell has an address defined by column name and row number example A1, D2, etc. It consists of 1048576 rows and 16383 columns, a row and column together make a cell. It is an electronic spreadsheet with numerous rows and columns, used for organizing data, graphically represent data(s), and performing different calculations. MS-EXCEL is a part of Microsoft Office suite software.

#MS OFFICE EXCEL 2007 TUTORIAL HOW TO#

How to Apply Conditional Formatting Based On VLookup in Excel?.How to Find the Slope of a Line on an Excel Graph?.Stacked Column Chart with Stacked Trendlines in Excel.COUNTIF Function in Excel with Examples.How to calculate Sum and Average of numbers using formulas in MS Excel?.How to Calculate Root Mean Square Error in Excel?.How to Calculate Euclidean Distance in Excel?.How to Calculate Mean Absolute Percentage Error in Excel?.How to Convert Data from Wide to Long Format in Excel?.How to Format Chart Axis to Percentage in Excel?.Statistical Functions in Excel With Examples.How to Calculate the Interquartile Range in Excel?.How to Create Pie of Pie Chart in Excel?.How to Calculate Weighted Average in Excel?.How to Enable and Disable Macros in Excel?.Positive and Negative Trend Arrows in Excel.How to Remove Pivot Table But Keep Data in Excel?.Plot Multiple Data Sets on the Same Chart in Excel.How to Automatically Insert Date and Timestamp in Excel?.How to Find Duplicate Values in Excel Using VLOOKUP?.How to Show Percentage in Pie Chart in Excel?.How to Find Correlation Coefficient in Excel?.Highlight Rows Based on a Cell Value in Excel.

How to Remove Time from Date/Timestamp in Excel?.

ISRO CS Syllabus for Scientist/Engineer Exam.

ISRO CS Original Papers and Official Keys.

GATE CS Original Papers and Official Keys.

Ms office excel 2007 tutorial