Filtering data in Excel
As your spreadsheets grow, it is important to master skills to make your data manageable. Filtering data is a quick…
productivity through technology
As your spreadsheets grow, it is important to master skills to make your data manageable. Filtering data is a quick…
You may want the column headings (A, B, C, etc) and the row headings (1, 2, 3, etc) to be…
Please do not use this feature! It is not part of the syllabus and will only result in your becoming…
This is especially handy if you are looking to create a list of unique values (or records) to import into…
Headers and footers can be created for the printing of your Excel worksheets in a similar fashion to those available…
We are probably most comfortable seeing data in a structure such as a table; tabulated data is easy to follow…
Excel’s COUNTBLANK function counts the number of cells in a given range that are blank. The cells must be completely…
In the tutorial on Excel’s Auto Fill Feature, we looked at copying a formula down in a spreadsheet. By default,…
Excel’s COUNT() function counts the number of cells in a given range that contain values. The values could be numbers,…
The post lists all the Microsoft Excel functions that you will learn in your 3-year IGCSE journey followed by your…