𝔖 Scriptorium
✦   LIBER   ✦

πŸ“

Excel 2007 Advanced. Part I

✍ Scribed by Moffat S.


Tongue
English
Leaves
131
Category
Library

⬇  Acquire This Volume

No coin nor oath required. For personal study only.

✦ Synopsis


The Mouse Training Company & Ventus Publishing ApS, 2012. – 131 p.

Contents:
Introduction.
Advanced worksheet Functions.
Names.
Using Names.
Conditional & Logical Functions.
AND, OR, NOT.
Lookup Functions.
Other Useful Functions.
Data consolidation.
Views, Scenarios, goal seek and solver.
Goal Seeking and Solving.
Views & Scenarios.
Using Excel to Manage Lists.
Excel Lists, List Terminology.
Sorting Data.
Adding Subtotals to a List.
Filtering a List.
List Statistics.
Pivottables.
Managing Pivottables.

✦ Subjects


Π‘ΠΈΠ±Π»ΠΈΠΎΡ‚Π΅ΠΊΠ°;ΠšΠΎΠΌΠΏΡŒΡŽΡ‚Π΅Ρ€Π½Π°Ρ Π»ΠΈΡ‚Π΅Ρ€Π°Ρ‚ΡƒΡ€Π°;Microsoft Office;Microsoft Excel


πŸ“œ SIMILAR VOLUMES


Excel 2007 Advanced. Part II
✍ Moffat S. πŸ“‚ Library 🌐 English

The Mouse Training Company & Ventus Publishing ApS, 2012. – 100 p.<div class="bb-sep"></div>Contents:<br/>Charts. <br/>Introduction to Charting. <br/>Formatting Charts. <br/>Templates. <br/>Introduction to Templates. <br/>Auditing. <br/>Auditing Features. <br/>Other formatting. <br/>Formatting Cells

Excel 2007 Introduction. Part I
✍ Moffat S. πŸ“‚ Library 🌐 English

The Mouse Training Company & Ventus Publishing ApS, 2012. – 115 p.<div class="bb-sep"></div>Contents:<br/>Introduction. <br/>The Basics. <br/>Windows Concepts. <br/>Getting Help. <br/>Microsoft Excel Help. <br/>Move Around and Enter Information. <br/>Moving. <br/>Useful Keys for Moving. <br/>Data En

Word 2007 Advanced. Part I
✍ Moffat S. πŸ“‚ Library 🌐 English

The Mouse Training Company & Ventus Publishing ApS, 2011. – 111 p.<div class="bb-sep"></div>Contents:<br/>Introduction.<br/>Advanced tables.<br/>Tables - advanced features.<br/>Table size and alignment.<br/>Advanced formatting techniques.<br/>Styles.<br/>Document Themes.<br/>Columns.<br/>Sections.<b

Excel 2007 Advanced Report Development
✍ Timothy Zapawa πŸ“‚ Library πŸ“… 2007 πŸ› Wiley 🌐 English

I bought this book because I already knew how to use excel but I wanted to be able to utilize some of the more advanced reporting functions. This book walks you through it with practice exercises and screen shots. More then worth the investment.

Excel 2007 Advanced Report Development
✍ Timothy Zapawa πŸ“‚ Library πŸ“… 2007 πŸ› Wiley 🌐 English

Create powerful, innovative reporting solutions with Excel 2007! With this new book, which is significantly updated from the bestselling Excel 2003 version, author Timothy Zapawa provides you with in-depth coverage of Excel 2007’s enhanced reporting capabilities. Discover what you can do with PivotT