The more email you send and receive, the larger your Outlook mailbox can grow. Large mailboxes can take longer to open and search, and many email providers, including Microsoft 365, limit the maximum size of your mailbox. If you receive a message that your mailbox is over its size limit, deleting messages and folders can Read More
Category: Microsoft Office
How VLOOKUP Return Zero Instead Of #N/A in Excel?
To return zero instead of #N/A when the VLOOKUP function cannot find the correct relative result, you just need to change the ordinary formula to another one in Excel. Select the cell you want to use VLOOKUP function, and type this formula =IFERROR(VLOOKUP(A13,$A$2:$C$10,3,0),0), drag the autofill handle to the range you need. See screenshot: Tips:(1) In Read More
How to Avoid Outlook Start With a Prompt “Outlook closed while you had items open. Reopen those items from your last session?”
Outlook is finally getting some better start-up and reopening windows options though not perhaps as much as regular users are hoping for. Outlook 365 for Windows is getting an option to reopen windows that were live when the program closed. That means open emails, meetings etc can reappear automatically when Outlook restarts. The option is Read More
Create and add an email signature in Outlook on the web
Office for business Office 365 Small Business Outlook on the web for Exchange Server 2016 Create a signature for your email messages that you can add automatically to all outgoing messages or manually to specific ones. Note: If the instructions don’t match what you see, you might be using an older version of Outlook on the web. Try Read More
Useful Microsoft Excel Keyboard Shortcuts
Even if you’re familiar with Microsoft Excel, you might be surprised by the number and variety of keyboard shortcuts you can use to speed up your work and generally make things more convenient. Now, does anyone expect you to memorize all these keyboard combos? Of course not! Everyone’s needs are different, so some will be Read More
Using IF with AND, OR and NOT functions
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2019 More… The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF(Something is True, then do something, otherwise do something Read More