Microsoft Office Blog by Chris Menard

Tax Brackets Explained using Excel's XLOOKUP function

Tax brackets show you the tax rate you will pay on each portion of your income. There are seven tax brackets. The United States has a progressive tax system based on your Taxable income, not Gross income or Net Income. Your income is taxed at different rates with a progressive tax system.

PowerPoint - Free Stock Videos from Microsoft now in PowerPoint

Microsoft 365 subscribers have access to Premium Creative Content, an in-app library of royalty-free images, icons, cutout people, stickers that are available in Word, PowerPoint, Outlook, and Excel. Now Microsoft has added Stock Videos for PowerPoint. The videos are subtle looping videos.

Email mail merge: personalized emails using Excel - Word & Outlook

Need to send personalized emails to individuals all at one time? That is called an "Email Mail Merge." I'm going to use Excel, Word, and Outlook - part of Microsoft 365 - to create and send bulk emails out. The order these apps are used would be Excel, then Word, and finally, Outlook.

ZOOM : share multiple applications at once

Zoom has released a new update - version 5.4.3 - on November 16, 2020. This includes a feature that allows you to share multiple programs at once! This is a great new feature because now you can share two or more programs at one time. In this article, I will show you how to share both Excel and Word programs at once.

Pre-assign breakout rooms in Zoom

Zoom has an update in release 5.4.0 that allows pre-assigned attendees to join after the Breakout Rooms have been started. Now they can also be automatically assigned to their Breakout Room. In this article on breakout rooms, I'll cover how to enable breakout rooms in settings, the four methods of assigning people to breakout rooms, and do a deep dive into pre-assigning participants to breakout rooms.

ZOOM : Basic vs. Pro Account - 7 Features you are missing

Zoom offers two types of accounts: Free accounts, which Zoom calls Basic accounts, and Paid accounts. I'll show in this article the 7 main features that the Basic account is missing when compared to the Paid account.

Free up space in your Google Account

Your free Google Account gives you 15GB of space. What do you do when you get close to 15GB? You can either buy more space, which is reasonably priced or simply remove files and free up space.

Roles in a Teams Meeting: Organizer - Presenter - Attendee

Teams Meetings have three roles: Organizer, Presenter, and Attendee. You have different capabilities depending on your role. We will cover all the possibilities on the roles and how to change roles.

ZOOM - Join Before Host with Time Limits

Zoom 5.4.0, released on October 26, 2020, now allows hosts to schedule meetings with Join Before Host with time limits. Now you can prevent participants from joining your meeting 2 hours before it starts! The host can allow participants to join 5, 10, or 15 minutes before the scheduled start time. The ability to join at any time is still available. The time limit feature is a great new feature.

Snagit 2021 - Simplify and Magnify - Two New Features

Snagit 2021 came out on October 20, 2020. Two news features are Simplify and Magnify. Simplify works by removing unnecessary details, simplified images focus your audience’s attention on the important parts, and help keep your content current. You can manually or automatically simplify or magnify an image.

Excel DateDif function - difference between two dates

In Excel if you need to calculate the difference between two dates in years, month, or days, the DATEDIF function will handle it. DATEDIF is "Date & Dif".

Zoom Security Enhancements for May 2020

Zoom has an update that has major security changes: Unmute all participants is not available anymore, now consent is required if the host mutes and then unmutes a participant and meeting information can now be accessed when screen-sharing.