Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2007

Mon 6 Feb 2012, 16:44 Delegate Terry said...

Terry has attended:
Excel Advanced course
Excel Advanced course

Excel

Data tables - how do i use them ?
Waterfall graphs how do i create them ?
How do I round to .49 and .99 endings always rounding up - what is the formula to use.

Tue 7 Feb 2012, 10:24 Trainer Anthony said...

RE: Excel

Hi Terry, thanks for your queries. Here are some walkthroughs for you:

http://www.ozgrid.com/Excel/data-tables.htm

http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/

http://www.ozgrid.com/Excel/excel-rounding.htm

Hope this helps,

Anthony

Mon 13 Feb 2012: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Activating the formula bar with the keyboard in Excel 2010

The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell.

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Activating the formula bar with the keyboard in Excel 2010