MS OFFICE FUN

Learn MS Office varieties of Tips & Tricks.

Saturday, November 12, 2016

How to convert currency into words

There is no built-in formula in excel, you have to add a vb script and permanently save it with your MS. Excel's installation as Add-In. Below, you will find the code to enter in your Excel sheet:  1. Press Alt+F11 > copy and...
Read more

Wednesday, November 09, 2016

Advanced Filters

Advanced Filters  The tutorial explains the basics of Excel Advanced Filter and how to use step-by-step guide walks you through how to apply filter. ...
Read more

Create Drop Down List in Excel

Create a Drop-Down List by Using Data Validation Microsoft Excel 2016 You can use Data Validation to create a dropdown list of options in a cell. However, the list font can't be changed, nor can the number of visible rows, which...
Read more

Microsoft Excel Pivot Table

Pivot tables are one of Excel's most powerful features. A pivot table is a tool that allows you to explore large sets of data interactively. Once you create a pivot table, you can quickly transform huge numbers of rows and columns...
Read more

Thursday, October 27, 2016

Excel Table Explained

Learn about using data Tables in Microsoft Excel you can create a data table to quickly try out different values for formulas. Excel is great for storing lists of data and you may need to manage that data by sorting it into order. How to...
Read more