All about Microsoft Office Word, Excel, PowerPoint and Outlook
Microsoft 365, Office 2021 and earlier versions.
Some basketball fans at Microsoft have released an Excel workbook to play mens and womens ‘fantasy’ college basketball with friends and family. Excel randomly allocates the 64 teams to your players who can see how the tournament progresses through the shared workbook. Even if you’re not interested in ‘college hoops’, you can look around the […]
Excel has five different Pie Charts, here they all are, showing how to use each chart and tricks to make the charts look better. Microsoft has five Excel Pie Charts though one of them is really a donut/doughnut. Find them all at Insert | Charts; 2-D and 3-D Pie charts plus the Doughnut/Donut chart. Part […]
There are several ways for an Excel table to be transposed (rows and columns) but none of the online suggestions work very well with tables. We’ve found a solution which transposes one table into a ‘swapped’ table i.e headers become column A and column A becomes the headers. Along the way we’ll explain a clever […]
Here’s an even better way to make an automatic list of tabs in an Excel workbook it works in Excel for Windows and Mac and bypasses some possible traps. Start with our article on Automatic worksheet/tabs list in Excel which explains how to add a list of Excel tabs/sheets with or without clickable links to […]
Function Fn keys on your keyboard, though neglected, have a special role to play in Microsoft Office. Sometimes they combine with Ctrl, Alt or Shift keys to provide certain functions. Here’s how to use Fn keys when they’re on smaller laptop keyboards or totally missing! Plus how Microsoft Office’s help is no help at all […]
