Excel Array formulas are useful for getting the result from a filtered list quickly with a single, simple formula. Continuing our series on Excel array formulas. Here’s a list of stocks with industries aka Table3. How many stocks are in the ‘Shop’ industry? The array formula in G5 has the answer from the formula: =COUNTIF(Table3[Industry],G4) […]
Array formulas are an important part of Excel and they are a lot more important now that dynamic array formulas are around. Don’t ignore arrays because they’re an unavoidable part of Excel for everyone. This is the start of a series to help you understand arrays in Excel. At the very least, you’ll know what […]
Word can generate a list of all the tables in a document. Like a Table of Contents, this list of tables or Table of tables can include page references or links to each table. A Table of tables can be useful for creating a proper appendix or reference within more formal documentation. It can be […]
Outlook can handle more than one calendar and has three options for easily viewing them, either individually or combined. Calendars can be displayed side-by-side or the more useful Overlay option. There’s also the ‘New Window’ option. Choosing the Outlook calendars to view In Outlook calendar view, use the check boxes in the calendar list to […]
Outlook can link to external, shared, calendars and copy any updates to that calendar using either a .ics tile or a webcal link. An Internet calendar can be for public events, holidays, sporting fixtures etc. They can be a one-time copy of event details or you can setup Outlook to check for updates to […]
