Courses
Get a thorough introduction to Microsoft's hosted collaboration and productivity suite. Author David Rivers tours the subscription service, showing how to administer user accounts; share Word, Excel, PowerPoint, and OneNote files with SharePoint; and manage mail, contacts, and calendars with the Outlook web app. The course also explains how to set up Office desktop apps to work with Office 365 and connect with colleagues using the Lync communication server.
In this course, author and Office expert Curt Frye shows how to create, edit, and share Microsoft Word, Excel, PowerPoint, and OneNote documents online with Office Web Apps. Each chapter addresses one of the programs, highlighting which features are available online and how they differ from the desktop versions. The course also includes information on integrating the Office Web Apps with SkyDrive and mobile, sharing online documents with other users, and embedding documents in web pages.
Have you ever wanted to get employee or client feedback quickly, without having to print and collect forms? In this course, author David Rivers shows how to create surveys online, while explaining when surveys are useful and how they can help collect the input needed to drive key business decisions. The course also gives an overview of top online survey tools, including SurveyMonkey, Google Forms, QuestionPro, and SurveyGizmo. The final chapter shows how to use SurveyMonkey to create a survey from start to finish, as well as smart ways to collect more responses.
Find out how to build and package native device applications using Adobe PhoneGap and web technologies such as HTML, CSS, and JavaScript. This course shows how to access the sensors and other capabilities of mobile devices through JavaScript coding, and build applications that reuse most of their code for deployment to iOS, Android, BlackBerry 6, and other mobile operating systems. Author Ryan Stewart shows how to get started with PhoneGap, including installing and setting up the software development kit (SDK), building a simple application from templates, using the most popular APIs like Geolocation and Storage, integrating jQuery Mobile and other JavaScript frameworks, and testing and debugging your app.
Pinterest is a social media tool that allows you to bookmark content around the web in a visually pleasing arrangement. In this course, author Justin Seeley illustrates the basics of setting up and managing a Pinterest account and explores ideas for finding inspiration. Fill out your profile, add friends, and start pinning. Discover how to share activity on Facebook and Twitter, add your own image and video pins, and plan for activities like a wedding or vacation. The course also covers pinning on the go with the iOS and Android apps.
In this course, author and sought-after presenter Lisa Larson-Kelley introduces Prezi, a cutting-edge tool for creating dynamic presentations. Discover how to add layers of meaning to static presentations with multimedia, spatial relationships, and movement. The course demonstrates the features and benefits of an effective Prezi presentation, shows how to navigate the user interface, and explains how to create, animate, share, and publish a prezi. Plus, Lisa shows how to present your prezi to a remote audience, via a web browser or your desktop.
Join author Barton Poulson as he introduces the R statistical processing language, including how to install R on your computer, read data from SPSS and spreadsheets, and use packages for advanced R functions. The course continues with examples on how to create charts and plots, check statistical assumptions and the reliability of your data, look for data outliers, and use other data analysis tools. Finally, learn how to get charts and tables out of R and share your results with presentations and web pages.
In this course, author Justin Seeley shows how to share content quickly and easily using the Tumblr microblogging platform. The course walks through creating an account, setting preferences, choosing a theme, and adding Facebook and Twitter integration, as well as creating audio, video, and text posts; building custom themes with CSS and HTML; and publishing posts remotely. The course also covers working with pages, creating page templates, and tracking blog traffic with Google Analytics.
Enhance productivity by automating routine tasks and providing custom functionality not built into Access with a few basics in VBA code. Author Curt Frye introduces object-oriented programming and provides database designers with a foundation in the Access object model and the Visual Basic for Applications (VBA) programming language. The course covers automating tasks with macros, working in the Visual Basic Editor, writing functions, adding logic, reading data, controlling forms, and more.
In Up and Running with VBA in Excel, Excel and VBA expert Curt Frye introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance Excel performance and efficiency. This course introduces the Visual Basic for Applications programming language, covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel 2007 object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course.