Learn how to use the data validation tools in Excel 2016 to control how users input data into workbooks and ensure data is entered consistently and accurately.
- Microsoft (38)
- Office 365 (19)
- Excel (10)
- PowerPoint (7)
- Word (6)
- Google (4)
- Outlook (4)
- Access (3)
- SharePoint (3)
- Apple (2)
- Excel for Mac (2)
- Google Apps (2)
- InfoPath (2)
- Acrobat (1)
- Adobe (1)
- Android (1)
- Gmail (1)
- Google Calendar (1)
- Google Drive (1)
- InDesign (1)
- iOS (1)
- iPad (1)
- OneNote (1)
- Windows (1)
- Home + Small Office (14)
- Productivity (14)
- Spreadsheets (12)
- Computer Skills (Windows) (10)
- Presentations (10)
- Word Processing (9)
- Databases (5)
- IT (5)
- Business Intelligence (4)
- iPhone, iPod, iPad (4)
- Collaboration (3)
- Data Analysis (3)
- Email (3)
- Teacher Tools (3)
- Charts + Graphs (2)
- Education + Elearning (2)
- Forms (2)
- Note Taking (2)
- Student Tools (2)
- Accessibility (1)
- Business Skills (1)
- Design (1)
- Digital Publishing (1)
- Enterprise Content Management (1)
- Office Suites (1)
- PDF (1)
- Web Conferencing (1)
Make your PowerPoint presentations more engaging by incorporating audio and video. Create multimedia presentations that wow.
Save time by automating repetitive tasks with Excel macros. Learn how to record, edit, and run simple macros, and program more complex macros with VBA.
Get tips and tricks for designing better presentations with PowerPoint 2016. Learn to format slides, create handouts, and use Excel data.
Upgrade to Office 2016. Learn how to migrate files and settings from Office 2003 and use the new features in Word, Excel, PowerPoint, and Outlook 2016.
Make the leap from Office 2007 to Office 2016, and take advantage of the latest features and performance improvements in Microsoft's popular productivity suite.
Learn how to upgrade to Office 2016 while migrating all your important files, preferences, and settings from Office 2013 intact.
Learn easy-to-use commands, features, and functions for managing and analyzing large amounts of data in Excel 2016.
Learn to create different kinds of Excel charts, from column, bar, and line charts to doughnut and scatter charts, with Excel for Mac 2016.
Create a better user experience for your Access users. Transform a boring database into a fast, efficient, and even fun environment.
Upgrading Office? Get used to the new interface and latest features in Office 2016, including Word, Excel, PowerPoint, and Outlook.
Learn how to quickly feed real-time data from an API directly into Excel using WEBSERVICE and FILTERXML functions, enabling powerful insights and real-time analytics.
Learn how to use Access forms and reports to control and organize the display of your data, create data entry points and menus for your users, and publish reports.
Get started using SharePoint 2016 for business collaboration and real-time documentation sharing. Find out how to save and share documents, create team sites and site collections, work with libraries and list apps, add and modify apps, manage permissions, and create simple workflows.
Become a Microsoft Office Specialist in SharePoint. Study for the SharePoint 2013 MOS exam.
Learn how to craft better queries—the key to finding raw data and transforming it into something usable—in Access 2016.
Master Excel formulas and functions—once and for all. Get tips for using the most challenging of the 450+ functions in Excel for Mac 2016.
Become a Microsoft Office Specialist. Study for the OneNote 2013 MOS certification exam online. This MOS certification training covers the four exam areas and includes a full-length practice test.
Become an Office Specialist by passing the MOS Excel 2013 certification exam. This training covers the five exam objectives—worksheets and workbooks, cells and ranges, formulas and functions, and charts and other objects —and includes a full-length practice test.
Take the rich features and productivity power of Word, Excel, and PowerPoint on the go with Office for iPad and iPhone.
Get going with the mobile version of Office 2016, optimized for the Windows 10 touch interface.
Get started with the new Office for Android suite.
Get started with the new Office for iOS suite.
Learn about the suite-wide enhancements in Office 2016 and Office 365, as well as program-specific new features in Word, Excel, PowerPoint, and Outlook.
Make your content readable to everyone! Learn how to create valid, accessible PDFs that can be read by screen readers and users of other assistive technology, using Word, Excel, PowerPoint, InDesign, and Acrobat DC.
Learn everything you need to know to smoothly migrate from Office 2010 to Google apps.
Learn everything you need to know to smoothly migrate from Office 2013 to Google apps.
Use Office shapes and SmartArt to spice up such business docs as presentations, fliers, conceptual graphics, and even Venn diagrams, org charts, and more.
Learn how to convert and migrate documents, email, spreadsheets, and presentations from Google to Office, and start using the unique features in Word, Excel, PowerPoint, and Outlook.
Get a new Microsoft Office tip every Tuesday. Take a five-minute break to improve your productivity and efficiency.
Upgrading from Office 2007 to Office 2010? Get used to the new interface, and explore the latest features in Word, Excel, PowerPoint, and Outlook.
Upgrading from Office 2010 to Office 2013? Get used to the new interface and touch controls, and explore the latest features in Word, Excel, PowerPoint, and Outlook.
Upgrading from Office 2007 to Office 2013? Get used to the new interface and touch controls, and explore the new features in each of the major application: Word, Excel, PowerPoint, and Outlook.
Discover the new Office for iPad applications: Excel, PowerPoint, and Word.
Create and publish sophisticated electronic forms using the latest version of the Microsoft form-creation tool InfoPath.
Take a look at suite-wide enhancements like cloud integration, Touch Mode, PDF editing, and Ribbon customization, as well as individual app improvements added to Office 2013.
A tour of the most anticipated updates and new features in Office 2013, now available as a public customer preview release.
Shows how to create and publish sophisticated electronic forms using InfoPath 2010.
“lynda.com has enabled me to grow my skill set at an affordable price. I find the business profiles/documentaries inspiring and the training is top notch.” —Shawn C.
more from our members »