Designing Professional Spreadsheet Management Systems Using Microsoft Excel 2013 and 2016 PDF eBook: A simplified Guide to Learning MS Office Data Analysis with Some Practical Examples and Exercises

Designing Professional Spreadsheet Management Systems Using Microsoft Excel 2013 and 2016 ebook (pdf)! 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!

CONTENTS

CHAPTER ONE

PART 1: INTRODUCTION TO MS-EXCEL (EXCEL 2007, 2010, 2013 and 2016)

PART 2: USER INTERFACE AND WORKSHEET OPERATIONS IN MICROSOFT EXCEL

PART 3: BUSINESS APPLICATIONS OF FUNCTIONS IN MICROSOFT EXCEL AND SOLUTIONS

CHAPTER TWO

PART 1: DATABASE OPERATIONS IN MS-EXCEL (2016, 2013, 2010, 2007)

PART 2: CHARTS AND CHART OPERATIONS IN MS-EXCEL (2016, 2013, 2010, 2007)

PART 3: MANIPULATIONS ON SMARTART, DUAL-AXIS CHARTS, SHAPES AND MATHEMATICAL EQUATIONS IN MS-EXCEL

CHAPTER THREE

PART 1: PRACTICAL AND BUSINESS APPLICATIONS OF BUILT-IN FUNCTIONS IN MS-EXCEL 2016

PART 2: REGRESSION ANALYSIS - USING THE FORECAST AND TREND FUNCTIONS

PART 3: BUSINESS APPLICATIONS OF EXCEL SUMIF, COUNTIF AND CONCATENATE FUNCTIONS

PART 4: HOW TO CALCULATE YOUR CGPA USING MS-EXCEL

PART 5: LOOKUP FUNCTION AND REFERENCING DATA IN OTHER WORKSHEETS OF AN EXCEL WORKBOOK

PART 6: USING THE VLOOKUP FUNCTION TO DESIGN WORKERS PAYROLL SYSTEM IN EXCEL

CHAPTER FOUR

PART 1: HOW TO PREPARE STORE LEDGER ACCOUNT/STOCK CONTROL IN MS EXCEL – FIFO & LIFO

PART 2: HOW TO PREPARE STORE LEDGER ACCOUNT USING SIMPLE & WEIGHTED AVERAGE METHODS IN MS EXCEL

CHAPTER FIVE

PART 1: HOW TO CALCULATE DEPRECIATION CHARGES USING STRAIGHT LINE & DOUBLE DECLINE BALANCE METHODS IN EXCEL

PART 2: HOW TO CALCULATE DEPRECIATION CHARGES USING THE SYD METHOD IN MS EXCEL

CHAPTER SIX

PART 1: HOW TO CALCULATE LOAN PAYMENT USING THE PMT FUNCTION IN MS EXCEL

PART 2: LEARN WHAT-IF ANALYSIS TOOLS: SCENARIO MANAGER & DATA TABLES – STEP BY STEP GUIDE

PART 3: HOW TO USE GOAL SEEK TOOL IN MS EXCEL – WHAT IF ANALYSIS BUSINESS TOOL

CHAPTER SEVEN

PART 1: HOW TO CREATE CUSTOM EXCEL WORKSHEET & WORKBOOK TEMPLATE – STEP BY STEP GUIDE

PART 2: HOW TO INSERT DATA INTO A WORKSHEET USING EXCEL DATA ENTRY FORM – STEP BY STEP GUIDE

PART 3: HOW TO CREATE A DROPDOWN MENU LIST FOR A WORKSHEET COLUMN IN MS EXCEL – EASY GUIDE

PART 4: HOW TO SET A CUSTOM ERROR & INPUT MESSAGE FOR A WORKSHEET OR CELL IN MS EXCEL