Social Media

It seems that social media is prominent in the news these days, especially Facebook. Even though the news may seem bad, I undertand that LOTS of people stay connected and "on top" of things through both Facebook and Twitter.

If you are one of those people, I just wanted to let you know that we've recently updated our ExcelTips presence on both of these popular social media sites. If you would like to see us on Facebook, you can do so here:

     https://www.facebook.com/excel.tipsnet/

I would love it if you like what you see there if you would really "Like" what you see there. (Got that? Good!) Clicking the Like button means you are more likely to see what we post there.

If, instead, you spend your social media time over at Twitter, you can follow @ExcelTipsNet.

Regardless of whether you use Facebook or Twitter, we'll try to continue posting great content for you to enhance what you are doing with Excel.

Kudos go to my son, Eric, who has been working on our social media presence for the past few weeks. If you have questions about what we are doing on social media or you have problems with getting connected with us there, you can e-mail him at eric@sharonparq.com.

Let me know what you think!

—Allen
     

ExcelTips (ribbon) for 21 April 2018

Macros extend Excel
Automatically Enabling Macros for Specific Workbooks

On your system you may have workbooks that contain macros you know are safe to use. Microsoft provides two things you can do with such workbooks that will cause those workbooks to load without impediment. This tip looks at both trusted locations and provides a link to additional information about digital signatures.

Read this tip »

(Thanks to Michael Avidan (MVP), Bharat Rohra, Charlie O'Neill, Bob Beechey, and Alec Whatmough for contributing to this tip.)

 
Date formulas
Leap Years and Fiscal Periods

Need to figure out when a fiscal year ends when that period does not correspond to the calendar year? Here are some ways that you can do the calculation and make sure you take leap years into account.

Read this tip »

 
Pay a Visit to Formville

Need invoices, statements, receipts, applications, and hundreds of other business forms you can put to use right away? How about if you can get those forms for free? Discover what awaits you in Formville, your destination for free printable business forms.

 
Charts and charting
Using Go To to Jump to a Chart Sheet

Create a chart on its own worksheet, and you can display it by simply clicking the tab at the bottom of the Excel work area. But if you can't do that, then you may want to use Go To to jump to that sheet. Here's the skinny on whether you can do that or not.

Read this tip »

 
Date formulas
Determining Month Names for a Range of Dates

Given a starting date and an ending date, you may want to generate the names of all the months between those two dates. This tip examines several ways you can determine the information.

Read this tip »

     

Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

 
Office 365 and Excel Versions

I'm a bit confused. I have Office 365, but I'm not sure what version of Excel I have. In the past, the version of Excel was the same as the version of Office in which it was included, so that if I had Office 2013 I knew I had Excel 2013. Because I have Office 365, does that mean I now have Excel 365? Any light you can shed on this would be appreciated.
—Gerry Thomas (provide an answer for this Help Wanted question)

 
ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450