Digitial Literacy

We rely on technology and various software programs for our day-to-day work, but the systems we use change regularly and sometimes it can be challenging to keep up with the most up-to-date versions. The Center for Professional Development has coordinated this Digital Literacy track to assist faculty and staff in staying current with the systems they are using. 
 
This track is comprised of in-person courses, as well as courses found on lynda.com. The courses from lynda.com are all labeled in the title. There are also a many of other courses available in lynda.com that can support your work. Please browse their library to see if there are other courses that would be meaningful for you as we selected a small sample to use for this track.

Excel

Topics:
Intro to Chart Terminology
o Data Point vs. Data Series
o Axes
o Legend
o Plot Area
o Structuring worksheet data for charting
Creating a Chart
o As a New Sheet
o As an Embedded Chart
o Selecting Contiguous Cells
o Selecting Non-Adjacent Cells
Modifying a Chart
o Changing Chart Type
o Changing Chart Layout
o Changing Chart Styles
o Changing Source Data
▪ Viewing same data as different types of charts.
o Adding and Modifying Layout Elements of a Chart
▪ Data Labels
▪ Axis Labels
Formatting Charts
o Selecting Individual Elements of a Chart
o Text and Number Formatting
o Fill and Border Formatting

2-D Charts (X, Y Axis)
o Formatting and Modifying:
▪ Scale
▪ Trendlines
▪ Switching Rows and Column Data
3-D Charts (X, Y, Z Axis)
o Formatting and Modifying:
▪ Rotation
▪ Perspective
▪ Elevation
Adding Sparklines to a Data Range (Excel 2010 only)
o Line
o Columns
o Win-Loss
Saving Chart as a Template, and setting as default chart type.
Using Charts with Other Applications
(Word, PowerPoint, PDF, etc.)
o Copying
o Linking
o Updating
 

Upon successful completion of this course, individuals will be able to create dashboards in Microsoft Office Excel 2013. 

Individuals will: 
•Create advanced formulas.
•Automate workbook functionality.
•Apply conditional logic.
•Visualize data by using basic charts.
•Implement advanced charting techniques.
•Analyze data by using PivotTables, slicers, and PivotCharts.

This is a two part program. In order to receive credit, participants must attend: 

April 17th, 2018 & April 24th, 2018 from 1:00 p.m. to 4:30 p.m.

In this course, participants will use Microsoft® Office Excel® 2013 to create spreadsheets and workbooks that they can use to store, manipulate, and share data.
Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. 
You will: 
•Get started with Microsoft Office Excel 2013
•Perform calculations
•Modify a worksheet
•Format a worksheet
•Print workbooks
•Manage workbooks

This course is a two part session. In order to receive credit you must be able to attend: 

 January 23rd, 2018 & January 30th, 2018 from 8:30 a.m. - 12:00 p.m.

OR

March 20th, 2018 & March 27th, 2018 from 8:30 a.m. - 12:00 p.m.

OR

April 17th, 2018 & April 24th, 2018 from 8:30 a.m. - 12:00 p.m.

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. 
In this course, you will: 
•Customize the Excel environment
•Create advanced formulas
•Analyze data by using functions and conditional formatting
•Organize and analyze datasets and tables
•Visualize data by using basic charts
•Analyze data by using PivotTables, slicers, and PivotCharts

This course is a two part session. In order to receive credit you must be able to attend: 

March 20th, 2018 & March 27th, 2018 from 1:00 p.m. - 4:30 p.m.

COURSE OUTLINE

1 - PREPARING DATA AND CREATING PIVOT TABLES

Prepare Data

Create a PivotTable from a Local Data Source

Create a PivotTable from Multiple Local Data Sources

Create a PivotTable from an External Data Source

2 - ANALYZING DATA USING PIVOTTABLES

Summarize PivotTable Data

Organize PivotTable Data

Filter PivotTable Data

Format a PivotTable Refresh and Change PivotTable Data

3 - WORKING WITH PIVOTCHARTS

Create a PivotChart

Manipulate PivotChart Data

Format a PivotChart

In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.

Topics include:

  • Copying and pasting techniques
  • Working with formulas and functions
  • Dealing with formula errors
  • Creating lookup tables
  • Naming cell ranges
  • Formatting data and worksheets
  • Finding and replacing data
  • Creating SmartArt diagrams
  • Creating charts and PivotTables
  • Recording macros
  • Sharing workbooks

Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.

Topics include:

  • What is Excel and what is it used for?
  • Using the menus
  • Working with dates and times
  • Creating simple formulas
  • Formatting fonts, row and column sizes, borders, and more
  • Inserting shapes, arrows, and other graphics
  • Adding and deleting rows and columns
  • Hiding data
  • Moving, copying, and pasting
  • Sorting and filtering data
  • Printing your worksheet
  • Securing your workbooks
  • Tracking changes

Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data.

Topics include:

  • Creating a PivotTable
  • Summarizing multiple data fields
  • Managing subtotals and grand totals
  • Grouping PivotTable fields
  • Filtering with selections, rules, slicers, and search filters
  • Applying PivotTable styles
  • Formatting cells
  • Creating PivotCharts
  • Enabling PowerPivot
  • Using DAX operators
  • Visualizing data with matrices, cards, and tiles
  • Building charts and maps

Visualize data and get new insights into your information with Excel's charts and graphs. Learn how to create and modify charts, graphs, tables, and SmartArt to enhance your spreadsheets or other Office documents. This course covers all of the essential features needed to get up and running with these valuable Excel tools.

Topics include:

  • Creating a chart
  • Picking a chart type
  • Displaying data with tables
  • Editing data in a chart
  • Adding SmartArt graphics

 

Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.

Topics include:
  • Working with the Excel interface
  • Entering data
  • Creating formulas and functions
  • Formatting rows, columns, cells, and data
  • Working with alignment and text wrap
  • Adjusting rows and columns
  • Finding and replacing data
  • Printing and sharing worksheets
  • Creating charts and PivotTables
  • Inserting and deleting sheets
  • Using power functions such as IF and VLOOKUP
  • Password-protecting worksheets and workbooks
  • Sorting data
  • Analyzing data with Goal Seek and Solver
  • Creating and running macros

Excel expert Dennis Taylor helps Excel 2016 users take their spreadsheet skills to the next level with this collection of tips and tricks. He begins with his top 10 productivity boosters, and then highlights navigation, display, and selection techniques to keep you moving quickly.

The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "10 Tiny Tips" chapter for a quick productivity boost.

Topics include:
  • Entering today's date or time instantly
  • Converting formulas to values with a simple drag
  • Undoing and redoing with keyboard commands
  • Accessing the Ribbon from the keyboard
  • Creating split screens fast
  • Navigating in workbooks quickly
  • Selecting noncontiguous ranges
  • Entering data more efficiently
  • Dragging and dropping data
  • Performing calculations without formulas
  • Applying formatting with keyboard shortcuts
  • Using database techniques to work with Excel data
  • Working with charts, shapes, and linked images

Excel expert Dennis Taylor demystifies some of the most useful of the 450+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic functions (SUM, AVERAGE, and MAX), and a few critical keyboard shortcuts that will let you locate and display formula cells and accelerate working with Excel formulas—even on multiple sheets. He then covers how to find and retrieve data with the VLOOKUP and INDEX functions, calculate totals with counting and statistical functions, extract data with text functions, and work with date, time, array, math and information functions. The course focuses on practical examples that will help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios.

Topics include:
  • Displaying and highlighting formulas
  • Converting formulas to values
  • Tabulating data from multiple sheets
  • Understanding the hierarchy of operations in formulas
  • Using absolute and relative references
  • Creating and expanding nested IF statements
  • Looking up information with VLOOKUP, MATCH, and INDEX
  • Using the powerful COUNTIF family of functions
  • Analyzing data with statistical functions
  • Calculating dates and times
  • Analyzing data with array formulas and functions
  • Extracting data with text function

Charts allow you to communicate information visually, in a way that's more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. In Excel 2016, there are six brand-new chart types to learn. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. Learn how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources. Plus, get an overview of the new chart types in Excel 2016: Treemap, Sunburst, Waterfall, Histogram, Pareto, and Box & Whisker.

The training wraps up with lesson on changing data sources for charts and printing and sharing charts.

Topics include:
  • Identifying chart elements
  • Selecting the right chart type
  • Creating basic charts
  • Creating sparklines
  • Styling charts
  • Moving and resizing charts
  • Modifying axes
  • Adding labels and gridlines
  • Analyzing data with trendlines
  • Inserting pictures, shapes, and text boxes
  • Customizing column, bar, line, and pie charts
  • Creating Gantt charts and other specialized Excel charts
  • Changing data sources
  • Printing and sharing charts

Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016. Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.

Topics include:
  • Formatting data for use in a PivotTable
  • Creating a new PivotTable
  • Connecting to data sources
  • Consolidating data from multiple data sources
  • Creating calculated fields
  • Summarizing field data
  • Sorting and filtering PivotTables
  • Working with Excel slicers
  • Formatting PivotTables with styles and formats
  • Applying conditional formats
  • Creating PivotCharts
  • Printing PivotTables
  • Running macros
  • Creating a PivotTable using the data model

Email Management

Tired of being overwhelmed by your email? Are you using your inbox as a “to-do list”, a contact manager, a calendar, or a filing cabinet? How many emails do you have in your inbox – 100…250…500…more than 1,000? If so, you aren’t alone! Learn how to properly manage your email so that you can enjoy the benefits of this great tool. Get control of your email so that it doesn’t control you!

During this session, you will learn:

  • The proven secrets of managing email
  • Who contributes to the email overload
  • The 5 misuses of an inbox
  • The golden rule of managing email
  • Disadvantages of a full inbox
  • 5 steps for clearing out an overloaded inbox
  • Strategies for incoming email management
  • 3 tips for significantly reducing spam
  • Strategies for managing outgoing emails including 4 options for directing email traffic
  • 5 tips to improve overall performance, processing, maintenance and more!

All registrants will receive course notes, Tips, Tools and Techniques for Managing Email, a 21 page how-to tip sheet and a Next Step Guide which contains a step-by-step strategy for getting your email under control.

By attending the Escape the Email Vortex session, you will learn how to create and maintain a proven strategy for cleaning out your inbox. You will have the ability to control your “email ecosystem” instead of allowing it to control you!

This session is best suited for MS Outlook users on a Windows operating system.  It will not include information on the MS Outlook Web App, (RIT's mymail system.)

Get a handle on your inbox. Learn to streamline your Outlook 2016 workflow with tips, strategies, and techniques for reviewing and organizing email. Gini Courter shows how to use views to rearrange and sort email, organize email with folders and categories, and use rules and Quick Steps to automate many common tasks. With these techniques, you'll cut down on the time and energy you spend on email every day.

Topics include:
  • Viewing messages by conversation
  • Ignoring a conversation
  • Using Mailbox Cleanup
  • Arranging email by date or by sender
  • Sorting and filtering views
  • Creating inbox folders
  • Customizing and using categories
  • Using a custom search folder
  • Creating Quick Steps and email rules
  • Using automatic replies

In Outlook 2010 Essential Training, author Karen Fredricks provides in-depth instruction on the key features of Outlook 2010. The course shows how to master fundamental Outlook features including sending and receiving email, creating an address book, and scheduling activities and tasks. It also covers basic administrative tasks including backing up the data file, setting up email accounts, and organizing data both manually and automatically.

Topics include:

  • Using the Office 2010 Backstage View
  • Using and customizing the Office 2010 Ribbon
  • Using Outlook as an email client
  • Filtering email with Quick Steps
  • Scheduling with multiple calendars
  • Creating tasks for to-do items
  • Taking notes
  • Adding multiple addresses and phone numbers for contacts
  • Reading blog posts
  • Integrating with social networking sites

 

Be more productive in Outlook. In Outlook 2013: Efficient Email Management, author Gini Courter demonstrates techniques to streamline your Outlook workflow. The course offers tips, strategies, and techniques for reviewing email, using views to rearrange and sort email, organizing email with folders and categories, and using rules and Quick Steps to automate many common tasks.
 

Topics include:

  • Viewing messages by conversation
  • Ignoring a conversation
  • Tagging messages with flags and categories
  • Arranging email by date or by sender
  • Creating inbox folders
  • Customizing and using categories
  • Creating a search folder
  • Creating Quick Steps and email rules

Learn how to best set up and manage email, calendars, and contacts in Outlook 2016. This course begins with a tour of the interface and shows how to connect to a wide variety of email accounts, as well as OneDrive for online file storage. Author Jess Stratton then shows how to quickly create, send, and read email and reduce your inbox clutter; organize, group, and share contacts; and stay on schedule with calendars and tasks. Plus, learn how to back up your Outlook data in case you need to restore or move it to a different machine.

Topics include:
  • Connecting accounts: Exchange, Office 365, IMAP, and POP
  • Searching for mail
  • Saving attachments
  • Organizing mail with flags and folders
  • Creating new messages
  • Working with contacts in the People hub
  • Adding delegates to act on your behalf
  • Creating meetings
  • Creating tasks and notes
  • Backing up and moving Outlook data

Learn how to set up and navigate email, calendar, and contacts in Outlook for Mac 2016. The course begins with a tour of the interface and shows how to connect to Office, Exchange, IMAP, and POP email accounts. Author Jess Stratton then shows how to quickly create, send, and read email as well as reduce your inbox clutter. Also see how to best organize, group, and share contacts, and stay on schedule with calendars and tasks.

Topics include:
  • Adding email accounts
  • Reading mail
  • Saving attachments
  • Searching mail
  • Organizing mail with folders, flags, and filters
  • Creating mail rules
  • Adding signatures
  • Setting an out-of-office auto-responder
  • Creating new contacts and groups
  • Working with delegates
  • Creating meetings
  • Opening other calendars
  • Creating tasks

Learn how to use the robust calendar and task management capabilities of Outlook 2016 to manage your personal and professional schedules. Author Gini Courter explains the difference between Outlook tasks and to-do lists, and shows how to use Outlook 2016 to make appointments, complete tasks, and find and organize your high-priority items. She also shows how to use built-in and custom Quick Steps to automate common or repetitive tasks, and use flags to follow up on important tasks. With these tips and techniques, you'll spend less time planning your schedule, and more time working on what matters most.

Topics include:
  • Managing your time with Outlook 2016
  • Creating an appointment or event
  • Inviting others to meetings
  • Creating recurring meetings
  • Flagging email
  • Creating tasks and to-do items
  • Applying categories
  • Using built-in Quick Steps
  • Completing a task and sending an update
  • Setting calendar and task list options

Social Media

Learn how to set up a Facebook account exclusively for business use and build out your page in a way that promotes your brand. In this series of videos, author Brad Batesole also shows how to craft and post interesting content, and identifies winning strategies for building and maintaining a thriving community of Facebook fans.

This course, revised for 2015, includes detailed information on creating ads and boosted posts, and shows how to use Facebook Insights to track your reach, page visits, and even the performance of your competitors. Brad Batesole also shows how to update your page on the go with the Facebook Pages Manager app, and tie your Facebook page to Twitter.

Topics include:

  • Planning your page
  • Engaging your community with status updates, photos, and video
  • Creating events and scheduling posts
  • Pinning and embedding posts
  • Moderating comments on your page
  • Creating a boosted post
  • Creating advertisements
  • Using Insights to track likes, post reach, page visits, and more
  • Adding page administrators
  • Linking to Twitter

 

Develop, implement, and optimize a winning Google+ presence for your business, in these tutorials with marketing expert Anson Alexander. Anson explains why Google+ is so crucial to businesses and then shows all the components that go into setting up a great Google+ business page.

Learn about this social media platform's unique conventions, including Google+ circles, communities, Events, and Hangouts, and then find out how to develop engaging posts. Anson also shows how to measure visibility and engagement to determine your brand's audience, and then maximize exposure with rich media, branded vanity URLs, YouTube integration, and more.

Topics include:

  • How Google+ will help your business
  • Creating a Google+ account and business page
  • Understanding circles and Hangouts
  • Sharing posts
  • Interacting with Google+ comments
  • Using Google+ Insights
  • Managing reviews
  • Connecting to a YouTube account

Find out what business opportunities await on Instagram. In this course, Anson Alexander shows how to get started using Instagram to increase your sales, brand recognition, and online presence. He'll cover the basics like choosing photos, hashtags, and filters and creating a posting schedule, as well as more advanced tricks like integrating Instagram with your website, Facebook feed, or blog. Plus, learn how to measure and track success of posts, so you can find out what content is gaining traction with which followers.

Topics include:

  • Business opportunities on Instagram
  • Brainstorming content ideas
  • Developing a posting schedule
  • Optimizing your Instagram profile
  • Interacting with the Instagram community
  • Using business-appropriate filters and hashtags
  • Adding Instagram photos to your website or Facebook
  • Measuring the success of your Instagram posts

 

reddit, the "front page of the Internet," is a popular news aggregator that anyone can contribute to: by asking questions, providing answers, engaging in debates, or simply posting links to interesting content. In this course Nick Brazzi explains how reddit works, how it is organized, and how you can set up an account to contribute to the community. He covers both the web-based and mobile platforms, demystifies common reddit abbreviations and jargon, and shows how to effectively search and navigate subreddits. Plus, learn how to post and vote on content, and use the "Ask Me Anything," or AMA, subreddit, which features politicians, celebrities, scientists, and other interesting people who are willing to answer questions posed by redditors.

Topics include:

  • Reading articles on reddit
  • Searching reddit
  • Using the Reddit Enhancement Suite
  • Posting content
  • Commenting and voting on content

 

Join the conversation—before it disappears. Learn how to set up and use Snapchat, the popular and supposedly confidential video-messaging platform that deletes messages after they are shared. Anson Alexander shows how to set up an account, record new photos and videos, and chat with friends, and helps new users understand critical privacy settings and whether "snaps" really disappear for good after viewing.

Topics include:

  • Creating a Snapchat account
  • Adding friends in Snapchat
  • Sending and receiving videos
  • Chatting
  • Deleting a Snapchat account

 

Think Pinterest is only good for cupcake recipes and wedding inspiration? Think again. Pinterest is a powerful marketing tool for businesses of all stripes. In this course, Pinterest expert Cynthia Sanchez explains the basics of Pinterest and dispels the myths that are keeping some companies away from this powerful marketing platform. She explains how to lay the foundation for a great Pinterest presence, starting with research, a strategic approach, and a website prepped for successful pinning.

Cynthia also provides crucial details on expanding Pinterest reach, including understanding what to pin and how often, writing successful pin descriptions, engaging with influencers, creating boards, and participating in groups. Plus, discover how to use contests, messaging, and Rich Pins; start advertising with Promoted Pins; and measure the results of your Pinterest activities.

Topics include:

  • How to pin
  • Researching customers on Pinterest
  • Creating a Pinterest plan
  • Creating a pinnable website
  • Opening a business Pinterest account
  • Linking to other social networks
  • Following other pinners
  • Crafting good pin descriptions
  • Creating article- and product-rich pins
  • Measuring Pinterest success with analytics

 

Join the social-media-marketing revolution: learn how to promote brands, increase sales, engage customers, and drive site traffic using Facebook and Twitter. This course helps marketers and business owners craft, implement, measure, and optimize a winning social-media-marketing strategy. Author Brad Batesole starts with the best uses for social media marketing, and the best platforms for each use. Once viewers understand the conceptual underpinnings of social media marketing, Brad shows how to create Facebook and Twitter profiles; write engaging, high-quality content that incorporates the unique features of each platform, such as hashtags and rich media; and maximize your reach by adding followers and fans. Finally, learn how to measure the results of those efforts using analytics, and see how well your posts and tweets are performing.

Topics include:

  • What is social media marketing?
  • Comparing Facebook and Twitter
  • Creating a brand presence
  • Defining your objective
  • Writing tweets and using retweets
  • Adding media and hashtags
  • Attracting followers on different platforms
  • Writing engaging Facebook posts
  • Reviewing Facebook and Twitter analytics

 

Businesses of all sizes can use Twitter for everything from finding new customers to deepening relationships with existing clients. This course explains how to best use the popular social media platform. Learn how to create a great user name and profile, define your brand personality, and begin tweeting.

Author Brad Batesole also shows how to use Twitter for lead gen, and track the impact of each tweet so you can determine what's working and what's not. You'll also learn how to integrate Twitter into your website, create an advertising account, and measure the results of promoted tweets and accounts.

Finally, Brad explains crucial workflows for managing your daily efforts, including how to monitor Twitter and schedule tweets. Plus, get tips for extending special offers on Twitter and tracking your results with Google Analytics.

Topics include:

  • Creating your user name and Twitter bio
  • Following other accounts
  • Crafting great tweets
  • Embedding photos and video
  • Using Twitter Cards to create "rich" tweets
  • Searching for potential clients
  • Retweeting
  • Advertising on Twitter
  • Using third-party Twitter-management tools
  • Tracking Twitter via Google Analytics

 

Mobile Technology

We all often find ourselves wishing we had more time or more help to complete tasks. We can't turn back the clock or simply secure more resources but we can take a look at how we're spending our time and identify opportunities to leverage tools or systems to simplify processes or increase our efficiency. This session will cover some common useful tools that can effectively improve your productivity. It will also discuss some best practices for identifying areas of your work that may benefit from the use of a technological tool. We will also explore methods for evaluating the right tool for your task.

Take your Android experience to the next level. This fun course offers cool, productivity-enhancing techniques to help Android users better enjoy their tablets and phones. It explores how to manage apps and widgets, record great video and take fantastic photos, get new and prepurchased music on a device, work with social media, set up parental controls, and much more. Android expert Dan Gookin offers cool tips and tricks you just have to try.

Topics include:

  • Finding and managing apps
  • Shooting video
  • Editing images
  • Enjoying some tunes
  • Reading ebooks
  • Exploring Google Now
  • Saving maps
  • Printing from your Android

 

Learn about all the cool new features of iOS 9, the latest iPhone and iPad operating system. Nick Brazzi covers multitasking, Siri and Proactive assistance, the News app, keyboard improvements, and more.

Topics include:
  • Migrating from Android
  • Working in Low Power mode
  • Using new Siri commands
  • Using the new and improved apps, including News and Wallet
  • Slide Over and Split View multitasking
  • Using the new keyboard tools and text selection features

Get the most out of your iPhone or iPad and learn just about everything you could ever want to know about iOS 9, Apple's operating system for the iPhone, iPad, and iPod touch. Garrick Chow explores the ways to interact with iOS 9 devices, from the external controls, touch screen, and multitasking views to the predictive keyboard and Siri, Apple's improved digital assistant. He also covers essential tasks: making and receiving calls, emailing, browsing the web with Safari, using Maps, taking notes, shooting photos, watching videos, and listening to music. Plus, discover how to extend the functionality of your iPhone or iPad by installing one of the 1 million+ apps available in the App Store. The course wraps up with some essential tips to help you customize your device, protect your privacy, and troubleshoot your iPhone or iPad if you encounter a problem.

Topics include:
  • Connecting to Wi-Fi
  • Controlling sounds
  • Typing
  • Syncing music, photos, contacts and more with your computer
  • Calling and texting
  • Making video calls with FaceTime
  • Sending and receiving email
  • Surfing the web
  • Playing music
  • Shooting photos and video
  • Getting directions from Maps
  • Making purchases with Apple Pay
  • Adding events to the calendar
  • Purchasing and installing apps
  • Finding your iPhone
  • Controlling your device with Siri
  • Troubleshooting your iOS 9 device

Discover how to be more productive and have more fun with your iPad. This course covers everything you need to know about gesturing, typing, and syncing files, as well as making the most of iPad when you're working on the go. Author Garrick Chow explains how to manage apps, configure email accounts, send text messages, and connect to secondary displays. He also shares tips on browsing the web and playing music and video back seamlessly on your iPad.

Topics include:

  • Using iPad-specific gestures
  • Typing tips
  • Syncing media and other files
  • Wireless syncing
  • Receiving and organizing email
  • Chatting with Messages
  • Installing apps
  • Browsing the web
  • Connecting to an external display
  • Using productivity software
  • Playing audio and video files

 

In this age of connected computers, a culture of social sharing, and ever-increasing digital assets, it's good to know there are tools to help you manage your digital life. Dropbox is one of them: an incredibly powerful, reliable, and easy-to-use cloud storage and file sharing service. Keith Gilbert will help you get up to speed with Dropbox as quickly as possible in this course. Learn how to set up and configure Dropbox; use Dropbox for file backup, synchronization, version control, collaboration, and file sharing; and how Dropbox can extend the power of apps on your mobile devices.

Topics include:

  • How much space do you get with Dropbox?
  • Signing up for Dropbox
  • Backing up your files
  • Synchronizing between devices
  • Sharing files and folders with non-Dropbox users
  • Sharing photos and videos
  • Using the Dropbox mobile app

 

Harness the power of Evernote for Mac, the popular note-taking and note-sharing tool that lets you ditch your paper notebooks in favor of a sleeker, cloud-based solution. The course begins with an explanation of Evernote and how you can use it to jot down and track important items. Next, discover how to create notebooks and notes within the application and take and store photos and screenshots, and even add audio to those notebooks. Learn how to use the tagging and search features to keep your notes organized and accessible—you can even search for text in handwritten notes. Finally, the course covers how to share your notes with others, as well as how to protect your content with encryption.

Topics include:

  • Creating an Evernote account
  • Creating and formatting text notes
  • Creating notebooks
  • Adding screenshots to a note
  • Creating a multimedia note
  • Clipping web content to a note
  • Merging notes
  • Finding notes and content
  • Tagging notes
  • Sharing notes
  • Protecting content with encryption
  • Using Evernote on mobile devices

Harness the power of Evernote for Windows, the popular note-taking and note-sharing tool that lets you ditch your paper notebooks in favor of a sleeker, cloud-based solution. The course begins with an explanation of what Evernote is and how you can use it to jot down and track important items. Next, discover how to create notes and notebooks within the application and store PDF content, photos, screenshots, web content, and more to those notebooks. Learn how to use the tagging and search features to keep your notes organized and accessible—you can even search for text in handwritten notes. Finally, the course covers how to share your notes with others, as well as how to protect your content with encryption.

Topics include:

  • Creating an Evernote account
  • Creating and formatting text notes
  • Creating notebooks
  • Adding screenshots to a note
  • Creating a multimedia note
  • Clipping web content to a note
  • Merging notes
  • Finding notes and content
  • Tagging notes
  • Sharing notes
  • Protecting content with encryption

Use your iPhone and iPad to accomplish critical business tasks. This course, from our Mobile for Business series, covers connecting an iOS device to a company network via Wi-Fi or secure VPN, setting up work email, and synching contacts and calendars. Along the way, author Nick Brazzi provides tips for giving presentations from your iPad or iPhone and customizing your device so it better suits your working style.

Topics include:

  • Getting connected to Wi-Fi and VPN
  • Printing with AirPrint
  • Synchronizing contacts and calendars
  • Connecting to displays for presentations
  • Using an external keyboard
  • Securing an iPhone or iPad with a passcode lock

 

Operating Systems

Having basic computer skills is a significant asset in today's modern world. Computers keep us connected to family and friends and help us do our jobs. Learn how to use a computer comfortably, while improving learning and productivity. This course focuses on the Microsoft Windows 10 operating system and offers a thorough, jargon-free introduction to computers, files and folders, networks, and peripherals like printers and keyboards. Garrick Chows also covers basic skills for working with software applications, the Internet, and email.

Interested in Mac computers? Check out Garrick's companion course, Computer Literacy for Mac.

Topics include:
  • What is a computer?
  • Purchasing a laptop vs. desktop
  • Understanding files and folders
  • Opening and saving files
  • Working with software
  • Setting up printers and Bluetooth devices
  • Connecting to networks to go online
  • Setting up email
  • Receiving and sending email
  • Searching the web

Learn all the ins and outs of El Capitan, Apple's Mac OS X 10.11 operating system. First, take a tour of the core interface elements—the menus, Finder, and Dock—so you can start working with files, folders, and applications right away. Then learn how to save files and find them again quickly, as well as use the core applications that come bundled with El Capitan (Mail, Calendar, Messages, FaceTime, iTunes, and Safari), and install new apps from the App Store. Finally, the course explores backing up your system, manually or with Time Machine, so you don't lose any important data.

Topics include:
  • Setting mouse and trackpad options and gesture controls
  • Connecting to the Internet
  • Organizing your Mac OS X desktop
  • Browsing files and folders with the Finder
  • Launching and quitting applications
  • Using Split View and multitasking
  • Searching for files with Spotlight
  • Browsing the web with Safari
  • Setting up Mail, Calendar, and Contacts
  • Connecting to others with Messages and FaceTime
  • Working with notifications
  • Installing apps
  • Sharing over a wireless network
  • Backing up your Mac

Mac OS X is designed to be elegant and easy to use, but there are hidden features and productivity-boosting shortcuts that even Mac pros can miss. Get Mac tips to help you become a better, more efficient user of Mac OS X El Capitan. Nick Brazzi offers handy tips and tricks for customizing Finder and Spotlight. He shows how to type hands-free with voice dictation and how to let your Mac read to you with Text to Speech. He also covers managing and securing files, recording video in QuickTime, and optimizing performance by finding more space on your hard drive and identifying the source of slowdowns.

Topics include:
  • Dragging files from one application to another
  • Using the Dictation and Text to Speech features
  • Printing to PDF
  • Customizing Finder windows
  • Securing files with encrypted disk images
  • Recording audio and video with QuickTime
  • Using the Activity Monitor to troubleshoot performance issues

Learn all the ins and outs of macOS Sierra, Apple's latest operating system. Author Nick Brazzi starts with the basics: installing and running the new OS, setting up system preferences and user accounts, and organizing the desktop. Learn how to work with the Dock and Launchpad, and set up your computer so it works best for you. He then shows how to save files and find them again quickly, work with email and calendars, send instant messages, video chat, and use the core applications that come bundled with Sierra (iTunes, Safari, QuickTime, Maps, and more). Looking for the latest apps and games? He also shows you how to find and install new applications from the Apple Store. Finally, Nick reviews sharing over a network and backing up and restoring files, so you never lose any important work.
 

Topics include:

  • Setting up an Apple ID or iCloud account
  • Browsing folders with Finder
  • Creating, copying, moving, and renaming files and folders
  • Organizing your desktop
  • Using Siri on the desktop
  • Launching and quitting applications from the Dock
  • Saving and searching
  • Browsing the web with Safari
  • Working with Mail, Contacts, and Calendar
  • Communicating with iMessage, Messages, and FaceTime
  • Using iTunes, QuickTime, Photos, Maps, and other bundled apps
  • Installing applications from the App Store
  • Sharing over a network
  • Backing up and restoring files

Please be aware that there was a significant update to Windows in August 2016, called the Anniversary Update. If you are using Windows after running the Anniversary Update, you should switch over to a different course, Windows 10 Anniversary Update Essential Training.

Learn all the essential features of Windows 10. This comprehensive course covers everything you need to know to install Windows, customize it to your liking, and start working with files and applications. Author Nick Brazzi shows how to manage folders, use Cortana to search and navigate, browse the web with the new Microsoft Edge browser, and work with Mail, Calendars, and People (aka contacts).

Plus, learn about sharing via a home network, multiuser configurations, security and privacy, and troubleshooting Windows.

Topics include:

  • Installing or upgrading to Windows 10
  • Connecting to the Internet
  • Launching, quitting, and managing applications
  • Creating, copying, moving, and renaming files and folders
  • Zipping and unzipping files
  • Using Cortana to search
  • Browsing the web with Edge
  • Sending email
  • Installing new apps
  • Sharing files over home networks
  • Backing up and restoring files
  • Configuring Windows updates
  • Using Windows Defender

Windows 10 is here! Explore the core new features and improvements in Microsoft's newest operating system. Take a look at the Start menu, Task View, Snap Assist, and Continuum, which allows you to run the same apps on mobile Windows devices as your PC. Also see how the Cortana virtual assistant can help you find files and more, and check out the the Edge web browser's novel capabilities.

Windows expert David Rivers shares tips and shortcuts for working more efficiently in Windows 10. This course opens with a top 10 list of power tips, before delving into mouse tricks and keyboard shortcuts, display and desktop organization tips, techniques for improving efficiency with basic operating system features, tips for improving system performance, and useful Windows utilities.

Topics include:
  • Customizing the startup environment
  • Running multiple virtual desktops
  • Saving files to PDF
  • Locking your screen
  • Enabling "God mode"
  • Configuring automatic app updates
  • Enabling Tablet mode on a PC
  • Fine-tuning power settings
  • Working with time-saving apps, tools, and utilities

Presentation Development

This workshop gives you the tools to create an effective, engaging presentation by focusing on preparation, practice and techniques to improve your public speaking and sharing information. This workshop also covers how to properly use visuals in your presentation to help convey your message, instead of distracting from it.

This is a two day session.

Learn the basics of creating engaging presentations with PowerPoint 2016. This course first explores the interface and helps viewers create and format great PowerPoint presentations on a Windows PC. Author Garrick Chow then shows how to best work with text, images, and multimedia and use the presentation tools to deliver a compelling presentation. The course wraps with instructions for sharing and exporting the finished presentation.

Topics include:
  • Creating a new PowerPoint presentation
  • Adding slides and sections
  • Adding and formatting text
  • Adding video, audio, pictures, and hyperlinks
  • Changing themes
  • Working with transitions
  • Presenting and navigating your slide deck
  • Printing slides and notes
  • Sharing and collaborating with others

This course is the perfect introduction to PowerPoint for Mac 2016. The course first explores the interface and helps viewers create and format great PowerPoint presentations. Author Garrick Chow then shows how to best work with text, images, and multimedia and use the presentation tools to deliver a compelling presentation. The course wraps with instructions for sharing and exporting the finished presentation.

Topics include:
  • Creating a new PowerPoint presentation
  • Adding slides and sections
  • Adding and formatting text
  • Adding video, audio, pictures, and hyperlinks
  • Changing themes
  • Working with transitions
  • Presenting and navigating your slide deck
  • Printing slides and notes
  • Sharing and collaborating with others

In PowerPoint 2010 Essential Training, author David Diskin demonstrates how to engage an audience with images, video, sound, charts, and diagrams in professional presentations. The course also covers a variety of methods to share presentations with others, and provides comprehensive tutorials on how to design presentations that successfully deliver a quality message. Exercise files accompany the course.

Topics include:

  • Using the Office 2010 Backstage View
  • Using and customizing the Office 2010 ribbon
  • Starting a presentation from scratch
  • Applying slide layouts for consistency
  • Rearranging slides
  • Running a presentation for an audience
  • Formatting with font, color, bullets, and alignment
  • Adding and customizing photos, clip art, shapes, audio, and video
  • Applying picture effects such as background removal, brightness, and color effects
  • Modifying slide masters
  • Adding a logo to the background
  • Adding and customizing tables, charts, diagrams, and data from Excel
  • Printing a presentation
  • Sharing a presentation with others through video, the web, SharePoint, and PDF

 

In this course, author Jess Stratton teaches the basics of creating, editing, and sharing presentations with Microsoft PowerPoint 2013. The course shows how to build a slideshow from scratch, or leverage PowerPoint templates and themes for quick construction. Jess shows how to add and edit text, images, graphs, video, and animation; format slides for consistency; and add speaker notes to ensure a smooth delivery. Plus, discover how to collaborate on changes and then share the final presentation via print, video, PDF, or email.

Topics include:

  • Touring the PowerPoint interface
  • Creating a presentation
  • Adding, removing, and rearranging slides
  • Adding and formatting pictures
  • Working with bullet points
  • Inserting tables from Excel
  • Adding shapes and creating diagrams
  • Inserting audio and video clips
  • Delivering your presentation
  • Reusing and sharing a presentation

 

Learn how to best create, edit, and share presentations with PowerPoint 2016, the popular presentation platform. Jess Stratton shows how to build a slideshow from scratch or leverage PowerPoint templates and themes for quick construction. Jess then demonstrates how to add and edit text, images, graphs, video, and animation; format slides for consistency; and add speaker notes and transitions to ensure a smooth delivery. Plus, discover how to collaborate on changes and then share the final presentation via print, PDF, or a recorded slideshow.

Topics include:
  • Connecting PowerPoint to OneDrive
  • Creating presentations from themes and templates
  • Using and editing slide masters
  • Changing the layout or theme
  • Adding pictures and objects
  • Working with bullet points, text boxes, and tables
  • Adding shapes, diagrams, and charts
  • Incorporating video, audio, and animation
  • Adding speaker notes and comments
  • Running a slideshow
  • Reusing and sharing PowerPoint presentations

Document Processing

This foundational course teaches everything you need to know to create, edit, and manage PDFs in the Acrobat DC family of programs: Acrobat Pro, Acrobat Standard, and Acrobat Reader. Author Claudia McCue shows how to create PDFs using source material from Microsoft Office, Adobe CC, web pages, and scans, and edit and combine PDFs. She also demonstrates how to create fillable forms, gather comments and review PDFs, esign documents, and add audio, video, and links to PDFs.

Topics include:
  • Searching PDFs
  • Creating PDFs from Microsoft Office and Adobe CC
  • Printing to PDF
  • Converting a scan to searchable text
  • Adding hyperlinks and bookmarks
  • Combining multiple PDFs
  • Exporting to Office, HTML, or RTF formats
  • Commenting and reviewing
  • Building fillable forms
  • Adding interactivity
  • Protecting content
  • Ensuring accessibility

Learn how to create, format, share, and print a wide variety of documents in Word 2016. Author David Rivers covers creating new documents from templates and scratch, formatting text and pages, working with headers and footers, using themes and styles, adding multimedia, and more. He'll also show how to share documents with others and enhance your productivity with macros.

Topics include:
  • Using templates to create new documents
  • Creating and editing text
  • Formatting text, pages, and paragraphs
  • Adjusting line spacing and page breaks
  • Adding headers, footers, and page numbers
  • Applying styles and themes to documents
  • Creating bulleted and numbered lists
  • Working with tables, macros, and building blocks
  • Illustrating documents
  • Proofing, reviewing, and printing documents
  • Collaborating with others via OneDrive and email
  • Customizing Word

Learn how to create electronic forms that are visually pleasing and easy to navigate with Word 2016. This course covers designing a form; capturing data effectively with form controls such as dropdown lists, date pickers, and check boxes; and testing, protecting, and distributing forms. Gini Courter also shows how to accelerate form creation with free Microsoft.com templates and customize and share templates with colleagues.

Topics include:
  • Starting with a form template
  • Gathering form requirements
  • Formatting form tables
  • Inserting form controls: lists, date pickers, check boxes, and more
  • Protecting the form
  • Saving a form as a Word 2016 template
  • Sharing Word form templates with your team
  • Creating forms with Word building blocks

Design Software

Find out how to build well-crafted print publications, interactive documents, digital magazines, and ebooks all in one application: InDesign CC. In this course, David Blatner guides you through the core features and tools of this popular page-layout application, including concepts such as setting up documents with master pages and easily formatting text, objects, and tables using styles. The first chapter helps those who are new to the program get up to speed with creating and editing documents. From there, the course shows how to navigate and customize the workspace, work with text frames and graphics, add and format tables, build interactive documents and EPUBs, and much more. Last, learn how to package, print, and export your finished project.

Topics include:

  • Getting started in just 20 minutes
  • Becoming familiar with the user interface
  • Setting up a new document
  • Placing graphics such as QR codes and barcodes
  • Formatting objects
  • Creating color and gradient swatches
  • Organizing projects with layers
  • Transforming objects
  • Incorporating drop caps, bullets, and numbering
  • Applying character and object styles
  • Building a multidocument book
  • Creating an interactive PDF and exporting to EPUB
  • Proofing a document with the Preflight panel
  • Printing and exporting a document

 

Learning how to use Adobe Photoshop efficiently and effectively is the best way to get the most out of your pixels and create stunning imagery. Master the fundamentals of this program with Julieanne Kost, and discover how to achieve the results you want with Photoshop and its companion programs, Bridge and Camera Raw. This comprehensive course covers nondestructive editing techniques using layers, masking, adjustment layers, blend modes, and Smart Objects. Find out how to perform common editing tasks, including lens correction, cropping and straightening, color and tonal adjustments, noise reduction, shadow and highlight detail recovery, sharpening, and retouching. Julieanne also shows how to achieve more creative effects with filters, layer effects, illustrative type, and the Photomerge command for creating panoramas and composites.

Topics include:

  • Using Bridge to batch rename files and add keywords and metadata to photos
  • Viewing, rating, filtering, and creating collections to isolate your best work
  • Comparing raw and JPEG file formats
  • Retouching and automating workflow with Camera Raw
  • Navigating documents and the Photoshop interface
  • Understanding file formats, resolution, canvas size, and print size
  • Cropping, straightening, transforming, warping, scaling, and resizing images
  • Selecting, stacking, aligning, and grouping layers
  • Making precise selections using the Marquee, Lasso, and Brush tools
  • Using Refine Edge, Quick Selection, and layer masks to isolate soft edge objects
  • Improving tone, contrast, and color selectively
  • Converting to black and white and tinting images
  • Retouching blemishes, smoothing skin, whitening teeth, and brightening eyes
  • Retouching with the Liquify, Content-Aware Fill, Healing Brush, and Patch tools
  • Merging multiple exposures
  • Making nondestructive changes with Smart Filters
  • Adding texture, edge effects, and drop shadows with blend modes
  • Working with type
  • Creating, modifying, and combining shapes using the Shape tools
  • Adding layer effects
  • Saving and sharing images via contact sheets, web galleries, and Save For Web
  • Editing video and audio clips
  • Panning and zooming still photos

 

Whether you're an experienced creative professional or someone who recently purchased a camera, learning how to use Photoshop efficiently and effectively is the best investment you can make to get the most out of your images.

Julieanne Kost filters out the noise and complexity often associated with Photoshop, so you'll feel empowered to get the image results you want. She concentrates on enhancing and compositing photos, as well as automating parts of the process for the most efficient workflow possible. She'll cover cropping, retouching, and combining multiple images, and working with non-image-based assets such as type, shapes, and even video. Along the way, you'll learn the secrets of nondestructive editing with Camera Raw, layers, masks, blending modes, Smart Objects, filters, and more. Start watching to quickly get the professional results you're looking for with Photoshop.

Topics include:
  • Customizing Photoshop's interface
  • Resizing and resampling images
  • Comparing raw and JPEG files
  • An overview of Camera Raw
  • Cropping and straightening
  • Working with layers
  • Transforming, distorting, and warping
  • Taking advantage of Smart Objects
  • Working with layer masks and blend modes
  • Making selections
  • Adding adjustment layers
  • Retouching portraits, including skin, teeth, hair, and eyes
  • Combining multiple images
  • Working with filters
  • Creating character, paragraph, and type along a path
  • Shape layers and layer effects
  • Painting in Photoshop
  • Creating time-lapse videos and animated GIFs
  • Working with video
  • Sharing images

Learn how to use Publisher 2013 to easily create your own brochures, newsletters, menus, and postcards, and prepare them for professional printing, email distribution, or posting on the web. This course shows how to master Publisher's core features and tools, using a selection of real-world examples. David Rivers demonstrates how to work with text frames, and format and edit text; how to insert and position shapes, pictures, and tables; and how to customize and automate the layout and design of publications. Plus, learn how to send out a mass mailing with Mail Merge, and prep publications for commercial or desktop printing and digital distribution.

Topics include:

  • Creating a new publication from scratch
  • Using the built-in Publisher templates
  • Changing fonts
  • Translating text
  • Inserting pictures, backgrounds, and WordArt
  • Working with tables
  • Creating and applying master pages
  • Using building blocks
  • Creating publications for the web
  • Using Mail Merge
  • Printing and sharing publications

 

This course offers in-depth instruction in all the core features and tools in Publisher 2016, the desktop publishing software from Microsoft. Author David Rivers demonstrates Publisher's features using real-world examples of the different kinds of publications you can create with Publisher, from greeting cards to brochures to newsletters. The course explains how to work with text frames and format and edit text; insert and position shapes, pictures, and tables; and customize and automate the layout and design of publications. Plus, learn about Publisher's features for sending out mass mailing with Mail Merge and sharing publications on the web or in print.

Topics include:
  • Creating new publications
  • Saving publications
  • Inserting pages
  • Working with text
  • Creating bulleted and numbered lists
  • Inserting and deleting objects, pictures, and tables
  • Creating master pages
  • Using building blocks
  • Creating web publications
  • Performing a mail merge
  • Printing a publication

Online Collaboration

Learn how to use Adobe Connect to run meetings, connect with learners online, and record standalone presentations. Garrick Chow shows how Connect bridges real-world gaps and helps anyone with an Internet connection link up online. Watch this course and learn how to create new meetings; establish audio connections, whether over the computer or on the phone; open pods to chat, video conference, or share content; share your screen; and make content available for download over Connect. You don't need to have everyone in the same room to have a great meeting; you just need to Connect.

Topics include:

  • Creating meetings, users, and groups
  • Setting up audio
  • Passcode protecting a room
  • Video conferencing
  • Recording and editing meetings
  • Managing participants
  • Sharing your screen
  • Creating break-out rooms
  • Working with the Chat pod
  • Polling your audience
  • Creating courses and curriculum with Connect

 

BlueJeans is excited to announce the launch of Coffee & BlueJeans, the new self-serve 24 x 7 x 365 training site! Coffee & BlueJeans serves up fast, interactive, self-paced training for admins and users alike.

On this site, new BlueJeans users can quickly become familiar with the basics, like scheduling and hosting meetings. Seasoned users will benefit from the Power User menu, including tips on recording and scheduling shortcuts.

You can use it to learn more about the administrator features and tools, including Command Center and Live Meeting Control, or how to quickly analyze your video usage and measure your ROI.

You'll also find one-page quick tops to download, and be able to register for a live training hosted by a member of our Customer Success team.

 

Simply follow the link, create an account, and start learning. Please use your RIT email address when creating and logging into Coffee & BlueJeans.
 

Take a closer look at Google Docs and discover how to build documents with rich formatting, images, and tables. In this course, Jess Stratton shows how to get around Google Docs' web-based interface, create new documents, and add features such as footnotes, headers and footers, and page numbering. You'll also see how to make your documents more engaging by adding images, Google drawing objects, and tables. Then learn how to share docs with others—for real-time, simultaneous collaboration—and take Google Docs on the go on your tablet.

Topics include:
  • Creating, naming, saving, and editing docs
  • Formatting text
  • Creating a table of contents
  • Inserting images and tables
  • Copying, renaming, and moving docs
  • Publishing docs on the web
  • Sharing docs
  • Translating docs
  • Using Google Docs on mobile devices

Google Sheets is a feature-rich, cloud-based spreadsheet application that allows you to format and analyze all kinds of data. In this course, author Sally Norred shows you how to get the most from Google Sheets. Discover how to get around the interface, enter and work with data, and use formatting and function features, and learn smart ways to make your data work for you. Plus, see how to work with your spreadsheet data on the go with the Google Sheets mobile app.

Topics include:

  • Navigating Google Sheets
  • Creating, naming, and saving spreadsheets
  • Importing files
  • Converting other file formats such as Microsoft Excel to Google Sheets
  • Editing cells
  • Inserting, deleting, and moving rows and columns
  • Adding hyperlinks and images
  • Formatting data
  • Using formulas and functions
  • Sharing spreadsheets
  • Using the Google Sheets mobile app

Connect and collaborate across the globe with WebEx Meetings. In this course, author and webinar specialist Sally Norred shows you how to use WebEx Meetings to host, run, and record online meetings. Discover how to set up an online meeting and invite attendees, work with interactivity, let attendees participate and present, and save and record a meeting. Also check out the quick tips sheets (free to all members) for a list of handy shortcuts for hosts, presenters, and attendees alike.

Topics include:

  • Setting up a host account
  • Installing WebEx Meetings
  • Joining a meeting
  • Using text chat
  • Scheduling meetings
  • Launching instant meetings
  • Sharing your desktop or specific applications
  • Changing presenters
  • Managing audio
  • Using whiteboards and annotation tools
  • Recording meetings
  • Video conferencing
  • Using WebEx Meetings on mobile devices

 

Microsoft OneNote ist in allen Editionen von Office 2010 enthalten, aber viele Anwender haben dieses sehr hilfreiche und leistungsfähige Werkzeug noch gar nicht entdeckt. Office-Trainer Kai Schneider ist von OneNote begeistert und wird in diesem Video-Training diese Begeisterung mit Ihnen teilen und an mehreren Fallbeispielen zeigen, wie das Notizverwaltungsprogramm Ihre tägliche Arbeit erheblich effizienter macht.

In this course, author David Rivers shows you the basics of using Microsoft OneNote 2013 to create, edit, and save notes. Discover easy ways to format your text, organize notebooks, use stationery, work with tables, perform research, and integrate your notes with Outlook. For new notetakers, the "Getting Started" chapter provides an overview of the complete workflow, so you can quickly get up and running with OneNote. Plus, learn about new features included in OneNote 2013, such as how to sync notes with SkyDrive.

Topics include:
  • What is OneNote?
  • Copying and pasting content
  • Creating, moving, and deleting sections
  • Adding images, audio, and video
  • Formatting text
  • Searching notebooks
  • Sharing and moving books
  • Using templates
  • Creating tables
  • Converting handwriting to type text

Learn how to use OneNote 2016 to create, edit, and save notes and keep your information organized. Discover easy ways to create notes, add and format text, stay organized with tables, and share and password-protect your notebooks. Plus, learn how to integrate all sorts of content into notes, such as screen clippings, images, audio and video, and even Excel worksheets.

Topics include:
  • Sending content and screen clippings to OneNote
  • Copying and pasting content
  • Recording audio and video notes
  • Attaching files
  • Formatting text
  • Linking and tagging notes
  • Searching a notebook
  • Using templates
  • Creating tables
  • Converting handwriting to type
  • Interacting with Outlook
  • Sharing and syncing notebooks
  • Collaborating on notebooks

Learn how to use OneNote for Mac 2016 to create, edit, and save notes. Discover easy ways to create notes, add and format text, stay organized with tables, and share and password-protect your notebooks. Plus, learn how to integrate all sorts of content into notes, such as screen clippings, images, audio and video, Excel worksheets, and even emojis.

Topics include:
  • Creating, deleting, and sharing notebooks
  • Adding pictures, audio, video, and file attachments to notes
  • Formatting notes
  • Linking notes
  • Using tabs
  • Creating tables
  • Syncing notebooks
  • Tracking authors and page versions

Customer surveys are rich sources of information and essential guides to areas where customer service teams can improve their focus. In this course, Jeff Toister provides step-by-step instructions for designing and implementing effective surveys and analyzing the results. He'll give you tips on increasing response rates, writing effective questions, and turning the data into actions that can improve service quality.

RIT Systems

Do you know what it takes to stay safe online? Do you know how to protect yourself and other RIT people? Are you worried about your online privacy? Did you know your smartphone can be attacked?

Cybercriminals continue to devise new ways to attack us both at RIT and at home. In order to meet those threats, we need to understand how to defend against them.

Join us for an hour of tips, tools, and best practices that will help you enjoy the Internet more safely, whether you’re using a personal computer, smartphone, or tablet.

 

Drupal is the official content management system (CMS) used by RIT. This class is the beginning of the new Drupal training series. It is intended for new users or those seeking to refresh their knowledge of Drupal 7. The class focuses on the basic tasks that a website editor would be expected to perform.

 

Some examples of people who would find this class to be beneficial would be:
• People who have never used Drupal
• Someone who would like a refresher on the basics
• Taking over website updating responsibilities
• Interested in creating a website in Drupal
• Migrating a current website into Drupal

Student Employment and Career Services are jointly introducing a new and comprehensive job registration and posting system. This course is essential for all RIT staff who plan to hire students for On-Campus employment in 2018. Course will discuss registering and logging into the new system, Handshake, and provide an overview of how this new system changes the hiring process for our student employees. Once enrolled in Handshake, supervisors will have greater access to their positions, postings, and applicants.

Drupal 7 Essential Training shows how to get the most out of Drupal, the content management system (CMS) that powers over a quarter million web sites. The course demonstrates how to download and install Drupal, add content and graphics to a site, change layout and design elements, control visitor interactions, and expand the site's capabilities beyond what’s available in Drupal core. Discussion of established best practices in each step to ensure that a site remains streamlined, secure, and up-to-date. Exercise files are included with the course.

Topics include:

  • Comparing Drupal with other content management systems
  • Understanding nodes
  • Creating basic content
  • Adding blogs, discussions groups, and polls
  • Subscribing to RSS feeds
  • Creating new content types
  • Managing users, roles, and permissions
  • Creating and modifying block regions
  • Adding menus
  • Extending site capabilities with modules

 

Online Learning Methods

lynda.com is an online learning platform with video tutorials in a number of disciplines: 3D, video, business, photography, web design, graphic design, and more. The number of courses is over 3,000 and new content is added weekly from respected professionals. This course is designed to help RIT faculty and staff navigate through lynda.com. We will also explore the reporting features in lynda.com and E-Learning Zone so learners will know how they can view the courses they have completed.

Learn how to find, access, and view courses in the lynda.com training library. Staff author Garrick Chow explains how to find the "need to know" material quickly and browse other subjects you might be interested in. A full rundown of the types of training offered is included, from in-depth essential training on specific software packages, to first looks at up-and-coming technology trends, to inspirational documentaries following creative professionals working in a variety of disciplines. Garrick also shows how to use special library features such as bookmarks, the queue, certificates of completion, frequently asked questions (FAQs), and more, as well as where to turn for help when you need it. Plus, learn to access lynda.com on the go, either through our mobile site, or the iOS app, which also supports playing videos on your TV via AirPlay and an Apple TV.

Topics include:

  • Browsing the library by subject, software, or author
  • Finding the latest releases
  • Downloading and using exercise files
  • Searching video transcripts
  • Choosing the right video player
  • Understanding types of courses
  • Using your training history
  • Printing and sharing certificates of completion
  • Logging in from multiple computers
  • Updating your member profile
  • Setting site preferences
  • Changing your membership plan
  • Searching the FAQs
  • Contacting customer support
  • Viewing content on an iPhone, iPad, or other mobile device