Office information

WEBSERVICE function: The function returns data from a web service on the Internet or Intranet. Support functions from Excel 2013 onwards. Syntax: WEBSERVICE (url)

Instructions on how to create notes for documents in Excel. You can customize the comment to a formula or to a data cell in a spreadsheet by doing the following steps: Step 1:

Instructions on how to use the search and replace function in Excel. You can customize the addition of a comment to a formula or to a data cell in a worksheet by performing the

Instructions on how to set up the AutoCorrect function in Excel. To set up the AutoCorrect function in Excel, do the following: Step 1: Go to the File - Option tab: Step 2: The

Instructions on how to protect spreadsheets in Excel. Protecting spreadsheets is an essential need of many users, thanks to this feature who makes spreadsheets can secure their

Instructions on how to insert and delete worksheets in Excel. 1. Insert a sheet (sheet) in Excel. Step 1: Right-click on any sheet (or you can choose a new sheet location) -

Detailed instructions to you how to choose images to make up the worksheet in Excel. To create wallpaper you follow these steps: 1. Create a wallpaper for spreadsheets from images

Instructions on how to change the color SheetTab and hide the worksheet display in Excel. SheetTab is where the names of the sheets are displayed so you need to color them to

Instructions on how to rename, copy and move spreadsheets in Excel. 1. How to change the name of the worksheet (sheet) in Excel - Method 1: + Double-click the worksheet name - when

Overview of the interface in Excel 2013, 2016. The following article helps you understand the overview of the interface in Excel 2013, 2016. When you open the Excel interface, work

You are in need of converting drawings in CAD files to Word for printing or presentations but do not know how to transfer? How to quickly convert CAD files to Word, keep the best

The following article introduces you in detail how to create a presentation from a template available in PowerPoint. Step 1: Open PowerPoint - go to File - New - select the

The following article introduces you in detail. Create slides from an existing slide in PowerPoint. Step 1: Open PowerPoint - go to File - Open - select the PowerPoint file to

Introduction Overview of the PowerPoint interface. 1. The interface contains commands and controls. 1.1 Title bar: At the top shows the name of the presentation. 1.2 Ribbon:

Introduce how to design a slide yourself in PowerPoint. Step 1: Open PowerPoint - go to File - New - click Blank Presentation:

Introduce how to Save a slide presentation file in PowerPoint. 1. Save a new presentation file. Step 1: Open PowerPoint - go to File - Save - choose a location to save the

Introduce how to open a slide file in PowerPoint. To open a PowerPoint file, do the following: Method 1: - Open PowerPoint - go to File - Open tab (or press Ctrl + O key

Introduce the basic operations with objects on Slide in PowerPoint 2013. The example on Silde has 2 objects as shown: The operations for working with 2 objects on Silde include: 1.

Instructions on how to filter advanced data in Excel. Data Filter (automatic data filtering) allows you to filter data only on a single column or data field -> so it is limited

Instructions on how to organize a database in Excel. Sorting data is indispensable when working in Excel. 1. Sort data simply. Step 1: Select the data range to be sorted - Data -