Information and Insight from the Excel Spreadsheet and Access Database Experts

How to use the ABS Function in Excel

ABS Function

A lesser know function in Excel is ABS, which is short for absolute. This function simply converts any negative number into a positive one.

To use it we simply type in the function and refernce a cell which contains a number. If the number...

Read more

Excel Developer Tips Summing Filtered Rows

Excel Expert Tips - Summing Filtered Rows

In Excel you can sum a range of rows using the SUM command, however this will sum up all the rows even if they are filtered....

Read more

Date Formatting in Access Databases

Access Database Date Formatting

If you write even simple VBA code, or use forms to set dates to run reports or queries, at some point you will probably have been tripped up by international date formats in Access or Excel, particularly if you are in the...

Read more

Excel Quick Sum of Column

Excel Spreadsheets Quick Sum of Column...

Read more

Excel Header and Ribbon Short Cuts

Excel Spreadsheets Header and Ribbon Short Cuts...

Read more

Excel Copy Cell and Formula Short Cuts

Excel Tip for Copying Cell and Formula Short Cuts...

Read more

Excel Formulae Wizard

Tips from Xlteq Excel Formulae Wizard...

Read more

Toggle Formulas Off and On

Toggle Excel Formulas Off and On

A simple keyboard shortcut to switch the view between displaying cell values and the formulae that are in the cells....

Read more

PowerPoint Presentations Automated

PowerPoint presentations to the board – a help or hindrance to your productivity?

How often do you hear fellow sales managers complain that if they could spend less time putting together management information (MI) they would have more time to generate...

Read more

Editing a dropdown list

How to editing a dropdown list in Excel...

Read more

Viewing two excel spreadsheets side by side

How to view two spreadsheets on one screen...

Read more

Top 10 Keyboard Shortcuts in Excel

Keyboard Shortcuts Make Using Excel So Much Easier

Here are our top 10 shortcuts

Shift + Space: Select entire rowCtrl + Space: Select entire columnCtrl + arrows (up / down / left / right) : move to the end of rows and columnsDouble click on the black cross
Read more

Access Database and Excel Spreadsheet Developers

Call us : 020 3817 6945

Email us :

Find us : Unit 1, Wood Green Farm Buildings, Upper Basildon, Berkshire, RG8 8NA

Made with by BarkWeb Platform: Jolojo