Design Your Own Business Cards with MS Publisher

Posted on September 7, 2017 by Angela Nino

  Are you in need of business cards? There are many places online that offer you the ability to create a discount card. The disadvantage of these web sites is that you cannot do much in the way of customizing. If you want to be able to make your own layout and text, you can design your card using Publisher. You can print the cards yourself or send them to a printer to get a professional look. Choosing Your Card In Publisher, you can choose from a variety of designs, or even create your own from scratch. When you open the Publisher application, click on the “Built-In” templates. This will be under “New” on the left and then two lines…

Read More

Do you have the hottest MS Office skills for 2017?

Posted on August 31, 2017 by Angela Nino

Do you have the top MS Office skills for 2017? If you are job hunting or looking to advance, are you able to perform the tasks that are asked of you? Are you an expert in knowing what is needed in today’s office environment? From my experience with large, medium and small businesses, I have found that many of them use at least one Microsoft Office program. If you are searching for new employment, you will often see Microsoft Excel and Word on the description. I am seeing more organizations that rely on Outlook, PowerPoint and Access, too. Even SharePoint use is on the rise in many larger organizations. Here are some of the most desirable MS Office and SharePoint…

Read More

Financial Calculators for Excel

Posted on August 22, 2017 by Angela Nino

Excel has so many amazing financial functions and formulas. But, do you really want to create a financial calculator, like a mortgage calculator from scratch? If not, you can find many online or within the Excel templates. Excel Financial Calculator Templates To see a huge number of templates, just launch Excel and enter Financial Calculators in the template search box. See Figure 1. Figure 1 Some of the available options include calculators for mortgage loans, balloon payments, simple amortization schedules, and even for bathroom remodel costs. If you want to narrow down your search, you can choose from a list of categories on the right side. See Figure 2. Figure 2 For this post, let’s look for a simple calculator…

Read More

Create a Table of Contents in Excel

Posted on August 15, 2017 by Angela Nino

Have you ever had an Excel file with multiple worksheets? Wouldn’t it be nice to have a table of contents on a worksheet with links to each sheet? Many of us would shout, “Yes!”. Unfortunately, Excel cannot do that by itself. But, by creating a macro, you can help Excel create the sheet. The website Computergaga even provides the code. There is one issue with the code, but it is resolved in the comments in their blog. I am providing the corrected code in this post. Save As Macro-Enabled You will want to save the Excel file as a Macro-Enabled Excel file. Just go to File and click on Save As. Change the Save As Type to Excel Macro-Enabled Workbook….

Read More

Microsoft Office Differences Between Mac and PC

Posted on August 8, 2017 by Angela Nino

Over the years, I’ve worked in a Microsoft Office application on PC and Mac. The Windows version has had more improvements and updates than the Mac version, even though Office was created for Mac before the PC. Even though the release for Mac was first, the PC version often received the focus for improvement and added features. Microsoft Office Versions In my opinion, the Mac version looks a little rougher around the edges than the more streamlined look on the PC. Outside of the interface differences, you will notice that Mac Office doesn’t have all of the apps that the PC version has. And, some of the visual basic functions are missing in Mac. Mac does have a better layout…

Read More

Why Microsoft Office Matters in the Workplace

Posted on August 1, 2017 by Angela Nino

In most office environments, you will find Microsoft Office products. They still comprise the highest market share for office suite applications. When you look for a benchmark for word processors and spreadsheets, Microsoft sets the bar. Even when looking at email/calendar software, Microsoft Outlook is at the top of the heap. Microsoft Office So, why use Microsoft Office? Why learn about Excel, Word, and other programs? The power of the software. The features and full effectiveness of the applications haven’t been duplicated. Especially when looking at spreadsheets, you won’t find one that out performs Excel. If you aren’t using the full scope of what is available in Word, Excel, Outlook, and PowerPoint, then you are missing out. For example, think…

Read More

Exciting Microsoft Apps for Productivity

Posted on July 25, 2017 by Angela Nino

We all know of Microsoft’s Office products, but they are always working on other apps that can help increase your office and home productivity. Sway Sway is an app that helps you tell a story digitally. The initial roll-out has been improved and the current version is user-friendly. Download the app from the Microsoft store. See Figure 1. Figure 1 You can easily add all kinds of multimedia content. My son and I tried it for our own personal use to create a digital presentation. It was quick work to show my son how to use it to creatively design our story. The Microsoft store page shows other ideas, too. See Figure 2. Figure 2 The stories, reports, or presentations…

Read More

Help! The Laptop Ate My Homework

Posted on July 18, 2017 by Angela Nino

Most people have experienced the sheer panic of working on a document, presentation, or other file and then having it disappear. There are several tips that you can implement before or do after losing a document to help recover the item. Set up a Backup If you haven’t lost a file yet, don’t wait for it to happen. Be proactive and set up a backup for your hard drive. There are cloud services, if you want to set it up for automatic syncing with your system. Or, you can use a local backup. Either way, it is well worth the investment of a little time and money to ensure that you can recover a file if it goes missing. Check…

Read More

5 Outlook Tips for HR Experts

Posted on July 11, 2017 by Angela Nino

Juggling people, appointments, email, and tasks are all part of the daily routine in Human Resources. But, are we doing it in the most effective way? Microsoft Outlook has many great features that can help make the work life of an HR professional much easier and more productive. Peek at an App When looking at email in your Outlook inbox, you might want to “peek” at your calendar. If you point to your calendar icon, you can take a quick view of the current month date navigator and upcoming appointments. See Figure 1. Figure 1 Dock Your Peek Screen If you would like to dock the “peek” view on your screen, you can click the button in the top right…

Read More

Create a Risk Register Using Excel

Posted on July 3, 2017 by Angela Nino

If you are involved in any level of project management, then you have most likely seen, used, or even developed a risk register. Being able to quantify the risk associated with each part of a project is important in planning, design, and implementation phases. Noting triggers and mitigating actions in the analysis is important, as well. Microsoft Excel can help you with your risk register. You don’t need to create one from scratch. There are several templates and resources to help you. Check out the following sites to find templates, definitions of terms, and even tutorial videos. Risk Register Tips, Terms and Templates Tips, Components, and a Template Template, Benefits of a Risk Analysis, and Explanation of the Risk Management…

Read More