lesson 8 maia dominguez

Concept Map Lesson 8: Using Data Tools

Importing Data from External Text Files

Replacing Data

Using Hyperlinks

Customizing the Quick Access Toolbar

Finding Data

On the Quick Access Toolbar, click Customize Quick Access Toolbar , then click a button in the list On the Quick Access Toolbar, click Customize Quick Access Toolbar , then click More Commands ; or Click File click Options , click Quick Access Toolbar ; or

A hyperlink is a clickable element in an electronic document that you can use to jump to or open another document You can use hyperlinks to launch web pages from the Internet or the internal corporate intranet open a workbook or document located on a computer (including your own) create a new workbook create an email with a specific set of recipients and a subject line ©

Escribe un título genial

Contextualiza tu tema con un subtítulo

No nos gusta aburrir. No queremos ser repetitivos. Comunicar como siempre aburre y no engancha. Lo hacemos diferente. Hacemos sabotaje al aburrimiento. Creamos lo que al cerebro le gusta consumir porque le estimula.

Enlace

Replacing Data

When replacing textUse Replace to replace the currently selected value with the new value Use Replace All to replace all applicable cells with the new value To activate the Replace command: On the Home tab, in the Editing group, click Find & Select , then click Replace ; or Press CTRL+H; or In the Find dialog box, click the Replace tab ©

Finding Data

You can use the Find feature to search a worksheet for every occurrence of:A value A function name A cell reference To activate the Find feature On the Home tab, in the Editing group, click Find & Select , then click Find ; or Press CTRL+F ©

File Origin Specify the character set used to create the data in the text file. Delimiter Specify the character used to separate each field of text in the text file. Data Type Detection Specify the number of rows in the text file that Excel uses to interpret the type of data contained in the text file. (Preview)