雷火电竞赛事开盘注册

5 Courses | 5h 10m 21s
4 Books | 17h 41m
Includes Lab
Includes Test Prep

8 Courses | 6h 51m 41s
4 Books | 17h 41m
Includes Lab
Includes Test Prep

6 Courses | 3h 49m 10s
2 Books | 7h 29m
Includes Lab

5 Courses | 4h 19m 57s
1 Book | 4h 27m
Includes Lab

6 Courses | 4h 44m 14s
7 Books | 58h 45m
Includes Lab
Includes Test Prep

2 Courses | 53m 13s
2 Books | 22h 6m

5 Courses | 2h 55m 33s
2 Books | 7h 29m
Includes Lab

3 Courses | 3h 6m 37s
1 Book | 4h 27m
Includes Lab

8 Courses | 5h 51m 38s
7 Books | 56h 51m
Includes Lab
Includes Test Prep

5 Courses | 3h 23m 9s
4 Books | 40h 33m

Acquire knowledge of Office programs such as Excel, Word, PowerPoint, Outlook, and Access as you prepare to earn a Microsoft Office Specialist (MOS) certification in a specific Office program.

GETTING STARTED

Opening & Setting Up

1.

Finding & opening Word 2016

2m 30s

NOW PLAYING
2.

Using Word 2016

3m 21s

UP NEXT

+6 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Shaping & Structuring Documents

1.

Inserting a page break

4m 4s

NOW PLAYING
2.

Creating & formatting a section

5m 41s

UP NEXT

+14 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Getting Started

1.

Finding & opening the application

2m 28s

NOW PLAYING
2.

Using the application

3m 55s

UP NEXT

+4 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Setting Up

1.

Installing an account

3m 10s

NOW PLAYING
2.

Using Outlook

5m 39s

UP NEXT

+4 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Getting Started

1.

Finding & opening the application

2m 53s

NOW PLAYING
2.

Exploring the Interface

4m 13s

UP NEXT

+3 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Working with Databases

1.

Creating a database

4m 3s

NOW PLAYING
2.

Using database templates

4m 58s

UP NEXT

+4 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Illustrating Presentations

1.

Inserting an image

2m 24s

NOW PLAYING
2.

Inserting a screenshot

2m 17s

UP NEXT

+16 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Formatting Email

1.

Formatting your text

5m 18s

NOW PLAYING
2.

Inserting special characters

6m 34s

UP NEXT

+11 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Custom & Conditional Formatting

1.

Customizing your number formats

5m 34s

NOW PLAYING
2.

Customizing your text formats

3m 17s

UP NEXT

+5 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Tables, Fields, & Entries

1.

Understanding your database

5m 37s

NOW PLAYING
2.

Creating a table

2m 48s

UP NEXT

+7 MORE VIDEOS | FREE ACCESS

COURSES INCLUDED

Opening & Setting Up

Before getting started with Word 2016 for Windows, you will need to know how to open the application and use the basic navigation tools. Learn how to scroll, zoom, and use the different view modes to take control of your workspace.

8 videos | 32m Assessment Badge

Creating, Opening & Saving Documents

Creating, saving, and opening documents are central to your user experience in Word 2016 for Windows. Learn how to create files, how to save them, and how to optimize your documents with accessibility and protection tools.

15 videos | 1h 8m Assessment Badge

Editing Documents

Typing, manipulating, and checking your text is made easy with Word 2016's intuitive text tools. Discover how to build out your document more quickly with special characters, advanced AutoCorrect tools, and predefined AutoText items.

16 videos | 1h 13m Assessment Badge

Formatting Documents

Control every aspect of your text's appearance and structure with Word 2016's formatting tools. Use color, effects, and intuitive alignment tools to quickly transform your text and make your document more readable.

20 videos | 1h 38m Assessment Badge

Using the Find & Replace Tools

Whether you are looking for a word or phrase, Word 2016 for Windows has the tool for you. Perform simple searches, use wildcards to widen the scope, and define replacement text to quickly make changes to your document.

7 videos | 36m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Shaping & Structuring Documents

Shaping and structuring text properly makes your document more readable. Use sections, headers, and cover pages to set out your ideas clearly, and advanced reference tools to help your reader find the information they need.

16 videos | 1h 18m Assessment Badge

Illustrating Documents

Sometimes images and illustrations say it better than text. With Word 2016 for Windows, you can insert images and videos from online and local locations, build custom equations, and create hyperlinks to other sources of information.

11 videos | 52m Assessment Badge

Using Table Tools

Bring structure to your technical data with Word 2016 table tools. Insert new entries, columns, or rows on the fly; apply formatting to make values stand out; and manipulate your data with the sort, filter, and calculation tools.

9 videos | 40m Assessment Badge

Creating Graphics & Diagrams

With Word 2016's graphics tools, you can create charts and diagrams to add visual impact to your documents. Learn how to build diagrams, insert customizable SmartArt graphics, and transform your data using different chart types.

10 videos | 54m Assessment Badge

Using Research Tools

Word 2016 for Windows gives you a suite of research tools to enrich your documents. Organize your citations and sources, use the dictionaries to check your text, and pull information into your document directly from the web.

8 videos | 40m Assessment Badge

Creating Forms & Bulk Mailings

With Word 2016's forms and mailings tools, you can collect, process, and re-use data in a variety of different ways. Build data collection forms, import mailing lists, and create mail merge documents in a matter of minutes.

11 videos | 51m Assessment Badge

Using Sharing & Collaboration Tools

Collaboration is made easy in Word 2016 for Windows. Share your document via email, upload your document to your OneDrive storage space, and use the comment and change tracking tools to keep on top of any modifications made to your files.

10 videos | 51m Assessment Badge

Configuring the Application

Every aspect of your Word 2016 for Windows application, from interface and language to input and save options, can be customized. If these default settings aren't enough, you can even install new tools and services via the add-in store.

10 videos | 41m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Getting Started

PowerPoint is the presentation application that is included with Microsoft Office 2016. Discover how to locate and open the application, explore the interface tools and menus, and navigate between slides and presentations.

6 videos | 19m Assessment Badge

Creating Presentations

Create your slides, and finesse them like a pro. Discover how to use themes, create and manipulate slides, and work with slide elements.

13 videos | 45m Assessment Badge

Saving & Sharing Presentations

Once your presentation is done, you can save, export, and share it. Explore the methods for saving, backing up, exporting, and protecting PowerPoint 2016 presentations.

18 videos | 1h 1m Assessment Badge

Inserting & Manipulating Text

PowerPoint 2016 presentations contain two key elements: graphics and text. Discover how to manipulate text like a pro.

9 videos | 29m Assessment Badge

Formatting Presentations

Presentations with visual impact are the key to a great talk. Explore the many ways you can polish your PowerPoint 2016 presentation, from working with color and WordArt to paragraphs, lists, themes, and backgrounds.

17 videos | 55m Assessment Badge

Organizing Presentations Assets

Your presentation needs to be tweaked to make it just right. Discover the various editing elements of PowerPoint, from copying and pasting to object grouping and slide organization.

6 videos | 17m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Setting Up

Outlook 2016 is the email client that ships with the Microsoft Office suite. Discover how to configure an account, explore the interface and available tools, access help, and use keyboard shortcuts to help you save time.

6 videos | 25m Assessment Badge

Sending & Receiving Email

Outlook 2016 makes it easy to send and receive emails. Learn how to send, receive, reply to and forward emails; work with attachments; create out-of-office and automatic replies; and print emails.

16 videos | 1h 1m Assessment Badge

Illustrating Email

Outlook 2016 emails do not have to contain text only. Explore ways to illustrate your emails, including adding images, links, shapes, WordArt and SmartArt graphics, tables, charts, polls, and objects.

17 videos | 1h 15m Assessment Badge

Contact Tools

Outlook 2016 makes it easy to keep track of people you connect with. Discover how to add, import,export, and categorize contacts; create and manage groups; and configure your address book.

11 videos | 47m Assessment Badge

Calendar Tools

Keep track of events, meetings and appointments in Outlook 2016 using the calendar function. Discover how to configure your calendar; create and organize events and meetings; add, import, and export calendars; and work with tasks.

13 videos | 50m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Getting Started

Excel 2016 is the spreadsheet application in the Microsoft Office 2016 suite. Explore the interface and some of its features, including the ribbon, status bar, zoom, and various view modes.

5 videos | 19m Assessment Badge

Creating, Saving & Sharing Workbooks

Excel 2016 is highly customizable and easy to share with others. Learn how to create, manage, and save documents; insert headers and footers; edit document properties; and protect and share your workbooks.

19 videos | 1h 13m Assessment Badge

Inserting & Manipulating Data

Excel 2016 contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range.

16 videos | 1h 3m Assessment Badge

Formatting Data

Formatting data makes it easier to see and work with. Discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2016 to change data presentation.

14 videos | 51m Assessment Badge

Illustrating Documents

An Excel 2016 worksheet can contain more than just numbers and text. Discover how to insert and edit images, screenshots, and shapes; insert hyperlinks; and use the new Smart Lookup feature.

6 videos | 28m Assessment Badge

Basic Formulas

The power of Excel 2016 is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM and COUNT, perform rounding and ranking, and generate random numbers.

12 videos | 48m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Working with Databases

Access 2016 is the database application in the Microsoft Office 2016 suite. Discover how to open existing databases and create new ones, and learn how you can customize the interface, including the Quick Access Toolbar and ribbon.

6 videos | 27m Assessment Badge

Saving, Printing & Exporting Databases

Data is key for any database application, and you'll want to be able to save, protect, and share it. Discover how to save data, protect your database, print database items, export a database, and send tables via email in Access 2016.

6 videos | 26m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Illustrating Presentations

A picture speaks a thousand words, but why stop there? Explore the graphic elements of PowerPoint, from working with images to audio and video files, hyperlinks, bookmarks, tables, equations, and inserting other file types.

18 videos | 1h 4m Assessment Badge

Creating Graphics & Diagrams

Good presentations often require good visual elements that speak louder than words. Explore custom shapes, fill effects, shape effects, charts, and SmartArt.

9 videos | 22m Assessment Badge

Adding Animations

Presentations are far more impactful for the audience when animation is added to the mix. Discover how to create, customize, and manage animations in PowerPoint.

8 videos | 29m Assessment Badge

Preparing & Delivering Slideshows

Ready to go live? All that work you put into your presentation has come to this. It's time to prepare and deliver your slideshow, from working with notes and action buttons to annotation and custom slide shows.

11 videos | 42m Assessment Badge

Configuring PowerPoint

PowerPoint is ready to use out of the box, but configuring it can make it even better. Discover how to customize the view, interface, Quick Access Toolbar, and ribbon.

5 videos | 17m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Formatting Email

There are numerous formatting techniques that can be applied to Outlook 2016 emails. Discover how to format text, use lists, work with styles and templates, and manage signatures.

13 videos | 57m Assessment Badge

Organizing Email

To be productive, you need to keep your Outlook 2016 emails organized. Explore how to mark, flag, categorize, filter, and sort emails; use conversations and folders; use conditional formatting; and handle junk email.

19 videos | 1h 15m Assessment Badge

Configuring the Client

Customize Outlook 2016 to make it your own. Learn how to add multiple accounts; work with RSS feeds; customize the interface, ribbon, and Quick Access Toolbar; and use the import and export function.

11 videos | 53m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Custom & Conditional Formatting

To customize data, you can use the built-in formats in Excel 2016, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.

7 videos | 31m Assessment Badge

Finding, Sorting & Filtering Data

Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping.

11 videos | 45m Assessment Badge

Referencing Data

Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.

10 videos | 47m Assessment Badge

Working with Formulas

In addition to simple formulas, Excel 2016 has the power to solve more complex calculations. Explore how to calculate loan interest and payments, use the Goal Seek and forecast tools, and find and prevent duplicate values.

10 videos | 40m Assessment Badge

Creating Charts & Graphics

Analyze and present your data in a visually attractive manner in Excel 2016. Learn how to insert and customize charts, create chart templates, work with different chart types, and use trendlines.

15 videos | 1h 7m Assessment Badge

Using Conditional Formulas

In some cases, you may need to create formulas using data based on specific criteria in your range. Learn how to create and work with conditional formulas in Excel 2016, including SUMIF, SUMIFS, and SUMPRODUCT.

9 videos | 41m Assessment Badge

Extracting Information with Formulas

Excel 2016 has a number of formulas for extracting both numeric and textual data from cells. Discover how to use some of these formulas, including MONTH, DAY, YEAR, MAX, MIN, CONCATENATE, SEARCH, LEN, LOOKUP, and VLOOKUP.

13 videos | 49m Assessment Badge

Configuring Options & Settings

Get more out of Excel 2016 by customizing it to your own needs. Learn how to manage your account, connected services, and add-ins; configure input and formula options; and customize the interface, ribbon, and Quick Access Toolbar.

8 videos | 28m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Tables, Fields, & Entries

To get the most out of Access 2016, you need to understand the structure and main elements of a database. Explore tables, primary keys, and relationships, and discover how to format and edit both fields and field properties.

9 videos | 39m Assessment Badge

Inserting, Importing, & Formatting Data

There is little value in an empty database table. Learn how to enter and import data, change formatting settings, create dropdown menus, enforce data validation, and create labels with your data.

8 videos | 35m Assessment Badge

Finding & Organizing Data

As your tables get larger, it gets harder to locate specific data. Discover how to sort and filter data, edit indexes, search for data, and locate duplicate values and records.

6 videos | 24m Assessment Badge

Creating Forms & Queries

Forms in Access 2016 are designed to help you visualize records and create new data entries more easily. Discover different ways to create and customize forms, and create and work with queries.

16 videos | 1h 16m Assessment Badge

Using the Report & Analysis Tools

For data to be useful, it must be accurate and presented in a meaningful way. Learn how to use the Access 2016 tools to create and customize reports, and to analyze and clean your data to help ensure data integrity.

5 videos | 28m Assessment Badge

FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

BOOKS INCLUDED

Book

Word 2016 For Professionals For Dummies

Packed with information to take the guesswork out of Microsoft Word and help you work smarter and faster, this comprehensive guide leads you beyond basic word processing to get the most out of Word by learning to work with graphics, creating complexly-formatted documents, adding automation features to templates, collaborating with others, and sharing documents.

8h 8m By Dan Gookin

Book

Word 2016 in Easy Steps

Offering an invaluable tool for both newcomers and those upgrading from older versions, this clear, concise and colorful visual reference guide uses detailed images and easy-to-follow instructions to quickly get you up to speed with Word 2016.

1h 42m By Scott Basham

Book

Teach Yourself VISUALLY Word 2016

Are you a visual learner who prefers to see how Word works rather than hear a long-winded explanation? Let this book's straightforward, show-me-don't-tell-me approach help you quickly come to grips with all of Word's capabilities and get you up and running - and actually using them - in no time.

2h 57m By Elaine Marmel

Book

Word 2016 For Dummies

Written by the author of the first-ever For Dummies book, Dan Gookin, this friendly, easy-to-follow guide quickly and painlessly gets you up to speed on mastering the world's number one word processing software. Learn to format multiple pages, develop styles, build distinctive templates, add creative flair to your documents with images and tables, and more.

4h 54m By Dan Gookin

FREE ACCESS

BOOKS INCLUDED

Book

Word 2016 For Dummies

4h 54m By Dan Gookin

Book

Teach Yourself VISUALLY Word 2016

2h 57m By Elaine Marmel

Book

Word 2016 in Easy Steps

1h 42m By Scott Basham

Book

Word 2016 For Professionals For Dummies

8h 8m By Dan Gookin

FREE ACCESS

BOOKS INCLUDED

Book

PowerPoint 2016 For Dummies

Taking the pain out of working with PowerPoint, this friendly, plain-English guide presents full-color illustrations and step-by-step instructions to show you how to create and edit slides, import data from other applications, collaborate with other users in the Cloud, add charts, clip art, sound, and video, and more.

4h 5m By Doug Lowe

Book

Teach Yourself VISUALLY PowerPoint 2016

Offering an effortless approach to creating winning presentations with the latest version of PowerPoint, this uncomplicated, accessible resource demonstrates how to create slides, dress them up using templates and graphics, add sound and animation, present in a business or Internet setting, and so much more.

3h 24m By Barbara Boyd, Ray Anthony

FREE ACCESS

BOOKS INCLUDED

Book

Outlook 2016 for Dummies

Giving you simple, clear explanations about how Outlook can work for you, this book is updated to reflect the latest and greatest features integrated into the Outlook 2016 user interface to ensure you're at the top of your Outlook game.

4h 27m By Bill Dyszel

FREE ACCESS

BOOKS INCLUDED

Book

Excel 2016 Bible

Written by expert author and Excel Guru John Walkenbach, this comprehensive, go-to guide will lead you through the powerful new features and capabilities of Excel and teach you to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.

14h 51m By John Walkenbach

Book

Essential Excel 2016: A Step-by-Step Guide

Loaded with screen shots, step-by-step instructions, and reader exercises, this complete guide shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it.

7h 14m By David Slager

Book

Excel 2016 in Easy Steps

Using detailed images and easy-to-follow instructions to get you up to speed with Excel, this concise yet comprehensive guide shows you how to quickly get to grips with the new features of Microsoft's latest version of this popular spreadsheet application.

1h 38m By Michael Price, Mike McGrath

Book

Excel 2016 Formulas

Offering all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas, this comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more.

10h 54m By Dick Kusleika, Michael Alexander

Book

Excel 2016 All-in-One For Dummies

If you're looking to bring your Excel skills from "meh" to excellent, this friendly guide offers everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic, and beyond.

14h 6m By Greg Harvey

Book

Excel 2016 For Dummies

Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest version of Microsoft Excel quickly and painlessly.

6h 57m By Greg Harvey

Book

Teach Yourself VISUALLY Excel 2016

Packed with visually rich tutorials and step-by-step instructions that will help you take your Excel skills to new heights, this friendly and approachable guide will have you creating, editing, and manipulating Excel spreadsheets in no time.

3h 5m By Paul McFedries

FREE ACCESS

BOOKS INCLUDED

Book

Access 2016 Bible

With clear guidance toward everything from the basics to the advanced, this go-to reference provides everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way.

16h 22m By Dick Kusleika, Michael Alexander

Book

Access 2016 For Dummies

Written in a friendly and accessible manner, yet assuming no prior Access or database-building knowledge, this helpful guide walks you through the basics of creating tables to store your data, building forms that ease data entry, writing queries that pull real information from your data, and creating reports that back up your analysis.

5h 44m By Ken Cook, Laurie Ulrich Fuller