Publisher's Synopsis
This book covers all Excel functions (2014) and macro. Excel is widely used across world. Knowing excel functions is always a step forward in one's skillsets. Major topics covered in this book are. 1.Introduction to Excel Functions 2.String Functions 3.Date and Time Functions 4.Maths and Trigonometric functions 5.Lookup Functions 6.Logical Functions 7.Information Functions 8.Financial Functions 9.Statistical Functions 10.Engineering Functions 11.Database functions. 12.User Defined Functions. 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.
