MS Excel Basics
Editing Worksheet
Formatting Cells
Formatting Worksheets
Working with Formula
Advanced Operations
MS Excel Resources
Selected Reading
- Excel - Context Help
- Excel - Open Workbook
- Excel - Close Workbook
- Excel - Delete Worksheet
- Excel - Hiding Worksheet
- Excel - Copy Worksheet
- Excel - Create Worksheet
- Excel - Save Workbook
- Excel - Move Around
- Excel - Entering Values
- Excel - Backstage
- Excel - Explore Window
- Excel - Getting Started
- Excel - Home
Editing Worksheet
- Excel - Undo Changes
- Excel - Add Text Box
- Excel - Insert Comments
- Excel - Special Symbols
- Excel - Zoom In-Out
- Excel - Spell Check
- Excel - Find & Replace
- Excel - Copy & Paste
- Excel - Rows & Columns
- Excel - Move Data
- Excel - Delete Data
- Excel - Select Data
- Excel - Insert Data
Formatting Cells
- Excel - Apply Formatting
- Excel - Borders and Shades
- Excel - Merge & Wrap
- Excel - Text Alignments
- Excel - Setting Colors
- Excel - Rotate Cells
- Excel - Text Decoration
- Excel - Setting Fonts
- Excel - Setting Cell Type
Formatting Worksheets
- Excel - Conditional Format
- Excel - Freeze Panes
- Excel - Set Background
- Excel - Insert Page Breaks
- Excel - Header and Footer
- Excel - Page Orientation
- Excel - Adjust Margins
- Excel - Sheet Options
Working with Formula
- Excel - Builtin Functions
- Excel - Using Functions
- Excel - Formula Reference
- Excel - Copying Formulas
- Excel - Creating Formulas
Advanced Operations
- Excel - Keyboard Shortcuts
- Excel - Pivot Charts
- Excel - Simple Charts
- Excel - Pivot Tables
- Excel - Data Tables
- Excel - Workbook Security
- Excel- Translate Worksheet
- Excel - Email Workbooks
- Excel - Printing Worksheets
- Excel - Cross Referencing
- Excel - Adding Graphics
- Excel - Using Macros
- Excel - Using Templates
- Excel - Using Themes
- Excel - Using Styles
- Excel - Data Validation
- Excel - Using Ranges
- Excel - Data Sorting
- Excel - Data Filtering
MS Excel Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Excel - Insert Data
Insert Data in Excel 2010
In MS Excel, there are 1048576*16384 cells. MS Excel cell can have Text, Numeric value or formulas. An MS Excel cell can have maximum of 32000 characters.
Inserting Data
For inserting data in MS Excel, just activate the cell type text or number and press enter or Navigation keys.
Inserting Formula
For inserting formula in MS Excel go to the formula bar, enter the formula and then press enter or navigation key. See the screen-shot below to understand it.
Modifying Cell Content
For modifying the cell content just activate the cell, enter a new value and then press enter or navigation key to see the changes. See the screen-shot below to understand it.
Advertisements