Technology Training

Get Started With Skype For Business

Skype for Business really brings into question the need for a physical phone in the business world, especially for small companies. Skype for Business is another value-add in the Microsoft Office 365 offering and it works seamlessly with other Microsoft Office apps.

In this video, we will walk you through accessing Skype for Business on Windows 10. Once you have the application installed and opened, we will show you how to set up your microphone, headphones, and webcam. After you’ve gone through the setup process, it is relatively straightforward. You can open up a chat session, have a voice call or start a video conference with anyone in your contacts list. The great thing about Skype for Business is that you can talk to anyone around the world no matter if they are using Skype for Business or not.

Skype for Business is a great tool that will allow you to not only talk to friends and colleagues around the world but you can also attend virtual meetings with Skype for Business conferencing. Skype for Business also has many great built-in features such as screen sharing in case you need to show something to a colleague on your computer. The best part of all this is that you have Skype For Business built into your Office 365 subscriptions.

Microsoft Office 365 is changing the way that business communicates by creating one platform that encompasses email, voice, chat, conferencing and a whole lot more. What is great about what Microsoft has created is that you can get all the basics of business communication, hosted by Microsoft, for a low monthly cost. No more Exchange servers, PBX boxes or PRI’s to pay for and maintain.

If you haven’t looked into what Microsoft has to offer through Office 365 we strongly recommend that you do. If you already use Office 365 and are still paying to maintain a phone system then you may want to consider Skype For Business to help minimize and consolidate expenses.

Technology Training

Microsoft Outlook 2016 Out of Office Auto Reply

Are you going on vacation? Don’t forget to set your “Out of Office” auto email reply in Microsoft Office 2016. In this video, we will show you how to set up and schedule an automated reply so that you don’t have to worry about emails going unanswered while you are away.

If you are worried that you might miss something important, the best practice is to put the name and contact information for someone in your company that can be available to respond if your customers need help. If necessary, you can even set your emails to forward to a colleague while you are away. Now you are ready to go on vacation! The only thing to remember now is that you need to turn off your auto reply when you return.

Technology Training

Microsoft Excel 2016 Formatting Cells

A big part of learning how to work with numbers in Excel 2016 is learning how to format them so that Excel knows what your numbers are representing. There are many options in Excel such as general, number, currency, accounting, short date, long date, time, percentage, fraction, scientific and text. By telling Excel what your numbers are, Excel will have a format for those numbers that will make your life easier. More accurately, you are formatting the cell or range of cells that you are placing your numbers in. Any time you place a number in that cell it will appear with the format that you choose.
One example of using Excel in this way is the currency setting. When you turn on the currency setting for a cell, column or row you have enabled Excel to place two decimal places after the number you have entered, removing a few key strokes. It will also add in a comma for large dollar amounts and the currency symbol of your choice. This is ideal when you are working with money.
If you need to use Excel as a glorified calculator and you are working with percentages or fractions, Excel gives you options for that as well. Using the add, subtract, multiply and divide functions that we reviewed in the last Excel video, you can use percentages and fractions in mathematical equations.
If you are making a presentation in Excel and you would like to add in a note that isn’t effected by equations, you can use the text format. This will allow you to type anything you want into a cell without confusing Excel in the process.
There are many more options to choose from and when you become familiar with these options you will be able to use Excel much more effectively. In later videos we will review how to use the features to make more complex calculations.

Technology Training

Microsoft Excel 2016 Introduction to Worksheets

Microsoft Excel 2016 is an extremely useful tool that can make sense of almost any data you put into it once you learn how to use it. There are a few updates to the functionality and user interface in Excel 2016 that we will be reviewing so that you will be up to speed with all the latest features. In this video we will explore a few of the basic features such as how to open and use a workbook. First we will show you how to open multiple sheets inside of a workbook. Once you have the basics of the cells, columns and rows down, we will show you how to add, subtract, multiply and divide the numbers by their columns or rows.

Like any great peace of software, Excel 2016 has many shortcuts to make your life easier. Once you have learned how to add, subtract, multiply and divide your columns and rows, you will want to learn how to multiply your efforts by using the drag features. This will duplicate the chosen functions for each column or row so that you can see values for each row or column. If you are trying to add up numbers for a set of rows, all you will need to do is set the SUM function for one row. Once Excel understands the function you are trying to accomplish for that row, you will be able to drag and select all of the subsequent boxes to find the SUM values for the remaining rows without having to repeat the SUM process for each row.

Stay tuned for more great Microsoft Excel 2016 videos!

CW Portal