My Book “Productivity Boosting Aspects of Microsoft Excel” is now available on Amazon Kindle

Knowing the effective and efficient approach of turning this huge raw data into relevant information to enhance business success in today’s challenging and competitive-environment inform the written of this book “Productivity Boosting Aspects of Microsoft Excel” to Instil Data Intelligence using Microsoft Excel.   The book focused more on how to helps improve your Microsoft Excel skills and[…]

Shares 0

COUNTIF and COUNTIFS

COUNTIF function in Excel is use to counting cells within selected range that met a certain condition. Syntax: COUNTIF(range, criteria) Range: this is the selected cells to count from Criteria: it spelt out the condition to be met doing the counting The following example elaborate more on how COUNTIF works. The formula asked excel to[…]

Shares 0

Useful Excel Keyboard Shortcuts

The table below shows useful Keyboard Shortcuts in Excel. You can download it here S/N Excel Keyboard Shortcut Usefulness 1 F1 Display Excel Help task pane 2 F2 Edit active cell 3 F3 Show paste name dialog box 4 F4 Repeat last action or make absolute cell to absolute 5 F5 Show go to dialog[…]

Shares 0