This e-book will shows you the newer Excel's basic and advanced features with tones of pictures and examples and in this way will help you to do your job quickly and more efficient. The presented examples are working under Excel 2010 for Windows and Excel for Mac 2011 too.
We will discuss about:
How to install Excel on Windows and Mac
Menu structure and the Ribbon
Formatting worksheets
Working with formulas
Working with functions (mathematical, logical, text, date and financial functions)
Manipulating data (sorting, filtering)
PivotTables and Reports
Visual presentation of the data (tables and diagrams)