Simplex-IT
Simplex-IT Newsletter
Join Our List
Contact Us!
In This Issue
Project Online Lunchinar
Book Review?
May Webinar: Updating Project Schedules
Lync Online becomes Hosted UC
Latest videos
Free Excel Webinar: VLOOKUPS / FORMULAS / TRACKING
Blogs, Blogs, Blogs...
Plain Funny
Issue: #85May/2015


 

Timing is everything.

 

So is the digestive system.

 

So here's the story.  I was in Las Vegas attending the annual Sophos Partner conference (Sophos is one of our primary partners, specifically dealing with security).  The conference ended on Thursday the 30th.  And my plan was (hint:  I'm using the term "plan" in the past tense, so you know this isn't going to end well) to finish the newsletter that evening, and get it out in the morning (on the 1st).

 

Ahhh...no.  Didn't happen.  I started an absolutely brilliant article (hint:  again using the past tense, this time "started;" again, not going to end well) on some of the security insights I gained at the conference.

 

No problem, I figured.  Give it the weekend.  Finish it and everything else up and get it out the morning of the 4th.

Ya know that stomach bug that everybody's complaining about?  I think that's what nailed me starting Saturday morning.  And although I was able to get some things done, writing witty (or whatever you want to call this) prose for the newsletter was not in my wheelhouse.

 

Sunday I was a little better, but had to take time out for crawling lessons with grandson Matthew.  I'm told that I'm making great progress.

 

Monday morning I was slightly mobile, but had way too much catch up still underway.  So here it is early Tuesday morning, and I'm finishing the pieces of the newsletter.  And it's a short one, but there will be additional things added to the blog over the next week.

 

Including an article about my recent insights into IT security.

 

I think it's gonna be brilliant.

 

Bob 

  

Follow us on Twitter    
View my profile on LinkedIn 
Find us on Facebook

 

View our videos on YouTube

 

May Lunchinar: Project Online for the Small to Mid-Sized Businesses

Project Management used to be something you found only in large organizations - they had the budget and resources to implement such a thing. But not anymore... With Microsoft Project Online, it's affordable for everyone, and user friendly too.

 

During the lunchinar, we'll discuss the basics of project management, and demonstrate some of the capabilities of Microsoft Project and Project Online. We'll show how managers and executives, project managers, and the folks working on the individual tasks can use these tools. You'll see how you can easily create and track your project work, and how to create reports to show future projections. We'll also touch on Project Sites, the SharePoint component that provides and extra workspace for things like Risks, Issues, Documents, Calendar, General Discussions, and much more.

So join us if your find yourself wanting quick, easy, answers to questions like:

  • What's going on right now?
  • What project are running late or over budget?
  • When will I have the time and resources to start another project?
  • Why, when, and how did this project get so off track??

Bob Coppedge and Patti Smerk (who heads up our new simplex-PM practice) and will be demonstrating these tools and techniques to show they can be used to help you gain better insight and manage your projects more effectively.


 

When:  Wednesday May 20th, from 11:30am-1pm (Eastern)

Where:  Stow Hampton Inn and Online

Cost:  Free!

RSVP:  Click here!

Paris 1919: Six Months That Changed the World

I decided I'm going to try to increase my reading non-IT books.  And I figured the best way would be to share with folks a book each month (yeah, we'll see how long this lasts).

 

I just finished Paris 1919:  Six Months That Changed the World by Margaret MacMillan.  Written back in 2003 it's an extremely detailed review of the process after World War I that led to the Treaty of Versailles.  This treaty was blamed (the author would argue against) for setting the stage for World War II.  At the very least it most certainly created rather arbitrarily defined countries and borders, especially in the Middle East.

 

It's an interesting read.  Especially at a time where it's easy to read the news today and wonder (whether you're left or right facing) "how could any politician do such stupid things?"  Read this book and you'll get a feeling for a good amount of the silliness, pettiness, ignorance and more that drove this process.

May Webinar: Updating Project Schedules

So you've finished creating the project schedule, congratulations! You're done and don't ever have to look at it again, right? Wrong!

(At the end of this article you'll see how to register for a free webinar on this topic later in May!)

Your project schedule is a constantly changing document. Changes occur all the time throughout the duration of a project. Tasks are added, removed, and reordered. They finish and start earlier and later. The resource assignments change. Issues happen.. And our schedules need to reflect that.

The project baseline is the starting point - this is where your original plan and intentions are stored. Think of this as "this is what we planned to do." After that, when the project has started and is in execution, changes to the project schedule need to be made. Think of this as "this is what we actually did." The value of capturing the actual information is in the variance analysis. Now you can show the variance in your original plan from what actually occurred. Also, when a schedule is updated with actual information, MS Project automatically adjust the future start and finish dates of all linked tasks. This ensures your resources always have the most up to date task information.

To read more click here.
To RSVP for the webinar (May 21st), click here.

Lync Online to Become Full-Fledged Hosted UC Service

We've been saying for the past couple of years that Microsoft Lync Online was ultimately going to be a game changer when fully implemented.  And we pointed at Microsoft's acquisition of Skype as a critical component of that strategy.

 

And we waited.

 

And then...we waited some more.  Until now.  The rebranding of Lync (to Skype for Business) finally gives some meat to the process.  It's not fully in place yet (as this article explains), but I think the changes are on the way, and undeniable.

 

The following article excerpt, by Brian Riggs, originally appeared here: http://ubm.io/1PIMzOH

  

Skype for Business Online promises to be a game changer - not only for Microsoft, but also its partners, customers, and competitors.

 

As Microsoft begins to upgrade Lync Online users to Skype for Business Online this week, it is taking the first step in delivering a full-featured hosted UC service. And, make no mistake about it, this will be a game changer - for Microsoft and its partners, customers, and competitors.

To read more click here.

Latest webinar videos from Simplex-IT

We've got 3 new videos from the month of April:


 

Project Online:  Using Project Sites
Project Online: Using Project Sites


 


 

MS Access:  Getting answers from your database
MS Access: Getting answers from your database


 

Keeping Corporate Data Healthy by Simplex IT
Keeping Corporate Data Healthy by Simplex IT


 

Free Excel Webinar: VLOOKUPS / FORMULAS / TRACKING

In this free session, we will look at creating Vlookup formulas - since most tables are created vertically, you can look up values from a table to populate another worksheet, then when you update the main table, it updates the other worksheets.   We will create name ranges to use in formulas and when selecting large areas of a worksheet, work with IF statement functions, the Sumif and Sumifs formulas, and the DGET function (grabs one record from a large database).

We will also look at working with comments and tracking a workbook so you can send and then review changes and accept or decline those changes to update workbook. Learn how to protect a workbook and worksheet so others can only change cells you choose.

Will also look at creating a simple macro in Excel and learn more about the Personal workbook which is a hidden workbook that stores macros.

Click to read more!

To RSVP for the webinar (May 21st), click here .

Want to find out about this stuff quicker?

Blog updates from Simplex-IT over the past month

 
Remember to check out our blog:

 

Plain Funny

This year the Hubble telescope celebrates its 25th anniversary.  Thankfully it's still going strong.  I thought this video, taken from Hubble data, was pretty cool.  


 

Incredible Hubble Space Telescope fly-through of the Gum Nebula
Incredible Hubble Space Telescope fly-through of the Gum Nebula


 

We'd love to hear feedback about this!  Send comments to Bob@Simplex-IT.com, or call us at 234.380.1277!

 

Sincerely,

Bob Coppedge
Simplex-IT LLC