Microsoft Office Specialist on Microsoft Office 2016: 77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation beginner
Certification Exam:
Expertise:
- 5 Courses | 5h 10m 22s
- 4 Books | 17h 41m
- Includes Test Prep
- 8 Courses | 6h 51m 41s
- 4 Books | 17h 41m
- 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 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 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 in Word 2016 for Windows
-
2m 30s
-
3m 21s
GETTING STARTED
Shaping & Structuring Documents in Word 2016 for Windows
-
4m 4s
-
5m 41s
GETTING STARTED
Getting Started in PowerPoint 2016 for Windows
-
2m 28s
-
3m 55s
GETTING STARTED
Getting Started in Excel 2016 for Windows
-
2m 53s
-
4m 13s
GETTING STARTED
Working with Databases in Access 2016 for Windows
-
4m 3s
-
4m 58s
GETTING STARTED
Illustrating Presentations in PowerPoint 2016 for Windows
-
2m 24s
-
2m 17s
GETTING STARTED
Formatting Email in Outlook 2016 for Windows
-
5m 18s
-
6m 34s
GETTING STARTED
Custom & Conditional Formatting in Excel 2016 for Windows
-
5m 34s
-
3m 17s
GETTING STARTED
Tables, Fields, & Entries in Access 2016 for Windows
-
5m 37s
-
2m 48s
COURSES INCLUDED
Opening & Setting Up in Word 2016 for Windows
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 in Word 2016 for Windows
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 in Word 2016 for Windows
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 in Word 2016 for Windows
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 in Word 2016 for Windows
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
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Shaping & Structuring Documents in Word 2016 for Windows
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 in Word 2016 for Windows
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 in Word 2016 for Windows
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 in Word 2016 for Windows
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 in Word 2016 for Windows
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 in Word 2016 for Windows
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 in Word 2016 for Windows
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 in Word 2016 for Windows
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
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Getting Started in PowerPoint 2016 for Windows
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 in PowerPoint 2016 for Windows
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 in PowerPoint 2016 for Windows
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 in PowerPoint 2016 for Windows
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 in PowerPoint 2016 for Windows
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 in PowerPoint 2016 for Windows
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
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Setting Up in Outlook 2016 for Windows
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 in Outlook 2016 for Windows
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 in Outlook 2016 for Windows
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 in Outlook 2016 for Windows
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 in Outlook 2016 for Windows
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
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Getting Started in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Working with Databases in Access 2016 for Windows
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 in Access 2016 for Windows
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
COURSES INCLUDED
Illustrating Presentations in PowerPoint 2016 for Windows
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 in PowerPoint 2016 for Windows
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 in PowerPoint 2016 for Windows
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 in PowerPoint 2016 for Windows
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 2016 for Windows
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
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Formatting Email in Outlook 2016 for Windows
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 in Outlook 2016 for Windows
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 in Outlook 2016 for Windows
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
COURSES INCLUDED
Custom & Conditional Formatting in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 Excel 2016 for Windows
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 in Excel 2016 for Windows
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 Excel 2016 for Windows
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Tables, Fields, & Entries in Access 2016 for Windows
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 in Access 2016 for Windows
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 in Access 2016 for Windows
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 in Access 2016 for Windows
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 in Access 2016 for Windows
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
SHOW MORE
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 DummiesPacked 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 StepsOffering 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 2016Are 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 DummiesWritten 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
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Word 2016 For DummiesWritten 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
Book
Teach Yourself VISUALLY Word 2016Are 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 in Easy StepsOffering 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
Word 2016 For Professionals For DummiesPacked 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
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
PowerPoint 2016 For DummiesTaking 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 2016Offering 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
BOOKS INCLUDED
Book
Outlook 2016 for DummiesGiving 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
BOOKS INCLUDED
Book
Excel 2016 BibleWritten 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 GuideLoaded 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 StepsUsing 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 FormulasOffering 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 DummiesIf 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 DummiesWhether 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 2016Packed 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
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Access 2016 BibleWith 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 DummiesWritten 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
BOOKS INCLUDED
Book
PowerPoint 2016 For DummiesTaking 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 2016Offering 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
BOOKS INCLUDED
Book
Outlook 2016 for DummiesGiving 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
BOOKS INCLUDED
Book
Excel 2016 BibleWritten 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
Advance Excel 2016 Training GuideExplaining the difficult concepts in a familiar language, this comprehensive book offers a variety of examples along with their systematically worked out solutions, covering the complex functionality of Excel 2016.
1h 11m
By Ritu Arora
Book
Essential Excel 2016: A Step-by-Step GuideLoaded 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 StepsUsing 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 FormulasOffering 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 DummiesIf 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 DummiesWhether 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
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Access 2016 BibleWith 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 DummiesWritten 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
Book
Microsoft Access 2016 Programming Pocket PrimerShowing you only the things you need to know to feel at home with VBA, this quick, concise guide presents Access programming fundamentals that can also apply to Excel programming.
3h 30m
By Julitta Korol
Book
Microsoft Access 2016 Programming by Example with VBA, XML, and ASPTaking nonprogrammers through detailed steps of creating Access databases from scratch, this thorough resource shows them how to retrieve and manage their data programmatically using various programming languages and techniques.
14h 57m
By Julitta Korol
SHOW MORE
FREE ACCESS