Excel hints and tips
Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training add this page to your favourites/bookmarksBookmark page

view a printable version of this pagePrintable version 		Customer: Sign in
Delegate: Sign in
Trainer: Log in

rssRSS feeds

What's this?

All hints and tips:

RSS feed Add to Google

Only Excel hints and tips:

RSS feed Add to Google

Hints and tips home » Excel hints and tips

Excel hints and tips

TitleDate
Charts2008 Mar 31
Copying Formulae Quickly2007 Dec 17
Closing Multiple Workbooks quickly2007 Oct 11
Missing Field handle2007 Oct 10
Separate the year from a date2007 Mar 12
Formula for last day of month2007 Mar 12
Select Single Data Marker2007 Mar 7
Using Alt in Save Dialog Box2007 Mar 7
New Normal Worksheet2007 Mar 7
Sorting List Subtotals2007 Mar 4
Manually rotating a 3D chart2007 Mar 4
Shared Conditional Formatting2007 Mar 4
No Zeros2007 Jan 26
Remove unused toolbar buttons2006 Dec 19
Reset Excel toolbars to default settings2006 Dec 19
Printing spreadsheets without opening them first2006 Dec 19
Find cells that match a format2006 Dec 1
Recently used file list2006 Dec 1
Deleting a range of cells using the autofill handle2006 Nov 28
Quickly select a block of data2006 Nov 28
Selecting blank cells within a range of data2006 Nov 28
Selecting constant values only2006 Nov 28
Copying the same value, label or formula quickly into a range of selected cells.2006 Nov 28
Change the default location for opening and saving spreadsheets2006 Nov 26
Shortcuts for working with named ranges in Excel2006 Nov 26
Hiding a worksheet in Excel2006 Nov 26
Shortcut for accessing recently opened files2006 Nov 26
Moving between split pane sections in a spreadsheet2006 Nov 26
Shortcut keys to move between sheets2006 Nov 26
Use RANDBETWEEN to generate random numbers2006 Nov 26
Using Excel's MODE function2006 Nov 26
LARGE and SMALL functions and their uses2006 Nov 26
Turn off AutoComplete in Excel2006 Nov 26
Use the Format Painter to copy formatting more than once in Excel2006 Nov 25
Checking formulas with multiple operators2006 Nov 24
Changing Excel file and worksheet defaults2006 Nov 24
Use Paint Brush to Format More than one Cell2006 Nov 24
Stop Formula Returning A "#DIV/0" Error2006 Nov 24
Make macros work in newer versions of Excel2006 Nov 24
Use the SUBTOTAL function in Excel2006 Nov 24
Repeating headings on spreadsheets that print on more than one page2006 Nov 24
Shortcut for deleting all comments in a spreadsheet2006 Nov 24
Change the Print button so it brings up the Print dialogue box2006 Nov 24
##### displaying in Excel2006 Nov 24
Sorting data stored in rows2006 Nov 24
Select blank cells automatically2006 Nov 23
Quickly Adding New Worksheets2006 Nov 23
Create a unique items table from a duplicating table2006 Nov 23
Converting an American date format to European using Formula2006 Nov 23
Change Excel's default font2006 Nov 23
Convert Text into Number2006 Nov 23
Concatenating Results of Formulas2006 Nov 23
Creating a range of monthly payments as text2006 Nov 23
Apply currency format quickly in Excel2006 Nov 23
Select only cell that contain text to lock format2006 Nov 21
Conditional formatting for cells that return text , not picked up by Go to command2006 Nov 21
Reconciling a list to correspond with another2006 Nov 21
Quickly create a list of numbers2006 Nov 14
Counting Non Number Cells (Text)2006 Oct 31
Counting Blanks2006 Oct 31
Viewing Many Worksheets2006 Oct 31
Generating Random Numbers2006 Oct 26
Calculate difference between two times2006 Oct 26
Colouring cells containing formulas2006 Oct 26
Large Icons on toolbar2006 Oct 25
Showing all menu items2006 Oct 25
Sum Up All the Values in A Column2006 Oct 24
Display pictures on Chart Data Point2006 Oct 24
Create Charts with One keystroke2006 Oct 24
Cycling through Absoulte cell references2006 Oct 24
editing a formula quickly2006 Oct 24
Pivot table grouping2006 Oct 23
Creating custom lists2006 Oct 23
Hiding Formulae in the Formula Bar2006 Oct 19
Difference between Two Dates2006 Oct 19
Move data worksheet to worksheet2006 Oct 10
Create a hyperlink navigation sheet2006 Oct 6
Go to source of a cell2006 Oct 6
Outlining - Grouping rows or columns2006 Oct 5
Outlining - ungrouping rows or columns2006 Oct 5
autosum shortcut key2006 Oct 5
removing border lines on the keyboard2006 Oct 5
Hiding and unhiding columns using the keyboard2006 Oct 5
Hiding and unhiding rows using the keyboard2006 Oct 5
Trace Dependents / Precedents without the blue arrows2006 Oct 5
paste functions box quickly2006 Oct 5
Adding cells, Rows & columns2006 Oct 5
Deleting cells, Rows & columns2006 Oct 5
Closing all your workbooks Quickly2006 Oct 5
Highlighting only Text cells2006 Oct 5
Removing custom dictionary entries2006 Oct 5
Paste a web address into the hyperlink address field2006 Oct 4
Adding up rows or columns without seeing formulas2006 Oct 4
Status Bar Functions2006 Oct 4
Get back to active cell2006 Oct 4
Line breaks in a cell2006 Oct 3
Generate randon numbers2006 Oct 3
current date2006 Oct 3
Auto-insert the current time2006 Oct 3
date and time2006 Oct 3
calculate age or service2006 Oct 3
bring up formatting dialog box2006 Oct 3
Transpose text2006 Oct 3
Number format shortcut2006 Oct 3
Currency format2006 Oct 3
Percentage format2006 Oct 3
Adjusting the Elevation and Rotation in a 3-D Chart2006 Oct 3
edit and format multiple worksheets in one operation2006 Oct 3
Finding cells that have data restrictions2006 Oct 3
Using an equal (=) sign that isn't part of a formula2006 Oct 3
Autonumber in Excel2006 Oct 3
DATEDIF function2006 Oct 3
COUNT function vs COUNTA function2006 Oct 2
Random Numbers2006 Oct 2
Bracketed negative numbers2006 Sep 27
Closing Multiple Open Worksheets At Once2006 Sep 27
Display Functions on Worksheets2006 Sep 27
Highlighting a data range2006 Sep 27
Naming and Using Constants2006 Sep 26
Change the Value of a Constant2006 Sep 26
Hide data in Excel Worksheets2006 Sep 26
Checking if a calculation adheres to Order of Precedence2006 Sep 26
Working with 3D formulas2006 Sep 21
3D formulas find and replace2006 Sep 21
Toggle Formulas and Results2006 Sep 21
Editing Formulas in Excel Cells2006 Sep 21
Freeze Rows and Columns to keep lables displayed2006 Sep 21
Formst Excel to display leading zeroes2006 Sep 21
Moving between Worksheets without using the mouse2006 Sep 21
Entering text in Multiple Worksheets2006 Sep 21
Seeing named ranges as part of the zoom2006 Sep 20
Selecting your working range2006 Sep 20
Quick Zooming in Excel with rollerball mouses2006 Sep 20
Adding up time greater than 24 hours2006 Sep 18
Get to the end of the used range2006 Sep 16
View a unique list2006 Sep 16
Adding date and time2006 Sep 16
Quickly insert a function2006 Sep 16
The dual nature of toolbar buttons2006 Sep 16
Quickly hide and unhide rows and columns2006 Sep 16
Do a fast scroll2006 Sep 16
Fill formulae across a sheet2006 Sep 16
Turn Function tooltips on and off2006 Sep 16
Create and delete borders2006 Sep 16
Return to the active cell after scrolling2006 Sep 16
Ctrl+d's double life2006 Sep 16
Use shortcut keys to select rows or columns2006 Sep 16
Using basic functions without doing formulas2006 Sep 14
Creating Quick Column Charts2006 Sep 12
Finding your worksheets quickly2006 Sep 12
Make a quick copy of a worksheet2006 Sep 5
Quickly copy a formula across sheets2006 Sep 5
Generating simple column charts2006 Aug 31
Repeat action2006 Aug 30
Adding a comment to a formula2006 Jun 28
Manually wrapping text2006 Jun 28
Validating text entries2006 Jun 28

Rate this page:
3.0/5 (46 votes cast)
Institute of IT Training - Accredited Training Provider ILM
Microsoft Certified Partner		 Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

 Institute of IT Training - Accredited Training Provider
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams		 Association of Computer Trainers verified by visa, mastercard securecard

© 2010 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions