Edit product

$0.99

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

You've purchased this product

See it in your library

View in Library
Sorry, this item is not available in your location.
Sold out, please go back and pick another option.
  • Size4.52 MB
  • Length161 pages
  • FormatPDF

Checkout

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

Enter your info to complete your purchase

Card

···· ···· ···· 4242
Test card

05/18

Card

Use a different card?

Card

pp paypal

or pay with

We do not keep any of your sensitive credit card information on file with us unless you ask us to after this purchase is complete.

or pay with

Please confirm your location:
You'll be charged US$0.99.

Your purchase was successful!

We charged your card and sent you a receipt

    Gumroad Library

    Download from the App Store or text yourself a link to the app

    Thanks for the purchase. Feel free to get back to us on our website if you find any difficulty in studying the book.

    Good news! Since you already have a Gumroad account, it's also been added to your library.

    Powered by Gumroad