Skip navigation

Bookboon.com Download free eBooks and textbooks

Choose a category

Excel 2010 Advanced

Excel 2010 Advanced
4.6 (334 reviews) Read reviews
ISBN: 978-87-7681-788-6
1 edition
Pages : 256
  • Price: 29.99 kr
  • Price: €3.99
  • Price: £3.99
  • Price: ₹150
  • Price: $3.99
  • Price: 29.99 kr
  • Price: 29.99 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.
Please enter your work email address.
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
Click here!

Corporate eLibrary

Discover our Business Solutions for employee learning

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 Business Solutions for employee learning

About the book

  1. Reviews
  2. Description
  3. Content

Reviews

Balilou ★★★★★

Ce livre est excellent, vous trouverez tout ce dont vous avez besoin.

Buti Motloung ★★★★★

My productivity levels have never been boosted this massively. The book is a must have for every individual and office.

George ★★★★★

Great resource, a true treasure for those who want to handle Excel 2010 with ease.

Ahmad Shakeb ★★★★★

This is useful for students, thank you for publishing this book.

Edward Blake ★★★★★

I like it, I have used it a lot. I can highly recommend it!

Description

This free Excel 2010 eBook should be used as a point of reference after following attendance of the advanced level Excel 2010 training course. It covers all the topics taught and aims to act as a support aid for any tasks carried out by the user after the course.

The manual is divided into sections, each section covering an aspect of the advanced course. The table of contents lists the page numbers of each section and the table of figures indicates the pages containing tables and diagrams.

Content

  1. Advanced worksheet functions
    1. Conditional & Logical Functions
    2. Counting And Totalling Cells Conditionally
    3. And, Or, Not
    4. Lookup Functions
  2. Views, scenarios, goal seek, solver
    1. Goal Seeking And Solving
    2. Advanced Solver Features
    3. Scenarios
    4. Views
  3. Using excel to manage lists
    1. Excel Lists,List Terminology
    2. Sorting Data
    3. Subtotals
    4. Filtering A List
    5. Advanced Filtering
    6. Criteria Tips
    7. Multiple Criteria
    8. Calculated Criteria
    9. Data Consolidation
    10. Pivottables
    11. Modifying A Pivottable
    12. Managing Pivottables
    13. Formatting A Pivottable
    14. Banding
    15. Slicers
  4. Charts
    1. Introduction To Charting 143 Creating Charts 145 Formatting Charts 157 Changing The Chart Layout 163 Sparklines
  5. Templates
    1. Introduction To Templates
    2. Create Custom Templates
  6. Drawing and formatting
    1. Inserting, Formatting And Deleting Objects
    2. More Formatting
  7. Excel tools
    1. Reviewing
    2. Auditing
    3. Proofing Tools
This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with EU regulation.