Saturday, November 12, 2016
How to convert currency into words
on
Saturday, November 12, 2016
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 moreWednesday, November 09, 2016
Advanced Filters
on
Wednesday, November 09, 2016
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 moreCreate Drop Down List in Excel
on
Wednesday, November 09, 2016
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 moreMicrosoft Excel Pivot Table
on
Wednesday, November 09, 2016
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 moreThursday, October 27, 2016
Excel Table Explained
on
Thursday, October 27, 2016
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
Subscribe to:
Posts
(
Atom
)