Beschreibung
Major topics covered in this book are.
1.Introduction to Excel Formulae
2.String Formulae
3.Date and Time Formulae
4.Maths and Trigonometric Formulae
5.Lookup Formulae
6.Logical Formulae
7.Information Formulae
8.Financial Formulae
9.Statistical Formulae
10.Engineering Formulae
11.Database Formulae.
12.User Defined Formulae.
13.VBA Editor
14.VBA Programming Basics
15.Writing and running macros
16.Automating workbook tasks
17.Automating worksheet tasks
18.Automating daily excel tasks
19.Working with pivot table and charts.