Use Excel as a spreadsheet, database or graphing application. Create sophisticated calculations and formulae to recalculate automatically. The advantage of using formulas is that when data in the worksheet changes, all the formulas recalculate automatically. This feature assists you in developing budgets, forecasting models, creating sales plans, making financial projections, calculating inventories calculations, generating banking statements, and basically working with any format involving numbers. Excel can sort lists and select specific pieces of information based on specified conditions.
includes: Spreadsheet concepts = workbooks and worksheets = selecting cells = entering and editing data = calculations and formulae = shortcut techniques = moving and copying data = printing = page setup =
includes: Managing worksheets = paste special = ranges = charts = autofilter = sorting = comments = ...and more!
includes: Outlines = database tools = advanced filters = charts = linking workbooks = scenarios = macros = ...and more!
= learn lots of shortcuts and tips to help you speed up your existing knowledge of Excel