UL Home Human Resources HR Talent Development Microsoft Tips and Tricks Microsoft Tips and Tricks Microsoft OutlookAdd a contactAdd and request read receipts and delivery notificationsAllow someone else to manage your mail and calendarAttach files or insert pictures in Outlook email messagesChange how you view your Outlook calendarChange the default font or text color for email messagesCreate an email messageCreate and add a signature to messagesCreate and send email in OutlookCreate and use contact groupsCreate appointments and meetingsDelay or schedule sending email messagesDelete an emailExport contacts from OutlookIgnore all email messages in a conversationImport contacts to OutlookManage your calendar and contacts in OutlookMark a message as read or unreadRecall or replace an email message that you sentReply to or forward an email messageSchedule a meeting with other peopleSearch and filter emailSend automatic Out of Office replies from OutlookSend an automatic reply emailSet or remove remindersSet up your Outlook mobile appShare your calendar with other peopleUse and configure the Reading Pane to preview messagesUse calendar categoriesUse Conversation Clean Up to delete redundant messagesUse folders to organize your inboxMicrosoft ExcelCollaborate on Excel workbooks at the same time with co-authoringCreate a PivotTable to analyze worksheet dataFormat elements of a chartLock or unlock specific areas of a protected worksheetUse sparklines to show data trendsAdd a watermark in ExcelAlign or rotate text in a cellAnalyze and format in ExcelAnalyze your data instantlyAnnotate a worksheet by using commentsApply data validation to cellsAutomatically number rowsAvailable number formatsCalculate the difference between two datesChange the format of a cellCollaborate in ExcelCombine text from two or more cells into one cellConditional formattingCopy cell formatting with the Format PainterCOUNTIF functionCreate a chart from start to finishCreate a list of sequential datesCreate a PivotChartCreate a workbook in ExcelCreate and format tablesCreate or delete a custom number formatDefine and use names in formulasDisplay or hide zero valuesFilter data in a PivotTableFilter data in a range or tableFilter for unique values or remove duplicate valuesFind or replace text and numbers on a worksheetFreeze panes to lock rows and columnsGroup or ungroup data in a PivotTableHide or show rows or columnsIF functionIFSImport or export text (.txt or .csv) filesInsert or delete cells, rows, and columnsLearn more about ExcelMerge and unmerge cellsMove or copy cells and cell contentsOverview of formulas in ExcelProtect an Excel fileResize a table, column, or rowSave or convert to PDFSee files others have shared with youSelect cell contents in ExcelSet up your Excel mobile appShare your Excel workbook with othersSort data in a tableSplit text into different columns with the Convert Text to Columns WizardSUM functionSUMIFSUMIFSTotal the data in an Excel tableUpdate the data in an existing chartUse slicers to filter dataUse the Field List to arrange fields in a PivotTableVLOOKUPMicrosoft WordApply themesCheck spelling, grammar, and clarityCreate newsletter columnsInsert picturesResearch, edit, and design in WordAccept tracked changesAdd a border to a pageAdd a watermarkAdd a watermarkAdd and edit textAdd and format textApply stylesChange marginsChange page orientation to landscape or portraitChange the line spacing in WordCollaborate on Word documents with real-time co-authoringConvert or save to PDFCreate a bulleted or numbered listCreate a document in WordCreate a table of contents Edit a PDF Find and replace text Insert a header or footer Insert a page break Insert a table Insert a table Insert hyperlinks Insert icons Insert icons Insert or delete a comment Insert page numbers Insert pictures Insert WordArt Insert WordArt Learn more about Word Print an envelope Print mailing labels Print return address labels Print your document Remove hyperlinks Rotate a picture or shape Rotate a picture or shape Save a document Set up your Word mobile app Share a document Show or hide the ruler Show or hide the ruler Show word count Track changes in Word Use Word on a mobile device Wrap text around a picture Wrap text around a pictureOne DriveUL One Drive - My Workstation
