Saturday, 10 June 2017

BASICS OF MS EXCEL YOU MUST KNOW!

1  Ribbon : The tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review and View. Excel selects the ribbon'... thumbnail 1 summary

Ribbon: The tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review and View. Excel selects the ribbon's Home tab when you open a workbook.
Workbook: A workbook is another word for your Excel file. When you start Excel, click Blank workbook to create an Excel workbook from scratch.
Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.
Format Cells: When we format cells in Excel, we change the appearance of a number without changing the number itself.
Find & Select: Learn how to use Excel's Find, Replace and Go To Special feature.
Templates: Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used.
Data Validation: Use data validation in Excel to make sure that users enter certain values into a cell.
Keyboard Shortcuts: Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed.
Print: This chapter teaches you how to print a worksheet and how to change some important print settings in Excel.
10 Share: Learn how to share Excel data with Word documents and other files.
11 Protect: Encrypt an Excel file with a password so that it requires a password to open it.

No comments

Post a Comment

Recent Posts