An edition of Excel 2013 Core: Advanced
(2013)
Excel 2013 Core: Advanced
by Shelley Fishel
- 0 Ratings
- 0 Want to read
- 0 Currently reading
- 0 Have read
Share
×Close
Last edited by Tom Morris
September 7, 2022 | History
This user guide will introduce you to some of Excel’s more complex functionality. Specifically when analysing data.
You can download the book for free via the link below.
Publish Date
2013
Publisher
Bookboon.com
Check nearby libraries
Buy this book
| Edition | Availability |
|---|---|
1
|
aaaa
Libraries near you:
WorldCat
|
Book Details
Table of Contents
Obsah
Apply Conditional Logic in formula
IF Function (IF Statement)
Nested IF Function
COUNTIF Function
SUMIF Function
Create and apply Range Names
Defining a Named Cell or Range of Cells
Using a Named Cell in a formula
Naming a range of cells
Editing and renaming a named range
Define a Name Using the Dialogue Box
Sum a range
Charts
Using Quick Analysis
Recommended Charts
Creating charts with the keyboard
Creating line charts
Creating and editing a column chart
Creating pie charts
Modifying charts using the Ribbon
Modifying charts using icons
Formatting charts – Task Pane
Apply and manipulate illustrations
Pictures in Excel
Resize the picture – dragging
Modify a picture
Reset a picture
SmartArt
SmartArt
Shapes
Inserting shapes into a workbook
Screenshots
Inserting a screenshot
Manage comments
Inserting and editing comments
Deleting comments
Show/Hide Comments
Moving between comments
Printing comments
Sorting data
Databases in Excel – introduction
Sort data
Sort on font colour
Sort on cell colour
Sort on cell icon
Filtering data
Filter data – the filter icon
Filter on text
Filter on more than one column
Remove the filter
Filter data on colour
Text filters
Number filters
Date filters
Format as table
What is format as table
Format as table icon
Insert a table
Change table style
Remove formatting
Name the table
Calculated columns
Add a total row
Convert back to a range (remove automatic functionality)
Filter a table
Filter a table
Filter a table with a total row
Insert a slicer
Customize a slicer
Delete a slicer
Grouping and outlining
Outlining
Create an automatic outline
Subtotals
Why use subtotals?
Sort first
Subtotals command
Remove subtotals
Apply conditional formatting
Conditional formatting
Top and bottom rules
Data bars
Colour scales
Icon sets
Clear rules
Use a formula to control conditional formatting
Sparkline charts
Sparkline line chart
Column spark lines
Creating a win/loss spark line chart
Remove a spark line chart
Text functions
Text functions – an introduction
Concatenate
Trim
Upper
Lower
Proper
Right
Left
Mid
Quick analysis
Quick analysis
Quick analysis Formatting
Quick analysis totals
Quick analysis Charts
Quick analysis Tables
Quick analysis sparklines
Macros
What is a Mmcro
Macro security
Get ready
Get set and go
Run the macro
Index
ID Numbers
Links outside Open Library
Community Reviews (0)
Feedback?
| September 7, 2022 | Edited by Tom Morris | merge authors |
| August 12, 2015 | Edited by Alice Kirk | Edited without comment. |
| August 12, 2015 | Created by Alice Kirk | Added new book. |