Skip navigation

Bookboon.com Download free eBooks and textbooks

Choose a category

Excel 2010 Advanced

Excel 2010 Advanced
4.5 (253 reviews) Read reviews
ISBN: 978-87-7681-788-6
1 edition
Pages : 256
Price: Free

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.

This is a Premium eBook - get it free for 30 days

You can also read this in Bookboon.com Premium

Summary

This free Excel 2010 eBook should be used as a point of reference after following attendance of the advanced level Excel 2010 training course.

300+ Business books exclusively in our Premium eReader

  • No adverts
  • Advanced features
  • Personal library
More about Premium

Buy this eBook

Buy now

Subscribe to all 800+ eBooks

Start free trial 30 day FREE trial

About the book

  1. Description
  2. Content
  3. Embed
  4. Reviews

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
  2. Conditional & Logical Functions
    Counting And Totalling Cells Conditionally
    And, Or, Not
    Lookup Functions

  3. Views, scenarios, goal seek, solver
  4. Goal Seeking And Solving
    Advanced Solver Features
    Scenarios
    Views

  5. Using excel to manage lists
  6. Excel Lists,List Terminology
    Sorting Data
    Subtotals
    Filtering A List
    Advanced Filtering
    Criteria Tips
    Multiple Criteria
    Calculated Criteria
    Data Consolidation
    Pivottables
    Modifying A Pivottable
    Managing Pivottables
    Formatting A Pivottable
    Banding
    Slicers

  7. Charts
  8. Introduction To Charting 143 Creating Charts 145 Formatting Charts 157 Changing The Chart Layout 163 Sparklines

  9. Templates
  10. Introduction To Templates
    Create Custom Templates

  11. Drawing and formatting
  12. Inserting, Formatting And Deleting Objects
    More Formatting

  13. Excel tools
  14. Reviewing
    Auditing
    Proofing Tools

Embed

Size
Choose color
Implementation code. Copy into your own page
Embed Frame - Terms of Use

The embed frame is free to use for private persons, universities and schools. It is not allowed to be used by any company for commercial purposes unless it is for media coverage. You may not modify, build upon, or block any portion or functionality of the embed frame, including but not limited to links back to the bookboon.com website.

The Embed frame may not be used as part of a commercial business offering. The embed frame is intended for private people who want to share eBooks on their website or blog, professors or teaching professionals who want to make an eBook available directly on their page, and media, journalists or bloggers who wants to discuss a given eBook

If you are in doubt about whether you can implement the embed frame, you are welcome to contact Thomas Buus Madsen on tbm@bookboon.com and seek permission.

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!