Choose a category

ISBN
1 edición
Páginas : 184
• Price: 129,00 kr
• Price: €13,99
• Price: £13,99
• Price: ₹250
• Price: \$13,99
• Price: 129,00 kr
• Price: 129,00 kr

## Descarga GRATIS tus ebooks en 4 sencillos pasos

Lo sentimos, pero para poder descargar nuestros libros o ver nuestros vídeos, necesitas un navegador que permita JavaScript.
Después de introducir tu dirección de correo electrónico, recibirás un correo de confirmación. Confirma este correo para recibir el boletín de noticias mensual con respecto a libros de texto gratuitos. Los datos de contacto que nos proporciones no serán proporcionados a terceros.

## This is a Premium eBook

### You can get free access for a month to this - and 800 other books with the Premium Subscription. You can also buy the book below

• Start a 30-day free trial. After trial: 39,99 kr p/m
• Start a 30-day free trial. After trial: €5,99 p/m
• Start a 30-day free trial. After trial: £4,99 p/m
• Start a 30-day free trial. After trial: ₹299 p/m
• Start a 30-day free trial. After trial: \$3,99 p/m
• Start a 30-day free trial. After trial: 39,99 kr p/m
• Start a 30-day free trial. After trial: 39,99 kr p/m

## Acerca del libro

### Opiniones

Excellent.

#### Andewi ★★★★★

Excellent book. Easy to be followed. Thank you.

#### sames2009@gmail.com ★★★★★

Easy to use and apply.

#### Dr. Zulkhar Nain ★★★★★

This is a simple to understand book. I appreciate the efforts made in writing it.

### Descripción

This user guide will introduce you to some of Excel’s more complex functionality. Specifically when analysing data.

You will learn how to:

1. Use Conditional Logic in a formula – IF statements
2. Use the SumIF and CountIF functions
3. Produce a chart
4. Sort and filter
5. Apply subtotals
6. Introduction to Pivot Tables
7. Introduction to Macros

### Contenido

1. Apply Conditional Logic in formula
1. IF Function (IF Statement)
2. Nested IF Function
3. Countif Function
4. Sumif Function
2. Create and apply Range Names
1. Defining a Named Cell or Range of Cells
2. Using a Named Cell in a formula
3. Naming a range of cells
4. Editing and renaming a named range
5. Define a Name Using the Dialogue Box
3. Charts
1. Using Quick Analysis
2. Recommended Charts
3. Creating charts with the keyboard
4. Creating line charts
5. Creating and editing a column chart
6. Creating pie charts
7. Modifying charts using the Ribbon
8. Modifying charts using icons
9. Formatting charts – Task Pane
4. Apply and manipulate illustrations
1. Pictures in Excel
2. Resize the picture – dragging
3. Modify a picture
4. Reset a picture
5. SmartArt
1. SmartArt
6. Shapes
1. Inserting shapes into a workbook
7. Screenshots
1. Inserting a screenshot
9. Sorting data
1. Databases in Excel – introduction
2. Sort data
3. Sort on font colour
4. Sort on cell colour
5. Sort on cell icon
10. Filtering data
1. Filter data – the filter icon
2. Filter on text
3. Filter on more than one column
4. Remove the filter
5. Filter data on colour
6. Text filters
7. Number filters
8. Date filters
11. Format as table
1. Reasons to use Tables in Excel
2. Format as table icon
3. Insert a table
4. Change table style
5. Remove formatting
6. Name the table
7. Calculated columns
9. Convert back to a range (remove automatic functionality)
12. Filter a table
1. Filter a table
2. Filter a table with a total row
3. Insert a slicer
4. Customize a slicer
5. Delete a slicer
13. Grouping and outlining
1. Outlining
2. Create an automatic outline
14. Subtotals
1. Why use subtotals?
2. Sort first
3. Remove subtotals
15. Apply conditional formatting
1. Conditional formatting
2. Top and bottom rules
3. Data bars
4. Colour scales
5. Icon sets
6. Clear conditional formatting
7. Use a formula to control conditional formatting
16. Sparkline charts
1. Sparkline line chart
2. Column spark lines
3. Creating a win/loss spark line chart
4. Remove a spark line chart
17. Text functions
1. Text functions – an introduction
2. Concatenate
3. Trim
4. Upper
5. Lower
6. Proper
7. Right
8. Left
9. Mid
18. Quick analysis
1. Quick analysis
2. Quick analysis Formatting
3. Quick analysis totals
4. Quick analysis Charts
5. Quick analysis Tables
6. Quick analysis sparklines
19. Macros
1. What is a Mmcro
2. Macro security