الدخول جرب مجانًا

Follow us

مرحبًا بك في Bookboon

لكي نتمكن من توفير خدماتنا، نعتمد على سلسلة من ملفات تعريف الأرتباط الأساسية التي تساعد مستخدمينا على الاستفادة من على المزايا التي نقدمها.

عرض بيانات ملفات تعريف الارتباط
الفئات الشركات
كتب Professional الإلكترونية

Excel 2010 Advanced

بواسطة Stephen Moffat, The Mouse Training Company
(425 التقييمات)
8 التعليقات
256
اللغة:  English
This Excel 2010 eBook should be used as a point of reference after following attendance of the advanced level Excel 2010 training course.
اشتراك Professional Plus ‏‎‎مجاني‎‎ لأول ‎30‎ ‏يوم‎‎ ثم ‏ $6.99 شهريًا بعد ذلك
الوصول إلى هذا العنوان على منصة bookboon
الوصف
المحتوى
التعليقات

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.

  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
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.
Michael
Fantastic book
Peter
It is a good book to get an advanced look into Excel
Edward Blake
I like it, I have used it a lot. I can highly recommend it!
Excellent
More reviews
اكتب تعليقًا
نبذة عن المؤلف

Stephen Moffat, The Mouse Training Company

تعرف على المؤلف
محتوى مُشابِه