Please turn JavaScript on
My Online Training Hub - Upgrade Your Skills In Excel, Word and Outlook icon

My Online Training Hub - Upgrade Your Skills In Excel, Word and Outlook

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.16 / day

Message History

A total can look reasonable even when Excel has ignored several amounts. A report can display the right percentage even after someone has overwritten its formula. And a workbook header can become outdated because somebody typed the sheet name by hand. These 10 unusual Excel functions help you spot problems and handle tasks you might ...


Read full story

If you work a repeating shift pattern, counting working days and days off on a calendar quickly becomes tedious. An Excel shift roster template can map the pattern across an entire year using just four inputs: the year, the first day of the cycle, days on and days off. In this tutorial, you’ll build a ...


Read full story

If an AI-generated spreadsheet contains a mistake, you are still responsible for the report you present. The most dangerous mistakes are often plausible numbers that reach a report or business decision without anyone questioning them. To check AI work in Excel, focus on five areas: PivotTables, Power Query and Excel’s auditing tools can help you ...


Read full story

A few subscriptions you barely use can be easy to overlook. Put them all in one spreadsheet, though, and the annual cost can be a surprise. This Excel subscription audit template brings your subscriptions together, converts monthly and annual fees into a comparable figure, and shows where your money is going. Identify the subscriptions you ...


Read full story

Excel has useful commands tucked away in menus, keyboard shortcuts and the Quick Access Toolbar. Some can save you repeated clicks. Others make it easier to spot differences or check a long list without constantly looking between your screen and a printed page. Each walkthrough explains how to use the feature and the details that ...


Read full story