Category: Excel

Using Count Functions In Excel

I was called upon this week to solve a problem using the Excel Count functions. The situation was that the user just didn’t understand the difference between each of the functions available, which I will summarise here. There are 5 Count functions COUNT Counts how many numbers are in the list of arguments COUNTA Counts …

Continue reading

Inserting the Date and Time into a Worksheet

It happens often, current date and/or time is to be added to a worksheet, perhaps while making a time stamped log of activities. Maybe there is a requirements to have the current data or time displayed automatically in a cell every time formulas are recalculated. There are several ways to insert the current date and …

Continue reading

Excel Quick Shortcuts – Formatting

In this article we once again consider some key tips utilising keyboard shortcuts, this time in relation to formatting. There are many possible number formats, all of which can be accessed through the Format cells dialog box. There are however some preformatted options that can readily be accessed using keyboard shortcuts. In many cases these …

Continue reading

Excel Shortcuts

I’m starting a series of articles here about shortcuts in Microsoft Excel. Becoming more productive across all applications is important, and to help you n your way there are a series of keyboard shortcuts that can be used. Firstly I’ll consider moving around a worksheet. Keyboard shortcuts for moving around workbooks This is only a …

Continue reading

New eBooks to Download

With Microsoft Office 2003 support being stopped in just over 2 years a number of individuals and organisations are now looking to update their version of Microsoft Office. There are a substantial number of differences between these versions, not least in the commands, gone are the menus and in come the ribbons, and not forgetting …

Continue reading