Browsing Posts in Office 2013

What is Office 365?

Click here to RSVP for the webinar on this topic on Thursday August 13th from 11-noon (eastern)

Office 365 is a subscription based service to the Office programs you know and love. It’s kept up to date automatically, so there’s no software for you to purchase and install. Your subscription gives you access from up to 5 devices, so you can work from your computer, tablet, smartphone, whatever you need.

 

Office applications
There are a couple different ways to use the Office products with Office 365. You have Office Web Apps, which are basically web based versions of the familiar Office products, as well as the full versions. Office Web Apps have a lot of the same functionality, although not all. And of course you will still have the full versions of the Office products available to install on your computer.

 

Email
Office 365 keeps all your emails in sync across all your devices. It’s also easy to share calendars and view scheduling information for people within your organizations.

 

Instant Messaging
Office 365 comes with Skype for Business (Or Skype depending on the subscription you choose). You’ll have individual and group Instant Messaging capabilities, availability indicators, and calling information. Check out our webinar on Skype for Business for more information on these capabilities.

 

Video Conferencing
Skype for Business also offers individual or group video conferencing. It’s fully integrated with Outlook, so creating meetings with links to Skype calls can be done right from your Outlook client. And Skype for Business isn’t limited to people within your organization, you can also communicate with people outside your organization.

 

Collaboration
Share files and collaborate in real time from any device. Working on a presentation or document with a team? With Office 365 you can edit and track other edits easily in one shared file. Version control is easy because everything is in real time.

 

So which subscription do you need? That depends on if you need email, Office, or both. Below is a more detailed table of the subscriptions:

 

 

 

 

Interested in Office 365? Join us for August Office webinar where we’ll demonstrate some of the basic functionalities and discuss the various subscriptions available.

 

Access your files anywhere and with any device using OneDrive (webinar)

OneDrive is the free cloud based storage solution from Microsoft. It’s accessible from any device, and much easier than emailing files or using a flash drive. A lot of our devices don’t even have USB ports, and I’d always lose those things anyway.

RSVP for the webinar by clicking here

OneDrive comes with your Microsoft account, and you get 15GB of space. If you need more, you can purchase more – anywhere from 100GB for $1.99/month to 1 TB for $9.99 per month. In Windows 8 and later you can access OneDrive from the One Drive app tile.

OneDrive for Business comes with most Microsoft Office 365 accounts, and you get 1TB of space. It’s very similar in function to the personal OneDrive (in fact it gets downright confusing sometimes).

When you save something in OneDrive it gets stored “in the cloud” (namely servers belonging to Microsoft).  If you want to, you can install a client app that will also copy all the files locally (extremely handy).

To get started using OneDrive, just save a file to One Drive instead of your local computer. It’s as easy as selecting the OneDrive option from your list of locations. If you have many files on your local computer, you can either move or copy those to OneDrive. If you chose to make a copy for OneDrive, be sure not to get the versions mixed up. They’ll be named the same thing, so you’ll want to pay extra attention to the location in which you’re accessing them.

You can change the default location for saving files to OneDrive as well. In Settings, and PC Settings, you’ll see some options for OneDrive. Under “Save Documents to OneDrive by default”, select “On.” You can also control which folders are kept in sync as well. In settings, select the Chose Folders to select specific folders to sync and not to sync.

You can access OneDrive through Windows Explorer, where it can be configured just like any other storage location. And, you can create a folder hierarchy for file management, just like you would in your hard drive, or My Documents folders.

But is it secure??  We are always concerned about the security of our data, right? With OneDrive, your files are only accessible by you, unless you choose to share them. To keep safe from hackers, be sure to use a very strong password and add security information to your Microsoft account, such as your phone number, email address and a security question.

There are apps for Android, Apple, and Windows devices too. Just install the appropriate one on each device you wish to use OneDrive with. It’s handy to have the ability to work on file at the office, and then pick back up from your tablet at home or on the go when you want to make changes.

Are there problems with OneDrive?  Yup.  Uploading large numbers of files can corrupt your local copy, plus there are some limitation.

Interested in seeing OneDrive in action? Join us on July 9th  from 11-12 for this month’s Office Webinar, where we’ll demonstrate OneDrive and talk in more detail about the benefits and capabilities.  We’ll also be giving away a copy of Microsoft Office 365 courtesy of Microsoft.

 RSVP for the webinar by clicking here

Skype for Business logo

 

Lync is now Skype for Business!

If you’re a Lync user, you may have noticed a change already – Lync is now Skype for Business! Join us on June 11th (see below to RSVP) for our monthly webinar where we’ll talk about Skype for Business and demonstrate some of the collaboration capabilities. We’ll be giving away a free copy of Office 2013 to one lucky winner too!

Skype for Business can be used to increase communication and collaboration in a number of different ways:

Voice Calling (VoIP) – Audio calls are easy in Skype, and you don’t pay for long distance or airtime. And Skype for Business integrates with your previous contacts from Skype, so you’ll have one tool for your business and personal calls.

Video Calls – One-on-one video calls can be much more personal when you can talk face to face, even if it is virtually. With Skype for Business, you can have those discussions and be able to see facial expressions and body language, or just check out your colleague’s new haircut.

Video Conferencing – Similar to the one-on-one video calls, but with more than two people. This is great for bringing teams together with a more personal feel. Who’s wouldn’t prefer to look at their colleague’s instead of staring at a conference speakerphone the whole time?

Screen Sharing – It’s easy to share your screen during a call. Whether you are working on a project with a co-worker and need to share your screen on the fly, or leading a scheduled presentation, Skype for Business makes it easy to share your screen with your participants.  You’ll see Simplex-IT using Skype for Business for our webinars too!

Online Meetings – Integration with Microsoft Office makes creating online meetings easy! In Outlook, instead of creating a “New Meeting” just select “Skype Meeting” instead. A link to the Skype meeting will be created for you in the body of the meeting invitation. From there, it’s the same as creating a meeting. Your recipients can then use the link provided to join the meeting.

Skype for Business

 

 

 

 

 

 

Instant Messaging – For a quick message, who has time for email? The instant messaging capability in Skype for Business makes it easy to send a message to your contacts. It’s also great for back and forth conversation type communication, rather than the one-sided email that’s easy to lose in your Inbox. Conversations are saved in Outlook, so you can go back and reference them at any point, with no email clutter. You can also see your contacts availability, and let other’s know yours. Leaving for the afternoon or on an important assignment and can’t be bothered? Change your status to Off Work or Do Not Disturb to let everyone know. You can create groups, favorites, and much more.

Skype for Business Instant Messaging

 

 

 

 

 

 

 

 

 

 

Want to learn more about Skype for Business and see it in action? Join us for our monthly Office Webinar!

What: Skype for Business
When: Thursday, June 11th 11am – noon EST
Where: Online
Click here to Register!

 

*Update*  The correct date for this event is Thursday May 14th!

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.

We look forward to you participating in our next Office webcast.

One attendee will win a copy of Microsoft Office Pro 2013, thanks to Microsoft!

At Simplex-IT, we specialize in sharing our knowledge with several free webinar and Lunchinar events each month on topics such as Microsoft Office, Project Management and Data Practices. Contact us at Info@Simplex-IT.com, Twitter (Simplex_IT), LinkedIn (http://www.linkedin.com/company/simplex-it) or FaceBook: (http://www.facebook.com/simplex.it).  Also, watch any of our over 100 videos at https://www.youtube.com/user/simplexITBob.

Questions?  Email us at Events@Simplex-IT.com.

Heads up: beginning April 14, Lync Online will become Skype for Business— so they can “combine the natural, collaborative way Skype enables people to speak face-to-face with the security and control of Lync.”  Also because Microsoft can’t go a month without renaming or rebranding something.

Why are they doing this?  Remember how Microsoft bought Skype a few years back?  One of the reasons (ok, maybe the reason) was that Skype offered a way to bring their Unified Communication model to fruition as a service as opposed to requiring everybody to buy servers (they could actually see the cloud model coming several years ago).  Fast forward to today, it’s a logical extension to bind the services offered by Skype and Lync.

Look for future offerings from MS and other partners to solidify this offering.  My suspicion is within a couple of years they’ll be fully competing for the entire small business phone business market without necessarily offering phones.

Anywho…back to the hype…I mean Skype…back to the Skype (all kidding aside, this is pretty cool).  After the organization has transitioned to Skype for Business, you will benefit from:

Skype design – Skype for Business uses the same interface as Skype—if you’ve used Skype, you’re already familiar with Skype for Business.

Global reach – Voice and video connectivity to the entire Skype network.

Full Lync feature set – Because Skype for Business builds on existing Lync features, no features or functionality will be lost.

Schedule an online meeting. Make a video call. Add a new emoticon to your next IM chat. Skype for Business makes communication easy and makes you more productive. Not sure how you’ll best use it? Have a look at this video for some ideas.

Not sure about Office 365, or Lync, or Skype, or life in general?  Contact us at Simplex-IT or just call 234.380.1277 and we’ll help you out.

MS AccessIn this webcast, we will continue to look at our data that we worked with in the last webcast using Microsoft Access 2013.  In the last webcast we created tables and worked with field settings and learned how to find data in a table.  Now, we will learn how to filter in a table.  Filters are a great way to find information quickly in a database, but are not as powerful as queries.

Queries ask questions and are the guts of a database.  It’s where you get all the answers to your questions to extract useful information.  We will learn how to create queries using one or more tables in a database.  We will see how to create queries using the query wizard and work with criteria to get the information we are looking for.  We will learn how to create a calculation in a query and total a group of items, such as total sales by department, total units in stock for products.  Do you want to enter the information you are looking for in a box so you get a different outcome each time you run the query or print a report, let’s create a parameter query to do just that.  Now that you have the information you need, why not print the query.  You want the report to look nice, let’s combine the fields such as first and last name even though they were create as separate fields in a table.  You can also export the report to Word and then email it to someone even if they don’t use Access.

Yes – there is so much more to Access and really we’ve just covered a fraction of what it can do.  If you are interested in learning more, we can provide another webcast or come out and train your employees to learn how to use this powerful program.

Attend this Free webinar from Simplex-IT and possible win a copy of Microsoft Office Professional 2013!

When:  Thursday, April 9th from 11-noon (eastern)

Where:  Online

click here to:  RSVP

At Simplex-IT, we specialize in sharing our knowledge with several free webinar and Lunchinar events each month on topics such as Microsoft Office, Project Management and Data Practices.  Contact us at Info@Simplex-IT.com, Twitter (Simplex_IT), LinkedIn (http://www.linkedin.com/company/simplex-it) or FaceBook: (http://www.facebook.com/simplex.it)

Microsoft has been pretty busy over the past few months with Windows 10. A major new version was released for preview, including their version of Apple Siri (“Cortana,” from the xBox Halo).

But less fanfare has been generated for some of the decisions behind the scenes, including rather liberal upgrade paths from previous versions of Windows (including Windows phone). Also how Microsoft is going to handle software updates to Windows 10 once it’s released.

And let’s not forget about Microsoft Office. Apparently it’s also going to be released in the same timeframe (no surprise there). Also apparently it’s going to be called “Office 2016,” in spite of my ongoing belief will be getting rid of the version number sooner rather than later.

So at our next luncheon are were going to review all of these changes that Microsoft is going to be implementing over the next 9 to 12 months. We’ll also take a look (a high-altitude one) at some of the other changes that Microsoft is rolling out, including significant changes to Microsoft’s Azure(cloud-based server and infrastructure), and Microsoft rebranding of their Lync product into Microsoft Skype for Business.

As always our lunchinars are free and open to the public.  We’ll be giving away a copy of Windows 8.1 and Office Professional 2013 (courtesy of Microsoft).

When:  Wednesday, March 18, 2015 from 11:30 AM to 1:00 PM (Eastern)

Where:  Stow Hampton Inn (or online from noon to 1pm)

Click here to RSVP!

MS AccessIn this free webcast, we will look at creating and working with data in Access tables.  First we will look at how to organize and separate information into functional tables and set a primary field to identify records.  Will look at design vs. datasheet view – how to create fields in a table and understand certain rules when working with fields.  Will set the primary key field and work with different data types (such as text, numbers, dates, hyperlinks and attachments).  Did you know you can create a calculated field in a table?  We will work with data property settings, such as input masks, setting defaults and understand why you should create captions for your fields. We will use the lookup wizard to connect fields to other tables and create dropdown lists. We will also look at the relationship window to understand how to relate tables together.

Then we will look at a using the search, sorting, filtering features in a table, as well as being able to total, average, count a column of numbers.  Finally look at creating a quick form to help you enter data more efficiently into a table.

Since Access is such a powerful program and there are many parts to this software, we will cover another session next month that shows how to create queries and use criteria to extract the information you need out of your database.  And will also cover how to create a quick report to print that information.

One attendee will win a copy of Microsoft Office Pro 2013, thanks to Microsoft!

When:  March 12th, 11am-noon (Eastern)

Where:  Online

Click here to RSVP

At Simplex-IT, we specialize in sharing our knowledge with several free webinar and Lunchinar events each month on topics such as Microsoft Office, Project Management and Data Practices.  Contact us at Info@Simplex-IT.com, Twitter (Simplex_IT), LinkedIn (http://www.linkedin.com/company/simplex-it) or FaceBook: (http://www.facebook.com/simplex.it)

We’re happy to announce our February Office Webinar topic:  Visio 2013 Extras

This session is designed to cover more Visio diagrams and features.  We will learn how to create and work with your own stencils.  Create and save background pages and how to apply them to other diagrams.  Did you know you could create calendars in Visio?  How about a project timeline?  Another diagram that is useful is the brainstorming diagram, which utilizes the legend feature.  The legend can be used in a flowchart or any other diagram.

We will learn how to use the container feature.  Create layers in a diagram and import an excel spreadsheet into an organizational chart using the import function.

 We hope you can participate in this part two of “Exploring Visio” to help you with your diagrams.

Join Simplex-IT’s veteran trainer, Michele Bobola, for this one-hour, live streaming presentation.

One lucky attendee will win a copy of Microsoft Office Professional 2013, courtesy of Microsoft.

When: Thursday, February 12th, from 11am-noon

Where:  Online!

How Much?:  Free!

Click here to RSVP

Questions? Feel free to contact us by email at Events@Simplex-IT.com or call 234.380.1277.

Don’t miss this informational, free webinar brought to you by Simplex-IT – your Virtual CIO – bringing Vision, Confidence and Strategy to your Business IT!

Microsoft Excel is all about Data. But data without structure is not very useful or meaningful. That’s why you will want to tune in to this free instructional Webinar on using Excel’s Data features found on the Ribbon. In this one-hour, live streaming presentation, Simplex-IT’s veteran trainer, Michele Bobola, will show you how to use Excel’s features like: 

  • Advanced Sorting and Filtering
  • Subtotals
  • Data Validation
  • Consolidating Data
  • Data Forms
  • Combining and Separating Data
  • Flash fill
  • What If Analysis
  • Importing Data

If you would like to learn how to more effectively tame the data inside Excel to do your bidding, then check out this free Webinar on Using Excel’s Data Ribbon Features!

When: Thursday, January 8 from 11:00am-12:00 noon.
Where: Streaming Live Online

 We hope you can participate in this FREE one hour webinar. RSVP now and block out the time on your calendar.

To reserve your spot go to http://exceldata.eventbrite.com,  email John@Simplex-IT.com or call 234.380.1277.

Everyone who RSVPs will receive an email the morning of the webinar with instructions on how to log in to our webcast using Microsoft Lync (you do NOT have to have Lync installed on your computer!). So watch your Inbox!

Questions? Feel free to contact us by email at John@Simplex-IT.com or call 234.380.1277.

Don’t miss this informational, free webinar brought to you by Simplex-IT – your Virtual CIO – bringing Vision, Confidence and Strategy to your Business IT!