Videopříručky - Vzorce v Excelu - DVD – group of authors (2011)

A video guide focused exclusively on creating formulas in MS Excel 2007/2010. The MS Excel spreadsheet calculator is a relatively powerful tool that can perform a vast number of calculations. This video guide is intended for users who already have some experience with Excel and want to deepen their knowledge. The title includes descriptions of the following functions: Parentheses, SUM, SUMIF, SUMIFS, SIN, COS, TAN, SQUARE ROOT, POWER, ABS, ROUND, PI, RANDBETWEEN, GCD, LCM, ROMAN, AVERAGE, AVERAGEIF, AVERAGEIFS, COUNTBLANK, COUNTIF, COUNTIFS, MAX, MIN, LARGE, SMALL, MODE, COUNT, COUNTA, DMAX, DMIN, DCOUNT, DCOUNTA, DAVERAGE, DSUM, DGET, CONCATENATE, CAST, LEN, SUBSTITUTE, FIND, NAMES, IF, VLOOKUP, HLOOKUP, TODAY, NOW, DATE, PAYMENT, NUMBER_OF_PERIODS. These functions have been carefully selected as the most commonly used and useful. For each function, there is a separate example in the video guide, which describes its creation from A to Z. Data - Excel spreadsheets are available for all examples, allowing you to practice the example along with the commented video. This is the most illustrative type of aid for creating formulas.