Excel 2010 Tutorial Wallpaper
Excel 2010 Tutorial
Excel Tutorial for Beginners - A beginner's tutorial for Microsoft Excel 2010 to
learn basic to advance concepts step by step including open workbooks, format
workbooks, save workbooks, email workbooks, formulas setting, pivot tables,
pivot charts
Excel 2010
Excel Tutorial
Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Mi
Getting Started with Excel 2010
This chapter teaches you how to start an excel 2010 application in simple steps. Assuming you have M
Explore Window in Excel 2010
The following basic window appears when you start the excel application. Let us now understand the v
BackStage View in Excel 2010
The Backstage view has been introduced in Excel 2010 and acts as the central place for man
Entering Values in Excel 2010
Entering values in excel sheet is a child’s play and this chapter shows how to enter values in an ex
Move Around in Excel 2010
Excel provides a number of ways to move around a sheet using the mouse and the keyboard.First of all
Save Workbook in Excel 2010
Saving New SheetOnce you are done with typing in your new excel sheet, it is time to save your sheet
Create Worksheet in Excel 2010
Creating New WorksheetThree new blank sheets always open when you start Microsoft Excel. Below steps
Copy Worksheet in Excel 2010
Copy WorksheetFirst of all, let us create some sample text before we proceed. Open a new excel sheet
Hiding Worksheet in Excel 2010
Hiding WorksheetHere is the step to hide a worksheet.Step − Right Click the Sheet Name&nbs
Delete Worksheet in Excel 2010
Delete WorksheetHere is the step to delete a worksheet.Step − Right Click the Sheet Name&n
Close Workbook in Excel 2010
Close WorkbookHere are the steps to close a workbook.Step 1 − Click the Close Button
Open Workbook in Excel 2010
Let us see how to open workbook from excel in the below mentioned steps.Step 1 − Click the
Context Help in Excel 2010
MS Excel provides context sensitive help on mouse over. To see context sensitive help for a particul
Insert Data in Excel 2010
In MS Excel, there are 1048576*16384 cells. MS Excel cell can have Text, Nu
Select Data in Excel 2010
MS Excel provides various ways of selecting data in the sheet. Let us see those ways.Select wit
Delete Data in Excel 2010
MS Excel provides various ways of deleting data in the sheet. Let us see those ways.Delete with
Move Data in Excel 2010
Let us see how we can Move Data with MS Excel.Step 1 − Select the data you want
Rows and Columns in Excel 2010
Row and Column BasicsMS Excel is in tabular format consisting of rows and columns.Row runs hori
Copy and Paste in Excel 2010
MS Excel provides copy paste option in different ways. The simplest method of copy pa
Find and Replace in Excel 2010
Spell Check in Excel 2010
MS Excel provides a feature of Word Processing program called Spelling check. We can get r
Zoom In/Out in Excel 2010
Zoom SliderBy default, everything on screen is displayed at 100% in MS Excel. You can change the zoo
Special Symbols in Excel 2010
If you want to insert some symbols or special characters that are not found on the keyboard in that
Insert Comments in Excel 2010
Adding Comment to CellAdding comment to cell helps in understanding the purpose of cell, what input
Add Text Box in Excel 2010
Text BoxesText boxes are special graphic objects that combine the text with a rectangular graphic ob
Undo Changes in Excel 2010
Undo ChangesYou can reverse almost every action in Excel by using the Undo command. We can undo chan
Setting Cell Type in Excel 2010
Formatting CellMS Excel Cell can hold different types of data like Numbers, Currency, Dates, etc. Yo
Setting Fonts in Excel 2010
You can assign any of the fonts that is installed for your printer to cells in a worksheet.Setting F
Text Decoration in Excel 2010
You can change the text decoration of the cell to change its look and feel.Text DecorationVarious op
Rotate Cells in Excel 2010
You can rotate the cell by any degree to change the orientation of the cell.Rotating Cell from Home
Setting Colors in Excel 2010
You can change the background color of the cell or text color.Changing Background ColorBy default th
Text Alignments in Excel 2010
If you don’t like the default alignment of the cell, you can make changes in the alignment of the ce
Merge and Wrap in Excel 2010
Merge CellsMS Excel enables you to merge two or more cells. When you merge cells, you don’t combine
Borders and Shades in Excel 2010
Apply BordersMS Excel enables you to apply borders to the cells. For applying border, select the ran
Apply Formatting in Excel 2010
Formatting CellsIn MS Excel, you can apply formatting to the cell or range of cells by Right Cl
Sheet Options in Excel 2010
Sheet OptionsMS Excel provides various sheet options for printing purpose like generally cell gridli
Adjust Margins in Excel 2010
MarginsMargins are the unprinted areas along the sides, top, and bottom of a printed page. All print
Page Orientation in Excel 2010
Page OrientationPage orientation refers to how output is printed on the page. If you change the orie
Header and Footer in Excel 2010
Header and FooterA header is the information that appears at the top of each printed page and a foot
Insert Page Break in Excel 2010
Page BreaksIf you don’t want a row to print on a page by itself or you don’t want a table header row
Insert Page Break in Excel 2010
Page BreaksIf you don’t want a row to print on a page by itself or you don’t want a table header row
Set Background in Excel 2010
Background ImageUnfortunately, you cannot have a background image on your printouts. You may have no
Freeze Panes in Excel 2010
Freezing PanesIf you set up a worksheet with row or column headings, these headings will not be visi
Conditional Format in Excel 2010
Conditional FormattingMS Excel 2010 Conditional Formatting feature enables you to format a range of
Creating Formulas in Excel 2010
Formulas in MS ExcelFormulas are the Bread and butter of worksheet. Without formula, worksheet will
Copying Formulas in Excel 2010
Copying Formulas in MS ExcelCopying formulas is one of the most common tasks that you do in a typica
Formula Reference in Excel 2010
Cell References in FormulasMost formulas you create include references to cells or ranges. These ref
Using Functions in Excel 2010
Functions in FormulaMany formulas you create use available worksheet functions. These functions enab
Built-in Functions in Excel 2010
Built In FunctionsMS Excel has many built in functions, which we can use in our formula. To see all
Data Filtering in Excel 2010
Filters in MS ExcelFiltering data in MS Excel refers to displaying only the rows that meet certain c
Data Sorting in Excel 2010
Sorting in MS ExcelSorting data in MS Excel rearranges the rows based on the contents of a particula
Using Ranges in Excel 2010
Ranges in MS ExcelA cell is a single element in a worksheet that can hold a value, some text, or a f
Data Validation in Excel 2010
Data ValidationMS Excel data validation feature allows you to set up certain rules that dictate what
Using Styles in Excel 2010
Using Styles in MS ExcelWith MS Excel 2010 Named styles make it very easy to apply a set o
Using Themes in Excel 2010
Using Themes in MS ExcelTo help users create more professional-looking documents, MS Excel has incor
Using Templates in Excel 2010
Using Templates in MS ExcelTemplate is essentially a model that serves as the basis for something. A
Using Macros in Excel 2010
Macros in MS ExcelMacros enable you to automate almost any task that you can undertake in Excel 2010
Adding Graphics in Excel 2010
Graphic Objects in MS ExcelMS Excel supports various types of graphic objects like Shapes gallery, S
Cross Referencing in Excel 2010
Graphic Objects in MS ExcelWhen you have information spread across several different spreadsheets, i
Printing Worksheets in Excel 2010
Quick PrintIf you want to print a copy of a worksheet with no layout adjustment, use the
Email Workbooks MS Excel 2010
Email WorkbookMS Excel allows you to email the workbook very easily. To email the workbook to anyone
Translate Worksheet in Excel 2010
Translate WorksheetYou can translate the text written in a different language, such as phrases or pa
Workbook Security in Excel 2010
Workbook SecurityWe can apply security to the workbook by the concept of protection available in the
Data Tables in Excel 2010
Data TablesIn Excel, a Data Table is a way to see different results by altering an input cell in you
Pivot Tables in Excel 2010
Pivot TablesA pivot table is essentially a dynamic summary report generated from a database. The dat
Simple Charts in Excel 2010
ChartsA chart is a visual representation of numeric values. Charts (also known as graphs) have been
Pivot Charts Excel 2010
Pivot ChartsA pivot chart is a graphical representation of a data summary, displayed in a pivot tabl
Pivot Charts Excel 2010
MS Excel Keyboard Short-cutsMS Excel offers many keyboard short-cuts. If you are familiar with windo
iPhone 5 5S resolutions : 640 x 1136
iPhone 6 6S resolutions: 750 x 1334
iPhone 6 6S Plus resolutions: 1080 x 1920
Android Mobiles HD resolutions: : 360 x 640 540 x 960 720 x 1280 1080 x 1920
Widescreen Resolution : 1280x800 Widescreen Resolution : 1280x800 1440x900 1680x1050 1920x1200 1680x1260 1920x1440 2048x1536 Original
HD Resolution : 1280x720 1366x768 1600x900 1920x1080 2560x1440
Mobiles HD resolutions: : 480x640 768 x 1280
Mobiles QHD resolutions : 1440 x 2560
1600x900 1920x1080
Mobile iPhone : 960x640 1136x640 1134x750 2208x1242
Tablet Android/iPad : 1024x768 1280x1280 960x640
IPad 2: 1024x1024
Tablet : 1280x1280
Dual Monitor : 2560x1024
Comments