Having a Good Week

I hope that things are going well in your corner of the world. Here, in the Wyatt corner, things have been buzzing just a bit, as I've dealt with an influx of new students in a course I prepared for Microsoft Word users. (It's a good "busy," though, as I enjoy helping people out.)

Speaking of courses, I'm thinking of opening the doors to my Excel Macros Master Class again in the near future. There are still a few logistical issues I need to deal with, but I hope to get those ironed out in due course. If I do decide to open the doors (or, I should say, *when* I decide to open the doors) I'll let you know.

I hope you enjoy the tips in this week's newsletter and that you have a great week.

—Allen
     

ExcelTips (menu) for 16 February 2019
Files
Importing Multiple Files to a Single Workbook

If you use Excel to work with data exported from another program, you might be interested in a way to import a large number of text files into an Excel workbook. This tip explains how you can use a macro to make short work of the files you need to import.

Read this tip »

 
Graphics
Displaying Images based on a Result

Got some images that you want to appear in a worksheet based on the result displayed in a cell? Figuring out how to "conditionally display" an image can be tricky, but it can be done following the steps in this tip.

Read this tip »

 
Macros! Macros! Get Your Macros Here!

Learn all the best methods for creating and using Excel macros. ExcelTips: The Macros is the best single source for learning about macros or improving your existing skills. Be the person everyone looks to when something needs to happen in Excel. Get yours today!

 
Date formulas
Calculating Week-Ending Dates

When working with dates, you may need to figure out all the dates on which weeks end in a given year. There are several formulaic ways to accomplish this task, as described in this tip.

Read this tip »

 
Web publishing
Adding Excel Information to a Web Page

Besides saving a worksheet as a complete Web page, you can also save smaller portions of your data to an existing Web page. This tip shows how easy such an operation is.

Read this tip »

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