Microsoft Excel
The new Excel IMAGE function enables you to insert images into cells with a formula. This great function allows you to sort, filter, and rearrange images. Excel IMAGE function IMAGE Function syntax =IMAGE(source, [alt_text], [sizing], [height], [width]) IMAGE Function Arguments * [Required] source is the URL path of the
Microsoft Teams
Teams allows you to "Record a video clip" in Chat. This is possible for one-on-one chats and group chats. Teams Video clip in Chat After sending, users can watch the clip directly in the chat. The icon to Record a video clip is right next to the Send
Microsoft Teams
Using Meeting CO-ORGANIZERS in Microsoft Teams Meetings. You can choose co-organizers when you schedule a meeting so that if you can't attend, the co-organizers will be able to end the meeting and perform other actions you as the organizer would do. Make sure you choose at least one
Microsoft Excel
Conditional Formatting in Excel allows you to highlight every 2nd, 3rd, 4th, or 5th row. Writing a formula using the MOD function and ROW function together allows us to do this. **Excel - Highlight every 3rd row** The MOD Function has two required arguments and shows the remainder after dividing
Microsoft Excel
When you share a PivotTable in Excel, even if you delete the data source worksheet, the data source is still attached to the PivotTable.It is called PivotTable cache. It is possible to share PivotTable results without the underlying data. You need to use Paste Special along with Paste Formats.
Microsoft Excel
The GCD Function in Excel finds the Greatest Common Divisor. We will use GCD to show Ratios in Excel. GCD Function in Excel GCD finds the greatest common divisor, which is an integer, and it will divide into the numbers without a remainder. Examples of GCD function 1. The GCD
Microsoft Excel
A liquidity ratio is a type of Financial Ratio that determines if a company can pay its short-term debt and obligations with its current assets. The higher the liquidity ratio, the better. What are Current Assets? Current Assets consist of cash and other assets expected to be converted to cash
Microsoft Excel
The Status Bar in Excel is the area at the bottom of the windows that shows your zoom control in the right corner and Ready in the left corner. **Excel Status Bar** The Status Bar show calculation such as Sum, Average, and Count. The number of worksheets can also be
Microsoft
Microsoft Forms is easy to use for surveys and polls. One of my features is how Forms summarizes responses and shows Pie Charts and Graphs. **Microsoft Forms - share responses** You can always share the Excel file that contains all the responses, but you lose the charts automatically created by
Microsoft Excel
The COUNTIF function in Excel allows you to only count the number of cells that meet certain criterion. For example, the number of cells that the HR department appears in. With COUNTIF, you can do a wildcard search by using \* (asterisk). **COUNTIF with wildcard search and cell reference** The asterisk
Microsoft OneDrive
One of my favorite OneDrive features is sharing a folder with Read Only permissions. This allows me to add files and folders so students or co-workers, or even clients can download the files, but they can't delete or edit the files. I can even set an expiration date
Zoom
When you are presenting in Zoom, it is important to have access to the Meeting Control bar. Frequently, it will disappear, and you have to Stop Presenting to get it back. **Zoom Meeting Control Toolbar** Some users have said they have to exit the meeting and join again. That is