Skip navigation

Bookboon.com Download free eBooks and textbooks

Choose a category

Excel 2016 Advanced

Excel 2016 Advanced
4.8 (72 reviews)
ISBN: 978-87-403-1199-0
1 edition
Pages : 184
  • Price: 129.00 kr
  • Price: €13.99
  • Price: £13.99
  • Price: ₹250
  • Price: $13.99
  • Price: 129.00 kr
  • Price: 129.00 kr

Download for FREE in 4 easy steps...

We are terribly sorry, but in order to download our books or watch our videos, you will need a browser that allows JavaScript.
After entering your email address, a confirmation email will be sent to your inbox. Please approve this email to receive our weekly eBook update. We will not share your personal information with any third party.
eLib
Unlock your organization's learning potential
See Demo

Corporate eLibrary

Discover our employee learning solutions

This is a Premium eBook

Bookboon Premium - Gain access to over 800 eBooks - without ads

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
eLib
Unlock your organization's learning potential
Click here!

Corporate eLibrary

Discover our employee learning solutions

About the book

  1. Description
  2. Content
  3. About the Author

Description

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

You will learn how to:

  • Use Conditional Logic in a formula – IF statements
  • Use the SumIF and CountIF functions
  • Produce a chart
  • Sort and filter
  • Apply subtotals
  • Introduction to Pivot Tables
  • Introduction to Macros

Content

  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
  8. Manage comments
    1. Inserting and editing comments
    2. Deleting comments
    3. Show/Hide Comments
    4. Moving between comments
    5. Printing comments
  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
    8. Add a total row
    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
    3. Get ready
    4. Get set and go
    5. Run the macro

About the Author

Shelley Fishel has more than a dozen years’ experience in helping people to get more from their computers. After working for an IT training organization Shelley decided to ‘do her own thing’ when she realized the limitations of delivering standard courses.

“Why waste time and money on training people in areas that are not relevant to them? It’s common sense to invest that time and effort on what they really need.”

That was the ‘light bulb moment’ and the IT Training Surgery’s unique approach has resulted in a growing business with a team of highly qualified IT trainers.

“If trainees get bored they forget most of what they learn. We like to offer a range of training approaches to suit different people and, most of all; we aim to make training fun!”

Shelley and her team have worked hard to achieve accreditation by the Learning and Performance Institute for the IT Training Surgery, as a recognized high quality provider of IT training,

To find out more about our training give us a call on 020 8203 1774 or visit our website www.theittrainingsurgery.com

This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with EU regulation.