- 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
Using Templates in Excel 2010
Using Templates in MS Excel
Template is essentially a model that serves as the basis for something. An Excel template is a workbook that’s used to create other workbooks.
Viewing Available Templates
To view the Excel templates, choose File » New to display the available templates screen in Backstage View. You can select a template stored on your hard drive, or a template from Microsoft Office Onpne. If you choose a template from Microsoft Office Onpne, you must be connected to the Internet to download it. The Office Onpne Templates section contains a number of icons, which represents various categories of templates. Cpck an icon, and you’ll see the available templates. When you select a template thumbnail, you can see a preview in the right panel.
On-pne Templates
These template data is available onpne at the Microsoft server. When you select the template and cpck on it, it will download the template data from Microsoft server and opens it as shown below.
Advertisements