Edit product
Your Cart
    Subtotal

    Is this your street address?

    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 .

    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

      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

      Sorry, this item is not available in your location.
      Sold out, please go back and pick another option.

      You've purchased this product

      Give it a rating:

      See it in your library

      View in Library
      • Size 4.52 MB
      • Length 161 pages
      • Format PDF

      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