Learn it fast with expert-taught software and skills training at lynda.com. See what you can learn

By Doug Winnie | Wednesday, November 12, 2014

Review: The Microsoft Band Fitness Tracker and Smart Watch

The Microsoft Band has a lot of cool features.

Microsoft recently released the Microsoft Band, a fitness tracker and smart watch device. What makes it unique in a crowded and growing market for digital lifestyle wearables?

The Band has some impressive features, but comes with some bulk and awkwardness in fit. Let’s take a look.

By Nick Brazzi | Monday, November 03, 2014

Find Out What's Brand New in Outlook for Mac

The new Outlook for Mac looks much the same as the old

Microsoft has just released an all new version of Outlook for Mac, the productivity application for managing email, calendars, address books, and more—and we’ve got a first look course ready to get you up and running with this new version.

The course will be useful for new users. But if you’re upgrading from Outlook 2011, this transition is going to be really easy for you; the new version of Outlook for Mac has barely changed at all compared to Outlook 2011.

By Jess Stratton | Tuesday, May 28, 2013

Monday Productivity Pointers: Collaborating with SkyDrive

SkyDrive is a free collaboration product from Microsoft that helps you store and synchronize digital files across your desktop and mobile devices. With SkyDrive, you’ll get 7 gigabytes of space for storing your files, photos, and important assets, which can then be accessed from either a web browser or native applications on your desktop, tablet, or smartphone.

In this week’s first Monday Productivity Pointers video, I show you how to use SkyDrive directly within Microsoft apps like Windows 8 and Office 2013, and also work on new documents directly in your web browser. With your SkyDrive account, you’re also entitled to use the Microsoft Office Web Apps—online versions of Word, PowerPoint, and Excel—for free!

By Madeline Simmons | Friday, March 01, 2013

What is the difference between Office 365 and Office 2013?

Microsoft recently launched the new Office 365 as well as Office 2013. You are not alone if the various products have created confusion for you.

To clarify, Office 365 refers to the subscription models for Office, not a specific version, and it delivers the Office programs as part of your subscription. With online storage, sharing and syncing with the Microsoft cloud, Office 365 has features to make it easier for teams to collaborate and communicate with familiar applications like Word, Excel, and PowerPoint.

If you subscribe to Office 365 and are running Office on a Windows 7 or Windows 8 machine, you will see Office 2013 as your user interface. This means if you are a subscriber to Office 365, the lynda.com courses titled with version 2013 will be relevant and helpful for you. Microsoft is expected to push out updates to Office 365 on a quarterly basis, so over time we expect greater differences between these offerings. Rest assured, we are working to address the anticipated divergence between Office 365 and Office 2013 in our future training courses.

Suggested courses to watch next:

• Office 2013 New Features • Up and Running with Office Web Apps • Excel 2013 Essential Training

By Juliana Aldous | Monday, February 18, 2013

Getting to know Office 2013 and Office 365

Now that Microsoft has officially launched Office 365, we’d like to introduce you to our lineup of new Office training content.

You can use our new playlist feature to create your own personalized Office learning path. First determine which version of Office you’ll be using: Will you be starting with the cloud-based subscription Office 365? Or will you be taking the more traditional route with Office 2013? Note: if you are running Office 365 on a Windows 7 or 8, your version of Office will have the new features of Office 2013.

If you’re unfamiliar with the new Microsoft subscription model, I would suggest adding both David Rivers’s Up and Running with Office 365 and Curt Frye’s Up and Running with Office Web Apps to your playlist. David’s course introduces the Office 365 subscription model and how it works. Curt’s course takes you into the individual applications like Word, Excel, PowerPoint, and OneNote.

The best course to start with to get an overall view of the latest Office features is David Rivers’s Office 2013 New Features. David walks you through the major applications in the suite: Word, Excel, PowerPoint, Access, Publisher, OneNote, and Outlook. Get a peek at integrating Office with the cloud. David covers the changes to the user interface, key new features, and product enhancements.

Figure 1 David Rivers shows you the suite.

David Rivers shows you the suite.

Figure 2 David Rivers takes you through the changes in Office 2013.

David Rivers takes you through the changes in Office 2013.

Figure 3 David Rivers shows you how to use SkyDrive with Office 2013.

David Rivers shows you how to use SkyDrive with Office 2013.

Once you’ve watched Office 2013 New Features, you’ll probably be ready to dive into your favorite Office application. We have more coming over the next few weeks, but to start you off we have Essential Training courses ready for SharePoint, Excel, Word, Access, Outlook, and PowerPoint.

If you use SharePoint, start off with Gini Courter’s SharePoint Foundation 2013 Essential Training. The Essential Training covers all the basics and features. You’ll also get a deeper look at how SharePoint integrates with all the Office applications.

Excel 2010 Essential Training has been one of our most highly viewed courses. Dennis Taylor takes you through all the basics from organizing your data to working with formulas, worksheets, pivot tables, and charts in Excel 2013 Essential Training.

Next up is David Rivers’s Word 2013 Essential Training. Learn the basics of creating and editing documents, using templates and building blocks, sharing and collaborating in documents, and working with tables.

If Access is more your thing, then take a look at Adam Wilbert’s course on Access 2013 Essential Training. Adam demonstrates how to create and work with tables, forms, reports, and macros and how to use that data in other Office applications such as Excel and Word.

Our newest staff author and productivity guru, Jess Stratton, has two Essential Training courses for you: PowerPoint 2013 Essential Training and Outlook 2013 Essential Training. In PowerPoint 2013 Essential Training, Jess shows you the basics of creating, editing, working with, and sharing presentations. In Outlook 2013 Essential Training, Jess gives you a tour of the interface and teaches you how to create, send, organize, and read mail; use contacts; leverage productivity with tasks and notes; and manage your day with Outlook.

Keep an eye on our new release list for more.

Interested in more?

• All lynda.com Office courses • All lynda.com Business courses

By Mark Niemann-Ross | Friday, October 26, 2012

What is Windows 8 going to change?

The user interface for Windows 8 blurs the line between tablet, desktop, and smartphone. That’s a good thing.

The Microsoft Build conference starts October 30. For a week developers will be exposed to the latest Windows technologies, analysts will write megabytes of blogs, pundits will tweet reactions both pro and con, and the way we experience computers will change in dramatic and obvious ways.

The new Windows 8 interface

For developers and users alike, the Windows 8 interface is an in-your-face change. No longer based around overlapping windows and desktops, information and applications are now presented as colored tiles. It is possible to slip back into the traditional Windows interface where each running application is visually separated with windows that can be dragged on top of each other, hidden, and closed; but most of the time the new Windows looks, and functions, very much like a well-designed webpage.

Opinions are harsh. Windows traditionalists miss familiar icons such as the Start menu, Control Panel, File Explorer, and Close button, and are finding the years they spent deciphering the nuances of utilities to now be irrelevant and useless. Worse, users stumble into the traditional Windows interface, but have no idea how to return to the new tiled interface, and developers find creating applications now requires new ways of programming, use of new interfaces, and new ways of thinking about interacting with users. What was Microsoft thinking?

DOS to Windows, windows to tiles, desktop to phone In 2011, computer vendors shipped more smartphones than desktop computers further supporting the idea that handheld devices—such as smartphones and tablets—are pushing desktop and laptop computers into obsolescence. Apple and Android are battling for first place, with Microsoft scrambling for a piece of the action. Dell, the king of laptop manufacturers, has lost almost half of its value in eight months. The future is painfully clear, and it looks like a handheld device, or smaller.

Microsoft correctly reasons that making improvements to an interface that depends on a keyboard and mouse is corporate suicide, but what about our former Windows Vista user futilely searching for the Windows Start button? Is there nothing to be done for them?

Short answer: The pain is only temporary.

Long answer: We’ve done this before. New interfaces, like apps or tiles, are simply normal innovation. They’re disruptive, sometimes annoying, and the first iteration is often clumsy, but the process is normal, expected, and necessary.

lynda.com is working on a collection of classes for developers and users of Windows 8. In the early part of 2013, you can expect to see courses that show how to get started with the Windows 8 developer tools, as well as more in-depth training intended to assist with advanced developer questions.

Nobody on Star Trek uses a mouse Science fiction explores a possible future, and most science fiction computers don’t use keyboards or mice; they use gestures and voice recognition. Our grandchildren will think our computers are quaint.

Personally, I have enough years under my belt to remember the jump from CPM, to DOS, to Windows 3, and the jump from my beloved Apple IIe to Macintosh OS X. Each was a move away from a known paradigm to something better. Everything changed for the traditionalists invested in the existing technology, and boy, did they complain.

But the number of people using the new tools soon outweighed the traditionalists. New users with curiosity about how the system does work, rather than assumptions about how the system should work took over.

Here’s to a lifetime of learning!

Interested in more? • The full Windows 8 Preview First Lookcourse on lynda.com • All operating systems courses on lynda.com

Suggested courses to watch next:Windows 8 Metro App First Look • Windows 7 Essential TrainingMigrating from Windows XP to Windows 7

By Bonnie Bills | Sunday, October 31, 2010

Office 2011 for the Mac video training now available

Office for Mac 2011 is now available, and it is a step forward for Microsoft’s suite of office productivity apps for Mac users. Notable features include a new-to-the-Mac Ribbon interface, which creates a more seamless experience for folks who also use Office 2007 or Office 2010 for Windows, the brand-new Cocoa-based Outlook for the Mac, and reinstated Visual Basic for Applications (VBA) support. If you’re upgrading from Office for Mac 2008, or new to Office for the Mac, lynda.com has comprehensive training on the suite’s four main apps.

Excel for Mac 2011 Essential Training Course TrailerIn Excel for Mac 2011 Essential Training, Curt Frye covers the ins and outs of Excel for the Mac, including features borrowed from the Windows version like Sparklines for easy data visualization, enhanced Pivot Table reports, and the ability to automate workbooks with macros.

PowerPoint for Mac 2011 Essential Training Course TrailerIn PowerPoint for Mac 2011 Essential Training, David Rivers gives in-depth tutorials in PowerPoint 2011, including using and customizing the new Ribbon, editing photos within PowerPoint, and broadcasting presentations over the web. The course also provides detailed instructions for changing the look of presentations: using built-in and custom themes, formatting text, inserting tables and charts, adding pictures and SmartArt drawings, and adding animation.

Word for Mac 2011 Essential Training Course Trailer In Word for Mac 2011 Essential Training, Maria Langer shows how to build outlines, format text and pages, work with headers and footers, use themes and styles, add multimedia, and more. It also shows how to customize and automate Word 2011, including how to record macros.

Outlook for Mac 2011 Essential Training Course TrailerAnd in Outlook for Mac 2011 Essential Training, Alicia Katz Pollock offers complete coverage of the long-awaited Entourage replacement, including migrating from other email applications, setting up IMAP, POP, and Exchange accounts, syncing Address Book contacts, and taking advantage of organizational features like Conversation View and My Day.

By Bonnie Bills | Thursday, July 08, 2010

Office 2010 for Business: Focus on Access

lynda.com has been rolling out courses on Office 2010 since the suite launched in May, and there are already more than 50 hours of Office 2010 training in the lynda.com Online Training Library® covering all the core applications and SharePoint! I have been talking with our incredibly talented and enthusiastic group of Office 2010 authors about their experiences with this latest version. Today’s Q&A, the last in the series, features Alicia Katz Pollock, author ofAccess 2010 New Features, Access 2010 Essential Training, and Access 2010 Real World Projects.

Q: Access 2010 is touted as a simple product that you can use even if you’re not a database expert. What features can inexperienced users take advantage of to get up and running with Access?

A: While getting started with Microsoft Access isn’t as easy as sitting down and typing a document in Word, Access provides you a variety of tools to get started building your own database solution. First, take advantage of the sample database templates, such as the contact management tools. If you’re starting from scratch, Access’s Application Parts and Quick Start menus have predesigned tables and forms to provide the most common fields and configurations. And last, a new feature is that field data types and validation options are now available right on the Ribbon so you can easily see them and take advantage of proper database techniques.

Q: An issue most businesses wrestle with is how to get data out of databases and into the hands of busy managers in a format they can use and understand. What kind of tools does Access 2010 have for presenting data to the decision makers who need to act on it?

A: It’s easy to create an attractive, modern-looking report just by clicking a few buttons. Click on a table or a query containing the information you want on the printed report, and click the Report button. Voilà, a report ready to send to the printer. And if you want more control, including subtotals or your logo, click on the Report Wizard and answer its questions. Once you’re done, you can further refine the appearance by dragging the reports table cells to rearrange and resize them. Last, if you need the data moved into another data reporting tool, it’s easy to export into .xls, .csv, .txt, .xml, and .html using the Data ribbon.

Q: For users migrating from Access 2003 to Access 2010, they’ll have a new interface experience. What can you tell folks who might be nervous about the Ribbon interface? How has the Ribbon improved from 2007 to 2010?

A: The Ribbon is one of the best things to ever happen to Microsoft Office. In fact, when Microsoft polled users about what features they wanted to see, 90 percent of them were already in the program, but buried three menus deep. The Ribbons give you instant access to just about every feature in the program, yet are nice to look at and easy to understand.

One of the best Ribbon improvements from 2007 to 2010 is that they unburied all your table-building tools, so that you don’t have to go into Design view to use techniques like data types and validation rules.

Q: What’s your favorite feature in Access 2010 and why?

A: My favorite feature in Access 2010 is the new Record Validation tool. You’ve always been able to determine if acceptable data was entered into one field, but now you can compare data within two fields in a record to make sure your data was entered correctly. For example, you can now confirm that the “End Date” is after the “Start Date.” For us nitpicky data analysts, that brings comfort and security.

But on second thought, my favorite feature may just be the new and improved Macro builder interface. You no longer have to know code to build macros!

Get the latest news

  •   New course releases
  •   Pro tips and tricks
  •   News and updates
  
New releases submit clicked

You can change your email preferences at any time. We will never sell your email. More info

Featured articles

A lynda.com membership includes:

Unlimited access to thousands of courses in our library
Certificates of completion
New courses added every week (almost every day!)
Course history to track your progress
Downloadable practice files
Playlists and bookmarks to organize your learning
Become a member

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.