Publisher's Synopsis
This book covers all Excel functions (2014) and macro. Excel is widely used across world. Knowing excel Formulae is always a step forward in one's skillsets. 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.