Monthly Archives: September 2021

Microsoft Excel – keyboard shortcut for scrolling from worksheet tab to worksheet tab

I was training Excel via Zoom yesterday and for some reason, because of her screen setup, one participant could not see the worksheet tabs on her screen. Nor could she right-click towards the button left to find the Activate dialog … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – Geography

If you are using Excel 365 on the Data tab, in the Data Types group, you will find one called Geography. You may have wondered what it is for. If you have names of cities, etc and want to know … Continue reading

Posted in Excel 365, Microsoft Excel | Tagged , | Leave a comment

Microsoft Excel – using conditional formatting to compare figures across two different worksheets

If you have two worksheets with similar data, you may want to use conditional formatting to show whether the information in one sheet is higher than the corresponding data in the second sheet, for example you may have Sales figures … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged | Leave a comment

Microsoft Excel – why doesn’t Insert Timeline work with my pivot table?

A useful tool if you have created an Excel pivot table is the Timeline which allows you to filter your pivot table to see figures for a specific time frame. Creating a timeline involves having at least one date field … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Word 365 – where has my spellcheck button gone?

In previous versions of Microsoft Word, the Spellcheck button used to be on the Review tab and I would often encourage people to add it to their Quick Access Toolbar so they could find it more easily. Spellcheck has now … Continue reading

Posted in Uncategorized, Word 365 | Tagged | Leave a comment