Excel hints and tips
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Hints and tips home » Excel hints and tips

Excel hints and tips

TitleDate
Navigate with keyboard without losing your active cell21 Nov 2012
Apply Autosum with keyboard shortcut7 Nov 2012
Shortcut fill a cell with contents from adjacent cells6 Nov 2012
Add a € to your cells 16 Oct 2012
Create own ribbon tab - Excel 201015 Oct 2011
Display developer tab - Excel 201015 Oct 2011
Autofit column width – Excel (all versions)15 Oct 2011
Switch on smart tags – Excel 200715 Oct 2011
Move to edge of data block10 Oct 2011
Multiple Lines of Text in a Cell10 Oct 2011
Switching Between Spreadsheets10 Oct 2011
Screen Splitters in Excel10 Oct 2011
Move or Highlight Cells10 Oct 2011
Jumping Across the Excel Screen10 Oct 2011
Jumping Between Sheets in a Book10 Oct 2011
Quick Absolute Cell References10 Oct 2011
Enter formulae into multiple cells10 Oct 2011
Keyboard Shortcuts to Add Rows or Columns10 Oct 2011
Using the Quick Access Toolbar in Excel20106 Oct 2011
How to apply the same formatting and data to multiple sheets at the same time in Excel 201028 Sep 2011
Display Formulas Instead of Results in Excel 201028 Sep 2011
Use the Ctrl-key for quick navigation in Excel 201028 Sep 2011
Creating charts in Excel 201027 Sep 2011
Conditional Formatting in Excel 201027 Sep 2011
Importing Numbers in Excel 201027 Sep 2011
Copying Values Without Formulas in Excel 201027 Sep 2011
Change the Default Width of All Columns in Excel 201027 Sep 2011
Convert a column into row quickly in Excel 201027 Sep 2011
Recovering Unsaved Work in Excel 201027 Sep 2011
Page Break Preview in Excel 201027 Sep 2011
Convert Text to Columns in Excel 201027 Sep 2011
Saving your Excel Spreadsheet as a CSV File27 Sep 2011
Filtering Data in an Excel 2010 Worksheet23 Sep 2011
Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines23 Sep 2011
Moving or Copying Sheets Between Workbooks in Excel 201021 Sep 2011
Adding multiple rows in an Excel 2010 Worksheet16 Sep 2011
Adding Rows or Columns in an Excel 2010 Worksheet16 Sep 2011
Hide columns in an Excel 2010 Worksheet16 Sep 2011
Hide separate columns in Excel 201016 Sep 2011
Some examples of CTRL key shortcuts in Excel 201016 Sep 2011
Removing the Ribbon from view in Excel 201016 Sep 2011
Add Text to Displayed Numbers in Excel 201016 Sep 2011
Paste with Live Preview in Excel 201016 Sep 2011
Create Equations in Excel 201016 Sep 2011
Applying and removing border from cell in Excel 201015 Sep 2011
The Easiest Way to See a Sum or Average in Excel 201015 Sep 2011
Viewing two Excel 2010 Workbooks at the same time15 Sep 2011
Customize the toolbar in Excel 201015 Sep 2011
Activating the formula bar with the keyboard in Excel 201015 Sep 2011
The Easiest and Quickest Way to use Autosum in Excel 201015 Sep 2011
How to select certain data in an Excel 2010 workbook15 Sep 2011
Excel 2010 Shortcuts - Start and End of the Worksheet15 Sep 2011
How to Spell Check an Excel 2010 Worksheet15 Sep 2011
How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet15 Sep 2011
Wrapping Text in a Cell in an Excel 2010 Workbook15 Sep 2011
New to Excel 2010 - Sparklines!15 Sep 2011
Changing the Tab Colour of an Excel 2010 Worksheet15 Sep 2011
Create your own custom list on Excel 2010!15 Sep 2011
Rotating Text in an Excel 2010 Worksheet15 Sep 2011
Charts31 Mar 2008
Copying Formulae Quickly17 Dec 2007
Closing Multiple Workbooks quickly11 Oct 2007
Missing Field handle10 Oct 2007
Separate the year from a date12 Mar 2007
Formula for last day of month12 Mar 2007
Select Single Data Marker7 Mar 2007
Using Alt in Save Dialog Box7 Mar 2007
New Normal Worksheet7 Mar 2007
Sorting List Subtotals4 Mar 2007
Manually rotating a 3D chart4 Mar 2007
Shared Conditional Formatting4 Mar 2007
No Zeros26 Jan 2007
Remove unused toolbar buttons19 Dec 2006
Reset Excel toolbars to default settings19 Dec 2006
Printing spreadsheets without opening them first19 Dec 2006
Find cells that match a format1 Dec 2006
Recently used file list1 Dec 2006
Deleting a range of cells using the autofill handle28 Nov 2006
Quickly select a block of data28 Nov 2006
Selecting blank cells within a range of data28 Nov 2006
Selecting constant values only28 Nov 2006
Copying the same value, label or formula quickly into a range of selected cells.28 Nov 2006
Change the default location for opening and saving spreadsheets26 Nov 2006
Shortcuts for working with named ranges in Excel26 Nov 2006
Hiding a worksheet in Excel26 Nov 2006
Shortcut for accessing recently opened files26 Nov 2006
Moving between split pane sections in a spreadsheet26 Nov 2006
Shortcut keys to move between sheets26 Nov 2006
Use RANDBETWEEN to generate random numbers26 Nov 2006
Using Excel's MODE function26 Nov 2006
LARGE and SMALL functions and their uses26 Nov 2006
Turn off AutoComplete in Excel26 Nov 2006
Use the Format Painter to copy formatting more than once in Excel25 Nov 2006
Checking formulas with multiple operators24 Nov 2006
Changing Excel file and worksheet defaults24 Nov 2006
Use Paint Brush to Format More than one Cell24 Nov 2006
Stop Formula Returning A "#DIV/0" Error24 Nov 2006
Make macros work in newer versions of Excel24 Nov 2006
Use the SUBTOTAL function in Excel24 Nov 2006
Repeating headings on spreadsheets that print on more than one page24 Nov 2006
Shortcut for deleting all comments in a spreadsheet24 Nov 2006
Change the Print button so it brings up the Print dialogue box24 Nov 2006
##### displaying in Excel24 Nov 2006
Sorting data stored in rows24 Nov 2006
Select blank cells automatically23 Nov 2006
Quickly Adding New Worksheets23 Nov 2006
Create a unique items table from a duplicating table23 Nov 2006
Converting an American date format to European using Formula23 Nov 2006
Change Excel's default font23 Nov 2006
Convert Text into Number23 Nov 2006
Concatenating Results of Formulas23 Nov 2006
Creating a range of monthly payments as text23 Nov 2006
Apply currency format quickly in Excel23 Nov 2006
Select only cell that contain text to lock format21 Nov 2006
Conditional formatting for cells that return text , not picked up by Go to command21 Nov 2006
Reconciling a list to correspond with another21 Nov 2006
Quickly create a list of numbers14 Nov 2006
Counting Non Number Cells (Text)31 Oct 2006
Counting Blanks31 Oct 2006
Viewing Many Worksheets31 Oct 2006
Generating Random Numbers26 Oct 2006
Calculate difference between two times26 Oct 2006
Colouring cells containing formulas26 Oct 2006
Large Icons on toolbar25 Oct 2006
Showing all menu items25 Oct 2006
Sum Up All the Values in A Column24 Oct 2006
Display pictures on Chart Data Point24 Oct 2006
Create Charts with One keystroke24 Oct 2006
Cycling through Absoulte cell references24 Oct 2006
editing a formula quickly24 Oct 2006
Pivot table grouping23 Oct 2006
Creating custom lists23 Oct 2006
Hiding Formulae in the Formula Bar19 Oct 2006
Difference between Two Dates19 Oct 2006
Move data worksheet to worksheet10 Oct 2006
Create a hyperlink navigation sheet6 Oct 2006
Go to source of a cell6 Oct 2006
Outlining - Grouping rows or columns5 Oct 2006
Outlining - ungrouping rows or columns5 Oct 2006
autosum shortcut key5 Oct 2006
removing border lines on the keyboard5 Oct 2006
Hiding and unhiding columns using the keyboard5 Oct 2006
Hiding and unhiding rows using the keyboard5 Oct 2006
Trace Dependents / Precedents without the blue arrows5 Oct 2006
paste functions box quickly5 Oct 2006
Adding cells, Rows & columns5 Oct 2006
Deleting cells, Rows & columns5 Oct 2006
Closing all your workbooks Quickly5 Oct 2006
Highlighting only Text cells5 Oct 2006
Removing custom dictionary entries5 Oct 2006
Paste a web address into the hyperlink address field4 Oct 2006
Adding up rows or columns without seeing formulas4 Oct 2006
Status Bar Functions4 Oct 2006
Get back to active cell4 Oct 2006
Line breaks in a cell3 Oct 2006
Generate randon numbers3 Oct 2006
current date3 Oct 2006
Auto-insert the current time3 Oct 2006
date and time3 Oct 2006
calculate age or service3 Oct 2006
bring up formatting dialog box3 Oct 2006
Transpose text3 Oct 2006
Number format shortcut3 Oct 2006
Currency format3 Oct 2006
Percentage format3 Oct 2006
Adjusting the Elevation and Rotation in a 3-D Chart3 Oct 2006
edit and format multiple worksheets in one operation3 Oct 2006
Finding cells that have data restrictions3 Oct 2006
Using an equal (=) sign that isn't part of a formula3 Oct 2006
Autonumber in Excel3 Oct 2006
DATEDIF function3 Oct 2006
COUNT function vs COUNTA function2 Oct 2006
Random Numbers2 Oct 2006
Bracketed negative numbers27 Sep 2006
Closing Multiple Open Worksheets At Once27 Sep 2006
Display Functions on Worksheets27 Sep 2006
Highlighting a data range27 Sep 2006
Naming and Using Constants26 Sep 2006
Change the Value of a Constant26 Sep 2006
Hide data in Excel Worksheets26 Sep 2006
Checking if a calculation adheres to Order of Precedence26 Sep 2006
Working with 3D formulas21 Sep 2006
3D formulas find and replace21 Sep 2006
Toggle Formulas and Results21 Sep 2006
Editing Formulas in Excel Cells21 Sep 2006
Freeze Rows and Columns to keep lables displayed21 Sep 2006
Formst Excel to display leading zeroes21 Sep 2006
Moving between Worksheets without using the mouse21 Sep 2006
Entering text in Multiple Worksheets21 Sep 2006
Seeing named ranges as part of the zoom20 Sep 2006
Selecting your working range20 Sep 2006
Quick Zooming in Excel with rollerball mouses20 Sep 2006
Adding up time greater than 24 hours18 Sep 2006
Get to the end of the used range16 Sep 2006
View a unique list16 Sep 2006
Adding date and time16 Sep 2006
Quickly insert a function16 Sep 2006
The dual nature of toolbar buttons16 Sep 2006
Quickly hide and unhide rows and columns16 Sep 2006
Do a fast scroll16 Sep 2006
Fill formulae across a sheet16 Sep 2006
Turn Function tooltips on and off16 Sep 2006
Create and delete borders16 Sep 2006
Return to the active cell after scrolling16 Sep 2006
Ctrl+d's double life16 Sep 2006
Use shortcut keys to select rows or columns16 Sep 2006
Using basic functions without doing formulas14 Sep 2006
Creating Quick Column Charts12 Sep 2006
Finding your worksheets quickly12 Sep 2006
Make a quick copy of a worksheet5 Sep 2006
Quickly copy a formula across sheets5 Sep 2006
Generating simple column charts31 Aug 2006
Repeat action30 Aug 2006
Adding a comment to a formula28 Jun 2006
Manually wrapping text28 Jun 2006
Validating text entries28 Jun 2006


Management Training courses London
Course rating:
4.6 stars - based on 70 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest