Xem mẫu
Excel 2007 Advanced: Part II
Stephen Moffat, The Mouse Training Company
Download free books at
Stephen Moffat, The Mouse Training Company
Excel 2007 Advanced Part II
2
Download free eBooks at bookboon.com
Excel 2007 Advanced: Part II
© 2012 Stephen Moffat, The Mouse Training Company & bookboon.com ISBN 978-87-403-0035-2
3
Download free eBooks at bookboon.com
Excel 2007 Advanced: Part II Contents
Contents
Introduction Part I
Section 1 Advanced worksheet Functions Part I 1.1 Names Part I 1.2 Using Names Part I 1.3 Conditional & Logical Functions Part I 1.4 AND, OR, NOT Part I 1.5 Lookup Functions Part I 1.6 Other Useful Functions Part I 1.7 Data consolidation Part I
Section 2 Views, Scenarios, goal seek and solver Part I 2.1 Goal Seeking and Solving Part I 2.2 Views & Scenarios Part I
Section 3 Using Excel to Manage Lists Part I 3.1 Excel Lists, List Terminology Part I 3.2 Sorting Data Part I 3.3 Adding Subtotals to a List Part I 3.4 Filtering a List Part I
www.sylvania.com
We do not reinvent the wheel we reinvent light.
Fascinating lighting offers an infinite spectrum of possibilities: Innovative technologies and new markets provide both opportunities and challenges. An environment in which your expertise is in high demand. Enjoy the supportive working atmosphere within our global group and benefit from international career paths. Implement sustainable ideas in close cooperation with other specialists and contribute to influencing our future. Come and join us in reinventing light every day.
Light is OSRAM
4
Click on the ad to read more
Download free eBooks at bookboon.com
Excel 2007 Advanced: Part II Contents
3.5 List Statistics Part I 3.6 Pivottables Part I 3.7 Managing Pivottables Part I
Section 4 Charts 7 4.1 Introduction to Charting 8 4.2 Formatting Charts 20
Section 5 Templates 41 5.1 Introduction to Templates 42
Section 6 Auditing 48 6.1 Auditing Features 49
Section 7 Other formatting 54 7.1 Formatting Cells 54
Section 8 Other Excel features 69 8.1 Inserting, Formatting and Deleting Objects 69 8.2 Reviewing 80 8.3 Proofing Tools 93
360° thinking
Discover the truth at www.deloitte.ca/careers
5
Download free eBooks at bookboon.com
© Deloitte & Touche LLP and affiliated entities.
Click on the ad to read more
...
- tailieumienphi.vn
nguon tai.lieu . vn