Blog

Information and Insight from the Excel Spreadsheet and Access Database Experts

Using the Select Case Statement

Access Tips from Xlteq

Using the Select Case Statement

Often in VBA code you need to take a value and “do something” conditionally.

The traditional approach is to use an If Then Else or If Then Elseif ElseIf … type of construct, however these quickly...

Read more

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

Access Database and Excel Spreadsheet Developers

Call us : 020 3817 6945

Email us : info@xlteq.com

Find us : Undys Cottage, 39 Charnham Street, Hungerford, RG17 0EJ

Made with by BarkWeb Platform: Jolojo