Tag Archives: Microsoft 365

Speed Up Your Work Using Macros in Excel

Posted on March 3, 2023 by garysch

The thing about Excel is you can have the same old tasks to do day after day. Import some data, then format it to look like the data the previous day and the day before that, then create a chart, … Continue reading →

Posted in Excel, Uncategorized | Tagged , , , , , , , | Leave a comment

Creating a Gantt Chart in Excel

Posted on March 20, 2022 by garysch

Of course there is the brilliant program MS Project for project management but perhaps you need to do something a bit quick and not as involved as what you can do with MS Project. Well you could have a go … Continue reading →

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

PowerPoint’s Rehearse with Coach to Help You Present Better

Posted on March 19, 2022 by garysch

I think we all want to know that we keeping our audience engaged when we are doing our PowerPoint presentation. So how many of you rehearse your presentation either in our heads or out loud? Now if you do rehearse … Continue reading →

Posted in PowerPoint | Tagged , , , , , , , | Leave a comment

How to Use AutoFill in Excel without Changing the Formatting

Posted on February 4, 2022 by garysch

One of the many tools in Excel that speeds up how you work is Fill, used to be called AutoFill way back, it is how you can quickly make a series or copy values or formulas by simply clicking and … Continue reading →

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

Excel: Using the MAX() and MIN() Functions

Posted on May 15, 2021 by garysch

Want to find the highest or lowest values in the a range in Excel? Then there are two functions that are easy to use to do that. They are MAX(), for finding the highest, or maximum value, and you guessed … Continue reading →

Posted in Excel, excel function, Excel Functions, Microsoft 365, Microsoft Office | Tagged , , , , , , , , , | Leave a comment

How to Use Consolidate Data in Microsoft Excel

Posted on December 7, 2020 by garysch

If you have data spread out over multiple workbooks or worksheets you might want to have them all in one place on one sheet. Rather than having to copy and paste you can do this using the Excel feature Consolidate … Continue reading →

Posted in Excel, excel data | Tagged , , , , , , , , , | Leave a comment

How to Use Excel Flash-fill

Posted on December 6, 2020 by garysch

Excel has many wonderful features but this is one of my favourites. Its called Flash-fill. It might be easier to watch the video but will try and explain it. If you have a list of data and need to say … Continue reading →

Posted in Excel, excel data | Tagged , , , , , , , , , , , , | Leave a comment

How to Remove Duplicates in an Excel List

Posted on December 5, 2020 by garysch

If you have created lists in Excel you might have thought to check if it has any duplicates. It could be data you’ve imported or data that has been entered. Perhaps you have shared the spreadsheet and you want to … Continue reading →

Posted in Excel, excel data | Tagged , , , , , , , , , , | Leave a comment