Skills

Access Help Center

Learn how to: create a table and add fields, naming fields, controls, and objects, set field size, add a calculated field, add data macro, control data entry formats with input masks, restrict data input by using a validation rule, add or change a tables primary key, create and use an index to improve performance, import and export links to data, database objects into Access, Excel, or SQL Server databases. Link to or import data from Salesforce and Dynamics 365. create a simple query, join tables and queries, apply criteria to text values, use like criteria to locate data, examples of wildcard characters, use parameter to make a query ask for input, introductions to forms and controls, how to create a navigation, split, and tabbed form, set the tab order for controls, add check box to show yes/no values, list of choices by using a list box or combo box, create a subform, use expression builder, guide to syntax, and much more.

Link to Resource

Microsoft Teams Help Center

Learn how to: find and join a team, use or create a link or code, see who’s on a team, create a team from scratch or from an existing team or from an existing croup, renew a team, add people, change settings, reorder team lists, let everyone know about a new channel or team, change the default SharePoint site for a team, use teams from Outlook or SharePoint, keep up with information, explore the activity feed, manage notifications, manage mobile apps, use @mentions to get someones attention, favorite or follow a channel, view and resume and old conversation, use commands, private chats and channels, create, edit, or delete groups, mute a chat, leave a group chat, send messages to Skype for Business users, turn off chat, call in a meeting, share your screen, take notes, blur your background, multitasking in a meeting, audio settings, whiteboard, record, and edit transcripts, and edit, download, share, link, move, copy, and sync files.

Link to Resource

SharePoint Help Center

Learn how to: share SharePoint files or folders in Office 365, share a site, change the default link type when users get links for sharing, checkout, in or discard changes to files in a library, enable and configure versioning for a list or library, how does versioning work, restore a previous version of an item or file, set up a library to require check-out of files, delete a previous version of an item, add, edit, or delete list items, bulk edit item properties, create a list based on a spreadsheet, learn about modern pages, add and remove columns, add a page to a communication site, using web parts, classic pages, team site, plan, create a team site, manage your team site settings, updated with news, etc.

Link to Resource

OneNote Help Center

Learn how to: take notes, covert and solve math equations, send documents and files to OneNote for Windows 10, embed content, insert a file, create links to notebooks, sections, pages, and paragraphs, add links, research your paper easily, format text, check spelling, insert a table, format pages, change background color of a page, add a picture to a page, edit and crop pictures, insert online videos, send photos and images form other apps, write notes and draw, change the color and thickness of ink strokes, draw straight links or measure with a ruler, replay ink strokes, group selected ink strokes in drawing, sync notebooks, share a page of notes or an entire notebook, protect notes with a password, notebook storage options, organize, create more room, search and tips.

Link to Resource

OneDrive Help Center

Learn how to: upload or create save files, photos, and folders to OneDrive, save files by default to OneDrive, save photos, videos, and screenshots automatically, add and sync shared folders, share and work with shared files and folders, change permissions, see if documents are safe in the discover view, sync files, backup files from your documents, pictures, and desktop folders, sync SharePoint files, move files off a windows 7 PC, set up for mobile, android, and mac, set system requirements, frozen accounts, merge personal and work accounts, storage plan and billing questions, and more.

Link to Resource

Outlook Help Center

Learn how to: get started, add email accounts to Outlook, create and send email, manage your calendar and contacts in Outlook, set up your outlook mobile app, change or update your password, create or customize a view, use and configure the reading Pane to preview messages, reply to or forward and email message, create and add a signature to messages, change the default font or text color, attach files or insert pictures, mark a message as read or unread, delete an email, recall or replace and email message you sent, add and request receipts and delivery notifications, delay or schedule sending messages, send automatic reply, search and filter email, ignore all email messages in a conversation, use conversation clean up to delete redundant messages, remove reminders, use folders to organize, allow someone else to mange your mail and calendar, add contacts, create and use contact groups, & import and export contacts.

Link to Resource

PowerPoint Help Center

Learn how to: get started on PowerPoint, slides, layouts, text tables, picture, and graphics, present slideshows, animations, audio, and video, templates, customize a slide master, change page orientation between landscape and portrait, organize PPT into sections, add hyperlinks, outlines, check spelling, add slide numbers, page numbers, and dates/time. Also learn how to share and collaborate. Learn how to add, rearrange, duplicate, and delete slides. Learn design, how to save, set up mobile apps, and how insert icons, watermarks, and artistic effects.

Link to Resource

Excel Help Center

Learn how to: build, delete, select, insert, move, copy, hide, freeze, filter, split workbooks, rows, columns, cells, unique values, duplicate values, sequential dates, resize tables, replace text, merge and unmerge cells, apply data validation, import or export text, formulas, functions, formatting, tables, charts, pivot tables, and how to share and collaborate. Align or rotate text, conditional formatting, display or hide zero values, format painter, slicers, range, titles, elements, chart legend, secondary axis in charts, trends or moving average lines, updating data and more. Save in OneDrive, analyze data, set up mobile app, and learn much more about excel.

Link to Resource

Word Help Center

Learn how to: create a document in word, add and edit text, find and replace, check spelling, grammar, and clarity, show word count, insert & remove hyperlinks, create a bulleted or numbered list, change the line spacing, apply styles and themes, change margins, newletter columns, page orientation to landscape or portrait, add a border, insert header and footer, page numbers, page breaks, table of contents, save a document to OneDrive, research, edit, and design in word, write and edit, format text, layout pages, pictures and tables, icons, wordart, ruler, rotate shape, wrap text around picture, print, share, collaborate in word, set up your word mobile app, convert or save to PDF, print an envelope, return address labels, or mailing labels, and learn much more about Microsoft word.

Link to Resource

EdX

edX is the trusted platform for education and learning. Founded by Harvard and MIT, edX is home to more than 20 million learners, the majority of top-ranked universities in the world and industry-leading companies. As a global nonprofit, edX is transforming traditional education, removing the barriers of cost, location and access. Fulfilling the demand for people to learn on their own terms, edX is reimagining the possibilities of education, providing the highest-quality, stackable learning experiences including the groundbreaking MicroMasters® programs. Supporting learners at every stage, whether entering the job market, changing fields, seeking a promotion or exploring new interests, edX delivers courses for curious minds on topics ranging from data and computer science to leadership and communications. edX is where you go to learn.

Our students come from every country in the world! Whether you are interested in computer science, languages, engineering, psychology, writing, electronics, biology, or marketing, we have the course for you! 

Link to Resource

Map in Seconds

Turn your excel spreadsheets and data into maps. Find data online and enter it to create a map.

Step 1: copy your data. Step 2: paste it into the website. Step 3: download your map.

Link to Resource

Word 2016 Tutorial

Microsoft Word 2016 is the word processing application in the MS Office 2016 suite. Get help producing and sharing documents here.

The content at GCFLearnFree.org is what we call self-paced tutorials. This means these tutorials are available when you are, on your schedule. You can view one lesson or an entire tutorial. And you don’t have to create an account or sign in; you can start learning immediately.

 

Link to Resource