Excel Basics-Updated Weekly
- Here are two links explaining how to use one-way and two-way data table to do sensitivity analysis:
2. How to create range names for a worksheet to help interpret and use data:
3. How to count in EXCEL–Countif function
4.How to calculate across a large area fast in a worksheet and use absolute reference- example 3
5. VLookup function in EXCEL to search and return values in an excel worksheet:
6. can I use a formula to automatically display today’s date?
English