This book comprehensively and meticulously introduces the usage, practical applications and operating skills of formulas and functions in Excel 2016/2013/2010/2007/2003 from seven aspects: function function, function format, parameter description, precautions, Excel version reminder, case application, and cross-reference. The last three chapters also extend the application of formulas and functions to conditional formatting, data validation, and charts in order to make them more powerful. This book combines theory and practice, providing 457 cases covering multiple industries. Readers can draw inferences based on the cases in the book and directly apply them to actual work, effectively improving learning effects and practical application capabilities.
This book can be used as a function quick-check tool manual, and as a collection of rich function application cases. It is suitable for readers who need Excel formulas and functions.
Reader comments
This book is really useful! For mothers like me who have just given birth, data processing and table making are often used. This book introduces the use of Excel formulas and functions in detail from many aspects, and there are many cases for reference. I think it is not only a quick reference manual, but also a case guide. I have recommended it to my friends and everyone found it very helpful!
This book is really useful! For mothers like me who have just given birth, data processing and table making are often used. This book introduces the use of Excel formulas and functions in detail from many aspects, and there are many cases for reference. I think it is not only a quick reference manual, but also a case guide. I have recommended it to my friends and everyone found it very helpful!