Skip to content

Import text from Word into PowerPoint Slides

Import slide from Word outline to PowerPoint

If you set up a Word file correctly with styles (heading 1, 2, 3), the file will import fairly nicely into a PowerPoint.  Much faster than copy/pasting umpteen times, a few shortcuts on getting fonts/colors to match is included.

Most instructions do not include the details that are reviewed – it does not always go in perfectly.


Excel 2016 – create a forecast with goal seek

Creating and planning a forecast on nearly any product or service is often accurate guess work as you’re looking at previous/current conditions, future trends. Unfortunately as we don’t have a crystal ball, we don’t really know what the future may bring! (kind of like being a weatherman).

Now you’ll be prepared when you go on Shark Tank with your next big greatest invention!

This video demonstrates goal seek, very basic formulas including absolute references in addition to fine tuning its appearance and moving/hiding data.

Excel – copy only filtered data/subtotal function

When filtering data and you want to only use the  data shown, the typical copy and paste will display all the hidden data.  To display ONLY the data that appears in the filter, this method will work with either the filtered data or using the subtotal function.  Although you can use a Pivot Table/Chart to perform this, this method is a bit simpler.
This video uses Excel 2016 and should work with many earlier versions that have the find and select function which appears on the home tab.

Carbonite – customer service very poor

Carbonite does have its positives – phone calls always answered in America. However, be darned cautious in knowing what will or will not be restored. I was misled about what was backed up – considerable data stored in a root directory (C:) not backed up and am severely inconvenienced. it will take me about 20 hours to FTP some files that are online. In addition, data files dating back 20 years are gone forever.

If any of my subscribers have advice on where I should go to in the future, please advise. I thank you!

Access – queries/reports with calculations

Videos shown are in version 2016 which also applies to those using 2013.  One of the many powerful features in Access is the ability to do calculations.  Working with the “Santa” database, we can calculate raises for the elves in a query.  After the query is completed, we are creating a report for Santa which will show the results in a more professional fashion.  In addition, additional formulas are created such as the average salary.  Formatting is more than bold, italic, we can see themes.  In addition, graphics can be added to create customized report.

The videos are in 2 parts.

Queries with calculations

Reports with calculations

Excel – linked data types

If you have the current version of Excel, this may be a game changer for you with linked data types – this link goes into more detail.

The New data Types are technically Linked Data Types. This means they pull data from an Online Source. Right now, there are two New Data Types in Excel, Stocks and Geography.

But for Understanding, you can think of the New Data Types in Excel as Entities. Every Cell contains a “hidden lookup row” that turns the text within a Cell into a “record” with properties.

This is definitely worth checking out!



Use social media to enhance your business’s online presence

If you have a business with an online presence, you may wish to improve its online effectiveness (or educate yourself a bit more!) with this online video is a short snippet of topics being covered in significant detail

The class is May 24, 7 – 9:30  at Greenwich Continuing Education (Greenwich High School) – go to to register.