Excel Training Manual for Financial Professionals - Couverture souple

Du Plessis, Anton

 
9781539533283: Excel Training Manual for Financial Professionals

Synopsis

This is an Excel training manual to be used either for instructor led classes or as a self-study guide. The audience for this book is mainly financial professionals. It can also be used by anyone wanting to increase their current Excel skills.This book assumes you are already using Excel frequently and have a good working knowledge of using the software as a starting point . The skills trained in this course are aimed at taking your existing skills and building and expanding on it. This course is not aimed at the beginner level.The skills taught in this course are generic Excel skills and you would be able to use this course in Excel 2010, 2013 or 2016.Some of the topics covered are:

• Worksheet manipulations
• Using the IF, AND and OR functions
• VLOOKUP
• Named Ranges
• Conditional Formatting
• Formula auditing
• Pivot Tables
• Text Functions
• Data sorting
• Sub-totalling
• Auto filters
• Charts
• Data validation
• Goal seek
• Keyboard Shortcuts

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

Présentation de l'éditeur

This is an Excel training manual to be used either for instructor led classes or as a self-study guide. The audience for this book is mainly financial professionals. It can also be used by anyone wanting to increase their current Excel skills. This book assumes you are already using Excel frequently and have a good working knowledge of using the software as a starting point . The skills trained in this course are aimed at taking your existing skills and building and expanding on it. This course is not aimed at the beginner level. The skills taught in this course are generic Excel skills and you would be able to use this course in Excel 2010, 2013 or 2016. Some of the topics covered are: · Worksheet manipulations · Using the IF, AND and OR functions · VLOOKUP · Named Ranges · Conditional Formatting · Formula auditing · Pivot Tables · Text Functions · Data sorting · Sub-totalling · Auto filters · Charts · Data validation · Goal seek · Keyboard Shortcuts

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.