Become Certified MOS 2016 (a YouTube PlayList)

Learn how to become certified Microsoft Office 2016 Specialist of Word, Excel, PowerPoint & Outlook / Expert of Word & Excel / Master from different experts.
.

.
Above video belongs to a PlayList
Collection of MOS 2016 Video Tutorials from experts

Data Validation - Basics

To prevent incorrect data posting in specific cells we use Data Validation. 
if you created a worksheet that will be used by others, you need to ensure that only correct data that matches with requirements is entered. 

For example: between (10 and 20), or only specific text (Mr., Mrs, or Miss), etc.

Following are some basic data validations:

Whole Number:This can be used to restrict whole number data entry as per defined validation only.
For example you can prevent data which is out of a number range. See below animation.

If you understand the above, you can explore following more options to validate the data entery:

* Decimal
* Date
* Time
* Text Length
* List   (multi-choice drop-down list.  Items separated with comma)

Following advanced options and will be posted seperately ...

* Custom

For more detail, write us ...

Cell Styles

A smart way to quickly format a cell or range of cells is Cell Style. A cell style is a defined set of misc. formatting, such as fonts, font sizes, font Colors, number formats, cell borders, cell shading, etc.

Microsoft Office Excel has many predefined cell styles that you can apply. You can modify or duplicate a cell style to create your own, custom cell style as per your requirement or taste.

BENEFITS OF USING CELL STYLES:
* Apply Several formats in one step
* Ensure consistent formatting
* Saves time by just selecting a defined style.

Important: Cell styles are based on the document theme that is applied to the whole workbook. When you switch to another document theme, the cell styles are updated to match the new document theme.

APPLY CELL STYLE 
1. Select a cell or range of cells
2. Click on "Cell Styles" button at Home tab
3. click on a pre-defined cell style




CREATE NEW OWN STYLE
1. Goto Home tab > Styles group > Cell Styles
2. Click "New Cell Styles"
3. Type an appropriate name for the new cell style in Style name box.
4. Click on Format button
5. Format Cells dialogue box appears with many tabs, where from you can select different formats
6. After selection of format(s) click on OK button.
Now u can use/apply this new style.

MODIFY A STYLE
* To modify an existing cell style, right-click that cell style, and then click Modify.
* Cell Style Dialogue Box will appear
* Click on format button and change formatting as required




STYLE DERIVED FROM AN OLD STYLE (DUPLICATE)
* To create a style derived form an existing cell style, right-click that cell style, and then click Duplicate.
* Cell Style Dialogue Box will appear
* Change the style name
* Click on format button and change formatting as required

Note: A duplicate cell style and a renamed cell style are added to the list of custom cell styles. If you do not rename a built-in cell style, the built-in cell style will be updated with any changes that you make.


For more information; write us or check below link
Support.Office.Com

Flash Fill

Flash fill is a new tool introduced in Microsoft Excel 2013, to fill out data based on an example.
 

Excel detect a pattern in your data, fill accordingly remaining data within a flash of time. It works best when your data has some consistency. Flash Fill is available in Data tab and Ctrl+E is a shortkey

Rather than manually entering first, middle, or last names in respective columns (or attempting to copy an entire client name from column A and then editing out the parts not needed in the First Name, Middle Name, and Last Name columns), you can use Flash Fill to quickly and effectively do the job.

For more detail check at office.com by clicking here.