Display archivesNew user of spreadsheet programs? I have a course for you.

September 10th, 2014
If you’re new to the whole concept of spreadsheet programs, check out my new course, published by Tuts+: Intro to Spreadsheets. It’s not Excel, only!

 

Of course, Excel is the 800 lb. gorilla in this category, and most of the course focuses on it, but the course will also help if you’re using other applications, like Google Sheets, Apple Numbers, LibreOffice Calc, and the web and mobile versions of Excel. You can finish the course in about a day. Exercise files are included.

 

intro-to-spreadsheets

 

 


Display archivesHow to prevent Illustrator from combining layers when you group or paste

August 21st, 2014
When you copy and paste objects that are on multiple layers, or when you group objects that are on multiple layers, Adobe Illustrator will combine everything onto one layer. It’s probably not what you want, and can be frustrating. Here is how to fix both problems.

 

 

My full-length Adobe Illustrator CC and CS6 courses are at TotalTraining.com.

 

 


Display archivesInstantly turn any YouTube video into an animated gif

August 17th, 2014
Depending on whether you love or hate animated gifs, this will be either excellent or horrible: to turn any YouTube video into an animated gif without having to download anything or mess with any application, substitute the “youtube” in the URL with “gifyoutube“.

 

For example, I’ll take this video of Felicia Day (creator of The Guild and Geek and Sundry) flying on a trapeze:
www.youtube.com/watch?v=YIfPZka-8XQ

 

…and change the URL into this:
www.gifyoutube.com/watch?v=YIfPZka-8XQ

 

Enter a title for the gif (title is truncated, below), drag the video’s play head to the time where you want the gif to start, then set the number of seconds the gif should run, with a maximum of 10 seconds. Click the Create gif button on bottom, and it instantly creates the gif and gives you a URL that you can use.

 

gifyoutube

 

The gif I created above has a URL of:
http://share.gifyoutube.com/oQS.gif

 

(And if you want to see Felicia Day doing a lot of other fun stuff, check out her channel, The Flog.)

 

 


Display archivesHow to Create a Gantt Chart in Excel

July 29th, 2014
Posted on LinkedIn. Tutorial with exercise files.

 

completed-chart

 

Need more Excel training?

 

 


Display archivesOneNote for the Kindle Fire

July 25th, 2014
Microsoft just released OneNote for the Kindle Fire, and the app is free. More info here.

 

 


Display archivesMicrosoft will merge all 3 versions of Windows

July 23rd, 2014
Call it E. Pluribus Windows: in a big shift from the Steve Ballmer days, Microsoft CEO Satya Nadella says Microsoft will merge all 3 versions of Windows into one OS that runs on all screen sizes.

 

This means developers can create universal apps that will run on any platform.

 

The Verge has more.