This help guide enables the beginner to get introduced to the Excel application and its usage in accounting, data analysis, etc.
It starts by explaining the interface and getting used to its functionality. It also explains how to customize the Quick Access toolbar. It deals with defining the cell ranges, and absolute and relative cell references. Shortcut keys and arithmetic, logical, conditional, text, LOOKUP functions, etc are explained in detail with their syntax.
An assignment is included to prepare a marksheet using the available marks dataset. A detailed solution file is also provided.
Simple exercises comprising 20 basic questions are also included with solutions.
No reviews yet.