Designing Professional Spreadsheet Management Systems Using Microsoft Excel 2013 & 2016

Do You Want to Learn The Simplified Guides to Learn Microsoft Office Excel Spreadsheet Management up to the Professional and Advance Level?

Then Designing Professional Spreadsheet Management Systems Using Microsoft Excel 2013 and 2016! written by Kelly Joseph is the all-in-one tutorial book to help you achieve your goals in Spreadsheet management and worksheet operations. The book shows the screen to screen pictures of each step or procedure to achieve any task in MS Excel 2013 and 2016 application.

Due to the inevitable rate of technological development, many companies now use these basic MS Office Packages like Excel for interview. Microsoft Excel relieves you of many Office stresses especially Spreadsheet Managers and those who analyze data. Most graduates miss employment opportunities due to their illiteracy in these basic Microsoft Office Packages like Microsoft Access, Excel and PowerPoint. That is why Kelly Joseph has chosen to help you out! He gives you some real life and practical exercises after each chapter to help you digest the knowledge you acquired in that chapter.

Kelly Joseph carefully wrote this book step by step to help those who had the type of zeal he had seven years ago. This book is needed by everybody both students and Spreadsheet Management Professionals because it covers the curriculum for both fields. He concentrated on the most popular Spreadsheet Management System Packages: MS Excel which is one of the three applications he knows well. Even if you don’t have a previous knowledge in Data Analysis and Spreadsheet Management, don’t panic because Kelly assumes that every user of this book has no previous knowledge of this course. This enabled him start from the scratch in other to carry everybody along!

Some of the Topics Covered in this book include:

•INTRODUCTION TO MS-EXCEL 2013 AND 2016
•THE NEW FEATURES IN EXCEL 2016
•THE MS-EXCEL USER INTERFACE
•WORKSHEET TERMINOLOGIES AND OPERATIONS
•ORDER OF PRECEDENCE
•CATEGORIES OF MS-EXCEL BUILT-IN WORKSHEET FORMULAS / FUNCTIONS
•EXCEL FUNCTION KEYS
•MS-EXCEL ERROR MESSAGES, CAUSES, SOLUTIONS AND SOME ERROR DEBUGGING FUNCTIONS
•DATABASE OPERATIONS IN MS-EXCEL
•HOW TO CREATE AND MANIPULATE A CHART IN MS EXCEL
•MANIPULATIONS ON SMARTART, DUAL-AXIS CHARTS, SHAPES AND MATHEMATICAL EQUATIONS IN MS-EXCEL
•PRACTICAL AND BUSINESS APPLICATIONS OF BUILT-IN FUNCTIONS IN MS-EXCEL
•STORE LEDGER ACCOUNT/STOCK CONTROL
•CALCULATING DEPRECIATION USING VARIOUS METHODS IN MS EXCEL
•WHAT IF ANALYSIS TOOLS AND PMT FUNCTION
•LOAN AMORTIZATION CALCULATION STEPS
•WHAT-IF ANALYSIS AND ITS TOOLS
•ADVANCED MS EXCEL - HOW TO CREATE CUSTOM EXCEL WORKBOOK TEMPLATE