Switching between Excel Workbooks

Posted on October 16, 2017 by Angela Nino

When working with one Excel file (called a workbook) at a time, it is pretty easy to stay organized and move around easily. Opening a second Excel file can complicate things a little bit. Trying to move between multiple Excel worksheets can get even more problematic, especially if you need to look back and forth quickly. Then, make it more difficult by moving within the worksheets within the different workbooks. An example of this is when you are working on your budget from the last year or two to create your upcoming budget. If you have worksheets from several departments within each budget file, it can get really confusing. You can have all of the workbooks open but just look…

Read More

Preparing Payroll in Excel

Posted on October 12, 2017 by Angela Nino

Are you a small business or a sole proprietor who needs to prepare payroll? If you are like many smaller companies, it is hard to find a simple solution that doesn’t eat up your entire budget. The good news is that you can do much of the tasks in an Excel payroll calculator. Payroll Calculator One of the Excel payroll calculators can be found on the Microsoft Office site at: https://templates.office.com/en-us/Payroll-calculator-TM06101177. See Figure 1. Figure 1 Click the Download button and enable editing after it is saved to your computer. This workbook already has everything set up for many tasks. Enter employee information – includes hourly wage, tax percentages, insurance and other deductions Payroll information – includes hours worked, vacation/sick…

Read More

Pro Tips for PowerPoint Presentations

Posted on October 6, 2017 by Angela Nino

Picture of a man giving presentation

About a month ago, I sat in on a presentation given by a good friend. She is a whiz at PowerPoint and seems to really “get” what it takes to reach an audience effectively. I am always impressed with her visual slideshows that are simple yet interesting. The slides add to her presentation without taking the focus off of her as the presenter. I asked if I could share some of her tips in a blog post and she agreed. Keep it Simple This is my friend’s greatest strength with PowerPoint. She does not just fill the screen with “stuff”. The presentations that have open space and are not cluttered seem to help us focus better and do not take…

Read More

Effectively Searching and Sorting your Inbox

Posted on September 28, 2017 by Angela Nino

I cannot tell you how many times I have had a client need to pause our one-on-one training session to deal with email. We are usually sitting at their desk and are working with their files. A notification pops up with a new email message they received in their inbox. I have heard: “If I don’t deal with this now, I will forget about it.” “My inbox is taking on a life of its own.” “I’m sorry, I have to answer this now or I’ll lose this message in all of the others clogging my inbox.” “I have to leave this message in my inbox because it is a reminder for me.” Most of the people I train use Microsoft…

Read More

Creating Process Flows

Posted on September 18, 2017 by Angela Nino

  Are you struggling with being able to get a certain concept or instruction steps across to your training attendees? Or, do you just need to illustrate a process or procedure in your report but don’t have the time or energy to invest in learning Visio? You can do it right inside Word. The flowchart shapes and symbols are located on the Insert tab in the Shapes button menu. If you can insert a shape in Word, then you can create the flowchart. You just need to create a drawing canvas before you begin that will keep the flowchart items together. It is essentially a box that will help your group of symbols and lines stay grouped together. Insert a…

Read More

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