This 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.
Advanced worksheet functions
Conditional & Logical Functions
Counting And Totalling Cells Conditionally
And, Or, Not
Views, scenarios, goal seek, solver
Goal Seeking And Solving
Advanced Solver Features
Using excel to manage lists
Excel Lists,List Terminology
Filtering A List
Modifying A Pivottable
Formatting A Pivottable
Introduction To Charting 143 Creating Charts 145 Formatting Charts 157 Changing The Chart Layout 163 Sparklines
Introduction To Templates
Create Custom Templates
Drawing and formatting
Inserting, Formatting And Deleting Objects
Ce livre est excellent, vous trouverez tout ce dont vous avez besoin.
My productivity levels have never been boosted this massively. The book is a must have for every individual and office.
Great resource, a true treasure for those who want to handle Excel 2010 with ease.
This is useful for students, thank you for publishing this book.
It is a good book to get an advanced look into Excel
I like it, I have used it a lot. I can highly recommend it!