Microsoft Excel 2013: Develop and Use Complex Spreadsheets

by The Tilde Group

Topic 1 - Spreadsheet skills reviewed Topic 2 - Formulas in Excel Topic 3 - Functions in Excel Topic 4 - Using statistical functions Topic 5 - Viewing and adjusting worksheets Topic 6 - Using date & time functions Topic 7 - Using logical functions Topic 8 - Creating and editing templates Topic 9 - Using lookup functions Topic 10 - Using maths functions Topic 11 - Charting and pictures in Excel Topic 12 - Using financial functions Topic 13 - Useful text functions Topic 14 - Working with data in tables Topic 15 - Creating PivotTables and PivotCharts Topic 16 - Useful database functions Topic 17 - Importing & exporting data Topic 18 - Linking Excel data to other programs Topic 19 - Tools for summarizing data Topic 20 - Conditional formatting Topic 21 - Creating macros.

192 pages, Paperback

First published May 15, 2014