General (Microsoft) Articles

Cheat Sheet / Updated 03-25-2022

Master the commands in one Office 2019 program and you are well on your way to mastering the other programs. Following is key information you can take to any Office 2019 program you are working in.

Cheat Sheet / Updated 03-17-2022

Microsoft Office apps are chock full of options and features that are just too tough to squeeze into the pages of a single book. This cheat sheet includes a handful of helpful tips and tricks to give your Office experience a boost, including learning how to create automatic replies to senders, check your documents for accessibility issues, embed fonts in your Word documents and PowerPoint presentations for better portability when sharing, and even check the current weather when perusing your Outlook Calendar.

Cheat Sheet / Updated 03-15-2022

Microsoft Office 2019 comes jam-packed with features. This Cheat Sheet can help you navigate around those features easier by providing keyboard shortcuts and tips for using the mouse, and ribbon to get fast access to the most commonly used commands. You’ll master Office 2019 in no time!

Cheat Sheet / Updated 02-24-2022

Millions of users have realized the value of Office 365. Making the best use of the services that make up Office 365, however, can be a challenge. This guide is a quick reference to the key services, productivity tools, and security features in Office 365 to help you maximize your investment in the technology.

Cheat Sheet / Updated 02-23-2022

Here are some useful Office 365 features worth knowing about. Two of these cheat sheets explain how Office 365 lets you turn one thing into another — how to turn a Word document into a PowerPoint presentation and how to turn an Office 365 file into a PDF so that people who don’t have Office can read it. For people who get mountains of email, here are instructions for moving your Office 365 email messages as they arrive into a specific Outlook folder.

Cheat Sheet / Updated 01-10-2022

If your organization has implemented Microsoft 365 as a productivity suite, be prepared to discover the bells and whistles of a cloud solution that has been adopted by millions of users across the globe. Even if you’re already a superuser of the bundled Office applications like Outlook, Word, Excel, and PowerPoint, you’ll find there are still a lot of features and functionalities within these tools you’ve never heard of before. Before you become overwhelmed trying to figure out all the how-tos, take a step back and consider the following tips. You might just realize the best value of Microsoft 365 is how you can adapt it to your own personality and style.

Cheat Sheet / Updated 01-07-2022

Here are a few shortcuts to help you get your work done faster in Office 2021. Read on to see how to insert one Word 2021 file into another without having to cut and paste, how to enter serial information such as numbers and dates into an Excel 2021 worksheet, and how to make a Word 2021 file the genesis for a PowerPoint 2021 presentation.

Cheat Sheet / Updated 12-07-2021

After you discover keyboard shortcuts in Office, you’ll wonder how you ever functioned without them. Keyboard shortcuts make common tasks faster and easier. By pressing a key combination, you can duplicate many of the most commonly used commands and tasks. Some of the keyboard shortcuts are the same across multiple applications, whereas others are specific to a particular application.

Article / Updated 10-21-2021

Microsoft Teams is available to users who have licenses with following Office 365 corporate subscriptions: E1, E3, E5, Business Premium, and Business Essentials. In the education plans, it is available in the A1, A1 Plus, A5, and A3 subscriptions. Plans are in place to roll out Teams in the government cloud as well. Teams can be accessed from the web browser, a desktop application, or a mobile app. The maximum number of users who can access the full functionality of Teams is based on the number of licensed users in the organization. Guest access is allowed, which means that users from other Office 365 tenants can be invited to an organization’s Teams hub without the need for additional licenses. With Teams, you can conduct one-on-one or group audio and video calls. You can share screens during web conferencing, schedule meetings, and also record those meetings. In addition, each user has up to 1 TB of storage space. From an administrator’s standpoint, Teams offers tools for managing users and third-party applications. There are reports to glean usage and settings that can be configured with policies specific to the organization. For peace of mind, Microsoft offers a 99.9 percent financially backed service-level agreement (SLA) uptime for Teams. Touring the Microsoft Teams user interface Tabs, bots, @mentions, and red bangs are just part of the new lingo you’re going to need to add to your vocabulary to use Teams. That’s assuming you’re already a savvy social media user who knows what emojis, stickers, and giphys are all about. Let’s take a tour of the Teams user interface. When you run the desktop application, the first screen you see after you log in is shown below. App bar: Here you can navigate to the various sections in Teams. From the top, you’ll see the following icons: Activity is where you’ll find mentions, replies, and other notifications. Chat is where you’ll see your recent one-on-one or group chats and your Contacts list. Teams displays all the teams you are a member of. Meetings or Calendar is synched with your Outlook calendar and displays all your upcoming meetings. Files aggregates all the files from all the teams you are a member of. It is also where you access your personal OneDrive for Business storage. Calls allows you to see a history of all incoming and outgoing video and audio calls. You can also call others in your organization, simply by typing their name. […] includes links to apps that are tied to Teams and the channels within Teams. Store takes you to apps and services that can be integrated into Teams. Feedback takes you to the Microsoft Teams user voice page where you can leave feedback about the service. Teams section: In the image above, the Teams icon is selected in the App bar, so the list of one's teams is displayed. Channel: A dedicated section within a team to organize conversations and tasks into specific topics or projects. Join or Create a Team button: Clicking this button takes you through the process of creating or joining a team. This button is only visible when the Teams icon is selected in the App bar. New Chat button: Clicking this button selects the Chat icon in the App bar and allows you to start a new chat with an individual or a group. Command bar: This bar at the top is used to query apps or perform a search in Teams. Tabs: Switch between different Teams pages with these tabs. Conversations and Files are automatically included; the + sign tab allows you to add shortcuts to content in Teams. Channel Conversations: This section displays all the conversations in the selected channel. Chats in Channel Conversations are persistent, so if you’ve been away, it’s easy to scroll through to get caught up when you get back. Chats can include visual indicators such as the @mention, which indicates that the chat specifically mentions a user, or a red bang to indicate high importance. Take note that chats are open by design so everyone in the team has visibility to the conversation to help speed up the decision-making process when needed. Compose box: This is where you can type a message to start a conversation. You can send a quick chat or expand the Compose box to access rich formatting tools. Send icon: When you’re ready to share your chat, click the Send icon to post your chat to the team. Getting help from the Microsoft Teams Command bar Teams is intuitive to use, but you if you need quick assistance, the Command bar is your one-stop destination for help. You can do a search across conversations, users, files, and apps. For example, if you enter the word “launch” in the command bar, the left pane will display the search results grouped by Messages, People, and Files. You can also run a command right from the Command bar by entering a slash ( / ). This action will display the available commands or shortcuts. Select the appropriate command from the list to initiate the command. Collaborating in the Microsoft Teams Hub Many think that the “email tree” phenomenon was isolated to big enterprise environments, but it often rears its ugly head in small organizations, too. Imagine the following scenario: Someone sends an email to three people asking for their input on something. Two of the recipients immediately respond. Recipient #3 replies to Recipient #2 but forgets to reply to all. Now Recipient #2 has information the others don’t have. Recipient #1 then forwards the email to yet another person (Recipient #4) who replies to all with his feedback, which doesn’t account for what’s already been discussed prior to him being involved. Pretty soon, everyone’s mailbox explodes with replies to replies and replies to all so that the sender finally throws her hands up in frustration because now the conversation has gotten out of hand and she's spending too much time getting everyone up to speed. On top of that, she now must consolidate all the feedback manually. Teams makes email trees go away. In Teams, the sender can avoid the previous scenario by uploading the file into the Teams channel, @mention the people she needs feedback from, and start a conversation right from the document in Teams. This way, everyone sees everyone’s comments and edits. A new person joining the conversation can just scroll up to get up to speed and everyone is well-informed and happy. Creating and managing a Microsoft Teams hub To collaborate in Teams, you first need to be either a member of a Teams hub or the creator of one. To create a team: Click Teams from the App bar. Click the Join or Create a Team link that appears at the bottom of the App bar. Click the Create a Team card. Enter the name and description of the team. Choose the privacy settings for your team (Private or Public). A Private team means only team owners can add members, while a Public team means anyone in your organization can join the Team. Click Next. Add members to your team by adding a name, email address, a distribution list, or a mail-enabled security group in the Add box. A team can have a maximum of 2,500 members from either your organization or external users through secure guest access. Optionally, you can choose the role of the team member (Owner or Member) by clicking the drop-down arrow next to Member. If you forget to do this, you can update the membership type later. Click Close. Team management features are accessed by clicking the ellipses next to your team name in the App bar. The following management options are available: Manage team launches the Members tab where you can add or remove members, change the role of a member, or search for a member. Add a channel launches a dialog box where you can enter a channel name and the description for the channel. Add members launches a dialog box where you can enter the names of people, distribution lists, or mail-enabled security groups to add to your team. Leave the team launches a validation window that asks you to confirm your intent to leave the team. Edit team launches a dialog box where you can change the team name, the team description, and privacy settings. Get link to team launches a dialog box where you can copy the URL for the team to share with others. Delete the team launches a validation window that asks you to confirm your intent to delete the team. Chatting in Microsoft Teams When a new member is added to a team, that member automatically gets access to all previous conversations, files, and other types of information shared in the team’s hub. This is especially helpful for onboarding a new team member to a project. There is no need to think about what files to forward to get the new member up to speed, since they can self-serve from the content available in the hub or simply ask for help from others through chat. To start a chat, click on the Compose Box and start typing your message while in either the Activity, Chat, or Teams sections. When you’re done, click the Send icon to post your message. Depending on the culture of your team, you can spice up your chats with emojis, giphys, or stickers. You’ll find a variety of options when you click these icons below the Compose Box. Sometimes conversations in a team can become noisy when there are many members talking about different topics. To help with that, take advantage of the threaded messages feature in Teams by replying directly to a specific message so the reply in in context with the original message. Sharing files in Microsoft Teams When you create a Teams hub, a SharePoint site is automatically created in the backend, which, in turn, creates a document library for each channel. Files uploaded in a Teams channel show up in the Files tab and are stored in a SharePoint document library. In fact, you can click the ellipses next to the file name and then choose to open the file from its location in SharePoint. To share a file in Teams: Select Teams from the App bar. Compose a message in the Compose box from a channel. Click the Attach icon (it looks like a paperclip) below the Compose box and select the source for the attachment you want to share. Select the file from the source and upload it. The file you uploaded will now be embedded in the message. Click the Send icon (it looks like an airplane) to post your message. The file you shared will also show up in the Files tab. Alternatively, you can go directly to the Files tab and click the Upload button to upload a file. Once the file is uploaded, click the name of the file to open it. Once opened, you can start a conversation with others regarding the document. Meeting and conferencing the Microsoft Teams way Chats and conversations in Teams are fun ways to communicate with others. Sometimes, however, it’s more efficient to get on a quick call with team members to resolve an issue versus going back and forth in a chat. Fortunately, Teams provides a complete meeting solution with support for audio and video conferencing. Because calling capabilities are built into Teams, you don’t need to log out of Teams and open a separate application to start an ad-hoc meeting. For more formal meetings, you can schedule a meeting much like how you set up meetings in Outlook. Meetings you create in Teams will show up in your Outlook calendar. Setting up an impromptu Microsoft Teams meeting Let’s say for example you are chatting with three members of your team about an issue. After a lengthy back and forth and waiting times in between, you decide it’ll be much faster to just get on a call and talk about the issue. To start an impromptu meeting: Reply to the conversation thread and click the Video icon that appears at the bottom of the Compose box. From the video window that pops up, enter a subject for your call. Toggle the video camera on or off to choose between sharing your video or just audio. Click Meet Now to start the conference. A conference window will open with a pane on the right where you can invite others to join the meeting. When you’re done with the meeting, click the red phone icon to end the call and leave the meeting. After the meeting, notes and conversations are posted to the channel so others who couldn’t make it to the meeting can quickly catch up on what they’ve missed. Scheduling a Microsoft Teams meeting You can set up a formal meeting ahead of time to give the invited participants notice about a meeting. Like Outlook, formal meeting requests in Teams include a Meeting Title (the equivalent of Subject in Outlook), Location, Start and End Date or Time, Details, and a list of participants. In Teams, you can select a channel to meet in. When a channel is selected, artifacts from the meeting are posted in the channel. To schedule a Teams meeting: Click Meetings from the Apps bar. Click the Schedule a Meeting button that appears at the bottom of the left pane. From the New meeting window, enter the Title, Location, Start and End Date/Time, Details, Channel, and the names of the people you want to invite to the meeting. If you want to check people’s availability, click Schedule Assistant above the Details section to display your participants’ availability based on their Outlook calendars. Click the Schedule a Meeting button. The meeting is now scheduled and will appear in the Meetings section in Teams as well as in your Outlook calendar.

Article / Updated 10-05-2021

To create an Access database, you need to first create a database table and then define the names of all the fields you want to store in that table. Access database tables let you divide a file into separate parts. For example, one database table may hold the names and addresses of all your customers, a second database table may hold the names and addresses of all your employees, and a third database table may hold the names and addresses of your suppliers. Access stores all this related information in a single Access file that’s saved on your hard drive. Designing an Access database To design your Access database, you can create a database from scratch or use an existing template, which you can modify. Designing a database means defining both the number of fields to use for storing information and the maximum amount of data each field can hold. If you have a field that stores numbers, what are the maximum and minimum limits on the numbers you want to save in that field? If you’re storing someone’s age, you probably don’t want the field to contain negative numbers or numbers beyond 200. If your field needs to hold salaries, the field may need to hold large numbers but no negative numbers. In general, store information in separate field in Access. So, rather than create a single field to hold someone’s full name, create two separate fields: One field holds a first name, and the second field holds the last name. By storing last names in a separate field, you can easily yank last names out of your database to create form letters that state, “The Smith family has just won $200,000 dollars in the Publisher’s Umpteenth Sales Pitch Sweepstakes!” Access can create a blank database or a special database by using one of many templates available from the Microsoft website. No matter how you create a database, you will likely need to customize it for the type of data you want to store. When you start Access, it gives you a choice of opening an existing database or creating a new one. Creating a new database To create a database with Access already running, follow these steps: Click the File tab. Choose New.Access displays a variety of database templates you can use. Click an icon, such as Blank Database, or any database template. When you click a template, a window appears; you see a preview of your template. Click in the File Name text box and type a descriptive name for your database. If you click the folder icon that appears to the right of the File Name text box, you can open a dialog box that will let you define a specific drive and folder in which to store your database file. Click the Create button to create your database file. Access displays a blank database. Click the Click to Add heading. Access displays a menu for defining what type of data that field can hold, such as text or numbers. Choose Long Text. Access displays a generic field name, such as Field 1. Type a name for your field (such as First Name or Salary). Press Enter.Access displays another Click to Add column; its menu lets you choose the type of data to store in the next field. Choose Long Text or any other data type you want the field to hold.Access displays another generic field, such as Field1. Type a name for your field, such as Last Name. Repeat Steps 9 through 11 for each additional field you want to create. When you have finished adding fields, press Esc on the keyboard. Check here for handy Access 2019 keyboard shortcuts.