Microsoft Office 2016: The Complete Guide (2015)

IDENTIFYING NEW FEATURES OF WORD 2016

WORKING IN THE WORD 2016 USER INTERFACE

OPENING, NAVIGATING, AND CLOSING DOCUMENTS

VIEWING DOCUMENTS IN DIFFERENT WAYS

STARTING, ENTERING TEXT IN, AND SAVING DOCUMENTS

MODIFYING TEXT

FINDING AND REPLACING TEXT

CORRECTING SPELLING AND GRAMMATICAL ERRORS

APPLYING STYLES TO TEXT

CHANGING A DOCUMENT’S THEME

MANUALLY CHANGING THE LOOK OF CHARACTER

MANUALLY CHANGING THE LOOK OF PARAGRAPHS

CREATING AND MODIFYING LISTS

PRESENTING INFORMATION IN COLUMNS

ADJUSTING AND PREVIEWING THE PAGE LAYOUT

MONITORING WHAT APPEARS ON A SEPARATE PAGE

DHOW TO PREPARE DOCUMENTS FOR ELECTRONIC DISTRIBUTION?

HOW TO DIGITALLY SIGN DOCUMENTS

SENDING AND PRINTING DOCUMENTS

MODIFYING AND INSERTING DIAGRAMS

CREATING TABBED LISTS

PRESENTING INFORMATION IN TABLES

FORMATTING TABLES

INSERTING AND MODIFYING PICTURES

INSERTING SCREEN CLIPPING

DRAWING AND MODIFYING SHAPES

ADDING WORDART TEXT

PUTTING IN AND ADJUSTING CHARTS

INCORPORATING PICTORIAL ELEMENTS

CATEGORIZE AND COORDINATE CONTENT

GENERATING DOCUMENTS THAT ARE TO BE USED EXTERNALLY

UTILIZING MAIL MERGE

ADDING OTHER FEATURES TO THE DOCUMENT

BEING MORE RESOURCEFUL IN WORD

FREQUENTLY USED SHORTCUTS – ACCESS KEYS

COPYING FORMATTING

INSERTING YOUR LISTNUM FIELD

CONCLUSION

WHERE DID IT ALL BEGIN?

EXCEL FOR WINDOWS

HOW TO INSERT A SERIES OF NUMBERS INTO A COLUMN?

HOW COPY AN EXCEL 2016 CHART TO ANOTHER OFFICE APPLICATION

HOW TO CHOOSE BETWEEN THE OPTIONS OF EMBEDDING OR LINKING A CHART

HOW TO PRODUCE A HYPERLINK TO A CURRENT FILE OR WEB PAGE

HOW TO GENERATE A HYPERLINK TO A DIFFERENT FILE

HOW TO CREATE A HYPERLINK TO A PARTICULAR DESTINATION IN A WORKBOOK

HOW TO CREATE OR REMOVE A HYPERLINK TO AN EMAIL ADDRESS

HOW TO REMOVE A HYPERLINK TO AN EMAIL ADDRESS

HOW TO SELECT A HYPERLINK AND NOT OPEN THE LINK

HOW TO CHANGE OR FORMAT A HYPERLINK

HOW TO COPY OR CHANGE/DELETE A HYPERLINK

HOW TO CREATE A NORMAL HYPERLINK WITH THE USE OF THE HYPERLINK FUNCTION

HOW TO CREATE AN EXTERNAL REFERENCE LINK TO WORKSHEET DATA ON THE WEB

HOW TO SET THE FOUNDATION ADDRESS FOR THE HYPERLINKS IN A WORKBOOK

HOW TO CREATE A PIVOTTABLE IN EXCEL 2016 TO EVALUATE WORKSHEET INFORMATION

HOW TO CHANGE THE DATA LAYOUT OF A PIVOT TABLE

FORMAT NUMBERS AS CURRENCY IN EXCEL 2016

SUBTRACTING NUMBERS IN EXCEL 2016 FOR WORKBOOKSS

CREATING A CHART IN EXCEL

ADD AND DELETE PAGE NUMBERS ON WORKSHEETS

CREATING A DROP-DOWN LIST IN EXCEL 2016 FOR WINDOWS

EXPORT XML DATA FROM EXCEL 2016

EXCEL CANNOT SAVE THE WORKBOOK BECAUSE IT DOESN’T HAVE ANY MAPPED RANGES

ADD A WATERMARK IN EXCEL

SHARE YOUR WORKBOOK

CREATE A FORECAST

GET & TRANSFORM FUNCTION IN EXCEL 2016

HOW TO COLLABORATE IN EXCEL 2016 BY USING A SHARED WORKBOOK

MORE NEW CHART TYPES

THE GET & TRANSFORM QUERY

THE ONE-CLICK FORECASTING

EXCEL 2016 3D MAPS

EXCEL 2016 MULTI-SELECT SLICER

PUBLISHING & SHARING YOUR ANALYSIS WITH POWER BI

INSERTING PICTURES WITH ACCURATE ORIENTATION

USING THE TELL ME FEATURE/a>

UTILIZING THE INSIGHT PANE

UTILIZING INK EQUATION

UTILIZING SIMPLER SHARE FEATURE

UTILIZING THE VERSION HISTORY FEATURE

ADDED NEW THEMES IN EXCEL 2016

THE EXCEL FUNCTION FOR iPhones

USING EXCEL 2016 FOR IPAD

EXCEL MOBILE FOR WINDOWS PHONE

Excel for Android

EXCEL FOR IPAD HELP

MICROSOFT EXCEL 2016 FOR MAC

PERFORMING VARIOUS FUNCTIONS IN EXCEL FOR MAС

New Features in Microsoft Excel 2016 for Mac

COMPARISONS: EXCEL 2016 FOR WINDOWS & FOR MAC